Tax Equity Model in Excel: Build a Solar Partnership Flip (2026)

June 15, 2026 · VeloraAI Team
Financial Modeling Excel Formulas

The U.S. renewable energy industry deployed over $60 billion in tax equity in 2025, and the partnership flip remains the dominant structure even after the Inflation Reduction Act introduced credit transferability. Yet most analysts asked to build their first tax equity model in Excel discover the hard way that the mechanics look nothing like a normal project finance model. You are not just sculpting debt — you are tracking two parallel sets of books (tax and GAAP), allocating credits and losses under IRC §704(b), enforcing deficit restoration obligations, and solving for an IRR-based "flip" date that bends the entire cash waterfall.

This guide walks through a complete solar partnership flip model from a blank workbook to a working flip-date solver. We cover the legal structure, ITC vs PTC trade-offs under the 2026 IRA framework, capital account mechanics, HLBV accounting, and the Excel formulas that hold it all together.

What Is a Tax Equity Partnership Flip?

A tax equity partnership flip is a joint venture between a project Sponsor and a Tax Equity Investor (TEI) where the TEI funds part of the project's capital cost in exchange for the lion's share of tax benefits — the Investment Tax Credit (ITC) or Production Tax Credit (PTC) plus accelerated MACRS depreciation. Allocations "flip" once the TEI hits a target after-tax yield.

In a typical 99/5 partnership flip:

  • Pre-flip: TEI gets 99% of tax credits, losses, and a small share of cash (often 2-5%). Sponsor gets 1% of taxes and the rest of cash.
  • Flip event: TEI achieves its target after-tax IRR (usually 6.5%-8.5% for solar ITC deals, 7%-9% for PTC wind deals).
  • Post-flip: TEI's allocation drops to 5%. Sponsor takes 95% of everything going forward and often has a buyout option at fair market value.

ℹ️ Note: The 99/5 nomenclature refers to the pre-flip / post-flip TEI allocation percentages. Cash sharing during the pre-flip period is typically much smaller than 99% — the TEI primarily monetizes tax benefits, not operating cash.

Why does this structure exist?

Most renewable developers cannot use the tax credits themselves — they do not have enough taxable income to absorb a $30 million ITC in Year 1, or 10 years of PTCs against a small balance sheet. A bank, insurer, or large corporate with tax appetite contributes capital and "buys" the credits through the partnership, then exits after the recapture period.

graph TD
    A[Sponsor: Developer] --> B[Project LLC<br/>Partnership]
    C[Tax Equity Investor] --> B
    B --> D[Solar/Wind Project]
    D --> E[Operating Cash Flow]
    D --> F[Tax Credits + Depreciation]
    E --> G[Pre-flip: 95% Sponsor / 5% TEI cash]
    F --> H[Pre-flip: 1% Sponsor / 99% TEI tax]
    G --> I[Flip Event: TEI hits Target IRR]
    H --> I
    I --> J[Post-flip: 95% Sponsor / 5% TEI - all items]

How Do You Build a Tax Equity Model in Excel?

A clean tax equity model has eight tightly-linked tabs: assumptions, timeline, project cash flow, tax depreciation, ITC/PTC schedule, partnership allocations, capital accounts, and the IRR solver. Each feeds the next, and the entire model converges on one number — the flip date that triggers reallocation.

Module 1: Timeline and Operating Period

Tax equity flip models generally run quarterly for the first 6-10 years (to track ITC recapture, depreciation, and the flip event precisely) and may stretch annual to year 30+ for terminal value.

Set up Row 5 as period numbers (1, 2, 3...) and Row 6 as period-end dates:

=EOMONTH(prior_date, 3)

Then create three flag rows:

=IF(period_date <= COD, 1, 0)                                    // Construction flag
=IF(AND(period_date > COD, period_date <= COD+5*4), 1, 0)        // ITC recapture window (5 yrs)
=IF(period_date > COD, 1, 0)                                     // Operations flag

These flags switch revenue, depreciation, and credit timing on and off across the model.

