| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Stop Working in ASRS at Age | 55 | Age you stop working in an ASRS-covered position | ||||||||||||||||||||||||||||
2 | Draw Pension at Age | 55 | Age you start drawing ASRS pension | ||||||||||||||||||||||||||||
3 | Years of Service | 32 | ASRS years of service at retirement. | ||||||||||||||||||||||||||||
4 | Multiplier | 73.60% | Graded Multiplier times years of service | ||||||||||||||||||||||||||||
5 | Current 403b/457/IRA Balance | $0 | Current balance in your tax-advantaged account | ||||||||||||||||||||||||||||
6 | Monthly Investment | $400 | Monthly contribution to tax-advantaged account going forward for remainder of your career (assumes no match) | ||||||||||||||||||||||||||||
7 | Years Remaining to Invest | 32 | Number of years remaining in your career that you will invest in your tax-advantaged account | ||||||||||||||||||||||||||||
8 | Annual Return | 7% | Annual interest rate earned on tax-advantaged account | ||||||||||||||||||||||||||||
9 | Value of Investment | $529,047 | Total accumulated in tax-advantaged accounts at time of stopping working in an ASRS-covered job | ||||||||||||||||||||||||||||
10 | Average Final Compensation | $85,000 | Average of your highest consecutive 36 months of salary | ||||||||||||||||||||||||||||
11 | Replacement Percentage | 90% | Percent of final average salary you want to live on after stopping working in an ASRS-covered job | ||||||||||||||||||||||||||||
12 | Yearly Increase through age 65 | 2% | Increase in living expenses per year (inflation) through age 65; also assumed inflation rate | ||||||||||||||||||||||||||||
13 | Yearly Increase after age 65 | 1% | Increase in living expenses per year (inflation) after age 65; spending inflation rate after 65, but assume inflation itself is still what's in B12 | ||||||||||||||||||||||||||||
14 | Social Security Replacement % | 37% | Assumption for replacement percentage based on earnings level and age of withdrawal (manually enter, based on https://www.ssa.gov/OACT/NOTES/ran9/an2020-9.pdf) | ||||||||||||||||||||||||||||
15 | Age Begin Drawing Soc Sec | 67 | Age at which you start drawing Social Security Benefits (earliest: 62, full: 67, highest: 70) | ||||||||||||||||||||||||||||
16 | Early Retirement Reduction | 100% | Any reduction in ASRS benefit if take early retirement benefit (manually enter from tables) | ||||||||||||||||||||||||||||
17 | Annuity Option Reduction | 100% | If you choose any option other than Straight Life Annuity, enter the reduction percentage here (manually enter - contact ASRS for percent) | ||||||||||||||||||||||||||||
18 | For Reference | ||||||||||||||||||||||||||||||
19 | Age | ASRS Pension (yearly) | ASRS Pension (monthly) | Social Security Pension (yearly) | Social Security Pension (monthly) | 457/403b/IRA Withdrawal (yearly) | 457/403b/IRA Withdrawal (monthly) | Percent of Projected 457/403b/IRA Balance (yearly) | 457/403b/IRA Balance | Total to live on (yearly) | Total to live on (monthly) | 457/403b/IRA Withdrawal (yearly) | Withdrawal amount using 4% "Rule" with yearly inflation increase (yearly) | Cost of health insurance (monthly, employee only) | Health Insurance Cost as a Percent of Monthly Expenses | ||||||||||||||||
20 | 55 | $62,560 | $5,213 | $0 | $0 | $13,940 | $1,162 | 2.63% | $551,165 | $76,500 | $6,375 | $13,940 | $21,162 | 0.00% | |||||||||||||||||
21 | 56 | $62,560 | $5,213 | $0 | $0 | $15,470 | $1,289 | 2.81% | $573,193 | $78,030 | $6,503 | $15,470 | $21,585 | 0.00% | |||||||||||||||||
22 | 57 | $62,560 | $5,213 | $0 | $0 | $17,031 | $1,419 | 2.97% | $595,094 | $79,591 | $6,633 | $17,031 | $22,017 | 0.00% | |||||||||||||||||
23 | 58 | $62,560 | $5,213 | $0 | $0 | $18,622 | $1,552 | 3.13% | $616,825 | $81,182 | $6,765 | $18,622 | $22,457 | 0.00% | |||||||||||||||||
24 | 59 | $62,560 | $5,213 | $0 | $0 | $20,246 | $1,687 | 3.28% | $638,339 | $82,806 | $6,901 | $20,246 | $22,906 | 0.00% | |||||||||||||||||
25 | 60 | $62,560 | $5,213 | $0 | $0 | $21,902 | $1,825 | 3.43% | $659,587 | $84,462 | $7,039 | $21,902 | $23,364 | 0.00% | |||||||||||||||||
26 | 61 | $62,560 | $5,213 | $0 | $0 | $23,591 | $1,966 | 3.58% | $680,516 | $86,151 | $7,179 | $23,591 | $23,832 | 0.00% | |||||||||||||||||
27 | 62 | $62,560 | $5,213 | $0 | $0 | $25,314 | $2,110 | 3.72% | $701,065 | $87,874 | $7,323 | $25,314 | $24,308 | 0.00% | |||||||||||||||||
28 | 63 | $62,560 | $5,213 | $0 | $0 | $27,072 | $2,256 | 3.86% | $721,173 | $89,632 | $7,469 | $27,072 | $24,795 | 0.00% | |||||||||||||||||
29 | 64 | $62,560 | $5,213 | $0 | $0 | $28,865 | $2,405 | 4.00% | $740,770 | $91,425 | $7,619 | $28,865 | $25,290 | 0.00% | |||||||||||||||||
30 | 65 | $62,560 | $5,213 | $0 | $0 | $29,779 | $2,482 | 4.02% | $760,761 | $92,339 | $7,695 | $29,779 | $25,796 | 0.00% | |||||||||||||||||
31 | 66 | $62,560 | $5,213 | $0 | $0 | $30,702 | $2,559 | 4.04% | $781,162 | $93,262 | $7,772 | $30,702 | $26,312 | 0.00% | |||||||||||||||||
32 | 67 | $62,560 | $5,213 | $31,450 | $2,621 | $185 | $15 | 0.02% | $835,646 | $94,195 | $7,850 | $185 | $26,838 | 0.00% | |||||||||||||||||
33 | 68 | $62,560 | $5,213 | $32,079 | $2,673 | $498 | $41 | 0.06% | $893,609 | $95,137 | $7,928 | $498 | $27,375 | 0.00% | |||||||||||||||||
34 | 69 | $62,560 | $5,213 | $32,721 | $2,727 | $808 | $67 | 0.09% | $955,297 | $96,088 | $8,007 | $808 | $27,923 | 0.00% | |||||||||||||||||
35 | 70 | $62,560 | $5,213 | $33,375 | $2,781 | $1,114 | $93 | 0.12% | $1,020,976 | $97,049 | $8,087 | $1,114 | $28,481 | 0.00% | |||||||||||||||||
36 | 71 | $62,560 | $5,213 | $34,042 | $2,837 | $1,417 | $118 | 0.14% | $1,090,928 | $98,020 | $8,168 | $1,417 | $29,051 | 0.00% | |||||||||||||||||
37 | 72 | $62,560 | $5,213 | $34,723 | $2,894 | $1,716 | $143 | 0.16% | $1,165,456 | $99,000 | $8,250 | $1,716 | $29,632 | 0.00% | |||||||||||||||||
38 | 73 | $62,560 | $5,213 | $35,418 | $2,951 | $2,012 | $168 | 0.17% | $1,244,886 | $99,990 | $8,332 | $2,012 | $30,224 | 0.00% | |||||||||||||||||
39 | 74 | $62,560 | $5,213 | $36,126 | $3,011 | $2,303 | $192 | 0.19% | $1,329,563 | $100,990 | $8,416 | $2,303 | $30,829 | 0.00% | |||||||||||||||||
40 | 75 | $62,560 | $5,213 | $36,849 | $3,071 | $2,591 | $216 | 0.19% | $1,419,860 | $102,000 | $8,500 | $2,591 | $31,445 | 0.00% | |||||||||||||||||
41 | 76 | $62,560 | $5,213 | $37,586 | $3,132 | $2,874 | $239 | 0.20% | $1,516,175 | $103,020 | $8,585 | $2,874 | $32,074 | 0.00% | |||||||||||||||||
42 | 77 | $62,560 | $5,213 | $38,337 | $3,195 | $3,152 | $263 | 0.21% | $1,618,935 | $104,050 | $8,671 | $3,152 | $32,716 | 0.00% | |||||||||||||||||
43 | 78 | $62,560 | $5,213 | $39,104 | $3,259 | $3,426 | $286 | 0.21% | $1,728,594 | $105,090 | $8,758 | $3,426 | $33,370 | 0.00% | |||||||||||||||||
44 | 79 | $62,560 | $5,213 | $39,886 | $3,324 | $3,695 | $308 | 0.21% | $1,845,642 | $106,141 | $8,845 | $3,695 | $34,038 | 0.00% | |||||||||||||||||
45 | 80 | $62,560 | $5,213 | $40,684 | $3,390 | $3,959 | $330 | 0.21% | $1,970,602 | $107,203 | $8,934 | $3,959 | $34,718 | 0.00% | |||||||||||||||||
46 | 81 | $62,560 | $5,213 | $41,498 | $3,458 | $4,217 | $351 | 0.21% | $2,104,032 | $108,275 | $9,023 | $4,217 | $35,413 | 0.00% | |||||||||||||||||
47 | 82 | $62,560 | $5,213 | $42,328 | $3,527 | $4,470 | $372 | 0.21% | $2,246,531 | $109,357 | $9,113 | $4,470 | $36,121 | 0.00% | |||||||||||||||||
48 | 83 | $62,560 | $5,213 | $43,174 | $3,598 | $4,717 | $393 | 0.21% | $2,398,741 | $110,451 | $9,204 | $4,717 | $36,843 | 0.00% | |||||||||||||||||
49 | 84 | $62,560 | $5,213 | $44,038 | $3,670 | $4,958 | $413 | 0.21% | $2,561,349 | $111,555 | $9,296 | $4,958 | $37,580 | 0.00% | |||||||||||||||||
50 | 85 | $62,560 | $5,213 | $44,918 | $3,743 | $5,193 | $433 | 0.20% | $2,735,087 | $112,671 | $9,389 | $5,193 | $38,332 | 0.00% | |||||||||||||||||
51 | 86 | $62,560 | $5,213 | $45,817 | $3,818 | $5,421 | $452 | 0.20% | $2,920,743 | $113,798 | $9,483 | $5,421 | $39,098 | 0.00% | |||||||||||||||||
52 | 87 | $62,560 | $5,213 | $46,733 | $3,894 | $5,643 | $470 | 0.19% | $3,119,157 | $114,936 | $9,578 | $5,643 | $39,880 | 0.00% | |||||||||||||||||
53 | 88 | $62,560 | $5,213 | $47,668 | $3,972 | $5,857 | $488 | 0.19% | $3,331,231 | $116,085 | $9,674 | $5,857 | $40,678 | 0.00% | |||||||||||||||||
54 | 89 | $62,560 | $5,213 | $48,621 | $4,052 | $6,065 | $505 | 0.18% | $3,557,928 | $117,246 | $9,770 | $6,065 | $41,492 | 0.00% | |||||||||||||||||
55 | 90 | $62,560 | $5,213 | $49,593 | $4,133 | $6,265 | $522 | 0.18% | $3,800,279 | $118,418 | $9,868 | $6,265 | $42,321 | 0.00% | |||||||||||||||||
56 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||