Co-Located Solar + BESS Model | Shared-POI Constraint & ITC Qualification Test

Description
A hybrid solar-plus-storage project is not the solar project plus the battery project. Both assets sit behind one point of interconnection, so they compete for export capacity hour by hour. The battery's investment tax credit depends on where its charging energy comes from, and that is tested every year, not once at closing. A valuation built by adding two standalone forecasts together misses both constraints by construction.

This model prices the same project twice and reports the distance between the two numbers.

The first valuation is the sum of the parts: the solar farm at its own yield plus the battery at its own revenue stacking, added together as if they were two projects on two separate grid connections. That is what a developer deck shows. The second is the co-located reality: a single export limit capping combined output hour by hour, a battery that must charge mostly from the array to keep its credit, and inverter clipping as free charging energy but only in the hours when clipping actually exists.

The engine is a 12-month by 24-hour dispatch grid. For every month-hour combination the model computes how much export capacity is left after the solar array has taken its share, and that residual headroom is what the battery has to work with. The constraint bites in two distinct ways. The array itself is curtailed whenever its AC output exceeds the export limit. And the battery loses discharge hours precisely when it wants them most, because on a summer-peaking price curve some of the expensive hours arrive while the sun is still up. The model counts those hours explicitly.

The tax credit is treated as an annual test with a recapture ladder rather than a lump sum. Storage co-located with a renewable generator has historically qualified only when a minimum share of charging energy came from the generator rather than the grid, pro-rata above the threshold and zero below it, with credit already claimed clawed back if a disqualifying change happens during the vesting period. Switch grid charging on and the model shows the arbitrage gained, the credit at risk, the year the recapture lands, and how many years of extra arbitrage would be needed to repay it. That trade-off is what makes charging policy a financeable variable instead of a footnote.

Debt is then sized on each cash flow case using the same lender test, and the model answers the question a credit committee actually asks: if the sponsor's debt is drawn, what coverage does the real project deliver?

Ten sheets. Every input editable and highlighted. Every parameter either traced to a public source or flagged as a declared input with the band it should sit in. No macros, no external links, no structured tables: it opens in Excel, LibreOffice and Google Sheets. A five-page guide walks a real deal through it in order.
The threshold selector is not a legal statement and the price shape is not a forecast. The model tells you the consequence of a rule and a market you specify. What it contributes is the structure of the comparison.