Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 17

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 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 for which I sell my current house. I’m also unsure about the annual interest rate I’ll receive when I close. How can I determine how my monthly payments will depend on the amount borrowed and the annual interest rate?

• A major internet company is considering purchasing another online retailer. The retailer’s current annual ...