Module #1 Introduction to Advanced Financial Modeling Overview of the course, importance of advanced financial modeling, and setting up a project plan
Module #2 Review of Financial Statements and Accounting Principles Review of income statement, balance sheet, and cash flow statement, and accounting principles relevant to financial modeling
Module #3 Excel Skills for Advanced Financial Modeling Advanced Excel skills required for financial modeling, including shortcuts, formulas, and functions
Module #4 Building a Robust Financial Model Structure Best practices for building a robust financial model structure, including layout, formatting, and organization
Module #5 Forecasting Revenue and Expenses Techniques for forecasting revenue and expenses, including regression analysis and growth rate assumptions
Module #6 Building a Three-Statement Model Building a integrated three-statement model, including income statement, balance sheet, and cash flow statement
Module #7 Working Capital and Capital Expenditure Forecasting Forecasting working capital and capital expenditures, including accounts receivable, accounts payable, and inventory
Module #8 Debt and Equity Modeling Modeling debt and equity, including debt repayment schedules and equity issuance
Module #9 Free Cash Flow and Enterprise Value Modeling Modeling free cash flow and enterprise value, including EBITDA and EV/EBITDA calculations
Module #10 Sensitivity Analysis and Scenario Planning Conducting sensitivity analysis and scenario planning to test the robustness of the financial model
Module #11 Data Validation and Error Checking Best practices for data validation and error checking in financial models
Module #12 Dashboards and Reporting Building dashboards and reports to communicate financial model results to stakeholders
Module #13 Merger and Acquisition Modeling Modeling mergers and acquisitions, including accretion/dilution analysis and purchase price allocation
Module #14 LBO Modeling Modeling leveraged buyouts, including debt financing and exit multiples
Module #15 DCF Modeling and Terminal Value Calculation Calculating terminal value and conducting discounted cash flow analysis
Module #16 Modeling Real Options and Exotic Derivatives Modeling real options and exotic derivatives, including binomial trees and Monte Carlo simulations
Module #17 Risk Analysis and Monte Carlo Simulation Conducting risk analysis and Monte Carlo simulations to quantify uncertainty in financial models
Module #18 Advanced Financial Modeling in Real-World Scenarios Applying advanced financial modeling techniques to real-world scenarios, including case studies and group exercises
Module #19 Financial Modeling for Renewable Energy and Project Finance Modeling renewable energy projects and project finance transactions
Module #20 Financial Modeling for Real Estate and Property Development Modeling real estate and property development projects, including cash flow waterfalls and sensitivity analysis
Module #21 Advanced Financial Modeling Tools and Software Using advanced financial modeling tools and software, including VBA macros and financial modeling apps
Module #22 Advanced Excel Functions for Financial Modeling Using advanced Excel functions, including XNPV, XIRR, and AGGREGATE functions
Module #23 Financial Modeling Best Practices and Audit Techniques Best practices for financial modeling and audit techniques to ensure model integrity
Module #24 Presenting Financial Models to Stakeholders Presenting financial models to stakeholders, including communication strategies and visualization techniques
Module #25 Course Wrap-Up & Conclusion Planning next steps in Advanced Financial Modeling career