Gorgeous model that tells a story in a clean & concise way, I love it. I will definitely be using some of the visualization techniques from this in my FP&A role.
I'm not this year new to accounting but I'm still new to accounting. Paste special. CFS. WACC. I'm learning so far from just RUclips videos. Love all of you ❤guys and girls by the way. (How could we not)? So thanks. What does DCF stand for, please. Anybody?
I love your work mate, I will have more free time soon and will buy your big course, looking forward! The problem with Excel is that you forget things you don't use frequently, that's why I am doing this model for the second time
Thanks for the tutorial, 1 question though, why do you assume that positive impact = negative impact? for e.g. in the model you set the positive impact of a 5% change in revenue growth to 19% because the negative impact of a -5% change is 19% but according to my calculations (42.83/34.85 - 1) = 23% so a 5% change in Revenue growth causes a 23% change in share price not 19% as stipulated in the gravity sort table and tornado chart. Please clarify this
It is an excellent to explain complex concepts bundle of thanks. but i cant find the excel sheets please share the excel files so we practice along with the tutorial.
Very informative..BUT...is there not a fundamental flaw in the final diagram? You are comparing the effect of +/-5% changes in some inputs to +/-1% changes in other to +/-1x changes in yet another. Should they all not be normalized????
When you take the inverse value of the positive (column J), aren't you assuming each component is a mirror image of the other? I don't think they all have symmetrical outcomes on either side of 0
CFI videos are very informative and well presented. I have seen almost all the videos posted by CFI. My question is for CFI; please answer what extra can I get by enrolling for the course? Thank you
Hello, At 14:48, he changed the revenue formula of 2016. Typically when you perform such analysis, do you always sensitize the first year's projected figures as opposed to last year (2020)?
I like your Excel file but I wonder if its too complicated for real life application. Looks like the worksheet you are working with is loaded with an insane amount of data analysis.
But, I have a question regarding the sensitivity of growth rate in revenue, which actually affect the EBITDA value as well somehow. How do you overcome that issue ?
As you said you worked as investment banker and consultant in corporate development. why you get into teaching line ..? Your reasons will be valuable for me thanks..
I try to use "what if" function for the model that parameter input and formula in the different sheet. And it's not work. So I do the one way sensitivity analysis manually by change each parameter to min and max one by one.
At minute 22:21, why did you select the negative values as the value to numerator of your division (-5% revenue growth value / (reference value-1))...why you don't select +5% as the numerator?
The choice of change in assumptions depends on what you're trying to sensitize. If you would like to know which assumption has the biggest impact on the share price when it decreases by -5%, you would use the negative change as the numerator and rank their absolute values. Vice versa, if you would like to see which assumption affects the share price the most when there is a +5% change, you would take the absolute value of the positive changes and rank them.
Hi SJ. There are two possible reasons for the data table to not be working: - The independent variables you are trying to test are not properly linked to the model (i.e. none of formulas used in the model is dependent on the variable cells) - You have not enabled automatic calculation in Excel (you may turn it on by going to Formulas > Calculation Options > Automatic) Hope this helps!
We have a number of courses in finance. You can check out our course catalog and pricing here: courses.corporatefinanceinstitute.com/collections When you click on each course title, you can see the course curriculum, a detailed overview of the topics covered, and our students' feedback. All of our lectures, study materials, and exams are online and can be accessed from anywhere in the world, allowing you to complete the training at your own pace! Hence, there is no specific timeline for any of our courses. You can sign up for the course of your choice by creating a profile online using your email address and start studying whenever you wish!
Can you please help... I created my own financial model and I implemented the direct and indirect sensitivity analysis shown in the video. The direct method matches the results with my model. However, the indirect method numbers are not matching. The values at 0% are matching the model. However, the values at different percentages, in my case +/-10%, are not matching. Where do you think I went wrong?
While it is difficult to assess what the issue is without looking at the excel file, here are some common problems that may be causing the disparity: 1. The 10% growth rate change is being applied to revenue and not to the actual revenue growth rate. i.e it is growing revenue by 10% instead of changing the growth rate of revenue by 10% (i.e change revenue growth to 11%). 2. Check if all other variables are held constant. Sometimes another variable has been changed that is affecting your results. 3. Simple cell reference issues. I would suggest using trace precedents and dependents to audit the model and see if all the formulas are correctly referenced! I hope you manage to resolve your issue soon!
@@CFI_Official Thank you very much for the insight. My model was actually adding the +/-10% change in revenue growth percentage instead of +/-10% of the forecasted revenue growth percentage. The numbers makes sense now. Thanks again!
hi i would like to ask for your help , i meed to created a price list but is a bit complicit as im not usr to excel im planning to buy stuff and they are different grade of the same product example : grade A = 100% Grade B= 85% grade C 65% and so on many thanks
Hi Xiaolin, Thank you for reaching out to us! You can find the Excel document in the full course here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
Hello, I m actually working on a project finance. and I would like to perform a sensitivity analysis on the DSCR and IRR which variables should I take into consideration. From Morocco best regards
Hi really appreciate the video Thanks. I have a question regarding the financial model. if you have so many data i you have a maximum amount to spent , let say for each person in the database, to make sure that if the person goes aver the amount allocated you ,manually change a number or 2 to make the report look "nice" , how can you set up your model so the expenses wont go over. I was thinking about the " If , CONDITION" in excel. can you help please
You can use data validation to limit/control the numbers users can input. Go to the data ribbon, data validation, then select under Allow: "whole number" or "decimal" and set the min/max allowed. Check out more in our full Excel course: courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance
Hi, All of our courses are online and entirely self-paced. Hence, you can start the course by enrolling online at anytime here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
Hi, this video is taken from our Scenario & Sensitivity Analysis course, which can be accessed here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling The templates are available in the course and downloadable after enrollment!
![Business Analyst Full Course [2024] | Business Analyst Tutorial For Beginners | Edureka](/img/1.gif)
Download the Excel file for this course: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
Please send me mining financial model and senstivity analysis vs scenario analysis on my mail id ... manvinders449@gmail.com
please send me this financial model artagbat.b@qmc.mn
Gorgeous model that tells a story in a clean & concise way, I love it. I will definitely be using some of the visualization techniques from this in my FP&A role.
Thanks! Glad it was helpful for you
@@CFI_Official lo
very effective way of explaining sensitivity analysis for equities. Thanks a lot!
Happy to help!
Such an amazing presentation!! Many thanks!
Thank you so much. It was useful for my interview
The best video with great communication skill.....
Well presented with clarity. Thanks
I'm not this year new to accounting but I'm still new to accounting. Paste special. CFS. WACC. I'm learning so far from just RUclips videos. Love all of you ❤guys and girls by the way. (How could we not)? So thanks. What does DCF stand for, please. Anybody?
DCF stands for : Discounted cash flow
Man, I really apreciate this video. Thanks a lot!
Sensitivity analysis- Excellent post. Thanks.
I love your work mate, I will have more free time soon and will buy your big course, looking forward! The problem with Excel is that you forget things you don't use frequently, that's why I am doing this model for the second time
Thanks! We're glad you're finding the courses helpful
Today bought the big bundle, finally!
I want to know more about corporate finances 1. Nice video.
Thanks for the tutorial, 1 question though, why do you assume that positive impact = negative impact? for e.g. in the model you set the positive impact of a 5% change in revenue growth to 19% because the negative impact of a -5% change is 19% but according to my calculations (42.83/34.85 - 1) = 23% so a 5% change in Revenue growth causes a 23% change in share price not 19% as stipulated in the gravity sort table and tornado chart. Please clarify this
Very good question. I was wondering this too.
F4.. Thank you, just thank you...
It is an excellent to explain complex concepts bundle of thanks. but i cant find the excel sheets please share the excel files so we practice along with the tutorial.
This was so useful! Thank you so much!
Excellent ! The presentation was very informative and helpful. Thanks a ton !!
Amazing method, tremendously useful
Good morning, congratulations on the course. Would you like this spreadsheet to be available?
Nice videos. Thanks posting
Very informative..BUT...is there not a fundamental flaw in the final diagram? You are comparing the effect of +/-5% changes in some inputs to +/-1% changes in other to +/-1x changes in yet another. Should they all not be normalized????
Is it possible to do this sensitivity analysis to more than 2 inputs, say, 3 or 4 inputs all at the same time, using data tables?
Hello! its a great tutorial but we are unable to practice it. so please share excel files so we practice along with the tutorial. Thanks.
When you take the inverse value of the positive (column J), aren't you assuming each component is a mirror image of the other? I don't think they all have symmetrical outcomes on either side of 0
that's right, the change in share value for a +5% change in revenue growth is 22.8%, not the 19% presented in the tornado
Stunning! Thank you.
CFI videos are very informative and well presented.
I have seen almost all the videos posted by CFI.
My question is for CFI; please answer what extra can I get by enrolling for the course?
Thank you
Yes u buy a subscription for 1 year where u can learn everything and get certified if u pass the exam
Great stuff. Thank you.
Thanks for the video!
Hello,
At 14:48, he changed the revenue formula of 2016. Typically when you perform such analysis, do you always sensitize the first year's projected figures as opposed to last year (2020)?
Is there a course which takes you through the complete building of this model please?
Thanks!
I like your Excel file but I wonder if its too complicated for real life application. Looks like the worksheet you are working with is loaded with an insane amount of data analysis.
Excellent
Thanks!
But, I have a question regarding the sensitivity of growth rate in revenue, which actually affect the EBITDA value as well somehow. How do you overcome that issue ?
Hi Ugo, this is by design so you can see the impact on the entire model when revenue changes (including the impact on EBITDA)
As you said you worked as investment banker and consultant in corporate development. why you get into teaching line ..?
Your reasons will be valuable for me thanks..
I'm registering to enroll but its denying my debit card
where is the download link for the excel file?
Thank you so much
I try to use "what if" function for the model that parameter input and formula in the different sheet. And it's not work. So I do the one way sensitivity analysis manually by change each parameter to min and max one by one.
At minute 22:21, why did you select the negative values as the value to numerator of your division (-5% revenue growth value / (reference value-1))...why you don't select +5% as the numerator?
The choice of change in assumptions depends on what you're trying to sensitize. If you would like to know which assumption has the biggest impact on the share price when it decreases by -5%, you would use the negative change as the numerator and rank their absolute values. Vice versa, if you would like to see which assumption affects the share price the most when there is a +5% change, you would take the absolute value of the positive changes and rank them.
I don't understand why the change is always symmetric? Are there some cases which the change on +5% is not opposite of the change on -5%?
What could be the reason for me getting the same numbers for every combination of change?
Hi SJ. There are two possible reasons for the data table to not be working:
- The independent variables you are trying to test are not properly linked to the model (i.e. none of formulas used in the model is dependent on the variable cells)
- You have not enabled automatic calculation in Excel (you may turn it on by going to Formulas > Calculation Options > Automatic)
Hope this helps!
what if all of your outputs are the same?
where is the file you are working with?
This video quality is distorted is there another link to the vide
Please provide vedio for all courses of financial modeling in details.....
We have a number of courses in finance. You can check out our course catalog and pricing here: courses.corporatefinanceinstitute.com/collections
When you click on each course title, you can see the course curriculum, a detailed overview of the topics covered, and our students' feedback. All of our lectures, study materials, and exams are online and can be accessed from anywhere in the world, allowing you to complete the training at your own pace! Hence, there is no specific timeline for any of our courses. You can sign up for the course of your choice by creating a profile online using your email address and start studying whenever you wish!
Impressive. Thank you for sharing.
Very helpful, Can someone give the excel file of that?
Is there financial aid available
Can you please help... I created my own financial model and I implemented the direct and indirect sensitivity analysis shown in the video. The direct method matches the results with my model. However, the indirect method numbers are not matching. The values at 0% are matching the model. However, the values at different percentages, in my case +/-10%, are not matching. Where do you think I went wrong?
While it is difficult to assess what the issue is without looking at the excel file, here are some common problems that may be causing the disparity:
1. The 10% growth rate change is being applied to revenue and not to the actual revenue growth rate. i.e it is growing revenue by 10% instead of changing the growth rate of revenue by 10% (i.e change revenue growth to 11%).
2. Check if all other variables are held constant. Sometimes another variable has been changed that is affecting your results.
3. Simple cell reference issues. I would suggest using trace precedents and dependents to audit the model and see if all the formulas are correctly referenced!
I hope you manage to resolve your issue soon!
@@CFI_Official Thank you very much for the insight. My model was actually adding the +/-10% change in revenue growth percentage instead of +/-10% of the forecasted revenue growth percentage. The numbers makes sense now.
Thanks again!
@@greensal86 No problem at all.
hi i would like to ask for your help , i meed to created a price list but is a bit complicit as im not usr to excel
im planning to buy stuff and they are different grade of the same product
example : grade A = 100% Grade B= 85% grade C 65% and so on
many thanks
how to write "if A and B are in the same row'' in vba programming.
Hi, Thanks for the wonderful video. Can i know where to download the excel docuemnt which you used for the video? Many thanks
Hi Xiaolin,
Thank you for reaching out to us! You can find the Excel document in the full course here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
Hello, I m actually working on a project finance. and I would like to perform a sensitivity analysis on the DSCR and IRR which variables should I take into consideration.
From Morocco best regards
Hi really appreciate the video Thanks. I have a question regarding the financial model. if you have so many data i you have a maximum amount to spent , let say for each person in the database, to make sure that if the person goes aver the amount allocated you ,manually change a number or 2 to make the report look "nice" , how can you set up your model so the expenses wont go over. I was thinking about the " If , CONDITION" in excel. can you help please
You can use data validation to limit/control the numbers users can input. Go to the data ribbon, data validation, then select under Allow: "whole number" or "decimal" and set the min/max allowed. Check out more in our full Excel course: courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance
❤️
This course which time complect
Hi,
All of our courses are online and entirely self-paced. Hence, you can start the course by enrolling online at anytime here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
is this template available?
Hi, this video is taken from our Scenario & Sensitivity Analysis course, which can be accessed here: courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling
The templates are available in the course and downloadable after enrollment!
GG
very poor visual resolution. Blurry and out of focus. Unusable.
you are not from the time when we downloaded low-resolution movies in RMVB haha