Microsoft® Excel Data Analysis and Business Modeling

Chapter 15. Sensitivity Analysis with Data Tables

• I’m thinking of starting a store to sell gourmet lemonade in the local mall. Before opening the store, I’m curious about how my profit, revenue, and variable costs will depend on the price I charge and the unit variable cost.

• I am going to build a new house. The amount of money I need to borrow (with a 15-year repayment period) depends on the price I sell my current house for. I’m also unsure about the annual interest rate I’ll receive when I close. Can I determine how my monthly payments will depend on the amount borrowed and the annual interest rate?

• A major Internet company is thinking of purchasing another online retailer. The retailer’s current annual revenues are $100 million, with expenses ...