I have done have of the project. Just finish it.

profilemwade3
rent20vs20own20analysis20spreadsheet20to20be20completed20by20student.xlsx

Rent V Own Analysis

Student Name
Rent versus Own Analysis of a Personal Residence
Property Information Loan Information:
Loan-to-value ratio 85.00%
Purchase price $275,000 Loan amount $233,750
Initial Rent $18,000 /year Interest rate 4.25%
Rental growth rate 3.50% Loan term (years) 30
Property growth rate 3.25% Payments (per year) 12
Insurance $1,750
Maintenance $250
Expense growth 3.00%
Marginal tax rate 28.00%
Property tax % 1.15%
Selling expenses 7.25%
Loan and Equity Calculations
Annual debt service (payment) $13,799
Annual loan constant 5.90% Annual Debt Service/Original Loan Amount
Equity investment $41,250
Summary loan Schedule
End of year 1 2 3 4 5
Annual Constant Payment $13,799 $13,799 $13,799 $13,799 $13,799
EOP Balance 229,809 225,698 221,408 216,933 212,263
Annual Interest 9,858 9,687 9,509 9,323 9,129
Annual Principal 3,941 4,111 4,290 4,476 4,670
Property Data
0 1 2 3 4 5
Property value $275,000 283,938 293,165 302,693 312,531 322,688
Rents 18,000 18,630 19,282 19,957 20,655
BTCF (owner)
Year 1 2 3 4 5
Property taxes 3,163 3,265 3,371 3,481 3,594
Insurance 1,750 1,803 1,857 1,912 1,970
Maintenance 250 258 265 273 281
Principal and Interest 13,799 13,799 13,799 13,799 13,799
Cash Outflows before taxes 18,961 19,124 19,292 19,465 19,644
Tax deductions from owning
Property taxes $3,163 $3,265 $3,371 $3,481 $3,594
Interest 9,858 9,687 9,509 9,323 9,129
Total tax deductions $13,021 $12,953 $12,881 $12,804 $12,723
Tax savings 3,646 3,627 3,607 3,585 3,563
Net cost of owning
Cash Outflows before taxes 18,961 19,124 19,292 19,465 19,644
Tax savings 3,646 3,627 3,607 3,585 3,563
After tax cost 15,316 15,497 15,686 15,880 16,081
Net cost of renting
Rents $18,000 $18,630 $19,282 $19,957 $20,655
Net Cash Flow of Renting Verses Owning Before Sale
Cost of renting $18,000 $18,630 $19,282 $19,957 $20,655
Cost of owning 15,316 15,497 15,686 15,880 16,081
After Tax Cash Flow Own vs Rent $2,684 $3,133 $3,597 $4,077 $4,574
BT Cash Flow - Sale
1 2 3 4 5
Projected Sales price 283,938 293,165 302,693 312,531 322,688
Selling Costs 20,585 21,254 21,945 22,658 23,395
Mortgage balance 229,809 225,698 221,408 216,933 212,263
Benefit from sale (own - rent) 33,543 46,213 59,340 72,940 87,030
AT Cash Flow - Sale
Sales price $283,938 $293,165 $302,693 $312,531 $322,688
Less selling costs 20,585 21,254 21,945 22,658 23,395
Less purchase price 275,000 275,000 275,000 275,000 275,000
Gain on sale (11,648) (3,089) 5,748 14,872 24,293
Exclusion on Capital Gains 0 0 5,748 14,872 24,293
Taxable gain 0 0 0 0 0
Tax 0 0 0 0 0
After tax cash flow 33,543 46,213 59,340 72,940 87,030
Cash savings and IRR summary
Cash flows AT IRR
Year Sold 0 1 2 3 4 5
1 -41,250 $36,227 -12.18%
2 -41,250 2,684 49,346 12.68%
3 -41,250 2,684 3,133 62,936 19.57%
4 -41,250 2,684 3,133 3,597 77,017 21.84%
5 -41,250 2,684 3,133 3,597 4,077 91,604 22.50%

Assumptions

Example Project Assumptions
Purchase price of house $ 275,000
Apartment Rent per month $ 1,500
Rent growth per year 3.50%
House price appreciation per year 3.25%
Annual home owners insurance cost $ 1,750
Annual home owners maintenance expense $ 250
Expense growth per year 3.00%
Marginal tax rate 28.00%
Property tax rate 1.15%
Selling expenses 7.25%
Loan information
Bank loan to value 85.00%
Interest rate 4.25%
Loan term in years 30
Other Information
Alternative investment return on down payment 12.00%

Amortization Schedule

