TSR Calculation – Best Practice

Written By: Deidre Salisbury

Section 1 – TSR Calculation Considerations

One of the benefits of using Relative Total Shareholder Return (“RTSR”) as a performance metric is the transparency of the calculation. It is based on empirical stock price data which is published daily from many different objective financial data sources. Nonetheless a wide variance of methodologies for calculating Total Shareholder Return (“TSR”) exist in the marketplace depending on your plan agreements.

Some of the potential decisions for the calculation are summarized below:

  • Treatments of dividends – Are they re-invested and when? Are they accumulated?
  • The use of an averaging period to smooth out day to day fluctuations in rankings
  • The potential use of volume weighted average prices (VWAP’s)
  • Foreign exchange rate considerations, if any global peers are selected

Infinite Equity believes it is critical that companies clearly define their methodology for calculating TSR and have it be explicitly written into their grant agreements. Due to the breadth and magnitude of plans that we administer and certify using MyPerformanceAwards, we have published our preferred methodology for calculating TSR. We have selected this methodology – not for simplicity – but as the most theoretically accurate approach that replicates the returns of an investor.   

Section 2 of this article provides a simplistic example of this calculation (without looking at VWAPs or currency rate exchanges). Section 3 provides the mathematical algorithms for calculations using this approach. Although we have published the mathematics here, note that any actual calculation or certification will be customized specific to your program, past practices, and legal grant agreement.

Section 2 – Empirical Example of TSR Calculation

The following example assumes that the TSR calculation uses a 20-trading day average with dividends to be re-invested on the ex-dividend date with the following dividend data. Note that the single share (1.0000) accumulates to 1.0853 shares during the performance period.

Ex-Dividend DateDividends PaidStock PriceShares PurchasedAccumulated Shares
1/28/2016$1.00$126.01.00791.0079
4/28/2016$1.00$146.07.00691.0148
7/28/2016$1.00$144.42.00701.0219
10/28/2016$1.00$144.00.00711.0290
1/30/2017$1.20$164.80.00751.0365
4/27/2017$1.20$166.55.00751.0439
7/28/2017$1.20$174.00.00721.0511
10/31/2017$1.20$186.94.00671.0579
1/31/2018$1.30$214.38.00641.0643
4/30/2018$1.30$193.73.00711.0714
7/31/2018$1.30$197.87.00701.0785
10/31/2018$1.30$205.28.00681.0853

The calculation of TSR of 64.6% can then be seen as follows:

Beginning of Performance PeriodEnd of Performance Period
Day #DatePriceSharesValueDatePriceSharesValue
112/31/2015$132.041.0000$132.0412/31/2018$204.181.0853$221.59
212/30/2015$133.261.0000$133.2612/28/2018$202.081.0853$219.32
312/29/2015$134.141.0000$134.1412/27/2018$200.121.0853$217.19
412/28/2015$133.121.0000$133.1212/26/2018$197.571.0853$214.42
512/24/2015$133.891.0000$133.8912/24/2018$187.761.0853$203.77
612/23/2015$134.151.0000$134.1512/21/2018$192.101.0853$208.48
712/22/2015$133.141.0000$133.1412/20/2018$193.581.0853$210.09
812/21/2015$131.191.0000$131.1912/19/2018$195.171.0853$211.82
912/18/2015$129.531.0000$129.5312/18/2018$196.521.0853$213.28
1012/17/2015$133.971.0000$133.9712/17/2018$197.921.0853$214.80
1112/16/2015$135.881.0000$135.8812/14/2018$200.001.0853$217.06
1212/15/2015$134.881.0000$134.8812/13/2018$202.421.0853$219.68
1312/14/2015$132.021.0000$132.0212/12/2018$202.481.0853$219.75
1412/11/2015$130.311.0000$130.3112/11/2018$202.281.0853$219.53
1512/10/2015$131.711.0000$131.7112/10/2018$203.261.0853$220.60
1612/9/2015$131.711.0000$131.7112/7/2018$204.881.0853$222.35
1712/8/2015$133.361.0000$133.3612/6/2018$207.961.0853$225.70
1812/7/2015$135.601.0000$135.6012/4/2018$210.121.0853$228.04
1912/4/2015$136.481.0000$136.4812/3/2018$220.811.0853$239.64
2012/3/2015$132.661.0000$132.6611/30/2018$218.241.0853$236.85
20-Trading Day Average$133.15$219.20
TSR with Dividends Reinvested64.6%

Section 3 – Mathematical Algorithms (Appendix – For those that just need to know)

Data Necessary

  • Stock Prices (S_{i}) – On any day i, this will be denoted by S_{i}.
  • Dividend Data (D_{i} ) – On any day i, this will be denoted by D_{i}.

Calculations Necessary

Let x represent the number of days in an x-day averaging period. (All calculations below should begin x-days prior to the beginning of the performance period, and therefore incorporate any dividends that may have been paid during the averaging period).

Total Shares (TS_{i}) – Represents the net number of shares owned (including new dividend shares) on any day i. It is calculated as TS_{i} = TS_{i-1} + NS_{i}.

New Shares (NS_{i}) – Represents the new number of shares purchased on day i from dividends. It is calculated as NS_{i} =\frac{D_{i}\times TS_{i-1}}{S_{i}}.

Total Value (TV_{i} ) – Represents the total value of the original share after reinvestment of dividends at any time i. It is calculated as TV_{i} = TS_{i} \times S_{i}.

Averaging Period (AP_{i}^{x} ) – Represents the average total value over an x-day averaging period. It is calculated as AP_{i}^{x}= \frac{\sum_{i-x}^{i}TV_{i}}{x} . (Note that at the beginning of the performance period, Time 0, this simplifies to AP_{0}^{x}= \frac{\sum_{0-x}^{0}TV_{0}}{x}.

Total Shareholder Return (TSR_{i}^{x}) – Represents the total shareholder return over an x-day averaging period on any day i. It is calculated as TSR_{i}^{x}=\frac{AP_{i}^{x}}{AP_{0}^{x}} - 1.

MyPerformanceAwards is a real-time solution for tracking performance equity plans and providing award holders clear insight into the current value of their outstanding awards. Please contact us if you’d like to learn more.


scott-graham-5fNmWej4tAA-unsplash

Unexpected Expense

Is Your Stock-Based Compensation Program about to Cause a Second Wave of Expense? The first quarter of 2020 was one of the worst quarters for...
GraphsOffice

The New AS 1210: Using the Work of a Specialist

The valuation and accounting for employee equity under ASC 718 can be quite material and has ramifications throughout your corporate financials. Some of the exhibits...
shutterstock_dividends-scaled

TSR Calculation: Accumulated Dividends

Infinite Equity laid out the preferred method for calculating Total Shareholder Return (TSR) here. However, the calculation of TSR ultimately must follow the definition outlined...