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 ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.