DocHub is an all-in-one PDF editor that allows you to vary sample in excel, and much more. You can highlight, blackout, or remove document elements, add text and pictures where you need them, and collect information and signatures. And since it works on any web browser, you won’t need to update your software to access its robust capabilities, saving you money. When you have DocHub, a web browser is all you need to handle your excel.
Sign in to our service and follow these instructions:
It couldn't be easier! Enhance your document management now with DocHub!
welcome to another video from Finance with Excel in this video Iamp;#39;m going to show you how to do a sensitivity analysis and Iamp;#39;ve set up a pretty simple case here where Iamp;#39;ve estimated a terminal value based on a free cash flow of 250 a weighted average cost of capital of 12% and a growth rate of 3% what weamp;#39;re going to find out now is how sensitive the terminal value is to changes in the cost of capital and the changes in the growth rate the first thing we need to do is we need to specify the possible changes in the inputs so I want to set up the possible values of the cost of capital as a row here and the possible values of the growth rate as a column so Iamp;#39;m going to have the cost of capital go from 8% all the way up to letamp;#39;s say 15% and growth rate from 0% until 5% and then in the left corner we need to make a reference to the output and so Iamp;#39;ll just type in equals and select the terminal value and when weamp;#39;ve done that just