Financial Analysis, Modelling & Forecasting

Module 1: Strategic finance in a disruptive world

• Aligning finance with stakeholder priorities
• Navigating business model disruptions
• Risk-integrated planning frameworks
• KPIs and financial performance benchmarking

Module 2: Core concepts in financial modelling

• Overview of income statements, balance sheets, and cash flows
• Building modular, driver-based models in Excel
• Forecasting logic: assumptions, inputs, scenarios
• Leveraging Excel Dashboards and google charts in financial workflows

Module 3: Advanced financial analysis & data visualization techniques

• Building a ratio analysis database in Excel, data visualization
• Modelling Cost-Volume-Profit (CVP) and breakeven scenarios
• Analysing asset utilization and capital structure
• Gearing impacts on EPS and ROE (hands-on case model)

Module 4: Forecasting for financial planning

• Time series and regression forecasting in Excel
• Sales and cost forecasting using correlation analysis
• Avoiding common forecasting errors
• Practical: Build a multi-period cash flow forecast
• Using Solver for optimization and trend smoothing

Module 5: Modelling for investment decisions

• Capital budgeting fundamentals (NPV, IRR, Payback)
• Cost of capital and capital structure decisions
• Modelling investment projects in Excel
• Business valuation using DCF, SVA, and EVA techniques
• Projecting shareholder value across time horizons

Module 6: Risk management and scenario modelling

• Identifying and quantifying financial risk
• Sensitivity, scenario, and “what-if” planning
• Monte Carlo simulations for probability-based decisions
• Modelling the impact of key business drivers on outcomes
• Hands-on: Build a scenario-driven sensitivity dashboard

Module 7: Building integrated financial models

• Linking income statement, balance sheet, and cash flow
• Forecasting revenue and cost components
• Working capital and capex planning
• Debt and equity financing structures

Module 8: Advanced financial modelling techniques

• Real Options Analysis
• Leveraged Buyout (LBO) modelling overview
• M&A modelling fundamentals
• Financial KPI dashboards and visualization
• Auditing and stress testing models

Module 9: Practical applications and case studies

• Case Studies: Corporate budgeting, start-up financials, project finance
• Group exercises in model building
• Presenting results to stakeholders
• Model review checklist and quality assurance