Three single-asset project finance models for the three technologies that make up most renewable pipelines today: solar PV, onshore wind and battery energy storage. They are built to the same pattern, so an analyst who learns one has learned all three, and a portfolio of mixed assets can be compared on one basis rather than three spreadsheets with three conventions.
Each model runs from a single Inputs sheet into Operations, Debt and Returns. Debt is sculpted to a target DSCR with a gearing cap, the repayment schedule runs in full, and the model reports project IRR, equity IRR and DSCR by period. Revenue is contracted first and merchant afterwards, with escalation on the contract and inflation on the merchant price. Operating costs escalate. Tax uses straight-line depreciation over a period you set. Three scenario multipliers (price, capex, resource) move the whole case at once.
What differs is what actually differs between the technologies. Solar carries degradation and availability over thirty operating years against a PPA and then merchant pricing. Wind carries two energy cases, because lenders do not size debt on expected yield: P50 drives the equity view, P90 is the one-year exceedance case debt is sized on, and both are reported. Battery storage carries a revenue stack that switches from a tolling fee per MW-year to merchant arbitrage income, plus capacity fade and an augmentation in a year you choose, at a cost per MWh restored.
All three are Excel workbooks with live formulas and no macros. Nothing is hard-coded into a result cell, so every figure can be traced back through the sheet to the input that produced it. Each workbook includes a Guide sheet explaining the conventions used and where each assumption belongs.
Use the set if you appraise, lend to or invest in renewable assets and want the sizing arithmetic to be the same across the pipeline. It is not a portfolio consolidation tool and not a substitute for a lender's own model audit.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form.
Source: Renewable Energy Project Finance: Solar, Wind, BESS () Document, Bindler
THERE ARE 3 PRODUCTS IN THIS BUNDLE:
|
|
A single-asset solar PV project finance model built the way lenders and sponsors expect, with nothing hidden: 30 operating years, PPA revenue with escalation followed by... [read more]
Individual Price: $49.00
|
|
|
A single-asset onshore wind project finance model built the way lenders and sponsors expect, with the one thing solar models do not need: two energy cases. P50 is the expected... [read more]
Individual Price: $49.00
|
|
|
A single-asset battery energy storage (BESS) project finance model with the two things a solar or wind model cannot give you: a revenue stack that switches from a... [read more]
Individual Price: $49.00
|
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |