Q$5.$ Using Scenario Manager for sensitivity analysis

For the following example of obtaining a $15$ year mortgage to buy a house you are likely to obtain a loan of $$400,000$

The number of months for repayment of loan $($monthly payment that includes both principal and interest$)$ are $240$ months $(20$ years$).$

The annual interest rate is $6\%.$ Use scenario manager to create a report tabulating monthly payments for the following scenario:

$\backslash$table$[[$Scenario$,$Amount Borrowed,Annual Rate,Number of monthly Payments$],[$Lowest payment,$$300,000,4\%,360,],[$Most$-$likely payment,$$400,000,6\%,240,],[$Highest Payment,$$550,000,8\%,180,]]$