Sensitivity Analysis in Excel

[@aatsw]

This is incredibly good. Thank you!

[@FlorianRemy]

I don't totally understand the data table behavior when you do the first sensitivity analysis at 1.20. In cell B17, if you use a reference to cell B3 instead of typing "15136", you will get different (and wrong) values in the second column (NOPAT). And then, if you update the value of the revenue in cell B3, it will change the results you get in the NOPAT column. EDIT: it's quite straightforward actually, Excel will replace the value in B3 by the one in B16 to evaluate the first NOPAT. When it calculates the second one, it will check the value in cell B17, so if you have put B17 = B3, it's gonna use the value in cell B16 (because to assess the first NOPAT it replaced B3 by B16). So it will give you the same NOPAT for the second row. And for the last NOPAT, it will do the same trick, B18 = B17 * 1.05 = B3 * 1.05 = B16 * 1.05 resulting in the same mistake.

[@motazfathy1981]

Make the income statement (from A1 to B12) Equations not absolute values: B9=(B3-B5-B6-B7) B11=(B9*B10) B12=(B9-B11) Regards,

[@olorunsholaabdulazeez2011]

Hello, I am trying to find out the sensitivity of CAR to ROA. Every time i set up my table i get the same figures for my dependent variable across the (-5%,0%,5%). I followed step by step as you instructed could you kindly point me in the right direction.

[@jacobacunavirgen1474]

Worked out perfectly. Thank you so much!

[@patrickodong8267]

How? I tried the same thing but i keep getting the wrong answers?

[@jonesistheman]

Hi! Just want to know, how did you fill up the data in the "Reordered sensitivity table"?

[@patrickodong8267]

I tried using the same procedure but I get 3,375 throughout? What did I do wrong?

[@ajaykumarrai4928]

great video sir.

[@immaculatemwihaki5877]

VERY HELPFULL

[@pv0315]

thank you Sir .

[@susankamara2345]

I am unclear as to how you inserted the figures into the reordered sensitivity table, so that they would still be linked to the adjusted sensitivity table

[@maulanayafiedanendra431]

it's ctrl+D