Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, BB, and E6. Good B7_0325 B8 15 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. Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12. Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. Enter a formula in cell F12 to calculate the remaining balance after the current payment. The remaining balance is calculated by subtracting the principal payment from the balance in column B. Ent a function in cell G12, based on the payment and loan details, that calculates amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references