Home
Search results “Sensitivity analysis with excel”

04:23
Views: 154996 Eric Andrews

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

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.

12:12
Views: 38950 bnahir

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: 85361 ExcelIsFun

04:52
Sensitivity Analysis using Excel For more details, visit: http://www.financewalk.com
Views: 23827 FinanceWalk

07:00
This brief video explains the components of LP Sensitivity Analysis using an Excel Solver Report. A few questions were also answered based on the following Linear Programming model. Max 50A + 60B + 55C s.t. A + B + C ≤ 100 2A + 3B + 2C ≤ 300 2A + 3B + 2C ≥ 250 A + 2C ≥ 60 1. State the optimal solution 2. What is the optimal objective function value? 3. What would happen to the optimal solution if a) the unit profit on B decreases by 20? b) the unit profit on C decreases to 45? c) the unit profits on A & C change to 53 (Simultaneous Changes-100% Rule)? 4. Interpret the reduced cost for A 5. What would happen to the objective function if a) the RHS of constraint 1 increases by 5? b) the RHS of constraint 2 decreases to 250? c) the RHS of constraint 4 changes to 44? 6. Which constraints are binding? 7. What are the slack/surplus values?
Views: 108776 Joshua Emmanuel

07:09
การใช้งาน Data - Table ใน MS Excel เพื่อใช้ในการคำนวณซ้ำโดยเปลี่ยนค่าตัวแปร 1-2 ตัว หรือเพื่อการทำ Sensitivity Analysis
Views: 17225 ExcelBear

13:23
Views: 8197 Aliosha Alexandrov

04:27
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.comData tables provide an elegant way to perform single and two-way sensitivity analysis on your Excel worksheet data. What is a single variable sensitivity analysis? It is the process by which you find out how one value changes based on a change in another value. You may wish to know how your monthly payments change with change in interest rate keeping the loan amount and period of loan constant. Or, you may wish to 'guesstimate' how your profit would change if you reduced on increased the sales price of an item because that might change the number of buyers. http://www.youtube.com/watch?v=jfRkXKgNVDs
Views: 35224 Dinesh Kumar Takyar

08:04
Views: 239659 Martin Schedlbauer

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/

15:28
Views: 9390 Aliosha Alexandrov

05:22
This is a tutorial on how to use Excel to calculate the intrinsic value of a stock using a non-constant dividend discount model and how to use a two-data table to conduct sensitivity analysis.
Views: 732 Shane Van Dalsem

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

11:23

07:38
In this video, I have explained how to perform sensitivity analysis in excel using data table and goal seek.

14:43
Views: 4167 Barry Cobb

13:25
Monte Carlo sensitivity analysis of Net Present Value (NPV) as a function on two random variables.
Views: 11400 Aliosha Alexandrov

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: 67644 LearnChemE

03:28
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com We learnt earlier how to implement a single variable sensitivity analysis using data tables. Today we'll learn about the two variable sensitivity analysis with data tables. We'll analyze how the equal monthly payment changes with the change in loan amount and the interest rate per annum simultaneously.
Views: 55879 Dinesh Kumar Takyar

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: 304205 Martin Green

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.

18:17
Views: 2075 Great Learning

26:03
Solve a linear programming minimization, do basic sensitivity analysis. Solve both graphically and with Excel solver. Here's the link to the Excel file from this video: https://bit.ly/2HErni8
Views: 447 David Johnk

09:44
The video explains the concept of Sensitivity Analysis.
Views: 4634 Ns Toor

14:36
A short tutorial how to perform simple one (checking the effects of one variable, e.g. price on another variable of interest, e.g. profit) and two way (checking the effect of two variables at the same time, e.g. price and cost, on another variable of interest, e.g. profit) Sensitivity Analyses using Data Tables in Excel
Views: 1626 Data Science at INCAE

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

03:03
Views: 8444 Meghan De Witt

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: 159926 Envato Tuts+

09:30
Views: 178473 Michael Popelianski

04:16
Sensitivity Analysis with Excel Data Table (http://akselrod-academy.com) In this video we discuss sensitivity analysis - the process of testing the influence one or more model inputs have on a model output. In our case we "sensitize" projected 2014 earnings per share to changes in sales growth and gross margin. A quick and painless way to run multiple scenarios without having to manually change each input each time is Excel Data Tables. Excel data tables essentially input these changing variable into your model and present the results in a neat matrix.

11:25

20:17
This tutorial shows how to simplify the sensitivity analysis procedure in engineering economics problems by using the Data Table feature in Excel. The results are used to construct a Tornado diagram and a spider plot to identify the critical parameters. Link to the Excel File: https://www.dropbox.com/s/wz2van6bw99m8ic/Slide%20Example-%20YouTube%20Link.xlsx?dl=0 What is a Data Table Anyway? https://www.youtube.com/watch?v=N924D6tGOG8 How to construct Stacked Bar Charts? https://www.youtube.com/watch?v=HcB0TL-ooCA
Views: 343 Arwa Aboughareeb

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/

11:25

08:44
This video will show you how to do sensitivity analysis in Excel. Thank you for watching this video. If you like it, please subscribe. Thank you.
Views: 178 Hum Panta

04:14
A walk through of the PMT equation on excel, along with the use of a data tabel or one-way sensitivity analysis
Views: 6736 tcgraffunder

04:55
A short tutorial on doing sensitivity analysis with data tables in Excel
Views: 5680 Somik Raha

16:58
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com Shows how to create scenario analysis with spinner boxes and macros that automatically copy data into new cells.
Views: 1829 Edward Bodmer

04:36
Check out my Blog: http://exceltraining101.blogspot.com This video is about creating a two variable data table feature. The use case for this is if you want to input two varying pieces of data and see how the output changes. For example say you are taking out a loan and maybe not sure how much you want to take out. At the same time you are unsure of the rate you might get. What are the possibilities of monthly payments you'll have? It's almost endless! With a two variable data table you can a range of interest rate AND a range of loan amounts and let the handy-dandy data table feature figure out the different monthly payments that are possible. Amazing! See the magic at work in the video. #exceltips #exceltipsandtricks #exceltutorial #doughexcel --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough
Views: 254776 Doug H

06:36
"Two-Variable Data Table Sensitivity Analysis (Valuation) In this video, we look at two-variable data table or two-dimensional data table for sensitivity analysis in excel. Two variable data table is where we can see the senstivity analysis in excel with changes in two variables and its corresponding impact on the output variable. Two variable data table example ------------------------------------------------------- Here we take an example of Alibaba Discounted Cash Flow sensitivity analysis. In DCF approach, we find the price of the stock using Free Cash Flow to firm approach where we require WACC (weighted average cost of capital) and Growth Rate (g) as the two variables. By using the base case assumption of WACC and g, we get the fair price of the stock. However, we can change the assumptions of WACC as well as g and find the effect on stock price using two variable Data Table. Two variable data table in sensitivity analysis is the most useful function. It provides the effect of changing two variables at one time. Such a data table is extremely useful for Financial Analysts and their clients. For more detail, please refer to https://www.wallstreetmojo.com/sensitivity-analysis-in-excel-with-finance-examples/" Subscribe to our channel to get new updated videos.Click the button above to subscribe or click on link below to subscribe - https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1
Views: 6827 WallStreetMojo

08:58
Internal Rate of Return calculation and Internal Rate of Return Sensitivity Table Creation
Views: 15741 Terry Tate

13:05

04:08
We can use data tables in MS Excel to a single variable analysis. A single variable sensitivity analysis helps us in finding out for example, how our sales will be affected if we decrease or increase the price of our goods.
Views: 8965 Dinesh Kumar Takyar

04:47
We can perform a two variable sensitivity analysis with data tables in MS Excel quickly and easily. For example we can estimate how our sales will affected if we increase or decrease the price of our goods and the packaging we use. We can also, for example, estimate the trend of our monthly loan payments with changes in loan period and interest rate.
Views: 4871 Dinesh Kumar Takyar

10:09
www.AuditExcel.co.za- How to create a 3 way ( or 4 or 5 or more) data table in Excel using the data table tool which normally only allows for a 2 way data table. To see more about this ability and to get templates look at https://online-excel-training.auditexcel.co.za/course/multi-variable-excel-data-table/

09:04
Sean talks you th
Views: 7908 financecanbefun

04:39
Check out my Blog: http://exceltraining101.blogspot.com Ever heard of a variable table? What about a one variable table? Well if you haven't you've step into the right place. A one variable table gives you the ability to put a variable input in and see how that input affects some outputs. For example let's say you are taking out a loan and wanted to see what your payments would be at 1%, 1.5% or etc. Instead of erasing and plugging in a different interest each time, you can just create a table that list the interest rates ranging from 1% to say 7% in .5% increments. This can be done with a one variable data table. View the video to see how it's done. #exceltips #exceltipsandtricks #exceltutorial #doughexcel --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough
Views: 213109 Doug H

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: 32926 Murray Saunderson