ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Buy or Rent Property?
2
3
VariablesFiguresMeasure
4
2 Bedroom Apartment Rents for$425
5
Apartment Price$50,000
6
Downpayment on Loan10%
7
Loan Rate - 30 year fixed7%
8
Number of Payments for 30 years360payments
9
Property Tax / Assessment Tax1%per year
10
Average Inflation Rate4%per year
11
Association Fees$40per month
12
Monthly loan payment if any$300per month
Get this from mortgage schedule or calculator using information in RED above
13
14
15
16
Spreadsheet
17
Buy it outright
Loan itRent it
18
Rent($425)loss
19
Price / total payments for outright buy($139)loss
20
Monthly Payment($300)loss
21
Association Fees($40)($40)loss
22
Total Loss/Gain($179)($340)($425)loss
23
24
25
Rent roomate pays you - set as 1/2$213 $213 $213 gain
26
New Total Loss/Gain$34 ($128)($213)net
27
28
29
30
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