Battery Storage Financial Model Template
Build, test and defend the investment case for any utility-scale solar and battery storage project with this fully-integrated Solar Battery Storage financial model Template. Rather than a static spreadsheet, this Excel model runs a true 384-month monthly engine — 18 months of construction, 6 months of commissioning and a full 30-year operating life — with both construction duration and operating life fully editable. Twenty interconnected tabs cover everything from CAPEX phasing and debt sculpting to unlevered project returns and levered equity IRR, giving developers, lenders, asset managers, consultants and students a single, transparent workbook for solar-plus-storage project finance analysis..
20-Year Financial Model for Solar + BESS Financial Model Template
Unlike most solar financial models, this template treats battery energy storage as a fully editable asset register rather than a fixed assumption — add or remove BESS containers, set individual degradation curves and augmentation years, and watch fleet-wide available capacity, arbitrage revenue and lifecycle CAPEX recalculate automatically. Senior debt is sculpted to a target DSCR using a trailing-12-month covenant test that removes seasonal distortion, while the DCF and Equity Returns tabs cleanly separate unlevered project IRR from levered equity IRR — the distinction every lender and every equity investor actually cares about. A dedicated Sensitivities tab stress-tests IRR against power price, CAPEX, leverage and WACC using live, two-way data grids, not static screenshots.
Whether you’re underwriting a co-located solar-plus-storage asset, preparing a lender information memorandum, building an investment committee pack, or teaching renewable energy project finance, this Excel financial model template gives you a rigorous, fully-reconciling starting point instead of a blank spreadsheet. Every formula is live, every input is colour-coded, and an automated Checks tab runs eighteen integrity tests — balance sheet reconciliation, debt roll-forward, DSCR covenant compliance, CAPEX funding and more — before you ever present a number to an investor, lender or board.
Tab-by-Tab Content
1. Cover Read Me
The Cover Read Me tab orients every user of this solar and battery storage financial model, explaining modelling conventions, colour-coding and navigation before you touch a single input — the fastest way to understand the workbook’s structure, key outputs and built-in guardrails.
- Model purpose, scope and modelling conventions explained upfront
- Colour-coded legend for inputs, formulas and cross-sheet links
- Step-by-step usage instructions across all 20 tabs
- Live KPI snapshot: capacity, CAPEX, Project IRR, Equity IRR
2. Inputs & Assumptions
Every assumption driving this solar-plus-storage financial model lives in one place. Change PPA pricing, BESS capacity, debt terms or tax rates here and the entire 384-month model — from CAPEX phasing to equity returns — recalculates instantly across all twenty tabs.
- 85+ editable inputs across project, solar, BESS, revenue, CAPEX, OPEX, financing and tax
- Illustrative default values so the model runs immediately, out of the box
- Single source of truth referenced by named ranges throughout the workbook
- Editable construction period, commissioning period and operating life
Solar + Battery Storage Revenues & Opex
3. Timeline
The Timeline tab is the master monthly calendar underpinning this entire solar and BESS project finance model, aligning all 384 columns — 18 months construction, 6 months commissioning, 30 years of operations — across every other tab in the workbook.
- Editable construction, commissioning and operating-life durations
- Monthly date, calendar year and financial year tracking
- Construction, commissioning, COD and operating-period flags for every month
- Single reference point every other tab links back to
4. Construction
Track every dollar of solar and BESS CAPEX exactly when it’s spent. The Construction tab phases capital expenditure across an 18-month build using an editable S-curve, funds it with debt and equity, and verifies sources equal uses automatically.
- Monthly CAPEX phasing via an editable S-curve, not a Year-0 lump sum
- Debt drawdowns, equity injections and capitalised interest (IDC) tracked monthly
- Automated sources-and-uses reconciliation with a live PASS/FAIL check
- Feeds the opening operating debt balance at commercial operation date
5. Solar
Model utility-scale solar PV generation with precision. The Solar tab converts installed DC and AC capacity into net energy output through a seasonal generation profile, availability, degradation and curtailment factors — the revenue engine behind every dollar this project earns.
- Self-normalising monthly seasonal generation shape, fully editable
- Degradation, availability, curtailment and electrical losses modelled separately
- DC/AC capacity ratio and inverter clipping built into the waterfall
- Net generation feeds Energy Revenue and BESS charging calculations directly
6. BESS
An editable battery energy storage asset register, not a fixed assumption. The BESS tab lets you add or remove containers, set individual degradation and augmentation schedules, and models fleet-wide available capacity as batteries age and get replaced over 30 years.
- Fully editable container-by-container battery asset register
- Per-container degradation rate, round-trip efficiency and augmentation year
- Fleet-wide available MW and MWh capacity calculated automatically
- Number of containers is a live input, never hardcoded
7. BESS Dispatch
Simulate realistic battery arbitrage dispatch month by month. The BESS Dispatch tab charges from solar and the grid, discharges to capture price spreads, tracks state of charge within safe limits, and counts equivalent full cycles across the operating life.
- Monthly charge and discharge volumes, net of round-trip losses
- State of charge clamped within minimum and maximum SOC limits
- Solar-to-BESS charging and grid charging split out separately
- Equivalent full-cycle counter feeds battery degradation tracking
8. Energy Revenue
Convert generation into cash. The Energy Revenue tab prices solar output under PPA and merchant contracts, and monetises BESS arbitrage on the spread between charge and discharge prices — the two largest revenue lines in any solar-plus-storage project.
- PPA and merchant power revenue with independent escalation rates
- BESS arbitrage margin priced on the captured charge/discharge spread
- Revenue automatically gated to zero before commercial operation date
- Feeds directly into EBITDA, debt sizing and equity distributions
9. Ancillary / Other Revenue
Capture every additional revenue stream a solar and battery storage asset can earn. This tab models capacity payments, frequency response, balancing services, grid services and other contracted income as independent, switchable modules alongside core energy sales.
- Five independently switchable ancillary revenue streams
- Capacity payments, frequency response and balancing services modelled separately
- Inflation-escalated contracted revenue for long-term offtake agreements
- Modular design lets you turn any revenue stream on or off
10. OPEX
Every operating cost a solar and BESS asset incurs, modelled monthly. The OPEX tab covers solar and battery O&M, land lease, insurance, asset management and grid fees, escalating with inflation from COD across a full 30-year operating life.
- Solar and BESS operations & maintenance split by fixed and variable cost
- Insurance, land lease, asset management and grid fees included
- All operating costs escalate with the Timeline inflation index
- Zero OPEX before the commercial operation date, automatically enforced
11. CAPEX
From initial construction spend to decade-two battery augmentation, the CAPEX tab captures the full capital lifecycle of a solar-plus-storage project — equipment, EPC fees, contingency, and the lumpy lifecycle CAPEX that lithium-ion batteries require to keep performing.
- Initial CAPEX build-up: solar, BESS, grid connection, EPC, contingency
- Lifecycle CAPEX: BESS augmentation, battery replacement, major maintenance
- Editable per-MW and per-MWh cost assumptions throughout
- Feeds both the unlevered DCF and the construction funding schedule
Solar + Battery Storage Equity & Costs
12. Working Capital
Model the cash timing gap between earning revenue and paying costs. The Working Capital tab calculates accounts receivable and payable from editable DSO/DPO assumptions, converting them into the monthly cash flow movement that feeds project financials.
- Editable days-sales-outstanding and days-payable-outstanding assumptions
- Net working capital position calculated every month
- Working capital movement feeds Monthly Financials cash flow directly
- Standard project finance working capital treatment throughout
13. Debt Financing
See exactly how senior debt behaves under stress. The Debt Financing tab sculpts principal repayments to a target DSCR, tracks interest and the debt balance monthly, and reports both single-month and trailing-12-month DSCR against your covenant threshold.
- Debt sculpted to a target DSCR, capped at the debt tenor
- Trailing-12-month DSCR removes seasonal distortion from covenant testing
- Minimum and average DSCR tested against the covenant automatically
- LLCR and closing debt balance at end of tenor calculated live
14. Tax
Corporate tax modelled the way lenders and investors expect. The Tax tab depreciates CAPEX on a rolling schedule, carries forward tax losses, and calculates cash tax payable — a critical driver of both project-level and equity-level investment returns.
- Rolling tax depreciation schedule with an editable useful life
- Tax loss carryforward, switchable on or off as an input
- Cash tax payable calculated monthly, net of losses
- Feeds both the unlevered DCF and equity cash flow build-up
15. Monthly Financials
The three-statement bridge every financial model needs. Monthly Financials consolidates the income statement, cash flow and a full balance sheet across 384 months, reconciling exactly — the foundation every downstream valuation and returns tab depends on.
- Full income statement, cash flow and balance sheet, modelled monthly
- Balance sheet reconciles exactly to zero across all 384 months
- Distribution waterfall subject to live DSCR lock-up testing
- Sponsor equity support mechanism funds lifecycle CAPEX cash shortfalls
16. Discounted Cash Flow (DCF)
Unlevered project valuation, independent of how it’s financed. The DCF tab discounts 30 years of free cash flow to firm at your WACC, calculating Project NPV, Project IRR and payback — plus live sensitivity tables on price, CAPEX and WACC.
- Unlevered free cash flow to firm, independent of capital structure
- Project NPV, Project IRR and discounted payback period calculated
- Live WACC sensitivity recomputed exactly, not approximated or scaled
- Rolls 384 monthly columns up to a readable Year 0–30 grid
17. Equity Returns
What the sponsor actually earns. The Equity Returns tab tracks levered cash flow to equity — contributions, distributions and exit proceeds — calculating Equity IRR, Equity NPV and cash-on-cash multiple, separate from the unlevered project-level view.
- Levered equity cash flow, kept clearly separate from the unlevered DCF
- Equity IRR, Equity NPV and equity multiple (MOIC) calculated
- Sponsor capital calls for lifecycle CAPEX shortfalls included
- Equity payback period tracked year by year across the hold
18. Sensitivities Scenarios
Stress-test the investment case before your investors do. This tab runs Downside, Base and Upside scenarios plus four live two-way sensitivity grids — IRR versus price, CAPEX, leverage and WACC — so you know exactly where the risk sits.
- Three built-in scenario cases: Downside, Base and Upside
- Four two-way sensitivity grids computed from live, recalculated cash flows
- Project IRR and Equity IRR tested against CAPEX, price, leverage and WACC
- Every grid cell is a real recalculation, never a static snapshot
19. Dashboard Investment Summary
Everything an investment committee needs on one page. The Dashboard pulls project, operations, financing and returns metrics into a single live summary, backed by six charts covering revenue, EBITDA, cash flow, debt paydown and BESS degradation.
- One-page project, operations, financing and returns summary
- Six native charts: revenue, EBITDA, cash flow, debt, degradation, IRR sensitivity
- Every figure links live back to its source tab
- Built for board packs and investment committee memos
20. Checks
Trust the model before you send it. The Checks tab runs eighteen automated integrity tests — sources equal uses, balance sheet ties out, debt and cash roll forward correctly, no revenue before COD — so every number is provably right.
- Eighteen automated PASS/FAIL integrity checks, updated live
- Balance sheet, debt and cash roll-forward reconciliation verified
- BESS SOC limits, generation limits and COD timing checked
- One overall “ALL PASS” status before circulating the model
Why Buy This Solar + BESS Financial Model?
Save significant modelling time with a ready-built Solar + BESS Financial Model Template in Excel designed around the way utility-scale renewable energy projects are actually analysed. Instead of starting with a blank spreadsheet, you get an integrated 20-tab model covering construction, solar generation, BESS, dispatch, revenue, CAPEX, OPEX, financing, tax, DCF valuation, equity returns, sensitivities and model checks. With editable assumptions, a 30-year operating horizon, flexible battery configurations and automated financial checks, the template provides a professional foundation for evaluating project economics, testing investment scenarios and presenting a defensible Solar + BESS investment case.
Battery Storage Frequently Asked Questions (Faq)
What is a Solar + BESS financial model?
A Solar + BESS financial model is an Excel-based model used to forecast the technical, operational and financial performance of a solar photovoltaic project combined with Battery Energy Storage Systems (BESS). It brings together solar generation, battery dispatch, energy and ancillary revenues, CAPEX, OPEX, financing, tax and cash flow to calculate project and equity investment returns.
How long does this Solar + BESS financial model cover?
The model uses a monthly 384-period structure, comprising 18 months of construction, 6 months of commissioning and a 30-year operating period. The construction, commissioning and operating-life assumptions are editable, allowing the template to be adapted to different project requirements.
Can I model multiple BESS containers?
Yes. The BESS is designed as a flexible asset register, rather than a single fixed battery assumption. You can add or remove containers and assign individual MW, MWh, efficiency, degradation and augmentation assumptions. Fleet-level capacity and lifecycle calculations then update automatically.
Does the model include BESS degradation and augmentation?
Yes. The BESS model supports individual degradation assumptions and augmentation schedules for each battery container. This allows available MW and MWh capacity, battery performance and lifecycle CAPEX to change throughout the operating period.
Does the model include battery dispatch?
Yes. The BESS Dispatch tab models charging, discharging, state of charge, round-trip losses and equivalent full cycles. Solar-to-BESS charging and grid charging can also be separated within the model.
Does the model include a DCF valuation?
Yes. A dedicated DCF tab calculates unlevered free cash flow to the firm, Project NPV, Project IRR and discounted payback. The DCF is kept separate from the financing structure so that project valuation can be assessed independently of debt and equity.
Can I calculate Equity IRR?
Yes. The dedicated Equity Returns tab calculates levered equity cash flows, Equity IRR, Equity NPV, equity multiple (MOIC) and payback after considering debt financing, distributions and sponsor capital requirements.
Does the financial model include project debt?
Yes. The Debt Financing tab includes debt drawdowns, interest, principal repayments, debt sculpting and DSCR analysis. Senior debt can be sculpted to a target DSCR, with minimum and average DSCR and LLCR calculated within the model.
Can I test different Solar + BESS scenarios?
Yes. The model includes Downside, Base and Upside scenarios, together with live two-way sensitivity analysis. Key variables such as power price, CAPEX, leverage and WACC can be tested to understand their impact on Project IRR and Equity IRR.
Is the model suitable for lender or investment analysis?
The template is designed to provide a structured basis for project finance and investment analysis, with separate project-level DCF, equity returns, debt metrics and automated integrity checks. It can be used as a starting point for underwriting, investment committee analysis, lender analysis and financial presentations.
Does the model include construction CAPEX?
Yes. The Construction and CAPEX tabs model monthly capital expenditure during the construction period, including solar, BESS, grid connection, EPC, contingency and other project costs. Debt drawdowns, equity injections and capitalised interest are also incorporated.
Does the model include automated checks?
Yes. A dedicated Checks tab contains 18 automated integrity tests covering key areas including sources and uses, balance sheet reconciliation, debt and cash roll-forwards, BESS SOC limits, generation limits and COD timing.
Final Notes on the Financial Model
This 20 Year 18 month construction, 6 month commissioning and 30 year operations Solar + BESS Supplier Financial Model focuses on balancing capital expenditures with steady revenue growth from a diversified product line. By optimizing operational costs, and power efficiency, and maximizing high-margin sales, the models ensure sustainable profitability and cash flow stability.