Inhouse Online Training Intermediate Financial Modeling
PT Mitsubishi Corporation Jakarta Representative Office
Zoom Arcarta Consultant | Tanggal 27 Februari 2025
INVESTASI IN HOUSE ONLINE TRAINING
1 Day
Rp 15.000.000 – Rp 20.000.000
2 Days
Rp 20.000.000 – Rp 25.000.000
INVESTASI TERMASUK :
- Soft Copy Modul Training (Email)
- Sertifikat Kehadiran (Ekspedisi)
- Qualified Instructor
WAKTU PELAKSANAAN TRAINING
Depend on request
OVERVIEW
The Intermediate Level – Financial Modeling course builds upon fundamental financial modeling concepts by introducing more advanced techniques for financial analysis and decision-making. It begins with an overview of intermediate financial modeling, distinguishing it from the basic level and emphasizing the need for more complex models in business forecasting and valuation.
Participants will explore advanced projection techniques, including sales growth projections, expense forecasting using indexation, and working capital adjustments to enhance financial model accuracy. The course also covers sensitivity analysis, teaching how to conduct “what-if” scenarios and utilize data tables to assess the impact of different assumptions on financial outcomes.
A key component of the training is company valuation, where participants will learn the Discounted Cash Flow (DCF) method, determine the Weighted Average Cost of Capital (WACC), and project cash flows for valuation purposes. Finally, the course introduces dynamic reporting, focusing on creating interactive dashboards and using pivot tables and charts to visualize and analyze financial data effectively. By the end of the program, participants will be equipped with the skills necessary to build robust, data-driven financial models for strategic decision-making.
Intermediate Level (4 Hours)
- Introduction to Intermediate Financial Modeling
- Differences Between Basic and Intermediate Levels
- Goals of More Complex Models
Advanced Projection Techniques
- Sales Growth Projections
- Expense Projections Using Indexation
- Adjusting Working Capital
Sensitivity Analysis
- Introduction to Sensitivity Analysis
- Creating “What-If” Scenarios
- Using Data Tables for Analysis
Company Valuation
- Discounted Cash Flow (DCF) Method
- Determining Weighted Average Cost of Capital (WACC)
- Projecting Cash Flows for DCF
Introduction to Dynamic Reporting
- Creating Interactive Dashboards
- Using Pivot Tables and Charts
Intermediate Level – Financial Modeling
Introduction to Intermediate Financial Modeling
- Differences Between Basic and Intermediate Levels
- Goals of More Complex Models
Advanced Projection Techniques
- Sales Growth Projections
- Expense Projections Using Indexation
- Adjusting Working Capital
Sensitivity Analysis
- Introduction to Sensitivity Analysis
- Creating “What-If” Scenarios
- Using Data Tables for Analysis
Company Valuation
- Discounted Cash Flow (DCF) Method
- Determining Weighted Average Cost of Capital (WACC)
- Projecting Cash Flows for DCF
Introduction to Dynamic Reporting
- Creating Interactive Dashboards
- Using Pivot Tables and Charts
TRAINER & FACILITATOR :
Tim Trainer Arcarta Consultant
INFORMASI
Registrasi, hubungi :
Arcarta Consultant
TELEPON :
+6221-889-68569
HP/ WA :
+62-812-2483-2565 (Citra)
Email:
info_training@arcartaconsultant.com;
info.arcartaconsultant@gmail.com
