This report is for educational purposes only, and not to provide investment advice. Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q3 2017
Canadian Pacific Railway TSX: CP NYSE: CP www.cpr.ca Fiscal Yr: Dec 31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G
Accounting Rules US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP Accounting Rules
CPR shares %
CPR Split
$6,478 <-12 mths 3.95%
Revenue* $4,320 $4,583 $4,708 $4,932 $4,303 $4,982 $5,177 $5,695 $6,133 $6,620 $6,712 $6,232 $6,531 $6,823 $7,189 35.97% <-Total Growth 10 Revenue
Increase 10.68% 6.10% 2.71% 4.76% -12.74% 15.76% 3.92% 10.01% 7.69% 7.94% 1.39% -7.15% 4.80% 4.47% 5.36% 3.12% <-IRR #YR-> 10 Revenue 35.97%
5 year Running Average $3,849 $4,026 $4,235 $4,489 $4,569 $4,701 $4,820 $5,018 $5,258 $5,721 $6,067 $6,278 $6,446 $6,584 $6,697 3.78% <-IRR #YR-> 5 Revenue 20.38%
Revenue per Share $27.30 $29.47 $30.71 $32.07 $25.54 $29.44 $30.45 $32.75 $34.97 $39.86 $43.87 $42.60 $45.04 $47.06 $49.58 4.54% <-IRR #YR-> 10 5 yr Running Average 55.93%
Increase 11.10% 7.94% 4.19% 4.42% -20.35% 15.28% 3.44% 7.54% 6.77% 13.98% 10.07% -2.90% 5.74% 4.47% 5.36% 5.43% <-IRR #YR-> 5 5 yr Running Average 30.25%
5 year Running Average $24.29 $25.51 $27.03 $28.83 $29.02 $29.45 $29.64 $30.05 $30.63 $33.49 $36.38 $38.81 $41.27 $43.68 $45.63 3.75% <-IRR #YR-> 10 Revenue per Share 44.53%
P/S (Price/Sales) Med 1.66 1.82 2.42 1.73 1.77 1.99 1.89 2.60 3.87 5.00 4.70 4.19 6.94% <-IRR #YR-> 5 Revenue per Share 39.88%
P/S (Price/Sales) Close 1.78 2.08 2.09 1.28 2.22 2.20 2.27 3.08 4.59 5.61 4.03 4.50 4.98 4.76 4.52 4.28% <-IRR #YR-> 10 5 yr Running Average 52.13%
*Revenue in M CDN $ P/S 10 yr 2.67 5 yr 4.50 86.15% Diff M/C 5.54% <-IRR #YR-> 5 5 yr Running Average 30.92%
-$4,583 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,232
-$5,177 $0 $0 $0 $0 $6,232
-$4,026 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,278
-$4,820 $0 $0 $0 $0 $6,278
-$29.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.60
-$30.45 $0.00 $0.00 $0.00 $0.00 $42.60
-$25.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38.81
-$29.64 $0.00 $0.00 $0.00 $0.00 $38.81
$12.31 <-12 mths 15.80%
EPS Basic $3.43 $5.06 $6.14 $4.03 $3.68 $3.86 $3.37 $2.82 $5.00 $8.54 $8.47 $10.69 111.26% <-Total Growth 10 EPS Basic
EPS Diluted* $3.39 $5.02 $6.08 $3.98 $3.67 $3.85 $3.34 $2.79 $4.96 $8.46 $8.40 $10.63 $12.50 $12.80 $14.20 111.75% <-Total Growth 10 EPS Diluted
Increase 30.38% 48.08% 21.12% -34.54% -7.79% 4.90% -13.25% -16.47% 77.78% 70.56% -0.71% 26.55% 17.59% 2.40% 10.94% 7.79% <-IRR #YR-> 10 Earnings per Share 111.75%
Earnings Yield 7.0% 8.2% 9.5% 9.7% 6.5% 5.9% 4.8% 2.8% 3.1% 3.8% 4.8% 5.5% 5.6% 5.7% 6.3% 26.05% <-IRR #YR-> 5 Earnings per Share 218.26%
5 year Running Average $2.79 $3.33 $3.92 $4.21 $4.43 $4.52 $4.18 $3.53 $3.72 $4.68 $5.59 $7.05 $8.99 $10.56 $11.71 7.79% <-IRR #YR-> 10 5 yr Running Average 111.78%
10 year Running Average $3.08 $3.42 $3.66 $3.76 $3.72 $3.97 $4.55 $5.06 $5.62 $6.26 $7.14 $8.19 10.99% <-IRR #YR-> 5 5 yr Running Average 68.45%
* ESP per share (Cdn GAAP) E/P 10 Yrs 5.19% 5Yrs 3.78%
-$5.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.63
-$3.34 $0.00 $0.00 $0.00 $0.00 $10.63
-$3.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.05
-$4.18 $0.00 $0.00 $0.00 $0.00 $7.05
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Dividend* $0.58 $0.75 $0.90 $0.99 $0.99 $1.04 $1.14 $1.30 $1.40 $1.40 $1.40 $1.70 $2.13 $2.25 $2.25 126.67% <-Total Growth 10 Dividends
Increase 12.02% 28.76% 20.00% 10.00% 0.00% 4.55% 10.14% 14.04% 7.69% 0.00% 0.00% 21.43% 25.00% 5.88% 0.00% Count 15 Years of data
Dividends 5 Yr Running $0.57 $0.65 $0.75 $0.84 $0.93 $1.01 $1.09 $1.17 $1.26 $1.33 $1.44 $1.61 $1.78 $1.95 150.65% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.28% 1.40% 1.21% 1.78% 2.19% 1.77% 1.98% 1.53% 1.03% 0.70% 0.68% 0.95% 1.02% 1.37% <-Median-> 10 Yield H/L Price
Yield on High Price 1.12% 1.18% 1.01% 1.33% 1.72% 1.55% 1.65% 1.29% 0.84% 0.58% 0.58% 0.82% 0.95% 1.15% <-Median-> 10 Yield on High Price
Yield on Low Price 1.50% 1.73% 1.51% 2.71% 3.00% 2.06% 2.47% 1.88% 1.34% 0.89% 0.83% 1.13% 1.11% 1.69% <-Median-> 10 Yield on Low Price
Yield on Close Price 1.20% 1.22% 1.40% 2.42% 1.74% 1.60% 1.65% 1.29% 0.87% 0.63% 0.79% 0.89% 0.95% 1.00% 1.00% 1.34% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 17.18% 14.94% 14.80% 24.87% 26.98% 26.88% 34.13% 46.59% 28.23% 16.55% 16.67% 15.99% 17.00% 17.58% 15.85% 25.88% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 17.26% 16.64% 17.76% 19.03% 20.64% 24.16% 30.94% 31.52% 26.82% 23.76% 20.43% 17.85% 16.81% 16.62% 22.20% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 8.77% 11.10% 10.50% 14.11% 30.25% 34.88% 37.85% 17.02% 12.59% 10.95% 8.71% 11.91% 13.45% 11.84% 10.66% 13.35% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 11.39% 11.31% 11.03% 13.06% 16.32% 20.35% 22.82% 20.94% 16.73% 13.12% 11.63% 11.46% 11.39% 11.28% 14.72% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 7.91% 9.29% 10.95% 12.21% 35.15% 31.81% 32.30% 15.95% 12.26% 10.41% 9.81% 11.60% 13.45% 11.84% 10.66% 12.24% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 10.22% 10.40% 10.06% 12.18% 15.31% 19.50% 21.10% 20.11% 15.77% 13.07% 11.62% 11.53% 11.50% 11.46% 14.19% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 0.95% 0.87% 5 Yr Med Payout 16.67% 11.91% 11.60% 8.53% <-IRR #YR-> 10 Dividends 126.67%
* Dividends per share 5 Yr Med and Cur. 5.31% 15.18% Last Div Inc ---> $0.35 $0.50 42.9% 8.32% <-IRR #YR-> 5 Dividends 49.12%
11.90% <-IRR #YR-> 5 Dividends To date
-$0.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.70
-$1.14 $0.00 $0.00 $0.00 $0.00 $1.70
-$1.30 $0.00 $0.00 $0.00 $0.00 $2.13
Historical Dividends Historical High Div 2.83% Low Div 0.58% Ave Div 1.71% Med Div 1.47% Close Div 1.29% Historical Dividends
High/Ave/Median Values Curr diff Exp. -64.53% 73.06% Exp. -41.13% Exp. -31.72% Exp. -22.09% High/Ave/Median
Future Dividend Yield Div Yd 1.56% earning in 5 Years at IRR of 9.2% Div Inc. 54.99% Future Dividend Yield
Future Dividend Yield Div Yd 2.41% earning in 10 Years at IRR of 9.2% Div Inc. 140.23% Future Dividend Yield
Future Dividend Yield Div Yd 3.74% earning in 15 Years at IRR of 9.2% Div Inc. 272.35% Future Dividend Yield
Yield if held 5 years 3.53% 2.71% 2.77% 2.97% 2.79% 2.28% 2.13% 1.75% 2.52% 3.10% 2.39% 2.95% 2.50% 1.66% 1.13% 2.65% <-Median-> 10 Paid Median Price
Yield if held 10 years 5.25% 4.80% 4.76% 5.47% 6.12% 6.27% 4.11% 4.01% 4.20% 3.95% 3.09% 3.17% 2.86% 4.06% 4.98% 4.16% <-Median-> 10 Paid Median Price
Yield if held 15 years 9.00% 9.33% 7.30% 6.87% 7.73% 8.66% 8.48% 6.13% 6.55% 6.75% 6.35% 8.11% <-Median-> 8 Paid Median Price
Yield if held 20 years 12.73% 12.62% 10.88% 11.24% 12.42% 13.91% 12.62% <-Median-> 3 Paid Median Price
Yield if held 25 years 20.45% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 12.86% 10.36% 10.05% 11.23% 11.88% 10.29% 9.43% 7.33% 10.57% 13.88% 11.34% 12.50% 9.44% 6.56% 4.88% 10.90% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 19.13% 18.38% 19.95% 26.29% 35.56% 41.14% 28.59% 26.86% 28.84% 29.58% 24.93% 22.86% 18.12% 26.57% 35.38% 27.73% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 52.30% 61.18% 50.74% 48.79% 58.67% 74.36% 81.38% 54.56% 51.59% 55.48% 57.01% 56.62% <-Median-> 8 Paid Median Price
Cost covered if held 20 years 109.34% 121.02% 96.82% 91.22% 107.67% 134.48% 109.34% <-Median-> 3 Paid Median Price
Cost covered if held 25 years 197.75% #NUM! <-Median-> 0 Paid Median Price
Graham No. $45.98 $59.39 $69.79 $59.07 $57.33 $49.70 $45.33 $42.89 $67.20 $80.18 $76.97 $86.96 $103.90 $105.13 $110.73 67.39% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.99 0.90 1.07 0.94 0.79 1.18 1.27 1.98 2.01 2.49 2.68 2.05 2.00 1.63 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.13 1.07 1.28 1.26 1.00 1.35 1.52 2.35 2.48 3.01 3.16 2.38 2.16 1.94 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.85 0.73 0.86 0.62 0.58 1.01 1.02 1.61 1.55 1.96 2.20 1.72 1.84 1.28 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.06 1.03 0.92 0.69 0.99 1.30 1.52 2.35 2.39 2.79 2.30 2.20 2.16 2.13 2.02 1.86 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 5.93% 3.38% -7.98% -30.63% -0.94% 30.20% 52.23% 135.23% 139.07% 179.06% 129.61% 120.28% 115.76% 113.21% 102.43% 41.21% <-Median-> 10 Graham Price
CPL price
CPR price
Price Close $48.71 $61.40 $64.22 $40.98 $56.79 $64.71 $69.01 $100.90 $160.65 $223.75 $176.73 $191.56 $224.16 $224.16 $224.16 211.99% <-Total Growth 10 Stock Price
Increase 19.39% 26.05% 4.59% -36.19% 38.58% 13.95% 6.65% 46.21% 59.22% 39.28% -21.01% 8.39% 17.02% 0.00% 0.00% 12.05% <-IRR #YR-> 10 Stock Price 211.99%
P/E 14.37 12.23 10.56 10.30 15.47 16.81 20.66 36.16 32.39 26.45 21.04 18.02 17.93 17.51 15.79 43.30% <-IRR #YR-> 5 Stock Price 177.58%
Trailing P/E 18.73 18.11 12.79 6.74 14.27 17.63 17.92 30.21 57.58 45.11 20.89 22.80 21.09 17.93 17.51 13.24% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 1.19% 2.45% % Tot Ret 8.99% 5.35% T P/E 30.21 P/E: 19.34 26.45 45.75% <-IRR #YR-> 5 Price & Dividend
-$61.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $191.56
-$31.70 $0.00 $0.00 $0.00 $0.00 $191.56
-$61.40 $0.90 $0.99 $0.99 $1.04 $1.14 $1.30 $1.40 $1.40 $1.40 $193.26
-$31.70 $1.30 $1.40 $1.40 $1.40 $193.26
Price H/L Median $45.36 $53.62 $74.39 $55.48 $45.22 $58.58 $57.62 $85.03 $135.33 $199.28 $205.99 $178.36 $207.54 232.66% <-Total Growth 10 Stock Price
Increase 27.92% 18.21% 38.74% -25.42% -18.49% 29.53% -1.64% 47.58% 59.16% 47.25% 3.37% -13.41% 16.36% 12.77% <-IRR #YR-> 10 Stock Price 232.66%
P/E 13.38 10.68 12.23 13.94 12.32 15.21 17.25 30.48 27.28 23.55 24.52 16.78 16.60 41.27% <-IRR #YR-> 5 Stock Price 209.56%
Trailing P/E 17.44 15.82 14.82 9.13 11.36 15.96 14.96 25.46 48.51 40.18 24.35 21.23 19.52 14.10% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 16.24 16.11 18.97 13.17 10.21 12.96 13.77 24.12 36.36 42.58 36.85 25.31 23.09 43.76% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 18.04 13.21 16.02 15.34 22.83 34.11 43.76 40.75 31.76 33.16 13.79 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.33% 2.50% % Tot Ret 9.43% 5.70% T P/E 25.46 P/E: 17.01 24.52 Count 23 Years of data
-$53.62 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $178.36
-$31.70 $0.00 $0.00 $0.00 $0.00 $178.36
-$53.62 $0.90 $0.99 $0.99 $1.04 $1.14 $1.30 $1.40 $1.40 $1.40 $180.06
-$31.70 $1.30 $1.40 $1.40 $1.40 $180.06
CP price
CPR price
High Months Oct Apr-Dec Jul May Dec Oct Dec Dec Dec Oct Mar Dec Oct
Price High $51.83 $63.81 $89.00 $74.48 $57.45 $66.86 $69.01 $100.98 $166.56 $241.67 $242.89 $206.87 $224.16 224.20% <-Total Growth 10 Stock Price
Increase 24.74% 23.11% 39.48% -16.31% -22.87% 16.38% 3.22% 46.33% 64.94% 45.09% 0.50% -14.83% 8.36% 12.48% <-IRR #YR-> 10 Stock Price 224.20%
P/E 15.29 12.71 14.64 18.71 15.65 17.37 20.66 36.19 33.58 28.57 28.92 19.46 17.93 24.55% <-IRR #YR-> 5 Stock Price 199.77%
Trailing P/E 19.93 18.82 17.73 12.25 14.43 18.22 17.92 30.23 59.70 48.72 28.71 24.63 21.09 16.67 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 45.09% P/E: 20.06 28.92 29.85 P/E Ratio Historical High
-$63.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $206.87
-$69.01 $0.00 $0.00 $0.00 $0.00 $206.87
CP price
CPR price
Low Mths Jan Jan Dec Nov Mar Feb Sep Jan Jan Jan Dec Jan Aug
Price Low $38.88 $43.42 $59.77 $36.48 $32.99 $50.29 $46.22 $69.08 $104.10 $156.88 $169.08 $149.84 $190.92 245.09% <-Total Growth 10 Stock Price
Increase 32.43% 11.68% 37.66% -38.97% -9.57% 52.44% -8.09% 49.46% 50.69% 50.70% 7.78% -11.38% 27.42% 13.19% <-IRR #YR-> 10 Stock Price 245.09%
P/E 11.47 8.65 9.83 9.17 8.99 13.06 13.84 24.76 20.99 18.54 20.13 14.10 15.27 26.52% <-IRR #YR-> 5 Stock Price 224.19%
Trailing P/E 14.95 12.81 11.91 6.00 8.29 13.70 12.01 20.68 37.31 31.63 19.99 17.84 17.96 11.38 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 49.46% P/E: 13.97 20.13 8.96 P/E Ratio Historical Low
-$43.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $149.84
Long Term Debt $5,759 $8,957 $8,684 $8,133 Debt
Change 55.53% -3.05% -6.35% 26.24% <-Median-> 2 Change
Debt/Market Cap Ratio 0.15 0.33 0.31 0.25 0.31 <-Median-> 3 % of Market C.
Goodwill & Intangibles $161.0 $162.0 $176 $211 $202 $187 Intangibles Goodwill
Change 0.62% 8.64% 19.89% -4.27% -7.43% 4.63% <-Median-> 4 Change
Intangible/Market Cap Ratio 0.01 0.01 0.00 0.01 0.01 0.01 0.01 <-Median-> 5 % of Market C.
Market Cap $7,706 $9,548 $9,845 $6,303 $9,569 $10,949 $11,732 $17,547 $28,178 $37,165 $27,040 $28,025 $32,503 $32,503 $32,503 193.53% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 160.1 158.8 155.6 155.5 166.8 169.8 170.6 173.2 176.5 174.4 191.0 150.5 146.6 -5.23% <-Total Growth 10 Diluted
Change 0.63% -0.81% -2.02% -0.06% 7.27% 1.80% 0.47% 1.52% 1.91% -1.19% 9.52% -21.20% -2.59% 1.00% <-Median-> 10 Change
Basic # of Shares in Millions 158.4 157.3 154.0 153.7 166.3 168.8 169.5 171.8 174.9 172.8 159.7 149.6 146.2 -4.90% <-Total Growth 10 Average
Change -0.19% -0.69% -2.10% -0.19% 8.20% 1.50% 0.41% 1.36% 1.80% -1.20% -7.58% -6.32% -2.27% 0.11% <-Median-> 10 Change
Difference -0.1% -1.1% -0.5% 0.1% 1.3% 0.2% 0.3% 1.2% 0.3% -3.9% -4.2% -2.2% -0.8% 0.15% <-Median-> 10 Difference
$2,217 <-12 mths 6.13%
# of Share in Millions 158.2 155.5 153.3 153.8 168.5 169.2 170.0 173.9 175.4 166.1 153.0 146.3 145.0 145.0 145.0 -0.61% <-IRR #YR-> 10 Shares -5.92%
Change -0.38% -1.71% -1.41% 0.33% 9.56% 0.42% 0.47% 2.29% 0.86% -5.30% -7.89% -4.38% -0.89% 0.00% 0.00% -2.96% <-IRR #YR-> 5 Shares -13.94%
CF fr Op $M $1,051 $1,051 $1,315 $1,079 $552 $502 $512 $1,328 $1,950 $2,123 $2,459 $2,089 $2,291 $2,755 $3,060 98.76% <-Total Growth 10 Cash Flow
Increase 33.68% 0.03% 25.08% -17.91% -48.89% -8.96% 1.97% 159.38% 46.84% 8.87% 15.83% -15.05% 9.67% 20.25% 11.05% SO S. Issue Buy Backs
5 year Running Average $737 $796 $902 $1,056 $1,009 $900 $792 $795 $969 $1,283 $1,674 $1,990 $2,182 $2,343 $2,531 150.13% <-Total Growth 10 CF 5 Yr Running
CFPS $6.64 $6.76 $8.58 $7.02 $3.27 $2.97 $3.01 $7.64 $11.12 $12.78 $16.07 $14.28 $15.80 $19.00 $21.10 111.26% <-Total Growth 10 Cash Flow per Share
Increase 34.18% 1.77% 26.88% -18.18% -53.35% -9.33% 1.49% 153.56% 45.58% 14.97% 25.74% -11.16% 10.65% 20.25% $19.60 7.11% <-IRR #YR-> 10 Cash Flow 98.76%
5 year Running Average $4.65 $5.04 $5.77 $6.79 $6.45 $5.72 $4.97 $4.78 $5.60 $7.50 $10.12 $12.38 $14.01 $15.59 $17.25 32.47% <-IRR #YR-> 5 Cash Flow 308.01%
P/CF on Med Price 6.83 7.93 8.67 7.91 13.82 19.74 19.13 11.13 12.17 15.59 12.82 12.49 13.14 12.12% Diff M/C 7.77% <-IRR #YR-> 10 Cash Flow per Share 111.26%
P/CF on Closing Price 7.33 9.08 7.49 5.84 17.35 21.81 22.91 13.21 14.45 17.51 11.00 13.42 14.19 11.80 10.62 36.51% <-IRR #YR-> 5 Cash Flow per Share 374.10%
$2,222 <-12 mths 3.64% 9.39% <-IRR #YR-> 10 CFPS 5 yr Running 145.35%
Excl.Working Capital CF $115 $205 -$55 $168 -$77 $49 $88 $89 $53 $110 -$275 $55 $0 $0 $0 20.03% <-IRR #YR-> 5 CFPS 5 yr Running 149.10%
CF fr Op $M WC $1,165.2 $1,256.0 $1,259.7 $1,246.7 $474.6 $550.6 $600.0 $1,417.0 $2,003.0 $2,233.0 $2,184.0 $2,144.0 $2,291.0 $2,755.0 $3,059.5 70.70% <-Total Growth 10 Cash Flow less WC
Increase 34.71% 7.79% 0.29% -1.03% -61.93% 16.01% 8.97% 136.17% 41.35% 11.48% -2.19% -1.83% 6.86% 20.25% 11.05% 5.49% <-IRR #YR-> 10 Cash Flow less WC 70.70%
5 year Running Average $786 $886 $981 $1,159 $1,080 $958 $826 $858 $1,009 $1,361 $1,687 $1,996 $2,171 $2,321 $2,487 29.01% <-IRR #YR-> 5 Cash Flow less WC 257.33%
CFPS Excl. WC $7.37 $8.08 $8.22 $8.11 $2.82 $3.25 $3.53 $8.15 $11.42 $13.44 $14.27 $14.65 $15.80 $19.00 $21.10 8.46% <-IRR #YR-> 10 CF less WC 5 Yr Run 125.32%
Increase 35.22% 9.66% 1.73% -1.35% -65.25% 15.53% 8.46% 130.87% 40.15% 17.72% 6.18% 2.66% 7.81% 20.25% 11.05% 19.29% <-IRR #YR-> 5 CF less WC 5 Yr Run 141.58%
5 year Running Average $4.96 $5.62 $6.27 $7.44 $6.92 $6.09 $5.18 $5.17 $5.83 $7.96 $10.16 $12.39 $13.92 $15.43 $16.97 6.14% <-IRR #YR-> 10 CFPS - Less WC 81.44%
P/CF on Med Price 6.16 6.64 9.05 6.84 16.05 18.00 16.32 10.44 11.85 14.82 14.43 12.17 13.14 32.94% <-IRR #YR-> 5 CFPS - Less WC 315.22%
P/CF on Closing Price 6.61 7.60 7.82 5.06 20.16 19.89 19.55 12.38 14.07 16.64 12.38 13.07 14.19 11.80 10.62 8.22% <-IRR #YR-> 10 CFPS 5 yr Running 120.42%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 12.65 5 yr 12.49 P/CF Med 10 yr 13.30 5 yr 12.17 6.67% Diff M/C 19.03% <-IRR #YR-> 5 CFPS 5 yr Running 138.94%
-$6.76 $0 $0 $0 $0 $0 $0 $0 $0 $0 $14 Cash Flow per Share
-$3.01 $0.00 $0.00 $0.00 $0.00 $14.28 Cash Flow per Share
-$5.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.38 CFPS 5 yr Running
-$4.97 $0.00 $0.00 $0.00 $0.00 $12.38 CFPS 5 yr Running
-$1,256 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,144 Cash Flow less WC
-$600 $0 $0 $0 $0 $2,144 Cash Flow less WC
-$885.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,996.2 CF less WC 5 Yr Run
-$826.3 $0.0 $0.0 $0.0 $0.0 $1,996.2 CF less WC 5 Yr Run
-$8.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.65 CFPS - Less WC
-$3.53 $0.00 $0.00 $0.00 $0.00 $14.65 CFPS - Less WC
-$5.62 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.39 CFPS 5 yr Running
-$5.18 $0.00 $0.00 $0.00 $0.00 $12.39 CFPS 5 yr Running
Change in non-cash working -$23.3 -$101.6 $50.3 -$132.2 $102.7 -$16.3 $24.0 -$5.0 -$2.0 -$124.0 $275.0
Accounts Receivable $44.0
Materials and supplies $14.0
Other current assets -$18.0
Accounts Payable and Accrued Liab -$95.0
Other operating activities, net -$91.2 -$103.4 $4.6 -$35.4 -$25.8 -$32.2 -$112.0 -$84.0 -$51.0 $14.0 old Labour restructuring & this
                        now one Item. Old -17, 14 for this items, now -3
