| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Rent Assumptions | Loan Assumptions | ||||||||||||||||||
2 | ||||||||||||||||||||
3 | Mobile Home Lot Rent | $400 | Home Price with Tax | $100,000 | ||||||||||||||||
4 | Lot Rent Increase | 4% | Down Payment | $10,000 | ||||||||||||||||
5 | Home Appreciation | 2% | Interest | 9% | ||||||||||||||||
6 | Apartment Rent | $1,500 | Amortization | 300 | ||||||||||||||||
7 | Apartment Rent Increase | 4% | Principal | $91,900 | ||||||||||||||||
8 | Loan Payment | $771.22 | ||||||||||||||||||
9 | ||||||||||||||||||||
10 | Buying a Manufactured Home | Renting | Difference | |||||||||||||||||
11 | ||||||||||||||||||||
12 | Year | Price/Value | Principal | Loan Payment | Lot Rent | Tax | Insurance | Maintenance | Monthly Cost | Equity | Year | Rent | Equity | Year | Buy | Rent | Savings | |||
13 | 0 | $100,000 | $90,000 | $771 | $400 | $83 | $83 | $83 | $1,421 | $10,000 | 0 | $1,500 | $0 | 0 | $17,055 | $18,000 | $945 | |||
14 | 1 | $102,000 | $90,198 | $771 | $416 | $85 | $85 | $85 | $1,442 | $11,802 | 1 | $1,560 | $0 | 1 | $32,560 | $36,720 | $4,160 | |||
15 | 2 | $104,040 | $89,085 | $771 | $433 | $87 | $87 | $87 | $1,464 | $14,955 | 2 | $1,622 | $0 | 2 | $46,974 | $56,189 | $9,215 | |||
16 | 3 | $106,121 | $87,868 | $771 | $450 | $88 | $88 | $88 | $1,486 | $18,253 | 3 | $1,687 | $0 | 3 | $61,513 | $76,436 | $14,923 | |||
17 | 4 | $108,243 | $86,536 | $771 | $468 | $90 | $90 | $90 | $1,510 | $21,707 | 4 | $1,755 | $0 | 4 | $76,176 | $97,494 | $21,317 | |||
18 | 5 | $110,408 | $85,079 | $771 | $487 | $92 | $92 | $92 | $1,534 | $25,329 | 5 | $1,825 | $0 | 5 | $90,962 | $119,394 | $28,432 | |||
19 | 6 | $112,616 | $83,486 | $771 | $506 | $94 | $94 | $94 | $1,559 | $29,130 | 6 | $1,898 | $0 | 6 | $105,867 | $142,169 | $36,302 | |||
20 | 7 | $114,869 | $81,743 | $771 | $526 | $96 | $96 | $96 | $1,585 | $33,125 | 7 | $1,974 | $0 | 7 | $120,889 | $165,856 | $44,967 | |||
21 | 8 | $117,166 | $79,837 | $771 | $547 | $98 | $98 | $98 | $1,612 | $37,329 | 8 | $2,053 | $0 | 8 | $136,024 | $190,490 | $54,466 | |||
22 | 9 | $119,509 | $77,752 | $771 | $569 | $100 | $100 | $100 | $1,639 | $41,757 | 9 | $2,135 | $0 | 9 | $151,268 | $216,110 | $64,842 | |||
23 | 10 | $121,899 | $75,471 | $771 | $592 | $102 | $102 | $102 | $1,668 | $46,428 | 10 | $2,220 | $0 | 10 | $166,614 | $242,754 | $76,141 | |||
24 | 11 | $124,337 | $72,977 | $771 | $616 | $104 | $104 | $104 | $1,698 | $51,361 | 11 | $2,309 | $0 | 11 | $182,055 | $270,464 | $88,409 | |||
25 | 12 | $126,824 | $70,248 | $771 | $640 | $106 | $106 | $106 | $1,729 | $56,576 | 12 | $2,402 | $0 | 12 | $197,584 | $299,283 | $101,699 | |||
26 | 13 | $129,361 | $67,264 | $771 | $666 | $108 | $108 | $108 | $1,761 | $62,097 | 13 | $2,498 | $0 | 13 | $213,191 | $329,254 | $116,063 | |||
27 | 14 | $131,948 | $63,999 | $771 | $693 | $110 | $110 | $110 | $1,794 | $67,949 | 14 | $2,598 | $0 | 14 | $228,865 | $360,425 | $131,560 | |||
28 | 15 | $134,587 | $60,428 | $771 | $720 | $112 | $112 | $112 | $1,828 | $74,159 | 15 | $2,701 | $0 | 15 | $244,592 | $392,842 | $148,250 | |||
29 | 16 | $137,279 | $56,523 | $771 | $749 | $114 | $114 | $114 | $1,864 | $80,756 | 16 | $2,809 | $0 | 16 | $260,357 | $426,555 | $166,198 | |||
30 | 17 | $140,024 | $52,250 | $771 | $779 | $117 | $117 | $117 | $1,900 | $87,774 | 17 | $2,922 | $0 | 17 | $276,145 | $461,617 | $185,472 | |||
31 | 18 | $142,825 | $47,578 | $771 | $810 | $119 | $119 | $119 | $1,939 | $95,247 | 18 | $3,039 | $0 | 18 | $291,935 | $498,082 | $206,147 | |||
32 | 19 | $145,681 | $42,466 | $771 | $843 | $121 | $121 | $121 | $1,978 | $103,215 | 19 | $3,160 | $0 | 19 | $307,705 | $536,005 | $228,300 | |||
33 | 20 | $148,595 | $36,876 | $771 | $876 | $124 | $124 | $124 | $2,019 | $111,719 | 20 | $3,287 | $0 | 20 | $323,431 | $575,446 | $252,015 | |||
34 | 21 | $151,567 | $30,761 | $771 | $912 | $126 | $126 | $126 | $2,062 | $120,806 | 21 | $3,418 | $0 | 21 | $339,084 | $616,463 | $277,380 | |||
35 | 22 | $154,598 | $24,072 | $771 | $948 | $129 | $129 | $129 | $2,106 | $130,526 | 22 | $3,555 | $0 | 22 | $354,632 | $659,122 | $304,490 | |||
36 | 23 | $157,690 | $16,756 | $771 | $986 | $131 | $131 | $131 | $2,151 | $140,934 | 23 | $3,697 | $0 | 23 | $370,040 | $703,487 | $333,447 | |||
37 | 24 | $160,844 | $8,753 | $771 | $1,025 | $134 | $134 | $134 | $2,199 | $152,091 | 24 | $3,845 | $0 | 24 | $385,267 | $749,626 | $364,359 | |||
38 | 25 | $164,061 | $0 | $771 | $1,066 | $137 | $137 | $137 | $2,248 | $164,061 | 25 | $3,999 | $0 | 25 | $400,270 | $797,611 | $397,342 | |||
39 | 26 | $167,342 | $0 | $0 | $1,109 | $139 | $139 | $139 | $1,527 | $167,342 | 26 | $4,159 | $0 | 26 | $415,316 | $847,516 | $432,199 | |||
40 | 27 | $170,689 | $0 | $0 | $1,153 | $142 | $142 | $142 | $1,580 | $170,689 | 27 | $4,325 | $0 | 27 | $430,930 | $899,416 | $468,486 | |||
41 | 28 | $174,102 | $0 | $0 | $1,199 | $145 | $145 | $145 | $1,635 | $174,102 | 28 | $4,498 | $0 | 28 | $447,134 | $953,393 | $506,260 | |||
42 | 29 | $177,584 | $0 | $0 | $1,247 | $148 | $148 | $148 | $1,691 | $177,584 | 29 | $4,678 | $0 | 29 | $463,949 | $1,009,529 | $545,580 | |||
43 | 30 | $181,136 | $0 | $0 | $1,297 | $151 | $151 | $151 | $1,750 | $181,136 | 30 | $4,865 | 0 | 30 | $481,399 | $1,067,910 | $586,511 | |||
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 | ||||||||||||||||||||