Integrated 3-Statement Financial Model & DCF Valuation

Developed a comprehensive, Excel-based financial modelling case study for a fictional UK manufacturing company, demonstrating integrated FP&A, financial forecasting, operational planning and business valuation.

The model combines three years of historical financial data (2023–2025) with a five-year forecast (2026–2030), linking operational assumptions directly to financial performance, cash flow and enterprise valuation.

Integrated Three-Statement Model: Fully linked Income Statement, Balance Sheet and Cash Flow Statement.

Revenue Forecasting: Volume and selling-price assumptions across three manufacturing business segments.

Manufacturing Capacity Planning: Production capacity, utilisation, expansion investment and unfulfilled customer demand.

Cost & Profitability Forecasting: Direct materials, labour, manufacturing overheads, operating expenses and EBITDA margins.

Working Capital Modelling: Receivables, inventory and payables driven by operating-day assumptions.

Capital Expenditure & Debt Schedules: Forecast investment, depreciation, borrowings, repayments and interest expense.

Scenario Analysis: Base, Upside and Downside cases with dynamically linked financial outputs.

DCF Valuation: Unlevered free cash flow forecasting, WACC, terminal value and enterprise-to-equity valuation.

Executive Dashboard: Interactive financial KPIs, profitability trends, segment performance and manufacturing capacity utilisation.

Model Integrity Checks: Reconciliation controls across the financial statements and supporting schedules.

Tools: Microsoft Excel | Financial Modelling | FP&A | DCF Valuation | Scenario Analysis