Ruestion

Use Scenario Manager to create a scenario report summarizing the monthly payments $($Use the PMT function$)$ for the scenarios given below.

$\backslash$table$[[$Scenario$,$Principal borrowed,Monthly rate,Number of monthly payments$],[$Lowest Principal,$$770,000,0\mathrm{.}60\%,360],[$Likely Principal,$$900,000,0\mathrm{.}65\%,240],[$Highest Principal,$$980,000,0\mathrm{.}70\%,180]]$

The scenario summary should be placed on a new worksheet that is different from the one that contains all the information and the base scenario$/$model$.$

All input and output cells in the scenario summary should be clearly named using range names.

Refer to the instructions listed under 'Homework assignments' in D$2$L$.$