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.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Q2 2022
Granite REIT TSX: GRT.UN NYSE: GRP.U https://granitereit.com/ Fiscal Yr: Dec 31
Year 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 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 Value Description #Y Item Total G Currency
Change in Reporting Currency <--USD$ CDN$---> Change in Currency
Accounting rules US GAAP US GAAP US GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting rules
US-CDN 0.9970 1.0213 0.9983 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2678 1.3544 1.3526 1.3526 1.3526 US-CDN
$367.6 <-12 mths 9.27%
Revenue US$ * $358.36 $182.95 $181.42 $191.09 $178.79 $156.20 $166.38 $177.47 $181.41 $210.72 $267.20 $310.37 $336.37 85.41% <-Total Growth 10 Revenue US$
Increase -2.44% -48.95% -0.83% 5.33% -6.44% -12.63% 6.52% 6.67% 2.22% 16.15% 26.81% 16.16% 8.38% Count 22 Years of data US$
Real Estate Revenue US$ $172.66 $182.95 $181.42 $191.09 $178.79 $156.20 $166.38 $176.19 $180.68 $210.06 $267.20 $310.37 $336.37 85.41% <-Total Growth 10 Revenue US$
Increase -22.93% 5.96% -0.84% 5.33% -6.44% -12.63% 6.52% 5.90% 2.55% 16.26% 27.20% 16.16% 8.38% 6.37% <-IRR #YR-> 10 Revenue 85.41% US$
5 year Running Average $198.0 $197.7 $196.0 $190.4 $181.4 $178.1 $174.8 $173.7 $171.6 $177.9 $200.1 $228.9 $260.9 13.81% <-IRR #YR-> 5 Revenue 90.91% US$
Revenue per Share $3.70 $3.90 $3.87 $4.07 $3.80 $3.32 $3.53 $3.76 $3.95 $3.89 $4.33 $4.72 $5.28 2.90% <-IRR #YR-> 10 5 yr Running Average 33.10% US$
Increase -22.93% 5.59% -0.75% 5.08% -6.58% -12.63% 6.28% 6.39% 5.28% -1.74% 11.46% 9.07% 11.76% 8.48% <-IRR #YR-> 5 5 yr Running Average 50.20% US$
5 year Running Average $4.22 $4.24 $4.20 $4.07 $3.87 $3.79 $3.72 $3.70 $3.67 $3.69 $3.89 $4.13 $4.44 3.15% <-IRR #YR-> 10 Revenue per Share 36.30% US$
P/S (Price/Sales) Med 5.19 7.33 9.00 8.91 9.39 9.87 8.41 9.83 10.30 11.80 10.46 14.88 12.31 7.05% <-IRR #YR-> 5 Revenue per Share 40.55% US$
P/S on High 7.49 8.44 9.97 9.78 10.22 11.54 9.64 10.99 11.13 13.51 14.34 17.62 15.87 11.33 <-Median-> 10 P/S on High US$
P/S on Low 2.88 6.22 8.03 8.05 8.57 8.20 7.19 8.68 9.47 10.10 6.58 12.13 8.75 8.62 <-Median-> 10 P/S on Low US$
P/S (Price/Sales) Close 7.36 8.19 9.81 8.96 9.35 8.28 9.47 10.40 9.83 13.04 14.12 17.63 9.66 0.54% <-IRR #YR-> 10 5 yr Running Average 5.52% US$
$497.2 <-12 mths 9.13%
Real Estate Revenue CDN$ $172.14 $186.85 $181.12 $203.25 $207.41 $216.30 $223.40 $221.03 $246.49 $272.82 $340.20 $393.49 $455.58 151.54% <-Total Growth 10 Revenue CDN$
Increase -26.83% 8.55% -3.07% 12.22% 2.05% 4.29% 3.28% -1.06% 11.52% 10.68% 24.70% 15.66% 15.78% 9.66% <-IRR #YR-> 10 Revenue 151.54% CDN$
5 year Running Average $215.6 $210.0 $208.7 $195.7 $190.2 $199.0 $206.3 $214.3 $222.9 $236.0 $260.8 $294.8 $341.7 15.56% <-IRR #YR-> 5 Revenue 106.12% CDN$
Revenue per Share $3.69 $3.99 $3.87 $4.33 $4.41 $4.60 $4.74 $4.71 $5.40 $5.05 $5.51 $5.99 $7.15 5.05% <-IRR #YR-> 10 5 yr Running Average 63.72% CDN$
Increase -26.83% 8.17% -2.99% 11.95% 1.89% 4.29% 3.05% -0.60% 14.49% -6.45% 9.26% 8.61% 19.39% 9.78% <-IRR #YR-> 5 5 yr Running Average 59.47% CDN$
5 year Running Average $4.60 $4.51 $4.48 $4.18 $4.06 $4.24 $4.39 $4.56 $4.77 $4.90 $5.08 $5.33 $5.82 6.34% <-IRR #YR-> 10 Revenue per Share 84.91% CDN$
P/S (Price/Sales) Med 5.27 7.32 9.09 8.59 9.04 8.94 8.56 10.16 9.77 12.15 10.95 14.88 11.76 8.70% <-IRR #YR-> 5 Revenue per Share 51.75% CDN$
P/S on High 7.60 8.43 9.90 9.25 9.68 9.91 9.50 11.03 10.62 13.67 14.44 17.64 14.51 10.82 <-Median-> 10 P/S on High CDN$
P/S on Low 2.94 6.21 8.28 7.93 8.41 7.96 7.61 9.28 8.93 10.64 7.46 12.11 9.02 8.67 <-Median-> 10 P/S on Low CDN$
P/S (Price/Sales) Close 7.35 8.18 9.76 8.93 9.35 8.25 9.46 10.45 9.86 13.07 14.13 17.60 9.66 2.66% <-IRR #YR-> 10 5 yr Running Average 29.98% CDN$
*Revenue in M CDN $  P/S Med 20 yr  8.22 15 yr  7.96 10 yr  9.96 5 yr  11.76 -100.00% Diff M/C 5.00% <-IRR #YR-> 5 5 yr Running Average 27.65% CDN$
$497.2 <-12 mths 9.13%
Revenue CDN$* $357.29 $186.85 $181.12 $203.25 $207.41 $216.30 $223.40 $222.64 $247.48 $273.68 $340.20 $393.49 $455.58 $525 $564 $587 151.54% <-Total Growth 10 Revenue CDN$
Increase -7.38% -47.70% -3.07% 12.22% 2.05% 4.29% 3.28% -0.34% 11.16% 10.58% 24.31% 15.66% 15.78% 15.24% 7.43% 4.08% 9.66% <-IRR #YR-> 10 Revenue 151.54% CDN$
5 year Running Average $697.1 $532.6 $411.8 $262.8 $227.2 $199.0 $206.3 $214.6 $223.4 $236.7 $261.5 $295.5 $342.1 $397.6 $455.7 $505.0 15.40% <-IRR #YR-> 5 Revenue 104.63% CDN$
Revenue per Share $7.65 $3.99 $3.87 $4.33 $4.41 $4.60 $4.74 $4.75 $5.42 $5.06 $5.51 $5.99 $7.15 $8.24 $8.85 $9.21 -1.84% <-IRR #YR-> 10 5 yr Running Average -16.93% CDN$
Increase -7.38% -47.89% -2.99% 11.95% 1.89% 4.29% 3.05% 0.13% 14.12% -6.53% 8.92% 8.61% 19.39% 15.24% 7.43% 4.08% 9.77% <-IRR #YR-> 5 5 yr Running Average 59.41% CDN$
5 year Running Average $14.83 $11.45 $8.86 $5.62 $4.85 $4.24 $4.39 $4.57 $4.78 $4.91 $5.10 $5.35 $5.83 $6.39 $7.15 $7.89 6.34% <-IRR #YR-> 10 Revenue per Share 84.91% CDN$
P/S (Price/Sales) Med 2.54 7.32 9.09 8.59 9.04 8.94 8.56 10.08 9.73 12.12 10.95 14.88 11.76 9.58 0.00 0.00 8.54% <-IRR #YR-> 5 Revenue per Share 50.65% CDN$
P/S on High 3.66 8.43 9.90 9.25 9.68 9.91 9.50 10.95 10.57 13.63 14.44 17.64 14.51 10.69 0.00 0.00 10.76 <-Median-> 10 P/S on High CDN$
P/S on Low 1.41 6.21 8.28 7.93 8.41 7.96 7.61 9.22 8.89 10.61 7.46 12.11 9.02 8.47 0.00 0.00 8.65 <-Median-> 10 P/S on Low CDN$
P/S (Price/Sales) Close 3.54 8.18 9.76 8.93 9.35 8.25 9.46 10.38 9.82 13.03 14.13 17.60 9.66 9.00 8.38 8.05 -4.10% <-IRR #YR-> 10 5 yr Running Average -34.23% CDN$
*Revenue in M CDN $  P/S Med 20 yr  7.53 15 yr  7.96 10 yr  9.91 5 yr  11.76 -9.12% Diff M/C 5.00% <-IRR #YR-> 5 5 yr Running Average 27.63% CDN$
-$181 $0 $0 $0 $0 $0 $0 $0 $0 $0 $456
-$223 $0 $0 $0 $0 $456
-$411.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $342.1
-$214.6 $0.0 $0.0 $0.0 $0.0 $342.1
-$3.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.15
-$4.75 $0.00 $0.00 $0.00 $0.00 $7.15
-$8.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.83
-$4.57 $0.00 $0.00 $0.00 $0.00 $5.83
$274.7 <-12 mths 3.97%
$4.28 <-12 mths 5.68%
AFFO CDN$ $149.30 $145.40 $138.10 $172.80 $215.70 $235.20 264.2
AFFO CDN$ Basic & Diluted CDN$ $1.65 $1.94 $2.83 $3.00 $3.16 $3.15 $3.09 $3.01 $3.53 $3.81 $3.68 $4.05 $4.43 $4.89 108.76% <-Total Growth 10 AFFO CDN$
Increase 17.58% 45.88% 6.01% 5.33% -0.32% -1.90% -2.59% 17.28% 7.93% -3.41% 10.05% 9.38% 10.38% 7.64% <-IRR #YR-> 10 AFFO 108.76% CDN$
AFFO Yield 7.3% 7.3% 8.3% 7.0% 6.3% 5.7% 5.4% 4.9% 3.5% 5.9% 6.0% 6.6% 5.56% <-IRR #YR-> 5 AFFO 31.07% CDN$
5 year Running Average $2.52 $2.82 $3.05 $3.08 $3.19 $3.32 $3.42 $3.62 $3.90 $4.17 5.32% <-IRR #YR-> 7 5 yr Running Average #DIV/0! CDN$
Payout Ratio AFFO 49.52% 103.05% 74.20% 73.20% 72.91% 76.29% 84.27% 90.50% 79.21% 76.22% 81.52% 76.53% 72.24% 65.45% 3.49% <-IRR #YR-> 5 5 yr Running Average 18.71% CDN$
5 year Running Average 74.58% 79.93% 76.17% 79.43% 80.63% 81.30% 82.34% 80.80% 77.15% 74.39% 80.28% <-Median-> 8 Payout 5 yr Running Average CDN$
Price/AFFO on High 20.36 19.74 14.15 14.23 14.42 14.30 16.82 19.03 19.55 20.91 28.72 25.61 19.89 0.00 17.92 <-Median-> 10 P/AFFO on High CDN$
Price/AFFO on Low 15.00 16.52 12.14 12.36 11.59 11.45 14.16 16.00 15.21 10.79 19.71 15.93 15.75 0.00 13.26 <-Median-> 10 P/AFFO on Low CDN$
Price/AFFO on Med 17.68 18.13 13.14 13.30 13.01 12.88 15.49 17.51 17.38 15.85 24.22 20.77 17.82 0.00 15.67 <-Median-> 10 P/AFFO on Med CDN$
Price/AFFO on Close 19.75 19.46 13.66 13.75 12.01 14.23 15.94 17.68 18.69 20.45 28.64 17.06 16.75 15.17 16.50 <-Median-> 10 P/AFFO on Close CDN$
Trailing P/AFFO Close 22.88 19.93 14.58 12.65 14.19 15.63 17.22 21.92 22.07 27.66 18.77 18.32 16.75 18.00 <-Median-> 10 Trailing P/AFFO Close CDN$
Median Values DPR 10 Yrs 76.41% 5 Yrs   79.21% P/CF 5 Yrs   in order 20.91 15.93 17.51 18.69 -4.37% Diff M/C -6.55% Diff M/C 10 DPR 75% to 95% best
$305.0 <-12 mths 5.43%
$4.75 <-12 mths 6.98%
FFO CDN$ $109.90 $138.30 $125.30 $158.40 $149.70 $153.20 $168.90 $177.50 $225.40 $251.30 $289.30 163.24% <-Total Growth 10 FFO CDN$
FFO Diluted CDN$ $1.44 $2.23 $2.44 $2.95 $2.66 $3.36 $3.18 $3.25 $3.68 $3.62 $3.98 $3.93 $4.43 81.56% <-Total Growth 10 FFO Diluted CDN$
FFO Basic CDN$ $1.44 $2.23 $2.44 $2.95 $3.37 $3.37 $3.18 $3.25 $3.68 $3.62 $3.98 $3.93 $4.44 $4.97 $5.33 81.97% <-Total Growth 10 FFO Basic CDN$ CDN$
Increase 20.99% 55.08% 9.59% 20.90% 14.24% 0.00% -5.64% 2.20% 13.23% -1.63% 9.94% -1.26% 12.98% 11.94% 7.24% 6.17% <-IRR #YR-> 10 FFO 81.97% CDN$
FFO Yield 5.30% 6.83% 6.46% 7.63% 8.17% 8.88% 7.09% 6.60% 6.92% 5.49% 5.11% 3.73% 6.43% 6.70% 7.18% 6.44% <-IRR #YR-> 5 FFO 36.62% CDN$
5 year Running Average $2.71 $2.49 $2.39 $2.05 $2.48 $2.87 $3.06 $3.22 $3.37 $3.42 $3.54 $3.69 $3.93 $4.19 $4.53 5.09% <-IRR #YR-> 10 5 yr Running Average 64.24% CDN$
Payout Ratio FFO 34.72% 36.70% 81.93% 71.19% 65.16% 68.37% 75.57% 80.12% 74.02% 77.24% 72.96% 76.34% 69.81% 64.39% 60.05% 4.04% <-IRR #YR-> 5 5 yr Running Average 21.90% CDN$
5 year Running Average 28.96% 32.10% 44.43% 55.53% 57.94% 64.67% 72.44% 72.08% 72.65% 75.06% 75.98% 76.14% 74.07% 72.1% 68.7% 72.55% <-Median-> 10 Payout 5 yr Running Average CDN$
Price/ FFO on High 19.50 15.09 15.69 13.57 12.67 13.53 14.17 15.99 15.57 19.06 20.01 26.89 23.36 17.73 0.00 15.78 <-Median-> 10 P FFO on High CDN$
Price/ FFO on Low 7.54 11.12 13.13 11.64 11.01 10.87 11.34 13.46 13.09 14.83 10.33 18.46 14.53 14.04 0.00 12.37 <-Median-> 10 P/ FFO on Low CDN$
Price/ FFO on Med 13.52 13.10 14.41 12.61 11.84 12.20 12.75 14.73 14.33 16.95 15.17 22.68 18.95 15.88 0.00 14.53 <-Median-> 10 P/ FFO on Med CDN$
Price/ FFO on Close 18.86 14.64 15.48 13.11 12.24 11.26 14.10 15.15 14.46 18.23 19.57 26.82 15.56 14.93 13.92 14.81 <-Median-> 10 P/ FFO on Close CDN$
Trailing P/FFO Close 22.82 22.70 16.96 15.84 13.99 11.26 13.30 15.49 16.37 17.93 21.52 26.48 17.58 16.71 14.93 16.11 <-Median-> 10 Trailing P/FFO Close CDN$
Median Values DPR 10 Yrs 73.49% 5 Yrs   74.02% P/CF 5 Yrs   in order 20.01 14.53 16.95 18.23 -11.91% Diff M/C -5.38% Diff M/C 10 DPR 75% to 95% best CDN$
-$1.64 <-12 mths -192.91%
EPS Basic US$ -$1.11 $3.32 $1.52 $2.91 $1.29 $2.97 $4.42 $6.05 $7.43 $6.00 $5.96 $16.14 $1.76 15.85% <-Total Growth 10 EPS Basic US$
EPS Diluted* US$ -$1.11 $3.32 $1.52 $2.90 $1.29 $2.96 $4.42 $6.94 $7.43 $6.00 $5.95 $16.14 $1.76 -$1.64 <-12 mths 15.68% <-Total Growth 10 EPS Diluted US$
Increase 22% -399% -54% 91% -56% 131% 49% 57% 7% -19% -1% 171% -89% -192.91% <-12 mths 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield -4.1% 10.4% 4.0% 8.0% 3.6% 10.8% 13.2% 17.8% 19.1% 11.8% 9.7% 19.4% 3.5% -180.3% <-12 mths 1.47% <-IRR #YR-> 10 Earnings per Share 15.68% US$
5 year Running Average -$0.01 $0.41 $0.55 $1.15 $1.58 $2.40 $2.62 $3.70 $4.61 $5.55 $6.15 $8.49 $7.46 $5.65 <-12 mths -23.98% <-IRR #YR-> 5 Earnings per Share -74.61% US$
10 year Running Average -$0.02 $0.24 $0.37 $0.77 $0.91 $1.20 $1.51 $2.13 $2.88 $3.57 $4.27 $5.56 $5.58 $5.13 <-12 mths 29.77% <-IRR #YR-> 10 5 yr Running Average 1254.79% US$
* Diluted ESP per share  E/P 10 Yrs 11.31% 5Yrs 11.85% 15.04% <-IRR #YR-> 5 5 yr Running Average 101.47% US$
-$2.21 <-12 mths -192.78%
EPS Basic -$1.11 $3.39 $1.52 $3.09 $1.49 $4.11 $5.93 $7.59 $10.13 $7.80 $7.59 $20.47 $2.39 57.18% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* CDN$ -$1.11 $3.39 $1.52 $3.09 $1.49 $4.11 $5.93 $8.70 $10.13 $7.80 $7.58 $20.47 $2.39 -$2.21 <-12 mths 56.94% <-Total Growth 10 EPS Diluted CDN$
Increase 16% -406% -55.17% 103.23% -51.71% 175.20% 44.49% 46.74% 16.44% -23.06% -2.79% 170.01% -88.35% -192.78% <-12 mths 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield -4.1% 10.4% 4.0% 8.0% 3.6% 10.8% 13.2% 17.7% 19.0% 11.8% 9.7% 19.4% 3.5% -3.0% <-12 mths 4.61% <-IRR #YR-> 10 Earnings per Share 56.94% CDN$
5 year Running Average $0.02 $0.41 $0.55 $1.19 $1.68 $2.72 $3.23 $4.66 $6.07 $7.33 $8.03 $10.94 $9.67 $7.20 <-12 mths -22.81% <-IRR #YR-> 5 Earnings per Share -72.59% CDN$
10 year Running Average $0.02 $0.25 $0.36 $0.81 $0.98 $1.37 $1.82 $2.61 $3.63 $4.51 $5.37 $7.08 $7.17 $6.64 <-12 mths 33.14% <-IRR #YR-> 10 5 yr Running 1650.55% CDN$
* Diluted ESP per share  E/P 10 Yrs 11.32% 5Yrs 11.82% 15.71% <-IRR #YR-> 5 5 yr Running 107.40% CDN$
-$1.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.39
-$8.70 $0.00 $0.00 $0.00 $0.00 $2.39
-$0.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.67
-$4.66 $0.00 $0.00 $0.00 $0.00 $9.67
Dividend US$* $2.37 $2.40 $2.51 Estimates Dividend* US$
Increase 3.38% 1.56% 4.62% Estimates Increase US$
Payout Ratio EPS -144.58% Estimates Payout Ratio EPS
Special Dividends US$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Special Dividends US$
Dividends* US$ $0.50 $0.80 $2.00 $1.97 $1.89 $1.66 $1.79 $2.08 $2.00 $2.15 $2.28 $2.37 $2.29 $2.37 $2.37 $2.37 14.28% <-Total Growth 10 Dividends US$
Increase -16.67% 60.00% 150.32% -1.40% -4.13% -12.10% 7.56% 15.98% -3.80% 7.81% 5.95% 3.75% -3.29% 3.39% 0.00% 0.00% 9 6 19 Years of data Count P, N US$
Average Increases 5 Year Running -1.11% 8.67% 38.73% 38.45% 37.62% 38.54% 28.05% 1.18% 0.70% 3.09% 6.70% 5.94% 2.08% 3.52% 1.96% 0.77% 6.32% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.58 $0.62 $0.90 $1.18 $1.43 $1.67 $1.86 $1.88 $1.88 $2.12 $2.24 $2.36 $2.40 $2.48 $2.33 $2.35 166.72% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 2.61% 2.80% 5.74% 5.44% 5.30% 5.07% 6.02% 5.62% 4.90% 4.69% 5.03% 3.37% 3.52% 4.13% 5.05% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 1.81% 2.43% 5.18% 4.96% 4.87% 4.34% 5.26% 5.03% 4.54% 4.10% 3.67% 2.84% 2.73% 3.67% 4.44% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 4.69% 3.29% 6.44% 6.03% 5.81% 6.11% 7.05% 6.37% 5.33% 5.48% 8.00% 4.13% 4.95% 4.70% 5.92% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 1.84% 2.50% 5.27% 5.41% 5.32% 6.05% 5.35% 5.31% 5.13% 4.25% 3.73% 2.84% 4.49% 4.27% 4.27% 4.27% 5.22% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS -45.05% 24.10% 131.52% 67.98% 147.22% 56.13% 40.51% 29.92% 26.88% 51.25% 38.31% 14.66% 129.94% -144.60% #VALUE! #DIV/0! 45.88% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running -9667% 151.22% 163.58% 102.62% 90.50% 69.46% 71.20% 50.77% 40.89% 38.21% 36.50% 27.78% 32.20% 43.85% #VALUE! #DIV/0! 45.83% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 26.30% 33.09% 80.27% 77.08% 111.18% 67.77% 70.78% 76.34% 78.82% 117.75% 73.32% 75.15% 71.16% 68.96% #VALUE! #DIV/0! 75.74% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 32.99% 30.58% 40.97% 50.73% 64.72% 71.65% 79.40% 78.52% 78.89% 82.52% 83.08% 83.51% 82.13% 79.76% #VALUE! #DIV/0! 79.15% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 39.82% 30.83% 82.36% 66.30% 87.14% 60.71% 65.47% 63.48% 62.34% 98.16% 66.11% 63.20% 56.71% 68.96% #VALUE! #DIV/0! 64.48% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 37.40% 33.37% 43.59% 51.57% 62.72% 64.52% 71.41% 67.63% 66.71% 70.30% 71.05% 70.21% 68.36% 69.56% #VALUE! #DIV/0! 68.00% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 10 Yr Med 10 Yr Cl 5.05% 5.22% 5 Yr Med 5 Yr Cl 4.69% 4.25% 5 Yr Med Payout 38.31% 75.15% 63.20% 1.97% <-IRR #YR-> 5 Dividends 10.25% US$
* Dividends per share  10 Yr Med and Cur. -15.49% -18.24% 5 Yr Med and Cur. -9.00% 0.51% Last Div Inc ---> $0.233 $0.242 3.86% 1.34% <-IRR #YR-> 10 Dividends 14.28% US$
Dividends Growth 15 9.34% <-IRR #YR-> 15 Dividends 281.42% US$
Dividends Growth 20 10.22% <-IRR #YR-> 19 Dividends US$
Dividends Growth 5 -$2.08 $0.00 $0.00 $0.00 $0.00 $2.29 Dividends Growth 5
Dividends Growth 10 -$2.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.29 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.29 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.29 Dividends Growth 20
Historical Dividends Historical High Div 8.15% Low Div 1.28% 10 Yr High 7.91% 10 Yr Low 2.74% Med Div 4.11% Close Div 4.37% Historical Dividends US$
High/Ave/Median Values Curr diff Exp. -47.61%     233.61% Exp. -46.02% 55.85% Cheap 3.90% Exp. -2.25% High/Ave/Median  US$
Dividend CDN* $3.20 $3.25 $3.40 Estimates Dividend* CDN$
Increase 3.24% 1.56% 4.62% Estimates Increase CDN$
Payout Ratio EPS -144.58% Estimates Payout Ratio EPS
Special Dividends CDN$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends CDN$
Dividends* CDN$ $0.50 $0.82 $2.00 $2.10 $2.20 $2.30 $2.40 $2.60 $2.72 $2.80 $2.90 $3.00 $3.0996 $3.2004 $3.2004 $3.2004 55.05% <-Total Growth 10 Dividends CDN$
Increase -20.88% 63.90% 144.68% 5.04% 4.57% 4.92% 4.30% 8.36% 4.61% 2.64% 3.86% 3.31% 3.32% 3.25% 0.00% 0.00% 15 4 19 Years of data Count P, N CDN$
Average Increases 5 Year Running -3.02% 7.50% 39.47% 35.71% 39.46% 44.62% 32.70% 5.44% 5.35% 4.97% 4.76% 4.56% 3.55% 3.28% 2.75% 1.98% 5.40% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.63 $0.65 $0.94 $1.21 $1.52 $1.88 $2.20 $2.32 $2.45 $2.81 $2.93 $3.05 $3.14 $3.24 $3.08 $3.14 236.03% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 2.57% 2.80% 5.69% 5.65% 5.50% 5.61% 5.92% 5.44% 5.17% 4.56% 4.81% 3.37% 3.68% 4.05% 5.30% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 1.78% 2.43% 5.22% 5.24% 5.14% 5.05% 5.33% 5.01% 4.76% 4.05% 3.65% 2.84% 2.99% 3.63% 4.88% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 4.61% 3.30% 6.24% 6.11% 5.92% 6.29% 6.66% 5.95% 5.66% 5.21% 7.06% 4.14% 4.80% 4.59% 5.94% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 1.84% 2.51% 5.29% 5.43% 5.32% 6.07% 5.36% 5.29% 5.12% 4.24% 3.73% 2.85% 4.49% 4.31% 4.31% 4.31% 5.20% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS -45.05% 24.10% 131.52% 67.98% 147.22% 56.13% 40.51% 29.92% 26.88% 35.86% 38.31% 14.66% 129.94% -144.60% #VALUE! #DIV/0! 39.41% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 2945.14% 159.41% 169.36% 101.80% 90.77% 69.25% 68.18% 49.77% 40.28% 38.26% 36.44% 27.85% 32.51% 44.98% #VALUE! #DIV/0! 45.03% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 26.30% 33.09% 80.27% 77.08% 111.18% 67.77% 70.78% 76.34% 78.82% 82.39% 73.32% 75.15% 71.16% 68.96% #VALUE! #DIV/0! 75.74% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 33.24% 30.55% 40.40% 50.80% 65.86% 72.10% 78.67% 77.87% 78.22% 82.27% 83.05% 83.61% 82.07% 79.63% #VALUE! #DIV/0! 78.44% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 39.82% 30.83% 82.36% 66.30% 87.14% 60.71% 65.47% 63.48% 62.34% 68.68% 66.11% 63.20% 56.71% 68.96% #VALUE! #DIV/0! 64.48% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 37.37% 33.19% 42.89% 51.48% 63.34% 64.67% 70.62% 67.27% 66.27% 70.13% 71.00% 70.23% 68.23% 69.48% #VALUE! #DIV/0! 67.75% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values 10 Yr Med 10 Yr Cl 5.30% 5.20% 5 Yr Med 5 Yr Cl 4.56% 4.24% 5 Yr Med Payout 35.86% 75.15% 63.20% 3.55% <-IRR #YR-> 5 Dividends 19.03% CDN$
* Dividends per share  10 Yr Med and Cur. -18.68% -17.11% 5 Yr Med and Cur. -5.36% 1.78% Last Div Inc ---> $0.2583 $0.2667 3.25% 4.48% <-IRR #YR-> 10 Dividends 55.05% CDN$
Dividends Growth 15 11.66% <-IRR #YR-> 15 Dividends 422.82% CDN$
Dividends Growth 20 10.50% <-IRR #YR-> 19 Dividends CDN$
Dividends Growth 5 -$2.60 $0.00 $0.00 $0.00 $0.00 $3.10 Dividends Growth 5
Dividends Growth 10 -$2.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.10 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.10 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.10 Dividends Growth 20
Historical Dividends Historical High Div 8.09% Low Div 1.27% 10 Yr High 7.02% 10 Yr Low 2.85% Med Div 4.17% Close Div 4.36% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -46.68%     239.62% Exp. -38.56% 51.34% Cheap 3.43% Exp. -1.13% High/Ave/Median  CDN$
Future Dividend Yield Div Yield 5.13% earning in 5 Years at IRR of 3.55% Div Inc. 19.03% Future Dividend Yield CDN$
Future Dividend Yield Div Yield 6.11% earning in 10 Years at IRR of 3.55% Div Inc. 41.69% Future Dividend Yield CDN$
Future Dividend Yield Div Yield 7.27% earning in 15 Years at IRR of 3.55% Div Inc. 68.65% Future Dividend Yield CDN$
Future Dividend Paid Div Paid $3.81 earning in 5 Years at IRR of 3.55% Div Inc. 19.03% Future Dividend Paid CDN$
Future Dividend Paid Div Paid $4.53 earning in 10 Years at IRR of 3.55% Div Inc. 41.69% Future Dividend Paid CDN$
Future Dividend Paid Div Paid $5.40 earning in 15 Years at IRR of 3.55% Div Inc. 68.65% Future Dividend Paid CDN$
Dividend Covering Cost Total Div $17.18 over 5 Years at IRR of 3.55% Div Cov. 23.15% Dividend Covering Cost CDN$
Dividend Covering Cost Total Div $33.82 over 10 Years at IRR of 3.55% Div Cov. 45.57% Dividend Covering Cost CDN$
Dividend Covering Cost Total Div $53.62 over 15 Years at IRR of 3.55% Div Cov. 72.26% Dividend Covering Cost CDN$
Yield if held 5 yrs 1.30% 2.07% 5.64% 10.80% 21.53% 11.87% 8.24% 7.41% 7.32% 7.01% 7.06% 7.40% 6.48% 6.07% 5.22% 5.30% 7.40% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 yrs 6.58% 6.37% 6.00% 6.10% 7.35% 14.01% 27.41% 14.96% 10.28% 8.81% 8.60% 8.02% 7.79% 8.08% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 yrs 8.53% 8.11% 7.57% 7.62% 8.74% 16.45% 31.38% 16.49% 8.11% <-Median-> 5 Paid Median Price CDN$
Yield if held 20 years 10.02% 9.28% 8.34% #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 5 years 8.22% 8.31% 13.20% 31.08% 74.61% 48.51% 37.72% 33.01% 32.88% 35.17% 35.59% 37.54% 32.85% 30.73% 25.11% 26.00% 35.38% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 28.61% 31.60% 32.76% 36.25% 45.95% 93.96% 212.17% 123.89% 89.92% 77.72% 76.44% 73.78% 73.79% 61.83% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 66.92% 72.29% 70.89% 74.92% 90.31% 177.25% 363.20% 204.78% 72.29% <-Median-> 5 Paid Median Price CDN$
Cost covered if held 20 years 117.66% 116.97% 111.80% #NUM! <-Median-> 0 Paid Median Price CDN$
Yr  Item Tot. Growth Per Year
Revenue Growth  $222.6 $247.5 $273.7 $340.2 $393.5 $455.6 $1,933.1 104.63% <-Total Growth 5 Revenue Growth  104.63% 15.40%
AFFO Growth $3.09 $3.01 $3.53 $3.81 $3.68 $4.05 $21.17 31.07% <-Total Growth 5 AFFO Growth 31.07% 5.56%
FFO Growth $3.25 $3.68 $3.62 $3.98 $3.93 $4.44 $22.90 36.62% <-Total Growth 5 FFO Growth 36.62% 6.44%
Net Income Growth $285.1 $341.0 $294.2 $337.6 $1,033.2 $115.0 $2,406.1 -59.67% <-Total Growth 5 Net Income Growth -59.67% -16.61%
Cash Flow Growth $127.5 $115.7 $141.2 $191.9 $206.9 $204.9 $988.1 60.65% <-Total Growth 5 Cash Flow Growth 60.65% 9.95%
Dividend Growth $2.08 $2.00 $2.15 $2.28 $2.37 $2.29 $13.16 10.25% <-Total Growth 5 Dividend Growth 10.25% 1.97%
Stock Price Growth $49.25 $53.21 $65.98 $77.90 $105.40 $69.08 40.26% <-Total Growth 5 Stock Price Growth 40.26% 7.00%
Revenue Growth  $181.1 $203.2 $207.4 $216.3 $223.4 $222.6 $247.5 $273.7 $340.2 $393.5 $455.6 $2,964.5 151.54% <-Total Growth 10 Revenue Growth  151.54% 9.66%
AFFO Growth $1.94 $2.83 $3.00 $3.16 $3.15 $3.09 $3.01 $3.53 $3.81 $3.68 $4.05 $35.25 108.76% <-Total Growth 10 AFFO Growth 108.76% 7.64%
FFO Growth $2.44 $2.95 $3.37 $3.37 $3.18 $3.25 $3.68 $3.62 $3.98 $3.93 $4.44 $38.21 81.97% <-Total Growth 10 AFFO Growth 81.97% 6.17%
Net Income Growth $71.5 $136.4 $60.5 $139.6 $208.0 $285.1 $341.0 $294.2 $337.6 $1,033.2 $115.0 $3,022.1 60.95% <-Total Growth 10 Net Income Growth 60.95% 4.87%
Cash Flow Growth $116.8 $120.2 $80.0 $115.4 $119.2 $127.5 $115.7 $141.2 $191.9 $206.9 $204.9 $1,539.9 75.35% <-Total Growth 10 Cash Flow Growth 75.35% 5.78%
Dividend Growth $2.00 $1.97 $1.89 $1.66 $1.79 $2.08 $2.00 $2.15 $2.28 $2.37 $2.29 $22.5 14.28% <-Total Growth 10 Dividend Growth 14.28% 1.34%
Stock Price Growth $37.76 $38.66 $41.26 $37.96 $44.83 $49.25 $53.21 $65.98 $77.90 $105.40 $69.08 82.94% <-Total Growth 10 Stock Price Growth 82.94% 6.23%
Dividends on Shares $56.70 $59.29 $62.21 $64.88 $70.31 $73.55 $107.89 $78.41 $81.00 $83.69 $86.41 $86.41 $86.41 $737.93 No of Years 10 Total Divs 12/31/12
Paid  $1,019.52 $1,043.82 $1,114.02 $1,024.92 $1,210.41 $1,329.75 $1,436.67 $1,781.46 $2,103.30 $2,845.80 $1,865.16 $2,003.40 $2,003.40 $2,003.40 $1,865.16 No of Years 10 Worth $37.76 26.48
Total $2,603.09
Graham Price FFO CDN$ $32.08 $31.24 $32.06 $48.61 $51.27 $54.61 $54.39 $57.72 $67.25 $68.85 $75.44 $84.61 $92.68 $97.06 $100.51 $0.00 189.04% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 0.61 0.93 1.10 0.77 0.78 0.75 0.75 0.83 0.78 0.89 0.80 1.05 0.91 0.81 0.79 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 0.87 1.08 1.19 0.82 0.83 0.83 0.83 0.90 0.85 1.00 1.06 1.25 1.12 0.91 0.88 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.34 0.79 1.00 0.71 0.72 0.67 0.66 0.76 0.72 0.78 0.55 0.86 0.70 0.72 0.71 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 0.84 1.04 1.18 0.80 0.80 0.70 0.82 0.85 0.79 0.96 1.03 1.25 0.75 0.76 0.74 #DIV/0! 0.81 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close -15.58% 4.32% 17.77% -20.47% -19.53% -30.49% -17.57% -14.67% -20.88% -4.17% 3.27% 24.57% -25.46% -23.55% -26.18% #DIV/0! -18.55% <-Median-> 10 Graham Price CDN$
Comments
Graham Price CDN$ $24.10 $38.55 $25.31 $49.74 $34.11 $60.27 $74.28 $94.45 $111.60 $101.05 $104.11 $193.09 $67.93 $67.24 #VALUE! $0.00 168.43% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 0.81 0.76 1.39 0.75 1.17 0.68 0.55 0.51 0.47 0.61 0.58 0.46 1.24 1.17 0.59 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Hi 1.16 0.87 1.51 0.80 1.25 0.76 0.61 0.55 0.51 0.68 0.77 0.55 1.53 1.31 0.72 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.45 0.64 1.27 0.69 1.09 0.61 0.49 0.46 0.43 0.53 0.39 0.38 0.95 1.04 0.51 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Cl 1.12 0.85 1.49 0.78 1.21 0.63 0.60 0.52 0.48 0.65 0.75 0.55 1.02 1.10 #VALUE! #DIV/0! 0.64 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc CL 12.37% -15.47% 49.21% -22.28% 20.96% -37.02% -39.65% -47.85% -52.32% -34.71% -25.17% -45.41% 1.69% 10.35% #VALUE! #DIV/0! -35.86% <-Median-> 10 Graham Price CDN$
Price Close CDN$ $27.08 $32.59 $37.76 $38.66 $41.26 $37.96 $44.83 $49.25 $53.21 $65.98 $77.90 $105.40 $69.08 $74.20 $74.20 $74.20 82.94% <-Total Growth 10 Stock Price CDN$
Increase 110.25% 20.35% 15.86% 2.38% 6.73% -8.00% 18.10% 9.86% 8.04% 24.00% 18.07% 35.30% -34.46% 7.41% 0.00% 0.00% 11.52 <-Median-> 10 CAPE (10 Yr P/E)
P/E -24.47 9.61 24.84 12.51 27.66 9.25 7.56 5.66 5.25 8.46 10.28 5.15 28.96 -33.52 #VALUE! #DIV/0! 7.00% <-IRR #YR-> 5 Stock Price 40.26% CDN$
Trailing P/E -28.34 -29.45 11.14 25.43 13.36 25.45 10.92 8.30 6.11 6.51 9.99 13.90 3.38 31.11 -33.52 #VALUE! 6.23% <-IRR #YR-> 10 Stock Price 82.94% CDN$
CAPE (10 Yr P/E) 1,451.68 117.84 82.87 37.71 31.64 22.38 17.03 12.70 10.34 9.51 8.92 7.80 8.14 9.33 #VALUE! #DIV/0! 12.65% <-IRR #YR-> 5 Price & Dividend 72.19% CDN$
Median 10, 5 Yrs D.  per yr 5.47% 5.65% % Tot Ret 46.78% 44.65% T P/E 10.46 6.51 P/E:  8.85 8.46 11.70% <-IRR #YR-> 10 Price & Dividend 155.32% CDN$
Price 15 D.  per yr 4.42% % Tot Ret 41.35% CAPE Diff -390.93% 6.27% <-IRR #YR-> 15 Stock Price 148.94% CDN$
Price  20 D.  per yr 3.37% % Tot Ret 41.01% 4.85% <-IRR #YR-> 20 Stock Price CDN$
Price & Dividend 15 10.69% <-IRR #YR-> 15 Price & Dividend CDN$
Price & Dividend 20 8.22% <-IRR #YR-> 20 Price & Dividend CDN$
Price  5 -$49.25 $0.00 $0.00 $0.00 $0.00 $69.08 Price  5
Price 10 -$37.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69.08 Price 10
Price & Dividend 5 -$49.25 $2.72 $4.00 $2.90 $3.00 $72.18 Price & Dividend 5
Price & Dividend 10 -$37.76 $2.10 $2.20 $2.30 $2.40 $2.60 $2.72 $4.00 $2.90 $3.00 $72.18 Price & Dividend 10
Price  15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69.08 Price  15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69.08 Price  20
Price & Dividend 15 $0.50 $0.82 $2.00 $2.10 $2.20 $2.30 $2.40 $2.60 $2.72 $4.00 $2.90 $3.00 $72.18 Price & Dividend 15
Price & Dividend 20 $0.50 $0.82 $2.00 $2.10 $2.20 $2.30 $2.40 $2.60 $2.72 $4.00 $2.90 $3.00 $72.18 Price & Dividend 20
Price Med H/L CDN$ $19.41 $29.17 $35.17 $37.20 $39.90 $41.11 $40.56 $47.86 $52.72 $61.35 $60.39 $89.12 $84.12 $78.95 139.22% <-Total Growth 10 Stock Price CDN$
Increase 90.29% 50.28% 20.55% 5.77% 7.26% 3.03% -1.33% 18.00% 10.15% 16.37% -1.57% 47.58% -5.61% -6.15% 1.28% <-IRR #YR-> 10 Stock Price 139.22% CDN$
P/E -17.54 8.60 23.13 12.04 26.75 10.01 6.84 5.50 5.20 7.87 7.97 4.35 35.26 -35.67 11.94% <-IRR #YR-> 5 Stock Price 75.76% CDN$
Trailing P/E -20.31 -26.36 10.37 24.47 12.91 27.56 9.88 8.07 6.06 6.05 7.74 11.76 4.11 33.09 4.65% <-IRR #YR-> 10 Price & Dividend 108.62% CDN$
P/E on Run. 5 yr Ave 905.96 71.04 63.64 31.32 23.79 15.12 12.57 10.26 8.68 8.36 7.52 8.15 8.70 10.96 16.84% <-IRR #YR-> 5 Price & Dividend 216.94% CDN$
P/E on Run. 10 yr Ave 1094.34 118.51 96.80 46.19 40.87 30.00 22.30 18.35 14.52 13.62 11.24 12.58 11.73 11.89 7.92 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 3.36% 4.90% % Tot Ret 72.41% 29.11% Price Inc 10.15% P/E:  7.92 7.87 Count 20 Years of data CDN$
-$35.17 $0.00 -$39.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $84.12
-$47.86 $0.00 $0.00 $0.00 $0.00 $84.12
-$35.17 $2.10 -$39.90 $2.30 $2.40 $2.60 $2.72 $2.80 $2.90 $3.00 $87.22
-$47.86 $2.72 $2.80 $2.90 $3.00 $87.22
High Months Dec Nov Oct May Dec Mar Dec Jun Sep  Dec Aug Dec Jan Feb
Price High CDN $ $28.00 $33.59 $38.29 $40.04 $42.70 $45.58 $45.05 $51.97 $57.28 $69.00 $79.65 $105.68 $103.73 $88.10 170.91% <-Total Growth 10 Stock Price CDN$
Increase 81.82% 19.96% 13.99% 4.57% 6.64% 6.74% -1.16% 15.36% 10.22% 20.46% 15.43% 32.68% -1.85% -15.07% 10.48% <-IRR #YR-> 10 Stock Price 170.91% CDN$
P/E -25.30 9.91 25.19 12.96 28.63 11.10 7.60 5.97 5.65 8.85 10.51 5.16 43.48 -39.81 14.82% <-IRR #YR-> 5 Stock Price 99.60% CDN$
Trailing P/E -29.30 -30.35 11.29 26.34 13.82 30.56 10.97 8.76 6.58 6.81 10.21 13.94 5.07 36.93 9.38 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 15.43% P/E:  9.68 8.85 29.24 P/E Ratio Historical High CDN$
-$38 $0 $0 $0 $0 $0 $0 $0 $0 $0 $103.73
-$52 $0 $0 $0 $0 $103.73
Low Months Sep  Aug Jun Jul Jan Sep Feb Jan Feb Jan Mar Mar Oct Jan
Price Low CDN $10.82 $24.75 $32.04 $34.35 $37.09 $36.63 $36.07 $43.75 $48.16 $53.70 $41.12 $72.55 $64.51 $69.79 101.34% <-Total Growth 10 Stock Price CDN$
Increase 116.40% 128.74% 29.45% 7.21% 7.98% -1.24% -1.53% 21.29% 10.08% 11.50% -23.43% 76.43% -11.08% 8.18% 7.25% <-IRR #YR-> 10 Stock Price 101.34% CDN$
P/E -9.78 7.30 21.08 11.12 24.87 8.92 6.08 5.03 4.75 6.89 5.42 3.54 27.04 -31.53 8.08% <-IRR #YR-> 5 Stock Price 47.45% CDN$
Trailing P/E -11.32 -22.36 9.45 22.60 12.01 24.56 8.79 7.38 5.53 5.30 5.27 9.57 3.15 29.26 6.48 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 10.08% P/E:  6.48 5.42 -8.87 P/E Ratio Historical Low CDN$
-$32 $0 $0 $0 $0 $0 $0 $0 $0 $0 $64.51
-$44 $0 $0 $0 $0 $64.51
Price Close US$ based on exchange rates $27.16 $31.91 $37.82 $36.35 $35.57 $27.41 $33.39 $39.26 $39.00 $50.80 $61.18 $83.14 $51.00 $54.86 $54.86 $54.86
Price Close US$  $27.21 $31.98 $38.01 $36.49 $35.55 $27.50 $33.44 $39.08 $38.89 $50.67 $61.15 $83.31 $50.99 $55.41 $55.41 $55.41 34.15% <-Total Growth 10 Stock Price US$
Increase 121.58% 17.53% 18.86% -4.00% -2.58% -22.64% 21.60% 16.87% -0.49% 30.29% 20.68% 36.24% -38.79% 8.67% 0.00% 0.00% 16.69 <-Median-> 10 CAPE (10 Yr P/E)
P/E Ratio -24.51 9.63 24.96 12.56 27.65 9.28 7.57 5.63 5.24 8.44 10.27 5.16 28.95 -33.86 #VALUE! #DIV/0! 5.46% <-IRR #YR-> 5 Stock Price 30.48% US$
Trailing P/E Ratio -29.90 -28.81 11.45 23.97 12.24 21.39 11.28 8.85 5.61 6.82 10.19 13.99 3.16 31.46 -33.86 #VALUE! 2.98% <-IRR #YR-> 10 Stock Price 34.15% US$
CAPE (10 Yr P/E) -1,476.32 131.02 101.56 47.53 38.88 22.98 22.08 18.38 13.52 14.20 14.31 14.99 9.14 10.81 #VALUE! #DIV/0! 11.04% <-IRR #YR-> 5 Price & Dividend 61.21% US$
Median 10, 5 Yrs D.  per yr 4.89% 5.57% % Tot Ret 62.14% 70.79% T P/E 10.73 6.82 P/E:  8.86 8.44 7.87% <-IRR #YR-> 10 Price & Dividend 90.47% US$
Price 15 D.  per yr 4.26% % Tot Ret 50.90% CAPE Diff -35.22% 4.11% <-IRR #YR-> 15 Stock Price 82.96% US$
Price  20 D.  per yr 4.06% % Tot Ret 41.78% 5.66% <-IRR #YR-> 20 Stock Price
Price & Dividend 15 8.37% <-IRR #YR-> 15 Price & Dividend 175.92% US$
Price & Dividend 20 9.72% <-IRR #YR-> 20 Price & Dividend
Price H/L Median $19.18 $28.62 $34.88 $36.28 $35.73 $32.80 $29.71 $36.94 $40.73 $45.88 $45.32 $70.29 $65.02 $57.35 86.42% <-Total Growth 10 Stock Price US$
Increase 106.96% 49.26% 21.86% 4.03% -1.53% -8.19% -9.42% 24.34% 10.25% 12.65% -1.21% 55.09% -7.50% -11.79% 6.43% <-IRR #YR-> 10 Stock Price 86.42% US$
P/E Ratio -17.27 8.62 22.91 12.49 27.78 11.06 6.73 5.32 5.48 7.64 7.61 4.35 36.91 -35.05 11.97% <-IRR #YR-> 5 Stock Price 76.00% US$
Trailing P/E Ratio -21.07 -25.78 10.50 23.83 12.30 25.51 10.02 8.36 5.87 6.18 7.55 11.81 4.03 32.56 11.09% <-IRR #YR-> 10 Price & Dividend 108.51% US$
P/E on Run. 5 yr Ave -3195.83 69.80 63.35 31.67 22.55 13.67 11.34 9.98 8.84 8.27 7.37 8.28 8.72 10.16 17.28% <-IRR #YR-> 5 Price & Dividend 147.80% US$
P/E on Run. 10 yr Ave -1040.37 117.26 93.18 47.26 39.07 27.41 19.62 17.37 14.16 12.86 10.60 12.65 11.65 11.19 7.63 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 4.66% 5.31% % Tot Ret 42.05% 30.72% T P/E 6.18 P/E:  7.63 7.61 Count 20 Years of data US$
High Months Dec Nov Oct May May Jan Dec Jul Sep Dec Dec Dec Jan Feb
Price High US$ $27.69 $32.95 $38.64 $39.81 $38.87 $38.35 $34.05 $41.29 $44.00 $52.50 $62.13 $83.27 $83.81 $64.39 116.90% <-Total Growth 10 Stock Price US$
Increase 89.53% 19.00% 17.27% 3.03% -2.36% -1.34% -11.21% 21.26% 6.56% 19.32% 18.34% 34.02% 0.65% -23.17% 8.05% <-IRR #YR-> 10 Stock Price 116.90% US$
P/E Ratio -24.95 9.92 25.38 13.71 30.23 12.94 7.71 5.95 5.92 8.74 10.44 5.16 47.59 -39.35 15.21% <-IRR #YR-> 5 Stock Price 102.98% US$
Trailing P/E Ratio -30.43 -29.68 11.64 26.15 13.38 29.83 11.49 9.35 6.34 7.07 10.35 13.99 5.19 36.56 9.33 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 7.07 P/E:  9.59 8.74 30.18 P/E Ratio Historical High US$
Low Months Sep  Oct Jun Aug Oct Sep Jan Jan Mar Jan Mar Mar Oct Jan
Price Low US$ $10.66 $24.29 $31.11 $32.75 $32.58 $27.25 $25.37 $32.59 $37.45 $39.25 $28.51 $57.31 $46.22 $50.31 48.57% <-Total Growth 10 Stock Price US$
Increase 171.94% 127.86% 28.08% 5.27% -0.52% -16.36% -6.90% 28.46% 14.91% 4.81% -27.36% 101.02% -19.35% 8.85% 4.04% <-IRR #YR-> 10 Stock Price 48.57% US$
P/E Ratio -9.60 7.32 20.43 11.28 25.34 9.19 5.74 4.70 5.04 6.54 4.79 3.55 26.24 -30.75 7.24% <-IRR #YR-> 5 Stock Price 41.82% US$
Trailing P/E Ratio -11.71 -21.88 9.37 21.51 11.22 21.19 8.56 7.38 5.40 5.28 4.75 9.63 2.86 28.57 6.14 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 5.28 P/E:  6.14 5.04 -8.54 P/E Ratio Historical Low US$
$147.80 <-12 mths -46.64%
Old pre 2022 $140 -$79 -$425 -$778 -$867 -$754 -$419 <-Mk Sc
Free Cash Flow MS $92 $112 $84 $98 $49 $133 $140 $75 $125 $153 $248 $262 $277 -$33 -$65 $22 229.76% <-Total Growth 10 Free Cash Flow MS CDN$
Change 21.74% -25.00% 16.67% -50.00% 171.43% 5.26% -46.43% 66.67% 22.40% 62.09% 5.65% 5.73% -111.91% -96.97% 133.85% 29.86% <-IRR #YR-> 5 Free Cash Flow MS 269.33% CDN$
FCF/CF from Op Ratio 1.04 0.99 0.72 0.81 0.61 1.15 1.17 0.59 1.08 1.08 1.29 1.27 1.35 -0.15 #VALUE! #DIV/0! 12.67% <-IRR #YR-> 10 Free Cash Flow MS 229.76% CDN$
Dividends paid $38 $94 $99 $103 $108 $113 $123 $125 $151 $137 $137 $137 $204 $204 $204 46.22% <-Total Growth 10 Dividends paid CDN$
Percentage paid 81.20% 80.71% 164.00% 100.00% 98.69% 55.20% 52.25% 49.42% -617.85% -313.68% 926.78% $0.81 <-Median-> 8 Percentage paid CDN$
5 Year Coverage 99.04% 87.57% 77.96% 64.48% 84.41% 118.79% 191.25% 5 Year Coverage CDN$
Dividend Coverage Ratio 1.23 1.24 0.61 1.00 1.01 1.81 1.91 2.02 -0.16 -0.32 0.11 1.24 <-Median-> 8 Dividend Coverage Ratio CDN$
5 Year of Coverage 1.01 1.14 1.28 1.55 1.18 0.84 0.52 5 Year of Coverage CDN$
Market Cap US$ $1,271 $1,499 $1,780 $1,713 $1,671 $1,293 $1,576 $1,833 $1,777 $2,739 $3,772 $5,473 $3,248 $3,530 $3,530 $3,530 82.49% <-Total Growth 10 Market Cap  US$
Market Cap CDN$ $1,265 $1,528 $1,768 $1,815 $1,940 $1,785 $2,113 $2,310 $2,431 $3,566 $4,805 $6,924 $4,401 $4,727 $4,727 $4,727 148.86% <-Total Growth 10 Market Cap CDN$
Diluted 46.71 46.97 46.88 46.95 47.07 47.10 47.09 41.10 45.90 49.00 56.7 64.0 65.3 62.2 39.30% <-Total Growth 10 Diluted Diluted Weighted
Change 0.00% 0.56% -0.20% 0.16% 0.26% 0.06% -0.01% -12.73% 11.68% 6.75% 15.71% 12.87% 2.03% -4.75% 1.15% <-Median-> 10 Change Average
Difference Diluted/Basic 0.0% -0.2% 0.0% -0.1% -0.1% -0.2% 0.0% 14.6% 0.0% 0.0% -0.2% 0.0% -0.2% 0.0% -0.03% <-Median-> 10 Difference Diluted/Basic
Basic # of Share in M 46.71 46.89 46.86 46.93 47.00 47.02 47.09 47.10 45.90 49.00 56.6 64.0 65.2 62.2 39.15% <-Total Growth 10 Average Basic Weighted
Change 0.00% 0.39% -0.07% 0.15% 0.16% 0.03% 0.16% 0.01% -2.55% 6.75% 15.51% 13.07% 1.88% -4.60% 0.16% <-Median-> 10 Change Average
Difference Basic/Outstanding 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.1% -0.4% -0.5% 10.3% 9.0% 2.6% -2.3% 2.4% 0.04% <-Median-> 10 Diff Basic/Outstanding
$218.59 <-12 mths 243.11%
# of Share in Millions 46.708 46.871 46.833 46.945 47.017 47.017 47.123 46.903 45.685 54.052 61.688 65.694 63.708 63.708 63.708 63.708 3.13% <-IRR #YR-> 10 Shares 36.03% Nunber of
Change 0.00% 0.35% -0.08% 0.24% 0.15% 0.00% 0.23% -0.47% -2.60% 18.31% 14.13% 6.49% -3.02% 0.00% 0.00% 0.00% 6.32% <-IRR #YR-> 5 Shares 35.83% Units 
CF fr Op $M US$ $88.80 $113.33 $116.84 $120.25 $80.05 $115.43 $119.16 $127.53 $115.74 $141.23 $191.90 $206.87 $204.88 $218.59 <-12 mths 75.35% <-Total Growth 10 Cash Flow  US$
Increase -13.95% 27.62% 3.10% 2.91% -33.43% 44.20% 3.23% 7.03% -9.25% 22.03% 35.87% 7.80% -0.96% 6.69% <-12 mths SO, Buy Backs
5 year Running Average $82.24 $94.56 $102.59 $108.48 $103.85 $109.18 $110.35 $112.48 $111.58 $123.82 $139.11 $156.65 $172.12 $192.69 <-12 mths 67.78% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $1.90 $2.42 $2.49 $2.56 $1.70 $2.46 $2.53 $2.72 $2.53 $2.61 $3.11 $3.15 $3.22 $3.43 <-12 mths 28.90% <-Total Growth 10 Cash Flow per Share US$
Increase -13.95% 27.17% 3.19% 2.67% -33.53% 44.20% 2.99% 7.53% -6.83% 3.14% 19.05% 1.23% 2.13% 6.69% <-12 mths 5.78% <-IRR #YR-> 10 Cash Flow 75.35% US$
5 year Running Average $1.76 $2.03 $2.20 $2.32 $2.22 $2.33 $2.35 $2.39 $2.39 $2.57 $2.70 $2.82 $2.92 $3.10 <-12 mths 9.95% <-IRR #YR-> 5 Cash Flow 60.65% US$
P/CF on Med Price 10.09 11.84 13.98 14.16 20.98 13.36 11.75 13.59 16.08 17.56 14.57 22.32 20.22 16.71 <-12 mths 2.57% <-IRR #YR-> 10 Cash Flow per Share 28.90% US$
P/CF on Closing Price 14.31 13.23 15.24 14.25 20.88 11.20 13.22 14.37 15.35 19.39 19.66 26.46 15.86 16.15 <-12 mths 3.41% <-IRR #YR-> 5 Cash Flow per Share 18.28% US$
5.40% Diff M/C 2.90% <-IRR #YR-> 10 CFPS 5 yr Running 33.05% US$
$265.92 <-12 mths 3.44%
Excl.Working Capital CF -$30.16 $8.29 -$2.97 $19.56 $22.09 $13.42 $9.66 $25.83 $30.60 $28.19 $20.94 $39.10 $52.19 $0.00 <-12 mths 4.09% <-IRR #YR-> 5 CFPS 5 yr Running 22.19% US$
CF fr Op $M WC $58.6 $121.6 $113.9 $139.8 $102.1 $128.9 $128.8 $153.4 $146.3 $169.4 $212.8 $246.0 $257.1 $218.6 <-12 mths 125.76% <-Total Growth 10 Cash Flow less WC US$
Increase -41.26% 107.38% -6.36% 22.77% -26.94% 26.16% -0.03% 19.05% -4.58% 15.77% 25.63% 15.56% 4.52% -14.97% <-12 mths 8.48% <-IRR #YR-> 10 Cash Flow less WC 125.76% US$
5 year Running Average $72.6 $86.7 $96.4 $106.8 $107.2 $121.3 $122.7 $130.6 $131.9 $145.4 $162.2 $185.6 $206.3 $220.8 <-12 mths 10.88% <-IRR #YR-> 5 Cash Flow less WC 67.63% US$
CFPS Excl. WC $1.26 $2.59 $2.43 $2.98 $2.17 $2.74 $2.73 $3.27 $3.20 $3.13 $3.45 $3.74 $4.04 $3.43 <-12 mths 7.90% <-IRR #YR-> 10 CF less WC 5 Yr Run 113.99% US$
Increase -41.26% 106.66% -6.29% 22.48% -27.05% 26.16% -0.26% 19.61% -2.03% -2.15% 10.08% 8.52% 7.78% -14.97% <-12 mths 9.58% <-IRR #YR-> 5 CF less WC 5 Yr Run 57.99% US$
5 year Running Average $1.55 $1.86 $2.07 $2.28 $2.29 $2.58 $2.61 $2.78 $2.82 $3.02 $3.16 $3.36 $3.51 $3.56 <-12 mths 5.20% <-IRR #YR-> 10 CFPS - Less WC 65.96% US$
P/CF on Med Price 15.27 11.03 14.34 12.18 16.45 11.97 10.87 11.30 12.71 14.64 13.14 18.77 16.11 16.71 <-12 mths 4.30% <-IRR #YR-> 5 CFPS - Less WC 23.41% US$
P/CF on Closing Price 21.67 12.33 15.63 12.25 16.36 10.03 12.23 11.95 12.14 16.17 17.72 22.25 12.64 16.15 <-12 mths -2.37% <-IRR #YR-> 10 CFPS 5 yr Running 70.09% US$
CF/-WC P/CF Med 10 yr 15.32 5 yr  17.56 P/CF Med 10 yr 12.92 5 yr  14.64 24.95% Diff M/C 4.80% <-IRR #YR-> 5 CFPS 5 yr Running 26.43% US$
$295.66 <-12 mths 6.55%
CF fr Op $M CDN$ $88.54 $115.74 $116.65 $127.89 $92.86 $159.84 $159.99 $159.99 $157.89 $183.43 $244.32 $262.26 $277.50 $295.66 <-12 mths 137.90% <-Total Growth 10 Cash Flow  CDN$
Increase -18.30% 30.73% 0.78% 9.64% -27.39% 72.13% 0.09% 0.00% -1.31% 16.18% 33.20% 7.34% 5.81% 6.55% <-12 mths SO, Buy Backs
5 year Running Average $88.82 $99.91 $108.08 $111.44 $108.34 $122.60 $131.45 $140.12 $146.12 $164.23 $181.12 $201.58 $225.08 $252.64 <-12 mths 108.26% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $1.90 $2.47 $2.49 $2.72 $1.98 $3.40 $3.40 $3.41 $3.46 $3.39 $3.96 $3.99 $4.36 $4.64 <-12 mths 74.88% <-Total Growth 10 Cash Flow per Share CDN$
Increase -18.30% 30.27% 0.86% 9.38% -27.50% 72.13% -0.13% 0.47% 1.32% -1.81% 16.71% 0.80% 9.11% 6.55% <-12 mths 9.05% <-IRR #YR-> 10 Cash Flow 137.90% CDN$
5 year Running Average $1.90 $2.14 $2.32 $2.38 $2.31 $2.61 $2.80 $2.98 $3.13 $3.41 $3.52 $3.64 $3.83 $4.07 <-12 mths 11.64% <-IRR #YR-> 5 Cash Flow 73.44% CDN$
P/CF on Med Price 10.24 11.81 14.12 13.65 20.20 12.09 11.95 14.03 15.25 18.08 15.25 22.32 19.31 17.01 <-12 mths 5.75% <-IRR #YR-> 10 Cash Flow per Share 74.88% CDN$
P/CF on Closing Price 14.29 13.20 15.16 14.19 20.89 11.17 13.20 14.44 15.40 19.44 19.67 26.40 15.86 15.99 <-12 mths 5.01% <-IRR #YR-> 5 Cash Flow per Share 27.69% CDN$
4.84% Diff M/C 5.16% <-IRR #YR-> 10 CFPS 5 yr Running 65.41% CDN$
$359.69 <-12 mths 3.30%
Excl.Working Capital CF -$30.07 $8.46 -$2.97 $20.80 $25.63 $18.59 $12.97 $32.40 $41.75 $36.61 $26.66 $49.57 $70.69 $0.00 <-12 mths 5.15% <-IRR #YR-> 5 CFPS 5 yr Running 28.53% CDN$
CF fr Op $M WC CDN$ $58.5 $124.2 $113.7 $148.7 $118.5 $178.4 $173.0 $192.4 $199.6 $220.0 $271.0 $311.8 $348.2 $295.7 <-12 mths 206.29% <-Total Growth 10 Cash Flow less WC CDN$
Increase -44.23% 112.44% -8.47% 30.80% -20.31% 50.59% -3.07% 11.23% 3.77% 10.22% 23.15% 15.07% 11.66% -15.08% <-12 mths 11.84% <-IRR #YR-> 10 Cash Flow less WC 206.29% CDN$
5 year Running Average $79.01 $91.94 $101.81 $109.98 $112.71 $136.70 $146.45 $162.19 $172.38 $192.69 $211.20 $238.98 $270.14 $289.34 <-12 mths 12.60% <-IRR #YR-> 5 Cash Flow less WC 80.98% CDN$
CFPS Excl. WC CDN$ $1.25 $2.65 $2.43 $3.17 $2.52 $3.80 $3.67 $4.10 $4.37 $4.07 $4.39 $4.75 $5.47 $4.64 <-12 mths 10.25% <-IRR #YR-> 10 CF less WC 5 Yr Run 165.32% CDN$
Increase -44% 112% -8% 30% -20% 51% -3% 12% 7% -7% 8% 8% 15% -15% <-12 mths 10.74% <-IRR #YR-> 5 CF less WC 5 Yr Run 66.55% CDN$
5 year Running Average $1.69 $1.97 $2.18 $2.35 $2.40 $2.91 $3.12 $3.45 $3.69 $4.00 $4.12 $4.34 $4.61 $4.66 <-12 mths 8.45% <-IRR #YR-> 10 CFPS - Less WC 125.16% CDN$
P/CF on Med 21.63 12.30 14.49 11.74 15.83 10.83 11.05 11.67 12.06 15.07 13.75 18.77 15.39 17.01 <-12 mths 5.91% <-IRR #YR-> 5 CFPS - Less WC 33.24% CDN$
P/CF on High Price 22.37 12.68 15.77 12.64 16.94 12.01 12.27 12.67 13.11 16.95 18.13 22.26 18.98 18.98 <-12 mths 15.03 <-Median-> 10 P/CF on High  111.22% CDN$
P/CF on Low Price 8.64 9.34 13.20 10.84 14.72 9.65 9.83 10.67 11.02 13.19 9.36 15.28 11.80 15.04 <-12 mths 10.93 <-Median-> 10 P/CF on Low  33.56% CDN$
P/CF on Closing Price 21.63 12.30 15.56 12.21 16.37 10.00 12.21 12.01 12.18 16.21 17.73 22.20 12.64 15.99 <-12 mths 7.76% <-IRR #YR-> 10 CFPS 5 yr Running CDN$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 15.25 5 yr  18.08 P/CF Med 10 yr 12.91 5 yr  15.07 23.89% Diff M/C 5.96% <-IRR #YR-> 5 CFPS 5 yr Running CDN$
-$3.41 $0.00 $0.00 $0.00 $0.00 $4.36 Cash Flow per Share CDN$
-$2.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.83 CFPS 5 yr Running CDN$
-$2.98 $0.00 $0.00 $0.00 $0.00 $3.83 CFPS 5 yr Running CDN$
-$114 $0 $0 $0 $0 $0 $0 $0 $0 $0 $348 Cash Flow less WC CDN$
-$192 $0 $0 $0 $0 $348 Cash Flow less WC CDN$
-$102 $0 $0 $0 $0 $0 $0 $0 $0 $0 $270 CF less WC 5 Yr Run CDN$
-$162 $0 $0 $0 $0 $270 CF less WC 5 Yr Run CDN$
-$2.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.47 CFPS - Less WC CDN$
-$4.10 $0.00 $0.00 $0.00 $0.00 $5.47 CFPS - Less WC CDN$
-$2.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.61 CFPS 5 yr Running CDN$
-$3.45 $0.00 $0.00 $0.00 $0.00 $4.61 CFPS 5 yr Running CDN$
Changes in working capital $0.293
Accounts Receivable $0.136 -$1.458 $2.723 -$1.191 -$1.626 -$3.670 $10.141 -$4.119 $1.674
Prepaid Expenses and other $0.067 $0.092 $0.333 -$0.362 -$0.475 -$0.906 $0.061 -$2.899 -$2.269
Accounts Payable & Accrued Liabilities -$6.401 $1.438 -$2.448 -$4.681 $5.788 -$0.639 $0.844 $5.411 -$4.209
Deferred Revenue $0.042 $1.293 -$1.376 -$1.411 -$0.245 $1.800 $5.595 $0.191 $4.702
Restricted Cash -$0.700 $0.727 $0.048 $0.335 $0.470
Leasing Commission paid -$2.581 -$4.225 -$1.307 -$2.953
Tenant Incentives paid -$1.036 -$9.913 -$0.513 -$2.019
Current income tax expense $10.490
Current taxes $3.662 $5.914 $7.873
Current taxes referring to previous period -$2.053 -$1.686
Withholding Taxes and other  $0.592 $0.000 $0.694
Income taxes paid -$14.525 -$4.377 -$5.921 -$0.225 -$3.468 -$10.273 -$3.009 -$5.679 -$7.669 -$18.090
Interest paid . -$17.059 -$19.349 -$17.192 -$19.585 -$17.719 -$21.116 -$28.833 -$32.654 -$40.483 -$52.494
                   
