# The Carve-Out Financial Statements Handbook: companion files

Julian R. Sterling, julianrsterling.com/carve-out

Carve_Out_Workbook.xlsx rebuilds every figure of the book's case, from the marked ledger to the parent's stranded costs. Read its tabs in this order:

- Ledger: 103 lines over three years, one mark each, and third-party revenue by segment (chapters 3 and 5, exercise 1)
- Allocations: nine pools, one key each, split to the dollar by the largest remainder method (chapter 6, exercises 2 and 3)
- Statements: the carve-out income statement for years 1 to 3 and the balance sheet at the end of years 0 to 3 (chapters 4, 5 and 7, exercise 4)
- NPI: net transfers built from identified flows, the roll-forward of the net parent investment and the cash flow statement (chapters 8 and 10, exercises 5 and 6)
- Tax: the separate return method, the loss carryforward, deferred tax and the tax-sharing difference (chapter 9, exercises 7 and 8)
- Tests: the significance tests against the listed buyer's figures (chapter 2)
- ProForma: year 3 pro forma net income, transaction accounting and autonomous entity columns apart (chapter 11, exercise 9)
- Bridge: standalone EBITDA, the two post-distribution years with the TSA, the parent's stranded costs and the six-pool free model (chapters 12, 13, 14 and 16, exercises 10 to 12)

Each tab: inputs in blue, formulas in black, case values used by the checks in grey. Cell B2 of each tab counts the checks that fail; send nothing to the auditors or the buyer while a count is above zero.
If a cell does not return the printed answer, find the first failing check on the earliest tab and fix the input, never the output. The net parent investment is never a plug.

Carve_Out_Standalone_Cost_Model.xlsx is the simplified model on six pools: replace the pools, keys, standalone estimates and TSA terms with your own.

Teskeridge Industries, Inc., Kilnmere and everyone in the case are fictional. Every key, pool, cost, fee, rate and date is a teaching assumption, not a market norm. Education only; not legal, accounting, tax or investment advice.
