
Financial Modeling
A two-day, hands-on program that turns Excel into a decision-grade financial modeling platform — build robust DCFs, dynamic forecasts, and scenario-proof models used for valuation, planning and investment decisions.
Course Overview
This practical program teaches you how to build clean, auditable and business-focused financial models that senior stakeholders trust.
Over two days you’ll construct an end-to-end model: revenue and cost drivers, working capital, capex, debt schedules, cash flow waterfalls and DCF valuation.
We focus on model design, documentation, error-proofing, sensitivity and scenario analysis, and model governance so your models survive scrutiny.
Real-world case studies and Excel labs ensure you leave with templates, shortcuts and reporting outputs you can apply immediately to planning, M&A, project appraisal and board reporting.
Course Curriculum
Module 1: Model Design & Best Practices
Workbook architecture, assumption tabs, flow, naming conventions and version control
Module 2: Revenue, Cost & Operating Model Build
Driver-based forecasting, margin mechanics and operating leverage
Module 3: Working Capital, CAPEX & Depreciation
NOWC mechanics, capex phasing, tax timing and cash flow conversion
Module 4: Debt Schedules & Interest Mechanics
Loan amortization, covenants, cash sweep and levered cash flow
Module 5: DCF Valuation & Terminal Value
Free cash flow, discount rate selection, WACC issues and terminal calculation
Module 6: Reporting & Dashboards
Clean outputs for board packs, KPI dashboards and narrative slides
Who Should Attend
- Financial modeler or valuation analyst in corporate finance and advisory
- M&A and transaction support specialist
- FP&A and planning lead with strong modeling credibility
- Treasury or project finance modeler for investment and debt structuring
Learning Outcomes
Participants will leave able to build, test and present professional financial models that support investment, planning and transaction decisions; they will produce board-ready outputs, stress test assumptions and implement governance practices that reduce error and improve stakeholder confidence.
Career Opportunities
- Professional Excel modeling: structured workbooks, named ranges and dynamic formulas
- DCF valuation, terminal value selection and sensitivity analysis
- Integrated cash flow forecasting and debt schedule construction
- Scenario design, data tables and basic Monte Carlo interpretation
- Model auditing, error checks and documentation for governance

