What is Holding Period Return (HPR)?

Holding Period Return Formula

Here’s the formula –

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Holding Period Return (wallstreetmojo.com)

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

Here, r = return per period

n = number of periods

Basic Examples

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 compoundingCompoundingCompounding is a method of investing in which the income generated by an investment is reinvested, and the new principal amount is increased by the amount of income reinvested. Depending on the time period of deposit, interest is added to the principal amount.read more 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.

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.

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 ReturnAbnormal ReturnAbnormal Returns are defined as a variance between the actual return for a stock or a portfolio of securities and the return based on market expectations in a selected time period. It is a key performance measure on which a portfolio manager or an investment manager is gauged.read moreAccounting Period DefinitionAccounting Period DefinitionAccounting Period refers to the period in which all financial transactions are recorded and financial statements are prepared. This might be quarterly, semi-annually, or annually, depending on the period for which you want to create the financial statements to be presented to investors so that they can track and compare the company’s overall performance.read moreCalculate PVRate of Return FormulaRate Of Return FormulaRate of Return (ROR) refers to the expected return on investment (gain or loss) & it is expressed as a percentage. You can calculate this by, ROR = {(Current Investment Value – Original Investment Value)/Original Investment Value} * 100read moreCost-Benefit Analysis FormulaCost-Benefit Analysis FormulaThe cost-benefit analysis involves comparing the costs to the benefits of a project and then deciding whether to proceed with the project. First, the costs and benefits of the project are quantified in monetary terms after adjusting for the time value of money, which gives a real picture of the costs and benefits.read more