3
$\begingroup$

I'm trying to understand a difference I'm seeing between the return I calculate using adjusted close price and the total shareholder return with dividends reinvested (TSR) I get from Bloomberg / this online calculator.

Here's an example. I'm looking at Pfizer's return from 12/31/2009 to 12/29/2017.

  • The TSR I get from Bloomberg Terminal and the aforementioned online calculator is 168.0262%.
  • Using adj. close from Yahoo Finance, I calculate a return of 167.912% (35.887527 / 13.395256 - 1)

My thinking is that adj. close should be adjusted for dividends and splits so calculating return with adj. close should match total shareholder return with dividends reinvested. So why is there a 0.114 bp difference? I know it's small but I don't undertsand why it's there. Is it just a rounding error or is my understanding of the fundamentals incorrect?

Thanks!

$\endgroup$
  • $\begingroup$ Most likely it is a data error in Yahoo finance (their adjustments are not always right). Try varying the end date to see on what date the discrepancy between bbg/dqydj and Yahoo occurs, then investigate what happened on that day. $\endgroup$ – Alex C Apr 4 '18 at 17:49
  • $\begingroup$ Thanks Alex. I'll do this analysis later when I get the chance. From a theoretical perspective though, should return using adj. close match total shareholder return? Thanks! $\endgroup$ – Lakshay Akula Apr 4 '18 at 17:57
  • $\begingroup$ Generally they should give the same result. (But if they differ I trust bbg more). $\endgroup$ – Alex C Apr 4 '18 at 22:31
  • $\begingroup$ My answer shows that the "total return" price series is not a close match to the actual total shareholder return. $\endgroup$ – Norgate Data Apr 11 '18 at 9:36
  • $\begingroup$ @NorgateData is this "total return" price series you're referring to Bloomberg's TSR data? And how are you calculating actual total shareholder return? $\endgroup$ – Lakshay Akula Apr 30 '18 at 21:43
0
$\begingroup$

RETURN

Firstly, return is based upon the amount gained over a period of time. So your calculation for a percentage return should actually be be: (Sale price - Cost basis)/Cost Basis.

TOTAL RETURN

A "total return" price series or index is a transformation of the original traded price timeseries to a timeseries that can be used to estimate/calculate a total return.

DIVIDENDS

For dividends, you become entitled to them at the close on the day prior to the ex-date. i.e. you must be holding on the close of the day prior to the ex-date. This dividend is then assumed to be re-invested at this time. However, this is not actually possible (on an absolute cash basis) since the dividend is typically paid to you some weeks later - the payment schedule is determined by the company.

Taking a dividend from Pfizer as an example: A dividend of $0.32 was declared in Sep 2017, with ex-date 20171109, record date 20171110, payment date 20171201. This means you would need to be holding the stock at the close on 20171108 in order to receive the dividend and would receive the dividend about 3.5 weeks later.

WORKED EXAMPLE

Further to this, will this method of adjustment produce a correct return? Let's work your Pfizer example.

Looking at the actual raw underlying data: PFE closed at 18.19 on 20091231. PFE closed at 36.22 on 20171229

There were no other capital altering events (stock dividends, splits, reverse splits, spinoffs, rights issues etc.) during this period, so the capital return is 36.22 - 18.19 = 18.03

Over the years the total dividends received was $8.00. (four each of 0.18,0.20,0.22,0.24,0.26,0.28,0.30,0.32)

There are no dividends that span the start and start and end period dates.

Therefore your % total return = (18.03 + 8.00)/18.19 = 143.1006%

If we use the reinvest-dividends-on-day-prior-to-exdate "Total Return" methodology, this gives: (35.887527-13.3925581)/13.3925581 = 167.9122%

WHY THE DIFFERENCE?

Now you're seeing some rather big discrepancies between the return calculated by comparing two data points on the "Total Return" methodology and your actual total return. For long time periods of holding, with a reasonable dividend yield, the "Total Return" methodology has its limitations, as we have shown above.

CONCLUSION

For long periods of holding and/or with high dividend yield stocks, don't use the Total Return methodology. Calculate the capital return and total dividends received separately.

ALTERNATIVE METRICS COMMENTARY

Instead of a "8 year return" as we've calculated above, consider using annualized methodology such as Compound Annual Growth Rate. This will make it easier to compare returns where the holding period differs.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.