MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

  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

Related

Категории