Best Way to Calculate Sharpe Ratio with Example

Best Way to Calculate Sharpe Ratio with Example. Sharpe Ratio is helpful in evaluating Mutual Funds Performance. Higher the Sharpe Ratio better is the fund.

Sharpe Ratio Formula = (Mean of Fund Returns – Risk-Free Return) / Standard Deviation

For calculating Sharpe Ratio follow these steps:

  1. Decide Fund whose Sharpe Ratio you want to calculate
  2. Find the NAV on First Day of the Month
  3. Find the NAV on Last Day of the Month
  4. Calculate Return by Formula i.e. (Return = (NAV on Last Day – NAV on First Day) / NAV on First Day)
  5. Calculate Mean of the returns this will give us monthly return
  6. To calculate annualized return multiple monthly return calculated in step 5 with 12.
  7. Calculate Standard Deviation of the return
  8. To calculate annualized Standard Deviation multiple it with 12.
  9. Risk Free Return is assumed to be 8% (As bank is giving minimum 8% interest on Fixed Deposits this may change from time to time).
  10. Put all the values calculated in the formula to get value of Sharpe Ratio

Example for calculating Sharpe Ratio:

SBI Magnum MidCap Fund.

MonthNAV on First Day of the MonthNAV on Last Day of the MonthReturn
        AB= (B-A)/A
January 201125.2422.2-0.12044
February 201121.8520.45-0.06407
March 201121.0722.760.080209
April 201122.7622.74-0.00088
May 201122.4922.42-0.00311
June 201122.522.43-0.00311
July 201122.8423.220.016637
August 201123.221.63-0.06767
September 201121.7620.86-0.04136
October 201120.6221.560.045587
November 201121.5119.62-0.08787
December 201119.7318.59-0.05778

 

Average Monthly Return-0.02532
Annualized Returns-0.30387
Standard Deviation0.058056
Annualized Standard Deviation0.20111
Risk Free Rate of Return0.08
Sharpe Ratio-1.90872

 

If you Want to read articles on Marketing Mix – Click Here

If you like This Article on Business Model of LinkedIn Please Like our Facebook Page PROJECTS4MBA

Cite This Work

Referencing Style to cite this article:
[citationic]

Recommended
Questionnaire for Satisfaction level of Retailers towards Airtel Mobile Services…