ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
AddressPayment Schedule
2
Year1234RentExpenses
3
Property Value$150,000.00$150,000.00$150,000.00$150,000.001500Taxes$950.00PaymentInterestPrincipalCumulativeCumulativeRemainingDate of LoanYearInterest Rate
4
Loans$120,000.00$117,543.99$114,936.50$112,168.181500Insurance$750.00NumberInterestPrincipalBalancePayment200,000.0016.00%
5
Equity$30,000.00$32,456.01$35,063.50$37,831.821500Utilities$0.001$1,199.10$1,000.00 $199.10 $1,000.00 $199.10 $199,800.90 Sep-17
6
Gross annual Income$18,000.00$18,000.00$18,000.000$18,000.0001500Maintenance$600.002$1,199.10$999.00 $200.10 $1,999.00 $399.20 $199,600.80
7
Expenses$4,100.00$4,100.000$4,100.000$4,100.0001500Repairs$1,200.003$1,199.10$998.00 $201.10 $2,997.01 $600.29 $199,399.71
8
Loan Payments$14,389.20$14,389.20$14,389.20$14,389.20Management$0.004$1,199.10$997.00 $202.10 $3,994.01 $802.39 $199,197.61
9
Interest Payments$11,933.19$11,781.71$11,620.88$11,450.14Misc$600.005$1,199.10$995.99 $203.11 $4,990.00 $1,005.50 $198,994.50
10
Loan Payoff$2,456.01$2,607.49$2,768.32$2,939.066$1,199.10$994.97 $204.13 $5,984.97 $1,209.63 $198,790.37
11
Cash Flow-$489.20-$489.20-$489.20-$489.20Total4,100.007$1,199.10$993.95 $205.15 $6,978.92 $1,414.78 $198,585.22
12
Depreciation Deduction$4,090.91$4,090.91$4,090.91$4,090.918$1,199.10$992.93 $206.17 $7,971.85 $1,620.95 $198,379.05
13
Tax Shelter$2,124.10$1,972.62$1,811.79$1,641.059$1,199.10$991.90 $207.20 $8,963.74 $1,828.16 $198,171.84
14
Tax Savings$594.75$552.33$507.30$459.4910$1,199.10$990.86 $208.24 $9,954.60 $2,036.40 $197,963.60
15
Building Profit$2,561.56$2,670.62$2,786.42$2,909.35appreciation0.00%11$1,199.10$989.82 $209.28 $10,944.42 $2,245.68 $197,754.32
16
Basic Return8.54%8.23%7.95%7.69%12$1,199.10$988.77 $210.33 $11,933.19 $2,456.01 $197,543.99
17
Appreciation Estimate$0.00$0.00$0.00$0.0013$1,199.10$987.72 $211.38 $12,920.91 $2,667.39 $197,332.61
18
Total Investment Return$2,561.56$2,670.62$2,786.42$2,909.3514$1,199.10$986.66 $212.44 $13,907.57 $2,879.83 $197,120.17
19
Return on Equity8.54%8.23%7.95%7.69%15$1,199.10$985.60 $213.50 $14,893.17 $3,093.33 $196,906.67
20
16$1,199.10$984.53 $214.57 $15,877.71 $3,307.89 $196,692.11
21
Monthly cash flow-$40.77-$40.77-$40.77-$40.7717$1,199.10$983.46 $215.64 $16,861.17 $3,523.53 $196,476.47
22
Cumulative profit$2,561.56$5,232.18$8,018.60$10,927.9518$1,199.10$982.38 $216.72 $17,843.55 $3,740.25 $196,259.75
23
Total ROI8.54%17.44%26.73%36.43%19$1,199.10$981.30 $217.80 $18,824.85 $3,958.05 $196,041.95
24
Annualized ROI8.07%20$1,199.10$980.21 $218.89 $19,805.06 $4,176.94 $195,823.06
25
21$1,199.10$979.12 $219.98 $20,784.17 $4,396.93 $195,603.07
26
22$1,199.10$978.02 $221.08 $21,762.19 $4,618.01 $195,381.99
27
23$1,199.10$976.91 $222.19 $22,739.10 $4,840.20 $195,159.80
28
24$1,199.10$975.80 $223.30 $23,714.90 $5,063.50 $194,936.50
29
25$1,199.10$974.68 $224.42 $24,689.58 $5,287.92 $194,712.08
30
26$1,199.10$973.56 $225.54 $25,663.14 $5,513.46 $194,486.54
31
27$1,199.10$972.43 $226.67 $26,635.57 $5,740.13 $194,259.87
32
28$1,199.10$971.30 $227.80 $27,606.87 $5,967.93 $194,032.07
33
29$1,199.10$970.16 $228.94 $28,577.03 $6,196.87 $193,803.13
34
30$1,199.10$969.02 $230.08 $29,546.05 $6,426.95 $193,573.05
35
31$1,199.10$967.87 $231.23 $30,513.91 $6,658.19 $193,341.81
36
32$1,199.10$966.71 $232.39 $31,480.62 $6,890.58 $193,109.42
37
33$1,199.10$965.55 $233.55 $32,446.17 $7,124.13 $192,875.87
38
34$1,199.10$964.38 $234.72 $33,410.55 $7,358.85 $192,641.15
39
35$1,199.10$963.21 $235.89 $34,373.76 $7,594.74 $192,405.26
40
36$1,199.10$962.03 $237.07 $35,335.78 $7,831.82 $192,168.18
41
37$1,199.10$960.84 $238.26 $36,296.62 $8,070.08 $191,929.92
42
38$1,199.10$959.65 $239.45 $37,256.27 $8,309.53 $191,690.47
43
39$1,199.10$958.45 $240.65 $38,214.72 $8,550.18 $191,449.82
44
40$1,199.10$957.25 $241.85 $39,171.97 $8,792.03 $191,207.97
45
41$1,199.10$956.04 $243.06 $40,128.01 $9,035.09 $190,964.91
46
42$1,199.10$954.82 $244.28 $41,082.84 $9,279.36 $190,720.64
47
43$1,199.10$953.60 $245.50 $42,036.44 $9,524.86 $190,475.14
48
44$1,199.10$952.38 $246.72 $42,988.82 $9,771.58 $190,228.42
49
45$1,199.10$951.14 $247.96 $43,939.96 $10,019.54 $189,980.46
50
46$1,199.10$949.90 $249.20 $44,889.86 $10,268.74 $189,731.26
51
47$1,199.10$948.66 $250.44 $45,838.52 $10,519.18 $189,480.82
52
48$1,199.10$947.40 $251.70 $46,785.92 $10,770.88 $189,229.12
53
49$1,199.10$946.15 $252.95 $47,732.07 $11,023.83 $188,976.17
54
50$1,199.10$944.88 $254.22 $48,676.95 $11,278.05 $188,721.95
55
51$1,199.10$943.61 $255.49 $49,620.56 $11,533.54 $188,466.46
56
52$1,199.10$942.33 $256.77 $50,562.89 $11,790.31 $188,209.69
57
53$1,199.10$941.05 $258.05 $51,503.94 $12,048.36 $187,951.64
58
54$1,199.10$939.76 $259.34 $52,443.70 $12,307.70 $187,692.30
59
55$1,199.10$938.46 $260.64 $53,382.16 $12,568.34 $187,431.66
60
56$1,199.10$937.16 $261.94 $54,319.32 $12,830.28 $187,169.72
61
57$1,199.10$935.85 $263.25 $55,255.17 $13,093.53 $186,906.47
62
58$1,199.10$934.53 $264.57 $56,189.70 $13,358.10 $186,641.90
63
59$1,199.10$933.21 $265.89 $57,122.91 $13,623.99 $186,376.01
64
60$1,199.10$931.88 $267.22 $58,054.79 $13,891.21 $186,108.79
65
61$1,199.10$930.54 $268.56 $58,985.33 $14,159.77 $185,840.23
66
62$1,199.10$929.20 $269.90 $59,914.53 $14,429.67 $185,570.33
67
63$1,199.10$927.85 $271.25 $60,842.38 $14,700.92 $185,299.08
68
64$1,199.10$926.50 $272.60 $61,768.88 $14,973.52 $185,026.48
69
65$1,199.10$925.13 $273.97 $62,694.01 $15,247.49 $184,752.51
70
66$1,199.10$923.76 $275.34 $63,617.77 $15,522.83 $184,477.17
71
67$1,199.10$922.39 $276.71 $64,540.16 $15,799.54 $184,200.46
72
68$1,199.10$921.00 $278.10 $65,461.16 $16,077.64 $183,922.36
73
69$1,199.10$919.61 $279.49 $66,380.77 $16,357.13 $183,642.87
74
70$1,199.10$918.21 $280.89 $67,298.99 $16,638.01 $183,361.99
75
71$1,199.10$916.81 $282.29 $68,215.80 $16,920.30 $183,079.70
76
72$1,199.10$915.40 $283.70 $69,131.20 $17,204.00 $182,796.00
77
73$1,199.10$913.98 $285.12 $70,045.18 $17,489.12 $182,510.88
78
74$1,199.10$912.55 $286.55 $70,957.73 $17,775.67 $182,224.33
79
75$1,199.10$911.12 $287.98 $71,868.85 $18,063.65 $181,936.35
80
76$1,199.10$909.68 $289.42 $72,778.53 $18,353.07 $181,646.93
81
77$1,199.10$908.23 $290.87 $73,686.77 $18,643.93 $181,356.07
82
78$1,199.10$906.78 $292.32 $74,593.55 $18,936.25 $181,063.75
83
79$1,199.10$905.32 $293.78 $75,498.87 $19,230.03 $180,769.97
84
80$1,199.10$903.85 $295.25 $76,402.72 $19,525.28 $180,474.72
85
81$1,199.10$902.37 $296.73 $77,305.09 $19,822.01 $180,177.99
86
82$1,199.10$900.89 $298.21 $78,205.98 $20,120.22 $179,879.78
87
83$1,199.10$899.40 $299.70 $79,105.38 $20,419.92 $179,580.08
88
84$1,199.10$897.90 $301.20 $80,003.28 $20,721.12 $179,278.88
89
85$1,199.10$896.39 $302.71 $80,899.68 $21,023.82 $178,976.18
90
86$1,199.10$894.88 $304.22 $81,794.56 $21,328.04 $178,671.96
91
87$1,199.10$893.36 $305.74 $82,687.92 $21,633.78 $178,366.22
92
88$1,199.10$891.83 $307.27 $83,579.75 $21,941.05 $178,058.95
93
89$1,199.10$890.29 $308.81 $84,470.04 $22,249.86 $177,750.14
94
90$1,199.10$888.75 $310.35 $85,358.79 $22,560.21 $177,439.79
95
91$1,199.10$887.20 $311.90 $86,245.99 $22,872.11 $177,127.89
96
92$1,199.10$885.64 $313.46 $87,131.63 $23,185.57 $176,814.43
97
93$1,199.10$884.07 $315.03 $88,015.70 $23,500.60 $176,499.40
98
94$1,199.10$882.50 $316.60 $88,898.20 $23,817.20 $176,182.80
99
95$1,199.10$880.91 $318.19 $89,779.11 $24,135.39 $175,864.61
100
96$1,199.10$879.32 $319.78 $90,658.44 $24,455.16 $175,544.84