Module 2: Project Cost and Eligible Basis

For a 100 MW solar PV project priced at $1,200/kW DC:

  • Total project cost: $120 million
  • ITC-eligible basis: $115 million (excludes interconnection above a threshold, capitalized interest after PIS, and certain land costs)
  • Tax basis after ITC: Eligible basis − 50% of ITC

Under the 2026 IRA rules, the base ITC is 30% for projects meeting prevailing wage and apprenticeship requirements, with adders of 10% domestic content and 10% energy community — a stacked credit can reach 50%.

=eligible_basis * itc_rate * itc_realized_flag

💡 Pro Tip: Always model the ITC as a separate line item from the tax basis adjustment. The IRS requires the partnership to reduce depreciable basis by 50% of the ITC claimed — this is the "basis adjustment" that most first-time modelers forget and that breaks every downstream capital account.

ITC vs PTC: Which Credit Should the Model Use?

The Investment Tax Credit (ITC) is a one-time credit equal to 30%+ of eligible project cost, claimed in Year 1, with a 5-year recapture cliff. The Production Tax Credit (PTC) is an inflation-adjusted per-kWh credit claimed over 10 years on actual energy production. Solar projects typically choose ITC; large wind projects often prefer PTC.

Feature ITC (Section 48E) PTC (Section 45Y)
Credit form 30%+ of eligible basis, Year 1 $0.0275/kWh × 10 years (2026, indexed)
Better for High-cost / low-yield projects (rooftop solar, storage) High-yield / low-cost projects (utility wind)
Recapture 5-year vesting, 20%/yr None
Flip date Often fixed date (Year 5-6) IRR-based (variable)
Basis reduction Yes — 50% of credit No
Bonus adders Domestic content, energy community, low-income Domestic content, energy community
Modeling complexity Higher (capital accounts swing) Moderate (10-yr stream)

For our walkthrough we use ITC because the capital account mechanics are richer and the flip mechanics are more interesting. Switching the same model to PTC requires only swapping the credit schedule and updating the flip trigger from a date to an IRR target.

graph TD
    A[Project Sponsor] --> B{ITC or PTC?}
    B -->|Solar, Storage,<br/>Lower output| C[ITC: 30%+ Day-1 Credit]
    B -->|Wind, High output,<br/>Bonus depreciation| D[PTC: $/kWh over 10 years]
    C --> E[Fixed-Date Flip<br/>Year 5-6]
    D --> F[Yield-Based Flip<br/>Target IRR]
    E --> G[Recapture risk:<br/>20%/yr vest]
    F --> H[Production risk:<br/>resource variability]

⚠️ Warning: Do not assume the TEI will always pick the higher-credit option. PTC is often preferred for wind because TEIs can monetize the 10-year stream against their own tax appetite more smoothly than a single-year ITC, and the absence of recapture reduces credit insurance cost.

How Do You Model the ITC and MACRS Depreciation?

The ITC hits the tax return in the year the project is placed in service. 5-year MACRS (with 60% bonus depreciation in 2026 under the IRA phasedown) drives the bulk of the tax shield, and the basis adjustment for ITC reduces depreciable basis by half the credit claimed.

MACRS schedule with bonus depreciation

The 2026 5-year MACRS half-year convention table:

Year Bonus (60%) Remaining Basis (40%) on MACRS Total Year %
1 60.00% 8.00% 68.00%
2 0% 12.80% 12.80%
3 0% 7.68% 7.68%
4 0% 4.61% 4.61%
5 0% 4.61% 4.61%
6 0% 2.30% 2.30%
Total 60.00% 40.00% 100.00%

In Excel, calculate annual depreciation as:

=depreciable_basis * INDEX(macrs_table, YEAR(period)-cod_year+1, 1)

Where depreciable_basis = eligible_basis - 0.5 * ITC_claimed.

Example: A $115M eligible-basis solar project with a 30% ITC has $34.5M of credits and a $115M − $17.25M = $97.75M depreciable basis. Year 1 depreciation = $97.75M × 68% = $66.5M.

