Home
Search results “What is a sensitivity analysis in business”

07:53
This short revision video introduces and illustrates the concept of sensitivity analysis. Sensitivity analysis is a technique which allows the analysis of changes in assumptions used in forecasts. As such, it is a very useful technique for use in investment appraisal, sales and profit forecasting and lots of other quantitative aspects of business management.
Views: 32403 tutor2u

04:23
Views: 150165 Eric Andrews

34:17
Sensitivity Analysis for Financial Modeling Course | Corporate Finance Institute Enroll in the full course to earn a certificate and advance your career: http://courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling This advanced financial modeling course will take a deep dive into sensitivity analysis with focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. Course agenda includes: Introduction Why perform sensitivity analysis? Model integration - Direct and Indirect methods Analyzing results Gravity sort table Tornado charts Presenting results By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your financial model. Form and function are both critical to ensure you can handle quick changes and information requests when you're working on a live transaction.

21:04
This video demonstrated the use of some of Excel's tools designed for what-if analysis. It uses the simple example of the PMT function in a loan calculator to demostrate Goal Seek, Data Tables and Conditional Formatting.
Views: 303280 Martin Green

10:54
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do Sensitivity Analysis and adjust a single variable for a NPV calculation. See the NPV and SLOPE function and TRANSPOSE array Functions and how to create a X Y Scatter chart.
Views: 84885 ExcelIsFun

11:45
Looking for advice on creating a sensitivity analysis in Microsoft Excel? The following video is part of the Financial Analyst Specialist certification program offered by BusinesTraining.com. http://businesstraining.com/Financial-Analyst-Certification.html
Views: 5824 BizTraining

23:59
FOR PEN DRIVE CLASSES CONTACT NO. 9977223599, 9977213599 E-MAIL- [email protected]
Views: 20661 CA PAVAN KARMELE

02:18
How to do a sensitivity analysis in Excel with two input variables.
Views: 510502 financewithexcel

07:30
Scenario/Sensitivity analysis is used to evaluate multiple economic and operational scenarios and assess the risk and rewards of strategic alternatives.

02:08
Views: 2137 Archimed Nemes

09:35
An overview of cost and profit sensitivity analysis, to accompany http://www.principlesofaccounting.com Chapter 18, Cost-Volume-Profit and Business Scalability. *Check out the Classroom page to find out how to take this course for credit: http://www.principlesofaccounting.com/classroom.html
Views: 23549 Larry Walther

11:35
Show an introduction to sensitivity analysis using the matrix form of the simplex method
Views: 3921 GOAL PROJECT

06:58
This video considers the usefulness of undertaking sensitivity analysis as part of the investment appraisal process.

07:52
An example of a simple sensitivity analysis and how it affects the NPV calculation of a project.

04:30
Views: 191 intrigano

06:47
This video describes how to use cost-volume-profit models to perform sensitivity (or what-if) analysis.
Views: 1765 KurtHeisinger

04:23
US CMA Exam Part 1 Pro forma FS is based on some assumptions But these assumptions could change ... Series of FS with a series of what-if analyses are made What-if analysis that changes one assumption (or variable) at a time is known as sensitivity analysis. Thus with sensitivity analysis, different sets of FS are made Management can ascertain the variables which have greater impact Management is interested in EPS, additional funding etc Some variables have negligible impact on the above items So the company can focus on the most critical assumptions. https://meraskill.com/cma?utm_medium=referral&utm_source=youtube&utm_campaign=us_cma WhatsApp Now: +91 8692900017
Views: 818 Mera Skill

01:44
Views: 12595 UtahStateCES

03:24
In this and next videos I will explain how to incorporate risk and uncertainty in the economic evaluation of projects for the purpose of investment. I will explain how you can apply the sensitivity analysis techniques to evaluate the projects in this case. There are several quantitative methods for incorporating risk and uncertainty. I will explain two of these methods: 1) Sensitivity analysis or probabilistic sensitivity analysis 2)Expected value or expected net present value
Views: 9412 F. Tayari

14:29
4 Financial Evaluation and Strategy - Corporate Finance
Views: 890 Ryo Eng

10:38
This video is a part of Conservation Strategy Fund's collection of environmental economic lessons and was made possible thanks to the support of the Gordon and Betty Moore Foundation and the Marcia Brady Tucker Foundation. This series is for individuals who want to learn - or review - the basic economics of conservation. In this video, you will learn how to set up a sensitivity analysis within a cost-benefit analysis. To follow this series, subscribe to our YouTube channel. For more information on these and other trainings from Conservation Strategy Fund, check out: http://www.conservation-strategy.org/

