•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Mirrored Values in Data Table
I'm trying to do a sensitivity table which changes the value of the share price based on changes in the WACC and growth rate but have been getting duplicate/mirrored? values.
Not sure if formula text is enough for anyone to get the picture, but feel free to ask for more details. Also the 10.06% on the left side of the data table is linked to the WACC input in blue, and the 2.00% at the top of the table is linked to the growth rate in blue.
And of course the cell on the top left is linked to my equity value/share.
Thanks in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site