Delete the best-case scenario and run another scenario report.
Add a scenario named High Price, in which Year 1 Price equals $15 and the other two inputs remain at their most-likely values.
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:
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 |
For the mortgage payment example in Chapter 15, use the Scenario Manager to create a report tabulating monthly payments for the following scenarios:
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 |