Battery storage project financial model, built free.
A three-statement Excel model for a battery storage operator, built from your own figures and checked to balance.
- Free account
- No card
- Usually ready within the hour
We use generative AI in parts of our process, so mistakes can occur. Every model should be checked by a person before it is relied on. Read more
Owns grid-scale batteries earning energy arbitrage, frequency control (FCAS / ancillary) and capacity or tolling payments.
In short
- 01
Three linked statements
Income statement, balance sheet and cash flow, linked in every period.
- 02
Valuation built in
Choose from 7 methods, from discounted cash flow to precedent deals.
- 03
Monthly to annual
Monthly, quarterly, half-yearly or annual periods, for up to 30 years.
- 04
Checked every period
A Checks sheet shows the balance sheet balances and the cash reconciles.
12 parts, each one tested.
Every part is a tested building block with its own checks: yours is put together from the ones your business needs.
- Wholesale electricity price curveThe wholesale electricity price forecast used by the revenue and cost parts that need it.
- Asset registerThe facts every other part of the model builds on — capacity, opening book value and remaining life.
- Development and constructionConstruction capex, commercial operation date and ramp-up for new assets, and the development pipeline.
- GenerationElectricity sent out (or discharged) by each asset in each period.
- Energy revenueRevenue from selling electricity (or discharging storage) under contracts and in the wholesale market.
- Certificates, ancillary and capacity revenueRevenue beyond energy sales — green certificates, frequency control and other ancillary services, and capacity or support payments.
- Fuel, charging energy and carbon costsVariable cost of the energy an asset consumes — gas, coal, charging or pumping electricity, electrolyser power — and its carbon cost.
- Operating costsSite operating costs — O&M, asset management, land lease, insurance, grid charges and community payments.
- Asset base and depreciationSustaining and replacement capex and depreciation of each asset's property, plant and equipment.
- Clean energy tax creditsProduction and investment tax credits earned by an asset, whether used by the owner, sold to a third party or allocated to a tax equity investor.
- Decommissioning and restoration provisionsProvisions to remove generation assets, abandon wells and restore sites — recognition, unwinding and spend.
- Energy and utility KPIsThe ratios investors and lenders use to judge energy and utility businesses.
The numbers it tracks.
- 01cycles per year
- 02arbitrage spread captured
- 03revenue per MW
- 04state of health
- 05LCOS
- 06equity IRR
What it is used for.
- Project financeGuide · Financial modelling services
- Development feasibilityGuide · Financial modelling services
- Operating forecastGuide · Financial projections
- Budget and rolling forecastGuide · Cash flow forecast
- ValuationGuide · DCF valuation model
- Lending and credit analysisGuide · Three-statement model
- Scenarios and sensitivities
- Asset acquisition
More in power generation and renewables.
- Solar and wind farm financial model
- Hydro power station financial model
- Gas-fired power station financial model
- Offshore wind farm financial model
- Geothermal generator financial model
- Nuclear generator financial model
- Waste-to-energy plant financial model
- Bioenergy producer financial model
- Hydrogen producer financial model
- Renewable energy developer financial model
- Carbon credit project financial model
Looking for a battery storage project financial model template? Ours arrives built for your business, with your figures in it.
See a finished model, sheet by sheetThe sample is built on illustrative figures and describes no real business. Models are calculations prepared from the information you provide. They are not financial advice and must be independently verified. See our terms.