Project Finance, Renewable Energy & Tax-Equity Structuring
Renewable Tax-Equity Partnership Flip PTC & Cash Formula
Calculate Utility-Scale Renewable Tax-Equity Partnership Flip Gross Production Tax Credits ($M), Pre-Flip 99% Investor Tax Benefit ($M), and Post-Flip 5% Safe-Harbor Residual Cash Split ($M).
Respect Rev. Proc. 2007-65 safe-harbor bounds: >=1% pre-flip sponsor share and >=5% post-flip investor floor!
Because project-level wind and solar SPVs rarely have enough current federal tax appetite to monetize Production Tax Credits (PTCs) and 5-year MACRS accelerated depreciation on their own, developers form a Yield-Based Tax-Equity Partnership Flip with an institutional tax-equity investor. Under IRS Rev. Proc. 2007-65 safe-harbor rules, the developer sponsor must retain at least 1% of pre-flip tax items (capping Investor Pre-Flip Tax Allocation at <= 99%), and once the investor hits its target after-tax IRR flip hurdle, the investor’s residual profit/cash share steps down to no less than 5% (leaving <= 95% of post-flip operating cash flow to the sponsor until a fair-market-value buyout option is exercised).
Verify on a 150 MW Wind Farm SPV—Annual_Net_Generation = 500 GWh (500,000 MWh/yr, B2), PTC_Rate = $28.00/MWh (B3 -> Gross Annual PTC = 500,000 * 28 / 10^6 = $14.00M in E2), Annual_MACRS_Deduction = $24.00M (B4) at Investor_Tax_Rate = 0.25 (25.0%, B5 -> $6.00M depreciation tax shield; $20.00M gross tax benefit), Pre_Flip_Investor_Alloc = 0.99 (99.0%, B6), and Post_Flip_Distributable_Cash = $18.00M/yr at a 5.0% post-flip investor floor (B7): Pre-Flip Investor Annual Tax Benefit equals 0.99 * (14.00 + 6.00) = $19.80M (E3), Post-Flip Investor 5% Cash Share is $0.90M/yr (E4), and Post-Flip Sponsor 95% Cash Share jumps to $17.10M/yr (E5)!
| Partnership Flip Metric (500 GWh, $28/MWh PTC, $24M MACRS, 99%/5% Flip) | Formula | Verified Output |
|---|---|---|
| Gross Annual PTC Generated ($M) | (Net_GWh * 1000 * PTC_Per_MWh) / 10^6 | $14.00M ($11.20M @ 400 GWh) |
| Pre-Flip Investor Tax Benefit ($M) | Pre_Flip_Share * (Gross_PTC + MACRS * Tax_Rate) | $19.80M ($17.03M @ 400 GWh) |
| Post-Flip Investor 5% Cash ($M) | 0.05 * Post_Flip_Distributable_Cash | $0.90M |
| Post-Flip Sponsor 95% Cash ($M) | 0.95 * Post_Flip_Distributable_Cash | $17.10M |
Safe-Harbor Pre-Flip Tax Benefit Allocation Formula
Validate Generation_GWh > 0, PTC_Rate >= 0, MACRS_Deduction >= 0, Tax_Rate in (0, 0.55), Pre_Flip_Investor_Share in [0.50, 0.99] (enforcing >= 1% sponsor interest!), and Post_Flip_Cash >= 0! Ask a hint-first prompt before coding: "Check my Rev. Proc. 2007-65 partnership-flip guard—why must Pre_Flip_Investor_Alloc be capped at 0.99 rather than 1.00?"
=LET(gn_g, B2, pt_r, B3, mc_d, B4, tx_r, B5, pf_s, B6, cf_p, B7, IF(OR(gn_g <= 0, pt_r < 0, mc_d < 0, tx_r <= 0, tx_r >= 0.55, pf_s < 0.5, pf_s > 0.99, cf_p < 0), "Invalid Partnership Flip Input", LET(pt_m, gn_g * pt_r / 1000, sh_m, mc_d * tx_r, ROUND(pf_s * (pt_m + sh_m), 2))))P90 Low-Wind Generation Flip-Delay Stress Check (Set Generation = 400 GWh)
Drop Annual_Net_Generation B2 from 500 GWh to a P90 low-wind year of 400 GWh: Gross PTC E2 falls to $11.20M and Pre-Flip Investor Tax Benefit E3 drops to 0.99 * (11.20 + 6.00) = $17.03M—delaying the date the investor reaches its target flip IRR! Also test B6 = 1.00 (100% allocation violating the 1% sponsor safe-harbor minimum) to trigger the guard!
=IF(ISTEXT(E3), E3, ROUND(0.95 * B7, 2))Try the example
Use the original values or change them to test your understanding.