ABCDEFGHIJKLMNOPQR
1
Green fields are for user supplied data
2
Renter OccupiedOwner Occupied
3
Acquisition Cost
4
 Current Value (Purchase Price)$450,000$630,000$450,000$550,000
5
 Closing Costs1.5%$6,750$9,450$6,750$8,250
6
 Repairs/Improvements$25,000$0$25,000$0
7
Total Investment$481,750$639,450$481,750$558,250
8
9
Calculate Mortgage on 100% (a)100%100%100%100%
10
 Principle$481,750$639,450$481,750$558,250
11
 Rate (b)6.5%6.5%3.5%3.5%
12
 Term360360360360
13
 Monthly Payment$3,045$4,042$2,163$2,507
14
15
Calculate Overhead
16
 50% Rule (vacancy, repairs, property management, taxes, insurance) (c)50%50%35%35%
17
 = Overhead$1,150$1,400$805$854
18
19
Market Rent$2,300$2,800$2,300$2,439
20
21
Calculate Return
22
 Rent$2,300$2,800$2,300$2,439
23
 - Mortgage-$3,045-$4,042-$2,163-$2,507
24
 - Overhead-$1,150-$1,400-$805-$854
25
Net Return-$1,895-$2,642-$668-$921
26
27
Annual Gain/Loss-$22,740-$31,701-$8,019-$11,057
28
29
Rate of Return-4.72%-4.96%-1.66%-1.98%
30
31
(a) In reality, you would put down >= 25% for investment property and about >= 20% for owner occupied
32
(b) Renter occupied mortgage vs. owner occupied mortgage rate
33
(c) 50% rule for renter occupied, vacancy and management are mute for owner occupied, so estimate 35%
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