ABCDEFGHIJKLMNOPQRSTUVWX
1
INSTRUCTIONS: You can change any value highlighted in the yellow cells (column B)
2
3
ASSUMPTIONS
4
5
MortgageBase CaseBest Case
Worst Case
6
Purchase Price$800,000$760,000$840,000
7
Interest Rate3.00%2.50%4.00%
8
Principal Amortization (Years)253025
9
Downpayment %20%20%20%
10
11
Annual Costs
12
Annual Property Taxes$10,000$10,000$10,300
13
Annual Maintainance Allowance$3,000$2,700$4,500
14
Annual Home Insurance$2,000$1,900$3,000
15
16
Monthly Costs
17
Utilitiy Costs$600$570$780
18
Other (Ex: Vacancy, Prop Management)
$500$250$1,500
19
20
One Time Costs
21
Closing Costs$15,000$13,500$22,500
22
Other Costs$5,000$0$15,000
23
24
Monthly Income
25
Rent$6,000$6,600$5,400
26
Utility Payments$100$570$0
27
28
Other Assumptions
29
Annual Home Appreciation3.0%5.0%-2.0%
30
General Inflation and Rent Increase1.5%2.0%0.0%
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