ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
AddressPayment Schedule
2
Year1234RentExpenses
3
Property Value$150,000.00$150,000.00$150,000.00$150,000.00900Taxes$950.00PaymentInterestPrincipalCumulativeCumulativeRemainingDate of LoanYearInterest Rate
4
Loans$120,000.00$117,886.74$115,687.37$113,398.41900Insurance$750.00NumberInterestPrincipalBalancePayment120,000.0014.00%
5
Equity$30,000.00$32,113.26$34,312.63$36,601.59900Utilities$0.001$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.000900Maintenance$600.002$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.000900Repairs$1,200.003$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.80Management$0.004$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.58Misc$600.005$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.226$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.80Total4,100.007$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.918$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.499$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.3810$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.80appreciation0.00%11$572.90$394.15 $178.75 $4,367.98 $1,933.92 $118,066.08
16
Basic Return8.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.0013$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.8014$572.90$392.36 $180.54 $5,546.85 $2,473.75 $117,526.25
19
Return on Equity8.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.5717$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.7418$572.90$389.94 $182.96 $7,110.23 $3,201.97 $116,798.03
23
Total ROI8.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 ROI7.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