Up to six pools of a parent's shared costs, one key each, the cost of running each function alone, the dis-synergies, standalone EBITDA against carve-out EBITDA, two years after the separation with the TSA and one-time costs, and the costs the parent keeps.
A division leaves its group with $30,363,248 of costs allocated through six pools. Running the same functions alone would cost $36,950,000 a year, so carve-out EBITDA of $57,365,852 becomes standalone EBITDA of $50,779,100. The model rebuilds that view on one sheet, with the TSA years and what the parent is left with, ready for your own pools and estimates.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Carve_Out_Standalone_Cost_Model.xlsx (13 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.
This model is a simplified version of the companion workbook of The Carve-Out Financial Statements Handbook, which follows one division out of its group: the marked ledger, nine pools split to the dollar, the net parent investment, separate return taxes, the significance tests, the Article 11 pro forma and the full standalone bridge.
One sheet in four blocks. Inputs are blue; everything else is a formula, and the last block counts the checks that fail.
| Measure | Value |
|---|---|
| Allocated to the division, six pools | $30,363,248 |
| Standalone run-rate, six pools | $36,950,000 |
| Carve-out EBITDA before one-time items | $57,365,852 |
| Standalone EBITDA on six pools | $50,779,100 |
| Year 1 after the separation: EBITDA before one-time costs (TSA fees $16,860,000) | $52,369,100 |
| Year 1: one-time separation costs, shown apart | $14,000,000 |
| Year 1: gross cost stranded at the parent | $22,627,739 |
| Year 2: EBITDA before one-time costs | $50,779,100 |
| Year 2: one-time separation costs | $4,000,000 |
| Year 2: gross cost stranded at the parent | $15,659,305 |
The six pools are finance, IT, human resources, legal, the executive office and the shared plant. The book's full bridge runs on nine pools; read the model's figures against each other, not against the full bridge.
It takes up to six pools of a parent's shared costs, the business's share of each key and the cost of running each function alone, and returns the allocated costs, the dis-synergies, standalone EBITDA, two years after the separation with the TSA and the one-time costs, and the costs the parent keeps.
Carve-out EBITDA carries allocations, a share of what the parent spent. Standalone EBITDA replaces each allocation with what the function would cost the business alone. In the book's six-pool example, $57,365,852 becomes $50,779,100.
Replace the blue inputs: carve-out EBITDA before one-time items, each pool's cost and key units, your standalone estimate by function, the TSA months and monthly fees, what the parent can remove each year, and the one-time separation costs.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbook of The Carve-Out Financial Statements Handbook goes further: the ledger, nine pools by the largest remainder method, the statements, the net parent investment, the separate return tax, the significance tests, the pro forma and the full bridge.