1. Why do you need this training?
Financial models are needed in budget planning, obtaining creditor financing, finding investors, risk management, valuation, etc.
This program will help you able to develop a financial model with Excel and provides a practical understanding of finance and accounting concepts. This training is suitable for participants from any background and can be included in the Company’s ODP program.
This training is very applicable where the topics, sectors covered, and the number of days of implementation can be adjusted according to the needs. Participants will be guided to develop a financial model according to their needs, where 50% – 60% of the schedule is practiced with Excel.
The output of this training is a model template according to business fields and projects that can be used immediately. This training has been held in various companies from different industries so that the method is tested.
This training curriculum is based on the global curriculum of the Professional Financial Modeler (PFM) certification program.
2. Outline Pelatihan
- Modeling design
- Modeling assumptions, Balance Sheet, and Income Statement
- Balancing direct and indirect methods
- Corporate financial model
- Adaptation according to company conditions
- Project finance model
- Determination of the feasibility of a new project
- Methods of quantitative evaluation of ongoing projects
- Cooperation project models such as BOT, BOO, and so on
- Analysis of the ability of funds to borrow
- Scenario analysis and sensitivity
3. Other topics to choose from
- Qualitative business analysis for company strategy
- Consolidated equity valuation
- Consolidation of subsidiaries using four methods
- Before and after merger
- Risk Valuation
4. Training Schedule
Example of a five-day training schedule
|Day/Session||Topic & Discussion|
|Session 1||Overview of Financial Model Formats, Understanding Profit and Loss Statements, and Balance Sheets Used in Financial Models|
|Session 2||Balancing with Direct and Indirect Methods|
|Session 3||Understanding Assumptions for Corporate Financial Models|
|Session 4||Studying Financial Projection Formats, Case Study of Financial Projection Preparation|
|Session 5||Case Study: Developing a Corporate Financial Model (1)|
|Session 6||Case Study: Developing a Corporate Financial Model (2)|
|Session 7||Adaptation to Company Conditions and Sector|
|Session 8||Financial Model of New Project Budget|
|Session 9||Case Study: Project Model on New Project|
|Session 10||Feasibility Model of Projects in Operation|
|Session 11||Case Study: Feasibility of an Operational Project|
|Session 12||Methods of Consolidating Subsidiaries|
|Session 13||Case Study: Consolidation of Subsidiaries to Parent|
|Session 14||Analysis of Joint Operation Scheme|
|Session 15||Case Study: Operational Cooperation Analysis|
|Session 16||Application Case Study: Preparing Company Budget (1)|
|Session 17||Application Case Study: Preparing Company Budget (2)|
|Session 18||Financial Ratio Analysis|
|Session 19||Sensitivity and Risk Analysis|