Duration: 2 Days.
Having a well developed financial model will allow any companies to perform better in their market and business environment. It means they can have better strategic planning, detailed valuation analysis, multi-year budget perspective, or better management of their budget facilities as well as CAPEX programs.
The skill in Financial Modeling will empower any finance professionals in advancing their career through specialized knowledge solutions and better productivity in their roles.
In this practical workshop, participants will exercise in building a multi-year, dynamic financial model for a real, public company. They will use the common spreadsheet program and discuss real world cases in building a comprehensive financial model.
This two-day program will help the participants how to:
-
Understand the essence of financial modeling
-
Exercise building a financial model
-
Use techniques in building a financial model fits to their company needs
-
Use excel spreadsheet for financial modeling
-
Connecting and balancing the financial model
-
Make meaning analysis of the financial models
Training Outline
1. Introduction
- The definition and applications of financial modeling in practical world
2. Getting Started in Financial Modelling
- Good practices in financial modelling
- Financial modelling layout, formatting and design
- Reviewing the fundamentals of financial statements and the relationships between financial statements
- Excel best practices & commonly used functions
- Useful techniques & Excel shortcuts
- Creating powerful graphs and charts Historical financial of key trends and drivers. Historical data manipulation
- Importance of the analysis of historical financial statements
- Analysis of historical Income Statement and Balance Sheet
- Identification of key trends and drivers and historical data manipulation
4. Making Financial Model – Modeling Income Statement
- Analysis of the historical income statement, macroeconomic environment and market trends
- Identification of relevant trends and model drivers
- Analysis of the cost items and structure
- Making projections of the Income Statement items
- Income tax expense forecasting
5. Modeling Balance Sheet
- Organization and structure of the Balance Sheet
- Approach to Balance Sheet forecasting
- Overview of different supporting schedules used in the model Shareholders’ Equity forecasting
- Forecasting dividends
- Working Capital Schedule
- CAPEX and amortization schedule
- Debt Schedule
- Cash flows from operating, investing and financing activities
- Integrating the Statement of Cash Flows into the model
- Connecting the projected financial statements and supporting schedules
- Balancing the balance sheet – common errors and useful checks
- Dealing with circular references and making the model robust
- Checking the model and managing model output
- Building the scenario manager
- Running scenarios under different operating assumptions
- Analyzing model outputs under different scenarios
- Running sensitivity analysis using data tables
Recommended Participants
Analysts, Investment Banking, Private Equity Analysts & Associates, Commercial Bankers, Controllers, Finance Managers & Directors , Business Development Professionals,
MBA and Business/Commerce Students
Contact Our Team
Marketing Office
One Pacific Place 15th Floor
Sudirman Central Business District
Jl. Jend. Sudirman Kav. 52-53
Jakarta 12190