Battery Energy Storage System (BESS) Financial Model w/ DCF, Sensitivity Analysis, & WACC

Very comprehensive 20 Year 169-tab Excel template for a Battery Storage plant.

Battery Energy Storage System (BESS) Financial Model w/ DCF, Sensitivity Analysis, & WACC
, , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , ,

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:

  1. Assumptions & Inputs
  2. Technical Performance Model
  3. Revenue Model
  4. Operating Cost Model
  5. Capital Expenditure Schedule
  6. Depreciation & Amortization Schedule
  7. Financing Schedule
  8. Income Statement
  9. Cash Flow Statement
  10. Balance Sheet
  11. Valuation & Returns Analysis
  12. 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.

You must log in to submit a review.