Setting Up a Sensitivity Table for a DCFPE
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