Why this matters for the partnership

That Year 1 combination — $34.5M ITC + $66.5M depreciation — is exactly what the TEI is buying. At a 21% federal corporate tax rate, $66.5M of depreciation is worth $13.97M, plus the $34.5M credit, equals $48.47M of tax value in Year 1 alone. The TEI funds a contribution sized to deliver its target after-tax IRR off that stream.

Building the Partnership Allocation Layer

The §704(b) allocations governed by the LLC agreement determine how each item flows to each partner. Build a section that allocates revenue, expenses, depreciation, ITC, and cash distributions period-by-period, switching from pre-flip to post-flip percentages when the flip event hits.

Pre-flip vs post-flip switch

Create a single flag cell flip_flag that is 0 before the flip and 1 after. Then every allocation uses:

=IF(flip_flag=0, pre_flip_pct, post_flip_pct) * total_item

For TEI allocations:

TEI_taxable_income = IF(flip_flag=0, 99%, 5%) * partnership_taxable_income
TEI_cash           = IF(flip_flag=0, 2%, 5%)  * cash_available_for_distribution
TEI_ITC            = IF(flip_flag=0, 99%, 5%) * total_ITC

💡 Pro Tip: Build the flip flag using SUMPRODUCT(prior_periods * cumulative_irr_flag) rather than a hard-coded date. That way, when assumptions change, the flip date automatically moves to the period where the TEI hits its target IRR.

Calculating the flip date

The flip occurs in the first period where the TEI's running after-tax IRR equals or exceeds the target (e.g., 7.5%). In Excel:

=IF(AND(prior_flip=0, XIRR(tei_aftertax_cf_to_date, dates_to_date) >= target_irr), 1, 0)

Once a 1 appears, drag the flag forward with =MAX(prior_period_flip, current_flip) so the partnership stays "flipped" through the rest of the model.

Capital Accounts and the HLBV Framework

Every flip model must track each partner's §704(b) "book" capital account and outside tax basis. The book capital account governs the §704(b) economic safe-harbor; outside basis governs whether a partner can actually deduct losses. Under HLBV (Hypothetical Liquidation at Book Value), GAAP income is allocated as the period-over-period change in each partner's claim on book equity if the partnership liquidated at book.

Book capital account roll-forward

For each partner, period by period:

Beginning Book Capital
+ Capital contributions
+ Allocated book income (revenue – expenses – book depreciation)
+ Allocated ITC (added back into book capital for §704(b))
- Cash distributions
= Ending Book Capital

The Excel formula for the TEI's ending book capital:

=prior_period_book_capital
 + tei_contribution
 + tei_pct * book_income
 + tei_pct * itc
 - tei_distributions

⚠️ Warning: Stop-loss allocations kick in once a partner's book capital reaches zero. If the TEI has no Deficit Restoration Obligation (DRO), losses that would push their capital below zero get re-allocated to the Sponsor. This is the single most common modeling error — losses pile onto Sponsor mid-life and the flip date moves materially.

Outside basis and at-risk

Outside basis is the tax-law cousin of book capital and limits the partner's ability to deduct losses (§704(d)) and recognize tax credits (§50). Track it with a separate roll-forward that uses tax depreciation (not book) and adjusts for the 50% ITC basis reduction.

Outside Basis
+ Cash contributions
+ Allocated taxable income
+ Allocated nonrecourse debt share (§752)
- Cash distributions
- Allocated tax losses
- 50% × ITC claimed (basis reduction)
= Ending Outside Basis

If outside basis goes to zero, the partner cannot deduct further losses until basis is restored — those are suspended losses that carry forward.

How Do You Solve for the Flip Date in Excel?

Use a helper column that computes the TEI's running after-tax IRR through each period. The flip flag turns on at the first period where running IRR ≥ target. Build the IRR solver with XIRR for accurate dating, and use an iterative MAX function to lock the flag once triggered.

