ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Acquitision Analysis and Valuation Calculator
2
3
20202019201820172017
4
Income $ 686,433 $ 688,818 $ 652,290 672522ProductionCollDays
5
Dr Production430272436148169
6
Lab/Dental Supplies
 $ 76,656 11% $ 96,167 $ 89,130 90019Hyg287835281427196
7
Wages $ 200,631 29% $ 207,184 $ 204,488 209794
8
Officers Comp $ 164,744 24% $ 165,316 $ 156,550
Estimated on 24% of total production is officer wages
9
Taxes $ 30,674 4% $ 31,820 $ 31,264 22470
10
Employee Benefits
 $ 3,300 0% $ 3,450 $ 3,200 FFS38.77%
11
Office Exp0%29999Insurance61.23%
12
Insurance0%6289
13
Telephone $ 2,800 0% $ 2,811 $ 2,763 # of Patients2314
in last 12 months
14
Janitorial0%
15
Utilities $ 5,922 1% $ 5,952 $ 6,018 5591Future recalls1654
16
Professional Fees
0%1275
17
Repairs0%15875HygieneMTWRF
18
Supplies0%104792222
19
City/County Taxes
 $ 5,114 1% $ 4,570 $ 4,280
20
Interest0%1231
21
Rent0%
22
Nitrous $ 950 0% $ 978 $ 1,200
23
Car/Truck0%3164
24
Advertising0%
25
Uniforms0%
26
27
Total Expense $ 490,791 71% $ 518,248 $ 498,893
28
29
Ordinary Income $ 195,642 29% $ 170,570 $ 153,397
30
31
32
EBITDA $ 195,642 $ 170,570 $ 153,397
33
 3 2 1 Weighted Multiple
34
 $ 586,926 $ 341,139 $ 153,397
35
36
 $ 1,081,463 Total
37
 6 Divided by Multiple
38
39
 $ 180,244 Weighted Average EBITDA
40
 3 Multiple 3-5 is Normal 6 is higher-end but possible for nice practice
41
 $ 540,732 <- Valuation
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100