Sensitivity Analysis in Excel

How to do a sensitivity analysis in Excel with two input variables.

[@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!

[@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:)

[@fl3661]

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

[@human8461]

Not calculated numbers on the clean sheet

[@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

[@jamesperry3837]

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

[@zuoquankoh7582]

This just saved my life. Thank you.

[@chileno2496]

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

[@AndrewWyborski]

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

[@millionkidane4117]

many thanks for your video!!

[@caiopereira3095]

Thank you so much. Straight to the point!

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

Thank you mate!

[@teodorodepaulaslemenson3759]

Did you put formulas on cells WACC and Growth?

[@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?

[@saman9107]

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

[@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.

[@funguy1128]

Thank you so much!!

[@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.

[@notoriousviktorious8793]

Tack mannen!

[@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!

[@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.

[@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.

[@Shoplifter16]

Thank you so much top video.

[@shifterspeed]

How do you do this in sheets?

[@nileshbarad4794]

Really helpful.. thanks

[@nikolazivkovic1675]

Solid

[@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

[@ccali327]

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

[@danielflex861]

This guy fucks - great video

[@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.

[@lukaskobis7904]

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

[@sriramkv980]

😄

[@piotrw4629]

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

[@0163503387]

Thanks a bunch ! You have saved my time !