Term in Months 360 Price $275,000
LTV 85%
Interest Rate 4.25% Loan Amt. $233,750
Constant
Month BOP Prin Bal Interest Amortization Payment EOP Prin Bal
1 Jan-14 $233,750.00 $827.86 $322.04 $1,149.91 $233,427.96
2 Feb-14 $233,427.96 $826.72 $323.19 $1,149.91 $233,104.77
3 Mar-14 $233,104.77 $825.58 $324.33 $1,149.91 $232,780.44
4 Apr-14 $232,780.44 $824.43 $325.48 $1,149.91 $232,454.96
5 May-14 $232,454.96 $823.28 $326.63 $1,149.91 $232,128.33
6 Jun-14 $232,128.33 $822.12 $327.79 $1,149.91 $231,800.54
7 Jul-14 $231,800.54 $820.96 $328.95 $1,149.91 $231,471.59
8 Aug-14 $231,471.59 $819.80 $330.11 $1,149.91 $231,141.48
9 Sep-14 $231,141.48 $818.63 $331.28 $1,149.91 $230,810.19
10 Oct-14 $230,810.19 $817.45 $332.46 $1,149.91 $230,477.74
11 Nov-14 $230,477.74 $816.28 $333.63 $1,149.91 $230,144.10
12 Dec-14 $230,144.10 $815.09 $334.82 $1,149.91 $229,809.29
13 Jan-15 $229,809.29 $813.91 $336.00 $1,149.91 $229,473.29
14 Feb-15 $229,473.29 $812.72 $337.19 $1,149.91 $229,136.09
15 Mar-15 $229,136.09 $811.52 $338.39 $1,149.91 $228,797.71
16 Apr-15 $228,797.71 $810.33 $339.58 $1,149.91 $228,458.12
17 May-15 $228,458.12 $809.12 $340.79 $1,149.91 $228,117.34
18 Jun-15 $228,117.34 $807.92 $341.99 $1,149.91 $227,775.34
19 Jul-15 $227,775.34 $806.70 $343.21 $1,149.91 $227,432.14
20 Aug-15 $227,432.14 $805.49 $344.42 $1,149.91 $227,087.72
21 Sep-15 $227,087.72 $804.27 $345.64 $1,149.91 $226,742.08
22 Oct-15 $226,742.08 $803.04 $346.86 $1,149.91 $226,395.21
23 Nov-15 $226,395.21 $801.82 $348.09 $1,149.91 $226,047.12
24 Dec-15 $226,047.12 $800.58 $349.33 $1,149.91 $225,697.79
25 Jan-16 $225,697.79 $799.35 $350.56 $1,149.91 $225,347.23
26 Feb-16 $225,347.23 $798.10 $351.80 $1,149.91 $224,995.43
27 Mar-16 $224,995.43 $796.86 $353.05 $1,149.91 $224,642.37
28 Apr-16 $224,642.37 $795.61 $354.30 $1,149.91 $224,288.07
29 May-16 $224,288.07 $794.35 $355.56 $1,149.91 $223,932.52
30 Jun-16 $223,932.52 $793.09 $356.82 $1,149.91 $223,575.70
31 Jul-16 $223,575.70 $791.83 $358.08 $1,149.91 $223,217.62
32 Aug-16 $223,217.62 $790.56 $359.35 $1,149.91 $222,858.28
33 Sep-16 $222,858.28 $789.29 $360.62 $1,149.91 $222,497.66
34 Oct-16 $222,497.66 $788.01 $361.90 $1,149.91 $222,135.76
35 Nov-16 $222,135.76 $786.73 $363.18 $1,149.91 $221,772.58
36 Dec-16 $221,772.58 $785.44 $364.46 $1,149.91 $221,408.12
37 Jan-17 $221,408.12 $784.15 $365.76 $1,149.91 $221,042.36
38 Feb-17 $221,042.36 $782.86 $367.05 $1,149.91 $220,675.31
39 Mar-17 $220,675.31 $781.56 $368.35 $1,149.91 $220,306.96
40 Apr-17 $220,306.96 $780.25 $369.66 $1,149.91 $219,937.30
41 May-17 $219,937.30 $778.94 $370.96 $1,149.91 $219,566.34
42 Jun-17 $219,566.34 $777.63 $372.28 $1,149.91 $219,194.06
43 Jul-17 $219,194.06 $776.31 $373.60 $1,149.91 $218,820.46
44 Aug-17 $218,820.46 $774.99 $374.92 $1,149.91 $218,445.54
45 Sep-17 $218,445.54 $773.66 $376.25 $1,149.91 $218,069.29
46 Oct-17 $218,069.29 $772.33 $377.58 $1,149.91 $217,691.71
47 Nov-17 $217,691.71 $770.99 $378.92 $1,149.91 $217,312.79
48 Dec-17 $217,312.79 $769.65 $380.26 $1,149.91 $216,932.53
49 Jan-18 $216,932.53 $768.30 $381.61 $1,149.91 $216,550.93
50 Feb-18 $216,550.93 $766.95 $382.96 $1,149.91 $216,167.97
51 Mar-18 $216,167.97 $765.59 $384.31 $1,149.91 $215,783.65
52 Apr-18 $215,783.65 $764.23 $385.68 $1,149.91 $215,397.98
53 May-18 $215,397.98 $762.87 $387.04 $1,149.91 $215,010.94
54 Jun-18 $215,010.94 $761.50 $388.41 $1,149.91 $214,622.52
55 Jul-18 $214,622.52 $760.12 $389.79 $1,149.91 $214,232.74
56 Aug-18 $214,232.74 $758.74 $391.17 $1,149.91 $213,841.57
57 Sep-18 $213,841.57 $757.36 $392.55 $1,149.91 $213,449.01
58 Oct-18 $213,449.01 $755.97 $393.94 $1,149.91 $213,055.07
59 Nov-18 $213,055.07 $754.57 $395.34 $1,149.91 $212,659.73
60 Dec-18 $212,659.73 $753.17 $396.74 $1,149.91 $212,262.99
61 Jan-19 $212,262.99 $751.76 $398.14 $1,149.91 $211,864.85
62 Feb-19 $211,864.85 $750.35 $399.55 $1,149.91 $211,465.29
63 Mar-19 $211,465.29 $748.94 $400.97 $1,149.91 $211,064.32
64 Apr-19 $211,064.32 $747.52 $402.39 $1,149.91 $210,661.93
65 May-19 $210,661.93 $746.09 $403.82 $1,149.91 $210,258.12
66 Jun-19 $210,258.12 $744.66 $405.25 $1,149.91 $209,852.87
67 Jul-19 $209,852.87 $743.23 $406.68 $1,149.91 $209,446.19
68 Aug-19 $209,446.19 $741.79 $408.12 $1,149.91 $209,038.07
69 Sep-19 $209,038.07 $740.34 $409.57 $1,149.91 $208,628.50
70 Oct-19 $208,628.50 $738.89 $411.02 $1,149.91 $208,217.49
71 Nov-19 $208,217.49 $737.44 $412.47 $1,149.91 $207,805.01
72 Dec-19 $207,805.01 $735.98 $413.93 $1,149.91 $207,391.08
73 Jan-20 $207,391.08 $734.51 $415.40 $1,149.91 $206,975.68
74 Feb-20 $206,975.68 $733.04 $416.87 $1,149.91 $206,558.81
75 Mar-20 $206,558.81 $731.56 $418.35 $1,149.91 $206,140.46
76 Apr-20 $206,140.46 $730.08 $419.83 $1,149.91 $205,720.63
77 May-20 $205,720.63 $728.59 $421.32 $1,149.91 $205,299.32
78 Jun-20 $205,299.32 $727.10 $422.81 $1,149.91 $204,876.51
79 Jul-20 $204,876.51 $725.60 $424.31 $1,149.91 $204,452.21
80 Aug-20 $204,452.21 $724.10 $425.81 $1,149.91 $204,026.40
81 Sep-20 $204,026.40 $722.59 $427.32 $1,149.91 $203,599.08
82 Oct-20 $203,599.08 $721.08 $428.83 $1,149.91 $203,170.25
83 Nov-20 $203,170.25 $719.56 $430.35 $1,149.91 $202,739.90
84 Dec-20 $202,739.90 $718.04 $431.87 $1,149.91 $202,308.03
85 Jan-21 $202,308.03 $716.51 $433.40 $1,149.91 $201,874.63
86 Feb-21 $201,874.63 $714.97 $434.94 $1,149.91 $201,439.69
87 Mar-21 $201,439.69 $713.43 $436.48 $1,149.91 $201,003.22
88 Apr-21 $201,003.22 $711.89 $438.02 $1,149.91 $200,565.19
89 May-21 $200,565.19 $710.34 $439.57 $1,149.91 $200,125.62
90 Jun-21 $200,125.62 $708.78 $441.13 $1,149.91 $199,684.49
91 Jul-21 $199,684.49 $707.22 $442.69 $1,149.91 $199,241.79
92 Aug-21 $199,241.79 $705.65 $444.26 $1,149.91 $198,797.53
93 Sep-21 $198,797.53 $704.07 $445.83 $1,149.91 $198,351.70
94 Oct-21 $198,351.70 $702.50 $447.41 $1,149.91 $197,904.28
95 Nov-21 $197,904.28 $700.91 $449.00 $1,149.91 $197,455.28
96 Dec-21 $197,455.28 $699.32 $450.59 $1,149.91 $197,004.70
97 Jan-22 $197,004.70 $697.72 $452.18 $1,149.91 $196,552.51
98 Feb-22 $196,552.51 $696.12 $453.79 $1,149.91 $196,098.73
99 Mar-22 $196,098.73 $694.52 $455.39 $1,149.91 $195,643.33
100 Apr-22 $195,643.33 $692.90 $457.01 $1,149.91 $195,186.33
101 May-22 $195,186.33 $691.28 $458.62 $1,149.91 $194,727.70
102 Jun-22 $194,727.70 $689.66 $460.25 $1,149.91 $194,267.45
103 Jul-22 $194,267.45 $688.03 $461.88 $1,149.91 $193,805.57
104 Aug-22 $193,805.57 $686.39 $463.51 $1,149.91 $193,342.06
105 Sep-22 $193,342.06 $684.75 $465.16 $1,149.91 $192,876.90
106 Oct-22 $192,876.90 $683.11 $466.80 $1,149.91 $192,410.10
107 Nov-22 $192,410.10 $681.45 $468.46 $1,149.91 $191,941.64
108 Dec-22 $191,941.64 $679.79 $470.12 $1,149.91 $191,471.53
109 Jan-23 $191,471.53 $678.13 $471.78 $1,149.91 $190,999.74
110 Feb-23 $190,999.74 $676.46 $473.45 $1,149.91 $190,526.29
111 Mar-23 $190,526.29 $674.78 $475.13 $1,149.91 $190,051.16
112 Apr-23 $190,051.16 $673.10 $476.81 $1,149.91 $189,574.35
113 May-23 $189,574.35 $671.41 $478.50 $1,149.91 $189,095.85
114 Jun-23 $189,095.85 $669.71 $480.20 $1,149.91 $188,615.66
115 Jul-23 $188,615.66 $668.01 $481.90 $1,149.91 $188,133.76
116 Aug-23 $188,133.76 $666.31 $483.60 $1,149.91 $187,650.16
117 Sep-23 $187,650.16 $664.59 $485.32 $1,149.91 $187,164.84
118 Oct-23 $187,164.84 $662.88 $487.03 $1,149.91 $186,677.81
119 Nov-23 $186,677.81 $661.15 $488.76 $1,149.91 $186,189.05
120 Dec-23 $186,189.05 $659.42 $490.49 $1,149.91 $185,698.56
121 Jan-24 $185,698.56 $657.68 $492.23 $1,149.91 $185,206.33
122 Feb-24 $185,206.33 $655.94 $493.97 $1,149.91 $184,712.36
123 Mar-24 $184,712.36 $654.19 $495.72 $1,149.91 $184,216.64
124 Apr-24 $184,216.64 $652.43 $497.48 $1,149.91 $183,719.17
125 May-24 $183,719.17 $650.67 $499.24 $1,149.91 $183,219.93
126 Jun-24 $183,219.93 $648.90 $501.01 $1,149.91 $182,718.92
127 Jul-24 $182,718.92 $647.13 $502.78 $1,149.91 $182,216.14
128 Aug-24 $182,216.14 $645.35 $504.56 $1,149.91 $181,711.58
129 Sep-24 $181,711.58 $643.56 $506.35 $1,149.91 $181,205.24
130 Oct-24 $181,205.24 $641.77 $508.14 $1,149.91 $180,697.10
131 Nov-24 $180,697.10 $639.97 $509.94 $1,149.91 $180,187.15
132 Dec-24 $180,187.15 $638.16 $511.75 $1,149.91 $179,675.41
133 Jan-25 $179,675.41 $636.35 $513.56 $1,149.91 $179,161.85
134 Feb-25 $179,161.85 $634.53 $515.38 $1,149.91 $178,646.47
135 Mar-25 $178,646.47 $632.71 $517.20 $1,149.91 $178,129.27
136 Apr-25 $178,129.27 $630.87 $519.04 $1,149.91 $177,610.23
137 May-25 $177,610.23 $629.04 $520.87 $1,149.91 $177,089.36
138 Jun-25 $177,089.36 $627.19 $522.72 $1,149.91 $176,566.64
139 Jul-25 $176,566.64 $625.34 $524.57 $1,149.91 $176,042.07
140 Aug-25 $176,042.07 $623.48 $526.43 $1,149.91 $175,515.65
141 Sep-25 $175,515.65 $621.62 $528.29 $1,149.91 $174,987.35
142 Oct-25 $174,987.35 $619.75 $530.16 $1,149.91 $174,457.19
143 Nov-25 $174,457.19 $617.87 $532.04 $1,149.91 $173,925.15
144 Dec-25 $173,925.15 $615.98 $533.92 $1,149.91 $173,391.23
145 Jan-26 $173,391.23 $614.09 $535.82 $1,149.91 $172,855.41
146 Feb-26 $172,855.41 $612.20 $537.71 $1,149.91 $172,317.70
147 Mar-26 $172,317.70 $610.29 $539.62 $1,149.91 $171,778.08
148 Apr-26 $171,778.08 $608.38 $541.53 $1,149.91 $171,236.55
149 May-26 $171,236.55 $606.46 $543.45 $1,149.91 $170,693.10
150 Jun-26 $170,693.10 $604.54 $545.37 $1,149.91 $170,147.73
151 Jul-26 $170,147.73 $602.61 $547.30 $1,149.91 $169,600.43
152 Aug-26 $169,600.43 $600.67 $549.24 $1,149.91 $169,051.19
153 Sep-26 $169,051.19 $598.72 $551.19 $1,149.91 $168,500.00
154 Oct-26 $168,500.00 $596.77 $553.14 $1,149.91 $167,946.86
155 Nov-26 $167,946.86 $594.81 $555.10 $1,149.91 $167,391.77
156 Dec-26 $167,391.77 $592.85 $557.06 $1,149.91 $166,834.70
157 Jan-27 $166,834.70 $590.87 $559.04 $1,149.91 $166,275.67
158 Feb-27 $166,275.67 $588.89 $561.02 $1,149.91 $165,714.65
159 Mar-27 $165,714.65 $586.91 $563.00 $1,149.91 $165,151.65
160 Apr-27 $165,151.65 $584.91 $565.00 $1,149.91 $164,586.65
161 May-27 $164,586.65 $582.91 $567.00 $1,149.91 $164,019.65
162 Jun-27 $164,019.65 $580.90 $569.01 $1,149.91 $163,450.64
163 Jul-27 $163,450.64 $578.89 $571.02 $1,149.91 $162,879.62
164 Aug-27 $162,879.62 $576.87 $573.04 $1,149.91 $162,306.58
165 Sep-27 $162,306.58 $574.84 $575.07 $1,149.91 $161,731.50
166 Oct-27 $161,731.50 $572.80 $577.11 $1,149.91 $161,154.39
167 Nov-27 $161,154.39 $570.76 $579.15 $1,149.91 $160,575.24
168 Dec-27 $160,575.24 $568.70 $581.21 $1,149.91 $159,994.03
169 Jan-28 $159,994.03 $566.65 $583.26 $1,149.91 $159,410.77
170 Feb-28 $159,410.77 $564.58 $585.33 $1,149.91 $158,825.44
171 Mar-28 $158,825.44 $562.51 $587.40 $1,149.91 $158,238.04
172 Apr-28 $158,238.04 $560.43 $589.48 $1,149.91 $157,648.55
173 May-28 $157,648.55 $558.34 $591.57 $1,149.91 $157,056.98
174 Jun-28 $157,056.98 $556.24 $593.67 $1,149.91 $156,463.32
175 Jul-28 $156,463.32 $554.14 $595.77 $1,149.91 $155,867.55
176 Aug-28 $155,867.55 $552.03 $597.88 $1,149.91 $155,269.67
177 Sep-28 $155,269.67 $549.91 $600.00 $1,149.91 $154,669.67
178 Oct-28 $154,669.67 $547.79 $602.12 $1,149.91 $154,067.55
179 Nov-28 $154,067.55 $545.66 $604.25 $1,149.91 $153,463.30
180 Dec-28 $153,463.30 $543.52 $606.39 $1,149.91 $152,856.90
181 Jan-29 $152,856.90 $541.37 $608.54 $1,149.91 $152,248.36
182 Feb-29 $152,248.36 $539.21 $610.70 $1,149.91 $151,637.67
183 Mar-29 $151,637.67 $537.05 $612.86 $1,149.91 $151,024.81
184 Apr-29 $151,024.81 $534.88 $615.03 $1,149.91 $150,409.78
185 May-29 $150,409.78 $532.70 $617.21 $1,149.91 $149,792.57
186 Jun-29 $149,792.57 $530.52 $619.39 $1,149.91 $149,173.18
187 Jul-29 $149,173.18 $528.32 $621.59 $1,149.91 $148,551.59
188 Aug-29 $148,551.59 $526.12 $623.79 $1,149.91 $147,927.80
189 Sep-29 $147,927.80 $523.91 $626.00 $1,149.91 $147,301.80
190 Oct-29 $147,301.80 $521.69 $628.22 $1,149.91 $146,673.58
191 Nov-29 $146,673.58 $519.47 $630.44 $1,149.91 $146,043.14
192 Dec-29 $146,043.14 $517.24 $632.67 $1,149.91 $145,410.47
193 Jan-30 $145,410.47 $515.00 $634.91 $1,149.91 $144,775.56
194 Feb-30 $144,775.56 $512.75 $637.16 $1,149.91 $144,138.39
195 Mar-30 $144,138.39 $510.49 $639.42 $1,149.91 $143,498.97
196 Apr-30 $143,498.97 $508.23 $641.68 $1,149.91 $142,857.29
197 May-30 $142,857.29 $505.95 $643.96 $1,149.91 $142,213.33
198 Jun-30 $142,213.33 $503.67 $646.24 $1,149.91 $141,567.10
199 Jul-30 $141,567.10 $501.38 $648.53 $1,149.91 $140,918.57
200 Aug-30 $140,918.57 $499.09 $650.82 $1,149.91 $140,267.75
201 Sep-30 $140,267.75 $496.78 $653.13 $1,149.91 $139,614.62
202 Oct-30 $139,614.62 $494.47 $655.44 $1,149.91 $138,959.18
203 Nov-30 $138,959.18 $492.15 $657.76 $1,149.91 $138,301.42
204 Dec-30 $138,301.42 $489.82 $660.09 $1,149.91 $137,641.32
205 Jan-31 $137,641.32 $487.48 $662.43 $1,149.91 $136,978.89
206 Feb-31 $136,978.89 $485.13 $664.78 $1,149.91 $136,314.12
207 Mar-31 $136,314.12 $482.78 $667.13 $1,149.91 $135,646.99
208 Apr-31 $135,646.99 $480.42 $669.49 $1,149.91 $134,977.49
209 May-31 $134,977.49 $478.05 $671.86 $1,149.91 $134,305.63
210 Jun-31 $134,305.63 $475.67 $674.24 $1,149.91 $133,631.39
211 Jul-31 $133,631.39 $473.28 $676.63 $1,149.91 $132,954.76
212 Aug-31 $132,954.76 $470.88 $679.03 $1,149.91 $132,275.73
213 Sep-31 $132,275.73 $468.48 $681.43 $1,149.91 $131,594.29
214 Oct-31 $131,594.29 $466.06 $683.85 $1,149.91 $130,910.45
215 Nov-31 $130,910.45 $463.64 $686.27 $1,149.91 $130,224.18
216 Dec-31 $130,224.18 $461.21 $688.70 $1,149.91 $129,535.48
217 Jan-32 $129,535.48 $458.77 $691.14 $1,149.91 $128,844.34
218 Feb-32 $128,844.34 $456.32 $693.59 $1,149.91 $128,150.76
219 Mar-32 $128,150.76 $453.87 $696.04 $1,149.91 $127,454.71
220 Apr-32 $127,454.71 $451.40 $698.51 $1,149.91 $126,756.21
221 May-32 $126,756.21 $448.93 $700.98 $1,149.91 $126,055.23
222 Jun-32 $126,055.23 $446.45 $703.46 $1,149.91 $125,351.76
223 Jul-32 $125,351.76 $443.95 $705.96 $1,149.91 $124,645.81
224 Aug-32 $124,645.81 $441.45 $708.46 $1,149.91 $123,937.35
225 Sep-32 $123,937.35 $438.94 $710.96 $1,149.91 $123,226.39
226 Oct-32 $123,226.39 $436.43 $713.48 $1,149.91 $122,512.90
227 Nov-32 $122,512.90 $433.90 $716.01 $1,149.91 $121,796.89
228 Dec-32 $121,796.89 $431.36 $718.55 $1,149.91 $121,078.35
229 Jan-33 $121,078.35 $428.82 $721.09 $1,149.91 $120,357.26
230 Feb-33 $120,357.26 $426.27 $723.64 $1,149.91 $119,633.61
231 Mar-33 $119,633.61 $423.70 $726.21 $1,149.91 $118,907.41
232 Apr-33 $118,907.41 $421.13 $728.78 $1,149.91 $118,178.63
233 May-33 $118,178.63 $418.55 $731.36 $1,149.91 $117,447.27
234 Jun-33 $117,447.27 $415.96 $733.95 $1,149.91 $116,713.32
235 Jul-33 $116,713.32 $413.36 $736.55 $1,149.91 $115,976.77
236 Aug-33 $115,976.77 $410.75 $739.16 $1,149.91 $115,237.61
237 Sep-33 $115,237.61 $408.13 $741.78 $1,149.91 $114,495.83
238 Oct-33 $114,495.83 $405.51 $744.40 $1,149.91 $113,751.43
239 Nov-33 $113,751.43 $402.87 $747.04 $1,149.91 $113,004.39
240 Dec-33 $113,004.39 $400.22 $749.69 $1,149.91 $112,254.70
241 Jan-34 $112,254.70 $397.57 $752.34 $1,149.91 $111,502.36
242 Feb-34 $111,502.36 $394.90 $755.01 $1,149.91 $110,747.36
243 Mar-34 $110,747.36 $392.23 $757.68 $1,149.91 $109,989.68
244 Apr-34 $109,989.68 $389.55 $760.36 $1,149.91 $109,229.32
245 May-34 $109,229.32 $386.85 $763.06 $1,149.91 $108,466.26
246 Jun-34 $108,466.26 $384.15 $765.76 $1,149.91 $107,700.50
247 Jul-34 $107,700.50 $381.44 $768.47 $1,149.91 $106,932.03
248 Aug-34 $106,932.03 $378.72 $771.19 $1,149.91 $106,160.84
249 Sep-34 $106,160.84 $375.99 $773.92 $1,149.91 $105,386.92
250 Oct-34 $105,386.92 $373.25 $776.66 $1,149.91 $104,610.25
251 Nov-34 $104,610.25 $370.49 $779.41 $1,149.91 $103,830.84
252 Dec-34 $103,830.84 $367.73 $782.18 $1,149.91 $103,048.66
253 Jan-35 $103,048.66 $364.96 $784.95 $1,149.91 $102,263.72
254 Feb-35 $102,263.72 $362.18 $787.73 $1,149.91 $101,475.99
255 Mar-35 $101,475.99 $359.39 $790.52 $1,149.91 $100,685.48
256 Apr-35 $100,685.48 $356.59 $793.32 $1,149.91 $99,892.16
257 May-35 $99,892.16 $353.78 $796.12 $1,149.91 $99,096.04
258 Jun-35 $99,096.04 $350.97 $798.94 $1,149.91 $98,297.09
259 Jul-35 $98,297.09 $348.14 $801.77 $1,149.91 $97,495.32
260 Aug-35 $97,495.32 $345.30 $804.61 $1,149.91 $96,690.70
261 Sep-35 $96,690.70 $342.45 $807.46 $1,149.91 $95,883.24
262 Oct-35 $95,883.24 $339.59 $810.32 $1,149.91 $95,072.92
263 Nov-35 $95,072.92 $336.72 $813.19 $1,149.91 $94,259.72
264 Dec-35 $94,259.72 $333.84 $816.07 $1,149.91 $93,443.65
265 Jan-36 $93,443.65 $330.95 $818.96 $1,149.91 $92,624.69
266 Feb-36 $92,624.69 $328.05 $821.86 $1,149.91 $91,802.83
267 Mar-36 $91,802.83 $325.14 $824.77 $1,149.91 $90,978.05
268 Apr-36 $90,978.05 $322.21 $827.70 $1,149.91 $90,150.35
269 May-36 $90,150.35 $319.28 $830.63 $1,149.91 $89,319.73
270 Jun-36 $89,319.73 $316.34 $833.57 $1,149.91 $88,486.16
271 Jul-36 $88,486.16 $313.39 $836.52 $1,149.91 $87,649.64
272 Aug-36 $87,649.64 $310.43 $839.48 $1,149.91 $86,810.15
273 Sep-36 $86,810.15 $307.45 $842.46 $1,149.91 $85,967.70
274 Oct-36 $85,967.70 $304.47 $845.44 $1,149.91 $85,122.26
275 Nov-36 $85,122.26 $301.47 $848.43 $1,149.91 $84,273.82
276 Dec-36 $84,273.82 $298.47 $851.44 $1,149.91 $83,422.38
277 Jan-37 $83,422.38 $295.45 $854.46 $1,149.91 $82,567.93
278 Feb-37 $82,567.93 $292.43 $857.48 $1,149.91 $81,710.45
279 Mar-37 $81,710.45 $289.39 $860.52 $1,149.91 $80,849.93
280 Apr-37 $80,849.93 $286.34 $863.57 $1,149.91 $79,986.36
281 May-37 $79,986.36 $283.29 $866.62 $1,149.91 $79,119.74
282 Jun-37 $79,119.74 $280.22 $869.69 $1,149.91 $78,250.04
283 Jul-37 $78,250.04 $277.14 $872.77 $1,149.91 $77,377.27
284 Aug-37 $77,377.27 $274.04 $875.86 $1,149.91 $76,501.40
285 Sep-37 $76,501.40 $270.94 $878.97 $1,149.91 $75,622.44
286 Oct-37 $75,622.44 $267.83 $882.08 $1,149.91 $74,740.36
287 Nov-37 $74,740.36 $264.71 $885.20 $1,149.91 $73,855.15
288 Dec-37 $73,855.15 $261.57 $888.34 $1,149.91 $72,966.81
289 Jan-38 $72,966.81 $258.42 $891.49 $1,149.91 $72,075.33
290 Feb-38 $72,075.33 $255.27 $894.64 $1,149.91 $71,180.69
291 Mar-38 $71,180.69 $252.10 $897.81 $1,149.91 $70,282.87
292 Apr-38 $70,282.87 $248.92 $900.99 $1,149.91 $69,381.88
293 May-38 $69,381.88 $245.73 $904.18 $1,149.91 $68,477.70
294 Jun-38 $68,477.70 $242.53 $907.38 $1,149.91 $67,570.32
295 Jul-38 $67,570.32 $239.31 $910.60 $1,149.91 $66,659.72
296 Aug-38 $66,659.72 $236.09 $913.82 $1,149.91 $65,745.90
297 Sep-38 $65,745.90 $232.85 $917.06 $1,149.91 $64,828.84
298 Oct-38 $64,828.84 $229.60 $920.31 $1,149.91 $63,908.53
299 Nov-38 $63,908.53 $226.34 $923.57 $1,149.91 $62,984.96
300 Dec-38 $62,984.96 $223.07 $926.84 $1,149.91 $62,058.13
301 Jan-39 $62,058.13 $219.79 $930.12 $1,149.91 $61,128.00
302 Feb-39 $61,128.00 $216.50 $933.41 $1,149.91 $60,194.59
303 Mar-39 $60,194.59 $213.19 $936.72 $1,149.91 $59,257.87
304 Apr-39 $59,257.87 $209.87 $940.04 $1,149.91 $58,317.83
305 May-39 $58,317.83 $206.54 $943.37 $1,149.91 $57,374.47
306 Jun-39 $57,374.47 $203.20 $946.71 $1,149.91 $56,427.76
307 Jul-39 $56,427.76 $199.85 $950.06 $1,149.91 $55,477.70
308 Aug-39 $55,477.70 $196.48 $953.43 $1,149.91 $54,524.27
309 Sep-39 $54,524.27 $193.11 $956.80 $1,149.91 $53,567.47
310 Oct-39 $53,567.47 $189.72 $960.19 $1,149.91 $52,607.28
311 Nov-39 $52,607.28 $186.32 $963.59 $1,149.91 $51,643.68
312 Dec-39 $51,643.68 $182.90 $967.00 $1,149.91 $50,676.68
313 Jan-40 $50,676.68 $179.48 $970.43 $1,149.91 $49,706.25
314 Feb-40 $49,706.25 $176.04 $973.87 $1,149.91 $48,732.38
315 Mar-40 $48,732.38 $172.59 $977.32 $1,149.91 $47,755.07
316 Apr-40 $47,755.07 $169.13 $980.78 $1,149.91 $46,774.29
317 May-40 $46,774.29 $165.66 $984.25 $1,149.91 $45,790.04
318 Jun-40 $45,790.04 $162.17 $987.74 $1,149.91 $44,802.30
319 Jul-40 $44,802.30 $158.67 $991.23 $1,149.91 $43,811.07
320 Aug-40 $43,811.07 $155.16 $994.75 $1,149.91 $42,816.32
321 Sep-40 $42,816.32 $151.64 $998.27 $1,149.91 $41,818.05
322 Oct-40 $41,818.05 $148.11 $1,001.80 $1,149.91 $40,816.25
323 Nov-40 $40,816.25 $144.56 $1,005.35 $1,149.91 $39,810.90
324 Dec-40 $39,810.90 $141.00 $1,008.91 $1,149.91 $38,801.99
325 Jan-41 $38,801.99 $137.42 $1,012.49 $1,149.91 $37,789.50
326 Feb-41 $37,789.50 $133.84 $1,016.07 $1,149.91 $36,773.43
327 Mar-41 $36,773.43 $130.24 $1,019.67 $1,149.91 $35,753.76
328 Apr-41 $35,753.76 $126.63 $1,023.28 $1,149.91 $34,730.48
329 May-41 $34,730.48 $123.00 $1,026.91 $1,149.91 $33,703.57
330 Jun-41 $33,703.57 $119.37 $1,030.54 $1,149.91 $32,673.03
331 Jul-41 $32,673.03 $115.72 $1,034.19 $1,149.91 $31,638.84
332 Aug-41 $31,638.84 $112.05 $1,037.86 $1,149.91 $30,600.98
333 Sep-41 $30,600.98 $108.38 $1,041.53 $1,149.91 $29,559.45
334 Oct-41 $29,559.45 $104.69 $1,045.22 $1,149.91 $28,514.23
335 Nov-41 $28,514.23 $100.99 $1,048.92 $1,149.91 $27,465.31
336 Dec-41 $27,465.31 $97.27 $1,052.64 $1,149.91 $26,412.67
337 Jan-42 $26,412.67 $93.54 $1,056.36 $1,149.91 $25,356.31
338 Feb-42 $25,356.31 $89.80 $1,060.11 $1,149.91 $24,296.20
339 Mar-42 $24,296.20 $86.05 $1,063.86 $1,149.91 $23,232.34
340 Apr-42 $23,232.34 $82.28 $1,067.63 $1,149.91 $22,164.71
341 May-42 $22,164.71 $78.50 $1,071.41 $1,149.91 $21,093.30
342 Jun-42 $21,093.30 $74.71 $1,075.20 $1,149.91 $20,018.10
343 Jul-42 $20,018.10 $70.90 $1,079.01 $1,149.91 $18,939.09
344 Aug-42 $18,939.09 $67.08 $1,082.83 $1,149.91 $17,856.25
345 Sep-42 $17,856.25 $63.24 $1,086.67 $1,149.91 $16,769.58
346 Oct-42 $16,769.58 $59.39 $1,090.52 $1,149.91 $15,679.07
347 Nov-42 $15,679.07 $55.53 $1,094.38 $1,149.91 $14,584.69
348 Dec-42 $14,584.69 $51.65 $1,098.26 $1,149.91 $13,486.43
349 Jan-43 $13,486.43 $47.76 $1,102.15 $1,149.91 $12,384.29
350 Feb-43 $12,384.29 $43.86 $1,106.05 $1,149.91 $11,278.24
351 Mar-43 $11,278.24 $39.94 $1,109.97 $1,149.91 $10,168.27
352 Apr-43 $10,168.27 $36.01 $1,113.90 $1,149.91 $9,054.38
353 May-43 $9,054.38 $32.07 $1,117.84 $1,149.91 $7,936.53
354 Jun-43 $7,936.53 $28.11 $1,121.80 $1,149.91 $6,814.73
355 Jul-43 $6,814.73 $24.14 $1,125.77 $1,149.91 $5,688.96
356 Aug-43 $5,688.96 $20.15 $1,129.76 $1,149.91 $4,559.20
357 Sep-43 $4,559.20 $16.15 $1,133.76 $1,149.91 $3,425.44
358 Oct-43 $3,425.44 $12.13 $1,137.78 $1,149.91 $2,287.66
359 Nov-43 $2,287.66 $8.10 $1,141.81 $1,149.91 $1,145.85
360 Dec-43 $1,145.85 $4.06 $1,145.85 $1,149.91 $0.00
Total $180,217.42 $233,750.00 $413,967.42