Step-by-step flip solver

  1. Build the TEI after-tax cash flow stream row by row:

    TEI_ATCF = -tei_contribution + tei_cash + tax_rate * tei_taxable_loss + tei_itc

    (Initial contribution is negative; ITC is a credit received in Year 1.)

  2. Build a running XIRR column. In each period column, compute:

    =IFERROR(XIRR(OFFSET(tei_atcf_start, 0, 0, 1, COLUMN()-start_col+1),
              OFFSET(date_start,     0, 0, 1, COLUMN()-start_col+1)), 0)

  3. Create the flip flag in a row below:

    =IF(MAX(prior_flip_cells)=1, 1, IF(running_irr >= target_irr, 1, 0))

  4. Drag all allocation rows to switch their percentages on the flag.

This creates a single closed-loop model where changing any assumption — credit rate, capex, generation, cash sweep — instantly reshapes the flip date.

ℹ️ Note: Excel's circular reference warning will fire here because the flip date affects allocations which affect IRR which affects the flip date. Enable iterative calculation: File → Options → Formulas → Enable iterative calculation (Max iterations: 100, Max change: 0.001).

Cash Waterfall and Distribution Schedule

The cash waterfall ranks distributions: O&M and project debt first, then a small Preferred Return to the TEI (often 2% of contribution), then pre-flip residual cash 95/5 to Sponsor/TEI, then post-flip 95/5 to Sponsor/TEI with optional Sponsor buyout in Year 10-15.

A typical solar partnership cash waterfall:

  1. Operating expenses (O&M, insurance, property tax) — 100% to project
  2. Senior debt service — if back-leveraged at the partnership or holdco level
  3. TEI preferred return — 2.00% of unreturned capital, paid quarterly
  4. Pre-flip residual cash — 95% Sponsor / 5% TEI
  5. Post-flip distribution — 95% Sponsor / 5% TEI (with full sweep mechanics in some deals)
  6. Sponsor buyout — optional at FMV between Year 10-15

In Excel, model each waterfall tier as its own row with MIN(available_cash, tier_target) cascading downward:

Tier1_O&M_paid     = MIN(available_cash, opex)
Tier2_debt_paid    = MIN(available_cash - Tier1, debt_service)
Tier3_pref_paid    = MIN(available_cash - Tier1 - Tier2, tei_pref_target)
Tier4_residual_TEI = MAX(0, available_cash - Tier1 - Tier2 - Tier3) * tei_residual_pct

Common Pitfalls That Break Tax Equity Models

Even experienced modelers stumble on the same five issues. Watch for these explicitly during model review.

1. Forgetting the 50% ITC basis reduction

Under §50(c)(3), the depreciable basis must be reduced by half the ITC claimed. Skip this and Year 1 depreciation is overstated by ~17%, which inflates the loss allocation, accelerates capital account erosion, and pushes the flip date too early.

2. Mishandling DRO and stop-loss allocations

A TEI typically has a limited DRO (often capped at 20-25% of the original contribution) or no DRO at all. When book capital approaches zero, the model must stop allocating losses to the TEI and re-allocate to the Sponsor. Build a LossLimit cell:

=MIN(allocated_loss, max_loss_before_zero_capital)

3. Ignoring outside basis for credit and loss deductions

A partner cannot recognize tax credits in excess of outside basis. If your TEI contribution is small relative to the ITC, you may run into §49 at-risk limitations. Always cross-check that ITC ≤ outside basis at Year 1.

4. Modeling ITC recapture incorrectly

The ITC vests 20% per year over 5 years. If the project is sold, materially altered, or fails the safe-harbor before Year 5, the unvested portion is recaptured — added back to tax liability. Model recapture as a contingent line item, even if you do not expect it to fire.

5. Using IRR instead of XIRR for the flip solver

The flip target is almost always an annualized after-tax IRR, and quarterly cash flows are not evenly spaced (different days per quarter). Use XIRR with actual period-end dates. Using IRR with quarterly periods can shift the flip date by 1-2 quarters and materially mis-size the TEI's investment. For a full breakdown of this annualization error — and how the same day-count mismatch affects PE fund returns and project finance models — see our guide to IRR vs XIRR vs MIRR in Excel.

