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
  • Restructuration
  • Before and after merger
  • Risk Valuation
  • Etc

4. Training Schedule

Example of a five-day training schedule

Day/Session Topic & Discussion
Day 1
Session 1Overview of Financial Model Formats, Understanding Profit and Loss Statements, and Balance Sheets Used in Financial Models
Session 2Balancing with Direct and Indirect Methods
Session 3Understanding Assumptions for Corporate Financial Models
Session 4Studying Financial Projection Formats, Case Study of Financial Projection Preparation
Day 2
Session 5Case Study: Developing a Corporate Financial Model (1)
Session 6 Case Study: Developing a Corporate Financial Model (2)
Session 7Adaptation to Company Conditions and Sector
Day 3
Session 8Financial Model of New Project Budget
Session 9Case Study: Project Model on New Project
Session 10Feasibility Model of Projects in Operation
Session 11Case Study: Feasibility of an Operational Project
Day 4
Session 12Methods of Consolidating Subsidiaries
Session 13Case Study: Consolidation of Subsidiaries to Parent
Session 14Analysis of Joint Operation Scheme
Session 15Case Study: Operational Cooperation Analysis
Day 5
Session 16Application Case Study: Preparing Company Budget (1)
Session 17Application Case Study: Preparing Company Budget (2)
Session 18Financial Ratio Analysis
Session 19Sensitivity and Risk Analysis
*) Schedule is tentative, topic and number of days can be adjusted according to audience Class in Indonesian or English