Publication number: ELQ-58674-1
View all versions & Certificate
Sensitivity Analysis Using Excel
In this video you will learn how to carry out sensitivity analysis using Excel.
In this video, you will see a sensitivity analysis using data tables and will learn how to use data tables in sensitivity analysis.
Sensitivity analysis is a technique that is used to see how different values of an independent variable impact a particular dependent variable under a given set of assumptions. This technique is used within specific boundaries that depended on one or more input variables - for example, the effect that changes in interest rates have on the price of bonds.
Video length: 4:51
This business tool includes
1 Video File
Add to bookmarks
Did Finance Walk's tool help you? You can make a small financial contribution to support the author.
- No review yet!
People using this tool also downloaded
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model13,658 remove_red_eye
Discounted Cash Flow Formula: TutorialVideo tutorial on how to build a discounted cash flow from scratch in Excel.financecorporate financedcfdiscounted cash flowexcelhow todiscounted cash flow analysis17 remove_red_eye
How to do Sensitivity Analysis in Excel: One & Two Variable Data TableLooking at Sensitivity Analysis in Excel for professionally modeling Discounted Cash Flow.dcfsensitivity analysisshare priceassumptionsdiscounted cash flowexcelstep by stepvariable datavariable data tablevaluation sensitivityNew!
DCF Valuation Model TemplateThis template provides you with a foundation to build your own discounted cash flow model with different assumptions.financedcffinancial modeldiscounted cash flowdcf modeldiscounted cash flow model134 remove_red_eye
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow6,984 remove_red_eye
The Discounted Free Cash Flow (DCF) ModelA full discounted cash flow excel model for a complete businessfinancevaluationpresent valueassetsdcfdiscounted cash flowcomplete business1,299 remove_red_eye
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.financevaluationdcfevaeconomic value addeddiscounted cash flow112 remove_red_eye
Activision Blizzard DCF (Discounted Cash Flow) ModelA simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)financevaluationdcfoperatingterminal valueshare pricediscounted cash flowworking capital436 remove_red_eye
Quick Lesson: Build a Discounted Cash Flow (DCF) Model, Part 1Learn how to build a simple DCF Model aligned with Investment Banking best practices.valuationdcfdiscounted cash flowtemplateexcelvideohow todcf modellessonquick lesson75 remove_red_eye
Discounted Cash Flow (DCF) Model (Academic Quality)A simple DCF model serving as an academic exercise to understand how financial modeling works.financevaluationcorporate financedcfdiscounted cash flowmbamergers and acquisitions1,103 remove_red_eyefreeby Joshua Wong
Any questions on Sensitivity Analysis Using Excel?
The user community and author are here to help. Go ahead!