Greetings,
I am trying to put together a sensitivity analysis where I put two variables into a seperate spreadsheet and would like the output to be put in the intercept cell (yellow) in the table. For example, I want to take the 2.4% value from terminal growth rate and 8.2% from terminal WACC and plug into the cells of my valuation in the second image (the green and red cells) I then want to take the yellow cell, my stock price per share from my valuation and input it in the sensitivity analysis table. See the sheets below: I think it more clear visually.
Any assistance would be greatly appreciated.
Best Regards.
table.jpg
dcff.jpg
Bookmarks