
This financial model for a Battery Energy Storage System (BESS) is a structured fully integrated three-statement model (Income Statement, Cash Flow Statement, and Balance Sheet) that captures the technical, operational, financing, and degradation characteristics of the project over its entire economic life. Unlike conventional generation assets, battery storage economics are heavily influenced by battery degradation, augmentation requirements, cycling behavior, ancillary service revenues, and replacement capital expenditures.
1. Financial Model Structure
The model should generally consist of the following modules:
- Assumptions & Inputs
- Technical Performance Model
- Revenue Model
- Operating Cost Model
- Capital Expenditure Schedule
- Depreciation & Amortization Schedule
- Financing Schedule
- Income Statement
- Cash Flow Statement
- Balance Sheet
- Valuation & Returns Analysis
- Sensitivity and Scenario Analysis
Revenue Model (Covering up to 10 Storage Containers)
The revenue model estimates all sources of battery storage income, including:
Energy Arbitrage
Revenue earned by charging during low-price periods and discharging during high-price periods.
Revenue = MWh discharged × Spread captured
Key drivers:
- Market price volatility
- Battery round-trip efficiency
- State of charge constraints
- Cycle limits
Capacity Market Revenues
Payments received for providing firm capacity to the grid.
Key assumptions:
- Contracted MW
- Capacity price
- Availability requirements
- Performance penalties
Ancillary Services
Potential revenues include:
- Frequency response
- Regulation services
- Spinning reserve
- Non-spinning reserve
- Voltage support
- Black start capability
Renewable Integration Revenues
For co-located solar-plus-storage systems:
- Curtailment reduction
- Peak shifting
- Energy firming
- Time-of-use optimization
Grid Services
Potential revenues from:
- Congestion relief
- Distribution deferral
- Transmission support
Income Statement
The Income Statement measures profitability during each reporting period.
Revenue
Includes:
- Energy arbitrage revenue
- Capacity payments
- Ancillary services revenue
- Renewable integration services
- Other grid service revenues
Total Revenue
Less:
Operating Expenses
Fixed Operating Expenses
- Labor
- Insurance
- Administration
- Site management
- Security
Variable Operating Expenses
- Charging energy costs
- Maintenance expenses
- Software licenses
- Communication services
Result:
EBITDA
EBITDA represents operating cash generation before capital recovery and financing costs.
EBITDA = Revenue − Operating Expenses
Less:
Depreciation and Amortization
Includes:
- Battery system depreciation
- BOP depreciation
- Buildings depreciation
- HVAC depreciation
- EMS/SCADA amortization
- Safety systems depreciation
- Export infrastructure depreciation
Result:
EBIT (Operating Income)
EBIT = EBITDA − D&A
Less:
Interest Expense
Interest on:
- Construction loans
- Term debt
- Revolving credit facilities
Result:
Earnings Before Tax (EBT)
EBT = EBIT − Interest Expense
Less:
Income Taxes
Based on:
- Tax depreciation
- Deferred tax adjustments
- Investment tax credits (where applicable)
Result:
Net Income
Net Income = EBT − Taxes
Cash Flow Statement
The Cash Flow Statement tracks actual cash movement and is usually the most important statement for project finance.
Cash Flow from Operations
Start with:
Net Income
Add back:
- Depreciation
- Amortization
- Non-cash impairment charges
Adjust for:
Working Capital Changes
- Accounts receivable
- Accounts payable
- Accrued expenses
- Inventory
Result:
Operating Cash Flow
Cash Flow from Investing Activities
Can Include:
Initial Construction CAPEX
- Battery procurement
- Site preparation
- Buildings
- Grid connection
Expansion CAPEX
- Capacity augmentation
- Additional battery racks
Replacement CAPEX
- Cell replacements
- Inverter replacements
- HVAC replacements
Salvage Value
Potential recovery at project end.
Result:
Investing Cash Flow
Balance Sheet
The Balance Sheet shows the project’s financial position.
Assets
Current Assets
Cash
Operating accounts and reserve accounts.
Accounts Receivable
Outstanding market settlements.
Prepaid Expenses
Insurance and service contracts.
Non-Current Assets
Battery Energy Storage Assets
Includes:
- Cells
- Modules
- Racks
- Containers
Recorded at cost less accumulated depreciation.
Balance of Plant Assets
Includes:
- Inverters
- Transformers
- Switchgear
- Cabling
- Civil works
Buildings and Facilities
- Control rooms
- Administrative buildings
- Warehouses
Software Assets
- EMS
- SCADA
- Monitoring platforms
Each year has it’s own dedicated Depreciation and Amortization of Battery Capacity Degradation tab
Battery capacity degradation is a unique characteristic of BESS assets and should be modeled separately from traditional fixed-asset depreciation. Capacity degradation reflects the physical reduction in usable energy storage capability caused by cycling, calendar aging, temperature exposure, and operational conditions. The technical model should forecast annual degradation rates, typically ranging from 1.5% to 3.0% per year depending on chemistry and cycling intensity. As usable capacity declines, revenue-generating capability also decreases unless augmentation investments are undertaken.
From an accounting perspective, the battery asset may be depreciated on a straight-line basis over its useful life, while the operational model separately reflects declining revenue due to degradation. In more advanced models, depreciation may be linked to expected energy throughput, creating a units-of-production depreciation methodology that better aligns accounting expense with battery consumption.
Capacity Loss and Battery Augmentation
Battery capacity loss should be explicitly modeled through degradation curves. Beginning-of-life capacity (100%) gradually declines to end-of-life thresholds, commonly 70–80% of original capacity. Revenue forecasts, ancillary service capability, and capacity market participation should all reflect the declining available energy and power capability.
To maintain contractual obligations, many projects include augmentation CAPEX. Augmentation involves installing new battery modules during the operating period to restore capacity. These expenditures should be modeled as future capital investments and added to the asset base for subsequent depreciation. Augmentation schedules are often triggered when capacity falls below predefined operational thresholds.
There are 15 individual inputs for CAPEX, including
CAPEX and Depreciation: Balance of Plant (BOP) / Systems
Balance of Plant encompasses all non-battery electrical and civil infrastructure required for operation. Components include power conversion systems, transformers, switchgear, protection equipment, cabling, grounding systems, foundations, roads, drainage, and communications infrastructure.
BOP assets typically represent 20–40% of total project cost and generally have useful lives longer than the battery cells. Depreciation is usually modeled on a straight-line basis over 20–30 years. Major replacements such as inverter overhauls may be treated separately as replacement CAPEX with independent depreciation schedules.
CAPEX and Depreciation: Thermal Management (HVAC) Systems
Thermal management systems regulate battery temperature and are essential for safety, efficiency, and warranty compliance. These systems include chillers, air conditioning units, cooling loops, fans, ducting, sensors, and controls.
HVAC systems generally have useful lives of 10–15 years and may require major refurbishment during the project life. Capital costs should be capitalized and depreciated separately from the battery system. Energy consumption associated with HVAC operation should be included in operating expenses because it directly impacts round-trip efficiency and project profitability.
CAPEX and Depreciation: Enclosures and Structural Components
Battery containers, steel structures, foundations, mounting systems, walkways, and structural supports are long-lived assets. These components provide environmental protection and physical support for electrical equipment.
Such assets typically have useful lives of 20–35 years. Straight-line depreciation is commonly used because deterioration occurs relatively uniformly over time. Major refurbishment programs should be modeled as future sustaining CAPEX where appropriate.
Discounted Cash Flow (DCF) for BESS
A DCF analysis values a battery storage project by estimating all future cash flows and discounting them back to their present value. For a BESS, cash inflows come from revenue streams like energy arbitrage (buying low, selling high), frequency regulation services, and capacity payments. Outflows include upfront capital costs (batteries, inverters) and ongoing operational expenses (maintenance, replacement cells). Since BESS revenues are highly volatile and dependent on real-time market prices, the DCF model projects these revenues over a 20-year life. The final net present value tells investors whether the project is likely to create value, assuming realistic input assumptions.
Weighted Average Cost of Capital (WACC) for BESS
The WACC represents the minimum return a BESS project must earn to satisfy its investors, blending the cost of debt and equity. Because battery storage is a capital-intensive technology with perceived technology risk and market volatility, lenders often demand higher interest rates or require strong counterparty contracts. Equity investors typically expect a higher risk premium (e.g., 12–15%) compared to a renewable generation asset due to revenue uncertainty. The WACC serves as the discount rate in the DCF; a lower WACC (e.g., from a contracted revenue model) increases project value, while a higher WACC (merchant market exposure) can render a physically viable BESS financially unattractive.
Sensitivity Analysis on BESS
Sensitivity analysis is critical for battery storage due to high uncertainty in key drivers. A typical model varies inputs like battery round-trip efficiency, degradation rate, energy price volatility, or the frequency of charge-discharge cycles. For example, a 10% drop in wholesale price spreads might reduce project NPV by 40%, while a 1% annual increase in degradation could cut total lifetime revenue by over 20%. Running a tornado chart or Monte Carlo simulation reveals which variables have the largest impact—often cycle life and capture price—helping developers decide whether to secure a fixed revenue contract or hedge against price risk. This analysis transforms a static DCF into a risk-aware decision tool.
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.