Module 5: Scenario Analysis and What-ifs

63% Complete


Scenario analysis is a key component in smart managerial decision making.  Excel provides a powerful tool called DataTable that makes scenario analysis easy to set up, highly efficient, and easy to interpret.

Please use the comment section below to post your questions and thoughts!

One-way DataTable: Mortgage and down payment

The effect of changing cut-offs

The impact of fee percentages on revenues

Two-way DataTable: The joint impact of interest rate and down payment on mortgage

Two-way DataTable: The effect of adoption rate and incidence rate on drug revenue