Sum -$20.80 -$25.63 -$18.59 -$12.970 -$32.401 -$41.750 -$36.607 -$26.664 -$49.568 -$70.686
Google --> TD 2017 -$20.41 -$25.63 -$18.59 -$16.63 -$32 -$42 -$37 -$27 -$50 -$71
Difference -$0.39 $0.00 $0.00 $3.66 $0 $0 $0 $0 $0 $0
TD -$20 -$26 -$19 -$17
Difference -$1 $0 $0 $4
OPM CDN$ 24.78% 61.94% 64.40% 62.93% 44.77% 73.90% 71.62% 71.86% 63.80% 67.02% 71.82% 66.65% 60.91% 56.32% -5.42% <-Total Growth 10 OPM CDN$
Increase -11.79% 149.97% 3.97% -2.30% -28.85% 65.06% -3.09% 0.34% -11.22% 5.06% 7.15% -7.19% -8.61% -7.54% Should increase  or be stable. CDN$
Diff from Ave -62.4% -6.0% -2.2% -4.5% -32.0% 12.2% 8.7% 9.1% -3.2% 1.7% 9.0% 1.2% -7.5% -14.5% 0.01 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 65.88% 5 Yrs 68.23% should be  zero, it is a   check on calculations CDN$
Investment Properties $1,943.70 $2,351.90 $2,310.38 $2,592.39 $2,653.10 $2,733.57 $3,424.98 $4,457.90 $5,855.58 $7,971.16 $8,839.57 $8,833.10 354.78% <-Total Growth 10 Investment Properties
Change 21.00% -1.77% 12.21% 2.34% 3.03% 25.29% 30.16% 31.35% 36.13% 10.89% -0.07% 16.60% <-Median-> 10 Change
Debt/Market Cap Ratio 0.14 0.22 0.22 0.20 0.24 0.24 0.35 0.27 0.33 0.30 0.29 0.35 25.50% <-Median-> 10 Debt/Market Cap Ratio
Long Term Debt $263.59 $514.93 $512.30 $523.77 $646.77 $647.31 $1,198.41 $1,186.99 $1,928.25 $2,425.85 $2,590.32 $3,062.88 882.71% <-Total Growth 10 Debt CDN$
Change 95.35% -0.51% 2.24% 23.48% 0.08% 85.14% -0.95% 62.45% 25.81% 6.78% 18.24% 15.13% <-Median-> 10 Change CDN$
Debt/Market Cap Ratio 0.15 0.28 0.26 0.29 0.31 0.28 0.49 0.33 0.40 0.35 0.59 0.65 0.32 <-Median-> 10 % of Market C. CDN$
Assets/Current Liabilities Ratio 26.95 23.12 18.99 26.48 49.80 19.42 49.49 56.46 18.05 52.12 14.98 16.95 24.80 <-Median-> 10 Assets/Current Liab Ratio CDN$
Debt to Cash Flow (Years) 2.26 4.03 5.52 3.28 4.04 4.05 7.59 6.47 7.89 9.25 9.33 10.36 5.99 <-Median-> 10 Debt to Cash Flow (Years) CDN$
Intangibles $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 #DIV/0! <-Total Growth 10 Intangibles CDN$
Goodwill $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 #DIV/0! <-Total Growth 10 Goodwill CDN$
Total yes--> $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 #DIV/0! <-Total Growth 10 Total CDN$
Change 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 Change CDN$
Intangible/Market Cap Ratio 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 % of Market C. CDN$
Current Assets US$ $155.75 $69.28 $61.61 $98.41 $108.67 $93.05       186.68 $371.07 $520.45 $247.80 $664.34 $383.76 $202.00 $119.57 227.86% <-Total Growth 10 Current Assets US$
Current Liabilities $116.75 $39.07 $45.28 $100.41 $111.09 $74.51         43.55 $131.63 $62.04 $65.51 $293.69 $129.65 $457.26 $399.01 909.78% <-Total Growth 10 Current Liabilities US$
Liquidity 1.33 1.77 1.36 0.98 0.98 1.25           4.29 2.82 8.39 3.78 2.26 2.96 0.44 0.30 2.54 <-Median-> 10 Ratio US$
Assets US$ $1,944.33 $1,224.59 $1,220.27 $2,321.02 $2,109.95 $1,972.81    2,168.50 $2,555.94 $3,070.48 $3,698.77 $5,299.62 $6,757.14 $6,852.00 $6,763.21 461.52% <-Total Growth 10 Assets US$
Liabilities $451.95 $330.55 $341.78 $744.76 $699.52 $630.48       716.40 $851.79 $1,240.12 $1,274.90 $2,219.03 $2,559.68 $2,805.68 $2,792.61 720.90% <-Total Growth 10 Liabilities US$
Debt Ratio 4.30 3.70 3.57 3.12 3.02 3.13           3.03 3.00 2.48 2.90 2.39 2.64 2.44 2.42 2.95 <-Median-> 10 Ratio US$
Book Value US$ $1,492 $894.0 $878.5 $1,571.3 $1,405.0 $1,335.3    1,450.96 $1,703.2 $1,829.3 $2,422.3 $2,422.3 $2,422.3 $2,422.3 $2,422.3 $2,422.3 $2,422.3 175.74% <-Total Growth 10 Book Value  US$
Book Value per Share $31.95 $19.07 $18.76 $33.47 $29.88 $28.40         30.79 $36.31 $40.04 $44.82 $39.27 $36.87 $38.02 $38.02 $38.02 $38.02 102.70% <-Total Growth 10 Book Value per Share US$
Current Assets CDN$ $155.28 $70.76 $61.51 $104.67 $126.07 $128.85 $250.66 $465.51 $709.99 $321.84 $845.8 $486.5 $273.6 $161.7 344.80% <-Total Growth 10 Current Assets CDN$
Current Liabilities $116.40 $39.91 $45.21 $106.80 $128.87 $103.17 $58.47 $165.13 $84.63 $85.09 $373.9 $164.4 $619.3 $539.7 1269.96% <-Total Growth 10 Current Liabilities CDN$
Liquidity Ratio 1.33 1.77 1.36 0.98 0.98 1.25 4.29 2.82 8.39 3.78 2.26 2.96 0.44 0.30 2.54 <-Median-> 10 Ratio CDN$
Liq. with CF aft div 1.89 3.71 1.87 1.25 0.90 1.75 5.09 3.05 8.78 4.16 2.44 3.36 0.57 0.47 3.36 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  1.73 1.63 1.19 1.01 0.90 1.46 5.09 1.25 8.78 0.37 0.63 0.46 0.26 0.47 0.46 <-Median-> 5 Ratio CDN$
Curr Long Term Debt $0.0 $0.0 $399.7 $399.9 CDN$
Liquidity Less CLTD 2.26 2.96 1.25 1.16 2.26 <-Median-> 3 Ratio CDN$
Liq. with CF aft div 2.44 3.36 1.61 1.81 2.44 <-Median-> 3 Ratio CDN$
Assets CDN$ $1,938.5 $1,250.7 $1,218.2 $2,468.6 $2,447.8 $2,731.8 $2,911.6 $3,206.4 $4,188.8 $4,804.0 $6,747.5 $8,566.7 $9,280.4 $9,147.9 661.81% <-Total Growth 10 Assets CDN$
Liabilities $450.6 $337.6 $341.2 $792.1 $811.5 $873.1 $961.9 $1,068.6 $1,691.8 $1,655.8 $2,825.3 $3,245.2 $3,800.0 $3,777.3 1013.71% <-Total Growth 10 Liabilities CDN$
Debt Ratio 4.30 3.70 3.57 3.12 3.02 3.13 3.03 3.00 2.48 2.90 2.39 2.64 2.44 2.42 2.95 <-Median-> 10 Ratio CDN$
Book Value CDN$ $1,487.9 $913.1 $877.0 $1,676.5 $1,636.2 $1,858.8 $1,949.7 $2,137.9 $2,497.0 $3,148.1 $3,922.2 $5,321.5 $5,480.3 $5,370.64 524.90% <-Total Growth 10 Book Value CDN$ CDN$
NCI $0.00 $0.00 $0.00 $5.28 $6.26 $9.76 $1.53 $1.25 $1.47 $1.97 $2.14 $2.88 $2.88 $3.48 NCI CDN$
Book Value CDN$ $1,487.9 $913.1 $877.0 $1,671.2 $1,630.0 $1,849.0 $1,948.2 $2,136.6 $2,495.5 $3,146.1 $3,920.1 $5,318.7 $5,477.5 $5,367.2 $5,367.2 $5,367.2 524.57% <-Total Growth 10 Book Value CDN$ CDN$
Book Value per share $31.86 $19.48 $18.73 $35.60 $34.67 $39.33 $41.34 $45.55 $54.62 $58.21 $63.55 $80.96 $85.98 $84.25 $84.25 $84.25 359.13% <-Total Growth 10 Book Value per Share CDN$
Change -10.88% -38.85% -3.88% 90.11% -2.62% 13.44% 5.13% 10.18% 19.91% 6.56% 9.18% 27.40% 6.20% -2.01% 0.00% 0.00% -15.72% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 0.61 1.50 1.88 1.04 1.15 1.05 0.98 1.05 0.97 1.05 0.95 1.10 0.98 0.94 0.98 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 0.85 1.67 2.02 1.09 1.19 0.97 1.08 1.08 0.97 1.13 1.23 1.30 0.80 0.88 0.88 0.88 16.46% <-IRR #YR-> 10 Book Value per Share 359.13% CDN$
Change 135.92% 96.79% 20.54% -46.14% 9.59% -18.90% 12.34% -0.29% -9.90% 16.37% 8.14% 6.20% -38.28% 9.62% 0.00% 0.00% 13.55% <-IRR #YR-> 5 Book Value per Share 88.74% CDN$
Leverage (A/BK) 1.30 1.37 1.39 1.48 1.50 1.48 1.49 1.50 1.68 1.53 1.72 1.61 1.69 1.70 1.57 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 0.30 0.37 0.39 0.47 0.50 0.47 0.49 0.50 0.68 0.53 0.72 0.61 0.69 0.70 0.57 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.05 5 yr Med 0.98 -15.72% Diff M/C 1.53 Historical A/BV CDN$
-$18.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $85.98
-$45.55 $0.00 $0.00 $0.00 $0.00 $85.98
$63.46 <-12 mths -87.24%
Total Comprehensive Income CDN$ $2.99 $143.95 $62.67 $253.31 $60.14 $330.96 $213.62 $322.76 $558.28 $286.93 $409.67 $1,286.31 $497.48 693.83% <-Total Growth 10 Total Comprehensive Inc CDN$
NCI $0.00 $0.00 $0.00 $0.44 $0.54 $3.59 $1.06 $0.23 $0.24 $0.11 $0.16 $0.33 $0.13 NCI CDN$
Shareholders $2.99 $143.95 $62.67 $252.88 $59.61 $327.38 $212.56 $322.53 $558.04 $286.82 $409.51 $1,285.99 $497.35 693.63% <-Total Growth 10 Comprehensive Income CDN$
Increase 123.28% 4712.65% -56.46% 303.52% -76.43% 449.21% -35.07% 51.74% 73.02% -48.60% 42.78% 214.03% -61.33% 42.8% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $25.97 $26.96 $16.79 $89.93 $104.42 $169.30 $183.02 $234.99 $296.02 $341.47 $357.89 $572.58 $607.54 23.02% <-IRR #YR-> 10 Comprehensive Income 693.63% CDN$
ROE CDN$ 0.2% 15.8% 7.1% 15.1% 3.7% 17.7% 10.9% 15.1% 22.4% 9.1% 10.4% 24.2% 9.1% 9.05% <-IRR #YR-> 5 Comprehensive Income 54.20% CDN$
5Yr Median 0.2% 0.2% 0.2% 7.1% 7.1% 15.1% 10.9% 15.1% 15.1% 15.1% 10.9% 15.1% 10.4% 43.17% <-IRR #YR-> 10 5 Yr Running Average 3519.23% CDN$
% Difference from NI -105.8% -9.5% -12.2% 74.4% -15.1% 69.3% -23.9% -9.8% 20.0% -24.9% -4.7% -1.8% 219.3% 20.92% <-IRR #YR-> 5 5 Yr Running Average 158.54% CDN$
Median Values Diff 5, 10 yr -3.3% -1.8% 10.4% <-Median-> 5 Return on Equity
-$62.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $497.3
-$322.5 $0.0 $0.0 $0.0 $0.0 $497.3
-$16.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $607.5
-$235.0 $0.0 $0.0 $0.0 $0.0 $607.5
Current Liability Coverage Ratio 0.50 3.11 2.51 1.39 0.92 1.73 2.96 1.17 2.36 2.59 0.72 1.90 0.56 0.55   CFO / Current Liabilities CDN$
5 year Median 0.25 0.50 2.51 2.51 1.39 1.73 1.73 1.39 1.73 2.36 2.36 1.90 1.90 0.72 1.90 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio 3.02% 9.93% 9.33% 6.02% 4.84% 6.53% 5.94% 6.00% 4.77% 4.58% 4.02% 3.64% 3.75% 3.23% CFO / Total Assets CDN$
5 year Median 3.02% 3.42% 5.20% 6.02% 6.02% 6.53% 6.02% 6.00% 5.94% 5.94% 4.77% 4.58% 4.02% 3.75% 4.0% <-Median-> 5 Return on Assets  CDN$
Return on Assets ROA -2.68% 12.72% 5.86% 5.87% 2.87% 7.08% 9.59% 11.16% 11.10% 7.95% 6.37% 15.29% 1.68% 3.41% Net  Income/Assets Return on Assets CDN$
5Yr Median -0.12% -0.12% -0.12% 5.86% 5.86% 5.87% 5.87% 7.08% 9.59% 9.59% 9.59% 11.10% 7.95% 6.37% 8.0% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE -3.49% 17.43% 8.13% 8.68% 4.31% 10.46% 14.34% 16.74% 18.64% 12.14% 10.96% 24.63% 2.84% 5.81% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median -0.20% -0.20% -0.20% 8.13% 8.13% 8.68% 8.68% 10.46% 14.34% 14.34% 14.34% 16.74% 12.14% 10.96% 12.1% <-Median-> 5 Return on Equity CDN$
-$147.39 <-12 mths -194.62%
Net Income CDN$ -$51.86 $159.12 $71.34 $145.27 $70.42 $195.54 $280.69 $357.75 $465.36 $382.28 $429.93 $1,310.27 $155.82 118.43% <-Total Growth 10 Net Income CDN$ CDN$
NCI $0.00 $0.00 $0.00 $0.24 $0.20 $2.21 $1.37 $0.05 $0.20 $0.20 $0.12 $0.34 $0.05 NCI CDN$
Shareholders -$51.86 $159.12 $71.34 $145.03 $70.21 $193.33 $279.33 $357.70 $465.16 $382.08 $429.80 $1,309.94 $155.77 $312 $327 118.36% <-Total Growth 10 Shareholders CDN$
Increase 16.77% -406.85% -55.17% 103.30% -51.59% 175.35% 44.48% 28.06% 30.04% -17.86% 12.49% 204.78% -88.11% 100.30% 4.81% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $1.7 $19.6 $26.1 $55.8 $78.8 $127.8 $151.8 $209.1 $273.1 $335.5 $382.8 $588.9 $548.5 $517.9 $506.9 8.12% <-IRR #YR-> 10 Net Income 118.36% CDN$
Operating Cash Flow $88.54 $115.74 $116.65 $127.89 $92.86 $159.84 $159.99 $159.99 $157.89 $183.43 $244.32 $262.26 $277.50 $295.66 <-12 mths $0.00 -15.32% <-IRR #YR-> 5 Net Income -56.45% CDN$
Investment Cash Flow -$10.86 -$51.12 -$25.80 -$25.80 $20.13 -$20.79 $11.78 -$237.85 $95.86 -$876.09 -$1,066.82 -$1,025.42 -$766.56 35.62% <-IRR #YR-> 10 5 Yr Running Average 2005.66% CDN$
Total Accruals -$129.53 $94.50 -$19.51 $42.94 -$42.78 $54.28 $107.56 $435.56 $211.41 $1,074.74 $1,252.31 $2,073.10 $644.83 21.27% <-IRR #YR-> 5 5 Yr Running Average 162.31% CDN$
Total Assets $1,938.5 $1,250.7 $1,218.2 $2,468.6 $2,447.8 $2,731.8 $2,911.6 $3,206.4 $4,188.8 $4,804.0 $6,747.5 $8,566.7 $9,280.4 Balance Sheet Assets CDN$
Accruals Ratio -6.68% 7.56% -1.60% 1.74% -1.75% 1.99% 3.69% 13.58% 5.05% 22.37% 18.56% 24.20% 6.95% 18.56% <-Median-> 5 Ratio CDN$
EPS/CF Ratio -0.88 1.28 0.63 0.98 0.59 1.08 1.62 2.12 2.32 1.92 1.73 4.31 0.44 1.67 <-Median-> 10 EPS/CF Ratio CDN$
-$71.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $155.8
-$357.7 $0.0 $0.0 $0.0 $0.0 $155.8
-$26.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $548.5
-$209.1 $0.0 $0.0 $0.0 $0.0 $548.5
$46.91 <-12 mths -87.22%
Total Comprehensive Income US$ $3.00 $140.94 $62.77 $238.16 $51.84 $239.01 $159.09 $257.28 $409.24 $220.92 $321.77 $1,014.60 $367.30 485.12% <-Total Growth 10 Total Comprehensive Income US$
NCI $0.00 $0.00 $0.00 $0.41 $0.46 $2.59 $0.79 $0.18 $0.18 $0.09 $0.12 $0.26 $0.09 NCI
Shareholders $3.00 $140.94 $62.77 $237.75 $51.38 $236.42 $158.31 $257.10 $409.06 $220.83 $321.64 $1,014.35 $367.21 484.97% <-Total Growth 10 Shareholders US$
Increase 124.52% 4598.03% -55.46% 278.75% -78.39% 360.11% -33.04% 62.41% 59.11% -46.01% 45.65% 215.37% -63.80% 45.6% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $26.56 $30.88 $20.46 $86.45 $99.17 $145.85 $149.33 $188.19 $222.45 $256.34 $273.39 $444.60 $466.62 19.32% <-IRR #YR-> 10 Comprehensive Income US$
ROE US$ 0.2% 15.8% 7.1% 15.1% 3.7% 17.7% 10.9% 15.1% 22.4% 9.1% 13.3% 41.9% 15.2% 7.39% <-IRR #YR-> 5 Comprehensive Income US$
5Yr Median 0.2% 0.2% 0.2% 7.1% 7.1% 15.1% 10.9% 15.1% 15.1% 15.1% 13.3% 15.1% 15.2% 36.71% <-IRR #YR-> 10 5 Yr Running Average US$
% Difference from NI -105.8% -9.5% -12.2% 74.4% -15.1% 69.3% -23.9% -9.8% 20.0% -24.9% -4.7% -1.8% 219.3% 19.91% <-IRR #YR-> 5 5 Yr Running Average US$
Median Values Diff 5, 10 yr -3.3% -1.8% 15.2% <-Median-> 5 Return on Equity
-$62.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $367.2
-$257.1 $0.0 $0.0 $0.0 $0.0 $367.2
-$20.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $466.6
-$188.2 $0.0 $0.0 $0.0 $0.0 $466.6
Current Liability Coverage Ratio 0.50 3.11 2.51 1.39 0.92 1.73 2.96 1.17 2.36 2.59 0.72 1.90 0.56 0.55   CFO / Current Liabilities US$
5 year Median 0.25 0.50 2.51 2.51 1.39 1.73 1.73 1.39 1.73 2.36 2.36 1.90 1.90 0.72 1.90 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio 3.02% 9.93% 9.33% 6.02% 4.84% 6.53% 5.94% 6.00% 4.77% 4.58% 4.02% 3.64% 3.75% 3.23% CFO / Total Assets US$
5 year Median 3.02% 3.42% 5.20% 6.02% 6.02% 6.53% 6.02% 6.00% 5.94% 5.94% 4.77% 4.58% 4.02% 3.75% 4.0% <-Median-> 5 Return on Assets  US$
Return on Assets ROA -2.68% 12.72% 5.86% 5.87% 2.87% 7.08% 9.59% 11.16% 11.10% 7.95% 6.37% 15.29% 1.68% 3.41% Net  Income/Assets Return on Assets US$
5Yr Median -0.12% -0.12% -0.12% 5.86% 5.86% 5.87% 5.87% 7.08% 9.59% 9.59% 9.59% 11.10% 7.95% 6.37% 8.0% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE -3.49% 17.43% 8.13% 8.68% 4.31% 10.46% 14.34% 16.74% 18.64% 12.14% 13.94% 42.65% 4.75% 9.52% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median -0.20% -0.20% -0.20% 8.13% 8.13% 8.68% 8.68% 10.46% 14.34% 14.34% 14.34% 16.74% 13.94% 12.14% 13.9% <-Median-> 5 Return on Equity US$
-$108.96 <-12 mths -194.74%
Net Income US$ -$52.01 $155.80 $71.46 $136.58 $60.70 $141.21 $209.05 $285.17 $341.12 $294.33 $337.67 $1,033.50 $115.05 61.00% <-Total Growth 10 Net Income US$ US$
NCI $0.00 $0.00 $0.00 $0.22 $0.18 $1.59 $1.02 $0.04 $0.15 $0.15 $0.10 $0.26 $0.04 NCI US$
Shareholders -$52.01 $155.80 $71.46 $136.36 $60.52 $139.62 $208.03 $285.14 $340.97 $294.18 $337.58 $1,033.24 $115.01 $230.67 $241.76 60.95% <-Total Growth 10 Shareholders US$
Increase 22.99% -399.54% -54.13% 90.82% -55.61% 130.68% 49.00% 37.06% 19.58% -13.72% 14.75% 206.07% -88.87% 100.56% 4.81% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $0.4 $19.6 $25.9 $53.9 $74.4 $112.8 $123.2 $165.9 $206.9 $253.6 $293.2 $458.2 $424.2 $402.1 $391.6 4.87% <-IRR #YR-> 10 Net Income 60.95% US$
Operating Cash Flow $88.80 $113.33 $116.84 $120.25 $80.05 $115.43 $119.16 $127.53 $115.74 $141.23 $191.90 $206.87 $204.88 -16.61% <-IRR #YR-> 5 Net Income -59.67% US$
Investment Cash Flow -$10.89 -$50.05 -$25.84 -$24.26 $17.35 -$15.01 $8.77 -$189.60 $70.27 -$674.54 -$837.91 -$808.82 -$565.97 32.24% <-IRR #YR-> 10 5 Yr Running Average 1534.82% US$
Total Accruals -$129.92 $92.52 -$19.54 $40.37 -$36.87 $39.20 $80.10 $347.20 $154.97 $827.49 $983.59 $1,635.19 $476.10 20.65% <-IRR #YR-> 5 5 Yr Running Average 155.64% US$
Total Assets $1,944.3 $1,224.6 $1,220.3 $2,321.0 $2,110.0 $1,972.8 $2,168.5 $2,555.9 $3,070.5 $3,698.8 $5,299.6 $6,757.1 $6,852.0 Balance Sheet Assets US$
Accruals Ratio -6.68% 7.56% -1.60% 1.74% -1.75% 1.99% 3.69% 13.58% 5.05% 22.37% 18.56% 24.20% 6.95% 18.56% <-Median-> 5 Ratio US$
Financial Cash Flow -$33.23 -$44.87 -$5.84 $152.43 -$78.19 -$103.96 -$29.76 -$83.89 $237.64 $264.49 $1,066.76 $263.03 $158.42 155.43 <-Median-> 10 EPS/CF Ratio US$
-$71.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $115.0
-$285.1 $0.0 $0.0 $0.0 $0.0 $115.0
-$25.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $424.2
-$165.9 $0.0 $0.0 $0.0 $0.0 $424.2
Change in Close CDN$ 110.25% 20.35% 15.86% 2.38% 6.73% -8.00% 18.10% 9.86% 8.04% 24.00% 18.07% 35.30% -34.46% 7.41% 0.00% count 21 Change in Close CDN$
up/down up down Down Down Down Down Down Down count 9 CDN$
Meet Prediction? Yes Yes % right count 2 22.22% CDN$
Financial Cash Flow CDN$ -$126.63 -$126.63 -$5.84 $162.13 -$90.71 -$143.96 -$39.96 -$105.24 $324.18 $343.53 $1,358.20 $333.48 $214.56 C F Statement  Financial CF CDN$
Total Accruals -$3.29 $219.16 -$13.71 -$121.76 $53.84 $183.15 $120.06 $452.43 -$169.22 $483.96 -$374.61 $1,301.72 $261.54 Accruals CDN$
Accruals Ratio -0.17% 17.52% -1.13% -4.93% 2.20% 6.70% 4.12% 14.11% -4.04% 10.07% -5.55% 15.20% 2.82% 2.82% <-Median-> 5 Ratio CDN$
Cash US$ $85.41 $55.96 $51.16 $89.81 $100.19 $86.05 $183.37 $55.02 $482.51 $229.96 $652.91 $317.49 $99.73 $116.52 Cash US$
Cash CDN$ $85.15 $57.15 $51.07 $95.52 $116.23 $119.16 $246.22 $69.02 $658.25 $298.68 $831.28 $402.51 $135.08 $157.60 Cash CDN$
Cash per Share $1.82 $1.22 $1.09 $2.03 $2.47 $2.53 $5.22 $1.47 $14.41 $5.53 $13.48 $6.13 $2.12 $2.47 $6.13 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 6.73% 3.74% 2.89% 5.26% 5.99% 6.68% 11.66% 2.99% 27.08% 8.37% 17.30% 5.81% 3.07% 3.33% 8.37% <-Median-> 5 % of Stock Price CDN$
Notes:
September 17, 2023.  Last estimates were for 2022, 2023 and 2024 of $443M, $483M and $515M for Revenue, $3.93, $4.16 and $4.52 for AFFO, $4.30, 
$4.54 and $4.93 for FFO, $3.10, $3.14 and $3.31 for Dividends, -$374 and $17 for 2022/3 for FCF, and $525M, $312M and $327M for Net Income.
September 19, 2022.  Last estimates were for 2021 and 2022 of $391M and 437M for Revenue, $3.65 and $4.16 for AFFO, $3.94 and $4.47 for FFO, 
$3.00, $3.05 and $3.18 for Dividends for 2021-23, $-299M and -$37M for FCF.
September 12, 2021.  Last estimates were for 2020, 2021 and 2022 in CDN$ of $330M, $362M and $378M for Revenue, $3.52, $3.87 and $4.00 for AFFO, 
$3.89, $4.16 and $4.30 for FFO, $2.91, $2.97 and $3.05 for dividends, -$84M, -$88M and 19M for FCF.
September 20, 2020.  Last estimates were for 2019,  2020 asnd 2021 of $272M amd 309M CDN$ for 2019 and 2020, $3.28, $3.63 and $3.73 for AFFO CDN$, 
$3.53, $3.96 and $4.02 for FFO CDN$, $2.80, $2.85 amd $2.88 for Dividends CDN$.
September 22, 2019.  Last estimates were for 2018 and 2019 of $261M and $279M for Revenue CDN$, $294, 3.09and 3.28 AFFO CDN$, $3.59 and 3.48 and $3.71 FFO CDN$
On January 15, 2019, immediately following the issuance of the stapled units, the stapled units were consolidated such that each unitholder held the same number of stapled 
units after the consolidation as each unitholder held prior to the special distribution.  I do not believe I need do any split or consolidation on this distribution of units.
December 31, 2018.  special distribution of CDN$1.200 per stapled unit, which will comprise CDN$0.300 per stapled unit payable in cash and CDN$ 0.900 per stapled unit payable by the issuance 
of stapled units based on the closing market price of the stapled units on the Toronto Stock Exchange on December 31, 2018.
September 28, 2018.  Last estimates were for 2017, 2018 and 2019 of $220M, $231M and $250M for Revenue CDN$, $3.09, $3.32 and $3.52 AFFO CDN$, $3.23, $3.62 and $3.83 FFO CDN$.
October 1, 2017.  Last estimates were for 2016 and 2017 of $223M and $228M for Revenue, $3.16, $3.28 and 3.16 for AFFO for 2016, 2017 and 2018, $3.48 and $3.63 and 3.51 for FFO for 2016, 2017 and 2018.
September 29, 2016.  Last estimates were for 2015 and 2016 of $212M and $233M for Revenue, $3.23 and $3.45 for AFFO, $.49 and $3.72 for FFO.
October 4, 2015.  Last estimates were in CDN$ for 2014 and 2015 Revenue of 220M and $239M, $2.83, $3.05 and $3.30 for 2014, 15 and 16 for AFFO, $3.29 and 3.48 for FFO, $3.29 and $3.48 for EPS.
September 23, 2014.  Last estimates were for 2013 and 2014 of $188.6M and $196.9M for Revenue, $2.51 and $2.78 for AFFO, $3.02 and $3.32 for FFO, $2.98 and $3.08 for EPS.
September 7, 2013.  Last estimates were for 2012 and 2013 of $183.25M and $183.56M US$ for Revenue, $2.51 and $2.90 US$ for Earnings.
July 2012, no estimates.  Also compny changed name to Granite REIT and started to report in CDN$ rather than US$.
Drop in revenue because the Company’s Racing & Gaming Business and $20M was transferred to Stronach due to cancellation of Class B shares.
The company's Racing and & Gaming was called Magna Entertainment Corp. (MEC)
I am using, as most analysts are, the net income from continuing operations.  Net Income is $59.196M rather than total reported of $155.979M.
I am also using EPS for continued operations of $1.26 which is shares into $59.196M.  Not reported $3.32 as reported.
June 13, 2012.  Company changed name from MI Developments (TSX-MIM.A) to Granite Real Estate (TSX-GRT.UN; NYSE-GRP.U) Website changing from www.midevelopments.com. 
Feb 06, 2011.  I cannot find anyone following this stock to get estimates.
2008.  TD still has this stock as a buy, down from a Strong Buy when I first got it.  I am not sure if I should have this stock.
AP 2007.  It has underperformed general market and real estate market. I am not sure I should have this stock?
AP 2006.  I have not done badly on this stock. TD still has it as an action buy
AP 2005.  my IRR is down to 17%.  It was higher for awhile when the NY Hedge fund tried to change it into a Unit trust, but has come down as they did not get their way.  I voted against it.  TD has a buy rating on this stock.
AP 2005.  TD has a buy rating on this stock.  I will hold it for now.  In my RRSP acct. It pay a increasing dividend
AP 2004.  Same as in 2003. Since Aug 2003, my IRR is 24% 
AP 2003. This stock was a spin off of Magna.  I will keep it for now to see how it does.  I have trust in Magna.  2003
Funds From Operations - FFO
A figure used by real estate investment trusts (REITS) to define the cash flow from their operations. It is calculated by adding depreciation and amortization expenses to earnings, and sometimes quoted on a
per share basis.
The FFO-per-share ratio should be used in lieu of EPS when evaluating REITs and other similar investment trusts. Good for all real estate firms.
Separate company from Aug 2003
Sector:
Real Estate
What should this stock accomplish?
Would I buy this company and Why.
I would consider this REIT again.  However, it may be a dividend growth in the long term, but not in the short term.
Why am I following this stock. 
I first bought some of this stock in 2003 when it was called MI Developments (TSX-MIM.A).  It was a company connected with Frank Stronach and Magna.  TD bank also had an Action Buy Call (Strong Buy) on this stock.  
By the December 2006, it was doing well and my stock was up some 15% per year.  I bought some more.  The year of 2006 was the last time I did well on this stock.  It kept going down and I sold it in 2009; being discourage it would ever do well again.
Dividends
Dividends are paid monthly.  Dividends are declared for shareholders of record for one month and paid in the following month.  
For example, the dividend declared for shareholders on December 27, 2013 was paid on January 15, 2014.
Prior to 2013, dividends were paid quarterly, basically in cycle 3 in April, June, September and December.   Dividends changed to monthly in 2013.  Because of the timing of the dividends, 2013 only had 11 payments.
How they make their money
Granite Real Estate Investment Trust, or Granite, is a real estate investment trust engaged in the acquisition, development, ownership, and management of logistics, warehouse and 
industrial properties in North America and Europe. The vast majority of the company's assets are logistics and distribution warehouses and multipurpose buildings split fairly evenly 
amongst Canadian, Austrian, and U.S. locations. The company's tenant is Magna International, an automotive parts and systems manufacturer, which accounts for the majority of Granite's lease income.   
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield (dividends and erarnings) 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 %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2015 Sep 29 2016 Oct 1 2017 Sep 28 2018 Sep 25 2019 Sep 20 2020 Sep 12 2021 Sep 19 2022 Sep 17 2023
Gorrie, Kevan 0.015 0.03% 0.030 0.06% 0.052 0.08% 0.068 0.10% 0.086 0.13% 0.100 0.16% 15.93%
CEO - Shares - Amount $0.798 $2.006 $4.079 $7.172 $5.934 $7.389
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Forsayeth, Michael Peter 0.00% 0.010 0.02% 0.021 0.05% 0.000 0.00% CEO interim basis
CEO/CFO - Shares - Amount $0.000 $0.431 $1.053 $0.000 Last updated Apr 2018
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Ceased Insider
Options - amount $0.000 $0.000 $0.000 $0.000
Neto, Teresa 0.000 0.00% 0.001 0.00% 0.003 0.00% 0.007 0.01% 0.011 0.02% Not found 63.73%
CFO- Shares - Amount $0.000 $0.094 $0.330 $0.471 $0.828
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000
Konstantopoulos, Ilias 0.005 0.01% 0.005 0.01% Site says Konstantopoulo 
CFO- Shares - Amount $0.246 $0.285 is CFO in 2018
Options - percentage 0.000 0.00% 0.000 0.00% INK Says Forsayeth 2018
Options - amount $0.000 $0.000 Ceased Insider May 2019
Ramparas, Michael Anthony 0.008 0.01% 0.012 0.02% 49.72%
Officer - Shares - Amount $0.571 $0.917
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000
Kumer, Lorne 0.00% 0.003 0.01% 0.000 0.00% 0.005 0.01% 0.009 0.02% 0.016 0.03% 0.019 0.03% 0.025 0.04% 0.029 0.05% 16.75%
Officer - Shares - Amount $0.020 $0.125 $0.000 $0.292 $0.606 $1.229 $1.963 $1.710 $2.145
Options - percentage 0.02% 0.010 0.02% 0.000 0.00% 0.010 0.02% 0.010 0.02% 0.010 0.02% 0.010 0.01% 0.010 0.02% 0.010 0.02% 0.00%
Options - amount $0.380 $0.448 $0.000 $0.532 $0.649 $0.766 $1.036 $0.679 $0.730
Miller, Gerald 0.01% 0.005 0.01% 0.005 0.01% 0.005 0.01% 0.004 0.01% 0.004 0.01% 0.004 0.01% 0.004 0.01% 0.004 0.01% 0.00%
Director - Shares - Amount $0.171 $0.202 $0.222 $0.239 $0.292 $0.345 $0.466 $0.306 $0.328
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Marshall, Kelly John 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.003 0.00% 0.000 0.00% Not found 2017 - 2021 -100.00%
Chairman - Shares - Amt $0.000 $0.000 $0.000 $0.000 $0.000 $0.207 $0.000 Last Report March 14,2023
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% has 0 units #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Directors 7 9 12 9 9 10 10 10
Women 0% 0 0% 0 0% 1 8% 3 33% 3 33% 4 40% 4 40% 4 40%
Minorities 0% 0 0% 2 22% 2 17% 2 22% 2 22% 3 30% 3 30% 3 30%
Year 2014
Increase in O/S Shares 0.15% 0.000 0.00% 0.106 0.22% 0.022 0.05% 0.106 0.23% 0.020 0.04% 0.064 0.10% 0.051 0.08% 0.089 0.14% 0 for 2020 is correct
due to SO $2.971 $0.000 $4.752 $1.084 $5.640 $1.320 $4.986 $5.375 $6.148
Book Value $2.790 $0.000 $4.181 $0.977 $4.181 $1.207 $1.977 $2.164 $4.089
Insider Buying -$0.008 -$1.175 -$6.686 -$1.010 -$1.345 $1.224 -$0.102 -$0.908 -$1.024
Insider Selling $0.179 $0.833 $0.289 $8.036 $16.624 $0.000 $0.000 $0.000 $0.250
Net Insider Selling $0.171 -$0.342 -$6.397 $7.025 $15.279 $1.224 -$0.102 -$0.908 -$0.774
% of Market Cap 0.01% -0.02% -0.28% 0.29% 0.43% 0.03% 0.00% -0.02% -0.02%
Institutions/Holdings 74.93% 149 73.03% 169 71.49% 176 74.46% 20 0.00% 20 63.37% 20 55.84% 20 58.68% 20 62.78%
Total Shares Held 74.93% 34.379 73.12% 33.705 71.86% 34.168 74.79% 8.841 16.36% 36.654 67.81% 36.681 55.84% 38.387 60.26% 40.019 62.82%
Increase/Decrease 3 Mths 0.04% 3.593 11.67% 0.918 2.80% -0.863 -2.46% 0.179 2.06% 5.695 18.40% 1.863 5.35% 2.034 5.60% 0.621 1.58%
Starting No. of Shares 30.785 32.787 35.032 8.663 Top 20 30.959 Top 20 34.817 Top 20 36.353 Top 20 39.398 Top 20
Copyright © 2008 Website of SPBrunner. All rights reserved.
My stock