Description
Module 1: Fundamentals of Financial Modeling
– Introduction to financial modeling concepts.
– Importance of financial models in decision-making.
– Building blocks of financial models.
Module 2: Excel for Financial Modeling
– Excel functions and tools for financial modeling.
– Data input, formula writing, and error handling.
– Formatting and visualization in financial models.
Module 3: Building Financial Statements Models
– Creating income statements, balance sheets, and cash flow statements.
– Linking financial statements and building dynamic models.
– Forecasting financial statements.
Module 4: Valuation Modeling
– Valuation modeling techniques.
– Discounted cash flow (DCF) analysis.
– Sensitivity analysis and scenario modeling.
Module 5: M&A and LBO Modeling
– Modeling mergers and acquisitions (M&A) transactions.
– Leveraged buyout (LBO) modeling.
– Building pro forma financial models for M&A.
Module 6: Advanced Financial Modeling
– Advanced modeling techniques and applications.
– Complex financial models and dynamic scenarios.
– Risk modeling and Monte Carlo simulation.
