Sharpe Ratio Calculator

Sharpe ratio is a metric that evaluates risk and returns together in order to help investors in the selection of such investment that generates higher returns for the optimal risk taken. This ratio provides the investor with a perception of return earned on per unit of risk he takes. Sharpe ratio calculator is an online tool for calculating the Sharpe ratio in the blink of an eye. The ratio has got its title from the name of William F. Sharpe, who has developed the formula of Sharpe’s Ratio.

It helps the management in analyzing whether adding any asset helps in generating higher returns or not. Also, it is of great use in ranking and comparing different portfolios.

The formula for calculating Sharpe’s ratio is as follows:

Sharpe’s Ratio = (Rf) / σ


= Mean Portfolio Return of Portfolio

Rf  = Risk-Free Rate of Return

σ = Standard Deviation

Sharpe Ratio Calculator

How to Calculate using Calculator?

For calculating Sharpe’s Ratio, simply provide the following data to the calculator:

Mean Portfolio Return – It is the average of return on a portfolio. It can be based on past as well as future data. The formula for calculating the mean portfolio return from past data is as follows:

= ∑x / n

And for calculating mean portfolio return from future data, the formula is as follows:

= ∑P(x)

Where, x = Return on Portfolio (%)

n = Number of Years

P = Probability

Risk-Free Rate of Return – The risk-free rate of return is a rate on investment having no risk. It works as a benchmark for various other interest rates. Investment in treasury bills and government bonds is considered as a risk-free investment.

Also Read: Sharpe Ratio

Therefore, (Rf) gives a result of returns generated by taking risks.

Standard Deviation – Standard deviation is the amount by which returns may fluctuate in correlation with its average return or mean. It is the expected risk of a portfolio. It represents volatility around the mean.

The formula for calculating standard deviation is:

  • From past data,

σ = √[∑(x – )2/n]

  • From future data,

σ = √[∑P(x – )2]

Excel Calculator – Sharpe Ratio

You can also download our excel based calculator for sharpe ratio.

Excel Calculator For Sharpe Ratio (50 downloads )

Sanjay Borad

Sanjay Bulaki Borad

MBA-Finance, CMA, CS, Insolvency Professional, B'Com

Sanjay Borad, Founder of eFinanceManagement, is a Management Consultant with 7 years of MNC experience and 11 years in Consultancy. He caters to clients with turnovers from 200 Million to 12,000 Million, including listed entities, and has vast industry experience in over 20 sectors. Additionally, he serves as a visiting faculty for Finance and Costing in MBA Colleges and CA, CMA Coaching Classes.

Leave a Comment