Companion files · The Private Markets Career Guides

The Private Equity Tax Professional

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 workbook, the toolkit and the read-me, in one archive66 KB

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.

The files

Three numbers to reproduce first

Exit allocationLanthorn: 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
BlockerBrightwater: $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.

Also by Julian R. Sterling

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.