In this article, I’m going to explain how to calculate one of the most famous ratios, among financial analysis, to measure risk in Microsoft Excel: the Sharpe Ratio. According to Investopedia: “The Sharpe ratio tells us whether a portfolio’s returns are due to smart investment decisions or a result of excess risk. Although one portfolio […]

## How to Do DCF Valuation Using Sensitivity Analysis in Excel

Discounted Cash flow is probably the commonest ways 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 […]