Project Finance Modelling

Structuring Project SPV Models

• Model phased construction and operations with clear timelines.
• Build revenue, O&M, reserve, and covenant schedules.
• Incorporate tax, depreciation, and funding constraints accurately.
• Create base, lender, and equity cases for decision review.

Debt, Equity, and Covenant Mechanics

• Size and sculpt debt with refinancing and cash sweep features.
• Calculate DSCR, LLCR, and project IRR under multiple scenarios.
• Model lock‑ups, distribution tests, and covenants robustly.
• Evidence lender compliance with transparent audit checks.

Excel Best Practices for Financial Modelling

• Structure models with separate inputs, calculations, and outputs to improve auditability.
• Use consistent naming conventions, dynamic ranges, and version control to reduce errors.
• Implement checksums and reconciliation flags to validate calculations end‑to‑end.
• Document assumptions, sources, and logic to support review, handover, and maintenance.

Ensuring Data Integrity and Model Accuracy

• Design robust data import and transformation steps with traceable lineage.
• Apply validation tests (type, range, and logic checks) to catch anomalies early.
• Minimise hard‑coding; build driver‑based links that prevent circularity and drift.
• Create error‑handling and exception logs that surface issues for timely fixes.

Communicating Financial Insights Effectively

• Translate model outputs into clear narratives that answer the ‘so what?’.
• Use charts, bridges, and scenarios to highlight drivers, risks, and options.
• Present concise recommendations with quantified impacts and sensitivities.
• Package model files and executive packs for efficient decision meetings.