This is a hands-on training, meaning that there will be no presentation slides. The participant will actively work together with the trainer to build the corporate model using their own laptop.
Things you will bring to your job after attending this training class:
First session before lunch:
The participant will be worked through as to how to make models be more user-friendly and structured, by showing the original and the finished model, by adding and/or learning about:
- Formats, number formats, lines and borders, colour and patterns, specific colour for inputs and results;
- Data validation to control inputs;
- Adding controls from Developer using Combo boxes and buttons;
- Conditional formatting to illustrate changes in data
- Use of functions and types of functions;
- Dynamic graphs to plot individual lines;
- Data tables for sensitivity anlaysis;
- Using index-scenario for sensitivity analysis;
- Understanding Net Present Value (NPV and XNPV functions).
Second session after lunch:
The participant will be allowed to see the general structure and design of a corporate model. The essential element of corporate modelling is presentation of history alongside the forecast, smooth transition from history to forecast and development of alternative structures for the assumptions. This exercise will work the participant through and/or learning about:
- How to build a basic integrated corporate model
- Using cash flow waterfall analysis and cash flow plug to balance the balance sheet in a quick way
- Corporate model with depreciation
- Incorporating minimum cash balance
- Modeling working capital
- EBITDA and Cash Flow Available for Debt Service (CFADS)
- Modeling target capital structure
Speaker: Sukarnaen Suwanto
Certified Valuation
Analyst of IACVA.org
Trainier in corporate finance & valuation topics
Investment:
2,900 K
discount 10% for 3 persons or more
Bank Permata
Branch Prudential Tower
Bank Account: 701642031
a.n PT BDO Insan Dinamis Indonesia
Contact Person
Reini
0812 – 8760 – 8686
[email protected]