Sum -$114.5 -$205.0 $54.9 -$167.6 $76.9 -$48.5 -$88.0 -$89.0 -$53.0 -$110.0 $275.0 -$55.0
Google -$89.0 -$53.0 -$110.0 $275.0 -$55.0
Net $0.0 $0.0 $0.0 $0.0 $0.0
OPM 24.32% 22.93% 27.93% 21.88% 12.82% 10.08% 9.89% 23.32% 31.80% 32.07% 36.64% 33.52% 46.18% <-Total Growth 10 OPM
Increase 20.78% -5.72% 21.78% -21.64% -41.43% -21.35% -1.88% 135.78% 36.35% 0.86% 14.24% -8.50% Should increase or be stable.
Diff from Median -5.1% -10.5% 9.0% -14.6% -50.0% -60.7% -61.4% -9.0% 24.1% 25.2% 43.0% 30.8% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 25.62% 5 Yrs 32.07% should be zero, it is a check on calculations
Current Assets $893.9 $1,004.9 $1,167.7 $1,123.0 $1,427.4 $1,203.8 $856.0 $1,329 $2,029 $1,277 $1,537 $1,009 $992 Liquidity ratio of 1.5 and up, best
Current Liabilities $1,116.7 $1,239.0 $1,334.8 $1,309.3 $1,383.0 $1,289.5 $1,210.0 $1,230 $1,378 $1,411 $1,447 $1,347 $1,888 0.92 <-Median-> 10 Ratio
Liquidity 0.80 0.81 0.87 0.86 1.03 0.93 0.71 1.08 1.47 0.91 1.06 0.75 0.53 1.06 <-Median-> 5 Ratio
Liq. with CF aft div 1.66 1.57 1.76 1.57 1.31 1.19 0.97 1.98 2.71 2.24 2.61 2.12 1.58 2.24 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.92 0.91 0.61 0.95 0.98 0.80 0.52 1.08 1.25 1.47 1.47 1.18 1.58 1.25 <-Median-> 5 Ratio
Port. Lg Term Dt 605.30 281.70 281.70 54.00 189.00 134.00 30.00 25.00 749.00
Liquidity Less CLTD 1.84 1.19 0.92 1.13 1.71 1.00 1.08 0.76 0.87 1.08 <-Median-> 5 Ratio
Liq. with CF aft div 2.33 1.52 1.26 2.07 3.14 2.48 2.67 2.16 2.61 2.48 <-Median-> 5 Ratio
Assets $10,891 $11,416 $13,365 $15,470 $15,531 $13,676 $14,110 $14,727 $17,060 $16,640 $19,637 $19,221 $19,479 Debt Ratio of 1.5 and up, best
Liabilities $6,505 $6,559 $7,907 $9,476 $8,825 $8,851 $9,461 $9,630 $9,963 $11,030 $14,841 $14,595 $13,914 1.54 <-Median-> 10 Ratio
Debt Ratio 1.67 1.74 1.69 1.63 1.76 1.55 1.49 1.53 1.71 1.51 1.32 1.32 1.40 1.51 <-Median-> 5 Ratio
* see bel.
Book Value $4,386 $4,857 $5,458 $5,993 $6,706 $4,825 $4,649 $5,097 $7,097 $5,610 $4,796 $4,626 $5,565 $5,565 $5,565 -4.75% <-Total Growth 10 Book Value
Book Value per Share $27.72 $31.23 $35.60 $38.97 $39.80 $28.51 $27.35 $29.31 $40.46 $33.77 $31.35 $31.62 $38.38 $38.38 $38.38 1.24% <-Total Growth 10 Book Value per Share
Change 10.54% 12.66% 14.00% 9.45% 2.13% -28.35% -4.10% 7.18% 38.05% -16.53% -7.19% 0.87% 21.38% 0.00% 0.00% 133.26% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.64 1.72 2.09 1.42 1.14 2.05 2.11 2.90 3.34 5.90 6.57 5.64 5.41 1.58 P/B Ratio Historical Median
P/B Ratio (Close) 1.76 1.97 1.80 1.05 1.43 2.27 2.52 3.44 3.97 6.62 5.64 6.06 5.84 5.84 5.84 0.12% <-IRR #YR-> 10 Book Value per Share 1.24%
Change 8.00% 11.89% -8.25% -41.70% 35.69% 59.04% 11.20% 36.42% 15.33% 66.85% -14.90% 7.45% -3.59% 0.00% 0.00% 2.95% <-IRR #YR-> 5 Book Value per Share 15.62%
Leverage (A/BK) 2.48 2.35 2.45 2.58 2.32 2.83 3.04 2.89 2.40 2.97 4.09 4.15 3.50 2.86 <-Median-> 10 A/BV
Debt/Equity Ratio 1.48 1.35 1.45 1.58 1.32 1.83 2.04 1.89 1.40 1.97 3.09 3.15 2.50 1.86 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.50 5 yr Med 5.64 133.26% Diff M/C 2.61 Historical Leverage (A/BK)
-$31.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.62
-$27.35 $0.00 $0.00 $0.00 $0.00 $31.62
$1,523 <-12 mths 19.26%
Comprehensive Income $795.20 $905.40 $657.70 $584.20 $309.60 -$80.00 $452 $2,140 $760 $2,094 $1,277 60.59% <-Total Growth 10 Comprehensive Income
Increase 13.86% -27.36% -11.18% -47.00% -125.84% 665.00% 373.45% -64.49% 175.53% -39.02% 175.53% <-Median-> 5 Comprehensive Income
5 Yr Running Average $650 $475 $385 $681 $716 $1,073 $1,345 4.85% <-IRR #YR-> 10 Comprehensive Income 60.59%
ROE 16.4% 16.6% 11.0% 8.7% 6.4% -1.7% 8.9% 30.2% 13.5% 43.7% 27.6% #NUM! <-IRR #YR-> 5 Comprehensive Income 1696.25%
5Yr Median 11.0% 8.7% 8.7% 8.7% 8.9% 13.5% 27.6% 12.87% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI -0.1% -4.3% 6.3% -4.6% -52.4% -114.0% -6.6% 144.6% -48.5% 54.9% -20.1% 23.11% <-IRR #YR-> 5 5 Yr Running Average 182.85%
Median Values Diff 5, 10 yr 8.9% 8.9% 27.6% <-Median-> 5 Return on Equity
-$795.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,277.0
$80.0 $0.0 $0.0 $0.0 $0.0 $1,277.0
-$650.4 $0.0 $0.0 $0.0 $0.0 $0.0 $1,344.6
-$475.4 $0.0 $0.0 $0.0 $0.0 $1,344.6
Current Liability Coverage Ratio 1.04 1.01 0.94 0.95 0.34 0.43 0.50 1.15 1.45 1.58 1.51 1.59 1.21 CFO / Current Liabilities
5 year Median 0.65 0.67 0.94 0.95 0.95 0.94 0.50 0.50 0.50 1.15 1.45 1.51 1.51 1.51 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 10.70% 11.00% 9.43% 8.06% 3.06% 4.03% 4.25% 9.62% 11.74% 13.42% 11.12% 11.15% 11.76% CFO / Total Assets
5 year Median 8.12% 8.24% 9.43% 9.43% 9.43% 8.06% 4.25% 4.25% 4.25% 9.62% 11.12% 11.15% 11.74% 11.2% <-Median-> 5 Return on Assets
Return on Assets 5.0% 7.0% 7.1% 4.0% 3.9% 4.8% 4.0% 3.3% 5.1% 8.9% 6.9% 8.3% 9.4% Net Income/Assets Return on Assets
5Yr Median 4.0% 5.0% 5.0% 5.0% 5.0% 4.8% 4.0% 4.0% 4.0% 4.8% 5.1% 6.9% 8.3% 6.9% <-Median-> 5 Asset Efficiency Ratio
ROE 12.4% 16.4% 17.3% 10.3% 9.1% 13.5% 12.3% 9.5% 12.3% 26.3% 28.2% 34.6% 32.8% Net Inc/ Shareholders' equity Return on Equity
5Yr Running Ave 12.5% 13.1% 13.9% 13.4% 12.8% 13.0% 12.3% 10.8% 11.3% 14.9% 17.5% 21.3% 25.7% 26.3% <-Median-> 5 Return on Equity
$1,805 <-12 mths 12.88%
Net Income $542.9 $796.30 $946.20 $619.00 $612.4 $650.7 $570 $484 $875 $1,476 $1,352 $1,599 $1,823 $1,806 $1,953 100.80% <-Total Growth 10 Net Income
Increase 31.45% 46.68% 18.82% -34.58% -1.07% 6.25% -12.40% -15.09% 80.79% 68.69% -8.40% 18.27% 14.01% -0.93% 8.14% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $445 $530 $620 $663 $703 $725 $680 $587 $638 $811 $951 $1,157 $1,425 $1,611 $1,707 7.22% <-IRR #YR-> 10 Net Income 100.80%
Operating Cash Flow $1,050.7 $1,051.0 $1,314.6 $1,079.1 $551.5 $502.1 $512 $1,328 $1,950 $2,123 $2,459 $2,089 22.91% <-IRR #YR-> 5 Net Income 180.53%
Investment Cash Flow -$896.2 -$896.2 -$2,514.3 -$856.1 -$458.7 -$635.6 -$1,044 -$1,011 -$1,597 -$750 -$1,123 -$1,069 8.12% <-IRR #YR-> 10 5 Yr Running Ave. 118.38%
Total Accruals $388.4 $641.5 $2,145.9 $396.0 $519.6 $784.2 $1,102 $167 $522 $103 $16 $579 11.23% <-IRR #YR-> 5 5 Yr Running Ave. 70.26%
Total Assets $10,891 $11,416 $13,365 $15,470 $15,531 $13,676 $14,110 $14,727 $17,060 $16,640 $19,637 $19,221 Balance Sheet Assets
Accruals Ratio 3.57% 5.62% 16.06% 2.56% 3.35% 5.73% 7.81% 1.13% 3.06% 0.62% 0.08% 3.01% 1.13% <-Median-> 5 Ratio
EPS/CF Ratio 0.46 0.62 0.74 0.49 1.30 1.18 0.95 0.34 0.43 0.63 0.59 0.73 0.68 <-Median-> 10 EPS/CF Ratio
-$796.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,599.0
-$570.0 $0.0 $0.0 $0.0 $0.0 $1,599.0
-$529.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,157.2
-$679.7 $0.0 $0.0 $0.0 $0.0 $1,157.2
Change in Close 19.39% 26.05% 4.59% -36.19% 38.58% 13.95% 6.65% 46.21% 59.22% 39.28% -21.01% 8.39% 17.02% 0.00% 0.00% Count 23 Years of data
up/down down down down down Count 8 34.78%
Meet Prediction? % right Count 1 12.50%
Financial Cash Flow -$412.7 -$354.8 $1,453.5 -$511.5 $448.7 -$167.8 $217 -$30 -$220 -$1,630 -$957 -$1,493 C F Statement Financial Cash Flow
Total Accruals $801.1 $996.3 $692.4 $907.5 $70.9 $952.0 $885 $197 $742 $1,733 $973 $2,072 Accruals
Accruals Ratio 7.36% 8.73% 5.18% 5.87% 0.46% 6.96% 6.27% 1.34% 4.35% 10.41% 4.95% 10.78% 4.95% <-Median-> 5 Ratio
Cash $124.3 $378.1 $117.6 $679.1 $360.6 $47 $333 $476 $226 $650 $164 $142 Cash
Cash per Share $0.80 $2.47 $0.76 $4.03 $2.13 $0.28 $1.91 $2.71 $1.36 $4.25 $1.12 $0.98 $1.91 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.30% 3.84% 1.87% 7.10% 3.29% 0.40% 1.90% 1.69% 0.61% 2.40% 0.59% 0.44% 1.69% <-Median-> 5 % of Stock Price
Notes:
October 20, 2017. Last estimates were for 2016, 2017 and 2018 of $6484M, $6754M and $7048NM for Revenue, $11.80, 12.20 and $13.60 for EPS,
$14.60, $17.70 and $19.60 for CFPS and $1758M, $1766M and $1879M for Net Income.
October 16, 2016. Last estimates were for 2015, 2016 and 2017 of $6848M, $7.185M and $7.527M for Revenue, $9.77, $12.00 and $13.50 for EPS,
$15.20, $17.30 and $18.00 for CFPS and $1549M, $1756M and $1924M for Net Income.
October 17, 2015. Last estimates were for 2014, 2015 and 2016 of $6651M, $7644M and $8075M for Revenue, $8.41, $10.90 and $13.10 for EPS,
$12.30, $15.50 and $17.20 for CFPS and $1468M, $1797M and $2065M for Net Income.
October 12, 2014. Last estimates were for $6176M, $6643M and $7088M for Revenue, $6.19, $7.90 and $9.43 for EPS, $10.60 $12.50 and $13.80 for CFPS.
Oct 6, 2013. Last estimates were for 2012 and 2013 of $5730M and $6162 M for Revenue, $4.42 and $5.50 for EPS.
Sep 4, 2012. Diluted earnings per share of $0.60, inclusive of the negative impact of approximately $0.30 from significant items including
management transition and advisory costs and an Ontario corporate income tax rate change. (Some sites show $.90 as EPS for Q2.)
management transition and advisory costs and an Ontario corporate income tax rate change.
Mar 13, 2011. When I last looked I got earnings for 2010 and 2011 of $3.40 and $4.05 and cash Flow of $6.02 and $7.05.
*They have their accounting procedures and say that Book Value, under new rules was only $4658.1 for 2009, not originally reported $6706 some 30.5% less. Therefore BV increased by 3.6% in 2010.
A lot of the figures for 2009 was restated with accounting changes of 2010. However, I have not changed my spreadsheet. Shows how fragil accounting figures can be.
Mar 3, 2010. Earnings came in higher, but cash flow came in a lot lower. Earning estimate for 2010 is lowered, but earnings are expected to recover, as well as Cash Flow in 2011.
In Jul 2009 I picked up for 2009 and 2010 earning estimates of $2.75 and $3.50 and Cash Flow estimates of $6.70 and $7.37.
In April I picked up 2009 and 2010 estimates of $3.70 and $4.20. Estimates for this stock have declined a lot.
April 26, 2009 AR 2008. In June 2008, I got earnings estimates of $4.50 (actual was basic at $4.03 and diluted at $3.98) and Revenue Estimates of $4946. (actual $4931.6) for 2008.
AP 2007. I have done ok on this stock since buying in 2006. TD has a buy rating on it. Dividends are increasing nicely. ANNUAL STATEMENT NOT YET REC
AP 2006. Revenue is not growning well, but earnings are. My stock is doing well. TD expects a 7.1% return on this this at present over next year. Keeper for now.
AP2005. This stock looks a lot better if figures from Financial Post Card is accurate. They are certainly different from the ones I had used.
2004. I do not think that they are making much money.
Prior to 2001, Company was Canadian Pacfic Limited (CPL) and CPR was spin off of CPL. (Although dividends were paid prior to 2002, I have no accurate figures.)
In 2001, the CPR's parent company, Canadian Pacific Limited, spun off its five subsidiaries, including the CPR, into independent companies.
For every 100 CP shares investors hold, they'll receive 68.4 shares of Pan Canadian Energy (the new name for PanCanadian Petroleum), 50 shares of CP Rail, 25 shares of Fairmont Hotels and Resorts,
25 shares of CP Ships, and 16.6 shares of Fording (CP's coal mining division). Currently only PanCanadian trades on its own, with CP owning 86.6 per cent of the shares. Those shares will be spun off in the restructuring.
Sector:
Services, Industrial
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock.
It is a stock I held from 1987 to 1999 so I am following it. I also held it 2006 to 2011. I decided in 2011 to have only one railway stock and chose CN as my railway stock.
Dividends
Dividends are paid quarterly in Cycle 1 of January, April, July and October. Dividends are declared in one month and paid in the following month.
For example, the dividend declared on December 30, 2011 was paid on January 30, 2012.
Why I bought and sold this stock.
I am following this stock because it is a dividend growth stock. It is one that was on Mike Higgs' list.
How they make their money
This company is a transcontinental railway operating in Canada and the U.S. Its rail network serves the principal centers of Canada, from Montreal to Vancouver and the U.S. Northeast and Midwest regions
Alliances with other carriers extend its market reach throughout the U.S. and into Mexico. Canadian Pacific Solutions provides logistics and supply chain expertise.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.
Also, for the Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jun 30 2012 Oct-06 2013 Oct 12 2014 Oct 17 2015 Oct 16 2016 Oct 20 2017
Creel, Keith E. 0.000 0.00% 0.000 0.00% 0.001 0.00% 0.001 0.00% 0.002 0.00% Used to be an officer
CEO - Shares - Amount $0.000 $0.000 $0.140 $0.254 $0.417 CEO 2017
Options - percentage 0.282 0.16% 0.382 0.23% 0.384 0.25% 0.454 0.31% 0.657 0.45%
Options - amount $45.303 $85.473 $67.831 $87.051 $147.192
Harrison, E. Hunter 0.094 0.05% 0.178 0.10% 0.178 0.11% 0.179 0.12% 0.179 0.12%
CEO - Shares - Amount $9.485 $28.596 $39.828 $31.567 $34.216
Options - percentage 0.675 0.39% 0.688 0.39% 0.178 0.11% 0.954 0.62% 1.085 0.74%
Options - amount $68.108 $110.527 $39.828 $168.634 $207.777
Reuters Options Value
Velani, Nadeem 0.001 0.00% 0.001 0.00%
CFO - Shares - Amount $0.098 $0.140
Options - percentage 0.011 0.01% 0.018 0.01%
Options - amount $2.139 $4.146
Erceg, Mark 0.000 0.00%
CFO - Shares - Amount $0.000
Options - percentage 0.045 0.03%
Options - amount $7.896
Grassby, Brian 0.003 0.00%
CFO - Shares - Amount $0.482
Options - percentage 0.103 0.06%
Options - amount $16.547
Demosky, Barton Wade 0.000 0.00%
CFO - Shares - Amount $0.000
Options - percentage 0.134 0.08%
Options - amount $29.983
Brooks, John Kenneth 0.001 0.00%
Officer - Shares - Amount $0.334
Options - percentage 0.031 0.02%
Options - amount $6.966
Deciccio, Guido 0.003 0.00% 2.463 1.48% 0.003 0.00% 0.004 0.00%
Officer - Shares - Amount $0.482 $551.096 $0.612 $0.688
Options - percentage 0.041 0.02% 0.031 0.02% 0.031 0.02% 0.029 0.02%
Options - amount $6.587 $6.936 $5.527 $5.600
Baird, John Russell 0.000 0.00% 0.000 0.00%
Director - Shares - Amount $0.000 $0.000
Options - percentage 0.002 0.00% 0.003 0.00%
Options - amount $0.346 $0.669
Ackman, William A. 24.160 13.89% 23.125 13.18% 13.941 8.39% 13.941 9.11% ceased to be insider Sep 2016
Director - Shares - Amount ######## $3,715.031 $3,119.299 $2,463.773
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Reardon, Andrew Fitzpatrick 0.004 0.00% 0.004 0.00% 0.004 0.00%
Chairman - Shares - Amt $0.712 $0.772 $0.904
Options - percentage 0.004 0.00% 0.007 0.01% 0.010 0.01%
Options - amount $0.753 $1.402 $2.223
Colter, Gary F. 0.002 0.00% 0.002 0.00%
Chairman - Shares - Amt $0.321 $0.448
Options - percentage 0.004 0.00% 0.005 0.00%
Options - amount $0.643 $1.119
Increase in O/S Shares 0.800 0.47% 3.900 2.24% 1.500 0.86% 1.000 0.60% 0.600 0.39% 0.200 0.14%
due to SO $55.208 $393.510 $240.975 $223.750 $106.038 $38.312
Book Value $41.000 $273.000 $113.000 $81.000 $54.000 $28.000
Insider Buying -$3.023 -$0.182 $0.000
Insider Selling $23.054 $774.842 $6.798
Net Insider Selling $539.494 $20.031 $774.660 $6.798
Net Selling % of Market Cap 1.45% 0.07% 2.76% 0.02%
Directors 14 12 10 9 10
Women 4 29% 4 33% 3 30% 3 33% 4 40%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings
Total Shares Held 291 73.03% 448 0.00% 470 76.04% 388 69.35% 432 68.37%
Increase/Decrease 125.382 73.75% 137.949 83.05% 122.393 80.00% 102.393 69.99% 99.107 68.35%
Starting No. of Shares 5.529 4.61% 38.395 38.57% -5.791 -4.52% -9.225 -8.27% -3.705 -3.60%
119.853 99.554 Nasdaq 128.183 Nasdaq 111.618 Nasdaq 102.812 Nasdaq
Copyright 2008 Website of SPBrunner. All rights reserved.
My stock