A free battery storage (BESS) financial model in Excel, from degradation to equity
Capacity fade and augmentation, merchant arbitrage and capacity revenue, merchant, tolled and floor cases, debt sized on each, the investment tax credit and its bridge, and development value: ten sheets, no macros.
The file develops a fictional 200 MW, four-hour battery: 800 MWh contracted at the point of interconnection, 840 MWh installed on day one. It costs $238.6 million; the tax credit brings $76.9 million of cash. Degradation is restored by 310 MWh of augmentation costing $28.3 million over the life. In 2028 the battery earns $15.1 million from arbitrage and $14.8 million from capacity. Fully merchant, it returns 9.92% unlevered and is worth $174.0 million at operation; under a toll it returns less but is worth more, $189.9 million.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Battery_Storage_BESS_Financial_Model.xlsx (49 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is one worked case from The Battery Storage Development Handbook. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 19 paperbacks by Julian R. Sterling on energy, infrastructure and land, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Ten sheets. Blue cells on Inputs are the only inputs.
README and Inputs
The asset (power, energy, efficiency, availability, cycles, degradation, augmentation), capital cost, prices, the toll and the floor, debt terms and the credit.
Fleet
Energy by block and year, retention, and the augmentation that restores contracted energy.
Merchant
Arbitrage and capacity revenue year by year.
Cases
Merchant, toll and floor cases: cash flows, values at operation and development value.
Debt and Credit
Term debt sized on each case, the credit bridge and the equity.
Duration, Development and Checks
Two-hour against four-hour economics, development value, and the checks: all OK.
What the worked case returns
Measure
Value
Power and contracted energy
200 MW, 800 MWh
Total capital cost
$238.6m
Credit cash
$76.9m
Augmentation over the life
310 MWh, $28.3m
2028 merchant revenue
$32.6m
Case A (merchant): unlevered IRR, value
9.92%, $174.0m
Case B (toll): unlevered IRR, value
9.46%, $189.9m
Case A term debt
$64.3m
The toll lowers the return and raises the value at the same time: contracted cash flows are discounted at a lower rate and support more debt. Which case is better depends on who holds the asset, which is the question the development value answers.
How to use it on your own project
Enter your power, energy, efficiency and degradation on Inputs.
Set the augmentation policy and read the Fleet sheet.
Enter price assumptions and read merchant revenue.
Compare the three cases and the debt each supports before choosing a contract.
Questions people ask about it
Is this template really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference. The debt is sized on cash flows within the tenor at a fixed ratio, not by iteration.
Why does the model install more energy than it contracts?
Because a battery loses capacity every year. Installing 840 MWh for an 800 MWh contract, then adding blocks over time, keeps the contracted energy available.
Can I use it for a real project?
You can reuse the structure. The project and every figure are fictional, and nothing here is investment advice.
The rest of the files
This template is the companion workbook for The Battery Storage Development Handbook; the companion page also carries the other files that go with it. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
This template comes from The Battery Storage Development Handbook. The book is on Apple Books and Google Play.
If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.