WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Holding Period Return

Holding Period Return

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Holding Period Return (HPR)?

Holding period return refers to total returns over the period for which an investment was held, usually expressed in percentage of initial investment, and is widely used for comparing returns from various investments held for different periods of time. It also captures any additional income from the investment apart from helping calculate the growth or decline in value over multiple periods.

Holding Period Return Formula

Here’s the formula –

Holding Period Return Formula = Income + (End of Period Value – Initial Value)/Initial Value

Holding period return formula

An alternative version of the formula can be used for calculating return over multiple periods from an investment. It is useful for calculating returns over regular intervals, which could include annualized or quarterly returns. Here, t = number of years

Annualized HPR = [Income + (End of Period Value – Initial Value)/Initial Value+1] * 1/t-1

Alternatively, returns for regular time intervals can be calculated thus:

(1 + HPR) = (1+r1) x (1+r2) x (1+r3) x (1+r4)

Here, r1, r2, r3, r4 are periodic returns.

It can also be represented thus:

HPR = [(1+r1) x (1+r2) x (1+r3) x … (1+rn)] – 1

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Here, r = return per period

n = number of periods

Basic Examples

You can download this Holding Period Return Excel Template here – Holding Period Return Excel Template

Suppose if an individual bought a stock which paid dividends of $50 and its price reached $170 from the initial price of $140 at which it was bought a year ago.

Now, we can calculate the HPR as follows:

  • HPR = [$50 + ($170 – $140)] / $140 = 57.14%

Now, we would try to calculate the annualized returns for the same stock over a period of 3 years. Let us suppose the stock paid dividends worth $50 each year, and returns varied with 21% growth for the first year, followed by 30% returns for the second year and -15% returns for the third year.

Now, we would calculate the annualized HPR as below:

  • HPR = [(1 + 0.21) x (1 + 0.30) x (1 – 0.15)] – 1
  • = [(1.21) x (1.30) x (0.85)] -1 = 33.70%
  • The result would be HPR of 33.71 for all 3 years.

The advantage of using this method is that it would help take into account the effect of compounding over the years, which would lead to a realistic outcome.

Interpretation

HPR can be used to calculate total returns for an investment for a single or multiple periods, including various forms of returns, which might be added improperly otherwise when calculating total returns. For instance, if someone holds a stock for a certain amount of time, and it pays dividends periodically, these dividends also need to be taken into account along with changes in stock prices. It would also require keeping in mind that a rise in the value of the investment during multiple periods of return leads to a compounding effect, which might be left out in simpler calculations.

For instance, if an investment grew by 10% annually, it would be erroneous to assume that in two years, the growth on initial value would be 20%. It has to be calculated, taking into account 10% growth for the first year and then calculating 10% growth over ‘this’ amount for the 2nd year, leading to a total return of 21.1% in two years, instead of 20%.

Relevance and Use of HPR Formula:

As we already explained, one of the key applications of the holding period return formula is inaccurately calculating the effect of compounding while estimating total returns on investment for multiple periods. Apart from that, it has great utility in comparing various investments held for different time intervals in terms of their total returns over these periods.

Calculator

You can use the following Calculator.

Income
End of Period Value
Initial Value
Holding Period Return Formula =
 

Holding Period Return Formula =Income+
(End of Period Value − Initial Value)
=
Initial Value
0+
(0 − 0)
= 0
0

Holding Period Return Formula in Excel (with excel template)

Let us now do the same example above in Excel. This is very simple. You need to provide the three inputs of Income, end of the period value, and initial value.

You can easily calculate the Holding Period in the template provided.

Now, we can calculate the HPR as follows:

HPR in Excel

Now, we would calculate the annualized HPR as below:

HPR Formula in Excel

Recommended Articles

This has been a guide to Holding Period Return and its definition. Here we provide the formula to calculate Holding Period Return along with practical examples and a calculator with a downloadable excel template. You can refer the following articles as well –

  • Abnormal Return
  • Accounting Period Definition
  • Calculate PV
  • Rate of Return Formula
  • Cost-Benefit Analysis Formula
3 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

Login

Forgot Password?

WallStreetMojo

Download Holding Period Return Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More