Define transaction purpose (acquisition, greenfield, refinance), time horizon, KPIs and required outputs. Collect historical financials, contract terms, capex plans, procurement schedules, market data and tax/regulatory inputs to seed the model.

Design model structure (P&L, balance, cashflow, capex, working capital, debt schedule). Set driver logic for revenues, costs and margins, and record all assumptions in a dedicated assumptions tab for auditability and review.

Construct integrated schedules: revenue build-up, cost curves, capex phasing, depreciation, working-capital timing and debt amortisation. Link to sensitivity toggles and scenario switches for quick re-forecasting and stakeholder walkthroughs.

Reconcile to audited accounts, perform reasonability checks, run sensitivity and downside scenarios, covenant and liquidity tests, and (where relevant) Monte Carlo or stress simulations. Produce a validation log and analyst notes for transparency.

Deliver investor-ready outputs: executive summary, KPI dashboard, valuation (DCF, IRR), funding plan and recommended actions (go/no-go, structure, mitigations). Provide the model file, a one-page assumptions memorandum and a short handover/training session.