Samanthaspreadsheet.xlsx

Sheet1

Buying Renting Investing
Mortgage Monthly Rent $ 3,000 Current Amount $ 140,000
Purchase Price $ 600,000 Monthly Interest
Samantha Pilleri: Same rate as mortgage
0.33%
Down Payment (20%) $ 120,000
Deed-Transfer Tax (3%)
Samantha Pilleri: Includes 1.5% each for local and provincial - due on purchase date
$ 18,000 FV Year 2 $ 72,000 FV Year 2 $151,640
Closing Fees $ 2,000 FV Year 5 $ 180,000 FV Year 5 $170,940
Purchase Price including Closing Fees and Deed-Transfer Tax $ 620,000 FV Year 10 $ 360,000 FV Year 10 $208,717
Annual Interest
Samantha Pilleri: Locked in for 10 year term

Samantha Pilleri: Same rate as mortgage
4%
Monthly Interest 0.33%
Amount Of Loan 480,000 Year 2 (Investing-Renting) $79,640
# Periods (25 yrs)
Samantha Pilleri: 25 year amortized mortgage w/ monthly pmts
300 Year 5 (Investing-Renting) ($9,060)
Selling Realtor Fee 5% Year 10 (Investing-Renting) ($151,283)
Selling Closing Costs 2,000
Monthly Expenses $ 600,000 3.333%
Condo Fees $ 1,055 $ 20,000
Taxes $ 300
Repairs $ 50
Mortage Payment $ 2,534
Total $ 3,939
Year 2 Periods 24
Year 5 Periods 60
Year 10 Periods 120
Scenario (a): Condo Price Remains Unchanged
Buy Option Year 2 Year 5 Year 10
Condo Value $ 600,000 $ 600,000 $ 600,000
Remaining Loan Balance $ 456,713 $ 418,102 $ 342,525
Equity $ 143,287 $ 181,898 $ 257,475
Realtor Fee (5%) $ 30,000 $ 30,000 $ 30,000
Closing Costs $ 2,000 $ 2,000 $ 2,000
Investment Gain $ 111,287 $ 149,898 $ 225,475
Monthly Payments $ 94,527 $ 236,317 $ 472,634
Investment Gain $ 16,760 $ (86,419) $ (247,159)
Renting Impact $ 79,640 ($9,060) ($151,283)
Scenario (b): Condo Price Drops 10% in Year 2, Returns to Purchase Price in Year 5, Increases 10% in Year 10
Buy Option Year 2 Year 5 Year 10
Condo Value $ 540,000 $ 600,000 $ 660,000
Remaining Loan Balance $ 456,713 $ 418,102 $ 342,525
Equity $ 83,287 $ 181,898 $ 317,475
Realtor Fee (5%) $ 27,000 $ 30,000 $ 33,000
Closing Costs $ 2,000 $ 2,000 $ 2,000
Investment Gain $ 54,287 $ 149,898 $ 282,475
Monthly Payments $ 94,527 $ 236,317 $ 472,634
Investment Gain $ (40,240) $ (86,419) $ (190,159)
Renting Impact $ 79,640 ($9,060) ($151,283)
Scenario (c): Condo Price Increases Annually by 2% Year Over Year
Buy Option Year 2 Year 5 Year 10
Condo Value $ 624,240 $ 662,448 $ 731,397
Remaining Loan Balance $ 456,713 $ 418,102 $ 342,525
Equity $ 167,527 $ 244,346 $ 388,872
Realtor Fee (5%) $ 31,212 $ 33,122 $ 36,570
Closing Costs $ 2,000 $ 2,000 $ 2,000
Investment Gain $ 134,315 $ 209,224 $ 350,302
Monthly Payments $ 94,527 $ 236,317 $ 472,634
Investment Gain $ 39,788 $ (27,093) $ (122,332)
Renting Impact $ 79,640 ($9,060) ($151,283)
Scenario (d): Condo Price Increases Annually by 5% Year Over Year
Buy Option Year 2 Year 5 Year 10
Condo Value $ 661,500 $ 765,769 $ 977,337
Remaining Loan Balance $ 456,713 $ 418,102 $ 342,525
Equity $ 204,787 $ 347,667 $ 634,812
Realtor Fee (5%) $ 33,075 $ 38,288 $ 48,867
Closing Costs $ 2,000 $ 2,000 $ 2,000
Investment Gain $ 169,712 $ 307,378 $ 583,945
Monthly Payments $ 94,527 $ 236,317 $ 472,634
Investment Gain $ 75,185 $ 71,061 $ 111,311
Renting Impact $ 79,640 ($9,060) ($151,283)

Monthly Mortgage Payments

