Calculation guide
Apply subsequent proportional dilution before distributing exit common equity.
Inputs
Cash-equivalent rollover
Example entry 100 (in the selected currency).
Total post-deal common equity value
Example entry 1000 (in the selected currency).
Later dilution of ownership
Example entry 20 %. Allowed range 0 to 100.
Exit enterprise value
Example entry 1800 (in the selected currency).
Exit net debt
Example entry 300 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Cash-equivalent rollover | 100 |
| Total post-deal common equity value | 1,000 |
| Later dilution of ownership | 20% |
| Exit enterprise value | 1,800 |
| Exit net debt | 300 |
| Result | Value |
|---|---|
| Seller exit proceeds | 120 |
| Diluted seller ownership | 8% |
Calculation steps
Seller exit proceeds = (((max(0, (Exit enterprise value − Exit net debt)) × Cash-equivalent rollover) ÷ Total post-deal common equity value) × (1 − (Later dilution of ownership ÷ 100)))
(((max(0, (1,800 − 300)) × 100) ÷ 1,000) × (1 − (20 ÷ 100))) = 120
Diluted seller ownership = (((100 × Cash-equivalent rollover) ÷ Total post-deal common equity value) × (1 − (Later dilution of ownership ÷ 100)))
(((100 × 100) ÷ 1,000) × (1 − (20 ÷ 100))) = 8%
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Cash-equivalent rollover | 100 | 110 | Seller exit proceeds | 120 | 132 |
| Total post-deal common equity value | 1,000 | 1,100 | Seller exit proceeds | 120 | 109.090909 |
| Later dilution of ownership | 20% | 22% | Seller exit proceeds | 120 | 117 |
| Exit enterprise value | 1,800 | 1,980 | Seller exit proceeds | 120 | 134.4 |
| Exit net debt | 300 | 330 | Seller exit proceeds | 120 | 117.6 |
