Problems

1. Delete the best-case scenario and run another scenario report.

2. Add a scenario named High Price, in which Year 1 Price equals $15 and the other two inputs remain at their most-likely values.

3. For the lemonade stand example in Chapter 15, “Sensitivity Analysis with Data Tables,” use the Scenario Manager to display a report summarizing profit for the following scenarios:

   Open table as spreadsheet

   Scenario	Price	Unit cost	Fixed cost
   High cost/high price	$5.00	$1.00	$65,000.00
   Medium cost/medium price	$4.00	$0.75	$45,000.00
   Low cost/low price	$2.50	$0.40	$25,000.00

4. For the mortgage payment example in Chapter 15, use the Scenario Manager to create a report tabulating monthly payments for the following scenarios:

   Open table as spreadsheet

   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