ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
(You must click 'File' above and then select 'Download' to use the spreadsheet)
2
3
ONLY CHANGE THE FIELDS IN BLUE.
4
What to Offer
5
6
Given:
7
Gross Income 1,080,000
8
Operating Expenses 500,000
9
Purchase Price 8,765,000
10
Req. Cash on Cash %8.00%
11
Vacancy7.00%
12
13
Loan Terms
14
Loan To Value70.00%
15
Rate3.00%
16
Amortization30
17
18
Gross Income 1,080,000
19
Vacancy 75,600
20
Operating Expenses 500,000
21
Net Operating Income 504,400
22
23
Net Operating Income 504,400
24
Purchase Price 8,765,000
25
Cap Rate5.75%
26
27
Annual Debt Service 310,410
28
Loan Principal Amount 6,135,500
29
Loan Constant 0.05059
30
31
Net Operating Income 504,400
32
Annual Debt Service 310,410
33
Cash Flow 193,990
34
Equity Down 2,629,500
35
Cash on Cash Return7.38%
36
37
LTV Debt Ratio70.00%
38
Loan Constant 0.05059
39
LTV Debt X Loan Constant3.54%
40
41
LTV Equity Ratio30.00%
42
Req. Cash on Cash %8.00%
43
LTV Equity X Req. Return2.40%
44
45
Required Cap Rate5.94%
46
47
Net Operating Income 504,400
48
Required Cap Rate5.94%
49
Required Purchase Price 8,489,476
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