Training course on Financial Modeling and Valuation

Module 1: Introduction to Financial Modeling and Valuation

Purpose and applications of financial models

Best practices in model design and structure

Overview of valuation methodologies

Module 2: Excel for Financial Modeling

Essential Excel functions for modeling (INDEX, MATCH, OFFSET, NPV, IRR, etc.)

Data validation, scenario tools, and error checks

Building dynamic and flexible spreadsheets

Module 3: Financial Statement Analysis

Linking the balance sheet, income statement, and cash flow statement

Key financial ratios and performance metrics

Adjusting historical data for analysis

Module 4: Forecasting Financial Statements

Revenue and expense drivers

Working capital and capital expenditure forecasting

Building pro forma financial statements

Module 5: Cost of Capital and Capital Structure

Calculating WACC (Weighted Average Cost of Capital)

Impact of leverage on value

Estimating cost of equity and cost of debt

Module 6: Discounted Cash Flow (DCF) Valuation

Free cash flow to firm vs free cash flow to equity

Terminal value estimation (Gordon growth and exit multiple methods)

Sensitivity analysis in DCF models

Module 7: Relative Valuation Techniques

Trading comparables (P/E, EV/EBITDA, P/B ratios)

Precedent transactions analysis

Adjusting for industry and market differences

Module 8: Valuation in Special Contexts

Valuing startups and high-growth companies

Distressed company valuation

Real options in valuation

Module 9: Scenario and Sensitivity Analysis

Building scenarios for different economic conditions

Sensitivity tables and tornado charts

Monte Carlo simulations for valuation uncertainty

Module 10: Mergers, Acquisitions, and LBO Modeling

Synergies and accretion/dilution analysis

Leveraged buyout (LBO) model structure

Case study: acquisition valuation

Module 11: Communicating Valuation Results

Structuring valuation reports and investment memos

Visualization techniques for financial models

Presenting results to executives and investors

Module 12: Capstone Project and Hands-On Workshop

Building a full financial model from scratch

Performing valuation of a real or simulated company

Presenting findings and receiving peer/instructor feedback