Simple Deal Structure Calculator.xlsx

	B	C	D	F	G	H	I	J	K	L	M	N
1	Simple Deal Structure Calculator
2
3	SBA Terms
4	Rate	10.0%
5	Term	10
6	Min DSCR	1.50		Minimum Equity %		EBITDA
7	Deal Terms				23.9%	500,000	750,000	1,000,000	1,250,000	1,500,000	1,750,000	2,000,000
8	EBITDA	650,000		Purchase Multiple	3.0x	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%
9	Multiple	5.0x		Purchase Multiple	3.5x	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%
10	Enterprise Value	3,250,000			4.0x	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%	10.0%
11	Plus Expenses	250,000			4.5x	18.1%	15.2%	13.8%	12.8%	12.2%	11.8%	11.4%
12	Cash Required	3,500,000			5.0x	25.5%	23.2%	22.0%	21.2%	20.7%	20.3%	20.1%
13	Equity	837,354	23.9%		5.5x	31.7%	29.8%	28.8%	28.1%	27.7%	27.4%	27.2%
14	SBA Debt	2,662,646	76.1%		6.0x	37.0%	35.3%	34.5%	33.9%	33.6%	33.3%	33.1%
15
16	Loan Calculations
17	Max SBA Payment	433,333
18	Implied Max Loan Size	2,662,646
19	Max Debt %	90.0%
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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