How to Do DCF Valuation Using Sensitivity Analysis in Excel
In this post, we are going to see Sensitivity Analysis in Excel. Discounted Cash flow is probably the commonest way of valuation of a company. This method involves amongst other things analyzing the impact of factors like cost of equity or change in risk-free rate on the price of a company’s share. It is but obvious that any company operates in a dynamic environment and hence for investors it is imperative that the model so built gives the investor a ...