Welcome to Excel for Financial Analysts post. Many of you might be wondering why this post? Why a separate excel post for how to use Excel in financial analysis? What’s so special about it?
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 […]
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 Excel. The Nobel laureate William F. Sharpe developed the Sharpe Ratio. According to Investopedia: “The Sharpe ratio is calculated by subtracting the risk-free rate from the return of the portfolio […]