A floor is priced by what it gives up in good years and valued by the debt it releases in bad ones. The lender sizes on the downside, so that is where the contract pays.
A $100 a kW-year revenue floor, with 50% of revenue above $120 given to the floor provider, costs a 100 MW battery $0.35m a year in expected revenue but raises debt capacity from $42.04m to $56.05m at a 1.30x low-case cover. Expected equity IRR rises from 13.7% to 15.5% and the low-price case from −6.7% to 1.9%.
| Item | Value |
|---|---|
| Battery | 100 MW / 400 MWh, capex $80.0m ($800 a kW) |
| Merchant revenue | $80, $130 or $190 a kW-year in a low, base or high price case, with probabilities of 30%, 50% and 20% |
| Operating cost | $20 a kW-year, $2.0m a year |
| Floor contract | Floor of $100 a kW-year; above $120 the owner keeps 50% of the extra revenue |
| Debt | 15-year annuity at 7.0%, sized so the low-case cash flow covers debt service 1.30 times |
| Equity return | 15 years of flat cash flows, no residual value, no degradation |
The annuity factor for 15 years at 7.0% is (1 − 1.07−15) ÷ 0.07 = 9.108. The lender gives no credit to revenue above the low case, which is why a floor changes the loan.
Owner revenue = R if R is between the floor and $120, the floor if R is below it, and 120 + 50% × (R − 120) above $120
Low case: merchant $80 is lifted to $100. Base case: 120 + 0.5 × (130 − 120) = $125. High case: 120 + 0.5 × (190 − 120) = $155
Excel, price in B6, floor in B2, threshold in B3, owner share in B4: =IF(B6<$B$2,$B$2,IF(B6<=$B$3,B6,$B$3+(1-$B$4)*(B6-$B$3)))
| Case | Probability | Merchant | With floor |
|---|---|---|---|
| Low price | 30% | 80 | 100 |
| Base price | 50% | 130 | 125 |
| High price | 20% | 190 | 155 |
| Expected revenue | 127.0 | 123.5 |
The floor costs 3.5 a kW-year in expected revenue, 0.35m a year across 100 MW, or 2.8% of expected merchant revenue. In exchange the low case rises by $20 a kW-year and the high case falls by $35.
Merchant: low-case cash flow (80 − 20) × 100,000 kW = $6.0m; debt service = 6.0 ÷ 1.30 = $4.615m; debt = 4.615 × 9.108 = $42.04m
With floor: (100 − 20) × 100,000 kW = $8.0m; debt service = 8.0 ÷ 1.30 = $6.154m; debt = 6.154 × 9.108 = $56.05m
Extra debt: 56.05 − 42.04 = $14.01m, which cuts the equity cheque from $37.96m to $23.95m
Excel, annuity debt from the low-case cash flow in B10: =B10/1.3*(1-1.07^-15)/0.07
Debt rises from 52.5% to 70.1% of capex. The extra $14.01m of debt costs $1.538m a year more in debt service, against a floor that costs $0.35m a year in expected revenue.
| Case | Merchant equity IRR | With floor equity IRR |
|---|---|---|
| Low price | −6.7% | 1.9% |
| Base price | 14.7% | 16.2% |
| High price | 32.1% | 30.1% |
| Probability-weighted cash flow | 13.7% | 15.5% |
The floor lifts the low-case IRR from −6.7% to 1.9% and the expected IRR from 13.7% to 15.5%. The high case falls from 32.1% to 30.1%. Most of the gain in expected IRR comes from the smaller equity cheque, not from the revenue protection itself.
| Case | Expected revenue, $/kW-yr | Cost vs merchant, $m a year | Debt, $m | Expected equity IRR | Low-case IRR |
|---|---|---|---|---|---|
| No floor, merchant | 127.0 | 0.00 | 42.04 | 13.7% | −6.7% |
| Floor $100, 50% above $120 (base) | 123.5 | 0.35 | 56.05 | 15.5% | 1.9% |
| Floor $90, 50% above $120 | 120.5 | 0.65 | 49.04 | 12.5% | −2.9% |
| Floor $110, 50% above $120 | 126.5 | 0.05 | 63.05 | 20.7% | 8.8% |
| Floor $100, 40% above $120 | 125.4 | 0.16 | 56.05 | 16.4% | 1.9% |
| Floor $100, 60% above $120 | 121.6 | 0.54 | 56.05 | 14.5% | 1.9% |
A $90 floor costs $0.65m a year and adds $7.01m of debt; a $110 floor costs $0.05m and adds $21.02m. Each extra $10 of floor adds $7.01m of debt, and a higher floor costs less here because only the low case ever falls below it. The sharing percentage does not change the debt, only the cost of the contract: 40% costs $0.16m a year and 60% costs $0.54m. A $90 floor is the one case that lowers expected equity IRR, to 12.5%. The model ignores the provider’s credit, any fee for the floor and degradation.
In expected value, 3.5 a kW-year here, $0.35m a year on 100 MW. The owner gains $20 in the low case and gives up $35 in the high case.
Because lenders size on the low case. Raising low-case revenue from $80 to $100 a kW-year lifts low-case cash flow from $6.0m to $8.0m and debt from $42.04m to $56.05m at 1.30x.
No. Expected IRR rises from 13.7% to 15.5% mainly because the equity cheque falls, but the high-price case drops from 32.1% to 30.1%.
The free companion files for The Battery Storage Development Handbook value a fictional 200 MW / 800 MWh battery under merchant, toll and floor cases, with degradation, augmentation, the investment credit, the foreign entity test and debt. The figures in this article use invented inputs and are not in them. No account and no email address.
Not on Amazon: 19 paperbacks by Julian R. Sterling on energy, infrastructure and land, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: infrastructure, data centres and energy → · All 1908 articles →