13:20
► Find beautiful and engaging presentation templates with Envato Elements: https://elements.envato.com/presentation-templates?utm_campaign=yt_tutsplus_Cl3Xvv6pDnA&utm_medium=referral&utm_source=youtube.com&utm_content=description For the complete written version and free Excel worksheet download, visit Envato Tuts+: http://business.tutsplus.com/tutorials/excel-what-if-analysis-how-to-use-the-scenario-manager--cms-26446?utm_campaign=yt_tutsplus_Cl3Xvv6pDnA&utm_medium=referral&utm_source=youtube.com&utm_content=description Learn how to compare multiple sets of data in Excel with the What if Analysis Scenerio Manager. It helps you find a solution or make a decision based on data analysis.
Views: 155646 Envato Tuts+

45:02
Views: 3746 Lou Gattis

09:44
Let's not only run scenario analysis to find binary outcomes, how about running advanced sensitivity analysis across all our 'what if' potential outcomes. There are seriously so many ways this can be implemented and execute across a range of data scenarios. Good luck implementing this one. ***** Learning Power BI? ***** All Enterprise DNA TV Resources - http://portal.enterprisedna.co/p/enterprise-dna-tv-resources FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources Learn more about Enterprise DNA - http://www.enterprisedna.co/
Views: 2880 Enterprise DNA

10:48
Analyzes net present value using sensitivity analysis and generates a tornado plot. Made by faculty at the University of Colorado Boulder Department of Chemical & Biological Engineering. Check out our process design playlist: http://www.youtube.com/playlist?list=PL4xAk5aclnUjEuE_fvbyEts_oBpHYcwLY
Views: 66895 LearnChemE

18:02
In this video I will work on an example and explain the sensitivity analysis method. I will describe how we can use sensitivity analysis for project evaluation.
Views: 3859 F. Tayari

11:19
Sensitivity Analysis is a tool used in financial modeling to analyze how the different values of a set of independent variables affect a specific dependent variable under certain specific conditions. Click here to learn more about this topic: https://corporatefinanceinstitute.com/resources/knowledge/modeling/what-is-sensitivity-analysis/

16:08
Views: 6656 CS Video Lectures

12:47
http://www.videofinancialmodelling.com/financial-modelling-sensitivity-and-scenario-analysis/ Shows how to setup a sensitivity, scenario or what-if analysis manager in a financial model.

30:29
very simple financial model. Main feature used - conduct “What if” analysis. It adds authority to any type of financial model by testing the model across a wide set of possibilities. Managers need to be prepared for all economic conditions. Sensitivity analysis helps managers to take decisions under certain specific conditions.
Views: 630 R K Arora

03:40
Views: 49 The Course

12:38
The Excel Data Table "What-if Analysis" tool is one of the most powerful, yet underutilised functions in Excel. It is a great way to deliver a high-level, informative what if analysis of a company's financial position such as its Net Present Value (NPV) from a Discounted Cash Flow (DCF) schedule. For the illustrated Excel spreadsheet, read more at http://strategizefm.com/dcf-excel-data-table/

27:03
Investment Appraisal Under Uncertainty Sensitivity Analysis (example 1) - ACCA Financial Management (FM) *** Complete list of free ACCA FM lectures is available on OpenTuition.com https://opentuition.com/acca/fm/ *** Free lectures for the ACCA Financial Management (FM) Exam To benefit from this lecture, visit opentuition.com/acca to download the notes used in the lecture and access ALL free resources: ACCA lectures, tests and Ask the ACCA Tutor Forums Please go to opentuition to post questions to ACCA Tutor, we do not provide support on youtube.
Views: 2815 OpenTuition

06:54
This video is about how to create a sensitivity analysis / what if with Excel 2016. Or in other words "How to do a sensitivity analysis in Excel with two input variables and/or just one variable." Q: Brian from Sandy, Utah writes "Hey John, I'm working on a project where the input costs are ill defined but i'm still tasked with estimating the outcome. I want to perform the analysis AND cover my butt by showing a range of costs / results. Can you look at my spreadsheet?" A: Thanks for writing Brian! You will want to perform a sensitivity analysis. Check out the video. Sensitivity tables are perfect for helping end users understand target costs and the relationship between inputs and outputs. You can scale these to a wide range if you wish. And good idea on your approach. Always good to provide a range when dealing with estimates, especially shakey ones.
Views: 274 Excel Hacker

10:51
An Excel-based sensitivity analysis of Shrieves Casting Company that uses data tables and graphing.
Views: 8075 Phillip Daves

27:02
ACCA F9 Investment Appraisal Under Uncertainty - Sensitivity Analysis Free lectures for the ACCA F9 Financial Management To benefit from this lecture, visit opentuition.com to download the free lectures notes used in the lecture and access all our free resources including all F9 lectures, practice tests and Ask the Tutor Forums. http://opentuition.com/acca/f9/ Please go to opentuition to post questions to ACCA F9 Tutor, we do not provide support on youtube. *** Complete list of free ACCA F9 lectures is available on http://opentuition.com/acca/f9/ ***
Views: 13908 OpenTuition

