A detailed, institutional-grade solar BESS financial model for an off-grid solar project paired with a Battery Energy Storage System — covering construction, operations and decommissioning across thirteen linked sheets, with battery dispatch mechanics, a full senior and subordinate debt structure, LCOE and complete lender covenants.

Adding storage to a solar project changes the financial model fundamentally, and most templates simply do not account for it. A battery is not a solar panel with a different name. Energy goes in and less comes out, because round-trip efficiency takes a cut on every cycle. Capacity is bounded by cycles per day and an availability factor. The asset degrades on its own curve and must be replaced as a substantial capital outflow — often while the debt is still outstanding.

This solar BESS financial model handles all of it explicitly. Generation splits between direct consumption and energy sent to storage. Round-trip efficiency is applied after transmission and distribution losses. Maximum storage per period is derived from battery capacity, availability factor, degradation and daily cycles — and only then is energy recovered from the batteries added to direct supply to establish what you can actually bill.

Around that engine sits a genuinely complete project finance structure — Project and Equity IRR and NPV, DSCR, LLCR and PLCR for both senior and subordinate debt, gearing ratios, equity payback, LCOE, a full cash waterfall and integrated financial statements on both periodic and annual bases.

Billable Energy: Supply Meets Demand

Most renewable models assume everything generated is sold. Off-grid does not work that way, and neither does this one. The model calculates the off-taker’s actual energy demand from contracted capacity and load factor, calculates net available supply from solar plus recovered battery energy, and bills the lesser of the two.

That single piece of logic is what makes the model honest. Oversize the plant and you generate energy nobody pays for. Undersize it and you incur an unserved energy penalty — priced per kWh with a cap set as a percentage of period revenue. For a system contracted to keep the lights on, that asymmetry is the central commercial risk, and it is modelled rather than assumed away.

Battery Capex and the Replacement Reserve

Storage capital cost is not one number. This solar BESS financial model separates the battery pack, battery management system, inverter and charger, energy management and control software, and installation and integration — each an individual input, so you can enter real supplier quotes rather than a blended estimate.

A dedicated BESS replacement reserve is then built from battery capex at construction and assumed battery life. The provision accrues through the operating period and the actual replacement expense lands when it falls due — both flowing separately through free cash flow. Battery replacement is the cost that quietly destroys returns in models that ignore it; here a lender can see the cash being set aside for it.

A Financing Structure Built for Lenders

The funding module is where this model separates itself from anything at a comparable price. Senior debt is priced on SOFR plus margin, with arrangement and commitment fees modelled separately, and is sized from your minimum DSCR — the model computes maximum permissible debt rather than leaving you to iterate toward it. Subordinate debt runs alongside with its own tenor, pricing, repayment profile and a complete covenant suite of its own.

Refinancing is built in, with its own tenure, repayment dates, interest rate and arrangement fees, so you can model taking out construction debt with cheaper operational-phase debt. An Equity Bridge Loan lets you defer equity injection through construction and watch the effect on Equity IRR. DSRA accounts for both debt tranches are sized by the number of periods you specify.

Equity drawdown itself carries three scenarios — equity first, debt first, or pro-rata funding proportion — each producing a materially different IRR. Interest during construction, bank fees, EBL charges and construction-phase VAT all capitalise into the funding requirement, with a macro breaking the resulting circularity at the click of the Optimisation button.

Assumptions You Control

Every driver of viability is an explicit input, with Base, Management and Upside cases on every revenue and cost line:

Lender & Investor Outputs

• Project IRR & NPV and Equity IRR & NPV, with a full WACC build-up
• Levelised Cost of Energy (LCOE) — built from construction capex, variable and fixed O&M and the BESS replacement provision, against NPV of net generation
• DSCR, LLCR and PLCR — minimum, maximum and average, calculated separately for senior and subordinate debt
• Gearing ratios — minimum, maximum and average across the debt structure
• Equity payback period and cumulative free cash flow to equity
• Cash waterfall & debt service profile — CFADS through to distributions
• Financial statements on two bases — periodic and annual, income statement, balance sheet and cash flow
• Dashboard — scenario selectors, return snapshot, DSCR and PLCR speedometers, and a ten-year graphical forecast

Scenarios Switched from the Dashboard

Six independent selectors sit on the dashboard: the revenue and cost case, the debt drawdown scenario, senior debt repayment profile, refinanced debt repayment profile, subordinate debt repayment profile, and depreciation method. Change any one and the returns, covenants and statements update together. That means you can test how a sculpted senior tranche paired with an annuity subordinate tranche affects minimum DSCR — the kind of question that usually requires rebuilding a model, answered here in a click.

Built to Audit Standard

Thirteen sheets, colour-coded by function — inputs, calculations, outputs and information — with consistent cell styles distinguishing every input, calculation and total. A dedicated Checks sheet runs arithmetic and logical tests, and each sheet carries its own model check and sheet check in fixed cells, so an error announces itself immediately rather than hiding. A Read Me sheet documents the model map, cell styles, abbreviations and macro guidance. This is a file you can hand to a lender’s technical adviser.

Who This Solar BESS Financial Model Is For

• Off-grid and microgrid developers building the case for a solar-plus-storage system
• Renewable energy investors assessing hybrid returns and structuring equity, subordinate debt and refinancing
• Mining, industrial and remote site operators evaluating captive power against diesel
• Lenders and debt advisors sizing debt from a target DSCR and testing the replacement reserve
• Project finance advisors preparing bankable models for financial close

What’s Included

• Excel financial model — thirteen sheets in binary format (.xlsb) for speed and stability
• Macro documentation — a Word document setting out the VBA code used, for your reference

Why This Model

New to these metrics? Read an overview of the debt service coverage ratio. For a model built to your own specification, see our project finance advisory services, or browse the full range of PPP and project finance templates.