Project Finance & Financial ModellingAI-enabled analysis with governance · Lesson 20 of 20

Capstone: a project finance deal from idea to operations

Article · 15 min · 8 min lecture

Video lecture

Capstone: a project finance deal from idea to operations

8 chapters · about 8 min · full transcript

Coming soon

Chapter 1 of 8

One deal, idea to operations

  • Sahara Sun Power: 150 MW solar plus storage
  • Six stages, every module connected
  • The questions a deal team must answer

The narrated lecture is in production

Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.

Chapters

Bringing it together

This capstone follows a fictional project from concept to operations, linking every module. Use it as a mental map and a revision tool.

The project

Illustrative. Sahara Sun Power (fictional) plans a 150 MW solar plant with battery storage, selling power under a 25-year PPA to a creditworthy state utility in the Gulf region. Total project cost is estimated at USD 180M.

Stage 1: feasibility and appraisal

  • Capex estimate: Class 4-style estimate from benchmarks, presented as a range.
  • Opex and lifecycle: O&M, insurance, land, battery augmentation in later years.
  • Revenue: P50 and P90 energy yields from an independent resource assessment; tariff indexed partially to USD.
  • Appraisal: project IRR and NPV at the sponsor's hurdle rate; payback as a secondary signal.
  • Decision: proceed to bid; development budget approved, recognising it is at risk.

Stage 2: structuring and bankability

  • SPV formed; sponsors: developer (60%) and a strategic partner (40%).
  • Contracts: EPC turnkey (fixed price, date, LDs), O&M agreement, PPA, land lease, grid connection agreement, direct agreements.
  • Risk allocation matrix completed; gaps found between EPC delay LDs and PPA late-COD penalties and fixed via higher LD rates and sponsor completion support.
  • Environmental and social assessment to lenders' standards.

Stage 3: modelling and debt sizing

  • Model structured with inputs, timing flags, calculations and outputs; checks sheet with master check.
  • CFADS built from P90 (lenders' case) and P50 (equity case).
  • Debt sized at the lower of DSCR sculpting (target DSCR set by lenders for contracted solar) and a gearing cap.
  • Illustrative result: debt USD 135M (75%), equity USD 45M (25%), with DSRA funded at close via a letter of credit.
  • Ratios: flat base-case DSCR at target; LLCR at start ≈ target DSCR; PLCR higher because of a PPA tail beyond debt maturity.
  • Sensitivities: delay, capex +10%, opex +10%, P99 yield, combined downside; debt service covered in all cases; equity returns reduced in combined downside.

Stage 4: due diligence and financial close

  • Technical, legal, insurance, model audit, tax and E&S reports.
  • CP checklist tracked weekly; a grid-connection agreement amendment was the longest-lead CP.
  • Interest rate swaps executed at close; tariff adjusted per bid rules for swap movements.
  • Financial close achieved; first drawdown funded equity first, then pro rata.

Stage 5: construction

  • Monthly drawdowns with independent engineer certification and funding sufficiency tests.
  • EAC tracked by cost category; contingency drawn down for a transformer delay; claims log monitored.
  • AI used to extract obligations from contracts into a compliance tracker and to draft monthly lender reports, all reviewed and signed by the finance lead.

Stage 6: operations

  • Commercial operation achieved two weeks late; delay LDs covered the lost revenue and debt service.
  • Quarterly reports: availability, output vs P50/P90, opex, DSCR, reserves.
  • Year 3: low irradiance and an inverter fault reduce DSCR close to lock-up; the team explains the variance by volume and availability, increases spares holdings and communicates early with lenders.
  • Year 5: refinancing opportunity; improved terms reduce debt cost, with refinancing gains shared per the PPA's provisions (if applicable).

Capstone review questions

  1. Why size debt on P90 but evaluate equity on P50?
  2. What would happen to debt capacity if the interest rate rose by 1% before hedging?
  3. Which contracts protect CFADS against a long construction delay?
  4. How would a lock-up event affect sponsors' cash flows and equity IRR?
  5. Which AI uses in this deal needed the highest review tier?

Model answers (short)

  1. Lenders need confidence in debt service under downside conditions; equity accepts more risk for returns.
  2. Debt capacity falls because the same maximum debt service has a lower present value at a higher rate.
  3. EPC delay LDs, sponsor completion support, delay-in-start-up insurance (if purchased) and PPA provisions.
  4. Distributions are deferred and cash trapped, lowering equity IRR even if the cash is later released.
  5. Figures in lender reports, compliance certificates and any model changes affecting the base case.

Common mistakes across deals

  • Optimistic early estimates becoming fixed budgets.
  • Gaps between contracts discovered late.
  • Models that are hard to audit.
  • CP tracking left to the last month.
  • Reporting that surprises lenders rather than informing them early.

Hands-on: the capstone sizing in a few lines of Python

import numpy as np

# Illustrative Sahara Sun Power check: sculpt on P90 CFADS, test the P50 equity case
years = np.arange(1, 19)                                  # 18-year loan
p50_cfads = np.full(18, 19.0)                             # USD M per year, illustrative
p90_cfads = p50_cfads * 0.90                              # lenders' case (from the yield report in practice)
rate, target, capex, cap = 0.065, 1.30, 180.0, 0.75

ds = p90_cfads / target
capacity = float((ds / (1 + rate) ** years).sum())
debt = min(capacity, cap * capex)
ds_actual = ds * debt / capacity
print(f"DSCR capacity {capacity:.1f}M | gearing cap {cap*capex:.1f}M | debt {debt:.1f}M ({debt/capex:.0%})")
print(f"DSCR on P90 {np.min(p90_cfads/ds_actual):.2f}x | on P50 {np.min(p50_cfads/ds_actual):.2f}x")

With these placeholder numbers the gearing cap binds at 135M (DSCR capacity is about 137M), so minimum DSCR is about 1.32x on the P90 case and about 1.47x on the P50 case. Change CFADS or the rate and watch which constraint binds: that is the stage 3 conversation in miniature.

Capstone template (one page)

StageKey decisionsKey risksEvidence you would showThe question to ask
1 Feasibility
2 Structuring
3 Modelling and sizing
4 Diligence and close
5 Construction
6 Operations

How to measure success

  • Every stage links to at least one earlier decision it depends on.
  • Your capstone states the sizing case, the binding constraint and the combined downside result.
  • You can answer the five capstone questions in one or two sentences each.

Key takeaways

  • A project finance deal flows through appraisal, structuring, modelling, due diligence, close, construction and operations.
  • Contracts, model and financing terms must align; gaps surface as risks later.
  • Debt is sized on lender downside cases; equity evaluates on base cases with sensitivities.
  • Governed AI use can speed diligence and reporting when humans verify and sign off.

Check your understanding

Quick questions to lock in the lesson. They don’t count towards your certificate.

  1. In the capstone, why were delay LD rates increased and sponsor completion support added?
  2. If interest rates rise before hedging, what happens to DSCR-based debt capacity?
  3. During operations, DSCR approaches the lock-up level. What is the best action?

Put it into practice

Write your own one-page capstone for a different asset type (e.g., a toll road or hospital PPP), covering all six stages.

Enrol for free to save your progress

Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.