I have done have of the project. Just finish it.
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 |