"Scenario Summary" will be generated in a separate worksheet and must remain in a separate worksheet.

All five input cells must be set as scenario changing cells, and both output cells must be set as result cells

but only the "Annual interest rate" and "Monthly Payment" will have different values for $scn1,scm2,scn3$ and $scn4.$

Suppose that on your $25$th birthday you checked the balance on

your retirement account $($it was $$50,000)$ and you decided to make

a fixed payment at the end of every month until you retire at the

age of $65.$

What is the amount of the monthly payment in order for you to

accumulate $$1,000,000$ at the end of the period?

Assume a $1\%,1\mathrm{.}25\%,1\mathrm{.}5\%$ and $1\mathrm{.}75\%$ annual growth rate of your

retirement fund and create scenarios corresponding to each of

these rates $($must be named $"$scn$1","$scn$2","$scn$3","$scn$4").$ NOTE:

ALL INPUT CELLS ARE SCENARIO CHANGING CELLS.

Then create a scenario report for these four scenarios with BOTH

OUTPUT CELLS being the result cells. The summary report $($must be

named "Scenario summary"$)$ must show the interest rates along

with the monthly payments corresponding to the future value of

$$1,000,000.$

Disregard the inflation.

What are the formulas and how to create scenarios