| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Year | Inc | Debt | Rate | Monthly Debt Svc | Annual Int Pd on Debt | Exp / Month | Savings | Rate of Return | IRA bal | Year | Inc | Debt | Rate | Monthly Debt Svc | Annual Int Pd on Debt | Exp / Month | Savings | Rate of Return | IRA bal | |
2 | 1 | $160,000 | $100,000 | 0.08 | ($2,027.64) | ($7,387.66) | ($6,500.00) | $1,668.33 | 0.03 | $1,718.38 | 1 | $160,000 | $100,000 | 0.08 | ($1,213.28) | ($7,754.07) | ($6,500.00) | $11,440.69 | 0.03 | $11,783.91 | |
3 | 2 | $170,000 | $76,882 | 0.08 | ($2,027.64) | ($5,981.32) | ($6,500.00) | $8,168.33 | 0.03 | $10,183.30 | 2 | $170,000 | $93,195 | 0.08 | ($1,213.28) | ($7,189.23) | ($6,500.00) | $17,940.69 | 0.03 | $30,616.34 | |
4 | 3 | $185,000 | $53,763 | 0.08 | ($2,027.64) | ($4,458.25) | ($6,500.00) | $17,918.33 | 0.03 | $28,944.68 | 3 | $185,000 | $85,825 | 0.08 | ($1,213.28) | ($6,577.52) | ($6,500.00) | $27,690.69 | 0.03 | $60,056.24 | |
5 | 4 | $210,000 | $30,645 | 0.08 | ($2,027.64) | ($2,808.76) | ($6,500.00) | $34,168.33 | 0.03 | $65,006.40 | 4 | $210,000 | $77,843 | 0.08 | ($1,213.28) | ($5,915.04) | ($6,500.00) | $43,940.69 | 0.03 | $107,116.83 | |
6 | 5 | $230,000 | $7,526 | 0.08 | ($2,027.64) | ($1,022.37) | ($6,500.00) | $47,168.33 | 0.03 | $115,539.97 | 5 | $230,000 | $69,199 | 0.08 | ($1,213.28) | ($5,197.57) | ($6,500.00) | $56,940.69 | 0.03 | $168,979.25 | |
7 | 6 | $250,000 | ($6,500.00) | $84,500.00 | 0.03 | $206,041.17 | 6 | $250,000 | $59,837 | 0.08 | ($1,213.28) | ($4,420.55) | ($6,500.00) | $69,940.69 | 0.03 | $246,087.53 | |||||
8 | 7 | $270,000 | ($6,500.00) | $97,500.00 | 0.03 | $312,647.40 | 7 | $270,000 | $49,698 | 0.08 | ($1,213.28) | ($3,579.03) | ($6,500.00) | $82,940.69 | 0.03 | $338,899.07 | |||||
9 | 8 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $429,146.82 | 8 | $280,000 | $38,718 | 0.08 | ($1,213.28) | ($2,667.68) | ($6,500.00) | $89,440.69 | 0.03 | $441,189.95 | |||||
10 | 9 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $549,141.23 | 9 | $280,000 | $26,826 | 0.08 | ($1,213.28) | ($1,680.68) | ($6,500.00) | $89,440.69 | 0.03 | $546,549.56 | |||||
11 | 10 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $672,735.46 | 10 | $280,000 | $13,948 | 0.08 | ($1,213.28) | ($611.76) | ($6,500.00) | $89,440.69 | 0.03 | $655,069.95 | |||||
12 | 11 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $800,037.53 | 11 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $781,842.05 | |||||||||
13 | 12 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $931,158.65 | 12 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $912,417.31 | |||||||||
14 | 13 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,066,213.41 | 13 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,046,909.83 | |||||||||
15 | 14 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,205,319.82 | 14 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,185,437.13 | |||||||||
16 | 15 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,348,599.41 | 15 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,328,120.24 | |||||||||
17 | 16 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,496,177.39 | 16 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,475,083.85 | |||||||||
18 | 17 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,648,182.71 | 17 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,626,456.36 | |||||||||
19 | 18 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,804,748.20 | 18 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,782,370.06 | |||||||||
20 | 19 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,966,010.64 | 19 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $1,942,961.16 | |||||||||
21 | 20 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $2,132,110.96 | 20 | $280,000 | ($6,500.00) | $104,000.00 | 0.03 | $2,108,369.99 | |||||||||
22 | |||||||||||||||||||||
23 | Year | Inc | Debt | Rate | Monthly Debt Svc | Annual Int Pd on Debt | Exp / Month | Savings | Rate of Return | IRA bal | Year | Inc | Debt | Rate | Monthly Debt Svc | Annual Int Pd on Debt | Exp / Month | Savings | Rate of Return | IRA bal | |
24 | 1 | $160,000 | $100,000 | 0.08 | ($2,027.64) | ($7,387.66) | ($6,500.00) | $1,668.33 | 0.13 | $1,885.21 | 1 | $160,000 | $100,000 | 0.08 | ($1,213.28) | ($7,754.07) | ($6,500.00) | $11,440.69 | 0.13 | $12,927.98 | |
25 | 2 | $170,000 | $76,882 | 0.08 | ($2,027.64) | ($5,981.32) | ($6,500.00) | $8,168.33 | 0.13 | $11,360.50 | 2 | $170,000 | $93,195 | 0.08 | ($1,213.28) | ($7,189.23) | ($6,500.00) | $17,940.69 | 0.13 | $34,881.59 | |
26 | 3 | $185,000 | $53,763 | 0.08 | ($2,027.64) | ($4,458.25) | ($6,500.00) | $17,918.33 | 0.13 | $33,085.07 | 3 | $185,000 | $85,825 | 0.08 | ($1,213.28) | ($6,577.52) | ($6,500.00) | $27,690.69 | 0.13 | $70,706.68 | |
27 | 4 | $210,000 | $30,645 | 0.08 | ($2,027.64) | ($2,808.76) | ($6,500.00) | $34,168.33 | 0.13 | $75,996.34 | 4 | $210,000 | $77,843 | 0.08 | ($1,213.28) | ($5,915.04) | ($6,500.00) | $43,940.69 | 0.13 | $129,551.53 | |
28 | 5 | $230,000 | $7,526 | 0.08 | ($2,027.64) | ($1,022.37) | ($6,500.00) | $47,168.33 | 0.13 | $139,176.07 | 5 | $230,000 | $69,199 | 0.08 | ($1,213.28) | ($5,197.57) | ($6,500.00) | $56,940.69 | 0.13 | $210,736.20 | |
29 | 6 | $250,000 | ($6,500.00) | $84,500.00 | 0.13 | $252,753.96 | 6 | $250,000 | $59,837 | 0.08 | ($1,213.28) | ($4,420.55) | ($6,500.00) | $69,940.69 | 0.13 | $317,164.89 | |||||
30 | 7 | $270,000 | ($6,500.00) | $97,500.00 | 0.13 | $395,786.98 | 7 | $270,000 | $49,698 | 0.08 | ($1,213.28) | ($3,579.03) | ($6,500.00) | $82,940.69 | 0.13 | $452,119.30 | |||||
31 | 8 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $564,759.28 | 8 | $280,000 | $38,718 | 0.08 | ($1,213.28) | ($2,667.68) | ($6,500.00) | $89,440.69 | 0.13 | $611,962.79 | |||||
32 | 9 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $755,697.99 | 9 | $280,000 | $26,826 | 0.08 | ($1,213.28) | ($1,680.68) | ($6,500.00) | $89,440.69 | 0.13 | $792,585.93 | |||||
33 | 10 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $971,458.73 | 10 | $280,000 | $13,948 | 0.08 | ($1,213.28) | ($611.76) | ($6,500.00) | $89,440.69 | 0.13 | $996,690.08 | |||||
34 | 11 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $1,215,268.36 | 11 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $1,243,779.79 | |||||||||
35 | 12 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $1,490,773.25 | 12 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $1,522,991.16 | |||||||||
36 | 13 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $1,802,093.77 | 13 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $1,838,500.01 | |||||||||
37 | 14 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $2,153,885.96 | 14 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $2,195,025.01 | |||||||||
38 | 15 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $2,551,411.14 | 15 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $2,597,898.26 | |||||||||
39 | 16 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $3,000,614.59 | 16 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $3,053,145.04 | |||||||||
40 | 17 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $3,508,214.48 | 17 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $3,567,573.89 | |||||||||
41 | 18 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $4,081,802.36 | 18 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $4,148,878.50 | |||||||||
42 | 19 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $4,729,956.67 | 19 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $4,805,752.70 | |||||||||
43 | 20 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $5,462,371.04 | 20 | $280,000 | ($6,500.00) | $104,000.00 | 0.13 | $5,548,020.55 |