Search results “Do sensitivity analysis excel”
Sensitivity Analysis in Excel
How to do a sensitivity analysis in Excel with two input variables.
Views: 424212 financewithexcel
Sensitivity Analysis - Microsoft Excel 2016
Example of how to build a sensitivity analysis table in Excel 2016 to evaluate how changing two inputs simultaneously will affect an output (profit). Course discount (81%): https://www.udemy.com/excel-power-user/?couponCode=YOU-TUBE ________ Here is a link to download the practice file we use in the video: https://excelpoweruser.weebly.com/blog/youtube-file-download Sensitivity analysis in Excel is one of the skills that separates the common Excel user from the power user. In this tutorial, we learn how to build a sensitivity analysis table in Excel 2016 to evaluate how changing two inputs simultaneously will affect an output (profit). I hope you enjoy this tutorial and please let me know if you would like more videos on sensitivity analysis. If you'd like to learn more, I built a business-focused Excel course on Udemy that is stripped down to the core functions for being an analyst. The objective is to get people to the power-user level quickly. The course is about 2 hours and includes things like: -completely abandoning the mouse to increase speed 3X -data manipulation & visualization -conditional statements & pivot tables Course discount (save 81%): https://www.udemy.com/excel-power-user/?couponCode=YOU-TUBE For additional tutorials about Excel, check out my Quora profile: https://www.quora.com/profile/Eric-Andrews-5
Views: 69222 Eric Andrews
Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations
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: 76738 ExcelIsFun
Data tables and sensitivity analysis Excel
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: 32478 Dinesh Kumar Takyar
Sensitivity Analysis for Financial Modeling Course | Corporate Finance Institute
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.
Sensitivity Analysis using Excel
Sensitivity Analysis using Excel For more details, visit: http://www.financewalk.com
Views: 17458 FinanceWalk
LP Sensitivity Analysis - Interpreting Excel's Solver Report
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: 47336 Joshua Emmanuel
Two variable sensitivity analysis using data tables in Excel
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: 51517 Dinesh Kumar Takyar
MS Excel: Monte Carlo Analysis - Uncertainty and Sensitivity to Change
In this tutorial we learn how to perform Monte Carlo iteration analysis to account for uncertainty in variables. In this scenario, we examine uncertainty in cost, benefit and growth rate values for a project and how they affect the net present value (NPV). Excel document link: https://drive.google.com/open?id=0B_lD7FHorWGzSGhMWHh5Ukx3Vzg Check out the NEW WEBSITE: https://growyourcareer.com and look under "Downloads" UPDATED BLOG: https://arcologydesigns.blogspot.com Formulas: Cell F2: =RAND()*(D2-C2)+C2 - Generates a random value between the established parameters. Cell I2: =1/1.05^H2 - Discount factor; accounts for our preference to consume now rather than later. Cell J4: =J3*(1+$F$4) - Accounts for the growth rate of benefits at a given percent per year. Cell K2: =I2*J2 - The present value of costs and benefits after discounting. Cell T1: =AVERAGE(R3:R102) - Average NPV. Cell T2: =STDEV(R3:R102) - Standard deviation of NPV. Cell T3: =MIN(R3:R102) - Minimum NPV Cell T4: =MAX(R3:R102) - Maximum NPV Normal Distributions and Bell Curves Tutorial: http://www.youtube.com/watch?v=50kZjl-7ZaQ ________________________________________________________________________ ArcologyDesigns: http://www.arcologydesigns.com BCB Energy, LLC: http://www.bcb-energy.com For free IT sample files, go to: www.bcb-energy.com and click on "IT Training Initiative," and navigate to the Sample Files download page. ________________________________________________________________________ 100% ALL original content - photos, music, lyrics, art and more! BCB Energy, LLC and its subsidiary ArcologyDesigns are the sole creators and owners to all artwork, photographs, illustrations, graphics, logos, lyrics, texts, materials, sound recordings and musical compositions and all features of the content and materials. This includes but is not limited to the design, assortment, arrangement, atmosphere and presentation and any associated copyrights or trademarks of such content and materials.
Views: 34821 Grow Your Career
Sensitivity Analysis in Excel
made with ezvid, free download at http://ezvid.com Tutorial on sensitvity analysis and tornado charts using excel and real data from NextEra.
Views: 33410 bnahir
PrecisionTree Quick Start - Step 5: Perform sensitivity analysis
These short, interactive tutorials are designed to teach you how to use DecisionTools software. This video is the one that corresponds with Step 5.
Views: 5398 PalisadeCorp
Sensitivity Analysis and Tornado Plots
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: 56567 LearnChemE
Excel's Business Tools - What-if Analysis
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: 284741 Martin Green
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 5119106 Excel Campus - Jon
7.3 Sensitivity Analysis
Sensitivity Analysis
Views: 39707 Dee Amaradasa
DCF Sensitivity Analysis with Excel Data Table (UPDATED)
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/
How to perform simple one and two way Sensitivity Analyses using Data Tables in Excel
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
Sensitivity Analysis in Excel
A short tutorial on doing sensitivity analysis with data tables in Excel
Views: 4701 Somik Raha
Sensitivity Analysis using Excel
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: 161 Hum Panta
Sensitivity report in Excel
Sensitivity report in Excel LP for problems 7-31 and 33; Quantitative Analysis for Management
Views: 51452 C. Dale Schrimshaw
Excel Sensitivity Analysis (Part 2/3 - Monte Carlo)
Monte Carlo sensitivity analysis of Net Present Value (NPV) as a function on two random variables.
Views: 9425 Aliosha Alexandrov
Financial Modelling - Sensitivity and Scenario Analysis
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.
Car Loan Comparison using Sensitivity Analysis in Excel
You want to buy a car of Rs. 8 Lakhs, but have an EMI per month budget of only Rs. 13,000. Which car should you buy? How much down payment of cash do you need to make? Your loan should be taken for how many months? Compare multiple car loan options using Excel's Data Table (Sensitivity Analysis), under What-If-Analysis. For more videos on managing Personal Finance using Excel, click this link https://www.youtube.com/playlist?list=PLsHesq9dVLnKFoNtLSrLbrPXPL_xZc6AG SUBSCRIBE! https://www.youtube.com/channel/UC8S-Az-vTSItYE-XR9Fb1Zg?sub_confirmation=1 Blog Visit www.ExcelRush.com for my free blog to learn Excel in-depth. Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.
Views: 1050 Excel Rush .com
IRR Calculation and IRR Sensitivity Table
Internal Rate of Return calculation and Internal Rate of Return Sensitivity Table Creation
Views: 10231 Terry Tate
Sensitivity Analysis in Excel
An Excel-based sensitivity analysis of Shrieves Casting Company that uses data tables and graphing.
Views: 2785 Phillip Daves
Excel - One Way Sensitivity Analysis and PMT Function
A walk through of the PMT equation on excel, along with the use of a data tabel or one-way sensitivity analysis
Views: 5643 tcgraffunder
Corp Finance - module 4 - NPV sensitivity analysis
An example of a simple sensitivity analysis and how it affects the NPV calculation of a project.
Views: 30155 GradSchoolTV
Exercise 5-2. Sensitivity Analysis - One Variable Data Table
I.T. in Hospitality and Tourism Operations Oct 2011 Term
Views: 11747 Jenny Lim
Multiple variable based Sensitivity & Scenario Analysis with Excel
More than 2 variable analysis Sensitivity & Scenario Analysis
Views: 1294 m.shoaib salim
How to create a sensitivity analysis / what if with Excel 2016
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: 209 Excel Hacker
Sensitive Analysis on Excel
Using Excel Tool (What-if Analysis/Data Table) to do the Sensitive Analysis
Views: 53107 ezselflearning
Excel Sensitivity Analysis
Sensitivity Analysis model which can be downloaded from my website
Views: 176884 Michael Popelianski
Excel Video 343 Data Tables with Three Variables
It’s hard to analyze and show three variables in two dimensional space with a Data Table, but Excel Video 343 has some ideas on how you might do it. The first way to analyze three variables is to simply change the third variable and watch as the Data Table changes. If you want something more like a Pivot Table to display the three variables, you’ll see how I created three Data Tables and then wrote formulas to copy specific rows from the three Data Tables. I’ll show you how I redid the Data Table to point to new cells as part of the video. Also note that I had to change the payment formulas in cells B43 and B67 to reference the new variable amounts. I redid the Data Table for a $325,000 loan amount as part of the video, but if you watch carefully, I needed to recalculate the $300,000 Data Table as well. I fix that and then resume recording. The idea is that you can have more than two variables in a Data Table. If you want your spreadsheet to be formatted like a Pivot Table, you need to copy and paste the Data Table as many times as your variables change, change the Data Table formula to reference the new variable cells, and then recreate the Data Table. There are limitations to what you can and can’t do with data in a Data Table. That’s what we’ll discuss in Excel Video 344. I look forward to seeing you then.
Views: 5093 PivotTableGuy
PrecisionTree - Sensitivity Analysis
Perform a sensitivity analysis in PrecisionTree to gain useful insights about the decision tree. Learn more about PrecisionTree: http://www.palisade.com/precisiontree/
Views: 6157 PalisadeCorp
Cost Benefit Analysis - Sensitivity Analysis Excel Model (Project Output Sensitivity Tester (POST))
Sensitivity analysis is used to incorporate risk into a cost benefit analysis. There are several approaches to sensitivity analysis. These approaches vary from applying percentage changes to benefit and cost categories to Monte Carlo Simulation on costs and/or benefits. The video looks at the project outputs sensitivity tester (POST) model that I have developed in Microsoft Excel. The model requires analysis to be conducted in the user’s original model prior to the use. This analysis should include identification and calculation of all relevant scenarios. The outputs of these scenarios are to be entered into POST. POST can be used to calculate a distribution of investment costs and can include as many as ten contingencies. Along with the distribution of costs, POST also calculates the P10, P50, P90, expected value, and standard deviation. This function of POST is recommended if only a base cost estimate or a strategic estimate is available. This function is not recommended if a full cost estimate has been conducted. The strength of the POST model is its capability to calculate distributions of benefits using assigned probability as well as Monte Carlo Simulation. The user of the model can identify up to six non-correlated parameters to adjust in the analysis. The user is able to adjust the parameters up or down. POST is capable of calculating all possible combinations of changes to parameters. Using the results, POST will provide distributions of the project’s benefit cost ratio (BCR) and net present value (NPV). POST also runs Monte Carlo Simulation of 2000 iterations to support the distribution calculated using all possibilities. As only six non-correlated parameters are adjusted, 2000 iterations should provide an accurate result. POST presents the NPV and BCR at P10, P50, and P90 as well as provides the expected value (recommended to be reported as the final result) and the standard deviation. POST also includes the probability the project will exceed the cut-off/hurdle BCR. The cut-off/hurdle BCR is the minimum BCR required for the project to be considered for funding. This video is a follow up to another cost benefit analysis sensitivity analysis video that is currently published on this channel. This video is available at: https://www.youtube.com/watch?v=86GONFJ1C4M The cost benefit analysis series is available at: https://www.youtube.com/watch?v=aOYAPxAtZeg&list=PL_-TsqunhENi8R_HKMO5P5SBX7KYtHWoh The official Spectrum Economics website can be accessed at: https://www.spectrumecons.com For more exciting videos go to my YouTube channel at https://www.youtube.com/channel/UCILwyLtjl7ZTlYOqFkAwLzw You can find me on LinkedIn at: https://www.linkedin.com/in/waynedavies-spectrumecons/ You can find me on Facebook at: https://www.facebook.com/SpectrumEconomics/ You can find me on Steemit at: https://steemit.com/@spectrumecons
Views: 490 Spectrum Economics
NPV, IRR, MIRR, and Data Tables
This is a tutorial on how to calculate NPV, IRR, and MIRR and how to use data tables to evaluate the sensitivity of changes in input variables to NPV.
Views: 25748 Shane Van Dalsem
Create a Two Variable Data Table
Check out my Blog: http://exceltraining101.blogspot.com In a previous post I showed you how to create a one variable data table. You should know by now how Excel just wants you to be able to do more! So much more that there is 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. Check out my Blog: http://exceltraining101.blogspot.com
Views: 201519 Doug H
Sensitivity, Specificity, and Accuracy in Excel
This video demonstrates how to calculate sensitivity, specificity, and accuracy using Microsoft Excel. False negatives (Type II Error) and false positives (Type I Error) are reviewed.
Views: 3802 Todd Grande
Three way data table excel
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/
Build an IRR Matrix for Real Estate in Excel
How to build a simple tool in Excel - the IRR Matrix - to analyze the internal rate of return of a real estate investment in each year of the projected hold period. The IRR Matrix is one tool for helping to assess the ideal hold period for an investment. To download the Excel Workbook used in this video, visit: https://www.adventuresincre.com/using-an-irr-matrix-to-analyze-hold-period To learn more about the author, visit: http://www.spencerburton.org
Views: 15512 Spencer Burton
Single Variable Sensitivity Analysis with Data Tables in MS Excel in Hindi
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: 8501 Dinesh Kumar Takyar
Create a One Variable Data Table
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. Check out my Blog: http://exceltraining101.blogspot.com
Views: 165396 Doug H
Excel What-If Analysis: How to Use the Scenario Manager
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. 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: 77884 Envato Tuts+
How to Use an Excel Data Table for "What-if" Analysis
An Excel Data Table is a great way to see the results of substituting two values in a formula. For example, to see what your monthly payment will be by changing BOTH the Interest Rate and the amount that you borrow. However, reading about how to set up an Excel Data Table can be confusing. Where, exactly, do you place the Row Inputs and the Column Inputs? Seeing how a Data Table is constructed is SO much easier. I invite you to watch this short Excel Training Video Lesson to see how to set up and use an Excel Data Table to analyze your data. You can find additional resources on my website: www.thecompanyrocks.com - I look forward to your comments.
Views: 548401 Danny Rocks