# The Private Equity Tax Professional: companion files

Julian R. Sterling

## What is here

- **PE_Tax_Model.xlsx**: the workbook that rebuilds the Corbel Ridge case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Fund and Investors, Exit Allocation, Blocker and IRR, Carry and Fees, Credit and OID, Calendar and Audit, Checks.
- **Fund_Tax_Toolkit.docx**: the twelve checklists of Appendix 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, audit readiness checklist), in editable form.

## Which sheet answers which chapter

- Chapters 3 to 5: Fund and Investors (Fund IV's commitments by investor type, partners, carry, fee and structure)
- Chapter 9: Exit Allocation (the Lanthorn gain by investor type and who pays what)
- Chapters 6 and 10: Blocker and IRR (the Brightwater direct and blocked paths, the blocker tax, the IRR gap, the section 1446(a) counterfactual)
- Chapters 12 and 13: Carry and Fees (the carry under the three-year rule, the 2026 management fee and waiver)
- Chapter 11: Credit and OID (the Pelham loan, the five-year discount accrual, the withholding under three treatments)
- Chapters 14 and 16: Calendar and Audit (Fund IV's tax calendar and the illustrative computation for the 2023 examination)

## Two inputs to change first

1. On Inputs, raise the blocker combined rate from 25.0% to 30.0%: watch the blocker tax rise and the IRR gap against the direct path widen.
2. On Inputs, change the Brightwater holding period from 2.0 to 3.5 years: watch the Brightwater carry turn long-term on Carry and Fees and every IRR of that exit fall. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Corbel Ridge Partners, Fund IV, Credit Fund II, Lanthorn, Brightwater, the blocker and Pelham are fictional; the model is a simplified teaching model; rates and rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not tax, legal or investment advice.
