Please Use Excel and Show Formulas using Goal seek or solver!!!!!

Pat is the type to plan everything in advance, and she is already starting to plan for retirement. She plans to work for 40 years, and then retire for the following 30 years. She expects to spend $100,000 in her first year of retirement, with a 2% growth rate. She will increase her working-years savings rate by 5% per year. While working, she expects her account will have a 6.75% return, and during retirement it will have a 4.75% return. After the 30^th year of retirement, she wants to have $200,000 in her account for safety net and bequest reasons (It is fine if the amount is not exactly $200,000 due to rounding error). Her retirement savings account currently has $0.

To solve the problem, determine how much Pat needs to save in year 1 to accomplish her retirement goals (use Solver or Goal Seek).

Please Use Excel and Show Formulas using Goal seek or solver!!!!!