Companion files · The Renewable Energy Development Handbook
Taking Solar and Wind Projects from Site Control to Commercial Operation: Land, Permits, Interconnection, PPAs and Financing.
These are the companion files of the book. One workbook rebuilds Cedar Hollow Solar, the fictional 150 MWac / 195 MWdc project the book follows from the first land option in 2022 to commercial operation in 2028: its capital cost, its energy yield and exceedance levels, market prices, a 20-year utility PPA, a 15-year virtual PPA and the merchant case, the production tax credit and the ITC alternative, the foreign entity test, debt and tax equity, a wind alternative and a battery option, and the value of the project at each development milestone. A second file holds the diligence checklists of Appendix B in editable form. No sign-up, no email is asked for, nothing is locked. Amounts are in US dollars; blue type is an input, black type is a formula.
The archive holds the workbook, the checklists and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Optional. When the workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
Chapters 1 to 15 · Appendix A
One Inputs sheet holds every assumption, each with a range name, and the scenario switches: offtake case, credit, bonus, energy level, capital cost, module price, network upgrades, hub price and discount rates. Capex, Energy, Market, Opex and Credits build the project year by year from 2028 to 2062. Cases values the utility PPA, the virtual PPA and the merchant case: development value and its bridge, the highest premium a buyer can pay, IRR, and values at COD and in 2038. Breakeven finds the PPA price that leaves the buyer at its discount rates, and Sensitivities draws the tornado. Then site screening, interconnection deposits and upgrade shocks, stage values and the developer's return, sales at earlier stages, debt and tax equity, the foreign entity test, the wind alternative, the battery option, EPC delay damages, and a Checks sheet that sets 431 figures the book prints beside the cells that compute them.
Download the workbook213 KBAppendix B
Land and site control, resource and energy yield, permits, interconnection, offtake, equipment and foreign entity documentation, the EPC contract, tax credits, financing and closing at NTP, and construction to COD. Edit them for your own project.
Download the checklists40 KBRead first
Which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| The offtake | The right to build Cedar Hollow is worth $33.4 million with the utility PPA, $15.2 million with the corporate virtual PPA and minus $38.2 million fully merchant, against a $27.0 million premium paid at notice to proceed |
| The credit | The production tax credit carries $73.0 million of that value: with the ITC instead the project is worth $6.6 million, and with no credit minus $39.6 million |
| The milestones | The project is worth $0.02 million at site control and $35.1 million at notice to proceed; the biggest step, $11.8 million, comes with the PPA and the start of construction in 2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Cedar Hollow Solar, Hartwell Ridge Wind, Calder Plains Renewables, Ashgrove Clean Power Fund, Norland Electric Cooperative, Quillon Data Systems, Ironbridge Constructors, Larkspur Solar Manufacturing and Marlow County are fictional, and the figures are the book's assumptions, not market statistics or forecasts. Nothing here is investment, legal, tax, accounting or engineering advice.
Forty private markets interview questions with model answers and the arithmetic worked out. Direct download, no sign-up.
Get the cheat sheetDiscover more of Julian R. Sterling's practical library of models, checklists and worked cases.
Browse Julian R. Sterling's books Browse all companion files