This report should not be construed as providing investment advice. It is for educational purposes only.  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 https://www.annualreports.com/Company/choice-properties-reit
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/
Choice Properties REIT TSX CHP.UN OTC PPRQF http://www.choicereit.ca/ Fiscal Yr: Dec 31
Year 12/31/11 12/30/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 12/31/26 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$1,064 <-12 mths -23.56%
Revenue* $318.5 $682.9 $743.1 $783.6 $829.8 $1,148.3 $1,288.6 $1,270.6 $1,292.3 $1,264.6 $1,309.2 311.03% <-Total Growth 10 Revenue Fin Statements
Net Revenue $238.8 $510.4 $550.9 $583.3 $621.2 $833.8 $920.4 $886.6 $912.0 $900.6 $940.1 293.76% <-Total Growth 10 Net Revenue
Revenue* $318.5 $682.9 $743.1 $783.6 $829.8 $1,148.3 $1,288.6 $1,270.6 $1,292.3 $1,339.5 $1,392.4 $1,450 $1,526 337.17% <-Total Growth 10 Revenue
Increase 114.41% 8.81% 5.45% 5.90% 38.37% 12.22% -1.39% 1.71% 3.65% 3.95% 4.14% 5.24% 15.90% <-IRR #YR-> 10 Revenue 337.17%
5 year Running Average $672 $838 $959 $1,064 $1,166 $1,268 $1,317 $1,349.0 $1,400.1 3.93% <-IRR #YR-> 5 Revenue 21.26%
Revenue per Share $0.86 $1.73 $1.82 $1.91 $2.01 $1.72 $1.84 $1.76 $1.79 $1.85 $1.92 $2.00 $2.11 11.87% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
Increase 101.61% 5.40% 4.81% 5.18% -14.39% 7.07% -4.46% 1.62% 3.63% 3.94% 4.14% 5.24% 9.47% <-IRR #YR-> 5 5 yr Running Average 57.21%
5 year Running Average $1.66 $1.84 $1.86 $1.85 $1.82 $1.79 $1.83 $1.86 $1.93 8.43% <-IRR #YR-> 10 Revenue per Share 124.54%
P/S (Price/Sales) Med 11.92 6.07 6.17 6.78 6.77 7.16 7.10 7.30 7.80 8.12 7.17 6.90 0.05 2.29% <-IRR #YR-> 5 Revenue per Share 11.96%
P/S (Price/Sales) Close 12.28 6.06 6.48 7.06 6.65 6.70 7.56 7.40 8.50 7.97 7.25 6.76 6.42 1.61% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
*Net Property Income in M CDN $  P/S Med 10 yr  7.13 5 yr  7.30 -5.25% Diff M/C -0.05% <-IRR #YR-> 5 5 yr Running Average -0.25%
-$318.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,392.4
-$1,148.3 $0.0 $0.0 $0.0 $0.0 $1,392.4
-$671.6 $0.0 $0.0 $0.0 $0.0 $0.0 $1,316.7
-$837.5 $0.0 $0.0 $0.0 $0.0 $1,316.7
-$0.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.92
-$1.72 $0.00 $0.00 $0.00 $0.00 $1.92
$604.8 <-12 mths 1.06%
$0.84 <-12 mths 0.97%
AFFO Amount $130.94 $285.24 $312.88 $330.25 $363.12 $356.49 587.695 566.469 586.506 581.752 598.432 357.03% <-Total Growth 10 AFFO Amount
AFFO*Basic $0.360 $0.746 $0.778 $0.807 $0.882 $0.866 $0.853 $0.801 $0.811 $0.804 $0.827 129.72% <-Total Growth 10 AFFO*Basic
AFFO*Diluted  $0.360 $0.745 $0.777 $0.805 $0.879 $0.827 $0.853 $0.800 $0.811 $0.804 $0.827 $0.93 $0.98 129.72% <-Total Growth 10 AFFO
Increase 106.94% 4.30% 4% 9.16% -5.89% 3.14% -6.21% 1.38% -0.86% 2.86% 12.45% 5.38% 10 0 10 Years of Data, AFFP, P or N 100.00%
AFFO Yield 3.4% 7.1% 6.6% 6.0% 6.6% 7.2% 6.1% 6.1% 5.3% 5.4% 5.9% 6.9% 7.2% 8.67% <-IRR #YR-> 10 AFFO 129.72%
5 year Running Average $0.71 $0.81 $0.83 $0.83 $0.83 $0.82 $0.82 $0.83 $0.87 0.00% <-IRR #YR-> 5 AFFO 0.00%
Payout Ratio 73.54% 87.25% 83.66% 85.09% 82.79% 89.48% 86.75% 92.50% 91.25% 92.04% 90.49% 80.65% 76.53% 2.33% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
5 year Running Average 83.50% 85.61% 85.55% 87.24% 88.43% 90.35% 90.56% 0.32% 0.31% 0.31% <-IRR #YR-> 5 5 yr Running Average 1.54%
Price/AFFO Median 28.38 14.08 14.46 16.07 15.46 14.89 15.32 16.05 17.19 18.69 16.69 14.87 0.10 15.75 <-Median-> 10 P/AFFO Med
Price/AFFO High 29.31 14.38 15.48 18.20 16.27 16.23 17.28 18.79 18.82 19.76 19.04 15.51 0.00 17.74 <-Median-> 10 P/AFFO High
Price/AFFO Low 27.44 13.79 13.44 13.95 14.65 13.54 13.35 13.31 15.56 17.61 14.34 14.24 0.00 13.87 <-Median-> 10 P/AFFO Low
Price/AFFO Close 29.22 14.05 15.19 16.73 15.19 13.93 16.31 16.26 18.73 18.36 16.87 14.56 13.82 16.28 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 29.08 15.84 17.34 16.58 13.11 16.82 15.25 18.99 18.20 17.35 16.37 14.56 17.08 <-Median-> 10 Trailing P/AFFO Close
Median Values DPR 10 Yrs 88.36% 5 Yrs   91.25% P/CF 5 Yrs   in order 16.69 18.82 14.34 16.87 -12.78% Diff M/C -7.59% Diff M/C 10 DPR 75% to 95% best
* Adjusted Funds From Operations
-$0.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.83
-$0.83 $0.00 $0.00 $0.00 $0.00 $0.83
-$0.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.82
-$0.81 $0.00 $0.00 $0.00 $0.00 $0.82
$736.8 <-12 mths 1.46%
$1.02 <-12 mths 1.79%
Calc FFO Basic $1.003 $1.076 $1.038 $0.987 $0.922 $0.954 $0.964 $1.003 Calc FFO Basic
Calc FFO Diluted $1.000 $1.072 $1.033 $0.987 $0.921 $0.954 $0.964 $1.003 Calc FFO Diluted
FFO $158.89 $348.97 $388.98 $410.14 $442.94 $603.84 $680.28 $652.01 $689.90 $697.73 $726.13 357.00% <-Total Growth 10 FFO
FFO*basic $0.437 $0.913 $0.967 $1.003 $1.076 $1.038 $0.987 $0.922 $0.954 $0.964 $1.003 129.52% <-Total Growth 10 FFO*basic
FFO*diluted $0.437 $0.912 $0.966 $1.000 $1.072 $1.033 $0.987 $0.921 $0.954 $0.964 $1.003 $1.03 $1.08 129.52% <-Total Growth 10 FFO*diluted
Increase 108.70% 5.92% 3.52% 7.20% -3.64% -4.45% -6.69% 3.58% 1.05% 4.05% 2.69% 4.85% 10 0 10 Years of Data, AFFP, P or N
FFO Yield 4.15% 8.71% 8.19% 7.42% 8.03% 8.97% 7.10% 7.08% 6.28% 6.53% 7.19% 7.61% 7.98% 8.66% <-IRR #YR-> 10 FFO 129.52%
5 year Running Average $0.88 $1.00 $1.01 $1.00 $0.99 $0.97 $0.97 $0.97 $1.01 -0.59% <-IRR #YR-> 5 FFO -2.90%
Payout Ratio 60.58% 71.27% 67.29% 68.50% 67.86% 71.64% 74.98% 80.35% 77.57% 76.76% 74.61% 72.82% 69.44% 1.61% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
5 year Running Average 67.87% 69.29% 70.04% 72.46% 74.24% 76.15% 76.79% 0.28% 0.27% -0.63% <-IRR #YR-> 5 5 yr Running Average -3.09%
Price/FFO Median 23.38 11.50 11.63 12.94 12.67 11.92 13.24 13.94 14.61 15.59 13.76 13.43 0.09 13.09 <-Median-> 10 Price/FFO Median
Price/FFO High 24.14 11.74 12.45 14.65 13.34 12.99 14.93 16.32 16.00 16.48 15.70 14.00 0.00 14.79 <-Median-> 10 Price/FFO High
Price/FFO Low 22.61 11.26 10.81 11.23 12.01 10.84 11.54 11.56 13.23 14.69 11.82 12.85 0.00 11.55 <-Median-> 10 Price/FFO Low
Price/FFO Close 24.07 11.48 12.22 13.47 12.45 11.15 14.09 14.13 15.92 15.31 13.91 13.15 12.54 13.69 <-Median-> 10 Price/FFO Close
Trailing P/FFO Close 23.96 12.94 13.94 13.35 10.75 13.47 13.18 16.49 15.47 14.47 13.50 13.15 13.70 <-Median-> 10 Trailing P/FFO Close
Median Values DPR 10 Yrs 73.12% 5 Yrs   76.76% P/CF 5 Yrs   in order 13.94 16.00 11.82 14.13 -5.71% Diff M/C DPR 75% to 95% best
* Funds From Operations
-$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.00
-$1.03 $0.00 $0.00 $0.00 $0.00 $1.00
-$0.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.97
-$1.00 $0.00 $0.00 $0.00 $0.00 $0.97
EPS Basic Calc $0.18 $0.52 -$0.39 -$0.55 $0.98 $1.12 -$0.84 $0.64 $0.03 $1.03 $1.10 496.43% <-Total Growth 10 EPS Basic
EPS Diluted* $0.18 $0.52 -$0.39 -$0.54 $0.98 $1.11 -$0.84 $0.64 $0.03 $1.03 $1.10 $1.00 $1.04 496.41% <-Total Growth 10 EPS Diluted
Increase 182.62% -173.93% -41.04% 280.33% 13.27% -175.91% 175.50% -95.00% 3132.99% 7.02% -9.17% 4.00% 7 3 10 Years of Data, EPS P or N 70.00%
Earnings Yield 1.75% 4.98% -3.27% -4.04% 7.35% 9.65% -6.06% 4.89% 0.21% 6.97% 7.89% 7.39% 7.68% 19.55% <-IRR #YR-> 10 Earnings per Share 496.41%
5 year Running Average $0.15 $0.34 $0.06 $0.27 $0.38 $0.39 $0.39 $0.76 $0.84 -0.18% <-IRR #YR-> 5 Earnings per Share -0.92%
10 year Running Average $0.08 $0.19 $0.10 $0.17 $0.17 $0.27 $0.36 $0.41 $0.55 17.11% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
* Diluted ESP per share  E/P 10 Yrs 4.94% 5Yrs 4.89% 3.03% <-IRR #YR-> 5 5 yr Running Average 16.07%
-$0.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.10
-$1.11 $0.00 $0.00 $0.00 $0.00 $1.10
-$0.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.39
-$0.34 $0.00 $0.00 $0.00 $0.00 $0.39
Dividend Estimates $0.76 $0.76 Estimates Dividend Estimates
Increase 1.02% 0.79% Estimates Increase
Payout Ratio EPS 75.60% 73.27% Estimates Payout Ratio EPS
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 <-Median-> 10 Special Dividends Dividend
Dividend* $0.26 $0.65 $0.65 $0.69 $0.73 $0.74 $0.74 $0.74 $0.74 $0.74 $0.75 $0.75 $0.75 $0.75 182.66% <-Total Growth 10 Dividends Low
Increase 0.00% 0.00% 5.38% 6.20% 1.72% 0.00% 0.00% 0.00% 0.00% 1.13% 0.22% 0.00% 0.00% 4 0 10 Years of data Moderate
Average Increases 5 Year Running 2.32% 2.66% 2.66% 2.66% 1.58% 0.34% 0.23% 0.27% 0.27% 0.27% 2.32% <-Median-> 7 Average Incr 5 Year Running Good
Dividends 5 Yr Running $0.60 $0.69 $0.71 $0.73 $0.74 $0.74 $0.74 $0.74 $0.75 $0.75 24.56% <-Total Growth 6 Dividends 5 Yr Running
Yield H/L Price 2.59% 6.20% 5.79% 5.29% 5.36% 6.01% 5.66% 5.76% 5.31% 4.93% 5.42% 5.42% 5.54% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 2.51% 6.07% 5.40% 4.68% 5.09% 5.51% 5.02% 4.92% 4.85% 4.66% 4.75% 5.20% 4.97% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 2.68% 6.33% 6.23% 6.10% 5.65% 6.61% 6.50% 6.95% 5.86% 5.23% 6.31% 5.66% 6.27% <-Median-> 10 Yield on Low Price AFFO
Yield on Close Price 2.52% 6.21% 5.51% 5.09% 5.45% 6.42% 5.32% 5.69% 4.87% 5.01% 5.36% 5.54% 5.54% 5.04% 5.41% <-Median-> 10 Yield on Close Price FFO
Payout Ratio EPS 143.43% 124.60% 0.00% 0.00% 74.16% 66.60% 0.00% 116.21% 2325.79% 71.94% 67.97% 75.00% 69.96% <-Median-> 10 DPR EPS CFPS
DPR EPS 5 Yr Running 393.00% 205.00% 1110.44% 270.78% 192.33% 188.30% 189.71% 97.90% 205.00% <-Median-> 7 DPR EPS 5 Yr Running FCF 1
Payout Ratio CFPS 11.81% 12.18% 11.36% 11.95% 13.60% 30.11% 39.55% 47.15% 43.75% 46.26% 46.14% 46.24% 34.83% <-Median-> 10 DPR CF FCF 2
DPR CF 5 Yr Running 12.21% 14.04% 16.76% 21.40% 28.50% 40.27% 44.39% 45.88% 21.40% <-Median-> 7 DPR CF 5 Yr Running
Payout Ratio CFPS WC 11.05% 12.84% 12.11% 12.04% 11.97% 22.32% 26.43% 34.86% 33.53% 33.62% 32.09% 32.16% 24.37% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 12.10% 13.53% 15.24% 18.16% 22.32% 29.26% 31.80% 33.21% 18.16% <-Median-> 7 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 5.54% 5.41% 5 Yr Med 5 Yr Cl 5.42% 5.32% 5 Yr Med Payout 71.94% 46.14% 33.53% 0.22% <-IRR #YR-> 5 Dividends 1.13%
* Dividends per share  10 Yr Med and Cur. -0.06% 2.45% 5 Yr Med and Cur. 2.18% 4.12% Last Div Inc ---> $0.0617 $0.0625 1.35% 1.42% <-IRR #YR-> 10 Dividends 182.66%
Dividends Growth 15 #NUM! <-IRR #YR-> 15 Dividends #DIV/0!
Dividends Growth 20 #NUM! <-IRR #YR-> 20 Dividends #DIV/0!
Dividends Growth 5 -$0.74 $0.00 $0.00 $0.00 $0.00 $0.75 Dividends Growth 5
Dividends Growth 10 -$0.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.75 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 $0.75 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 $0.75 Dividends Growth 20
Historical Dividends Historical High Div 6.88% Low Div 2.94% 10 Yr High 6.91% 10 Yr Low 4.66% Med Div 5.42% Close Div 5.36% Historical Dividends
High/Ave/Median Values Curr diff Exp. -19.49%     Exp. -19.84% 18.87% Cheap 2.20% Cheap 3.26% High/Ave/Median 
Future Dividend Yield Div Yd 5.60% earning in 5 Years at IRR of 0.22% Div Inc. 1.13% Future Dividend Yield
Future Dividend Yield Div Yd 5.66% earning in 10 Years at IRR of 0.22% Div Inc. 2.26% Future Dividend Yield
Future Dividend Yield Div Yd 5.73% earning in 15 Years at IRR of 0.22% Div Inc. 3.42% Future Dividend Yield
Future Dividend Paid Div Paid $0.76 earning in 5 Years at IRR of 0.22% Div Inc. 1.13% Future Dividend Paid
Future Dividend Paid Div Paid $0.77 earning in 10 Years at IRR of 0.22% Div Inc. 2.26% Future Dividend Paid Item
Future Dividend Paid Div Paid $0.78 earning in 15 Years at IRR of 0.22% Div Inc. 3.42% Future Dividend Paid Revenue Growth 
FFO Growth
Dividend Covering Cost Total Div $3.77 over 5 Years at IRR of 0.22% Div Cov. 27.82% Dividend Covering Cost Net Income Growth
Dividend Covering Cost Total Div $6.82 over 10 Years at IRR of 0.22% Div Cov. 50.35% Dividend Covering Cost Cash Flow Growth
Dividend Covering Cost Total Div $9.90 over 15 Years at IRR of 0.22% Div Cov. 73.14% Dividend Covering Cost Dividend Growth
Stock Price Growth
CDN REIT to Choice Div Gr 147.09% 9/28/06 # yrs -> 18 2006 $6.16 Cap Gain 119.85% CDN REIT to Choice
org yield 4.93% 12/31/24 Pension Div G Yrly 5.08% Div start $0.30 -4.93% 12.18% Revenue Growth 
FFO Growth
Yield if held 5 years 7.24% 7.05% 6.59% 5.72% 5.45% 6.08% 5.74% 5.84% 5.38% 6.33% <-Median-> 6 Paid Median Price Net Income Growth
Yield if held 10 years 7.33% 7.15% 6.68% 5.80% 7.33% <-Median-> 1 Paid Median Price Cash Flow Growth
Yield if held 15 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price Dividend Growth
Yield if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price Stock Price Growth
BMO, EMP
Cost covered if held 5 years 33.80% 33.77% 32.33% 28.50% 27.24% 30.12% 28.46% 29.04% 26.82% 31.23% <-Median-> 6 Paid Median Price
Cost covered if held 10 years 70.10% 69.22% 65.52% 57.39% 70.10% <-Median-> 1 Paid Median Price
Cost covered if held 15 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $1,148.3 $1,288.6 $1,270.6 $1,292.3 $1,339.5 $1,392.4 21.26% <-Total Growth 5 Revenue Growth  21.26%
FFO Growth $1.03 $0.99 $0.92 $0.95 $0.96 $1.00 $1.02 <-12 mths 1.79% -2.90% <-Total Growth 5 FFO Growth -2.90%
Net Income Growth $649.6 -$581.4 $450.7 $23.0 $744.3 $796.7 $663.61 <-12 mths -16.70% 22.65% <-Total Growth 5 Net Income Growth 22.65%
Cash Flow Growth $683.6 $580.6 $621.2 $669.4 $633.2 $642.0 -6.09% <-Total Growth 5 Cash Flow Growth -6.09%
Dividend Growth $0.74 $0.74 $0.74 $0.74 $0.74 $0.75 $0.75 <-12 mths 0.22% 1.13% <-Total Growth 5 Dividend Growth 1.13%
Stock Price Growth $11.52 $13.91 $13.01 $15.19 $14.76 $13.95 21.09% <-Total Growth 5 Stock Price Growth 21.09%
Revenue Growth  $318.5 $682.9 $743.1 $783.6 $829.8 $1,148.3 $1,288.6 $1,270.6 $1,292.3 $1,339.5 $1,392.4 $1,450 <-this year 4.14% 337.17% <-Total Growth 10 Revenue Growth  337.17%
FFO Growth $0.44 $0.91 $0.97 $1.00 $1.07 $1.03 $0.99 $0.92 $0.95 $0.96 $1.00 $1.03 <-this year 2.69% 129.52% <-Total Growth 10 FFO Growth 129.52%
Net Income Growth $67.1 $199.6 -$155.3 -$223.1 $404.4 $649.6 -$581.4 $450.7 $23.0 $744.3 $796.7 $724 <-this year -9.17% 1086.47% <-Total Growth 10 Net Income Growth 1086.47%
Cash Flow Growth $196.3 $476.4 $520.6 $530.6 $504.3 $683.6 $580.6 $621.2 $669.4 $633.2 $642.0 226.99% <-Total Growth 10 Cash Flow Growth 226.99%
Dividend Growth $0.26 $0.65 $0.65 $0.69 $0.73 $0.74 $0.74 $0.74 $0.74 $0.74 $0.75 $0.76 <-this year 1.02% 182.66% <-Total Growth 10 Dividend Growth 182.66%
Stock Price Growth $10.52 $10.47 $11.80 $13.47 $13.35 $11.52 $13.91 $13.01 $15.19 $14.76 $13.95 $13.54 <-this year -2.94% 32.60% <-Total Growth 10 Stock Price Growth 32.60%
Dividends on Shares $62.40 $62.40 $65.76 $69.84 $71.04 $71.04 $71.04 $71.04 $71.04 $71.84 $72.00 $72.00 $72.00 $562.64 No of Years 10 Total Dividends 12/31/13
Paid  $1,009.92 $1,005.12 $1,132.80 $1,293.12 $1,281.60 $1,105.92 $1,335.36 $1,248.96 $1,458.24 $1,416.96 $1,339.20 $1,299.84 $1,299.84 $1,428.48 $1,339.20 No of Years 10 Worth $10.52
Total $1,901.84 Total
Graham Number based on FFO $9.89 $15.45 $14.19 $11.84 $15.41 $17.08 $14.87 $13.57 $13.40 $14.48 $15.78 $15.98 $16.36 59.57% <-Total Growth 10 Graham Number on FFO
Increase 56.22% -8.14% -16.56% 30.10% 10.85% -12.93% -8.78% -1.23% 8.05% 9.02% 1.24% 2.40% 3.41% <-Median-> 10 Graham Price
Price/GP Ratio Med $1.03 $0.68 $0.79 $1.09 $0.88 $0.72 $0.88 $0.95 $1.04 $1.04 $0.87 $0.87 $0.01 0.88 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High $1.07 $0.69 $0.85 $1.24 $0.93 $0.79 $0.99 $1.11 $1.14 $1.10 $1.00 $0.90 $0.00 0.99 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low $1.00 $0.66 $0.74 $0.95 $0.84 $0.66 $0.77 $0.79 $0.94 $0.98 $0.75 $0.83 $0.00 0.78 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close $1.06 $0.68 $0.83 $1.14 $0.87 $0.67 $0.94 $0.96 $1.13 $1.02 $0.88 $0.85 $0.83 0.91 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 6.37% -32.24% -16.87% 13.73% -13.36% -32.56% -6.47% -4.10% 13.37% 1.96% -11.61% -15.26% -17.24% -9.04% <-Median-> 10 Graham Price
Based on EPS 3 yrs trailing $4.01 $7.01 $3.87 $3.17 $2.20 $10.77 $9.14 $7.55 $7.87 $11.85 $13.36 $13.26 based on EPS 3 yrs trailing Graham Number
Graham Number $6.43 $11.69 $10.43 $8.55 $14.74 $17.72 $11.95 $11.28 $2.45 $14.95 $16.53 $15.74 $16.06 157.23% <-Total Growth 10 Graham Number
Increase 81.79% -10.74% -17.99% 72.31% 20.18% -32.57% -5.57% -78.31% 511.14% 10.57% -4.79% 1.98% 2.50% <-Median-> 10 Graham Price
Price/GP Ratio Med 1.03 0.90 1.08 1.51 0.92 0.69 1.09 1.14 5.70 1.00 0.83 0.88 0.01 1.04 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 1.64 0.92 1.15 1.71 0.97 0.76 1.23 1.33 6.24 1.06 0.95 0.92 0.00 1.11 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 1.54 0.88 1.00 1.31 0.87 0.63 0.95 0.94 5.16 0.95 0.72 0.84 0.00 0.95 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 1.64 0.90 1.13 1.57 0.91 0.65 1.16 1.15 6.21 0.99 0.84 0.86 0.84 1.06 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 63.66% -10.40% 13.13% 57.46% -9.43% -34.97% 16.45% 15.34% 520.78% -1.30% -15.63% -13.99% -15.66% 5.91% <-Median-> 10 Graham Price
Month, Year Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25 Dec-26 10.00 <Count Years> 10 Month, Year
Price Close $10.52 $10.47 $11.80 $13.47 $13.35 $11.52 $13.91 $13.01 $15.19 $14.76 $13.95 $13.54 $13.54 $14.88 32.60% <-Total Growth 10 Stock Price
Increase -0.48% 12.70% 14.15% -0.89% -13.71% 20.75% -6.47% 16.76% -2.83% -5.49% -2.94% 0.00% 9.90% 53.00 <-Median-> 10 CAPE (10 Yr P/E)
P/E Ratio 56.99 20.07 -30.59 -24.76 13.61 10.37 -16.49 20.43 477.41 14.35 12.67 13.54 13.02 #DIV/0! 3.90% <-IRR #YR-> 5 Stock Price 21.09%
Trailing P/E Ratio 56.72 22.62 -34.92 -24.54 11.74 12.52 -15.43 23.85 463.90 13.56 12.30 13.54 14.31 2.86% <-IRR #YR-> 10 Stock Price 32.60%
CAPE (10 Yr P/E) 38.06 82.94 58.99 66.85 47.02 36.12 32.67 24.58 #DIV/0! 9.90% <-IRR #YR-> 5 Price & Dividend 59.71%
Median 10, 5 Yrs D.  per yr 6.03% 6.00% % Tot Ret 67.80% 67.46% T P/E 13.04 13.56 P/E:  13.14 14.35 8.89% <-IRR #YR-> 10 Price & Dividend 103.19%
Price 15 CAPE Diff -74.45% #NUM! <-IRR #YR-> 15 Stock Price #DIV/0!
Price  20 #NUM! <-IRR #YR-> 20 Stock Price #DIV/0!
Price & Dividend 15 #NUM! <-IRR #YR-> 15 Price & Dividend #DIV/0!
Price & Dividend 20 #NUM! <-IRR #YR-> 20 Price & Dividend #DIV/0!
Price  5 -$11.52 $0.00 $0.00 $0.00 $0.00 $13.95 Price  5 TD bank
Price 10 -$10.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.95 Price 10
Price & Dividend 5 -$11.52 $0.74 $0.74 $0.74 $0.74 $14.70 Price & Dividend 5
Price & Dividend 10 -$10.52 $0.65 $0.65 $0.69 $0.73 $0.74 $0.74 $0.74 $0.74 $0.74 $14.70 Price & Dividend 10 to year 35
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 $13.95 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 $13.95 Price  20
Price & Dividend 15 $0.00 $0.00 $0.26 $0.65 $0.65 $0.69 $0.73 $0.74 $0.74 $0.74 $0.74 $0.74 $14.70 Price & Dividend 15
Price & Dividend 20 $0.00 $0.00 $0.26 $0.65 $0.65 $0.69 $0.73 $0.74 $0.74 $0.74 $0.74 $0.74 $14.70 Price & Dividend 20
Price H/L Median $10.22 $10.49 $11.24 $12.94 $13.59 $12.31 $13.07 $12.84 $13.94 $15.03 $13.81 $13.83 9.90% 35.14% <-Total Growth 10 Stock Price
Increase 2.69% 7.10% 15.18% 4.98% -9.39% 6.13% -1.72% 8.57% 7.78% -8.12% 0.18% 5.54% 3.06% <-IRR #YR-> 10 Stock Price 35.14%
P/E Ratio 55.34 20.11 -29.13 -23.79 13.85 11.08 -15.49 20.16 438.13 14.61 12.54 13.83 15.44% 2.32% <-IRR #YR-> 5 Stock Price 12.14%
Trailing P/E Ratio 56.83 21.54 -33.55 -24.97 12.55 11.76 -15.22 21.89 472.23 13.42 12.56 9.22% <-IRR #YR-> 10 Price & Dividend 107.84%
P/E on Running 5 yr Average 89.66 36.55 204.77 47.86 36.35 38.23 35.31 18.21 8.09% <-IRR #YR-> 5 Price & Dividend 48.28%
P/E on Running 10 yr Average 37.94 33.59 13.85 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 6.16% 5.77% % Tot Ret 66.83% 71.33% T P/E 12.98 13.42 P/E:  13.19 14.61 Count 10 Years of data
-$10.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.81
-$12.31 $0.00 $0.00 $0.00 $0.00 $13.81
-$10.22 $0.65 $0.65 $0.69 $0.73 $0.74 $0.74 $0.74 $0.74 $0.74 $14.55
-$12.31 $0.74 $0.74 $0.74 $0.74 $14.55
High Months Dec Dec Oct Jul Feb Jan Sep Feb Dec Mar Jan Jan
Price High $10.55 $10.71 $12.03 $14.65 $14.30 $13.42 $14.74 $15.03 $15.26 $15.89 $15.75 $14.42 49.29% <-Total Growth 10 Stock Price
Increase 1.52% 12.32% 21.78% -2.39% -6.15% 9.84% 1.97% 1.53% 4.13% -0.88% -8.44% 4.09% <-IRR #YR-> 10 Stock Price 49.29%
P/E Ratio 57.15 20.53 -31.19 -26.93 14.58 12.08 -17.48 23.60 479.61 15.45 14.31 14.42 3.25% <-IRR #YR-> 5 Stock Price 17.36%
Trailing P/E Ratio 58.02 23.06 -37.98 -26.29 13.68 13.27 -17.82 23.96 499.41 15.31 13.10 14.58 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 14.50 15.31 P/E:  14.44 15.45 43.73 P/E Ratio Historical High
-$10.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.75
-$13.42 $0.00 $0.00 $0.00 $0.00 $15.75
Low Months Sep Feb Jan Jan Aug Apr Jan Mar Feb Jan Oct Feb
Price Low $9.88 $10.27 $10.44 $11.23 $12.87 $11.20 $11.39 $10.65 $12.62 $14.16 $11.86 $13.24 20.04% <-Total Growth 10 Stock Price
Increase 3.95% 1.66% 7.57% 14.60% -12.98% 1.70% -6.50% 18.50% 12.20% -16.24% 11.64% 1.84% <-IRR #YR-> 10 Stock Price 20.04%
P/E Ratio 53.52 19.69 -27.07 -20.64 13.12 10.08 -13.50 16.72 396.64 13.77 10.77 13.24 1.15% <-IRR #YR-> 5 Stock Price 5.89%
Trailing P/E Ratio 55.64 20.01 -29.12 -23.66 11.42 10.25 -12.63 19.82 445.04 11.53 12.03 13.12 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 11.47 11.53 P/E:  11.95 13.77 -17.79 P/E Ratio Historical Low
-$9.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.86
Free Cash Flow MS $261.40 $472.05 $528.53 $530.24 $503.68 $405.19 $580.56 $621 $669 $668 $642 $22 145.60% <-Total Growth 10 Free Cash Flow
Change 80.59% 11.96% 0.32% -5.01% -19.55% 43.28% 6.97% 7.73% -0.15% -3.89% -96.57% 9.64% <-IRR #YR-> 5 Free Cash Flow MS 58.44%
FCF/CF from Op Ratio 1.33 0.99 1.02 1.00 1.00 0.59 1.00 1.00 1.00 1.06 1.00 0.03 9.40% <-IRR #YR-> 10 Free Cash Flow MS 145.60%
Dividends paid $22.02 $114.94 $230.49 $245.43 $262.86 $619.30 $390.09 $571.44 $462.96 $364.52 $245.07 $542.73 1013.09% <-Total Growth 10 Dividends paid
Percentage paid 8.42% 24.35% 43.61% 46.29% 52.19% 152.84% 67.19% 92.02% 69.20% 54.57% 38.17% 2466.98% $0.53 <-Median-> 10 Percentage paid
5 Year Coverage 38.14% 60.38% 68.60% 79.11% 82.99% 81.81% 63.95% 83.40% 5 Year Coverage
Dividend Coverage Ratio 11.87 4.11 2.29 2.16 1.92 0.65 1.49 1.09 1.45 1.83 2.62 0.04 1.87 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 2.62 1.66 1.46 1.26 1.20 1.22 1.56 1.20 5 Year of Coverage
Free Cash Flow WSJ $375.63 $377.94 $503.68 $405.19 $637.01 $653.73 $794.18 $701.23 $642 $22 70.91% <-Total Growth 8 Free Cash Flow WSJ
Change 0.61% 33.27% -19.55% 57.21% 2.62% 21.48% -11.70% -8.45% -96.57% 9.64% <-IRR #YR-> 5 Free Cash Flow MS
FCF/CF from Op Ratio 72.15% 71.23% 99.87% 59.27% 109.72% 105.24% 118.64% 110.75% 100.00% 3.43% 6.93% <-IRR #YR-> 8 Free Cash Flow MS
Dividends paid $230.49 $245.43 $262.86 $619.30 $390.09 $571.44 $462.96 $364.52 $245.07 $542.73 6.33% <-Total Growth 8 Dividends paid
Percentage paid 61.36% 64.94% 52.19% 152.84% 61.24% 87.41% 58.29% 51.98% 38.17% 2466.98% $0.61 <-Median-> 9 Percentage paid
5 Year Coverage 76.03% 81.05% 77.05% 75.46% 59.33% 77.73% 5 Year Coverage
Dividend Coverage Ratio 1.63 1.54 1.92 0.65 1.63 1.14 1.72 1.92 2.62 0.04 1.63 <-Median-> 9 Dividend Coverage Ratio
5 Year of Coverage 1.32 1.23 1.30 1.33 1.69 1.29 5 Year of Coverage
Market Cap in $M $3,910.2 $4,138.7 $4,815.2 $5,530.2 $5,518.6 $7,697.3 $9,740.5 $9,402.7 $10,988.1 $10,679.7 $10,094.9 $9,798.2 $9,798.2 $10,767.9 158.17% <-Total Growth 10 Market Cap 158.17%
Calc Average # Diluted 412.25 584.61 Problem is rounding.
Diluted # of Shares in Million 363.77 382.64 402.58 410.03 413.21 584.61 689.29 707.76 723.13 723.52 723.67 723.67 723.67 98.94% <-Total Growth 10 Diluted
Change 5.19% 5.21% 1.85% 0.77% 41.48% 17.91% 2.68% 2.17% 0.05% 0.02% 0.00% 0.00% 7.12% <-IRR #YR-> 10 Diluted
Difference Diluted/Basic 0.0% -0.1% -0.1% -0.2% -0.4% -0.4% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% -100.0% 4.36% <-IRR #YR-> 5 Diluted
Basic # of Shares in Millions 363.77 382.34 402.09 409.02 411.49 581.98 689.02 707.55 723.09 723.52 723.64 723.64 98.93% <-Total Growth 10 Basic
Change 5.11% 5.16% 1.72% 0.60% 41.43% 18.39% 2.69% 2.20% 0.06% 0.02% 0.00% 2.44% <-Median-> 10 Change
Difference Basic/Outstanding 2.18% 3.39% 1.49% 0.37% 0.46% 14.81% 1.63% 2.15% 0.04% 0.00% 0.00% 0.00% 0.97% <-Median-> 10 Difference
Unitholders' Equity
Exchangeable Units 284.075 306.032 317.110 317.989 319.081 389.962 389.962 326.942 327.589 327.771 327.860 327.860 327.860 327.860 15.41% <-Total Growth 10 Exchangeable Units
Trust Units 87.614 89.255 90.954 92.569 94.301 278.203 310.293 395.787 395.787 395.787 395.787 395.787 395.787 395.787 351.74% <-Total Growth 10 Trust Units
# of Share in Millions 371.689 395.287 408.064 410.557 413.382 668.164 700.255 722.728 723.375 723.558 723.646 723.646 723.646 723.646 6.89% <-IRR #YR-> 10 Shares 94.69%
Change 6.35% 3.23% 0.61% 0.69% 61.63% 4.80% 3.21% 0.09% 0.03% 0.01% 0.00% 0.00% 0.00% 1.61% <-IRR #YR-> 5 Shares 8.30%
Cash Flow from Operations $M $196.3 $476.4 $520.6 $530.6 $504.3 $683.6 $580.6 $621.2 $669.4 $633.2 $642.0 $642.0 <-12 mths 226.99% <-Total Growth 10 Cash Flow
Increase 142.64% 9.29% 1.92% -4.96% 35.56% -15.08% 7.00% 7.77% -5.42% 1.39% 0.00% <-12 mths Shares Iss SO
5 year Running Average $445.7 $543.1 $564.0 $584.1 $611.8 $637.6 $629.3 $641.5 <-12 mths 43.95% <-Total Growth 7 CF 5 Yr Running
CFPS $2.24 $5.34 $5.72 $5.73 $5.35 $2.46 $1.87 $1.57 $1.69 $1.60 $1.62 $1.62 <-12 mths -38.15% <-Total Growth 10 Cash Flow per Share UT
Increase 138.18% 7.25% 0.14% -6.70% -54.05% -23.86% -16.11% 7.77% -5.42% 1.39% 0.00% <-12 mths 12.58% <-IRR #YR-> 10 Cash Flow 226.99%
5 year Running Average $4.88 $4.92 $4.23 $3.40 $2.59 $1.84 $1.67 $1.62 <-12 mths -1.25% <-IRR #YR-> 5 Cash Flow -6.09%
P/CF on Med Price 4.56 1.97 1.96 2.26 2.54 5.01 6.98 8.18 8.24 9.39 8.51 8.53 <-12 mths -3.18% <-IRR #YR-> 10 Cash Flow per Share -27.62%
P/CF on Closing Price 4.69 1.96 2.06 2.35 2.50 4.69 7.43 8.29 8.98 9.23 8.60 8.35 <-12 mths -7.97% <-IRR #YR-> 5 Cash Flow per Share -33.99%
39.21% Diff M/C -16.35% <-IRR #YR-> 6 CFPS 5 yr Running #DIV/0!
Excl.Working Capital CF $13.6 -$24.4 -$32.6 -$3.9 $69.0 $238.9 $288.1 $218.9 $204.2 $238.0 $281.0 $0.0 <-12 mths -19.43% <-IRR #YR-> 5 CFPS 5 yr Running -66.04%
Cash Flow from Operations $M WC $209.9 $452.0 $488.1 $526.7 $573.3 $922.5 $868.7 $840.1 $873.6 $871.2 $923.0 $923.0 <-12 mths 339.64% <-Total Growth 10 Cash Flow less WC
Increase 115.30% 7.98% 7.92% 8.85% 60.91% -5.84% -3.29% 3.99% -0.28% 5.95% 0.00% <-12 mths 15.96% <-IRR #YR-> 10 Cash Flow less WC 339.64%
5 year Running Average $450.0 $592.5 $675.8 $746.2 $815.6 $875.2 $875.3 $886.2 <-12 mths 0.01% <-IRR #YR-> 5 Cash Flow less WC 0.05%
CFPS Excl. WC $2.40 $5.06 $5.37 $5.69 $6.08 $3.32 $2.80 $2.12 $2.21 $2.20 $2.33 $2.33 <-12 mths 11.73% <-IRR #YR-> 6 CF less WC 5 Yr Run #DIV/0!
Increase 111.34% 5.96% 6.03% 6.85% -45.46% -15.57% -24.18% 3.99% -0.28% 5.95% 0.00% <-12 mths 8.12% <-IRR #YR-> 5 CF less WC 5 Yr Run 47.73%
5 year Running Average $4.92 $5.10 $4.65 $4.00 $3.30 $2.53 $2.33 $2.24 <-12 mths -0.27% <-IRR #YR-> 10 CFPS - Less WC -2.68%
P/CF on Median Price 4.26 2.07 2.09 2.27 2.23 3.71 4.67 6.05 6.32 6.83 5.92 5.93 <-12 mths -6.80% <-IRR #YR-> 5 CFPS - Less WC -29.67%
P/CF on Closing Price 4.39 2.07 2.20 2.37 2.20 3.47 4.97 6.13 6.88 6.71 5.98 5.81 <-12 mths -11.69% <-IRR #YR-> 6 CFPS 5 yr Running #DIV/0!
*Operational Cash Flow. CF/-WC P/CF Med 10 yr 6.00 5 yr  8.24 P/CF Med 10 yr 4.19 5 yr  6.05 38.58% Diff M/C -14.49% <-IRR #YR-> 5 CFPS 5 yr Running -54.29%
-$2.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.62 Cash Flow per Share
-$2.46 $0.00 $0.00 $0.00 $0.00 $1.62 Cash Flow per Share
-$4.88 $0.00 $0.00 $0.00 $0.00 $0.00 $1.67 CFPS 5 yr Running
-$4.92 $0.00 $0.00 $0.00 $0.00 $1.67 CFPS 5 yr Running
-$209.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.00 $923.0 Cash Flow less WC
-$922.5 $0.0 $0.0 $0.0 $0.00 $923.0 Cash Flow less WC
-$450.0 $0.00 $0.00 $0.00 $0.00 $0.00 $875.3 CF less WC 5 Yr Run
-$592.5 $0.00 $0.00 $0.00 $0.00 $875.3 CF less WC 5 Yr Run
-$2.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.33 CFPS - Less WC
-$3.32 $0.00 $0.00 $0.00 $0.00 $2.33 CFPS - Less WC
OPM Ratio 61.64% 69.75% 70.06% 67.72% 60.77% 59.54% 45.05% 48.89% 51.80% 47.27% 46.10% 44.27% -33.70% <-Total Growth 10 OPM
Increase 13.16% 0.44% -3.35% -10.26% -2.04% -24.32% 8.51% 5.96% -8.75% -2.46% -3.97% Should increase  or be stable.
Diff from Median 10.7% 25.3% 25.9% 21.6% 9.2% 6.9% -19.1% -12.2% -6.9% -15.1% -17.2% -20.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 55.67% 5 Yrs 47.27% should be  zero, it is a   check on calculations
EBITDA Mkt Scrn $881.1 $902.8 $914.8 $905.1 $836.7 $1,016.0 $1,063.0 EBITDA Mkt Sc
Change 2.46% 1.33% -1.06% -7.56% 21.43% 4.63% Change
Margin 68.38% 71.05% 70.79% 67.57% 60.09% 70.07% 69.66% Margin
To Debt To Debt
Adjusted EBITDA (EBITDAFV) $225.8 $485.5 $537.9 $567.0 $602.9 $840.3 $942.5 $902.8 $929.0 $941.6 $1,000.5 $1,022.8 $1,000.5 343.18% <-Total Growth 10 EBITDAFV Company
Change #DIV/0! 115.05% 10.78% 5.42% 6.32% 39.38% 12.16% -4.21% 2.90% 1.36% 6.26% 2.22% 1077.52% 6.29% <-Median-> 10 Change
Margin 70.88% 71.09% 72.38% 72.36% 72.65% 73.18% 73.14% 71.05% 71.88% 70.29% 71.86% 70.53% 65.57% 72.12% <-Median-> 0 Margin
Long Term Debt & Class C Units $3,286.44 $3,436.63 $3,579.20 $3,726.99 $3,338.42 $5,566.92 $6,413.45 $6,485.52 $6,230.01 $6,294.10 $6,695.92 $6,695.92 Debt Type
Change 4.57% 4.15% 4.13% -10.43% 66.75% 15.21% 1.12% -3.94% 1.03% 6.38% 0.00% 4.14% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.84 0.83 0.74 0.67 0.60 0.72 0.66 0.69 0.57 0.59 0.66 0.68 0.67 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 24.76 21.01 12.03 13.99 9.22 17.89 30.36 55.08 62.34 62.92 66.08 66.08 25.68 <-Median-> 10 Assets/Current Liab Ratio Liquidity
Current Liabilities/Asset Ratio 0.04 0.05 0.08 0.07 0.11 0.06 0.03 0.02 0.02 0.02 0.02 0.02 0.04 <-Median-> 10 Current Liab/Asset Ratio Liq. + CF
Debt to Cash Flow (Years) 16.74 7.21 6.87 7.02 6.62 8.14 11.05 10.44 9.31 9.94 10.43 10.43 Debt Ratio
Leverage
Intangibles $30.00 $30.00 $29.00 $28.00 $21.37 $13.96 $13.96 -53.45% <-Total Growth 5 Intangibles D/E Ratio
Goodwill $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 #DIV/0! <-Total Growth 5 Goodwill
Total $30.00 $30.00 $29.00 $28.00 $21.37 $13.96 $13.96 -53.45% <-Total Growth 5 Total
Change 0.00% -3.33% -3.45% -23.68% -34.65% 0.00% -3.45% <-Median-> 5 Change
Intangible/Market Cap Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 <-Median-> 6 Intangible/Market Cap Ratio
Current Assets $152.3 $247.6 $323.5 $310.0 $332.1 $193.8 $369.8 $587.2 $553.5 $877.3 $1,045.6 $1,045.6 Liquidity ratio of 1.5 and up, best Quick Ratio + curr Mortgages
Current Liabilities $300.8 $390.0 $740.4 $674.5 $1,076.2 $869.0 $513.1 $284.1 $259.4 $267.3 $261.9 $261.9 0.68 <-Median-> 10 Ratio
Liquidity Ratio 0.51 0.63 0.44 0.46 0.31 0.22 0.72 2.07 2.13 3.28 3.99 3.99 2.13 <-Median-> 5 Ratio
Liq. with CF aft div 0.87 1.12 0.84 0.88 0.61 0.64 0.92 1.48 1.54 1.88 2.10 2.10 1.54 <-Median-> 5 Ratio If Div = 0
Liq. CF re  Inv+Div  0.38 0.38 0.32 0.32 0.24 0.14 0.36 0.72 0.70 1.09 1.30 1.30 0.72 <-Median-> 5 Ratio
Curr Long Term Debt $89.725 $0.993 $302.188 $201.723 $400.088 $496.036 $0.000 $0.000 $0.000 $0.000 $0.000 $0.0 Ratio
Liquidity Less CLTD 0.72 0.64 0.74 0.66 0.49 0.52 0.72 2.07 2.13 3.28 3.99 3.99 2.13 <-Median-> 5 Ratio
Liq. with CF aft div 1.13 1.12 1.20 1.11 0.86 1.01 0.92 1.48 1.54 1.88 2.10 2.10 1.54 <-Median-> 5 Ratio
Assets $7,447.7 $8,192.4 $8,905.9 $9,435.3 $9,923.5 $15,549.2 $15,576.2 $15,647.2 $16,172.6 $16,819.5 $17,308.7 $17,308.7 Debt Ratio of 1.5 and up, best Current Ratio
Liabilities $6,576.1 $7,154.0 $8,062.8 $8,858.2 $8,986.5 $12,049.2 $12,478.2 $12,124.7 $12,862.4 $12,995.4 $12,940.2 $12,940.2 1.25 <-Median-> 10 Ratio
Debt Ratio 1.13 1.15 1.10 1.07 1.10 1.29 1.25 1.29 1.26 1.29 1.34 1.34 1.29 <-Median-> 5 Ratio
Book Value $871.7 $1,038.4 $843.1 $577.1 $937.0 $3,500.0 $3,098.0 $3,522.5 $3,310.2 $3,824.2 $4,368.5 $4,368.5 401.18% <-Total Growth 10 Book Value
NCI 0.00 7.70 7.76 7.77 8.70 7.80 7.80 7.80 0.00 0.00 0.00 8.70 NCI
Net Book Value (Unitholders) $871.7 $1,038.4 $843.1 $577.1 $928.3 $3,492.2 $3,090.2 $3,514.7 $3,310.2 $3,824.2 $4,368.5 $4,359.8 $4,359.8 $4,359.8 401.18% <-Total Growth 10 Book Value
Book Value per share $9.95 $11.63 $9.27 $6.23 $9.84 $12.55 $9.96 $8.88 $8.36 $9.66 $11.04 $11.02 $11.02 $11.02 10.94% <-Total Growth 10 Book Value per Share UT
Increase 16.94% -20.33% -32.74% 57.89% 27.52% -20.66% -10.83% -5.82% 15.53% 14.23% -0.20% 0.00% 0.00% -6.30% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.03 0.90 1.21 2.08 1.38 0.98 1.31 1.45 1.67 1.56 1.25 1.26 1.31 P/B Ratio Historical Median
P/B Ratio (Close) 1.06 0.90 1.27 2.16 1.36 0.92 1.40 1.47 1.82 1.53 1.26 1.23 1.23 1.35 1.04% <-IRR #YR-> 10 Book Value per Share 10.94%
Change -14.89% 41.46% 69.71% -37.23% -32.33% 52.19% 4.89% 23.97% -15.89% -17.26% -2.75% 0.00% 9.90% -2.54% <-IRR #YR-> 5 Book Value per Share -12.07%
Leverage (A/BK) 8.54 7.89 10.56 16.35 10.69 4.45 5.04 4.45 4.89 4.40 3.96 3.97 4.45 <-Median-> 5 A/BV
Debt/Equity Ratio 7.54 6.89 9.56 15.35 9.68 3.45 4.04 3.45 3.89 3.40 2.96 2.97 3.45 <-Median-> 5 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/BV 10 yr Med 1.35 5 yr Med 1.45 -8.68% Diff M/C 5.04 Historical Leverage (A/BK)
-$9.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.04
-$12.55 $0.00 $0.00 $0.00 $0.00 $11.04
Total Comprehensive Income $67.15 $199.61 -$155.28 -$223.07 $405.35 $656.95 -$589.99 $446.96 $29.35 $755.82 $790.32
NCI $0.00 $0.00 $0.00 $0.00 $0.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Shareholders $67.15 $199.61 -$155.28 -$223.07 $404.42 $656.95 -$589.99 $446.96 $29.35 $755.82 $790.32 1076.98% <-Total Growth 10 Comprehensive Income
Increase 197.27% -177.79% -43.66% 281.29% 62.44% -189.81% 175.76% -93.43% 2475.11% 4.56% 4.56% <-Median-> 5 Comprehensive Income
5 Yr Running Average $59 $177 $19 $139 $190 $260 $286 12.44% <-IRR #YR-> 10 Comprehensive Income 1076.98%
ROE 7.7% 19.2% -18.4% -38.7% 43.6% 18.8% -19.1% 12.7% 0.9% 19.8% 18.1% 3.77% <-IRR #YR-> 5 Comprehensive Income 20.30%
5Yr Median 7.7% 18.8% -18.4% 12.7% 12.7% 12.7% 12.7% 30.29% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from Net Income 0.00% 0.00% 0.00% 0.00% 0.00% 1.13% -1.48% -0.83% 27.57% 1.55% -0.80% 10.17% <-IRR #YR-> 5 5 Yr Running Average 62.30%
Median Values Diff 5, 10 yr 0.0% -0.8% 12.7% <-Median-> 5 Return on Equity
-$67.1 -$199.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $790.3
-$656.9 $0.0 $0.0 $0.0 $0.0 $790.3
-$58.6 $0.0 $0.0 $0.0 $0.0 $0.0 $286.5
-$176.5 $0.0 $0.0 $0.0 $0.0 $286.5
Current Liability Coverage Ratio 0.70 1.16 0.66 0.78 0.53 1.06 1.69 2.96 3.37 3.26 3.52 3.52   CFO / Current Liabilities
5 year Median 0.78 0.78 1.06 1.69 2.96 3.26 3.37 1.43 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 2.82% 5.52% 5.48% 5.58% 5.78% 5.93% 5.58% 5.37% 5.40% 5.18% 5.33% 5.33% CFO / Total Assets
5 year Median 5.58% 5.58% 5.58% 5.58% 5.40% 5.37% 5.33% 5.5% <-Median-> 10 Return on Assets 
Return on Assets ROA 0.90% 2.44% -1.74% -2.36% 4.08% 4.18% -3.73% 2.88% 0.14% 4.42% 4.60% 4.18% Net  Income/Assets Return on Assets
5Yr Median 2.44% -1.74% 2.88% 2.88% 2.88% 2.88% 4.18% 2.7% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 7.70% 19.22% -18.42% -38.65% 43.57% 18.60% -18.81% 12.82% 0.70% 19.46% 18.24% 16.60% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 18.60% -18.42% 12.82% 12.82% 12.82% 12.82% 16.60% 15.5% <-Median-> 10 Return on Equity
$663.61 <-12 mths -16.70%
Net Income $67.15 $199.61 -$155.28 -$223.07 $405.35 $649.58 -$581.36 $450.69 $23.01 $744.25 $796.69
NCI $0.00 $0.00 $0.00 $0.00 $0.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Shareholders $67.15 $199.61 -$155.28 -$223.07 $404.42 $649.58 -$581.36 $450.69 $23.01 $744.25 $796.69 $723.7 $752.6 1086.47% <-Total Growth 10 Net Income
Increase 197.27% -177.79% -43.66% 281.29% 60.62% -189.50% 177.52% -94.89% 3134.76% 7.05% -9.17% 4.00% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $59 $175 $18.9 $140.0 $189.3 $257.2 $286.7 $547.7 $608.0 28.06% <-IRR #YR-> 10 Net Income 1086.47%
Operating Cash Flow $196.3 $476.4 $520.6 $530.6 $504.3 $683.6 $580.6 $621.2 $669.4 $633.2 $642.0 4.17% <-IRR #YR-> 5 Net Income 22.65%
Investment Cash Flow -$111.9 -$296.7 -$414.6 -$373.2 -$249.5 -$1,582.8 $61.6 $155.2 -$64.1 -$616.7 -$361.3 30.30% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
Total Accruals -$17.3 $19.9 -$261.4 -$380.5 $149.6 $1,548.8 -$1,223.5 -$325.7 -$582.3 $727.8 $516.1 10.37% <-IRR #YR-> 5 5 Yr Running Average 63.76%
Total Assets $7,447.7 $8,192.4 $8,905.9 $9,435.3 $9,923.5 $15,549.2 $15,576.2 $15,647.2 $16,172.6 $16,819.5 $17,308.7 Balance Sheet Assets
Accruals Ratio -0.23% 0.24% -2.93% -4.03% 1.51% 9.96% -7.85% -2.08% -3.60% 4.33% 2.98% -2.08% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.08 0.10 -0.07 -0.10 0.16 0.34 -0.30 0.30 0.01 0.47 0.47 0.13 <-Median-> 10 EPS/CF Ratio
-$67.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $796.7
-$649.6 $0.0 $0.0 $0.0 $0.0 $796.7
-$58.6 $0.0 $0.0 $0.0 $0.0 $0.0 $286.7
-$175.1 $0.0 $0.0 $0.0 $0.0 $286.7
Change in Close -0.48% 12.70% 14.15% -0.89% -13.71% 20.75% -6.47% 16.76% -2.83% -5.49% -2.94% 0.00% 9.90% Count 11 Years of data
up/down down up Count 2 18.18%
Meet Prediction? % right Count 0 0.00%
Financial Cash Flow -$33.0 -$229.8 -$63.1 $196.7 -$253.5 $9.2 -$630.9 -$611.1 -$728.2 -$36.0 -$92.9 C F Statement  Financial Cash Flow
Total Accruals $15.7 $249.7 -$198.3 -$577.2 $403.1 $1,539.6 -$592.6 $285.5 $145.9 $763.8 $609.0 Accruals
Accruals Ratio 0.21% 3.05% -2.23% -6.12% 4.06% 9.90% -3.80% 1.82% 0.90% 4.54% 3.52% 1.82% <-Median-> 5 Ratio
Cash $51.4 $1.3 $44.4 $5.1 $6.4 $30.7 $42.0 $207.2 $84.3 $64.7 $252.4 $252.4 <-12 mths Cash
Cash per Share $0.14 $0.00 $0.11 $0.01 $0.02 $0.05 $0.06 $0.29 $0.12 $0.09 $0.35 $0.35 $0.12 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.31% 0.03% 0.92% 0.09% 0.12% 0.40% 0.43% 2.20% 0.77% 0.61% 2.50% 2.58% 0.77% <-Median-> 5 % of Stock Price
Notes:
February 23, 2024.  Last estimates were for 2023 and 2024 of $1406M, $1471M for Net Revenue, $0.90, $0.95 for AFFO, $0.99 and $1.05 for FFO, 
$0.75 and $0.76 for Dividends, $21M and $22M for FCF.
February 18, 2023.  Last estimates were for 2022 and 2023 of $1362, $1403 for Revenue, 0.87, $0.96 for AFFO, $0.98 and $1.07 for FFO, $0.74 and $0.74 for Dividends, $14M and $18M for FCF.
January 19, 2021.  The Last estimates were for 2021 and 2022 of 1353M, $1396 for Revenue, $0.86 and $0.92 for AFFO, $0.96 and $1.03 for FFO, $0.74 and $0.74 for Dividends, $14M and $27M for FCF.
February 14, 2021.  Last estimates were for 2020 and 2021 of $1371M, and $1421M for Revenue, $0.90 and $0.94 for AFFO, $1.02and $1.04 for FFO, -$0.17 and $0.99 for EPS.
February 15, 2020.  Last estimates were for 2019 and 2020 of $1350M and $1396M for Revenue, $0.85and $0.88 for AFFO, $1.00 and $1.02 for FFO, $0.74 and $0.74 for Dividends.
February 16, 2019.  Last estimates were for 2018, and 2019 of $1167M and $1340M for revenue, $089 and $0.92 for AFFO, $1.03 and 1.05 for FFO.
July 2013.  This stock went public in July 2013
This company bought out CDN Real Estate.  With this acquition Choice issued 182,83481 Units priced at $11.25.
Trust Units:  Unit Holders have a single vote, entitled to Pro-rata share of distributions and ability to redeem units from choice Properties.
Exchangeable Units:  These unit holders have units economically equivalent to Trust Units, receive distributions equal to Trust Units and are exchangeable. to Trust Units.
Exchangeable Units are owned by Lloblaw.
Class C LP Units:  These were all convered to Units on acquisition of CREIT.
Sector:
Real Estate, REIT
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock. 
I am folloowing this stock because I own it.
Why I bought this stock.
I got this stock when CDN REIT was acquired by Choice Properties.  Choice was originally a spin off from Loblaws. Later George Weston Limited (TSX-WN) 
in a reorganization received Loblaw’s share of Choice (61.6% interest) and Loblaws minority shareholders got George Weston Limited shares.   The Weston 
Family owns a majority share in George Weston Ltd and George Weston Limited has a controlling interest in Loblaws.
Dividends
Dividends are paid monthly.  Dividends are declared in one month for shareholders of record and paid in the next month.
For example, the distributions declared on February 28, 2018 were paid on March 15, 2018.
Misson Statement or closes thing I can find.
What I am looking for is a statement that the company wants to do well by their customers, employees, and community and and thereby earn shareholders a reasonable return.
For customers 
For employees 
For community 
For investors 
How they make their money.
Choice Properties Real Estate Investment Trust invests in commercial retail, industrial, mixed-use and residential properties across Canada. The company's portfolio 
primarily consists of shopping centers anchored by supermarkets and stand-alone supermarkets. The properties are mostly located in Ontario and Quebec, followed by Alberta, Nova Scotia, British Columbia, and New Brunswick
by Alberta, Nova Scotia, British Columbia, and New Brunswick.
Shares; '%, Value $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 Update this each year?? Change
Date 2017 Aug 02 2018 Feb 16 2019 Feb 15 2020 Feb 14 2021 Feb 19 2022 Feb 18 2023 Feb 23 2024
Diamond, Rael Lee  0.389 0.06% 0.433 0.06% 0.435 0.06% 0.592 0.08% 0.700 0.10% 0.808 0.11% 0.925 0.13% Was officer, 2020 is CEO 14.50%
CEO - Shares - Amount $4.483 $6.017 $5.657 $0.000 $10.327 $11.272 $12.528
Options - percentage 0.000 0.00% 0.000 0.00% 0.053 0.01% 0.080 0.01% 0.119 0.02% 0.098 0.01% 0.081 0.01% -17.08%
Options - amount $0.000 $0.000 $0.695 $1.174 $1.755 $1.364 $1.098
Johnson, Stephen E. 0.100 0.01% 3.293 0.47% ceased as insider May 2019
CEO - Shares - Amount $1.152 $45.804
Options - percentage -2.481 -0.37% 0.000 0.00%
Options - amount -$28.586 $0.000
Barrafato, Mario 0.173 0.03% 0.208 0.03% 0.209 0.03% 0.229 0.03% 0.259 0.04% 0.284 0.04% 0.287 0.04% CFO re website 2018, 19 1.20%
CFO - Shares - Amount $1.995 $2.888 $2.714 $3.380 $3.818 $3.957 $3.887
Options - percentage 0.979 0.15% 0.000 0.00% 0.058 0.01% 0.069 0.01% 0.081 0.01% 0.028 0.00% 0.042 0.01% 49.60%
Options - amount $11.278 $0.000 $0.757 $1.014 $1.202 $0.389 $0.565
Collins, Niall Gerard 0.000 0.00% 0.023 0.00% #DIV/0!
CFO - Shares - Amount $0.000 $0.309
Options - percentage 0.008 0.00% 0.008 0.00% 0.00%
Options - amount $0.106 $0.103
Radic, Ana 0.000 0.00% 0.002 0.00% 0.005 0.00% 0.066 0.01% Last filed Nov 19 -100.00%
Officer - Shares - Amount $0.000 $0.032 $0.066 $0.924 Only one in Other Officers
Options - percentage 0.039 0.01% 0.057 0.01% 0.086 0.01% 0.053 0.01% -100.00%
Options - amount $0.511 $0.840 $1.272 $0.746
Cole, Simone Elizabeth Jasmine 0.006 0.00%
Officer - Shares - Amount $0.077
Options - percentage 0.023 0.00%
Options - amount $0.318
Clark, Christie James Beckett 0.028 0.00% 0.026 0.00% Ceased insider Apr 2023 -100.00%
Director - Shares - Amount $0.419 $0.356
Options - percentage 0.033 0.00% 0.040 0.01% -100.00%
Options - amount $0.480 $0.552
Eadie, Graeme 0.010 0.00% 0.010 0.00% 0.00%
Director - Shares - Amount $0.139 $0.135
Options - percentage 0.060 0.01% 0.076 0.01% 25.19%
Options - amount $0.843 $1.025
Kinsley, Karen A. 0.016 0.00% 0.016 0.00% 0.00%
Director - Shares - Amt $0.219 $0.212
Options - percentage 0.052 0.01% 0.066 0.01% 28.44%
Options - amount $0.721 $0.898
Currie, Gordon Andrew McDonald 0.027 0.00% 0.031 0.00% 0.032 0.00% 0.032 0.00% Was 10% holder 2021 0.83%
Chairman - Shares - Amt $0.397 $0.464 $0.442 $0.432 Chairman 2022
Options - percentage 0.000 0.00% 0.007 0.00% 0.020 0.00% 0.033 0.00% 68.97%
Options - amount $0.000 $0.107 $0.272 $0.447
Weston, Willard Galen Garfield 0.050 0.01% 0.050 0.01% 0.050 0.01%
Chairman - Shares - Amt $0.654 $0.737 $0.737
Options - percentage 0.065 0.01% 0.080 0.01% 0.088 0.01%
Options - amount $0.849 $1.184 $1.297
Increase in O/S Shares 0.065 0.02% 0.037 0.01% 1.517 0.23% 2.204 0.31% 0.308 0.04% 0.837 0.12% 0.404 0.06% 0.330 0.05%
Due to Stock Options $0.880 $0.499 $17.472 $30.657 $4.005 $12.355 $5.970 $4.600
Book Value $0.901 $0.361 $16.261 $31.136 $4.841 $9.332 $2.776 $1.362
Insider Buying $0.000 -$0.024 -$6.605 -$0.058 -$1.450 -$1.703 -$2.420 -$2.434
Insider Selling $0.000 $0.610 $2.791 $18.361 $0.354 $0.278 $0.000 $0.000
Net Insider Selling $0.000 $0.586 -$3.815 $18.303 -$1.097 -$1.425 -$2.420 -$2.434
Net Selling % of Market Cap 0.00% 0.01% -0.04% 0.19% -0.01% -0.01% -0.02% -0.02%
Directors 9 9 10 9 9 10 11
Women 2 22% 2 22% 4 40% 4 44% 4 44% 4 40% 5 45%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0% 1 10% 2 18%
Minorities
Institutions/Holdings 69 22.68% 99 33.33% 20 40.23% 20 17.68% 20 22.54% 20 22.54%
Total Shares Held 62.894 16.13% 92.721 13.24% 124.553 17.23% 57.931 8.01% 73.887 10.21% 0.000 0.00%
Increase/Decrease 3 Mths 48.798 346.19% -0.128 -0.14% -4.071 -3.16% -1.466 -2.47% 0.046 0.06% 0.046 -100.00%
Starting No. of Shares 14.096 92.848 128.624 59.397 73.841 -0.046
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock $1.30 4.93%