A free partnership flip tax equity model in Excel, on a solar project
The ITC and its bonuses, the partnership flows and the flip, the investor's capital account against the DRO cap, a credit transfer, a hybrid deal, recapture, back-leverage and HLBV: thirteen sheets, no macros.
The file models Merrowfield Solar, a fictional $312 million project, financed by a bank's tax equity. The ITC is 40% (30% base plus the energy community bonus) of a $300 million basis: $120 million, 99% of it allocated to the investor before the flip. The investor contributes $160 million and reaches its target return in 2036, at a 7.50% IRR; over 25 years it earns 8.65%. Its capital account falls to minus $52.4 million in 2030, $3.6 million inside the $56 million deficit restoration cap.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Partnership_Flip_Tax_Equity_Model.xlsx (234 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is one worked case from The Tax Equity Investor. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Thirteen sheets. Blue cells on a light yellow background are inputs, on the Inputs sheet only. US dollars, 21% federal tax.
Read Me and Inputs
The project, the flip terms, tax rate and depreciation, the recapture schedule, the transfer and the back-leverage.
Portfolio
The bank's tax equity funds and the credits claimed against the budget.
Credits and Bonuses
The ITC rate, the credit and its split, the depreciable basis, and what each bonus is worth.
Flip Model
The partnership flows, the pre-flip allocations, the cumulative IRR and the flip year.
Capital Accounts
The investor's capital account year by year against the DRO cap.
Transfer, Hybrid, Recapture and Insurance
Credits bought at a discount, a storage deal that sells part of its credit, the recapture exposure and the casualty test.
Back-Leverage, HLBV, Answers and Checks
The sponsor's debt above the partnership, HLBV earnings, the answers to the exercises and the checks.
What the worked case returns
Measure
Value
Total cost
$312.0m
ITC rate and ITC
40%, $120.0m
Investor ITC (99% pre-flip)
$118.8m
Investor contribution
$160.0m
Flip year and IRR at the flip
2036, 7.50%
IRR over 25 years
8.65%
Lowest capital account
-$52.4m (2030)
Credits bought by transfer
$40.0m at 93.5 cents
Losing the energy community bonus would cut the ITC from $120 million to $90 million. That is why the bonuses, not the base credit, are where diligence and tax insurance concentrate.
How to use it on your own project
Enter your project cost, eligible basis and the bonuses you qualify for on Inputs.
Set the flip terms: pre-flip and post-flip allocations and the target return.
Read the flip year and IRR, then check the capital account against the DRO cap.
Use the Answers sheet to test one change at a time.
Questions people ask about it
Is this template really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference: the flip year is found from the cumulative IRR row, not by goal seek.
What is a partnership flip?
A structure in which the tax equity investor takes most of the tax benefits and cash until it reaches a target return, after which the allocations flip to the sponsor. Here the investor takes 99% of the ITC before the flip, which happens in 2036.
Can I use it for a real project?
You can reuse the structure. The bank, the projects and every figure are fictional, the tax treatment is simplified, and nothing here is tax or investment advice.
The rest of the files
This template is the companion workbook for The Tax Equity Investor; the companion page also carries the other files that go with it. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
This template comes from The Tax Equity Investor. The book is on Apple Books and Google Play.
If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.