Sensitivity Analysis in Excel

[@ilorijohn9509]

This was really helpful, I've been trying to sort out my company's sensitivity analysis for days and it kept failing...I'm glad this worked out🙏🏽💪🏽

[@angeloa.paladinoiii1827]

Grad Student in an MSRED program here, working on a project, thank you for putting this simple, yet powerful video together, it helped me a ton!

[@nickherbst5717]

If it is not working for u guys its probably because your original Term value is not calculated by a function. If you do this, im pretty sure it will work.

[@misaelherrera6557]

I'm 4 years late but in my case, it is calculated by a function and it's still not working

[@fl3661]

Is there any reason I get the same value throughout the whole table?

[@penguins2628]

In your settings go to formulas and set calculation settings to automatic default is usually partial.

[@flori7976]

Thank you so much! I am a beginner with excel and had to do a sensitivity analysis at work. You made it really easy:)

[@zuoquankoh7582]

This just saved my life. Thank you.

[@jamesperry3837]

TᕼᗩᑎK YOᑌ! - *this is a cool tutorial. Very nice example btw and it's just 2+ mins.*

[@AndrewWyborski]

Great video, really helped me out in a crunch! Much appreciated.

[@chileno2496]

Isn´t the Terminal Value formula TV= (FCF*(1+g))/(WACC - g ) ???? Why do you have only TV= FCF/(WACC - g) ?

[@caiopereira3095]

Thank you so much. Straight to the point!

[@njabulov.hadebe9102]

I am not winning here my table comes out with all the values as the terminal value. does anyone know why this is the case? how do I fix this? #thankxinadvanceforyourhelp

[@alexanderchenf1]

Same here

[@gabrielgonzalez9954]

Definitely answering this too late for you Njabulo, but anyone else encountering this problem should look under Formulas --> Calculation --> Calculation Options --> Automatic. Excel typically has it set to "Automatic Except for Data Tables" which can bring about that issue.

[@hl3616]

@@gabrielgonzalez9954 Mate youre a legend. I am sitting here for over an hour trying to figure out why i get no output in the table. Your advice did the trick. Thank you very much sir!

[@AirPickles]

Is terminal value (cell G11) a constant or is there a formula in that cell? I'm interested in doing a sensitivity analysis for two variables in a net present value equation. Is there guidance you could recommend? Thanks.

[@hete88]

There is a formula in that cell. FCF/ (WACC - Growth). You should be able to do a sensitivity analysis for two variables using the method in the video. Which two variables were you thinking about?

[@AirPickles]

hete88 Yes, I got everything to work, thanks.

[@saman9107]

This video was great help, thanks a bunch!! Kindly can you share model for stock price sensitivity analysis.

[@teodorodepaulaslemenson3759]

Did you put formulas on cells WACC and Growth?

[@elfienaevi9719]

hello, if i am doing a sensitivity analysis between beta and market risk premium, what will be the formula in cell G11? hope you can help me. Thanks!

[@lexielarsson3936]

How do you apply a sensitivity analysis if you invest in staff? I have this example where you invest 300 000 in a staff education and i don't know how to make a sensitivity analyse, because every example i find is related to FCF and WACC and i don't have such data.

[@babazfood]

Thanks for this useful video. I am trying to embed efficiency in my calculation to generate this table. But unfortunately it doesn't take into account efficiency factor as its not embed in the formula. Could you help me in a way i can embed efficiency in this analysis?

[@millionkidane4117]

many thanks for your video!!

[@saturdayalexander4688]

Please, i need help. I am working on my master thesis and want to know why researchers do not apply sensitivity analysis in goal programming research work.

[@shifterspeed]

How do you do this in sheets?

[@nileshbarad4794]

Really helpful.. thanks

[@Shoplifter16]

Thank you so much top video.

[@КультурныйХулиган-ц3м]

Thank you mate!

[@stokulapoke1]

Shout out to all the CE majors

[@danielbustos3356]

you understand how to solve for the assignment?

[@stokulapoke1]

@@danielbustos3356 Use the geometric gradient formula for your upper left "terminal" value. The uniform "A1" value is the savings percentage multiplied by your fixed salary. "i" is the ROR, "g" is your raises, and "n" is the number of years. All those values are obtained from retirement 1, and the sensitivity analysis only changes the ROR and savings values.

[@stokulapoke1]

@@danielbustos3356 Almost forgot, the geometric gradient formula returns a present value, so you need to multiply it by the F/P factor to convert it into a future value.

[@danielbustos3356]

Stephen Heffner thanks!!! The value that pops out is 6.879 mill just like retirement 1

[@funguy1128]

Thank you so much!!

[@nikolazivkovic1675]

Solid

[@notoriousviktorious8793]

Tack mannen!

[@lukaskobis7904]

I built a tool that lets you run a sensitivity analysis by simply uploading your Excel file: causal.app/sensitivity

[@ccali327]

How about next time, you just turn the lights off to see just how bad the picture quality can be?

[@anthonydibenedetto8344]

Correct me if I'm wrong, but I don't think this is correct. First, at a 0% growth rate, that would indicate extreme risk, so it would make more sense if the discount rate were then 15%, not 8. So, I think you need to flip your growth rates going from 5% down to (at a minimum) 0.5% (no one pays for 0% growth). Also, no one will pay the same for 0% growth at an 8% DR as 4% growth at a riskier 12% DR. Just nonsensical. Top left should indicate most optimistic viewpoint, while bottom right should indicate worst case.

[@abrahamceballos8291]

he is just showing how to do a table this is not a real scenario.

[@danielflex861]

This guy fucks - great video

[@sriramkv980]

😄

[@piotrw4629]

The content is ok, but why does he sound like he's doing it as a punishment?