Amount Of Loan 480,000
Annual Interest 4.000%
Monthly Interest 0.333%
# Periods 300
Payment $2,533.62
Annual Payment $30,403.40
Lifetime Payments $760,085.05
. Scheduled Beginning Interest Principal Ending Percent
Year Month Payment Balance Paid Paid Balance Paid Paid Principal Total Mortgage Payments
1 $2,533.62 480,000.00 1,600.00 $933.62 479,066.38 0.19% 0.19% $ 2,533.62
2 $2,533.62 479,066.38 1,596.89 $936.73 478,129.65 0.20% 0.39% $ 5,067.23
3 $2,533.62 478,129.65 1,593.77 $939.85 477,189.80 0.20% 0.59% $ 7,600.85
4 $2,533.62 477,189.80 1,590.63 $942.98 476,246.82 0.20% 0.78% $ 10,134.47
5 $2,533.62 476,246.82 1,587.49 $946.13 475,300.69 0.20% 0.98% $ 12,668.08
6 $2,533.62 475,300.69 1,584.34 $949.28 474,351.41 0.20% 1.18% $ 15,201.70
7 $2,533.62 474,351.41 1,581.17 $952.45 473,398.96 0.20% 1.38% $ 17,735.32
8 $2,533.62 473,398.96 1,578.00 $955.62 472,443.34 0.20% 1.57% $ 20,268.93
9 $2,533.62 472,443.34 1,574.81 $958.81 471,484.54 0.20% 1.77% $ 22,802.55
10 $2,533.62 471,484.54 1,571.62 $962.00 470,522.54 0.20% 1.97% $ 25,336.17
11 $2,533.62 470,522.54 1,568.41 $965.21 469,557.33 0.20% 2.18% $ 27,869.79
1 12 $2,533.62 469,557.33 1,565.19 $968.43 468,588.90 0.20% 2.38% $ 30,403.40
13 $2,533.62 468,588.90 1,561.96 $971.65 467,617.25 0.20% 2.58% $ 32,937.02
14 $2,533.62 467,617.25 1,558.72 $974.89 466,642.36 0.20% 2.78% $ 35,470.64
15 $2,533.62 466,642.36 1,555.47 $978.14 465,664.21 0.20% 2.99% $ 38,004.25
16 $2,533.62 465,664.21 1,552.21 $981.40 464,682.81 0.20% 3.19% $ 40,537.87
17 $2,533.62 464,682.81 1,548.94 $984.67 463,698.14 0.21% 3.40% $ 43,071.49
18 $2,533.62 463,698.14 1,545.66 $987.96 462,710.18 0.21% 3.60% $ 45,605.10
19 $2,533.62 462,710.18 1,542.37 $991.25 461,718.93 0.21% 3.81% $ 48,138.72
20 $2,533.62 461,718.93 1,539.06 $994.55 460,724.38 0.21% 4.02% $ 50,672.34
21 $2,533.62 460,724.38 1,535.75 $997.87 459,726.51 0.21% 4.22% $ 53,205.95
22 $2,533.62 459,726.51 1,532.42 $1,001.20 458,725.31 0.21% 4.43% $ 55,739.57
23 $2,533.62 458,725.31 1,529.08 $1,004.53 457,720.78 0.21% 4.64% $ 58,273.19
2 24 $2,533.62 457,720.78 1,525.74 $1,007.88 456,712.90 0.21% 4.85% $ 60,806.80
25 $2,533.62 456,712.90 1,522.38 $1,011.24 455,701.66 0.21% 5.06% $ 63,340.42
26 $2,533.62 455,701.66 1,519.01 $1,014.61 454,687.05 0.21% 5.27% $ 65,874.04
27 $2,533.62 454,687.05 1,515.62 $1,017.99 453,669.05 0.21% 5.49% $ 68,407.65
28 $2,533.62 453,669.05 1,512.23 $1,021.39 452,647.67 0.21% 5.70% $ 70,941.27
29 $2,533.62 452,647.67 1,508.83 $1,024.79 451,622.88 0.21% 5.91% $ 73,474.89
30 $2,533.62 451,622.88 1,505.41 $1,028.21 450,594.67 0.21% 6.13% $ 76,008.51
31 $2,533.62 450,594.67 1,501.98 $1,031.63 449,563.04 0.21% 6.34% $ 78,542.12
32 $2,533.62 449,563.04 1,498.54 $1,035.07 448,527.96 0.22% 6.56% $ 81,075.74
33 $2,533.62 448,527.96 1,495.09 $1,038.52 447,489.44 0.22% 6.77% $ 83,609.36
34 $2,533.62 447,489.44 1,491.63 $1,041.99 446,447.45 0.22% 6.99% $ 86,142.97
35 $2,533.62 446,447.45 1,488.16 $1,045.46 445,401.99 0.22% 7.21% $ 88,676.59
3 36 $2,533.62 445,401.99 1,484.67 $1,048.94 444,353.05 0.22% 7.43% $ 91,210.21
37 $2,533.62 444,353.05 1,481.18 $1,052.44 443,300.61 0.22% 7.65% $ 93,743.82
38 $2,533.62 443,300.61 1,477.67 $1,055.95 442,244.66 0.22% 7.87% $ 96,277.44
39 $2,533.62 442,244.66 1,474.15 $1,059.47 441,185.19 0.22% 8.09% $ 98,811.06
40 $2,533.62 441,185.19 1,470.62 $1,063.00 440,122.20 0.22% 8.31% $ 101,344.67
41 $2,533.62 440,122.20 1,467.07 $1,066.54 439,055.65 0.22% 8.53% $ 103,878.29
42 $2,533.62 439,055.65 1,463.52 $1,070.10 437,985.55 0.22% 8.75% $ 106,411.91
43 $2,533.62 437,985.55 1,459.95 $1,073.66 436,911.89 0.22% 8.98% $ 108,945.52
44 $2,533.62 436,911.89 1,456.37 $1,077.24 435,834.65 0.22% 9.20% $ 111,479.14
45 $2,533.62 435,834.65 1,452.78 $1,080.83 434,753.81 0.23% 9.43% $ 114,012.76
46 $2,533.62 434,753.81 1,449.18 $1,084.44 433,669.37 0.23% 9.65% $ 116,546.37
47 $2,533.62 433,669.37 1,445.56 $1,088.05 432,581.32 0.23% 9.88% $ 119,079.99
4 48 $2,533.62 432,581.32 1,441.94 $1,091.68 431,489.64 0.23% 10.11% $ 121,613.61
49 $2,533.62 431,489.64 1,438.30 $1,095.32 430,394.32 0.23% 10.33% $ 124,147.22
50 $2,533.62 430,394.32 1,434.65 $1,098.97 429,295.35 0.23% 10.56% $ 126,680.84
51 $2,533.62 429,295.35 1,430.98 $1,102.63 428,192.72 0.23% 10.79% $ 129,214.46
52 $2,533.62 428,192.72 1,427.31 $1,106.31 427,086.41 0.23% 11.02% $ 131,748.08
53 $2,533.62 427,086.41 1,423.62 $1,110.00 425,976.42 0.23% 11.25% $ 134,281.69
54 $2,533.62 425,976.42 1,419.92 $1,113.70 424,862.72 0.23% 11.49% $ 136,815.31
55 $2,533.62 424,862.72 1,416.21 $1,117.41 423,745.32 0.23% 11.72% $ 139,348.93
56 $2,533.62 423,745.32 1,412.48 $1,121.13 422,624.18 0.23% 11.95% $ 141,882.54
57 $2,533.62 422,624.18 1,408.75 $1,124.87 421,499.31 0.23% 12.19% $ 144,416.16
58 $2,533.62 421,499.31 1,405.00 $1,128.62 420,370.69 0.24% 12.42% $ 146,949.78
59 $2,533.62 420,370.69 1,401.24 $1,132.38 419,238.31 0.24% 12.66% $ 149,483.39
5 60 $2,533.62 419,238.31 1,397.46 $1,136.16 418,102.16 0.24% 12.90% $ 152,017.01
61 $2,533.62 418,102.16 1,393.67 $1,139.94 416,962.21 0.24% 13.13% $ 154,550.63
62 $2,533.62 416,962.21 1,389.87 $1,143.74 415,818.47 0.24% 13.37% $ 157,084.24
63 $2,533.62 415,818.47 1,386.06 $1,147.56 414,670.92 0.24% 13.61% $ 159,617.86
64 $2,533.62 414,670.92 1,382.24 $1,151.38 413,519.54 0.24% 13.85% $ 162,151.48
65 $2,533.62 413,519.54 1,378.40 $1,155.22 412,364.32 0.24% 14.09% $ 164,685.09
66 $2,533.62 412,364.32 1,374.55 $1,159.07 411,205.25 0.24% 14.33% $ 167,218.71
67 $2,533.62 411,205.25 1,370.68 $1,162.93 410,042.32 0.24% 14.57% $ 169,752.33
68 $2,533.62 410,042.32 1,366.81 $1,166.81 408,875.51 0.24% 14.82% $ 172,285.94
69 $2,533.62 408,875.51 1,362.92 $1,170.70 407,704.81 0.24% 15.06% $ 174,819.56
70 $2,533.62 407,704.81 1,359.02 $1,174.60 406,530.21 0.24% 15.31% $ 177,353.18
71 $2,533.62 406,530.21 1,355.10 $1,178.52 405,351.69 0.25% 15.55% $ 179,886.80
6 72 $2,533.62 405,351.69 1,351.17 $1,182.44 404,169.25 0.25% 15.80% $ 182,420.41
73 $2,533.62 404,169.25 1,347.23 $1,186.39 402,982.86 0.25% 16.05% $ 184,954.03
74 $2,533.62 402,982.86 1,343.28 $1,190.34 401,792.52 0.25% 16.29% $ 187,487.65
75 $2,533.62 401,792.52 1,339.31 $1,194.31 400,598.21 0.25% 16.54% $ 190,021.26
76 $2,533.62 400,598.21 1,335.33 $1,198.29 399,399.92 0.25% 16.79% $ 192,554.88
77 $2,533.62 399,399.92 1,331.33 $1,202.28 398,197.64 0.25% 17.04% $ 195,088.50
78 $2,533.62 398,197.64 1,327.33 $1,206.29 396,991.35 0.25% 17.29% $ 197,622.11
79 $2,533.62 396,991.35 1,323.30 $1,210.31 395,781.04 0.25% 17.55% $ 200,155.73
80 $2,533.62 395,781.04 1,319.27 $1,214.35 394,566.69 0.25% 17.80% $ 202,689.35
81 $2,533.62 394,566.69 1,315.22 $1,218.39 393,348.29 0.25% 18.05% $ 205,222.96
82 $2,533.62 393,348.29 1,311.16 $1,222.46 392,125.84 0.25% 18.31% $ 207,756.58
83 $2,533.62 392,125.84 1,307.09 $1,226.53 390,899.31 0.26% 18.56% $ 210,290.20
7 84 $2,533.62 390,899.31 1,303.00 $1,230.62 389,668.69 0.26% 18.82% $ 212,823.81
85 $2,533.62 389,668.69 1,298.90 $1,234.72 388,433.97 0.26% 19.08% $ 215,357.43
86 $2,533.62 388,433.97 1,294.78 $1,238.84 387,195.13 0.26% 19.33% $ 217,891.05
87 $2,533.62 387,195.13 1,290.65 $1,242.97 385,952.16 0.26% 19.59% $ 220,424.66
88 $2,533.62 385,952.16 1,286.51 $1,247.11 384,705.05 0.26% 19.85% $ 222,958.28
89 $2,533.62 384,705.05 1,282.35 $1,251.27 383,453.79 0.26% 20.11% $ 225,491.90
90 $2,533.62 383,453.79 1,278.18 $1,255.44 382,198.35 0.26% 20.38% $ 228,025.52
91 $2,533.62 382,198.35 1,273.99 $1,259.62 380,938.73 0.26% 20.64% $ 230,559.13
92 $2,533.62 380,938.73 1,269.80 $1,263.82 379,674.91 0.26% 20.90% $ 233,092.75
93 $2,533.62 379,674.91 1,265.58 $1,268.03 378,406.87 0.26% 21.17% $ 235,626.37
94 $2,533.62 378,406.87 1,261.36 $1,272.26 377,134.61 0.27% 21.43% $ 238,159.98
95 $2,533.62 377,134.61 1,257.12 $1,276.50 375,858.11 0.27% 21.70% $ 240,693.60
8 96 $2,533.62 375,858.11 1,252.86 $1,280.76 374,577.35 0.27% 21.96% $ 243,227.22
97 $2,533.62 374,577.35 1,248.59 $1,285.03 373,292.33 0.27% 22.23% $ 245,760.83
98 $2,533.62 373,292.33 1,244.31 $1,289.31 372,003.02 0.27% 22.50% $ 248,294.45
99 $2,533.62 372,003.02 1,240.01 $1,293.61 370,709.41 0.27% 22.77% $ 250,828.07
100 $2,533.62 370,709.41 1,235.70 $1,297.92 369,411.49 0.27% 23.04% $ 253,361.68
101 $2,533.62 369,411.49 1,231.37 $1,302.25 368,109.25 0.27% 23.31% $ 255,895.30
102 $2,533.62 368,109.25 1,227.03 $1,306.59 366,802.66 0.27% 23.58% $ 258,428.92
103 $2,533.62 366,802.66 1,222.68 $1,310.94 365,491.72 0.27% 23.86% $ 260,962.53
104 $2,533.62 365,491.72 1,218.31 $1,315.31 364,176.41 0.27% 24.13% $ 263,496.15
105 $2,533.62 364,176.41 1,213.92 $1,319.70 362,856.71 0.27% 24.40% $ 266,029.77
106 $2,533.62 362,856.71 1,209.52 $1,324.09 361,532.62 0.28% 24.68% $ 268,563.38
107 $2,533.62 361,532.62 1,205.11 $1,328.51 360,204.11 0.28% 24.96% $ 271,097.00
9 108 $2,533.62 360,204.11 1,200.68 $1,332.94 358,871.18 0.28% 25.24% $ 273,630.62
109 $2,533.62 358,871.18 1,196.24 $1,337.38 357,533.80 0.28% 25.51% $ 276,164.23
110 $2,533.62 357,533.80 1,191.78 $1,341.84 356,191.96 0.28% 25.79% $ 278,697.85
111 $2,533.62 356,191.96 1,187.31 $1,346.31 354,845.65 0.28% 26.07% $ 281,231.47
112 $2,533.62 354,845.65 1,182.82 $1,350.80 353,494.85 0.28% 26.36% $ 283,765.09
113 $2,533.62 353,494.85 1,178.32 $1,355.30 352,139.55 0.28% 26.64% $ 286,298.70
114 $2,533.62 352,139.55 1,173.80 $1,359.82 350,779.73 0.28% 26.92% $ 288,832.32
115 $2,533.62 350,779.73 1,169.27 $1,364.35 349,415.38 0.28% 27.21% $ 291,365.94
116 $2,533.62 349,415.38 1,164.72 $1,368.90 348,046.48 0.29% 27.49% $ 293,899.55
117 $2,533.62 348,046.48 1,160.15 $1,373.46 346,673.02 0.29% 27.78% $ 296,433.17
118 $2,533.62 346,673.02 1,155.58 $1,378.04 345,294.98 0.29% 28.06% $ 298,966.79
119 $2,533.62 345,294.98 1,150.98 $1,382.63 343,912.35 0.29% 28.35% $ 301,500.40
10 120 $2,533.62 343,912.35 1,146.37 $1,387.24 342,525.10 0.29% 28.64% $ 304,034.02
121 $2,533.62 342,525.10 1,141.75 $1,391.87 341,133.24 0.29% 28.93% $ 306,567.64
122 $2,533.62 341,133.24 1,137.11 $1,396.51 339,736.73 0.29% 29.22% $ 309,101.25
123 $2,533.62 339,736.73 1,132.46 $1,401.16 338,335.57 0.29% 29.51% $ 311,634.87
124 $2,533.62 338,335.57 1,127.79 $1,405.83 336,929.74 0.29% 29.81% $ 314,168.49
125 $2,533.62 336,929.74 1,123.10 $1,410.52 335,519.22 0.29% 30.10% $ 316,702.10
126 $2,533.62 335,519.22 1,118.40 $1,415.22 334,104.00 0.29% 30.39% $ 319,235.72
127 $2,533.62 334,104.00 1,113.68 $1,419.94 332,684.06 0.30% 30.69% $ 321,769.34
128 $2,533.62 332,684.06 1,108.95 $1,424.67 331,259.39 0.30% 30.99% $ 324,302.95
129 $2,533.62 331,259.39 1,104.20 $1,429.42 329,829.98 0.30% 31.29% $ 326,836.57
130 $2,533.62 329,829.98 1,099.43 $1,434.18 328,395.79 0.30% 31.58% $ 329,370.19
131 $2,533.62 328,395.79 1,094.65 $1,438.96 326,956.83 0.30% 31.88% $ 331,903.81
11 132 $2,533.62 326,956.83 1,089.86 $1,443.76 325,513.07 0.30% 32.18% $ 334,437.42
133 $2,533.62 325,513.07 1,085.04 $1,448.57 324,064.49 0.30% 32.49% $ 336,971.04
134 $2,533.62 324,064.49 1,080.21 $1,453.40 322,611.09 0.30% 32.79% $ 339,504.66
135 $2,533.62 322,611.09 1,075.37 $1,458.25 321,152.85 0.30% 33.09% $ 342,038.27
136 $2,533.62 321,152.85 1,070.51 $1,463.11 319,689.74 0.30% 33.40% $ 344,571.89
137 $2,533.62 319,689.74 1,065.63 $1,467.98 318,221.75 0.31% 33.70% $ 347,105.51
138 $2,533.62 318,221.75 1,060.74 $1,472.88 316,748.88 0.31% 34.01% $ 349,639.12
139 $2,533.62 316,748.88 1,055.83 $1,477.79 315,271.09 0.31% 34.32% $ 352,172.74
140 $2,533.62 315,271.09 1,050.90 $1,482.71 313,788.38 0.31% 34.63% $ 354,706.36
141 $2,533.62 313,788.38 1,045.96 $1,487.66 312,300.72 0.31% 34.94% $ 357,239.97
142 $2,533.62 312,300.72 1,041.00 $1,492.61 310,808.11 0.31% 35.25% $ 359,773.59
143 $2,533.62 310,808.11 1,036.03 $1,497.59 309,310.52 0.31% 35.56% $ 362,307.21
12 144 $2,533.62 309,310.52 1,031.04 $1,502.58 307,807.93 0.31% 35.87% $ 364,840.82
145 $2,533.62 307,807.93 1,026.03 $1,507.59 306,300.34 0.31% 36.19% $ 367,374.44
146 $2,533.62 306,300.34 1,021.00 $1,512.62 304,787.73 0.32% 36.50% $ 369,908.06
147 $2,533.62 304,787.73 1,015.96 $1,517.66 303,270.07 0.32% 36.82% $ 372,441.67
148 $2,533.62 303,270.07 1,010.90 $1,522.72 301,747.35 0.32% 37.14% $ 374,975.29
149 $2,533.62 301,747.35 1,005.82 $1,527.79 300,219.56 0.32% 37.45% $ 377,508.91
150 $2,533.62 300,219.56 1,000.73 $1,532.88 298,686.68 0.32% 37.77% $ 380,042.53
151 $2,533.62 298,686.68 995.62 $1,537.99 297,148.68 0.32% 38.09% $ 382,576.14
152 $2,533.62 297,148.68 990.50 $1,543.12 295,605.56 0.32% 38.42% $ 385,109.76
153 $2,533.62 295,605.56 985.35 $1,548.26 294,057.30 0.32% 38.74% $ 387,643.38
154 $2,533.62 294,057.30 980.19 $1,553.43 292,503.87 0.32% 39.06% $ 390,176.99
155 $2,533.62 292,503.87 975.01 $1,558.60 290,945.27 0.32% 39.39% $ 392,710.61
13 156 $2,533.62 290,945.27 969.82 $1,563.80 289,381.47 0.33% 39.71% $ 395,244.23
157 $2,533.62 289,381.47 964.60 $1,569.01 287,812.45 0.33% 40.04% $ 397,777.84
158 $2,533.62 287,812.45 959.37 $1,574.24 286,238.21 0.33% 40.37% $ 400,311.46
159 $2,533.62 286,238.21 954.13 $1,579.49 284,658.72 0.33% 40.70% $ 402,845.08
160 $2,533.62 284,658.72 948.86 $1,584.75 283,073.97 0.33% 41.03% $ 405,378.69
161 $2,533.62 283,073.97 943.58 $1,590.04 281,483.93 0.33% 41.36% $ 407,912.31
162 $2,533.62 281,483.93 938.28 $1,595.34 279,888.59 0.33% 41.69% $ 410,445.93
163 $2,533.62 279,888.59 932.96 $1,600.65 278,287.94 0.33% 42.02% $ 412,979.54
164 $2,533.62 278,287.94 927.63 $1,605.99 276,681.95 0.33% 42.36% $ 415,513.16
165 $2,533.62 276,681.95 922.27 $1,611.34 275,070.61 0.34% 42.69% $ 418,046.78
166 $2,533.62 275,070.61 916.90 $1,616.71 273,453.89 0.34% 43.03% $ 420,580.39
167 $2,533.62 273,453.89 911.51 $1,622.10 271,831.79 0.34% 43.37% $ 423,114.01
14 168 $2,533.62 271,831.79 906.11 $1,627.51 270,204.28 0.34% 43.71% $ 425,647.63
169 $2,533.62 270,204.28 900.68 $1,632.94 268,571.34 0.34% 44.05% $ 428,181.24
170 $2,533.62 268,571.34 895.24 $1,638.38 266,932.96 0.34% 44.39% $ 430,714.86
171 $2,533.62 266,932.96 889.78 $1,643.84 265,289.12 0.34% 44.73% $ 433,248.48
172 $2,533.62 265,289.12 884.30 $1,649.32 263,639.80 0.34% 45.08% $ 435,782.10
173 $2,533.62 263,639.80 878.80 $1,654.82 261,984.98 0.34% 45.42% $ 438,315.71
174 $2,533.62 261,984.98 873.28 $1,660.33 260,324.65 0.35% 45.77% $ 440,849.33
175 $2,533.62 260,324.65 867.75 $1,665.87 258,658.78 0.35% 46.11% $ 443,382.95
176 $2,533.62 258,658.78 862.20 $1,671.42 256,987.36 0.35% 46.46% $ 445,916.56
177 $2,533.62 256,987.36 856.62 $1,676.99 255,310.37 0.35% 46.81% $ 448,450.18
178 $2,533.62 255,310.37 851.03 $1,682.58 253,627.79 0.35% 47.16% $ 450,983.80
179 $2,533.62 253,627.79 845.43 $1,688.19 251,939.60 0.35% 47.51% $ 453,517.41
15 180 $2,533.62 251,939.60 839.80 $1,693.82 250,245.78 0.35% 47.87% $ 456,051.03
181 $2,533.62 250,245.78 834.15 $1,699.46 248,546.31 0.35% 48.22% $ 458,584.65
182 $2,533.62 248,546.31 828.49 $1,705.13 246,841.18 0.36% 48.57% $ 461,118.26
183 $2,533.62 246,841.18 822.80 $1,710.81 245,130.37 0.36% 48.93% $ 463,651.88
184 $2,533.62 245,130.37 817.10 $1,716.52 243,413.86 0.36% 49.29% $ 466,185.50
185 $2,533.62 243,413.86 811.38 $1,722.24 241,691.62 0.36% 49.65% $ 468,719.11
186 $2,533.62 241,691.62 805.64 $1,727.98 239,963.64 0.36% 50.01% $ 471,252.73
187 $2,533.62 239,963.64 799.88 $1,733.74 238,229.90 0.36% 50.37% $ 473,786.35
188 $2,533.62 238,229.90 794.10 $1,739.52 236,490.39 0.36% 50.73% $ 476,319.96
189 $2,533.62 236,490.39 788.30 $1,745.32 234,745.07 0.36% 51.09% $ 478,853.58
190 $2,533.62 234,745.07 782.48 $1,751.13 232,993.94 0.36% 51.46% $ 481,387.20
191 $2,533.62 232,993.94 776.65 $1,756.97 231,236.97 0.37% 51.83% $ 483,920.82
16 192 $2,533.62 231,236.97 770.79 $1,762.83 229,474.14 0.37% 52.19% $ 486,454.43
193 $2,533.62 229,474.14 764.91 $1,768.70 227,705.44 0.37% 52.56% $ 488,988.05
194 $2,533.62 227,705.44 759.02 $1,774.60 225,930.84 0.37% 52.93% $ 491,521.67
195 $2,533.62 225,930.84 753.10 $1,780.51 224,150.32 0.37% 53.30% $ 494,055.28
196 $2,533.62 224,150.32 747.17 $1,786.45 222,363.87 0.37% 53.67% $ 496,588.90
197 $2,533.62 222,363.87 741.21 $1,792.40 220,571.47 0.37% 54.05% $ 499,122.52
198 $2,533.62 220,571.47 735.24 $1,798.38 218,773.09 0.37% 54.42% $ 501,656.13
199 $2,533.62 218,773.09 729.24 $1,804.37 216,968.72 0.38% 54.80% $ 504,189.75
200 $2,533.62 216,968.72 723.23 $1,810.39 215,158.33 0.38% 55.18% $ 506,723.37
201 $2,533.62 215,158.33 717.19 $1,816.42 213,341.91 0.38% 55.55% $ 509,256.98
202 $2,533.62 213,341.91 711.14 $1,822.48 211,519.43 0.38% 55.93% $ 511,790.60
203 $2,533.62 211,519.43 705.06 $1,828.55 209,690.88 0.38% 56.31% $ 514,324.22
17 204 $2,533.62 209,690.88 698.97 $1,834.65 207,856.23 0.38% 56.70% $ 516,857.83
205 $2,533.62 207,856.23 692.85 $1,840.76 206,015.47 0.38% 57.08% $ 519,391.45
206 $2,533.62 206,015.47 686.72 $1,846.90 204,168.57 0.38% 57.46% $ 521,925.07
207 $2,533.62 204,168.57 680.56 $1,853.05 202,315.52 0.39% 57.85% $ 524,458.68
208 $2,533.62 202,315.52 674.39 $1,859.23 200,456.28 0.39% 58.24% $ 526,992.30
209 $2,533.62 200,456.28 668.19 $1,865.43 198,590.85 0.39% 58.63% $ 529,525.92
210 $2,533.62 198,590.85 661.97 $1,871.65 196,719.21 0.39% 59.02% $ 532,059.54
211 $2,533.62 196,719.21 655.73 $1,877.89 194,841.32 0.39% 59.41% $ 534,593.15
212 $2,533.62 194,841.32 649.47 $1,884.15 192,957.18 0.39% 59.80% $ 537,126.77
213 $2,533.62 192,957.18 643.19 $1,890.43 191,066.75 0.39% 60.19% $ 539,660.39
214 $2,533.62 191,066.75 636.89 $1,896.73 189,170.02 0.40% 60.59% $ 542,194.00
215 $2,533.62 189,170.02 630.57 $1,903.05 187,266.97 0.40% 60.99% $ 544,727.62
18 216 $2,533.62 187,266.97 624.22 $1,909.39 185,357.58 0.40% 61.38% $ 547,261.24
217 $2,533.62 185,357.58 617.86 $1,915.76 183,441.82 0.40% 61.78% $ 549,794.85
218 $2,533.62 183,441.82 611.47 $1,922.14 181,519.68 0.40% 62.18% $ 552,328.47
219 $2,533.62 181,519.68 605.07 $1,928.55 179,591.12 0.40% 62.59% $ 554,862.09
220 $2,533.62 179,591.12 598.64 $1,934.98 177,656.14 0.40% 62.99% $ 557,395.70
221 $2,533.62 177,656.14 592.19 $1,941.43 175,714.71 0.40% 63.39% $ 559,929.32
222 $2,533.62 175,714.71 585.72 $1,947.90 173,766.81 0.41% 63.80% $ 562,462.94
223 $2,533.62 173,766.81 579.22 $1,954.39 171,812.42 0.41% 64.21% $ 564,996.55
224 $2,533.62 171,812.42 572.71 $1,960.91 169,851.51 0.41% 64.61% $ 567,530.17
225 $2,533.62 169,851.51 566.17 $1,967.45 167,884.07 0.41% 65.02% $ 570,063.79
226 $2,533.62 167,884.07 559.61 $1,974.00 165,910.06 0.41% 65.44% $ 572,597.40
227 $2,533.62 165,910.06 553.03 $1,980.58 163,929.48 0.41% 65.85% $ 575,131.02
19 228 $2,533.62 163,929.48 546.43 $1,987.19 161,942.29 0.41% 66.26% $ 577,664.64
229 $2,533.62 161,942.29 539.81 $1,993.81 159,948.48 0.42% 66.68% $ 580,198.25
230 $2,533.62 159,948.48 533.16 $2,000.46 157,948.03 0.42% 67.09% $ 582,731.87
231 $2,533.62 157,948.03 526.49 $2,007.12 155,940.91 0.42% 67.51% $ 585,265.49
232 $2,533.62 155,940.91 519.80 $2,013.81 153,927.09 0.42% 67.93% $ 587,799.11
233 $2,533.62 153,927.09 513.09 $2,020.53 151,906.57 0.42% 68.35% $ 590,332.72
234 $2,533.62 151,906.57 506.36 $2,027.26 149,879.30 0.42% 68.78% $ 592,866.34
235 $2,533.62 149,879.30 499.60 $2,034.02 147,845.28 0.42% 69.20% $ 595,399.96
236 $2,533.62 147,845.28 492.82 $2,040.80 145,804.49 0.43% 69.62% $ 597,933.57
237 $2,533.62 145,804.49 486.01 $2,047.60 143,756.88 0.43% 70.05% $ 600,467.19
238 $2,533.62 143,756.88 479.19 $2,054.43 141,702.46 0.43% 70.48% $ 603,000.81
239 $2,533.62 141,702.46 472.34 $2,061.28 139,641.18 0.43% 70.91% $ 605,534.42
20 240 $2,533.62 139,641.18 465.47 $2,068.15 137,573.04 0.43% 71.34% $ 608,068.04
241 $2,533.62 137,573.04 458.58 $2,075.04 135,497.99 0.43% 71.77% $ 610,601.66
242 $2,533.62 135,497.99 451.66 $2,081.96 133,416.04 0.43% 72.20% $ 613,135.27
243 $2,533.62 133,416.04 444.72 $2,088.90 131,327.14 0.44% 72.64% $ 615,668.89
244 $2,533.62 131,327.14 437.76 $2,095.86 129,231.28 0.44% 73.08% $ 618,202.51
245 $2,533.62 129,231.28 430.77 $2,102.85 127,128.44 0.44% 73.51% $ 620,736.12
246 $2,533.62 127,128.44 423.76 $2,109.86 125,018.58 0.44% 73.95% $ 623,269.74
247 $2,533.62 125,018.58 416.73 $2,116.89 122,901.69 0.44% 74.40% $ 625,803.36
248 $2,533.62 122,901.69 409.67 $2,123.94 120,777.75 0.44% 74.84% $ 628,336.97
249 $2,533.62 120,777.75 402.59 $2,131.02 118,646.72 0.44% 75.28% $ 630,870.59
250 $2,533.62 118,646.72 395.49 $2,138.13 116,508.60 0.45% 75.73% $ 633,404.21
251 $2,533.62 116,508.60 388.36 $2,145.25 114,363.34 0.45% 76.17% $ 635,937.83
21 252 $2,533.62 114,363.34 381.21 $2,152.41 112,210.94 0.45% 76.62% $ 638,471.44
253 $2,533.62 112,210.94 374.04 $2,159.58 110,051.35 0.45% 77.07% $ 641,005.06
254 $2,533.62 110,051.35 366.84 $2,166.78 107,884.58 0.45% 77.52% $ 643,538.68
255 $2,533.62 107,884.58 359.62 $2,174.00 105,710.57 0.45% 77.98% $ 646,072.29
256 $2,533.62 105,710.57 352.37 $2,181.25 103,529.33 0.45% 78.43% $ 648,605.91
257 $2,533.62 103,529.33 345.10 $2,188.52 101,340.81 0.46% 78.89% $ 651,139.53
258 $2,533.62 101,340.81 337.80 $2,195.81 99,144.99 0.46% 79.34% $ 653,673.14
259 $2,533.62 99,144.99 330.48 $2,203.13 96,941.86 0.46% 79.80% $ 656,206.76
260 $2,533.62 96,941.86 323.14 $2,210.48 94,731.38 0.46% 80.26% $ 658,740.38
261 $2,533.62 94,731.38 315.77 $2,217.85 92,513.54 0.46% 80.73% $ 661,273.99
262 $2,533.62 92,513.54 308.38 $2,225.24 90,288.30 0.46% 81.19% $ 663,807.61
263 $2,533.62 90,288.30 300.96 $2,232.66 88,055.64 0.47% 81.66% $ 666,341.23
22 264 $2,533.62 88,055.64 293.52 $2,240.10 85,815.54 0.47% 82.12% $ 668,874.84
265 $2,533.62 85,815.54 286.05 $2,247.57 83,567.98 0.47% 82.59% $ 671,408.46
266 $2,533.62 83,567.98 278.56 $2,255.06 81,312.92 0.47% 83.06% $ 673,942.08
267 $2,533.62 81,312.92 271.04 $2,262.57 79,050.35 0.47% 83.53% $ 676,475.69
268 $2,533.62 79,050.35 263.50 $2,270.12 76,780.23 0.47% 84.00% $ 679,009.31
269 $2,533.62 76,780.23 255.93 $2,277.68 74,502.55 0.47% 84.48% $ 681,542.93
270 $2,533.62 74,502.55 248.34 $2,285.28 72,217.27 0.48% 84.95% $ 684,076.55
271 $2,533.62 72,217.27 240.72 $2,292.89 69,924.38 0.48% 85.43% $ 686,610.16
272 $2,533.62 69,924.38 233.08 $2,300.54 67,623.85 0.48% 85.91% $ 689,143.78
273 $2,533.62 67,623.85 225.41 $2,308.20 65,315.64 0.48% 86.39% $ 691,677.40
274 $2,533.62 65,315.64 217.72 $2,315.90 62,999.74 0.48% 86.88% $ 694,211.01
275 $2,533.62 62,999.74 210.00 $2,323.62 60,676.13 0.48% 87.36% $ 696,744.63
23 276 $2,533.62 60,676.13 202.25 $2,331.36 58,344.76 0.49% 87.84% $ 699,278.25
277 $2,533.62 58,344.76 194.48 $2,339.13 56,005.63 0.49% 88.33% $ 701,811.86
278 $2,533.62 56,005.63 186.69 $2,346.93 53,658.70 0.49% 88.82% $ 704,345.48
279 $2,533.62 53,658.70 178.86 $2,354.75 51,303.94 0.49% 89.31% $ 706,879.10
280 $2,533.62 51,303.94 171.01 $2,362.60 48,941.34 0.49% 89.80% $ 709,412.71
281 $2,533.62 48,941.34 163.14 $2,370.48 46,570.86 0.49% 90.30% $ 711,946.33
282 $2,533.62 46,570.86 155.24 $2,378.38 44,192.48 0.50% 90.79% $ 714,479.95
283 $2,533.62 44,192.48 147.31 $2,386.31 41,806.17 0.50% 91.29% $ 717,013.56
284 $2,533.62 41,806.17 139.35 $2,394.26 39,411.91 0.50% 91.79% $ 719,547.18
285 $2,533.62 39,411.91 131.37 $2,402.24 37,009.67 0.50% 92.29% $ 722,080.80
286 $2,533.62 37,009.67 123.37 $2,410.25 34,599.41 0.50% 92.79% $ 724,614.41
287 $2,533.62 34,599.41 115.33 $2,418.29 32,181.13 0.50% 93.30% $ 727,148.03
24 288 $2,533.62 32,181.13 107.27 $2,426.35 29,754.78 0.51% 93.80% $ 729,681.65
289 $2,533.62 29,754.78 99.18 $2,434.43 27,320.35 0.51% 94.31% $ 732,215.26
290 $2,533.62 27,320.35 91.07 $2,442.55 24,877.80 0.51% 94.82% $ 734,748.88
291 $2,533.62 24,877.80 82.93 $2,450.69 22,427.11 0.51% 95.33% $ 737,282.50
292 $2,533.62 22,427.11 74.76 $2,458.86 19,968.25 0.51% 95.84% $ 739,816.12
293 $2,533.62 19,968.25 66.56 $2,467.06 17,501.19 0.51% 96.35% $ 742,349.73
294 $2,533.62 17,501.19 58.34 $2,475.28 15,025.91 0.52% 96.87% $ 744,883.35
295 $2,533.62 15,025.91 50.09 $2,483.53 12,542.38 0.52% 97.39% $ 747,416.97
296 $2,533.62 12,542.38 41.81 $2,491.81 10,050.57 0.52% 97.91% $ 749,950.58
297 $2,533.62 10,050.57 33.50 $2,500.11 7,550.46 0.52% 98.43% $ 752,484.20
298 $2,533.62 7,550.46 25.17 $2,508.45 5,042.01 0.52% 98.95% $ 755,017.82
299 $2,533.62 5,042.01 16.81 $2,516.81 2,525.20 0.52% 99.47% $ 757,551.43
25 300 $2,533.62 2,525.20 8.42 $2,525.20 0.00 0.53% 100.00% $ 760,085.05