Skip to content
Home » Blog » Finance » Best Way to Calculate Sharpe Ratio with Example

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.

    Month NAV on First Day of the Month NAV on Last Day of the Month Return
            A B = (B-A)/A
    January 2011 25.24 22.2 -0.12044
    February 2011 21.85 20.45 -0.06407
    March 2011 21.07 22.76 0.080209
    April 2011 22.76 22.74 -0.00088
    May 2011 22.49 22.42 -0.00311
    June 2011 22.5 22.43 -0.00311
    July 2011 22.84 23.22 0.016637
    August 2011 23.2 21.63 -0.06767
    September 2011 21.76 20.86 -0.04136
    October 2011 20.62 21.56 0.045587
    November 2011 21.51 19.62 -0.08787
    December 2011 19.73 18.59 -0.05778
    Must Read  Total Deposits in Private Sector Banks of India

     

    Average Monthly Return -0.02532
    Annualized Returns -0.30387
    Standard Deviation 0.058056
    Annualized Standard Deviation 0.20111
    Risk Free Rate of Return 0.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…