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: 22364 tutor2u
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: 131135 Eric Andrews
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: 5808 BizTraining
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: 83049 ExcelIsFun
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.
Views: 170085 Corporate Finance Institute
FOR PEN DRIVE CLASSES CONTACT NO. 9977223599, 9977213599 E-MAIL- [email protected]
Views: 16226 CA PAVAN KARMELE
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: 8587 F. Tayari
An example of a simple sensitivity analysis and how it affects the NPV calculation of a project.
Views: 34167 GradSchoolTV
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: 23359 Larry Walther
Includes, - steps for decision analysis - decisions under uncertainty - decisions under risk - sensitivity analysis - decision trees - minimax, maxmin, realism (hurwicz), equally likely, and minimax regret criteria - expected monetary value (emv) calculation Playlist: https://www.youtube.com/playlist?list=PL34t5iLfZddtKi93_8Sd0KwwuABmgwbDS
Views: 17802 Bharatendra Rai
"If you’re trying to prepare for an eventual career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you.", Business Insider "A Financial Analyst Career is one of the top-paying entry-level jobs on the market.” "Even in the toughest job markets, the best candidates find great positions.", Forbes You simply have to find a way to acquire practical skills that will give you an edge over the other candidates. But how can you do that? You haven’t had the proper training, and you have never seen how analysts in large firms do their work ... Stop worrying, please! We are here to help. The Complete Financial Analyst Course is the most comprehensive, dynamic, and practical course you will find online. It covers several topics, which are fundamental for every aspiring Financial Analyst: Microsoft Excel for Beginner and Intermediate Users: Become Proficient with the world’s #1 productivity software Accounting, Financial Statements, and Financial Ratios: Making Sense of Debits and Credits, Profit and Loss statements, Balance Sheets, Liquidity, Solvency, Profitability, and Growth Financial Ratios Finance Basics: Interest Rates, Financial Math Calculations, Loan Calculations, Time Value of Money, Present and Future Value of Cash Flows Business Analysis: Understanding what drives a Business, Key Items to be Analyzed and their Meaning, the Importance of Industry Cycles, Important Drivers for the Business of Startup, Growth, Mature and Declining Companies, Important Drivers for an Industry Capital Budgeting: Decide whether a company's project is feasible from a financial perspective and be able to compare between different investment opportunities Microsoft PowerPoint for Beginner and Intermediate Users: The #1 tool for visual representation of your work, a necessary skill for every Financial Analyst As you can see, this is a complete bundle that ensures you will receive the right training for each critical aspect. Here comes the fun part! We have a challenge for you! After covering each major roadblock, you will be asked to solve a challenge. You will: Calculate a company’s sales in Excel Register its bookkeeping entries for 2015 and produce useful financial statements + calculate financial ratios Calculate a complete loan schedule for the company’s debt Analyze the company’s business performance Create a PowerPoint presentation based on the results Receive personalized feedback Receive a gift Participate in our monthly Amazon Gift Card Lottery(!) Sounds interesting, right? At the end of the challenge, you will send us the work you’ve done, and we will reply with personalized feedback. This makes for an interactive student experience that optimizes what you will learn from the course. What makes this course different from the rest of the Finance courses out there? High quality of production: HD video and animations (this isn’t a collection of boring lectures!) Knowledgeable instructor (experience in companies like Pwc and Coca-Cola) Complete training: We will cover all major topics and skills you need to become a top-class Financial Analyst Extensive Case Studies: To help you reinforce everything you’ve learned Course Challenge: Solve our Course Challenge and make this course an interactive experience Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 1 business day Dynamic: We don’t want to waste your time! The instructor keeps up a very good pace throughout the whole course Why should you consider a career as a Financial Analyst? Salary. A Financial Analyst job usually leads to a very well-paid career Promotions. Financial Analysts acquire valuable technical skills, which makes them the leading candidates for senior roles within a corporation Secure Future. There is high demand for Financial Analysts on the job market, and you won’t have to be concerned about finding a job Growth. This isn’t a boring job. Every day, you will face different challenges that will test your existing skills Please don’t forget that the course comes with Udemy’s 30-day unconditional, money-back-in-full guarantee. And why not give such a guarantee, when we are convinced the course will provide a ton of value for you? Just go ahead and subscribe to this course! If you don't acquire these skills now, you will miss an opportunity to separate yourself from the others. Don't risk your future success! Let's start learning together now! Who is the target audience? People who want a successful career in Finance Anyone who wants to learn the practical skills of Financial Analysis People who are ambitious and want to learn faster than their peers https://www.youtube.com/playlist?list=PL_H8SEcfTAXkGKvfYaBniT0boAwMkRqHt&disable_polymer=1
Views: 26 The Course
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: 2746 Enterprise DNA
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/
Views: 19145 Conservation Strategy Fund
Buy video lectures at http://www.conferenza.in/
Views: 5392 CS Video Lectures
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/
Views: 5840 Corporate Finance Institute
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: 139097 Envato Tuts+
Install our android app CARAJACLASSES to view lectures direct in your mobile - https://bit.ly/2S1oPM6 Join my Whatsapp Broadcast / Group to receive daily lectures on similar topics through this Whatsapp direct link https://wa.me/917736022001 by simply messaging YOUTUBE LECTURES Did you liked this video lecture? Then please check out the complete course related to this lecture, Banking Credit Analysis Process with 240+ Lectures, 17+ hours content available at discounted price (10% off)with life time validity and certificate of completion. Enrollment Link For Students Outside India: https://bit.ly/2wcpBMk Enrollment Link For Students From India: https://www.instamojo.com/caraja/banking-credit-analysis-process/?discount=inybcap68 Our website link : https://www.carajaclasses.com ---------------------------------------------------------------------------------------------------------------- BEST FOR CREDIT ANALYSIS THIS IS BEST LECTURE EXPLAINED IN SIMPLE METHOD WITH EXAMPLES FOR CREDIT PROFESSIONAL.Also it would def help on the job purpose as well.Would def recommend ------------------------------------------------------------------------------------------------------------------ Credit Analysis is the core process adopted by any Bank to understand, evaluate and appreciate about the Customers Identity, Integrity, Financial Position, - Repayment Capacity, Etc. Every Banker should be through with Credit Analysis Process because day in day out they have to deal with new customers and before sanctioning any new loans to them, Banker should have made detailed study of their customers. No Banker can raise to top unless he becomes conversant with Credit Analysis Process. Bank would generally throw employees on to the job before they get opportunity to be trained. This is with more specific reference to Credit Analysis where Bankers should under detailed learning process, else their mistakes in the process will be Very Costly beyond their manageable Position. Hence, this course will provide platform to Bankers to have fall back reference on the Critical Aspects of Credit Analysis Process, Banking/ Management Consultants can also use this course for the equipping themselves to the expectations of the Bankers while handling Credit Proposals. This Course has been Structured in self paced Learning Style. Learners can Learn Credit Analysis process at their own time, Convenience and place. Materials used in this Course will enable the participants to understand credit Analysis Process with almost Clarity. • Category: Business What's in the Course? 1. Over 171 lectures and 11 hours of content! 2. By taking this Course you will Understand, What is Credit Analysis 3. By taking this Course you will Understand, What is Working Capital Cycle 4. By taking this Course you will Understand, What is Project Financing 5. By taking this Course you will Understand, Detailed Process of Credit Analysis Course Requirements: 1. No prior knowledge is required for taking this course. 2. Students need PC / Laptop / Tab / Mobile (supporting Android / iOS) to view this course Who Should Attend? 1. Bankers 2. Consultants(Management/Banking/Finance) 3. Finance Managers 4. Entrepreneurs looking for Raising Funds 5. Department Heads 6. Chartered Accountants
Views: 904 CARAJACLASSES
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.
Views: 148209 Video Financial Modelling
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: 763 Mera Skill
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/
Views: 18573 Strategize Financial Modelling
Spreadsheets and Models - Module 2 What-if Analysis, Sensitivity Analysis, Scenarios, and Cash Flow To get certificate subscribe at: https://www.coursera.org/learn/wharton-quantitative-modeling/home/welcome ============================ Spreadsheets and Models https://www.youtube.com/playlist?list=PL2jykFOD1AWbT6cKeb8h5MEQvGb6-_gS0 ============================ Youtube channel: https://www.youtube.com/user/intrigano ============================ https://scsa.ge/en/online-courses/ https://www.facebook.com/cyberassociation/ Spreadsheets and Models About this course: The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses. Module 2 What-if Analysis, Sensitivity Analysis, Scenarios, and Cash Flow In this module, you'll move from spreadsheet to model, so you can begin to create your own models that reflect real-world events. You'll learn how to organize and lay out model elements, as well as the types of objective functions and their use. You'll also learn what-if analysis and scenarios, sensitivity analysis, and other classic models. By the end of this module, you'll be able to design a spreadsheet reflecting assumptions, decision variables, and outcomes, create a basic cashflow model, evaluate a small business opportunity, conduct what-if analysis, identify key variables using sensitivity analysis, and linear programming models and deterministic models.
Views: 98 intrigano
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: 39787 Grow Your Career
Strategic Financial Management : Chartered Accountancy; Capital Budgeting | Sensitivity Analysis | Simulation Analysis | Introduction | Examples | Part 5; Briefing : 00:00:36 - 00:01:43 Topic Covered : 1. Sensitivity Analysis : 00:01:56 - 00:23:51 - Introduction - Examples 2. Simulation Analysis : 00:23:59 - - Introduction - Examples - Steps involved in Simulation Analysis [CA May'11] : 00:30:09 - 00:33:28 - Limitations : 00:33:28 - 00:35:06 Video by Edupedia World (www.edupediaworld.com), Free Online Education; Download our App : https://goo.gl/1b6LBg Click here, https://www.youtube.com/playlist?list=PLJumA3phskPGZ7QPDmzNYr-fJDi5BjW6x for more videos on Strategic Financial Management; All Rights Reserved.
Views: 927 Edupedia World
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: 13069 OpenTuition
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: 263 Excel Hacker
Project planning and Capital Budgeting. For CA final and others
Views: 17 BOWALAL THAKUR
Professor David Hillier, University of Strathclyde; Short videos for my students Check out www.david-hillier.com for my personal website.
Views: 12235 David Hillier
This video covers how differing assumptions can effect your decision which is called senstivity analysis. This video is part of an energy accounting and investment analysis class in the Energy Management and Renewable Energy Solar Programs at Delaware Technical and Community College. To see a full playlist of the Energy Investment Analysis videos go here: https://www.youtube.com/playlist?list=PL1gduOjl1EholWYe-RlxUDPVSSCWiwYm1 To follow along with the slides (feel free to comment on them with questions/suggestions!) go here: https://docs.google.com/presentation/d/1nDDRZAt4FO6QSydLhlM3l_TfTGMT12p_YHtv4Ww9XLg/edit?usp=sharing For more details about the Energy Management program go here: https://www.dtcc.edu/academics/programs-study/energy-management. For more details about the renewable energy solar program go here: https://www.dtcc.edu/academics/programs-study/renewable-energy-solar. For more information about me go to my personal website here: http://bit.ly/corybud
Views: 716 Cory Budischak
Business decisions based on scenario analysis using single and double variable Data Table in excel.
Views: 14 FundaShake
Monte Carlo sensitivity analysis of Net Present Value (NPV) as a function on two random variables.
Views: 10758 Aliosha Alexandrov
Get this model: http://www.smarthelping.com/p/waterfall.html All models from smarthelping: http://www.smarthelping.com/p/excel.html I am trying to explain in plain english the purpose for having multiple IRR hurdles and how the waterfall logic works for cash flows over time. I also explain what this means for investors and sponsors and the incentives that arise by using such a model. This can be used in real estate or any kind of scenario where you have investors investing in a business that has cash flows over time.
Views: 84 smarthelping
Sean talks you th
Views: 7656 financecanbefun
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: 34673 Dinesh Kumar Takyar
Please like our Facebook page at https://www.facebook.com/rutgersweb To watch the entire video, please go to https://www.youtube.com/watch?v=AGu37rM1R5o Description: After a brief review of fixed, variable, and mixed costs, the Professor goes on to give a general idea of what a basic CVP (cost-volume-profit) analysis is. Afterwards, breakeven point is defined (as well as how to find it). Both the income statement and contribution margin approaches are also outlined, as well as utilizing CVP for profit planning. Finally, a brief overview of sensitivity analyses are given (and what they are used for). To receive additional updates regarding our library please subscribe to our mailing list using the following link: http://rbx.business.rutgers.edu/subscribe.html
Views: 2942 Rutgers Accounting Web