Module 5: Scenario Analysis and What-ifs

63% Complete

Introduction

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

Download Excel File

The effect of changing cut-offs

Download Excel File

The impact of fee percentages on revenues

Download Excel File

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

Download Excel File

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

Download Excel File

Ready to go to another module?

XBP Module 0: Road Map and Excel File Download

XBP Module 0: Road Map and Excel File Download
XBP Module 1: Work Faster and Better in Excel

XBP Module 1: Work Faster and Better in Excel
XBP Module 2: Organizing Data

XBP Module 2: Organizing Data
XBP Module 3: Master Financial Functions

XBP Module 3: Master Financial Functions
XBP Module 4: Charts and Graphs

XBP Module 4: Charts and Graphs
XBP Module 5: Scenario Analysis and What-ifs

XBP Module 5: Scenario Analysis and What-ifs
XBP Module 6: PivotTable

XBP Module 6: PivotTable
XBP Module 7: Find Patterns in Data

XBP Module 7: Find Patterns in Data

Discussion Area

Have a question or comments?  Enter below!