Building 3-Statement Models in Excel
Course Summary
2 Days | Skill Builder
Starting with a basic foundation in excel skills, from shortcuts to specialized finance functions & formulae.
Employing current best practices of leading investment banks, participants build a historical integrated 3 statement model using Walmart Inc’s and Ferrari S.p.A. live data. In the process they learn model planning, data extraction, scrubbing & normalization from public sources. Full 3 statement forecasts are constructed, with optimal parameterization, incorporating detailed debt amortizing, with cash sweep, cash & short-term revolver structures to balance the statements. Detailed instructions on building cork-screw schedules, auditing, and model structural integrity tools. Flexibility is built-in by including scenario analysis & sensitivity tables.
Learning Objectives
- Confident in sourcing data, extraction, HTML, and incorporation in excel for historical model foundation. Exploring AI use in data extraction.
- Ability to build full 3 statement models, integrated with dynamic Cash & Revolver balancing. Process cork-screw schedules including multiple debt, sweep, amortisation. Understand circularity pitfalls and uses.
- Full projection construct, with multiple scenario capacity.
- Incorporate Debt Capacity models for sculpting and future derivation of cash available for debt servicing.
- Separating data, logic and output parameters, build and present dashboard for dynamic output display.
Who Should Attend
Minimum 2-3 years professional experience, with understanding of accounting and financial statements. Suitable for:
- Credit & IB analyst
- Commercial Lenders & Credit Officers
- Corporate Finance Managers
- VC & PE Investors
Learning Topics
- Excel for Financial Modelling – Essential shortcuts, dynamic referencing, and specialized finance functions and formulae.
- Model Planning & Data Preparation – Structuring model logic, extracting and normalizing financial data from public sources (including HTML and AI-based tools).
- Historical Model Construction – Building a clean, linked historical 3-statement base using real data (e.g., Walmart Inc. and Ferrari S.p.A.).
- Integration & Circularity Management – Linking P&L, Balance Sheet, and Cash Flow with circularity controls and balance checks.
- Debt & Revolver Modelling – Creating detailed debt amortization, cash sweep, and revolver structures for statement balancing.
- Scenario & Sensitivity Analysis – Designing flexible models to test multiple business cases and assumptions dynamically.
- Debt Capacity & Cash Flow Forecasting – Developing capacity models to derive available cash for debt servicing.
- Model Integrity & Audit Tools – Applying best practices to ensure model accuracy, traceability, and robustness.
- Dashboard & Presentation Design – Separating data, logic, and outputs; visualizing results through dynamic dashboards.