Setting Up a Sensitivity Table for a DCF
Hey guys,
I'm a trying to teach myself basic modeling in my free time.
I'm having trouble creating a Sensitivity Table. I know I need to use a data table but I'm having trouble setting it up, every time I try I get that my input cells are invalid. Right now I have WACC across the top and Long Term Growth Rate down the side.
I'm trying to find implied share price and I am using the WACC and Long Term Growth Rate from my assumptions tab and my column and Row input cells.
Can you guys point out what I'm doing wrong? Also I'm not sure what formula to put in the top left corner that the data table feeds off of.
Thanks in advance for your help





I'm assuming you have WACC
I'm assuming you have WACC and perp growth inputs in A1 and A2, respectively, and a per share value your model spits out in A3. In the top left corner of your data table set it to equal A3 (per share value). Then you have WACC values across the top of the table and growth on the side. Highlight the table (including your WACC and growth that you are testing for sensitivity, open up the data table setup), put A1 as your row input and A2 as column input.
Who are you going to believe, me or your lying eyes?
Thanks a lot it works
Thanks a lot it works now.
That's what I had before but when referencing my WACC and perp growth rates they were on a different sheet and that what seemed to be causing the error they just need to be on the same sheet, thanks
Never mind figured it out.
Never mind figured it out. Thanks though
Alexkesz: Thanks a lot it
Thanks a lot it works now.
That's what I had before but when referencing my WACC and perp growth rates they were on a different sheet and that what seemed to be causing the error they just need to be on the same sheet, thanks
Right, your inputs must be on the same sheet as your data table, or else it will not work, as you've since figured out!