For the "mortgage payment" example in Chapter $17,$ use the Scenario Manager to create a report tabulating monthly payments for the following scenarios:

$\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]]$

The "mortgage payment" Excel file is attached here: HW Module $7-$ Mortgage.xlsx

$2.$ I am managing a conference at my college. My fixed costs are $$15,000.$ I must pay the $10$ speakers $$700$ each, and the college union $$300$ per conference participant for food and lodging costs. I am charging each conference participant who is not also a speaker $$900,$ which includes the conference fee and their food and lodging costs.

$2$a$.$ Develop a spreadsheet model to calculate the profit of the conference for any given number of speakers and participants.

$2$b$.$ Use the Goal Seek tool to find how many paid registrants need to attend to break even.

$3.$ Currently, you sell $40,000$ units of product $xYZ$ for $$45$ each. The unit variable cost of producing the product is $$5.$ You have decided to cut the product price by $30$ percent. You are sure this will increase sales by an amount between $10$ percent to $50$ percent $($increments of $5).$ Perform a sensitivity analysis using data tables to show how profit will change as a function of the percentage increase in sales. Ignore fixed costs.