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
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Parkland Fuel Corp TSX: PKI OTC: PKIUF www.parkland.ca Fiscal Yr: Dec 31 Q1 2017
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G
Accounting Rules C GAAP C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$6,732 <-12 mths 7.44%
Revenue* $875.5 $1,199.9 $1,697.7 $2,348.1 $2,020.0 $2,913.4 $3,980.5 $4,133.6 $5,663.4 $7,527.6 $6,266.6 $6,266.0 $8,891 $13,314 $13,580 422.22% <-Total Growth 10 Revenue
Increase 27.51% 37.04% 41.49% 38.32% -13.97% 44.23% 36.63% 3.85% 37.01% 32.92% -16.75% -0.01% 41.89% 49.75% 2.00% 17.97% <-IRR #YR-> 10 Revenue 422.22%
5 year Running Average $613 $754 $1,005 $1,362 $1,628 $2,036 $2,592 $3,079 $3,742 $4,844 $5,514 $5,971 $6,923 $8,453 $9,664 9.50% <-IRR #YR-> 5 Revenue 57.42%
Revenue per Share $23.65 $31.10 $33.96 $47.28 $40.24 $54.80 $61.85 $60.81 $78.88 $91.67 $66.77 $65.11 $92.05 $137.85 $140.60 22.98% <-IRR #YR-> 10 5 yr Running Average 691.58%
Increase 26.30% 31.47% 9.21% 39.21% -14.88% 36.17% 12.87% -1.68% 29.71% 16.21% -27.17% -2.48% 41.38% 49.75% 2.00% 18.17% <-IRR #YR-> 5 5 yr Running Average 130.39%
5 year Running Average $17.04 $20.25 $24.61 $30.94 $35.25 $41.48 $47.63 $53.00 $59.32 $69.60 $72.00 $72.65 $78.90 $90.69 $100.48 7.67% <-IRR #YR-> 10 Revenue per Share 109.37%
P/S (Price/Sales) Med 0.28 0.32 0.43 0.23 0.25 0.21 0.17 0.26 0.23 0.22 0.35 0.39 1.03% <-IRR #YR-> 5 Revenue per Share 5.27%
P/S (Price/Sales) Close 0.28 0.41 0.48 0.14 0.33 0.21 0.21 0.31 0.23 0.24 0.35 0.43 0.33 0.22 0.22 13.63% <-IRR #YR-> 10 5 yr Running Average 258.83%
*Revenue in M CDN $  P/S Med 10 yr  0.24 5 yr  0.26 8.81% <-IRR #YR-> 5 5 yr Running Average 52.54%
-$1,199.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $6,266.0
-$3,980.5 $0.0 $0.0 $0.0 $0.0 $6,266.0
-$754 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,971
-$2,592 $0 $0 $0 $0 $5,971
-$31.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $65.11
-$61.85 $0.00 $0.00 $0.00 $0.00 $65.11
$0.45 <-12 mths -8.16%
EPS Basic $0.68 $1.52 $1.66 $0.88 $0.97 $0.58 $0.74 $1.28 $1.31 $0.66 $0.45 $0.50 -67.18% <-Total Growth 10 EPS Basic
EPS Diluted* $0.67 $1.51 $1.64 $0.88 $0.97 $0.58 $0.73 $1.22 $1.26 $0.66 $0.45 $0.49 $0.74 $1.04 $1.95 -67.48% <-Total Growth 10 EPS Diluted
Increase 531.25% 123.76% 8.85% -46.34% 10.23% -40.21% 25.86% 67.12% 3.28% -47.62% -31.82% 8.89% 51.02% 40.54% 87.50% -10.62% <-IRR #YR-> 10 Earnings per Share -67.48%
Earnings Yield 10.2% 11.7% 10.2% 13.8% 7.2% 5.0% 5.8% 6.4% 6.8% 3.0% 1.9% 1.7% 2.4% 3.4% 6.4% -7.66% <-IRR #YR-> 5 Earnings per Share -32.88%
5 year Running Average $0.38 $0.64 $0.90 $0.96 $1.13 $1.12 $0.96 $0.88 $0.95 $0.89 $0.86 $0.82 $0.72 $0.68 $0.93 2.47% <-IRR #YR-> 10 5 yr Running Average 27.63%
10 year Running Average $0.25 $0.39 $0.55 $0.63 $0.70 $0.75 $0.80 $0.89 $0.96 $1.01 $0.99 $0.89 $0.80 $0.81 $0.91 -3.20% <-IRR #YR-> 5 5 yr Running Average -15.00%
* Diluted ESP per share  E/P 10 Yrs 6.10% 5Yrs 3.04%
-$1.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.49
-$0.73 $0.00 $0.00 $0.00 $0.00 $0.49
-$0.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.82
-$0.96 $0.00 $0.00 $0.00 $0.00 $0.82
Dividend Paid in Cash  $22.6 $24.5 $27.2 $63.8 Dividend Paid in Cash 
As a Percentage of Net Inc 24.62% 49.07% 68.93% 135.17% 59.00% <-Median-> 4 As a Percentage of Net Inc
Comments
Pre-split 07 $0.00 $0.10 $2.70 Pre-split 07
Special Dividend $0.00 $0.03 $0.90 $0.77 $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 Dividend
Pre-split 07 $1.82 $2.21 $1.18 Pre-split 07
Dividend* $0.61 $0.74 $0.88 $1.26 $1.26 $1.26 $1.04 $1.0200 $1.0353 $1.0548 $1.0749 $1.1205 $1.1493 $1.1544 $1.1544 52.10% <-Total Growth 10 Dividends
Increase 5.81% 21.43% 19.62% 42.98% 0.00% 0.00% -17.46% -1.92% 1.50% 1.88% 1.91% 4.24% 2.57% 0.44% 0.00% 1.69% <-Median-> 10 Increase
Dividends 5 Yr Running $0.61 $0.86 $1.15 $1.29 $1.42 $1.47 $1.32 $1.12 $1.08 $1.05 $1.06 $1.09 72.82% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 9.03% 7.44% 6.01% 11.77% 12.63% 10.75% 9.79% 6.37% 5.75% 5.21% 4.57% 4.37% 3.93% 6.19% <-Median-> 10 Yield H/L Price
Yield on High  Price 7.79% 5.60% 4.94% 7.96% 9.38% 9.41% 8.09% 5.31% 5.13% 4.60% 3.99% 3.59% 3.57% 5.22% <-Median-> 10 Yield on High  Price
Yield on Low Price 10.74% 11.11% 7.69% 22.58% 19.35% 12.54% 12.41% 7.97% 6.55% 6.02% 5.33% 5.60% 4.36% 7.83% <-Median-> 10 Yield on Low Price
Yield on Close Price 9.15% 5.74% 5.46% 19.69% 9.40% 10.97% 8.20% 5.39% 5.61% 4.85% 4.62% 3.98% 3.79% 3.81% 3.81% 5.53% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 90.10% 51.11% 108.61% 230.68% 129.90% 217.24% 142.47% 83.61% 82.17% 159.82% 238.87% 228.67% 155.31% 111.00% 59.20% 151.14% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 96.04% 95.86% 119.86% 113.72% 127.34% 153.57% 150.91% 117.97% 121.58% 120.95% 130.04% 150.97% 0.00% 0.00% 121.26% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 64.51% 42.29% 107.49% 140.78% 56.27% 1498.92% 74.69% 50.84% 55.83% 50.60% 45.18% 65.24% 64.57% 48.50% 37.97% 60.75% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 59.82% 70.21% 86.06% 79.61% 98.04% 108.16% 92.27% 74.12% 72.89% 53.77% 52.83% 55.37% 0.00% 0.00% 76.86% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 65.38% 43.56% 78.09% 127.49% 71.64% 82.97% 62.23% 49.62% 48.06% 67.50% 72.58% 72.96% 64.57% 48.50% 37.97% 72.11% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 63.41% 65.39% 77.98% 77.43% 79.62% 83.56% 76.89% 61.31% 60.36% 58.54% 60.36% 63.84% 0.00% 0.00% 71.14% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 5.21% 4.85% 5 Yr Med Payout 159.82% 50.84% 67.50% 4.28% <-IRR #YR-> 10 Dividends 52.10%
* Dividends per share  5 Yr Med and Cur. -26.92% -21.50% Last Div Inc ---> $0.0945 $0.0962 1.8% 1.50% <-IRR #YR-> 5 Dividends 7.74%
2.67% <-IRR #YR-> 3 Dividends
-$0.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.12
-$1.04 $0.00 $0.00 $0.00 $0.00 $1.12
-$1.04 $0.00 $0.00 $1.12
Historical Dividends Historical High Div 20.65% Low Div 3.83% Ave Div 12.24% Med Div 8.94% Close Div 7.89% Historical Dividends
High/Ave/Median Values Curr diff Exp. -81.56% Exp -0.56% Exp. -68.88% Exp. -57.40% Exp. -51.73% High/Ave/Median 
Adjusted Historical Dividends Historical High Div 16.71% Low Div 3.83% Ave Div 10.27% Med Div 7.24% Close Div 6.39% $0.105 $0.085 Adjust. Historical Dividends
High/Ave/Median Values Curr diff Exp. -77.21% Exp -0.56% Exp. -62.91% Exp. -47.39% Exp. -40.37% 80.95% -19.05% High/Ave/Median 
Future Dividend Yield Div Yd 5.10% earning in 5.00 Years at IRR of 6.00% Div Inc. 33.82% Future Dividend Yield
Future Dividend Yield Div Yd 6.82% earning in 10.00 Years at IRR of 6.00% Div Inc. 79.08% Future Dividend Yield
Future Dividend Yield Div Yd 9.13% earning in 15.00 Years at IRR of 6.00% Div Inc. 139.66% Future Dividend Yield
H/LYield held 5 yrs 20.51% 22.27% 14.48% 23.86% 19.66% 18.76% 10.51% 6.96% 9.67% 10.57% 9.17% 10.55% 7.18% 6.41% 5.70% 10.56% <-Median-> 10 Paid Median Price
H/LYield held 10 yrs 29.57% 36.34% 45.13% 32.59% 42.59% 31.44% 16.76% 19.61% 16.46% 16.00% 11.32% 7.84% 10.78% 11.57% 25.52% <-Median-> 10 Paid Median Price
H/LYield held 15 yrs 41.74% 42.06% 37.09% 27.28% 36.33% 33.87% 18.89% 21.86% 18.01% 36.71% <-Median-> 6 Paid Median Price
H/LYield held 20 yrs 44.97% 47.39% 41.35% 29.86% 44.97% <-Median-> 1 Paid Median Price
H/LYield held 25 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost cover if held 5 years 77.75% 92.80% 70.52% 109.11% 100.59% 105.73% 74.49% 45.11% 52.45% 54.24% 44.58% 49.96% 33.96% 30.86% 27.93% 62.38% <-Median-> 10 Paid Median Price
Cost cover if held 10 years 123.21% 200.05% 246.49% 210.55% 317.79% 315.60% 179.15% 215.46% 184.99% 183.52% 128.11% 82.21% 104.34% 110.91% 205.30% <-Median-> 10 Paid Median Price
Cost cover if held 15 years 419.05% 472.63% 447.64% 350.47% 494.41% 475.97% 268.46% 320.65% 273.19% 460.13% <-Median-> 6 Paid Median Price
Cost cover if held 20 years 631.98% 696.74% 646.58% 496.68% 631.98% <-Median-> 1 Paid Median Price
Graham No. $4.88 $8.28 $12.41 $8.74 $9.11 $6.87 $8.55 $11.94 $13.14 $10.15 $9.36 $9.60 $11.79 $13.98 $19.14 15.88% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.38 1.19 1.18 1.22 1.10 1.71 1.24 1.34 1.37 1.99 2.51 2.67 2.48 1.36 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.60 1.59 1.44 1.81 1.48 1.95 1.50 1.61 1.54 2.26 2.87 3.26 2.73 1.71 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.16 0.80 0.92 0.64 0.71 1.46 0.98 1.07 1.20 1.73 2.15 2.09 2.23 1.14 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.36 1.55 1.30 0.73 1.47 1.67 1.48 1.59 1.41 2.14 2.49 2.93 2.57 2.17 1.58 1.54 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 36.02% 54.92% 30.11% -26.76% 47.13% 67.37% 48.48% 58.61% 40.62% 114.15% 148.75% 193.12% 157.03% 116.81% 58.33% 53.54% <-Median-> 10 Graham Price
Month, Year Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
Pre-split 07 $19.90 $38.49
Price Close $6.63 $12.83 $16.15 $6.40 $13.40 $11.49 $12.69 $18.93 $18.47 $21.74 $23.29 $28.13 $30.31 $30.31 $30.31 119.25% <-Total Growth 10 Stock Price
Increase -8.72% 93.42% 25.88% -60.37% 109.38% -14.25% 10.44% 49.17% -2.43% 17.70% 7.13% 20.78% 7.75% 0.00% 0.00% 8.17% <-IRR #YR-> 10 Stock Price 119.25%
P/E 9.85 8.52 9.85 7.27 13.81 19.81 17.38 15.52 14.66 32.94 51.76 57.41 40.96 29.14 15.54 17.26% <-IRR #YR-> 5 Stock Price 121.67%
Trailing P/E 62.19 19.05 10.72 3.90 15.23 11.85 21.88 25.93 15.14 17.25 35.29 62.51 61.86 40.96 29.14 16.31% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.  per yr 8.14% 6.28% % Tot Ret 49.92% 26.68% T P/E 25.93 P/E:  16.45 32.94 23.54% <-IRR #YR-> 5 Price & Dividend
-$12.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.13
-$12.69 $0.00 $0.00 $0.00 $0.00 $28.13
-$12.83 $1.78 $2.03 $1.26 $1.26 $1.04 $1.02 $1.04 $1.05 $1.07 $29.25
-$12.69 $1.02 $1.04 $1.05 $1.07 $29.25
Price H/L Median $6.72 $9.90 $14.65 $10.71 $9.98 $11.72 $10.62 $16.01 $18.00 $20.24 $23.54 $25.64 $29.25 159.07% <-Total Growth 10 Stock Price
Increase 4.78% 47.32% 48.07% -26.94% -6.82% 17.49% -9.39% 50.71% 12.46% 12.44% 16.28% 8.92% 14.10% 9.99% <-IRR #YR-> 10 Stock Price 159.07%
P/E 9.98 6.57 8.93 12.16 10.28 20.21 14.55 13.12 14.29 30.67 52.30 52.32 39.53 19.27% <-IRR #YR-> 5 Stock Price 141.38%
Trailing P/E 62.97 14.70 9.72 6.53 11.34 12.08 18.31 21.92 14.75 16.06 35.66 56.97 59.69 17.94% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 9.98 6.57 8.93 12.16 10.28 20.21 14.55 13.12 18.91 22.74 27.24 31.42 40.63 26.59% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 26.90 25.49 26.65 17.07 14.31 15.67 13.28 18.07 18.82 20.00 23.78 28.87 36.65 15.51 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 7.96% 7.32% % Tot Ret 44.34% 27.52% T P/E 21.92 P/E:  14.42 30.67 Count 21 Years of data
-$9.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.64
-$10.62 $0.00 $0.00 $0.00 $0.00 $25.64
-$9.90 $0.88 $1.26 $1.26 $1.26 $1.04 $1.02 $1.04 $1.05 $1.07 $26.76
-$10.62 $1.02 $1.04 $1.05 $1.07 $26.76
High Months Feb 05 Dec 06 Sep 07 Jan 08 Dec 09 Jan 10 Dec 11 Dec 12 Feb 13 Sep 14 Apr 15 Oct 16 May 17
Pre-split 07 $23.35 $39.47
Price High $7.78 $13.16 $17.85 $15.83 $13.44 $13.39 $12.86 $19.22 $20.19 $22.95 $26.91 $31.25 $32.15 137.52% <-Total Growth 10 Stock Price
Increase 7.11% 69.04% 35.67% -11.32% -15.10% -0.37% -3.96% 49.46% 5.05% 13.67% 17.25% 16.13% 2.88% 9.04% <-IRR #YR-> 10 Stock Price 137.52%
P/E 11.56 8.73 10.88 17.99 13.86 23.09 17.62 15.75 16.02 34.77 59.80 63.78 43.45 19.43% <-IRR #YR-> 5 Stock Price 143.00%
Trailing P/E 72.97 19.54 11.85 9.65 15.27 13.80 22.17 26.33 16.55 18.21 40.77 69.44 65.61 20.08 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 26.33 P/E:  17.80 34.77 53.50 P/E Ratio Historical High
-$13.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.25
-$12.86 $0.00 $0.00 $0.00 $0.00 $31.25
Low Months Oct 05 Mar 07 Dec 08 Jan 09 Jul 10 Oct 11 Feb 12 Apr 13 Jan 14 Jan 15 Feb 16 Feb 17
Price Low $5.65 $6.63 $11.45 $5.58 $6.51 $10.05 $8.38 $12.79 $15.81 $17.53 $20.16 $20.02 $26.35 201.81% <-Total Growth 10 Stock Price
Increase 1.74% 17.40% 72.66% -51.28% 16.67% 54.38% -16.62% 52.63% 23.61% 10.88% 15.00% -0.69% 31.62% 11.68% <-IRR #YR-> 10 Stock Price 201.81%
P/E 8.39 4.40 6.98 6.34 6.71 17.33 11.48 10.48 12.55 26.56 44.80 40.86 35.61 19.03% <-IRR #YR-> 5 Stock Price 138.90%
Trailing P/E 52.97 9.85 7.60 3.40 7.40 10.36 14.45 17.52 12.96 13.91 30.55 44.49 53.78 11.48 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 17.52 P/E:  12.01 26.56 7.23 P/E Ratio Historical Low
-$6.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20.02
Long Term Debt $452.25 $453.65 $836.50 $828.60 Debt
Change 0.31% 84.39% -0.94% 42.35% <-Median-> 2 Change
Debt/Market Cap Ratio 0.25 0.21 0.31 0.28 0.25 <-Median-> 3 Debt/Market Cap Ratio
Goodwill & Intangibles $0.00 $0.00 $26.71 $31.12 $63.75 $212.28 $209.26 $198.11 $259.50 $342.90 $726.55 $764.00 $755.80 Intangibles Goodwill
Change 16.49% 104.87% 232.96% -1.42% -5.33% 30.99% 32.14% 111.88% 5.15% -1.07% 30.99% <-Median-> 9 Change
Intangible/Market Cap Ratio 0.00 0.00 0.03 0.10 0.09 0.35 0.26 0.15 0.20 0.19 0.33 0.28 0.26 0.19 <-Median-> 10 Intangible/Market Cap Ratio
Market Cap $245.5 $495.0 $807.3 $317.9 $672.6 $610.9 $816.7 $1,286.7 $1,326.1 $1,785.2 $2,185.9 $2,707.2 $2,927.5 $2,927.5 $2,927.5 446.88% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 50.229 52.113 71.655 75.756 78.884 76.058 87.380 95.606 98.113 #DIV/0! <-Total Growth 7 Diluted
Change 3.75% 37.50% 5.72% 4.13% -3.58% 14.89% 9.41% 2.62% 5.72% <-Median-> 7 Change
Basic # of Shares in Millions 36.900 38.475 48.835 50.266 50.086 51.963 59.430 66.444 70.315 75.857 87.107 95.274 96.406 147.63% <-Total Growth 10 Basic
Change 0.97% 4.27% 26.93% 2.93% -0.36% 3.75% 14.37% 11.80% 5.83% 7.88% 14.83% 9.38% 1.19% 8.63% <-Median-> 10 Change
Difference 0.3% 0.3% 2.4% -1.2% 0.2% 2.3% 8.3% 2.3% 2.1% 8.2% 7.7% 1.0% 0.2% 2.31% <-Median-> 10 Difference
$177.7 <-12 mths 7.53%
# of Share in M 37.014 38.583 49.986 49.665 50.194 53.164 64.354 67.973 71.795 82.114 93.856 96.238 96.584 96.584 96.584 9.57% <-IRR #YR-> 10 Shares 149.43%
Change 0.96% 4.24% 29.55% -0.64% 1.07% 5.92% 21.05% 5.62% 5.62% 14.37% 14.30% 2.54% 0.36% 0.00% 0.00% 8.38% <-IRR #YR-> 5 Shares 49.54%
CF fr Op $Millon $34.8 $70.2 $82.8 $71.6 $112.4 $4.5 $89.6 $136.4 $133.1 $171.2 $223.3 $165.3 $171.9 $229.9 $293.6 135.31% <-Total Growth 10 Cash Flow
Increase 13.85% 101.80% 17.92% -13.54% 56.93% -96.02% 1905.12% 52.19% -2.38% 28.58% 30.43% -25.97% 4.00% 33.71% 27.73% DRIP, SO S. Issue, Buy Backs, Deb Conv.
5 year Running Average $26.6 $38.3 $50.0 $58.0 $74.4 $68.3 $72.2 $82.9 $95.2 $107.0 $150.7 $165.9 $173.0 $192.3 $216.8 332.89% <-Total Growth 10 CF 5 Yr Running
CFPS $0.94 $1.82 $1.66 $1.44 $2.24 $0.08 $1.39 $2.01 $1.85 $2.08 $2.38 $1.72 $1.78 $2.38 $3.04 -5.66% <-Total Growth 10 Cash Flow per Share
Increase 12.78% 93.60% -8.98% -12.98% 55.28% -96.25% 1556.47% 44.09% -7.58% 12.43% 14.11% -27.80% 3.63% 33.71% 27.73% 8.93% <-IRR #YR-> 10 Cash Flow 135.31%
5 year Running Average $0.73 $1.03 $1.22 $1.34 $1.62 $1.45 $1.36 $1.43 $1.52 $1.48 $1.94 $2.01 $1.96 $2.07 $2.26 13.03% <-IRR #YR-> 5 Cash Flow 84.47%
P/CF on Med Price 7.14 5.43 8.84 7.42 4.45 139.42 7.63 7.98 9.71 9.71 9.89 14.92 16.43 0.00 0.00 -0.58% <-IRR #YR-> 10 Cash Flow per Share -5.66%
P/CF on Closing Price 7.05 7.05 9.75 4.44 5.98 136.69 9.11 9.43 9.96 10.43 9.79 16.38 17.03 12.74 9.97 4.29% <-IRR #YR-> 5 Cash Flow per Share 23.35%
83.61% Diff M/C 6.94% <-IRR #YR-> 10 CFPS 5 yr Running 95.66%
Excl.Working Capital CF -$0.5 -$2.0 $31.2 $7.5 -$24.1 $76.3 $17.9 $3.350 $21.530 -$42.870 -$84.280 -$17.5 $0.0 $0.0 $0.0 8.06% <-IRR #YR-> 5 CFPS 5 yr Running 47.36%
CF fr Op $M WC $34.3 $68.2 $114.0 $79.1 $88.3 $80.7 $107.5 $139.7 $154.7 $128.3 $139.0 $147.8 $171.9 $229.9 $293.6 116.70% <-Total Growth 10 Cash Flow less WC
Increase 14.29% 98.60% 67.16% -30.64% 11.64% -8.55% 33.21% 29.92% 10.69% -17.03% 8.33% 6.32% 16.32% 33.71% 27.73% 8.04% <-IRR #YR-> 10 Cash Flow less WC 116.70%
5 year Running Average $25.6 $36.2 $54.9 $65.1 $76.8 $86.1 $93.9 $99.1 $114.2 $122.2 $133.9 $141.9 $148.3 $163.4 $196.4 6.57% <-IRR #YR-> 5 Cash Flow less WC 37.43%
CFPS Excl. WC $0.93 $1.77 $2.28 $1.59 $1.76 $1.52 $1.67 $2.06 $2.15 $1.56 $1.48 $1.54 $1.78 $2.38 $3.04 14.65% <-IRR #YR-> 10 CF less WC 5 Yr Run 292.30%
Increase 13.21% 90.53% 29.03% -30.19% 10.46% -13.66% 10.04% 23.01% 4.80% -27.46% -5.22% 3.69% 15.90% 33.71% 27.73% 8.60% <-IRR #YR-> 5 CF less WC 5 Yr Run 51.07%
5 year Running Average $0.71 $0.97 $1.31 $1.48 $1.67 $1.78 $1.76 $1.72 $1.83 $1.79 $1.78 $1.76 $1.70 $1.75 $2.04 -1.40% <-IRR #YR-> 10 CFPS - Less WC -13.12%
P/CF on Med Price 7.24 5.60 6.42 6.72 5.67 7.72 6.35 7.79 8.36 12.95 15.89 16.69 -1.68% <-IRR #YR-> 5 CFPS - Less WC -8.10%
P/CF on Closing Price 7.15 7.26 7.08 4.02 7.62 7.57 7.59 9.21 8.57 13.91 15.73 18.32 17.03 12.74 9.97 6.14% <-IRR #YR-> 10 CFPS 5 yr Running 81.54%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 9.27 5 yr  9.71 P/CF Med 10 yr 7.75 5 yr  12.95 119.67% Diff M/C -0.07% <-IRR #YR-> 5 CFPS 5 yr Running -0.37%
-$1.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.72 Cash Flow per Share
-$1.39 $0.00 $0.00 $0.00 $0.00 $1.72 Cash Flow per Share
-$1.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.01 CFPS 5 yr Running
-$1.36 $0.00 $0.00 $0.00 $0.00 $2.01 CFPS 5 yr Running
-$68.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $147.8 Cash Flow less WC
-$107.5 $0.0 $0.0 $0.0 $0.0 $147.8 Cash Flow less WC
-$36.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $141.9 CF less WC 5 Yr Run
-$93.9 $0.0 $0.0 $0.0 $0.0 $141.9 CF less WC 5 Yr Run
-$1.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.54 CFPS - Less WC
-$1.67 $0.00 $0.00 $0.00 $0.00 $1.54 CFPS - Less WC
OPM 3.98% 5.85% 4.88% 3.05% 5.56% 0.15% 2.25% 3.30% 2.35% 2.27% 3.56% 2.64% -54.94% <-Total Growth 10 OPM
Increase -10.71% 47.26% -16.66% -37.49% 82.43% -97.24% 1367.61% 46.56% -28.75% -3.26% 56.68% -25.96% Should increase  or be stable.
Diff from Median 39.8% 105.9% 71.6% 7.2% 95.6% -94.6% -20.8% 16.0% -17.3% -20.0% 25.3% -7.2% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 2.84% 5 Yrs 2.64% should be  zero, it is a   check on calculations
Current Assets $63.1 $101.0 $167.5 $174.2 $193.0 $377.2 $450.9 $428.1 $660.0 $787.2 $521.2 $1,157.2 $1,076.5 Liquidity ratio of 1.5 and up, best
Current Liabilities $61.0 $88.6 $139.4 $125.4 $145.8 $261.2 $228.4 $211.1 $423.4 $410.9 $414.4 $1,066.1 $972.3 1.42 <-Median-> 10 Ratio
Liquidity Ratio 1.03 1.14 1.20 1.39 1.32 1.44 1.97 2.03 1.56 1.92 1.26 1.09 1.11 1.56 <-Median-> 5 Ratio
Liq. with CF aft div 1.24 1.60 1.16 1.16 1.66 1.20 2.07 2.35 1.70 2.12 1.55 1.14 1.17 1.70 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  1.08 1.42 0.68 0.84 1.04 0.62 1.75 1.89 1.18 1.55 0.81 0.97 1.17 1.18 <-Median-> 5 Ratio
Curr Long Term Debt $6.9 $10.1 $4.1 $3.2 $1.1 $81.6 $5.0 $1.2 $3.6 $3.4 $3.4 $3.4 $3.4
Liquidity Less CLTD 1.16 1.29 1.24 1.43 1.33 2.10 2.02 2.04 1.57 1.93 1.27 1.09 1.11 1.57 <-Median-> 5 Ratio
Liq. with CF aft div 1.39 1.80 1.19 1.19 1.67 1.75 2.12 2.36 1.71 2.14 1.57 1.14 1.17 1.71 <-Median-> 5 Ratio
Assets $133.0 $172.5 $375.7 $405.5 $474.3 $839.7 $923.4 $903.5 $1,262.3 $1,531.8 $1,818.7 $2,561.5 $2,469.1 Debt Ratio of 1.5 and up, best
Liabilities $74.9 $94.4 $167.0 $213.9 $283.6 $647.7 $637.3 $550.7 $825.4 $961.9 $1,006.0 $1,757.6 $1,662.4 1.62 <-Median-> 10 Ratio
Debt Ratio 1.78 1.83 2.25 1.90 1.67 1.30 1.45 1.64 1.53 1.59 1.81 1.46 1.49 1.59 <-Median-> 5 Ratio
Book Value $58.1 $78.1 $208.7 $191.6 $190.8 $192.0 $286.2 $352.7 $436.9 $569.9 $812.6 $803.9 $806.7 $806.7 $806.7 929.85% <-Total Growth 10 Book Value
Book Value per share $1.57 $2.02 $4.18 $3.86 $3.80 $3.61 $4.45 $5.19 $6.09 $6.94 $8.66 $8.35 $8.35 $8.35 $8.35 312.88% <-Total Growth 10 Book Value per Share
Change 4.59% 28.89% 106.37% -7.62% -1.47% -4.97% 23.14% 16.69% 17.27% 14.03% 24.76% -3.52% -0.01% 0.00% 0.00% 30.75% P/B Ratio Current/Historical Median
P/B Ratio (Median) 4.28 4.89 3.51 2.78 2.62 3.25 2.39 3.08 2.96 2.92 2.72 3.07 3.50 2.78 P/B Ratio Historical Median
P/B Ratio (Close) 4.23 6.34 3.87 1.66 3.53 3.18 2.85 3.65 3.03 3.13 2.69 3.37 3.63 3.63 3.63 15.23% <-IRR #YR-> 10 Book Value per Share 312.88%
Change -12.72% 50.07% -39.01% -57.10% 112.49% -9.77% -10.31% 27.84% -16.80% 3.22% -14.13% 25.19% 7.76% 0.00% 0.00% 13.44% <-IRR #YR-> 5 Book Value per Share 87.83%
Leverage (A/BK) 2.29 2.21 1.80 2.12 2.49 4.37 3.23 2.56 2.89 2.69 2.24 3.19 3.06 2.62 <-Median-> 10 A/BV
Debt/Equity Ratio 1.29 1.21 0.80 1.12 1.49 3.37 2.23 1.56 1.89 1.69 1.24 2.19 2.06 1.62 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.94 5 yr Med 2.96 23.55% Diff M/C 2.18 Historical 21 A/BV
-$2.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.35
-$4.45 $0.00 $0.00 $0.00 $0.00 $8.35
$47.80 <-12 mths 7.17%
Comprehensive Income $80.74 $44.34 $48.60 $30.19 $43.92 $84.53 $92.28 $52.06 $55.07 $44.60 -44.76% <-Total Growth 9 Comprehensive Income
Increase -45.08% 9.61% -37.88% 45.44% 92.49% 9.17% -43.58% 5.78% -19.01% 5.78% <-Median-> 5 Comprehensive Income
5 Yr Running Average $49.56 $50.32 $59.90 $60.60 $65.57 $65.71 -6.38% <-IRR #YR-> 9 Comprehensive Income #DIV/0!
ROE 38.7% 23.1% 25.5% 15.7% 15.3% 24.0% 21.1% 9.1% 6.8% 5.5% 0.31% <-IRR #YR-> 5 Comprehensive Income 1.56%
5Yr Median 21.1% 15.7% 15.3% 9.1% 5.80% <-IRR #YR-> 5 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% 0.0% 0.0% 0.0% 0.0% -0.4% 0.4% 4.4% 39.4% -5.5% 5.80% <-IRR #YR-> 5 5 Yr Running Average 32.59%
Median Values Diff 5, 10 yr 0.0% 0.4% 9.1% <-Median-> 5 Return on Equity
-$80.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $44.6
-$43.9 $0.0 $0.0 $0.0 $0.0 $44.6
-$49.6 $0.0 $0.0 $0.0 $0.0 $65.7
-$49.6 $0.0 $0.0 $0.0 $0.0 $65.7
Current Liability Coverage Ratio 0.56 0.77 0.82 0.63 0.61 0.31 0.47 0.66 0.37 0.31 0.34 0.14 CF less WC CFO / Current Liabilities
5 year Median 0.56 0.67 0.70 0.67 0.63 0.63 0.61 0.61 0.47 0.37 0.37 0.34 0.34 <-Median-> 5 Current Liability Cov Ratio
Current Liability Coverage Ratio 0.57 0.79 0.59 0.57 0.77 0.02 0.39 0.65 0.31 0.42 0.54 0.16   CFO / Current Liabilities
5 year Median 0.57 0.68 0.68 0.59 0.59 0.59 0.57 0.57 0.39 0.39 0.42 0.42 0.42 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 26.17% 40.73% 22.05% 17.66% 23.69% 0.53% 9.70% 15.10% 10.55% 11.18% 12.28% 6.45% CFO / Total Assets
5 year Median 24.37% 26.04% 26.04% 26.04% 23.69% 22.05% 17.66% 15.10% 10.55% 10.55% 11.18% 11.18% 11.2% <-Median-> 5 Return on Assets 
Return on Assets ROA 18.8% 34.0% 21.5% 10.9% 10.2% 3.6% 4.8% 9.4% 7.3% 3.3% 2.2% 1.8% Net  Income/Assets Return on Assets
5Yr Median 7.8% 15.7% 18.8% 18.8% 18.8% 10.9% 10.2% 9.4% 7.3% 4.8% 4.8% 3.3% 6.0% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 43.0% 75.1% 38.7% 23.1% 25.5% 15.7% 15.3% 24.1% 21.0% 8.8% 4.9% 5.9% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 15.8% 28.4% 38.7% 38.7% 38.7% 25.5% 23.1% 23.1% 21.0% 15.7% 15.3% 8.8% 18.4% <-Median-> 10 Return on Equity
$44.91 <-12 mths -4.86%
Net Income $24.97 $58.59 $80.74 $44.34 $48.60 $30.19 $43.92 $84.85 $91.96 $49.88 $39.50 $47.20 $65.6 $125.0 $261.0 -19.44% <-Total Growth 10 Net Income
Increase 530.53% 134.65% 37.80% -45.08% 9.61% -37.88% 45.44% 93.22% 8.37% -45.76% -20.81% 19.50% 38.98% 90.55% 108.80% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $13.7 $23.9 $37.7 $42.5 $51.4 $52.5 $49.6 $50.4 $59.9 $60.2 $62.0 $62.7 $58.8 $65.4 $107.7 -2.14% <-IRR #YR-> 10 Net Income -19.44%
Operating Cash Flow $34.8 $70.2 $82.8 $71.6 $112.4 $4.5 $89.6 $136.4 $133.1 $171.2 $223.3 $165.3 1.45% <-IRR #YR-> 5 Net Income 7.48%
Investment Cash Flow -$8.7 -$10.8 -$98.3 -$48.2 -$87.2 -$244.4 -$42.6 -$51.3 -$184.6 -$149.8 -$377.7 -$191.1 10.12% <-IRR #YR-> 10 5 Yr Running Average 162.15%
Total Accruals -$1.1 -$0.9 $96.2 $20.9 $23.4 $270.2 -$3.1 -$0.2 $143.4 $28.5 $193.9 $73.0 4.81% <-IRR #YR-> 5 5 Yr Running Average 26.47%
Total Assets $133.0 $172.5 $375.7 $405.5 $474.3 $839.7 $923.4 $903.5 $1,262.3 $1,531.8 $1,818.7 $2,561.5 Balance Sheet Assets
Accruals Ratio -0.85% -0.50% 25.59% 5.15% 4.93% 32.17% -0.34% -0.02% 11.36% 1.86% 10.66% 2.85% 2.85% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.73 0.85 0.72 0.55 0.55 0.38 0.44 0.59 0.58 0.42 0.30 0.32 0.49 <-Median-> 10 EPS/CF Ratio
-$59 $0 $0 $0 $0 $0 $0 $0 $0 $0 $47
-$44 $0 $0 $0 $0 $47
-$24 $0 $0 $0 $0 $0 $0 $0 $0 $0 $63
-$50 $0 $0 $0 $0 $63
Change in Close -8.72% 93.42% 25.88% -60.37% 109.38% -14.25% 10.44% 49.17% -2.43% 17.70% 7.13% 20.78% 7.75% 0.00% 0.00% Count 22 Years of data
up/down up down down down down down Count 10 45.45%
Meet Prediction? yes % right Count 3 30.00%
Financial Cash Flow -$23.1 -$31.3 -$14.7 -$10.2 -$27.1 $240.9 -$37.6 -$98.3 $45.0 $168.9 -$23.7 $28.8 C F Statement  Financial CF
Total Accruals $22.0 $30.4 $110.9 $31.1 $50.5 $29.3 $34.5 $98.1 $98.4 -$140.3 $217.5 $44.2 Accruals
Accruals Ratio 16.51% 17.64% 29.52% 7.67% 10.65% 3.49% 3.74% 10.86% 7.79% -9.16% 11.96% 1.73% 7.79% <-Median-> 5 Ratio
Cash $8.3 $36.5 $6.3 $19.5 $17.6 $18.5 $27.9 $14.7 $8.3 $199.1 $21.7 $25.6 $18.3 Cash
Cash per Share $0.22 $0.95 $0.13 $0.39 $0.35 $0.35 $0.43 $0.22 $0.12 $2.43 $0.23 $0.27 $0.19 $0.23 <-Median-> 5 Cash per Share
Percentage of Stock Price 3.38% 7.37% 0.78% 6.14% 2.62% 3.03% 3.42% 1.14% 0.62% 11.15% 0.99% 0.95% 0.63% 0.99% <-Median-> 5 % of Stock Price
Notes:
June 18, 2017.  Last estimates were for 2016 and 2017 of $7182M and $8447M for Revenue, $0.94 and $1.04 for EPS, $1.72 and $1.86 for CFPS and $87.2M and $102M for Net Income.
June 18, 2016.  Last estimates were for 2015, 2016 and 2017 of $7751M, $9430M and $9488M for Revenue, $0.81, $0.98 and $0.85 for EPS, $1.75, $1.98 and $1.77 for CFPS, 
$68.8M, $86.5M and $83.1M for Net Income.
June 27, 2015.  Last estimates were for 2014, 2015 aad 2016 of $7488M, $8014M and $12929M for Revenue, $1.03, 1.32 and $1.28 for EPS. $1.76 and $2.05 for CFPS for 2014 and 2015,
 $80.7M and $98.3M for net income for 2014 and 2015.