05:46
A short video explaining how sensitivity analysis works, how it related to capital budgeting and how it can be used to determine capital investment decisions for businesses.
Views: 2089 Study Now

04:03
What is Investment Banking Investment banking is a specific division of banking related to the creation of capital for other companies, governments and other entities. Investment banks underwrite new debt and equity securities for all types of corporations, aid in the sale of securities, and help to facilitate mergers and acquisitions, reorganizations and broker trades for both institutions and private investors. Investment banks also provide guidance to issuers regarding the issue and placement of stock. https://www.youtube.com/playlist?list=PL_H8SEcfTAXlt5mHfRTDdNoivaUagZC87
Views: 66 The Course

11:25

19:35
Views: 796 alice sun

09:04
Sean talks you th
Views: 7875 financecanbefun

12:12
Views: 38684 bnahir

12:28
Learn through this advanced example how you can run sensitivity analysis in Power BI using DAX. There are so many applications for this across multiple scenarios. In this example we will be working with sales margins. ***** Learning Power BI? ***** All Enterprise DNA TV Resources - https://enterprisedna.co/Enterprise-DNA-TV-resources FREE COURSE - Ultimate Beginners Guide To Power BI - http://enterprisedna.co/ultimate-beginners-guide-to-power-bi FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources Learn more about Enterprise DNA - http://www.enterprisedna.co/
Views: 2840 Enterprise DNA

25:46
Professor David Hillier, University of Strathclyde; Short videos for my students Check out www.david-hillier.com for my personal website.
Views: 12651 David Hillier

06:55
Views: 11756 The Audiopedia

07:28
Views: 1056 CARAJACLASSES

13:07
In this video clip, I demonstrate a technique to develop dynamic scenario analysis for Excel, in order to understand the impact on model result/s of changes to multiple input cells under multiple scenarios. The technique overcomes the limitations of the Scenario Manager which is found under the heading of "What-If Analysis" on the Excel Data Tab. The limitations of the standard Excel Scenario Manager are: 1) The routine exists outside of the Excel cells and it is a cumbersome process to change to change input cells under different scenarios in order to evaluate the impact on the model result for each scenario. 2) There is a limitation on the number of input variables (or "changing cells" as they are referred to in the Scenario Manager), which can be reached quite easily on more complex models. By using a combination of the HLOOKUP function, Data Validation (list type) and Data Tables, this technique overcomes these limitations. In order to clearly demonstrate the technique, the example I have used is deliberately simple (one would probably not use this for a simple model as the same result could be achieved by a grid structure with results at the end of each column). I have used the technique successfully for a number of more complex applications such as business valuations, project viabilities and financial budgets. In such applications, the final model result depends upon input from a number of other worksheets. The technique can also be used to assess multiple results for each scenario, with multiple input variables. For example, I have developed a financial model with 6 scenarios, 20 input variables and three results per scenario (e.g. NPV, IRR and Profitability Index). I have tested the results against separate static models for each scenario and I get the same results, so I am confident in the integrity of the technique. There are a few basic rules to follow: 1) The input variables must be values. 2) The scenario table, the data table and the model result formulae need to be located on the same worksheet. It is fine to link the input variables to other worksheets. The technique can be used for virtually any Excel model and has multiple applications. Although I believe that is preferable to commence model development with the specification of the scenario analysis, as this structures the thought process in terms of selection of key input variables and model result/s, the technique can be easily retro-fitted to existing models.
Views: 32357 Murray Saunderson

20:33
An investment has a positive net present value if its market value exceeds its cost. Such an investment is desirable because it creates value for its owner. The primary problem in identifying such opportunities is that most of the time we can’t actually observe the relevant market value. The possibility that we will make a bad decision because of errors in the projected cash flows is called forecasting risk (or estimation risk). Because of forecasting risk, there is the danger that we will think a project has a positive NPV when it really does not. How is this possible? It happens if we are overly optimistic about the future, and, as a result, our projected cash flows don’t realistically reflect the possible future cash flows.

00:43
Sensitivity analysis is a way to predict the outcome of a decision given a certain range of variables. Take the Investopedia Academy 'Financial Modeling' course: https://bit.ly/2Gb0k8N INVESTOPEDIA ACADEMY is expert instruction from Investopedia. Self-paced, online courses that provide on-the-job skills—all from the world’s leader in finance and investing education. Website: https://academy.investopedia.com/ Facebook: https://www.facebook.com/investopedia Twitter: https://twitter.com/investopedia