Excel - Scenario Manager / What-if Analysis

Excel's Scenario Manager is part of What-if Analysis in Excel. It is on the Data tab. The Scenario Manager allows you to easily save and substitute values on your worksheet. This is a huge time saver. Instead of creating different worksheets or cell ranges, you keep the initial data and just substitute scenarios. I use this for budgeting and forecasting, and in this video, I'll use a Loan Amortization worksheet. One great advantage of the Scenario Manager is I can create a Summary worksheet with the Scenario Manager. All my relevant cells and data end up on one worksheet.

Screenshot of where the Scenario Manager is located in Excel

* Base-case: Your most realistic estimate of what will happen (my original data)
* Best-case: Scenarios that are more optimistic but less probable
* Worst-case: Scenarios that are more pessimistic but less probable

Chapters:
0:00 Intro
0:35 Loan amortization template
1:30 House loan
2:55 Input & dependent cells
4:10 Add Scenarios
6:50 Show scenarios
8:10 Summary worksheet

In this specific video example, I use a loan amortization schedule template from Microsoft. I use scenario manager to look at the different loan amounts for a house, at different interest rates, and terms in years (15 years fixed vs. 30 years fixed).

File Download location

#msexcel #scenariomanager #excelscenariomanager #excelwhatifanalysis #chrismenardtraining
Websites:

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[lisaamante]

Las Vegas, NV, USA: Awesome instruction, clear, concise, quick and easy to follow. Thank you! BTW, I just now found out about this feature. Last year I created 14 spreadsheets to figure out which Long Term Care policy I was going to buy. This would have saved me DAYS and DAYS of my life and left me more confident I didn't have any formula errors.

[joeyfalle]

Great Video! I would recommend this to all my friends! I used the same spreadsheet for my mortgage comparison, but without the knowledge of "What-if Analysis/Scenario Analysis"...This is an amazing feature and could have saved at least 5 hours of my life! Thank you again for your time and effort for making this video and share your knowledge!

[simonasterisk]

This is an amazing feature and a great explanation. Thanks!