ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
3
LAUNDROMAT DEAL ANALYSIS TOOL
4
5
Laundromat Address:123 Main St
6
Google Maps Link:See notes
7
Google Street View Link:
8
9
Asking PricePractical PriceDream PriceTarget Multiplier
10
Acquisition Cost$625,000.00$600,000.00$550,000.003
11
Multiplier at current price and NOI4.644.454.08Loan Information
12
Estimated Down Payment$62,500.00$60,000.00$55,000.00Amount Down
13
Total Income$264,000.00$264,000.00$264,000.0010%
14
Total Expenses (enter as a negative number)-$129,240.00-$129,240.00-$129,240.00Interest Rate
15
NOI$134,760.00$134,760.00$134,760.007%
16
Term (Years)
17
Estimated Loan Payment (yearly)-$94,200.62-$90,432.59-$82,896.548
18
Estimated Loan Payment (monthly-$7,668.97-$7,362.21-$6,748.69Total Loan @ Asking Price
19
Ideal Cost of Business (NOI x your target multiplier) $404,280.00$404,280.00$404,280.00$562,500.00
20
Total Loan @ Practical Price
21
Yearly Net Income After Debt Service$40,559.38$44,327.41$51,863.46$540,000.00
22
Monthly Net Income After Debt Service$3,379.95$3,693.95$4,321.95Total Loan @ Dream Price
23
Cash on Cash Return 64.90%73.88%94.30%$495,000.00
24
25
HOW TO USE THIS WORKSHEET:
26
1. The only items that need input data are highlighted in GREEN.
27
2. Acquisition Cost has three categories, Asking Price from the seller, Practical Price based on market information, and Dream Price based on what would be a "home run" for you.
28
3. Your target multiplier should be the multiplier that you would be happy paying for an asset like this based on the quality of the equipment, lease, location, and income.
29
4. Total Income and expense is based on what the seller is presenting. You can adjust as you get actuals.
30
5. Loan information: amount down that you are targeting for this asset, SBA 10% Private Financing 10-20%, Seller financing 10-50%. Interest Rate is the target interest rate you are expecting, most rates are going to be a few points above prime. Term is in years. That is how long the loan will be held for, most business loans are 3-10 years.
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