Free Excel templates

A free carve-out standalone cost model in Excel

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.

Get the model

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.

The book behind this model

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.

Paperback PDF edition, $19.99

What is in the file

One sheet in four blocks. Inputs are blue; everything else is a formula, and the last block counts the checks that fail.

1. Inputs by function
For each of six pools: the pool cost, the business's key units and the total units, the standalone run-rate a year, TSA months and monthly fee, other payments to the parent such as a lease or a site services fee, and the share of the allocated cost the parent can remove in years 1 and 2.
2. Results by function
Allocated cost, standalone cost, dis-synergy, year 1 TSA fees and function cost, year 2 function cost, and the cost stranded at the parent in each year.
3. Detached against standalone EBITDA
The run-rate bridge, then years 1 and 2 with the one-time separation costs shown apart, the TSA fees and the parent's gross and net stranded cost.
4. Checks
Key units within totals, TSA months and removable shares within range, the allocation removed exactly once, one-time costs kept below the line.

What the worked case returns

MeasureValue
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.

How to use it on your own carve-out

  1. Group the parent's shared costs into pools by function and give each pool one key that measures what drives it.
  2. Enter each pool's cost and the key units of the business and of the whole group, then your standalone estimate for each function, function by function and evidenced.
  3. Enter the TSA months and fees and any lease the business will pay the parent, then what the parent can remove in each of the two years.
  4. Read standalone EBITDA against carve-out EBITDA, then change one estimate at a time to see what each is worth before it reaches the price.

Questions people ask

What does the carve-out standalone cost model do?

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.

Why does standalone EBITDA differ from carve-out EBITDA?

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.

How do I use it on my own carve-out?

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.

Is this model really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading