Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5 E6 = 312227.32 Bad B7 = .0700 B8 = 3 E6 = 350000 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately.

If i could get an answer that guides me through how to do this step by step would be helpful

B6 X =PMT(E7, E8,-E6) A B C D E F H 1 K L M N o P R S Loan Details Loan $312,227.32 Periodic Rate 0.479% # of Payments 60 4 5 Payment Details 6 Payment $6,000.00 7 APR 5.75% 8 Years 5 9 Pmts per Year 12 10 Payment Beginning Payment 11 Number Balance Amount 12 1 13 2 14 3 15 4 16 5 17 6 18 7 19 8 Principal Interest Paid Repayment Remaining Cumulative Balance Interest Cumulative Principal 9 20 21 22 10 11 12 13 14 15 16 17 23 24 25 26 27 28 29 30 31 32 33 34 35 18 19 20 21 22 23 24 36 25 26 27 37 38 39 40 28 29 Step Instructions Points Possible 12 5 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5 E6 = 312227.32 Bad B7 = .0700 B8 = 3 E6 = 350000 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately