You are $25$ years old and currently earn $$100,000$ per year. Your wage replacement ratio $($WRR$)$ is determined to be $80\%.$ You expect inflation will average $3\%$ for your entire life expectancy. You expect to earn $8\%$ on your investments and retire at age $62,$ living possibly to age $95.$ Your Social Security benefit statement indicates your Social Security retirement benefit in today's dollar adjusted for early retirement is $$40,000$ per year. You will make retirement savings contribution at the end of each month.

Use Excel to calculate Jane's rerirement planning options under the $($a$)$ the Pure Annuity Model, $($b$)$ the Capital Preservation Model and $($c$)$ the Purchasing Power Preservation Model