| A | B | C | D | E | F | G | H | I | J | K | L | M | N | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Year | Assumed Rate of Return | 7% | Monthly Contribution | $500 | Starting Balance | $0 | Instructions | |||||||
2 | |||||||||||||||
3 | PERA 401k/457b | Target Date Fund | TIAA 403b/457b | Target Date Fund | Vanguard IRA | Target Date Fund | |||||||||
4 | Annual Fee | Fund Fee | Annual Fee | Fund Fee | Annual Fee | Fund Fee | |||||||||
5 | $12.00 | 0.07% | $0 | 0.49% | $0 | 0.08% | |||||||||
6 | Balance | Balance | Dollar Difference from PERA 401k | Percent Difference from PERA 401k | Balance | Dollar Difference from PERA 401k | Percent Difference from PERA 401k | ||||||||
7 | 1 | $5,988 | For simplicity, assumes no growth of the monthly investments in the calendar year they are made. | $6,000 | $12 | 0.20% | $6,000 | $12 | 0.20% | ||||||
8 | 2 | $12,391 | $12,391 | $0 | 0.00% | $12,415 | $24 | 0.20% | |||||||
9 | 3 | $19,238 | $19,197 | -$40 | -0.21% | $19,274 | $37 | 0.19% | |||||||
10 | 4 | $26,559 | $26,447 | -$112 | -0.42% | $26,608 | $49 | 0.19% | |||||||
11 | 5 | $34,387 | $34,169 | -$219 | -0.64% | $34,449 | $62 | 0.18% | |||||||
12 | 6 | $42,758 | $42,393 | -$365 | -0.86% | $42,833 | $75 | 0.17% | |||||||
13 | 7 | $51,710 | $51,153 | -$557 | -1.09% | $51,797 | $88 | 0.17% | |||||||
14 | 8 | $61,281 | $60,483 | -$798 | -1.32% | $61,382 | $101 | 0.16% | |||||||
15 | 9 | $71,516 | $70,420 | -$1,095 | -1.56% | $71,629 | $114 | 0.16% | |||||||
16 | 10 | $82,460 | $81,005 | -$1,455 | -1.80% | $82,586 | $126 | 0.15% | |||||||
17 | 11 | $94,162 | $92,278 | -$1,884 | -2.04% | $94,301 | $139 | 0.15% | |||||||
18 | 12 | $106,676 | $104,285 | -$2,390 | -2.29% | $106,827 | $151 | 0.14% | |||||||
19 | 13 | $120,056 | $117,074 | -$2,982 | -2.55% | $120,219 | $163 | 0.14% | |||||||
20 | 14 | $134,364 | $130,696 | -$3,668 | -2.81% | $134,538 | $174 | 0.13% | |||||||
21 | 15 | $149,664 | $145,204 | -$4,460 | -3.07% | $149,848 | $185 | 0.12% | |||||||
22 | 16 | $166,023 | $160,657 | -$5,366 | -3.34% | $166,218 | $194 | 0.12% | |||||||
23 | 17 | $183,517 | $177,116 | -$6,401 | -3.61% | $183,720 | $203 | 0.11% | |||||||
24 | 18 | $202,223 | $194,646 | -$7,577 | -3.89% | $202,434 | $211 | 0.10% | |||||||
25 | 19 | $222,225 | $213,317 | -$8,907 | -4.18% | $222,442 | $217 | 0.10% | |||||||
26 | 20 | $243,613 | $233,204 | -$10,408 | -4.46% | $243,835 | $222 | 0.09% | |||||||
27 | 21 | $266,483 | $254,386 | -$12,097 | -4.76% | $266,708 | $225 | 0.08% | |||||||
28 | 22 | $290,938 | $276,947 | -$13,992 | -5.05% | $291,164 | $226 | 0.08% | |||||||
29 | 23 | $317,088 | $300,976 | -$16,113 | -5.35% | $317,313 | $225 | 0.07% | |||||||
30 | 24 | $345,051 | $326,569 | -$18,481 | -5.66% | $345,271 | $220 | 0.06% | |||||||
31 | 25 | $374,951 | $353,829 | -$21,122 | -5.97% | $375,164 | $213 | 0.06% | |||||||
32 | 26 | $406,923 | $382,863 | -$24,060 | -6.28% | $407,125 | $202 | 0.05% | |||||||
33 | 27 | $441,111 | $413,788 | -$27,323 | -6.60% | $441,298 | $188 | 0.04% | |||||||
34 | 28 | $477,668 | $446,725 | -$30,942 | -6.93% | $477,836 | $169 | 0.04% | |||||||
35 | 29 | $516,758 | $481,807 | -$34,951 | -7.25% | $516,902 | $145 | 0.03% | |||||||
36 | 30 | $558,557 | $519,173 | -$39,385 | -7.59% | $558,672 | $115 | 0.02% | |||||||
37 | 31 | $603,253 | $558,971 | -$44,282 | -7.92% | $603,332 | $79 | 0.01% | |||||||
38 | 32 | $651,047 | $601,360 | -$49,687 | -8.26% | $651,083 | $36 | 0.01% | |||||||
39 | 33 | $702,152 | $646,508 | -$55,644 | -8.61% | $702,138 | -$15 | 0.00% | |||||||
40 | 34 | $756,799 | $694,596 | -$62,203 | -8.96% | $756,726 | -$74 | -0.01% | |||||||
41 | 35 | $815,234 | $745,814 | -$69,419 | -9.31% | $815,091 | -$143 | -0.02% | |||||||
42 | 36 | $877,717 | $800,367 | -$77,350 | -9.66% | $877,495 | -$222 | -0.03% | |||||||
43 | 37 | $944,531 | $858,471 | -$86,060 | -10.02% | $944,218 | -$313 | -0.03% | |||||||
44 | 38 | $1,015,975 | $920,357 | -$95,618 | -10.39% | $1,015,558 | -$417 | -0.04% | |||||||
45 | 39 | $1,092,370 | $986,272 | -$106,098 | -10.76% | $1,091,834 | -$536 | -0.05% | |||||||
46 | 40 | $1,174,059 | $1,056,479 | -$117,581 | -11.13% | $1,173,389 | -$670 | -0.06% | |||||||
47 | 41 | $1,261,410 | $1,131,255 | -$130,154 | -11.51% | $1,260,588 | -$822 | -0.07% | |||||||
48 | 42 | $1,354,813 | $1,210,900 | -$143,913 | -11.88% | $1,353,821 | -$993 | -0.07% | |||||||
49 | 43 | $1,454,690 | $1,295,730 | -$158,960 | -12.27% | $1,453,505 | -$1,185 | -0.08% | |||||||
50 | 44 | $1,561,488 | $1,386,082 | -$175,406 | -12.65% | $1,560,088 | -$1,400 | -0.09% | |||||||
51 | 45 | $1,675,687 | $1,482,316 | -$193,371 | -13.05% | $1,674,046 | -$1,641 | -0.10% | |||||||
52 | 46 | $1,797,800 | $1,584,814 | -$212,986 | -13.44% | $1,795,890 | -$1,911 | -0.11% | |||||||
53 | 47 | $1,928,376 | $1,693,986 | -$234,390 | -13.84% | $1,926,165 | -$2,211 | -0.11% | |||||||
54 | 48 | $2,068,000 | $1,810,264 | -$257,736 | -14.24% | $2,065,456 | -$2,544 | -0.12% | |||||||
55 | 49 | $2,217,301 | $1,934,112 | -$283,188 | -14.64% | $2,214,385 | -$2,915 | -0.13% | |||||||
56 | 50 | $2,376,947 | $2,066,023 | -$310,924 | -15.05% | $2,373,621 | -$3,327 | -0.14% | |||||||
57 | |||||||||||||||
58 | |||||||||||||||
59 | |||||||||||||||
60 | |||||||||||||||
61 | |||||||||||||||
62 | |||||||||||||||
63 | |||||||||||||||
64 | |||||||||||||||
65 | |||||||||||||||
66 | |||||||||||||||
67 | |||||||||||||||
68 | |||||||||||||||
69 | |||||||||||||||
70 | |||||||||||||||
71 | |||||||||||||||
72 | |||||||||||||||
73 | |||||||||||||||
74 | |||||||||||||||
75 | |||||||||||||||
76 | |||||||||||||||
77 | |||||||||||||||
78 | |||||||||||||||
79 | |||||||||||||||
80 | |||||||||||||||
81 | |||||||||||||||
82 | |||||||||||||||
83 | |||||||||||||||
84 | |||||||||||||||
85 | |||||||||||||||
86 | |||||||||||||||
87 | |||||||||||||||
88 | |||||||||||||||
89 | |||||||||||||||
90 | |||||||||||||||
91 | |||||||||||||||
92 | |||||||||||||||
93 | |||||||||||||||
94 | |||||||||||||||
95 | |||||||||||||||
96 | |||||||||||||||
97 | |||||||||||||||
98 | |||||||||||||||
99 | |||||||||||||||
100 | |||||||||||||||