On December 31, 2010 Parkland Income Fund converted to the corporate entity Parkland Fuel Corporation and became taxable as a corporation.
On May 4, 2007, the Parkland Board of Directors approved a division of the trust units of the Fund on a three for one basis.  Parkland Income Fund established on April 30, 2002.
The Fund was created to acquire the fuel marketing, convenience store and related ancillary businesses formerly owned by Parkland Industries Ltd.  
This acquisition was completed on June 28, 2002 through a Plan of Arrangement that resulted in the previous Parkland Industries Ltd. shareholders indirectly exchanging
their shares for Units in the Fund or Class B Limited Partnership Units in Parkland Holdings Limited Partnership (“LP Units”), a limited partnership controlled by the Fund.
Sector:
Services, Industrial
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock. 
I decided to do a spreadsheet on this stock as it was a stock recommended by Roger Conrad in Money Show 2013.
Dividends
The dividends are payable monthly.  Dividends are declared for shareholders of record of one month and payable in the next month.
For example, the dividend pyable on 14 February 2014 is for shareholders f record of 22 January 2014.
How they make their money.
Parkland Fuel Corporation is a marketer and distributor of fuels, managing a nationwide network of sales channels for retail, commercial, wholesale and home heating fuel customers.
Daily Buy and Sell Advisor of October 23, 2013.
Parkland Fuel Corp.  (PKI-TSX, $18.33)  is our smallest capitalized stock in the ValueTrend portfolio. But the company has a solid business, given that it's Canada's premier distributor of heating fuel. 
Parkland also owns a few convenience stores and gas stations. With a great chart pattern, as well as a six per cent dividend yield, Parkland is now an attractive buy. 
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 Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jun 15 2014 Jun 27 2015 Jun 18 2016 Jun 18 2017
Espey, Robert Berthold 0.096 0.12% 0.114 0.12% 0.131 0.14% 0.147 0.15%
CEO - Shares - Amount $2.086 $2.661 $3.67 $4.46
Options - percentage 0.872 1.06% 0.959 1.02% 1.108 1.15% 1.236 1.28%
Options - amount $18.952 $22.328 $31.17 $37.48
McMillan, Michael Stanley Howie 0.014 0.01% 0.017 0.02% 0.021 0.02%
CFO - Shares - Amount $0.320 $0.49 $0.63
Options - percentage 0.118 0.13% 0.213 0.22% 0.279 0.29%
Options - amount $2.749 $5.99 $8.47
Lambert, Michael Robert 0.017 0.02%
CFO - Shares - Amount $0.373
Options - percentage 0.389 0.47%
Options - amount $8.463
Appelman, Melody Joy 0.002 0.00%
Officer - Shares - Amount $0.06
Options - percentage 0.127 0.13%
Options - amount $3.84
Cruickshank, Andrew Stuart 0.005 0.01% 0.008 0.01% 0.026 0.03% ceased to be insider Dec '16
Officer - Shares - Amount $0.105 $0.196 $0.74
Options - percentage 0.092 0.11% 0.104 0.11% 0.118 0.12%
Options - amount $1.999 $2.427 $3.32
Bechtold, John Frederick 0.051 0.06% 0.051 0.05% 0.051 0.05% 0.051 0.05%
Director - Shares - Amount $1.111 $1.190 $1.44 $1.55
Options - percentage 0.017 0.02% 0.020 0.02% 0.024 0.03% 0.028 0.03%
Options - amount $0.359 $0.477 $0.69 $0.85
Pantelidis, James 0.266 0.32% 0.272 0.29% 0.278 0.29% 0.283 0.29%
Chairman - Shares - Amt $5.782 $6.345 $7.82 $8.58
Options - percentage 0.054 0.07% 0.063 0.07% 0.071 0.07% 0.079 0.08%
Options - amount $1.166 $1.462 $2.01 $2.40
Increase in O/S Shares 0.074 0.10% 0.509 0.62% 0.610 0.65% 0.445 0.46%
due to SO $1.367 $11.066 $14.207 $12.52
Book Value $0.487 $6.400 $11.082 $7.800
Insider Buying $0.000 -$0.487 -$0.049
Insider Selling $0.000 $0.782 $1.332
Net Insider Selling -$0.153 $0.000 $0.295 $1.283
% of Market Cap -0.01% 0.00% 0.01% 0.04%
Directors 6 7 7 8
Women 1 17% 1 14% 1 14% 2 25%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 87 24.36% 69 30.04% 88 35.99% 98 28.22%
Total Shares Held 18.020 21.94% 25.200 26.85% 34.199 35.54% 34.033 35.24%
Increase/Decrease 4.470 32.99% -0.229 -0.90% 2.141 6.68% 1.304 3.98%
Starting No. of Shares 13.549 25.429 32.058 32.729
Copyright © 2008 Website of SPBrunner. All rights reserved.