Valuation Tool

	B	C	E	F	G	I	J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16	Purchase Price	$1,500,000	DSCR	1.2	1.6	Current Asking
17	EBITDA	$600,000	Max Yearly Debt	$500,000	$375,000	Purchase Price	$1,500,000
18	SDE	$600,000	Max Monthly Debt	$41,667	$31,250	SBA Required	10%
19						Cash Down	$150,000
20	EBIDTA Multiple	2.5	Max Bank Debt	$3,024,803	$2,268,602	Financed	$1,350,000
21	SDE Multiple	2.5	Expected Cash Down	-$1,524,803	-$768,602	Monthly Payment	$18,596
22			Cash Down (min 10%)	$302,480	$226,860	Yearly Payment	$223,155
23						DSCR	2.7
24	Financing Info
25	Term (Years)	10	Returns	1.2	1.6	EBITDA post debt	$376,845
26	Amortization (Years)	10	Preferred Cash Down	$120,000	$120,000
27	Amortization (Months)	120	Business Valuation	$3,144,803	$2,388,602
28	Rate	11%	CF	$100,000	$225,000
29	Rate/Month	0.92%	Cash on Cash	83.3%	187.5%
30
31
32	Yellow	Enter your information
33	Blank	Self Populates
34	Cash Down	10% cash down assumed (self populates)
35	Business Valuation	This takes the max bank debt (based on DSCR) and adds your preferred cash down to come up with a Valuation (self populates)
36
37
38
39
40
41
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