Home / Case Studies / Solar & Storage Project Finance Model
CASE STUDY
InteractiveSolar & Storage Project Finance Model
A 25-year project finance model for a solar and battery plant: CFADS, sculpted debt, DSCR, LLCR and sponsor returns.
Business challenge
A renewable energy sponsor needed to size senior debt to lender coverage targets and show investors the equity return under different yield, price and cost cases.
Outcome
The sponsor knows how much debt the project can carry, where covenants bite, and what drives equity returns before going to lenders.
Overview
A 25-year project finance model for a solar and battery plant: CFADS, sculpted debt, DSCR, LLCR and sponsor returns. Inside: construction draw curve and capitalised interest; CFADS and debt sculpting; DSCR, LLCR, PLCR and lock-up; debt-service reserve account; refinancing and equity returns; live sensitivity data tables. How to use this model: on the Dashboard sheet, use the drop-down in cell D7 to pick the scenario: Base, Upside or Downside. The grids on the Sensitivity sheet are live Excel data tables that recalculate the whole model for each cell.
Approach
Capacity, availability, curtailment and pricing drive monthly generation and revenue. Construction costs and draws set funding; CFADS sizes sculpted debt to a target DSCR with a reserve account and lock-up tests. Statements, refinancing and returns follow, with live sensitivity grids.
Capabilities
Skills
LET'S WORK TOGETHER
Need something like this for your business?
Tell me what you are trying to solve. I’ll respond with a practical view of how I can help.