A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Address | Payment Schedule | ||||||||||||||||||||||||
2 | Year | 1 | 2 | 3 | 4 | Rent | Expenses | |||||||||||||||||||
3 | Property Value | $150,000.00 | $150,000.00 | $150,000.00 | $150,000.00 | 900 | Taxes | $950.00 | Payment | Interest | Principal | Cumulative | Cumulative | Remaining | Date of | Loan | Year | Interest Rate | ||||||||
4 | Loans | $120,000.00 | $117,886.74 | $115,687.37 | $113,398.41 | 900 | Insurance | $750.00 | Number | Interest | Principal | Balance | Payment | 120,000.00 | 1 | 4.00% | ||||||||||
5 | Equity | $30,000.00 | $32,113.26 | $34,312.63 | $36,601.59 | 900 | Utilities | $0.00 | 1 | $572.90 | $400.00 | $172.90 | $400.00 | $172.90 | $119,827.10 | Sep-17 | ||||||||||
6 | Gross annual Income | $10,800.00 | $10,800.00 | $10,800.000 | $10,800.000 | 900 | Maintenance | $600.00 | 2 | $572.90 | $399.42 | $173.48 | $799.42 | $346.38 | $119,653.62 | |||||||||||
7 | Expenses | $4,100.00 | $4,100.000 | $4,100.000 | $4,100.000 | 900 | Repairs | $1,200.00 | 3 | $572.90 | $398.85 | $174.05 | $1,198.27 | $520.43 | $119,479.57 | |||||||||||
8 | Loan Payments | $6,874.80 | $6,874.80 | $6,874.80 | $6,874.80 | Management | $0.00 | 4 | $572.90 | $398.27 | $174.63 | $1,596.53 | $695.07 | $119,304.93 | ||||||||||||
9 | Interest Payments | $4,761.54 | $4,675.44 | $4,585.83 | $4,492.58 | Misc | $600.00 | 5 | $572.90 | $397.68 | $175.22 | $1,994.22 | $870.28 | $119,129.72 | ||||||||||||
10 | Loan Payoff | $2,113.26 | $2,199.36 | $2,288.97 | $2,382.22 | 6 | $572.90 | $397.10 | $175.80 | $2,391.32 | $1,046.08 | $118,953.92 | ||||||||||||||
11 | Cash Flow | -$174.80 | -$174.80 | -$174.80 | -$174.80 | Total | 4,100.00 | 7 | $572.90 | $396.51 | $176.39 | $2,787.83 | $1,222.47 | $118,777.53 | ||||||||||||
12 | Depreciation Deduction | $4,090.91 | $4,090.91 | $4,090.91 | $4,090.91 | 8 | $572.90 | $395.93 | $176.97 | $3,183.75 | $1,399.45 | $118,600.55 | ||||||||||||||
13 | Tax Shelter | $2,152.45 | $2,066.35 | $1,976.74 | $1,883.49 | 9 | $572.90 | $395.34 | $177.56 | $3,579.09 | $1,577.01 | $118,422.99 | ||||||||||||||
14 | Tax Savings | $602.68 | $578.58 | $553.49 | $527.38 | 10 | $572.90 | $394.74 | $178.16 | $3,973.83 | $1,755.17 | $118,244.83 | ||||||||||||||
15 | Building Profit | $2,541.15 | $2,603.14 | $2,667.65 | $2,734.80 | appreciation | 0.00% | 11 | $572.90 | $394.15 | $178.75 | $4,367.98 | $1,933.92 | $118,066.08 | ||||||||||||
16 | Basic Return | 8.47% | 8.11% | 7.77% | 7.47% | 12 | $572.90 | $393.55 | $179.35 | $4,761.54 | $2,113.26 | $117,886.74 | ||||||||||||||
17 | Appreciation Estimate | $0.00 | $0.00 | $0.00 | $0.00 | 13 | $572.90 | $392.96 | $179.94 | $5,154.49 | $2,293.21 | $117,706.79 | ||||||||||||||
18 | Total Investment Return | $2,541.15 | $2,603.14 | $2,667.65 | $2,734.80 | 14 | $572.90 | $392.36 | $180.54 | $5,546.85 | $2,473.75 | $117,526.25 | ||||||||||||||
19 | Return on Equity | 8.47% | 8.11% | 7.77% | 7.47% | 15 | $572.90 | $391.75 | $181.15 | $5,938.60 | $2,654.90 | $117,345.10 | ||||||||||||||
20 | 16 | $572.90 | $391.15 | $181.75 | $6,329.75 | $2,836.65 | $117,163.35 | |||||||||||||||||||
21 | Monthly cash flow | -$14.57 | -$14.57 | -$14.57 | -$14.57 | 17 | $572.90 | $390.54 | $182.36 | $6,720.30 | $3,019.00 | $116,981.00 | ||||||||||||||
22 | Cumulative profit | $2,541.15 | $5,144.29 | $7,811.94 | $10,546.74 | 18 | $572.90 | $389.94 | $182.96 | $7,110.23 | $3,201.97 | $116,798.03 | ||||||||||||||
23 | Total ROI | 8.47% | 17.15% | 26.04% | 35.16% | 19 | $572.90 | $389.33 | $183.57 | $7,499.56 | $3,385.54 | $116,614.46 | ||||||||||||||
24 | Annualized ROI | 7.82% | 20 | $572.90 | $388.71 | $184.19 | $7,888.28 | $3,569.72 | $116,430.28 | |||||||||||||||||
25 | 21 | $572.90 | $388.10 | $184.80 | $8,276.38 | $3,754.52 | $116,245.48 | |||||||||||||||||||
26 | 22 | $572.90 | $387.48 | $185.42 | $8,663.86 | $3,939.94 | $116,060.06 | |||||||||||||||||||
27 | 23 | $572.90 | $386.87 | $186.03 | $9,050.73 | $4,125.97 | $115,874.03 | |||||||||||||||||||
28 | 24 | $572.90 | $386.25 | $186.65 | $9,436.97 | $4,312.63 | $115,687.37 | |||||||||||||||||||
29 | 25 | $572.90 | $385.62 | $187.28 | $9,822.60 | $4,499.90 | $115,500.10 | |||||||||||||||||||
30 | 26 | $572.90 | $385.00 | $187.90 | $10,207.60 | $4,687.80 | $115,312.20 | |||||||||||||||||||
31 | 27 | $572.90 | $384.37 | $188.53 | $10,591.97 | $4,876.33 | $115,123.67 | |||||||||||||||||||
32 | 28 | $572.90 | $383.75 | $189.15 | $10,975.72 | $5,065.48 | $114,934.52 | |||||||||||||||||||
33 | 29 | $572.90 | $383.12 | $189.78 | $11,358.83 | $5,255.27 | $114,744.73 | |||||||||||||||||||
34 | 30 | $572.90 | $382.48 | $190.42 | $11,741.32 | $5,445.68 | $114,554.32 | |||||||||||||||||||
35 | 31 | $572.90 | $381.85 | $191.05 | $12,123.16 | $5,636.74 | $114,363.26 | |||||||||||||||||||
36 | 32 | $572.90 | $381.21 | $191.69 | $12,504.38 | $5,828.42 | $114,171.58 | |||||||||||||||||||
37 | 33 | $572.90 | $380.57 | $192.33 | $12,884.95 | $6,020.75 | $113,979.25 | |||||||||||||||||||
38 | 34 | $572.90 | $379.93 | $192.97 | $13,264.88 | $6,213.72 | $113,786.28 | |||||||||||||||||||
39 | 35 | $572.90 | $379.29 | $193.61 | $13,644.17 | $6,407.33 | $113,592.67 | |||||||||||||||||||
40 | 36 | $572.90 | $378.64 | $194.26 | $14,022.81 | $6,601.59 | $113,398.41 | |||||||||||||||||||
41 | 37 | $572.90 | $377.99 | $194.91 | $14,400.80 | $6,796.50 | $113,203.50 | |||||||||||||||||||
42 | 38 | $572.90 | $377.35 | $195.55 | $14,778.15 | $6,992.05 | $113,007.95 | |||||||||||||||||||
43 | 39 | $572.90 | $376.69 | $196.21 | $15,154.84 | $7,188.26 | $112,811.74 | |||||||||||||||||||
44 | 40 | $572.90 | $376.04 | $196.86 | $15,530.88 | $7,385.12 | $112,614.88 | |||||||||||||||||||
45 | 41 | $572.90 | $375.38 | $197.52 | $15,906.26 | $7,582.64 | $112,417.36 | |||||||||||||||||||
46 | 42 | $572.90 | $374.72 | $198.18 | $16,280.99 | $7,780.81 | $112,219.19 | |||||||||||||||||||
47 | 43 | $572.90 | $374.06 | $198.84 | $16,655.05 | $7,979.65 | $112,020.35 | |||||||||||||||||||
48 | 44 | $572.90 | $373.40 | $199.50 | $17,028.45 | $8,179.15 | $111,820.85 | |||||||||||||||||||
49 | 45 | $572.90 | $372.74 | $200.16 | $17,401.19 | $8,379.31 | $111,620.69 | |||||||||||||||||||
50 | 46 | $572.90 | $372.07 | $200.83 | $17,773.26 | $8,580.14 | $111,419.86 | |||||||||||||||||||
51 | 47 | $572.90 | $371.40 | $201.50 | $18,144.66 | $8,781.64 | $111,218.36 | |||||||||||||||||||
52 | 48 | $572.90 | $370.73 | $202.17 | $18,515.38 | $8,983.82 | $111,016.18 | |||||||||||||||||||
53 | 49 | $572.90 | $370.05 | $202.85 | $18,885.44 | $9,186.66 | $110,813.34 | |||||||||||||||||||
54 | 50 | $572.90 | $369.38 | $203.52 | $19,254.82 | $9,390.18 | $110,609.82 | |||||||||||||||||||
55 | 51 | $572.90 | $368.70 | $204.20 | $19,623.52 | $9,594.38 | $110,405.62 | |||||||||||||||||||
56 | 52 | $572.90 | $368.02 | $204.88 | $19,991.53 | $9,799.27 | $110,200.73 | |||||||||||||||||||
57 | 53 | $572.90 | $367.34 | $205.56 | $20,358.87 | $10,004.83 | $109,995.17 | |||||||||||||||||||
58 | 54 | $572.90 | $366.65 | $206.25 | $20,725.52 | $10,211.08 | $109,788.92 | |||||||||||||||||||
59 | 55 | $572.90 | $365.96 | $206.94 | $21,091.48 | $10,418.02 | $109,581.98 | |||||||||||||||||||
60 | 56 | $572.90 | $365.27 | $207.63 | $21,456.76 | $10,625.64 | $109,374.36 | |||||||||||||||||||
61 | 57 | $572.90 | $364.58 | $208.32 | $21,821.34 | $10,833.96 | $109,166.04 | |||||||||||||||||||
62 | 58 | $572.90 | $363.89 | $209.01 | $22,185.23 | $11,042.97 | $108,957.03 | |||||||||||||||||||
63 | 59 | $572.90 | $363.19 | $209.71 | $22,548.42 | $11,252.68 | $108,747.32 | |||||||||||||||||||
64 | 60 | $572.90 | $362.49 | $210.41 | $22,910.91 | $11,463.09 | $108,536.91 | |||||||||||||||||||
65 | 61 | $572.90 | $361.79 | $211.11 | $23,272.70 | $11,674.20 | $108,325.80 | |||||||||||||||||||
66 | 62 | $572.90 | $361.09 | $211.81 | $23,633.78 | $11,886.02 | $108,113.98 | |||||||||||||||||||
67 | 63 | $572.90 | $360.38 | $212.52 | $23,994.16 | $12,098.54 | $107,901.46 | |||||||||||||||||||
68 | 64 | $572.90 | $359.67 | $213.23 | $24,353.83 | $12,311.77 | $107,688.23 | |||||||||||||||||||
69 | 65 | $572.90 | $358.96 | $213.94 | $24,712.79 | $12,525.71 | $107,474.29 | |||||||||||||||||||
70 | 66 | $572.90 | $358.25 | $214.65 | $25,071.04 | $12,740.36 | $107,259.64 | |||||||||||||||||||
71 | 67 | $572.90 | $357.53 | $215.37 | $25,428.57 | $12,955.73 | $107,044.27 | |||||||||||||||||||
72 | 68 | $572.90 | $356.81 | $216.09 | $25,785.39 | $13,171.81 | $106,828.19 | |||||||||||||||||||
73 | 69 | $572.90 | $356.09 | $216.81 | $26,141.48 | $13,388.62 | $106,611.38 | |||||||||||||||||||
74 | 70 | $572.90 | $355.37 | $217.53 | $26,496.85 | $13,606.15 | $106,393.85 | |||||||||||||||||||
75 | 71 | $572.90 | $354.65 | $218.25 | $26,851.50 | $13,824.40 | $106,175.60 | |||||||||||||||||||
76 | 72 | $572.90 | $353.92 | $218.98 | $27,205.42 | $14,043.38 | $105,956.62 | |||||||||||||||||||
77 | 73 | $572.90 | $353.19 | $219.71 | $27,558.61 | $14,263.09 | $105,736.91 | |||||||||||||||||||
78 | 74 | $572.90 | $352.46 | $220.44 | $27,911.06 | $14,483.54 | $105,516.46 | |||||||||||||||||||
79 | 75 | $572.90 | $351.72 | $221.18 | $28,262.79 | $14,704.71 | $105,295.29 | |||||||||||||||||||
80 | 76 | $572.90 | $350.98 | $221.92 | $28,613.77 | $14,926.63 | $105,073.37 | |||||||||||||||||||
81 | 77 | $572.90 | $350.24 | $222.66 | $28,964.01 | $15,149.29 | $104,850.71 | |||||||||||||||||||
82 | 78 | $572.90 | $349.50 | $223.40 | $29,313.52 | $15,372.68 | $104,627.32 | |||||||||||||||||||
83 | 79 | $572.90 | $348.76 | $224.14 | $29,662.27 | $15,596.83 | $104,403.17 | |||||||||||||||||||
84 | 80 | $572.90 | $348.01 | $224.89 | $30,010.28 | $15,821.72 | $104,178.28 | |||||||||||||||||||
85 | 81 | $572.90 | $347.26 | $225.64 | $30,357.55 | $16,047.35 | $103,952.65 | |||||||||||||||||||
86 | 82 | $572.90 | $346.51 | $226.39 | $30,704.05 | $16,273.75 | $103,726.25 | |||||||||||||||||||
87 | 83 | $572.90 | $345.75 | $227.15 | $31,049.81 | $16,500.89 | $103,499.11 | |||||||||||||||||||
88 | 84 | $572.90 | $345.00 | $227.90 | $31,394.81 | $16,728.79 | $103,271.21 | |||||||||||||||||||
89 | 85 | $572.90 | $344.24 | $228.66 | $31,739.04 | $16,957.46 | $103,042.54 | |||||||||||||||||||
90 | 86 | $572.90 | $343.48 | $229.42 | $32,082.52 | $17,186.88 | $102,813.12 | |||||||||||||||||||
91 | 87 | $572.90 | $342.71 | $230.19 | $32,425.23 | $17,417.07 | $102,582.93 | |||||||||||||||||||
92 | 88 | $572.90 | $341.94 | $230.96 | $32,767.17 | $17,648.03 | $102,351.97 | |||||||||||||||||||
93 | 89 | $572.90 | $341.17 | $231.73 | $33,108.35 | $17,879.75 | $102,120.25 | |||||||||||||||||||
94 | 90 | $572.90 | $340.40 | $232.50 | $33,448.75 | $18,112.25 | $101,887.75 | |||||||||||||||||||
95 | 91 | $572.90 | $339.63 | $233.27 | $33,788.37 | $18,345.53 | $101,654.47 | |||||||||||||||||||
96 | 92 | $572.90 | $338.85 | $234.05 | $34,127.22 | $18,579.58 | $101,420.42 | |||||||||||||||||||
97 | 93 | $572.90 | $338.07 | $234.83 | $34,465.29 | $18,814.41 | $101,185.59 | |||||||||||||||||||
98 | 94 | $572.90 | $337.29 | $235.61 | $34,802.57 | $19,050.03 | $100,949.97 | |||||||||||||||||||
99 | 95 | $572.90 | $336.50 | $236.40 | $35,139.07 | $19,286.43 | $100,713.57 | |||||||||||||||||||
100 | 96 | $572.90 | $335.71 | $237.19 | $35,474.79 | $19,523.61 | $100,476.39 |