EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Sharpe Ratio Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Sharpe Ratio Formula

By Madhuri ThakurMadhuri Thakur

Sharpe Ratio

Sharpe Ratio Formula (Table of Contents)

  • Sharpe Ratio Formula
  • Sharpe Ratio Formula Calculator
  • Sharpe Ratio Formula in Excel (With Excel Template)

Sharpe Ratio Formula

The formula for Sharpe ratio is calculated by dividing the excess rate of return of the portfolio by the standard deviation of the portfolio return. The excess rate of return of the portfolio is calculated by deducting the risk free rate of return from the actual rate of return of the portfolio. Mathematically, the Sharpe ratio formula is represented as below,

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Sharpe Ratio = (Rp – Rf) / ơp

where,

  • Rp = Expected rate of return of the portfolio
  • Rf = Risk-free rate of return
  • ơp = Standard deviation of the portfolio return

In case the Sharpe ratio has been computed based on daily returns, it can be annualized by multiplying the ratio by the square root of 252 i.e. number of trading days in a year.

Sharpe Ratio = (Rp – Rf) / ơp * √252

Explanation of the Sharpe Ratio Formula

The formula for the Sharpe ratio can be computed by using the following steps:

Step 1: Firstly, the daily rate of return of the concerned portfolio is collected over a substantial period of time i.e. monthly, annually, etc. The rate of return is calculated based on net asset value at the beginning of the period and at the end of the period. Then the average of all the daily return is determined which is denoted as Rp.

Step 2: Now, the daily yield of a 10-year government security bond is collected to compute the risk-free rate of return which is denoted by Rf.

Step 3: Now, the excess rate of return of the portfolio is computed by deducting the risk-free rate of return (step 2) from the rate of return of the portfolio (step 1) as shown below.

Excess rate of return = Rp – Rf

Step 4: Now, the standard deviation of the daily return of the portfolio is calculated which is denoted by ơp.

Step 5: Now, the Sharpe ratio is calculated by dividing the excess rate of return of the portfolio (step 3) by the standard deviation of the portfolio return (step 4).

Sharpe Ratio = (Rp – Rf) / ơp

Step 6: Finally, the Sharpe ratio can be annualized by multiplying the above ratio by the square root of 252 as shown below.

Sharpe Ratio = (Rp – Rf) / ơp * √252

Examples of Sharpe Ratio Formula

Let’s take an example to understand the calculation of Sharpe Ratio formula in a better manner.

You can download this Sharpe Ratio Formula Excel Template here – Sharpe Ratio Formula Excel Template

Sharpe Ratio Formula – Example #1

Let us take an example of a financial asset with an expected rate of return of 10% while the risk-free rate of return is 4%. The standard deviation of the asset’s return is 0.04.

Sharpe Ratio Example 1-1

Sharpe Ratio is calculated using the below formula

Sharpe Ratio = (Rp – Rf) / ơp

Calculation of Example 1

  • Sharpe Ratio = (10% – 4%) / 0.04
  • Sharpe Ratio = 1.50

This means that the financial asset gives a risk-adjusted return of 1.50 for every unit of additional risk.

Sharpe Ratio Formula – Example #2

Let us take an example of two financial assets X and Y with the expected rate of return are 12% and 20% for both while the risk-free rate of return is 5%. However, the standard deviation of asset X and Y are 0.04 and 0.15. Figure out which is the better investment given the risk associated.

Sharpe Ratio Example 2-1

Sharpe Ratio for X is calculated using below formula

Sharpe Ratio = (Rp – Rf) / ơp

Calculation of Example 2

  • Sharpe ratio for X = (12% – 5%) / 0.04
  • Sharpe ratio for X = 1.75

Sharpe Ratio for Y is calculated using below formula

Sharpe Ratio = (Rp – Rf) / ơp

Calculation of Example 2-1

  • Sharpe ratio for Y = (20% – 5%) / 0.15
  • Sharpe ratio for Y = 1

This means that even though asset Y offers higher return compared to asset X (asset Y-20% asset X-12%), asset X is a better investment as it has higher risk-adjusted return indicated by Sharpe ratio of 1.75 compared to 1 of asset Y.

Relevance and Uses

It is quintessential to understand the concept of the Sharpe ratio as it is is a comprehensive tool to assess the performance of a portfolio against a certain level of risk. The ratio is usually used to capture the change in the overall risk-return characteristics of a portfolio after a new asset or asset class has been added to the portfolio. The ratio can also be utilized in the evaluation of a past performance of a portfolio by using actual returns of the portfolio in the formula. On the other hand, the ratio can also be used to assess the estimated Sharpe ratio based on expected portfolio performance. As per the Sharpe ratio, a higher value indicates the better risk-adjusted performance of the portfolio.

Sharpe Ratio Formula Calculator

You can use the following Sharpe Ratio Calculator.

Rp
Rf
Op
Sharpe Ratio Formula =
 

Sharpe Ratio Formula =
Rp − Rf
=
Op
0-0
= 0
0

Sharpe Ratio Formula in Excel (With Excel Template)

Now let us take the monthly return information of Sundaram Equity Hybrid Fund to illustrate in excel template below. The table provides the detailed calculation of the Sharpe ratio for Sundaram Equity Hybrid Fund.

Sharpe ratio is calculated by dividing the difference between the daily return of Sundaram equity hybrid fund and the daily return of 10 year G Sec bonds by the standard deviation of the return of the hybrid fund. Consequently, the Sharpe ratio based on the daily return is calculated as 0.272. Further, the Sharpe ratio has been analyzed by multiplying the previous result by the square root of 252.

Sharpe Ratio Example 3-1

Average of the daily return of Sundaram Equity Hybrid Fund

Sharpe Ratio Example 4-1

Average of the daily return of 10 year G-Sec

Sharpe Ratio Example 4-2

Standard Deviation

Standard Deviation

Sharpe Ratio is calculated as:

Sharpe Ratio Example 4-4

Sharpe Ratio for annual is calculated as:

Sharpe Ratio Example 4-5

Recommended Articles

This has been a guide to Sharpe Ratio formula. Here we discuss How to Calculate Sharpe Ratio along with practical examples. We also provide a Sharpe Ratio Calculator with downloadable excel template. You may also look at the following articles to learn more –

  1. Formula for Free Cash Flow
  2. Beta Formula Excel Template
  3. Examples of Payback Period Formula
  4. Asset Turnover Ratio Formula
  5. Portfolio Return Formula | Definition | Examples
  6. Turnover Ratio Formula with Template
Popular Course in this category
Financial Analyst Masters Training Program
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Training4.9
Investment Banking Training4.8
Financial Modeling Training4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Sharpe Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Sharpe Ratio Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more