# Battery Storage Model Build a BESS financial model with energy arbitrage, capacity market revenue, ancillary services, and granular degradation logic. Structured for infrastructure investors and project finance teams. - Canonical: https://finamodel.com/templates/battery-storage-model - Excel download: https://finamodel.com/templates/battery-storage.xlsx - Category: Energy - Model type: Project finance - Difficulty: Intermediate - Audiences: Developers & sponsors, Investors & analysts, Renewable energy developers, Utilities, Energy investors, Project finance teams - Tags: battery storage, renewable energy, energy arbitrage, grid services, PPA ## Overview A battery storage project finance model projects revenues from wholesale energy arbitrage, ancillary grid services, and capacity market payments to determine whether a 100 MW / 400 MWh lithium-ion system can service non-recourse debt at 1.35x minimum DSCR and deliver 12%+ equity IRR. The model stacks three merchant revenue streams that vary with electricity price spreads, ancillary market saturation, and capacity auction dynamics, then stresses for power price compression and augmentation capex (new battery racks added mid-life to offset degradation). Revenue modelling includes wholesale arbitrage (sold MWh at peak price minus charged MWh at off-peak price, both net of round-trip efficiency loss and grid fees), ancillary services (frequency regulation paid per MW per hour of grid service), and capacity market payments (bilateral contracts or auction clearing prices paid per MW per month). Opex is dominated by fixed long-term service agreement (LTSA) costs ($7.5M per MW per year), plus insurance, land lease, and asset management fees. Capex includes the EPC lump sum ($140M for a 400 MWh system at $350/kWh in 2025), grid connection, and a substantial interest-during-construction (IDC) charge capitalised to the asset. Augmentation capex is triggered when battery health of state (SOH) degrades below 80%, typically in year 13, requiring new racks at $200/kWh to restore capacity. Infra PE sponsors, development equity investors, and lenders use battery storage models to assess project viability, stress revenue under different commodity price and capacity market scenarios, confirm DSCR adequacy including augmentation reserves, and compare projected equity IRR to the cost of capital for energy transition funds. ## What's included - Revenue stacking across arbitrage, ancillary services, and capacity markets - Battery degradation and augmentation capex schedules - Round-trip efficiency and state of charge modelling - Project finance debt structuring with DSCR and cash sweep logic - IRR, NPV, and equity return outputs - Battery system sizing: MW capacity and MWh duration - Annual cycling volume and power price arbitrage revenue - Ancillary services: frequency regulation, capacity provision, and other grid services - Power purchase agreement (PPA) revenue by year and price escalation - Degradation cost and expected battery replacement timing - Operating and maintenance costs, and connection/transmission charges ## Battery Storage Model: What the BESS Project Finance Template Captures This battery storage model is a project-finance template for evaluating whether a 100 MW / 400 MWh lithium-ion BESS can support non-recourse senior debt at a target DSCR of 1.35x and what equity IRR remains for the sponsor. It combines merchant revenue, operating costs, debt, tax and cash flow into one integrated structure. ### Revenue Streams and Operating Drivers The model stacks three merchant revenue streams. Wholesale energy arbitrage is the dominant line: imported MWh are driven by available capacity, annual cycles and availability, while exported MWh are reduced by round-trip efficiency. - Arbitrage revenue nets charging cost inside the same line, so charging cost is not subtracted again downstream. Ancillary services are driven by power capacity, a per-MW hourly price, daily service hours, availability and days per year. - Capacity market payments use derated MW, a monthly capacity price and twelve months. An RTM trading fee is charged as a percentage of arbitrage plus ancillary revenue but not on bilateral capacity payments, and the fee is netted inside the net revenue line. ### Cost Structure and Tax Treatment Operating costs are fixed and stored as positive numbers on the Opex sheet, which is the single source of truth for total operating expenses. Lines include fixed O&M under an LTSA, land lease, insurance based on total capex, asset management and property taxes. - Most lines escalate at 2.5% inflation annually, with fixed O&M carrying a bundled LTSA escalator approximated at the same rate. Tax is applied at a flat 25% corporate rate, with 20-year straight-line tax depreciation on initial PP&E and a simple vintage-style treatment for augmentation capex. - Net operating loss carry-forward is the default, so tax is charged only once cumulative taxable profit turns positive. No MACRS, ITC or PTC is included in the base case. ### Debt, Capital Structure and Calculation Flow The model is sized at 55% debt and 45% equity with an 18-year tenor and straight-line principal amortisation, not DSCR-sculpted. Interest accrues on the opening debt balance at a 6.5% all-in rate. - Interest during construction is calculated on the debt portion of hard capex using the drawdown profile and an average outstanding percentage of 0.90 for a 40/60 two-year draw, then capitalised into PP&E; the facility is grossed up so the bank pays the IDC. A DSRA equal to six months of forward debt service is funded from debt proceeds at COD and released at final maturity. - The straight-line amortisation choice breaks the tax-interest-debt circularity because debt service is known without reference to CFADS. The build order runs from assumptions through technical build, revenue, opex, capex, debt, financials, tax, waterfall and returns. ### Outputs and Practical Use The outputs include project IRR, equity IRR, NPV, minimum DSCR and LLCR, supported by checks covering balance sheet balance, positive cash, declining debt, minimum DSCR, positive distributions and valid IRR signs. EBITDA is defined once on the Financials sheet from net revenue less total opex and consumed by tax, DSCR and waterfall calculations, avoiding duplicate definitions. - CFADS converts from EBITDA at roughly 90%, with the gap representing cash taxes and working capital movements. Debt service is subtracted, DSRA movements are applied, and positive distributions flow to equity. - The model is intended for sponsor-side FID decisions and lender-side credit review, and the public download is a values-only preview rather than a live formula workbook. ## Built for energy storage investment Use this model when revenue stacking, degradation, and infrastructure financing drive the project economics. ## Handles complex BESS mechanics A useful storage model connects degradation curves, augmentation capex, and multiple revenue streams so the long-term investment case is visible. ## Structured for bankable analysis This gives you a project finance framework with proper coverage ratios and debt sizing instead of a simplified energy spreadsheet. ## Built for energy storage investment Use this model when revenue stacking, degradation, and infrastructure financing drive the project economics. ## Handles complex BESS mechanics A useful storage model connects degradation curves, augmentation capex, and multiple revenue streams so the long-term investment case is visible. ## Structured for bankable analysis This gives you a project finance framework with proper coverage ratios and debt sizing instead of a simplified energy spreadsheet. ## Features - **Multi-revenue stream modeling:** Combine energy arbitrage, capacity payments, and ancillary services to see total project IRR and the sensitivity of each revenue stream. - **Cycling and degradation tracking:** Model annual cycling depth and frequency; degrade capacity and efficiency over time with realistic replacement capex. - **Power price sensitivity:** Run scenarios on spread between peak and off-peak power prices to see how market conditions affect profitability. ## Use cases - **Project development and economics evaluation:** Determine minimum PPA prices and ancillary service volumes needed to meet IRR targets. - **Financing and debt structuring:** Present cash flow projections and sensitivities to lenders or investors for bond offerings or project finance. - **Location and size optimization:** Compare different grid locations and battery sizes to identify the economics-optimal configuration. ## Frequently asked questions ### What is a battery storage financial model? It is a model that forecasts the revenue, costs, and returns of a battery energy storage system across its operational lifecycle. ### Who uses BESS financial models? Infrastructure investors, renewable energy developers, project finance bankers, and asset managers use them to underwrite storage investments. ### What should a battery storage model include? It should include revenue stacking, degradation schedules, augmentation capex, round-trip efficiency, and debt structuring with coverage ratios. ### How does degradation affect the model? Battery capacity declines over time, which reduces revenue potential. The model tracks this and includes augmentation capex to maintain nameplate capacity. ### Can it handle multiple revenue streams? Yes. The model supports simultaneous revenue from energy arbitrage, capacity markets, and ancillary services such as frequency response. ## Related templates - [Renewable Energy Project Economics Model](https://finamodel.com/templates/renewable-energy-model) - [EV Charging Network Model](https://finamodel.com/templates/ev-charging-model) - [Hydrogen Production and Storage Model](https://finamodel.com/templates/hydrogen-model)