Project Finance & Financial ModellingAI-enabled analysis with governance · Lesson 20 of 20
Capstone: a project finance deal from idea to operations
Video lecture
Capstone: a project finance deal from idea to operations
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
Transcript of the narration, chapter by chapter.
0:00 One deal, idea to operations
Everything in this course has been building to one idea: a project finance deal is a single story, told in stages, where each decision constrains the next. The estimate you accept in feasibility becomes the budget lenders fund. The risk you leave unallocated in structuring becomes a gap the model has to carry. The CFADS case you size on decides whether you lock up in year three. In this capstone lecture, we'll follow a fictional deal, Sahara Sun Power, a one hundred and fifty megawatt solar plant with battery storage, from concept to operations. At each stage, I'll connect it back to what you've learned and pose the question a good deal team would ask. By the end, you'll have a mental map of the whole lifecycle and a template for your own capstone.
0:58 Stage 1: feasibility and appraisal
Stage one, feasibility. Sahara Sun Power plans to sell power under a twenty-five-year PPA to a creditworthy state utility in the Gulf, with a total project cost estimated at one hundred and eighty million dollars, illustratively. The capex estimate comes from benchmarks, so it's early-stage and presented as a range, not a point. Opex and lifecycle costs include O and M, insurance, land and battery augmentation in later years. Revenue uses P50 and P90 energy yields from an independent resource assessment, and the tariff is partly indexed to the dollar. The team appraises project IRR and NPV at the sponsor's hurdle rate, with payback as a secondary signal, and decides to proceed to bid, approving a development budget that everyone knows is at risk until close. The question here: are we presenting the estimate honestly enough that it doesn't become a fixed budget by accident?
2:01 Stage 2: structuring and bankability
Stage two, structuring. The SPV is formed with a developer holding sixty per cent and a strategic partner forty. The contracts: an EPC turnkey contract with a fixed price, a fixed date and liquidated damages; an O and M agreement; the PPA; a land lease; a grid connection agreement; and direct agreements for lenders. The team completes a risk allocation matrix and finds exactly the gap we've discussed several times: EPC delay damages didn't cover the PPA's late-COD penalties plus debt service during a delay. They fix it with higher delay damage rates and sponsor completion support. An environmental and social assessment is carried out to lenders' standards. The question here: if construction ran six months late, who would pay for each day, and is anything left with the SPV that it can't bear?
2:59 Stage 3: modelling and debt sizing
Stage three, modelling. The model follows the principles you've learned: separate inputs, a timing sheet with flags, clean calculation blocks, outputs, and a checks sheet with a master check. CFADS is built on P90 for the lenders' case and P50 for the equity case. Debt is sized at the lower of DSCR sculpting, with a target set by lenders for contracted solar, and a gearing cap. The illustrative result: debt of one hundred and thirty-five million, seventy-five per cent, equity of forty-five million, and the DSRA funded at close with a letter of credit. In the base case DSCR is flat at target, LLCR at the start roughly equals the target, and PLCR is higher thanks to a PPA tail beyond debt maturity. Sensitivities cover delay, capex and opex overruns, a P99 yield and a combined downside: debt service is covered in every case, but equity returns are thin in the combined downside. The question: why size on P90 but evaluate equity on P50?
4:10 Stage 4: due diligence and financial close
Stage four, diligence and close. Technical, legal, insurance, model audit, tax and environmental and social reports all feed the lenders' base case. The CP checklist is tracked weekly, and the longest-lead item turns out to be an amendment to the grid connection agreement, exactly the kind of third-party dependency that slips closes. Interest rate swaps are executed at close, and the tariff is adjusted according to the bid rules for swap movements. Financial close is achieved, and the first drawdown follows the agreed order: equity first, then pro rata with debt. The question: what would happen to debt capacity if interest rates had risen by one per cent before the swaps were executed? And which CPs would you have escalated six months earlier?
5:03 Stages 5 and 6: construction and operations
Stage five, construction. Monthly drawdowns come with independent engineer certification and funding sufficiency tests. Estimate at completion is tracked by cost category. Contingency is drawn down for a transformer delay, and the claims log is monitored. AI is used to extract obligations from the contracts into a compliance tracker and to draft monthly lender reports, all reviewed and signed by the finance lead. Commercial operation arrives two weeks late, and the delay damages cover lost revenue and debt service, just as the stage two fix intended. Stage six, operations. Quarterly reports cover availability, output against P50 and P90, opex, DSCR and reserves. In year three, low irradiance and an inverter fault push DSCR close to lock-up. The team explains the variance by volume and availability, increases spares holdings, and talks to lenders early. By year five, a refinancing opportunity arises, with any gains shared according to the contract's provisions.
6:08 Watch me do it: answering the capstone questions
Let me work through the capstone questions the way I'd want you to answer them in an interview or an exam. Why size debt on P90 but evaluate equity on P50? Because lenders need confidence in debt service under downside conditions, while equity accepts more risk in return for higher expected returns. What if interest rates rose one per cent before hedging? Debt capacity falls, because the same maximum debt service has a lower present value at a higher rate. Which contracts protect CFADS in a long construction delay? EPC delay damages, sponsor completion support, delay-in-start-up insurance if purchased, and the PPA's own provisions. How would a lock-up affect sponsors? Distributions are deferred and cash trapped, lowering equity IRR even if the cash is later released. And which AI uses needed the highest tier? Figures in lender reports, compliance certificates and any model change affecting the base case.
7:12 Common mistakes, recap and try this now
The mistakes that recur 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, and reporting that surprises lenders rather than informing them early. So, to recap the whole journey. Feasibility sets honest ranges. Structuring allocates risk so contracts fit together. Modelling turns contracts into CFADS and debt capacity, tested with sensitivities. Diligence and close convert agreement into funding. Construction protects the budget with controls and evidence. And operations keep lenders informed with early, honest reporting. Your try-this-now: write your own one-page capstone for a different asset type, perhaps a toll road or a hospital PPP, covering all six stages and the key question a deal team should ask at each.
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
- Why size debt on P90 but evaluate equity on P50?
- What would happen to debt capacity if the interest rate rose by 1% before hedging?
- Which contracts protect CFADS against a long construction delay?
- How would a lock-up event affect sponsors' cash flows and equity IRR?
- Which AI uses in this deal needed the highest review tier?
Model answers (short)
- Lenders need confidence in debt service under downside conditions; equity accepts more risk for returns.
- Debt capacity falls because the same maximum debt service has a lower present value at a higher rate.
- EPC delay LDs, sponsor completion support, delay-in-start-up insurance (if purchased) and PPA provisions.
- Distributions are deferred and cash trapped, lowering equity IRR even if the cash is later released.
- 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)
| Stage | Key decisions | Key risks | Evidence you would show | The 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.
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.