ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
3
4
5
6
6/1/24
7
8
9
Property:
10
Debt Stack
11
12
Quick Opportunity Analyzer
1st Position Debt
4
13
Original Loan Amount $ or:
$1,000,000
14
Original Loan to Value %
15
Loan Amount Calculated
$1,000,000
16
Total Purchase Amount :
$1,750,000
Amortized or Interest-Only
Fully Amortized
17
Interest Rate %
8.00%
18
Gross Annual Revenue (actual-vacancy adjusted):
$200,000
Start Date: MM/DD/YYYY
2/1/2024
19
Loan Term (years)
25
20
TIMMS Utility Multiplier:
65%
Current Loan Balance:
Trimester1$995,752
21
Payment, (Monthly)
$7,718
22
NOI (Net Operating Income):
$130,000
Debt Service, Annual
$92,618
23
24
Cap Rate (calculated actual):
7.4%
2nd Position Debt
5
25
Original Loan Amount $ or:
$0
26
Market Cap Rate:
7.0%
Original Loan to Value %
0%
27
Loan Amount Calculated
$0
28
Value at market cap rate:
$1,857,143
Amortized or Interest-Only
Interest Pmt Only
29
Interest Rate %
0.00%
30
Combined LTV (total debt/market value) :
54%
Start Date: MM/DD/YYYY
12/30/2023
31
Loan Term (years)
30
32
Annual Debt Service total:
$92,618
Current Loan Balance:
Trimester1$0
33
Payment, (Monthly)
$0
34
Debt Service, Annual
$0
35
36
Discount % from Market Value:
6.1%
3rd Position Debt
5
37
Original Loan Amount $ or:
$0
38
NADS--Net After Debt Service : (What we keep)
$37,382
Original Loan to Value %
0%
39
Loan Amount Calculated
$0
40
BUDGET: Most we can offer Seller With Debt Takeover:
Amortized or Interest-Only
Fully Amortized
41
Max COC = NADS/.3 =
$124,607
Interest Rate %
0.00%
42
Start Date: MM/DD/YYYY
12/31/2023
43
Amount the Seller wants:
$300,000
Loan Term (years)
30
44
COC % = NADS/ Amount Seller Wants (Min. 30%)
12%
Current Loan Balance:
Trimester1
45
Payment, (Monthly)
46
Debt Service, Annual
$0
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