$3)$ Gina just turned $25$ and she is planning to retire at age $55.$ She plans to make $30$ equal annual

deposits into a retirement account and then withdraw $$35,000$ once per year for $30$ years,

beginning $5$ years after the last deposit. The retirement account earns an annual return of $10\%.$

a$.(3$ Points$)$ Draw the cash flow diagram for this situation.

b$.(3$ Points$)$ Solve this problem by hand, similar to the method shown in the Week $3$

slide deck.

c$.(15$ Points$)$ The answer to this part should be uploaded as an Excel file. Construct

an Excel model that will analyze the above problem. The Excel model should have

specific cells where the user can enter different withdrawal amounts, number of

withdrawals, and investment return percentages to see how the required deposit

changes as these parameters change.