Day 1: Foundations of Financial Modelling & Excel Proficiency

Objective: Build a strong foundation in Excel and core modeling principles.

Session 1: Introduction to Financial Modelling

What is financial modelling?

Types of financial models (valuation, budgeting, forecasting, LBO, etc.)

Best practices and modeling standards

Session 2: Excel for Financial Modelling

Essential formulas and functions (IF, INDEX/MATCH, LOOKUPs, OFFSET)

Absolute vs. relative referencing, dynamic ranges

Data validation, conditional formatting, named ranges

Session 3: Structuring a Financial Model

Modular design: Inputs, calculations, outputs

Model audit techniques and error checks

Keyboard shortcuts and efficiency tips

Day 2: Financial Statements & Forecasting Techniques

Objective: Learn to model and project financial statements with consistency and logic.

Session 1: Linking the 3 Financial Statements

Income statement, balance sheet, and cash flow

Key drivers and interrelationships

Circular references and iteration settings

Session 2: Historical Analysis & Assumption Building

Cleaning and organizing raw financial data

Trend analysis and ratio insights

Identifying and quantifying key drivers

Session 3: Forecasting Techniques

Revenue growth models (top-down vs. bottom-up)

Cost behavior analysis (fixed vs. variable)

Working capital and capex forecasting

Day 3: Valuation Modelling (DCF & Comparable Analysis)

Objective: Apply valuation methodologies through Excel-based modeling.

Session 1: Discounted Cash Flow (DCF) Modelling

Free cash flow to firm (FCFF) vs. equity (FCFE)

WACC, terminal value, and NPV calculation

Sensitivity and scenario analysis

Session 2: Comparable Company Analysis

Selecting peers and gathering market data

Calculating EV/EBITDA, P/E, and other multiples

Using multiples to derive valuation ranges

Session 3: Precedent Transactions & Sum-of-the-Parts

Deal comps overview

SOTP and asset-based valuation approaches

Day 4: Scenario Analysis, Sensitivity & Dashboarding

Objective: Enhance model flexibility and communication of results.

Session 1: Scenario Planning and Stress Testing

Base, bull, and bear case modeling

Creating scenario switches and toggles

Analyzing business risks and mitigation strategies

Session 2: Sensitivity Analysis & Data Tables

One-variable and two-variable data tables

Tornado charts and dynamic visuals

Goal Seek and Solver applications

Session 3: Dashboarding and Model Presentation

Building executive dashboards

Visualization techniques (charts, KPIs, sparklines)

Day 5: Project-Based Financial Modelling & Final Assessment

Objective: Consolidate learning by building a complete, end-to-end model.

Session 1: Capstone Model Development

Choose a sector-specific model (e.g., retail, SaaS, manufacturing)

Integrate revenue, cost, capex, financing, and valuation modules

Peer review and troubleshooting

Session 2: Final Presentation and Review

Present models in small groups

Receive feedback on logic, clarity, and robustness

Final Q&A: Tips for live financial modelling tasks