Companion files · The Private Markets Career Guides
How Fund Tax Really Works: Structures, Blockers, Withholding, K-1s, Carried Interest, Audits and the Career of a Tax Director at a Private Equity and Private Credit Manager.
These are the companion files of the book. One workbook rebuilds the Corbel Ridge case: Fund IV’s investors by type, the Lanthorn exit allocated among taxable, tax-exempt and non-US investors, the Brightwater exit along its direct and blocked paths, the carry under the three-year rule, the management fee waiver, the original issue discount and withholding on a private credit loan, the tax calendar and an illustrative audit computation. A toolkit holds the twelve checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 3 to 16
One Inputs sheet holds every rate and case assumption: federal rates, the blocker rate, the investor mix, the carry and fee terms, the exit prices and holding periods, the loan terms and the proposed audit adjustment. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook29 KBAppendix B
Fund structure review checklist, investor onboarding and tax status checklist, side letter tax terms checklist, acquisition tax diligence checklist, exit allocation checklist, blocker decision checklist, private credit loan tax checklist, carried interest holding period tracker, annual compliance calendar template, K-1 package review checklist, state and composite filing checklist and audit readiness checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Exit allocation | Lanthorn: a $350.0 million gain, $70.0 million of carry and $280.0 million for the limited partners: $98.0 million to US taxable investors, $112.0 million to tax-exempt investors and $70.0 million to non-US investors |
| Blocker | Brightwater: $16.25 million of blocker tax on a $65.0 million gain; an IRR of 14.0 percent through the blocker against 18.3 percent on the direct path, 4.3 points lower |
| Carry | $16.75 million of Brightwater carry held less than three years: $6.8 million of federal tax at the short-term rate against $4.0 million had it been long-term, a cost of $2.8 million |
The files are provided as they are, without warranty of any kind. The model is illustrative: Corbel Ridge Partners and the other names are fictional, the model is simplified, the rates and rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is tax, legal or investment advice.
More in private equity, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.