Sample TEI Sizing Calculation

To put numbers on the structure, here is a worked example for a 100 MW solar ITC project under 2026 rules.

Line item Value
Project cost $120,000,000
Eligible basis $115,000,000
ITC rate (30% base + 10% domestic content) 40%
Total ITC $46,000,000
Depreciable basis ($115M − 0.5 × $46M) $92,000,000
Year 1 depreciation (68%) $62,560,000
TEI target after-tax IRR 7.25%
TEI tax rate 21%
TEI sizing (PV of credits + tax shield + cash at 7.25%) ~$48,500,000
Sponsor equity + back-leverage $71,500,000
Modeled flip date Year 6 Q2

The TEI contributes ~40% of project cost and receives ~$46M of ITC plus ~$13M of depreciation tax shield in Year 1, hitting their target IRR roughly 5.5 years after PIS. This is a representative deal — actual sizing varies by credit stacking, generation, and tax appetite.

How VeloraAI Speeds Up Tax Equity Modeling

Tax equity models are dense with circular references, period-by-period allocations, and IRS-driven rules that change every few years. VeloraAI can generate the §704(b) allocation block from a plain-English description, surface stale macros and broken capital account roll-forwards during model audit, and run sensitivity analysis on the flip date across credit stacking and capex scenarios — all without leaving Excel. Combine it with the project finance modeling techniques we covered earlier for end-to-end deal coverage.

Frequently Asked Questions

What is a partnership flip in tax equity?

A partnership flip is a joint venture between a renewable project Sponsor and a Tax Equity Investor where the TEI receives ~99% of tax credits, depreciation, and a small share of cash until they hit a target after-tax IRR. At that point, the TEI's allocation "flips" down to ~5% and the Sponsor takes 95% of all items going forward.

Is tax equity still relevant after IRA transferability?

Yes. The IRA's Section 6418 credit transferability opened a parallel monetization channel, but tax equity remains the structure of choice for projects that need to monetize both ITC and accelerated MACRS depreciation, since transferability only conveys the credit itself. Most analysts now build hybrid structures combining T-flips with a credit sale to optimize total proceeds.

Should I use ITC or PTC in my model?

ITC is generally better for solar, storage, and lower-yield projects because the credit is large relative to lifetime generation. PTC suits utility-scale wind and high-capacity-factor solar because the inflation-indexed per-kWh credit, accrued over 10 years, often exceeds 30% ITC equivalent. Run both side-by-side and pick the higher NPV after structuring costs.

What is HLBV accounting and why does it matter?

HLBV (Hypothetical Liquidation at Book Value) is the GAAP method for allocating partnership income when economic and tax allocations diverge. Each period, GAAP income is the change in each partner's claim on book equity assuming a hypothetical liquidation at book. It matters because TEIs report book results to investors and HLBV can produce non-linear, sometimes negative, GAAP income even when cash flows are smooth.

How long does it take to build a tax equity model from scratch?

A first-time build by an experienced project finance analyst typically takes 60-90 hours, including assumptions, debt sizing, the §704(b) allocation block, two parallel capital accounts (book and tax), the XIRR-driven flip solver, and sensitivities. AI-assisted modeling tools can cut this by 40-60% by generating boilerplate roll-forwards and validating allocations against the LLC agreement.

Next Steps

A working partnership flip model is the entry ticket to renewable energy project finance — and the same framework extends to storage, RNG, hydrogen, and carbon-capture deals as the IRA technology-neutral credits phase in through 2032. Start with a clean ITC solar deal, get the capital accounts to tie and the flip to solve, then layer in back-leverage, transferability, and Sponsor buyout once the core mechanics are tight.

The fastest way to learn is to build one yourself, break it on purpose with edge cases (zero generation, full recapture, DRO-capped losses), and watch how the flip date moves. That is how senior project finance modelers develop the intuition that no course or template can teach.