Bankable Solar + BESS Financial Model

Introduction

Utility-scale renewable energy projects live or die by their financial models. Long before a single panel is installed or a battery container is delivered to site, a project's viability is tested, stress-tested, and negotiated inside a spreadsheet. Lenders size their debt off it. Sponsors calibrate their equity return expectations against it. Independent engineers and rating agencies pick it apart looking for optimistic assumptions or structural weaknesses.

The Solstice model was built to meet that standard: a fully linked, formula-driven, internationally bankable financial model for a utility-scale solar photovoltaic project paired with a Battery Energy Storage System (BESS), covering everything from first shovel in the ground through twenty-five years of commercial operation.

This is not a static projection or a set of hardcoded numbers dressed up to look like a model. Every cell that can be a formula is a formula. Every year is linked to the year before it. Change the PPA price, the interest rate, or the depreciation life in one place, and the effects ripple correctly through construction costs, tax calculations, debt sizing, cash flow, the balance sheet, and ultimately the investor returns — with the balance sheet still tying out to the cent. That internal consistency, more than any single number in it, is what makes a model "bankable."

The illustrative project underpinning the model is a 150 MWp / 100 MWac solar PV plant paired with a 50 MW / 200 MWh battery storage system, located in an emerging international solar market (the Atacama region of northern Chile is used as the illustrative jurisdiction, chosen deliberately to keep the model's tax and incentive structure globally applicable rather than tied to any one country's rules).

The model runs on an annual periodicity across a Year 0 construction period followed by twenty-five years of commercial operation — twenty-six columns of linked calculation running across every worksheet in the book.

The workbook itself is organized into fifteen interlinked tabs, each with a clear and single responsibility:

• Cover sheet for navigation and conventions


• Assumptions tab holding every technical, commercial, financing, and tax input as a clearly marked blue cell


• CapEx tab building up the full sources-and-uses of construction funds


• Production and Revenue tabs modeling solar generation, battery dispatch, and the resulting revenue streams


• OpEx tab for escalated operating costs


• Debt tab handling debt sizing and amortization


• Depreciation tab for tax calculations


• P&L, Cash Flow, and Balance Sheet tabs forming the core three-statement engine


• Returns tab summarizing the headline investment metrics


• Sensitivity tab for stress-testing


• Charts tab providing a visual dashboard


• Model Check tab that runs a suite of live integrity tests on the model every time it recalculates
  
  

Perhaps the single most important structural decision in the model is how debt gets sized. A naive approach — and one used in many simpler renewable energy models — sizes debt as a flat percentage of construction cost (a "gearing cap") and then checks, almost as an afterthought, whether the resulting debt service coverage ratio clears the lender's covenant. That approach gets the mechanics backwards. In real project finance, debt capacity is a function of the cash flow available to service it, not the other way around.

The Solstice model instead implements true DSCR sculpting. For every operating year, it calculates a "Sizing CFADS" — cash flow available for debt service — using a deliberately conservative version of the project's cash flow that strips out the interest tax shield entirely, precisely so that the calculation does not become circular (debt size would otherwise depend on interest expense, which depends on debt size). From that Sizing CFADS series, the model computes the annual debt service the project could sustain while holding a constant target DSCR, discounts that payment stream back to present value at the cost of debt, and arrives at a debt capacity figure. The actual debt drawn is the lesser of that DSCR-sculpted capacity and a maximum gearing cap set by the sponsor — with the model showing explicitly, in a labeled cell, which constraint is binding in any given scenario.

When gearing binds, the DSCR comes out comfortably above target, exactly as a well-structured deal should. When the DSCR constraint binds instead, the model's internal scaling factor lands precisely at 1.0, confirming the sculpting math is self-consistent — a check that is itself one of the automated tests on the Model Check tab.

Two further metrics that any international lender's term sheet will demand are the Loan Life Cover Ratio (LLCR) and the Project Life Cover Ratio (PLCR) — the net present value of future cash flow available to service debt, measured respectively over the remaining loan tenor and over the full remaining project life, each divided by the outstanding debt balance at financial close. Both are computed directly in the model and checked against configurable minimum covenants, alongside the more familiar annual DSCR.

Underpinning all of this is an explicit treatment of energy production uncertainty. Solar resource assessments are never expressed as a single number in professional practice; they are expressed as exceedance probabilities — P50 (the median expected outcome), P90 (the output level exceeded in ninety years out of a hundred), and P99 (an even more conservative downside case). The model lets the user select which of these three cases drives debt sizing through a simple dropdown, while the base-case revenue and equity return calculations always remain anchored to the P50 outcome. This mirrors exactly how a real transaction is structured: sponsors and their equity investors think in terms of the expected case, while senior lenders size their exposure off a deliberately conservative downside case, creating a cushion between the two.

An earlier design pass through this model included several distinctly American tax constructs — accelerated MACRS depreciation schedules and the federal Investment Tax Credit chief among them. Both have been deliberately removed. In their place, the model now uses a generic straight-line depreciation convention over a configurable asset life, alongside a configurable tax holiday period — a far more common and internationally recognizable incentive structure used across many emerging solar markets. The corporate tax rate itself is treated as a jurisdiction-specific input rather than defaulting to a U.S. statutory figure. The result is a model whose tax and incentive architecture can be redirected to almost any target jurisdiction by changing a handful of assumption cells, rather than one whose fundamental calculation logic is implicitly tied to a single country's tax code.

A financial model that cannot prove its own internal consistency is not a bankable model, no matter how sophisticated its formulas look. The Model Check tab treats validation as a feature in its own right rather than an afterthought. Fourteen live, formula-driven tests run automatically:

• Sources equal uses of funds at financial close


• The balance sheet ties out to the cent across all twenty-six years


• The debt schedule fully amortizes to zero by maturity


• The minimum operating-year DSCR clears its covenant


• Accumulated depreciation fully exhausts the depreciable basis on schedule


• Retained cash under the model's dividend policy nets to zero outside of two clearly-flagged and expected exceptions (the initial funding of the debt service reserve account and the lump-sum battery augmentation event)


• Both cover ratios clear their respective covenants


• The DSCR sculpting mechanism is shown to be internally coherent
  
  

Every test reports PASS, FAIL, or WARN with color-coded conditional formatting and a single overall status banner, so a reviewer can tell at a glance — without reading a single formula — whether the model is structurally sound.

The model's Charts tab distills its results into a KPI dashboard and seven native, fully linked Excel charts:

• Revenue composition by year


• EBITDA against net income


• Sources and uses of capital


• The debt balance running alongside its DSCR on a secondary axis


• The cumulative equity cash flow curve showing the investment payback point


• The year-by-year production profile split between solar and battery discharge
  
  

Every chart recalculates automatically as assumptions change, and the workbook has been formatted for clean, presentation-ready PDF export — with print titles, appropriately scaled paper sizes, and repeating label columns so that even the widest twenty-six-year statements print legibly across multiple pages rather than collapsing into illegible text on a single sheet.

The Solstice model is offered as a demonstration of what a genuinely bankable renewable energy financial model looks like under the hood: not a black box of hardcoded assumptions, but a transparent, fully-linked calculation engine built around the same debt sizing logic, cover ratio discipline, and energy certainty framework that international lenders, multilateral development banks, and export credit agencies actually require before they will commit capital to a project.

It is intended as a flexible starting point — every blue input cell is a lever the user is free to pull to reflect a different market, a different capital structure, or a different technology mix — resting on a calculation architecture that has been deliberately built to hold together under that kind of scrutiny.