Workshop agenda
Practical case study
Participants take active part in a workshop and are guided by a tutor in performing all calculations.
- Setting-up cash flow-based model step-by-step
- Focus on depreciation methods
- Income and costs modeling
- Cash-flow analysis
- Balance sheet analysis
- Working capital analysis
- Profitability analysis, performance ratios (NPV, IRR, MIRR, Payback, RONA, EVA)
- Sensitivity analysis
- Finding break-even
- Investments comparison techniques
- Investments consolidation techniques
- Difference investment – margin calculation
- Creating investment proposal
- Financing
Detailed description
The aim of this workshop is to give you a basic knowledge on how to create a cash flow-based model for investment feasibility studies using Invest for Excel® software. The participants will actively take part in all calculations. You will be introduced to all steps of investment calculation and profitability analysis. You will see the best framework for organizing your calculation and you will get basic understanding on how various investment elements affect the profitability ratios, profit and loss account, cash flow statement, working capital and balance sheet. You will learn interpreting the profitability reports and perform sensitivity analysis. You will also learn to recognize which parameters of your investment are the most sensitive and involve the most risk. During the training the techniques how to compare or consolidate various investment projects will be covered. We will also give a focus on how to create a ‘’difference margin’’ calculation. Difference margin analysis answers the question whether it is better to keep a status quo scenario or to change it. The performance ratios refer to just the difference between status quo and changed scenario. You will also be introduced to the financing module, where you can define the financing scheme for your investment. Finally, we will show you the best templates for creating the investment proposal, which can be used in your company or externally when you need to motivate your investment in a professional way.
In summary, you will learn how to create investment cash-flow based models and how to analyze them using the best frameworks of Invest for Excel® software in a practical way.
The training is focused on conducting real investment case studies. All participants actively take part in workshop and make all calculations individually, guided by a tutor.
Each participant receives certificate of completion of the workshop on building cash flow models for investment feasibility studies.
Prerequisites
- Basic knowledge of Excel.
Results of the workshop
- you quickly become familiar with basic concepts and terminology used in cash flow modeling
- you will know all performance indicators and how to analyze them
- you know how to create an investment calculation in Invest for Excel®
- you know how to use the basic features of Invest for Excel®
- you are able to perform capital investment analysis independently
- you have know-how to assess the best investment alternative and take a right decision
- you know how to create a professional investment proposal.
Duration
- 1 day
Price
Workshop per 1 day: 500 EUR
Workshop package per 2 consecutive days: 850 EUR
Minimum number of attendees per workshop: 4
Prices do not include VAT.
The workshops are free for customers with 20% maintenance agreement.
How to register?
You can register by:
E-mail: datapartner@datapartner.fi
Phone: +358 19 54 10 100
Fax: +358 19 54 10 111
