| Current Age | 22 |
| Expected Retirement Age | 65 |
| Expected Annual Inflation Rate | 0.021 |
| Starting Salary | $ 45,000.00 |
| Expected Salary Growth Rate | 0.04 |
| Employer contribution (%) | 0.03 |
| Employee contribution (%) | 0.06 |
| Current retirement savings | $ 300,000.00 |
| % of final salary required | 0.75 |
| Age | Salary Growth | Salary | Contributions | Withdrawals |
| 22 | $ - 0 | $ 45,000.00 | $ 46,350.06 |
| 23 | $ 1,800.00 | $ 46,800.00 | $ 48,204.06 |
| 24 | $ 1,872.00 | $ 48,672.00 | $ 50,132.22 |
| 25 | $ 1,946.88 | $ 50,618.88 | $ 52,137.51 |
| 26 | $ 2,024.76 | $ 52,643.64 | $ 54,223.00 |
| 27 | $ 2,105.75 | $ 54,749.38 | $ 56,391.92 |
| 28 | $ 2,189.98 | $ 56,939.36 | $ 58,647.60 |
| 29 | $ 2,277.57 | $ 59,216.93 | $ 60,993.50 |
| 30 | $ 2,368.68 | $ 61,585.61 | $ 63,433.24 |
| 31 | $ 2,463.42 | $ 64,049.03 | $ 65,970.56 |
| 32 | $ 2,561.96 | $ 66,610.99 | $ 68,609.38 |
| 33 | $ 2,664.44 | $ 69,275.43 | $ 71,353.76 |
| 34 | $ 2,771.02 | $ 72,046.45 | $ 74,207.90 |
| 35 | $ 2,881.86 | $ 74,928.31 | $ 77,176.22 |
| 36 | $ 2,997.13 | $ 77,925.44 | $ 80,263.26 |
| 37 | $ 3,117.02 | $ 81,042.46 | $ 83,473.79 |
| 38 | $ 3,241.70 | $ 84,284.16 | $ 86,812.74 |
| 39 | $ 3,371.37 | $ 87,655.52 | $ 90,285.25 |
| 40 | $ 3,506.22 | $ 91,161.74 | $ 93,896.66 |
| 41 | $ 3,646.47 | $ 94,808.21 | $ 97,652.52 |
| 42 | $ 3,792.33 | $ 98,600.54 | $ 101,558.62 |
| 43 | $ 3,944.02 | $ 102,544.56 | $ 105,620.96 |
| 44 | $ 4,101.78 | $ 106,646.35 | $ 109,845.80 |
| 45 | $ 4,265.85 | $ 110,912.20 | $ 114,239.63 |
| 46 | $ 4,436.49 | $ 115,348.69 | $ 118,809.21 |
| 47 | $ 4,613.95 | $ 119,962.63 | $ 123,561.57 |
| 48 | $ 4,798.51 | $ 124,761.14 | $ 128,504.03 |
| 49 | $ 4,990.45 | $ 129,751.59 | $ 133,644.19 |
| 50 | $ 5,190.06 | $ 134,941.65 | $ 138,989.96 |
| 51 | $ 5,397.67 | $ 140,339.32 | $ 144,549.55 |
| 52 | $ 5,613.57 | $ 145,952.89 | $ 150,331.53 |
| 53 | $ 5,838.12 | $ 151,791.00 | $ 156,344.79 |
| 54 | $ 6,071.64 | $ 157,862.64 | $ 162,598.58 |
| 55 | $ 6,314.51 | $ 164,177.15 | $ 169,102.52 |
| 56 | $ 6,567.09 | $ 170,744.24 | $ 175,866.62 |
| 57 | $ 6,829.77 | $ 177,574.00 | $ 182,901.28 |
| 58 | $ 7,102.96 | $ 184,676.96 | $ 190,217.33 |
| 59 | $ 7,387.08 | $ 192,064.04 | $ 197,826.02 |
| 60 | $ 7,682.56 | $ 199,746.61 | $ 205,739.06 |
| 61 | $ 7,989.86 | $ 207,736.47 | $ 213,968.62 |
| 62 | $ 8,309.46 | $ 216,045.93 | $ 222,527.37 |
| 63 | $ 8,641.84 | $ 224,687.77 | $ 231,428.46 |
| 64 | $ 8,987.51 | $ 233,675.28 | $ 240,685.59 |
| 65 | $ 9,347.01 | $ 243,022.29 | $ 250,313.02 |
| 66 | | | | $ 182,266.72 |
| 67 | | | | $ 186,094.32 |
| 68 | | | | $ 190,002.30 |
| 69 | | | | $ 193,992.35 |
| 70 | | | | $ 198,066.18 |
| 71 | | | | $ 202,225.57 |
| 72 | | | | $ 206,472.31 |
| 73 | | | | $ 210,808.23 |
| 74 | | | | $ 215,235.20 |
| 75 | | | | $ 219,755.14 |
| 76 | | | | $ 224,370.00 |
| 77 | | | | $ 229,081.77 |
| 78 | | | | $ 233,892.49 |
| 79 | | | | $ 238,804.23 |
| 80 | | | | $ 243,819.12 |
| 81 | | | | $ 248,939.32 |
| 82 | | | | $ 254,167.05 |
| 83 | | | | $ 259,504.55 |
| 84 | | | | $ 264,954.15 |
| 85 | | | | $ 270,518.19 |
| Sum | | | $ 5,649,389.49 | $ 4,472,969.18 |
| Money available for beneficiary | | | | $ 1,176,420.31 |
faisal91
_retirment_plan.xlsx
