Here’s How to Calculate Sharpe Ratio in Excel with Formula

Microsoft on Google Finance

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

One variable data table DCF

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 […]

How to Freeze Panes and Zoom in Excel

Picture5.png

  In this post, we will see how to freeze panes and how to zoom in and out of data in excel. Freezing Panes is especially important when you have really huge data. Like shown in the figure below, where the data size is large and you need to scroll down, in such case you […]

How to Hide, Unhide and Group in Excel

Navigation

In this post, we will see very important features- hide, unhide and group in excel. Hide and Group in excel feature is useful when you have really huge data that spans over too many rows and columns, and you want to do away with some rows and columns and want to access only few of them. […]