Microsoft Excel 2013: Data Analysis and Business Modeling

Chapter 16. Sensitivity analysis with data tables

Questions answered in this chapter:

• I’m thinking of starting a store in the local mall to sell gourmet lemonade. 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 cost.

• I intend to build a new house. The amount of money I need to borrow (with a 15-year repayment period) depends on the price for which I sell my current house. 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 ...