Companion files · The Battery Storage Development Handbook
Developing, Financing and Operating Utility-Scale BESS: Siting, Interconnection, Revenue Stacking and Bankable Contracts.
These are the companion files of the book. One workbook rebuilds Harrow Creek Storage, the fictional 200 MW / 800 MWh battery the book follows from notice to proceed: its capital cost, its degradation and augmentation year by year, its merchant revenue stack, a ten-year toll and a revenue floor, the investment credit and the material assistance test of the foreign entity rules, its debt and equity, three durations side by side and the value of the project at each development stage. 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 2 to 15 · Appendix A
One Inputs sheet holds every assumption and the sensitivity switches. Fleet ages each block of batteries and adds augmentation when energy would fall below the contract. Merchant builds arbitrage, capacity and ancillary revenue. Cases values the merchant, tolled and floor cases: development value, operating value and IRR. Debt sizes sculpted debt on contracted and merchant cash flow, the credit bridge and the equity return. Credit computes the investment credit and the material assistance cost ratio of three supply options. Then the duration comparison, the developer's return by stage, and a Checks sheet that sets 43 figures the book prints beside the cells that compute them.
Download the workbook49 KBAppendix B
Site and interconnection, permits and fire safety, equipment, contracts and trade, revenue, the tax credit, financing and the model, and the operating asset. Edit them for your own project.
Download the checklists38 KBRead first
| The three cases | The right to build Harrow Creek is worth $1.0 million fully merchant, $20.0 million with a ten-year toll at $12.25 per kW-month and $11.8 million with a revenue floor, against a $16 million price |
| The credit | Cells from a prohibited foreign entity put the material assistance ratio at 54 percent, one point below the 55 percent required for construction beginning in 2026, and the $76.9 million credit is lost |
| The debt | The toll supports $120.1 million of ten-year debt at 1.30 times; fully merchant at 2.00 times, $64.3 million over seven years |
The files are provided as they are, without warranty of any kind. The model is illustrative: Harrow Creek Storage, Linden Grid Partners, Carrow Energy Transition Fund, Westmark Energy Supply and their lenders 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