Your clients are both $34$ years old, want to plan for retirement at age $66,$ and both want to plan to age $100.$ They have a household income of $$154,000,$ which they said $($for planning purposes$)$ to assume it increases by inflation as it will keep the plan more conservative. They currently have a total of $$72,723$ saved for retirement purposes, but are saving $15\%$ of their household income, including company matches, into employer$-$provided retirement accounts.

You and the client have agreed on the following assumptions: Inflation $=2\mathrm{.}85\%$ Investment Return $=7\mathrm{.}20\%$ Wage Replacement Ratio $($WRR$)=65\%$ No legacy asset

$10.$ What is the retirement income need they will need to withdraw from their portfolio to support their first

year$$s living expenses upon retirement $($hint: Step $2)$

ANS: $246021$

$11.$ If they don$$t change anything, how much will they have in their retirement accounts to begin retirement with?

ANS:$3320329$

$12.$ If they don$$t change anything, how many years will their portfolio last in retirement? $($round to two

decimals$).$

ANS:$19\mathrm{.}15$

$13.$ How much in assets do they need to start retirement with in order to achieve their goals?

ANS:$4580334$

$14.$ What annual savings amount do they need to hit in order to achieve their retirement goal?

ANS:$34094$

$15.$ What rate of return do they need to achieve in order to meet their retirement goal?

ANS $8\mathrm{.}66$

I have the answers just need to know how to get to them using excel