Publication number: ELQ-85976-1
View all versions & Certificate
Sensitivity & Scenario Analysis Excel Template
How to use an excel data table for sensitivity and scenario analysis for you financial model.
The following Excel template is a model used for sensitivity and scenario analysis (or What-If analysis). The Excel template provides 2 types of data tables; 1-way data table and a 2-way data table.
The 1-way data table is used for when we want to see how sensitive an output is (or many outputs are) when set against the changes of 1 of its inputs (variables). On the other hand, we use the two-way data table when we want to see how an output changes when two of inputs changes.
So when we want to see how significantly the output changes when “more than 2” of the inputs change, what do we do?
As an example, if we want to perform a simulation for ROE, GPM, Net Profit, Current Ratio and EBITDA, by changing the price, volume, COGS and SGA expenses. In this case, we would need a 4 way data table as we use 4 variables.
However, Excel is not equipped with more-than-2 way data tables. So in order to solve this issue, we have listed a series of steps explained in the methodology, that you may use along the template.
Also, we can use as many inputs and outputs as we desire in this model, which makes it a very versatile platform for sensitivity and scenario analysis.
If you have any questions or feedback on the model, do comment on the discussion section below.
This business tool includes
1 Excel sheet, 1 methodology
Michael Shane offers you this business tool for free!
download for free
Add to bookmarks
- Rustom Sui(last updated: 21/06/2018 05:41)
- 민재 이(last updated: 15/06/2018 14:38)
- Olivier Niveau(last updated: 15/06/2018 08:22)
- Cristian Dunker(last updated: 07/06/2018 04:12)
- Ivan Valchev(last updated: 03/06/2018 03:37)
- Wilopski(last updated: 30/05/2018 12:22)
- Steven Crowthers(last updated: 26/05/2018 00:28)
- Arcangelo Trani(last updated: 24/05/2018 22:22)
- Mansi Naik(last updated: 24/05/2018 11:39)
- Cong Son Trinh, ACCA(last updated: 22/05/2018 14:56)
- Iman Najafi(last updated: 11/05/2018 15:39)
- Karabo(last updated: 10/05/2018 16:25)
- Arun Cherian Varghese(last updated: 07/05/2018 20:40)
- Abdulmalek Rashid(last updated: 30/04/2018 07:52)
- Don Donowitz(last updated: 29/04/2018 07:34)
- Marcus Paleti(last updated: 23/04/2018 16:15)
- Francesco Degioanni(last updated: 21/04/2018 10:43)
- Amro Emara(last updated: 10/04/2018 11:43)
- Mohammed Halaseh(last updated: 27/03/2018 09:02)
- Giuseppe Verardi(last updated: 25/02/2018 10:33)
- Paya Danesh(last updated: 25/02/2018 09:47)
People using this tool also downloaded
Cash Sweep Concepts Excel TemplateUnderstand the four concepts of cash sweeping.financemodeltemplateexceldownloadcash sweepconcepts423 remove_red_eyefreeby Michael Shane
Financial Model for Mobile Payment StartupIncludes assumptions page, income statement, balance sheet, cash flow statement and valuation sheet.income statementfinancemodelbalance sheetstartuptemplateexcelfreedownloadmobile1,300 remove_red_eyefreeby Tayfun Uslu
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaastemplateexcelenterprisefundraise289 remove_red_eye$299.00by Alexander Jarvis
Basic Startup Cost modelAnswers the question to how much you need to raise for a venture backed startup.costmodelsimplestartuptemplateexcelsampleraise capitalmanage cash burn2,810 remove_red_eye
SaaS Metrics Excel TemplateA standard SaaS reporting excel template for entrepreneurs to customize.startupsaaskpistemplateexceldownloadreportingrecurring revenue model3,107 remove_red_eyefreeby Amit Karp
Cash Model Template for StartupsTemplate to forecast your startup's cash expenditure, cash-flow as well as downside potential.modelforecaststartuptemplateexcelcashflowfree1,135 remove_red_eyefreeby Tim Raybould
Due Diligence Assessment ModelAssessment of new business ventures across ten different dimensionsfinancemodeltemplateexcel581 remove_red_eyefreeby Matt Evans
SaaS Financial Model: Simple Template For Early-Stage StartupsSimple financial planning tool tailored for early-stage SaaS entrepeneurs.financialmodelsimpleinvestorstartupearly-stagesaastemplateexcel2,646 remove_red_eyefreeby Gary Gaspar
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis2,979 remove_red_eye$9.00by Alexander Jarvis
Cash flow forecast + Supplementary Personal Survival budget Excel templateCalculates the expected amount of money going in and paying out for your business over a period of time.projectionmodelforecaststartuptemplateexcelcashflowcf1,732 remove_red_eye
Any questions on Sensitivity & Scenario Analysis Excel Template?
The user community and author are here to help. Go ahead!