| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | ||||||||
2 | Assumptions | |||||||
3 | ||||||||
4 | Interest rate | 5% | ||||||
5 | ||||||||
6 | Job Offer #1: Private Equity-Owned Practice | |||||||
7 | Insurance billing - growth rate % | 2% | ||||||
8 | Ancillary services - growth rate % | 2% | ||||||
9 | Insurance billing (2013 amount) | $350,000 | ||||||
10 | Ancillary services (2013 amount) | $650,000 | ||||||
11 | Physician count | 18 | ||||||
12 | ||||||||
13 | Buyouts | |||||||
14 | Acquisition multiple | 10.0x | ||||||
15 | ||||||||
16 | Buyout number | 1 | 2 | 3 | 4 | |||
17 | Buyout year | 2021 | 2030 | 2040 | 2050 | |||
18 | Buyout price | $105,449,344 | $126,021,728 | $126,021,728 | $187,261,658 | |||
19 | Ownership sold % | 52% | 70% | 75% | ||||
20 | Valuation (partner share) | $50,615,685 | $37,806,518 | $31,505,432 | ||||
21 | Reinvestment | 30% | 25% | 20% | ||||
22 | ||||||||
23 | Job Offer #2: Academic Institution-Affiliated | |||||||
24 | ||||||||
25 | Market Rate | 6.50% | ||||||
26 | 401K Match % | 8.50% | ||||||
27 | ||||||||
28 | ||||||||
29 | ||||||||
30 | ||||||||
31 | Outcomes | |||||||
32 | Job Offer #1: Private Equity-Owned Practice | $12,534,298 | ||||||
33 | Job Offer #2: Academic Institution-Affiliated | $18,173,759 | ||||||
34 | ||||||||
35 | ||||||||
36 | ||||||||
37 | ||||||||
38 |