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/ Q2 2015
North West Company TSX: NWC OTC: NWTUF www.northwest.ca Fiscal Yr: Jan 31
Year 1/31/05 1/31/06 1/31/07 1/31/08 1/31/09 1/31/10 1/31/11 1/31/12 1/31/13 1/31/14 1/31/15 1/31/16 1/31/17 2/1/18 2/2/19 Value Description #Y Item
Annual report 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$1,832.8 <-12 mths 2.05%
Revenue* $788.7 $849.7 $944.9 $1,064.5 $1,392.6 $1,444.4 $1,448.1 $1,495.1 $1,513.6 $1,543.1 $1,624.4 $1,796.0 $1,846 $1,912 $1,975 111.38% <-Total Growth 10 Revenue
Increase 0.76% 7.73% 11.21% 12.65% 30.83% 3.71% 0.26% 3.25% 1.24% 1.95% 5.27% 10.57% 2.78% 3.58% 3.29% 7.77% <-IRR #YR-> 10 Revenue
5 year Running Average $736.9 $775.0 $823.1 $886.1 $1,008.1 $1,139.2 $1,258.9 $1,368.9 $1,458.8 $1,488.9 $1,524.9 $1,594.5 $1,664.6 $1,744.3 $1,830.7 4.40% <-IRR #YR-> 5 Revenue
Revenue per Share $16.30 $17.56 $19.53 $22.00 $28.79 $29.86 $29.93 $30.91 $31.28 $31.87 $33.49 $37.01 $38.05 $39.41 $40.71 7.48% <-IRR #YR-> 10 5 yr Running Average
Increase 0.76% 7.73% 11.21% 12.65% 30.83% 3.71% 0.26% 3.25% 1.22% 1.87% 5.11% 10.51% 2.80% 3.58% 3.29% 4.84% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $15.53 $16.06 $17.05 $18.32 $20.84 $23.55 $26.02 $28.30 $30.15 $30.77 $31.50 $32.91 $34.34 $35.97 $37.74 7.74% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 0.55 0.62 0.75 0.86 0.57 0.58 0.67 0.66 0.69 0.78 0.73 0.72 0.76 4.34% <-IRR #YR-> 5 Revenue per Share
P/S High Price 0.63 0.73 0.95 1.03 0.69 0.65 0.75 0.73 0.75 0.86 0.79 0.80 0.86 0.77 <-Median-> 10 P/S High Price
P/S Low Price 0.47 0.51 0.54 0.68 0.45 0.50 0.59 0.59 0.63 0.71 0.66 0.63 0.66 0.61 <-Median-> 10 P/S Low Price
P/S (Price/Sales) Closing 0.63 0.71 0.84 0.84 0.56 0.60 0.70 0.63 0.74 0.80 0.79 0.82 0.67 0.65 0.63 7.44% <-IRR #YR-> 10 5 yr Running Average
*Sales in M CDN $ P/S Med 10 yr 0.70 5 yr 0.72 -4.38% Diff M/C 4.81% <-IRR #YR-> 5 5 yr Running Average
-$850 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,796
-$1,448 $0 $0 $0 $0 $1,796
-$775 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,594
-$1,259 $0 $0 $0 $0 $1,594
-$17.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $37.01
-$29.93 $0.00 $0.00 $0.00 $0.00 $37.01
-$16.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32.91
-$26.02 $0.00 $0.00 $0.00 $0.00 $32.91
$1.44 <-12 mths 0.70%
EPS Basic $0.78 $0.90 $1.13 $1.32 $1.58 $1.71 $1.59 $1.20 $1.35 $1.33 $1.30 $1.44 60.00% <-Total Growth 10 EPS Basic
EPS Diluted* $0.77 $0.89 $1.12 $1.31 $1.56 $1.69 $1.58 $1.19 $1.34 $1.32 $1.29 $1.43 $1.48 $1.61 $1.66 60.67% <-Total Growth 10 EPS Diluted
Increase 4.50% 15.09% 25.84% 16.96% 19.08% 8.33% -6.51% -24.68% 12.61% -1.49% -2.27% 10.85% 3.50% 8.78% 3.11% 4.86% <-IRR #YR-> 10 Earnings per Share
Earnings Yield 7.6% 7.1% 6.8% 7.1% 9.7% 9.4% 7.5% 6.1% 5.8% 5.2% 4.9% 4.7% 5.8% 6.3% 6.5% -1.98% <-IRR #YR-> 5 Earnings per Share
5 year Running Average $0.70 $0.75 $0.85 $0.97 $1.13 $1.31 $1.45 $1.47 $1.47 $1.42 $1.34 $1.31 $1.37 $1.43 $1.49 5.72% <-IRR #YR-> 10 5 yr Running Average
10 year Running Average $0.52 $0.62 $0.70 $0.78 $0.90 $1.01 $1.10 $1.16 $1.22 $1.28 $1.33 $1.38 $1.42 $1.45 $1.46 -1.98% <-IRR #YR-> 5 5 yr Running Average
* ESP per share (Cdn GAAP) E/P 10 Yrs 6.48% 5Yrs 5.19%
-$0.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.43
-$1.58 $0.00 $0.00 $0.00 $0.00 $1.43
-$0.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.31
-$1.45 $0.00 $0.00 $0.00 $0.00 $1.31
Pre-split 2006 $0.00 $0.00
Special Dividend $0.00 $0.00 $0.10 $0.12 $0.07 $0.00 $0.06 $0.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.03 <-Median-> 10 Special Dividends
Pre-split 2006 $1.80 $1.88
Dividend* $0.60 $0.63 $0.80 $1.03 $1.28 $1.32 $1.36 $0.96 $1.04 $1.12 $1.16 $1.20 $1.24 $1.24 $1.24 91.49% <-Total Growth 10 Dividends
Increase 15.38% 4.44% 27.66% 28.75% 24.27% 3.13% 3.03% -29.41% 8.33% 7.69% 3.57% 3.45% 3.33% 0.00% 0.00% Count 19 Years of data
Dividends 5 Yr Running $0.54 $0.57 $0.66 $0.78 $0.93 $1.07 $1.23 $1.26 $1.24 $1.19 $1.16 $1.11 $1.15 $1.19 $1.22 94.42% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 6.70% 5.77% 6.18% 6.11% 8.18% 7.67% 7.09% 5.14% 4.82% 4.49% 4.75% 4.53% 4.30% 5.62% <-Median-> 10 Yield H/L Price
Yield on High Price 5.87% 4.88% 4.32% 4.54% 6.40% 6.82% 6.05% 4.27% 4.41% 4.11% 4.37% 4.06% 3.79% 4.39% <-Median-> 10 Yield on High Price
Yield on Low Price 7.79% 7.06% 8.46% 7.67% 10.38% 8.77% 8.08% 5.71% 5.31% 4.96% 5.21% 5.11% 4.96% 6.69% <-Median-> 10 Yield on Low Price
Yield on Close Price 5.87% 5.01% 5.48% 6.25% 8.36% 7.36% 6.73% 5.41% 4.49% 4.41% 4.37% 3.93% 4.85% 4.85% 4.85% 5.45% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 77.59% 70.41% 80.36% 87.90% 86.54% 78.11% 89.87% 88.24% 77.61% 84.85% 89.92% 83.92% 83.78% 77.02% 74.70% 85.69% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 77.52% 76.06% 77.42% 80.93% 81.87% 81.40% 84.59% 85.83% 83.97% 83.57% 86.16% 84.78% 83.97% 83.59% 81.39% 83.77% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 59.33% 40.27% 53.43% 59.52% 72.42% 59.14% 61.94% 44.30% 39.01% 67.77% 48.48% 43.78% 50.61% 42.76% #DIV/0! 56.29% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 49.87% 46.24% 47.72% 51.69% 57.49% 57.69% 61.37% 58.84% 54.10% 53.06% 50.91% 47.12% 48.40% 49.11% #DIV/0! 53.58% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 46.35% 46.34% 56.08% 60.00% 60.63% 55.70% 61.88% 40.68% 37.65% 38.07% 40.27% 36.91% 50.61% 42.76% #DIV/0! 48.19% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 43.09% 43.56% 46.66% 50.72% 55.11% 56.46% 58.97% 55.23% 50.51% 45.94% 43.01% 38.63% 40.32% 41.32% #DIV/0! 50.62% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.75% 4.41% 5 Yr Med Payout 84.85% 44.30% 38.07% 6.71% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. 1.97% 9.98% Last Div Inc ---> $0.29 $0.31 6.9% -2.47% <-IRR #YR-> 5 Dividends
5.74% <-IRR #YR-> 4 Dividends
-$0.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20
-$1.36 $0.00 $0.00 $0.00 $0.00 $1.20
-$0.96 $0.00 $0.00 $0.00 $1.20
Historical Dividends Historical High Div 12.99% Low Div 4.10% Ave Div 8.55% Med Div 6.89% Close Div 6.25% Historical Dividends
High/Ave/Median Values Curr diff Exp. -62.70% Exp 18.19% Exp. -43.29% Exp. -29.67% Exp. -22.49% High/Ave/Median
Future Dividend Yield Div Yd 6.18% earning in 5 Years at IRR of 5.00% Div Inc. 27.63% Future Dividend Yield
Future Dividend Yield Div Yd 7.89% earning in 10 Years at IRR of 5.00% Div Inc. 62.89% Future Dividend Yield
Future Dividend Yield Div Yd 10.07% earning in 15 Years at IRR of 5.00% Div Inc. 107.89% Future Dividend Yield
Cost covered if held 5 years 59.96% 75.39% 65.06% 61.79% 59.89% 59.69% 56.58% 43.18% 32.79% 36.07% 33.66% 27.82% 28.18% 27.60% 24.38% 49.88% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 154.74% 177.94% 237.01% 189.85% 159.42% 136.88% 124.31% 107.89% 82.71% 64.42% 72.93% 157.08% <-Median-> 8 Paid Median Price
Cost covered if held 15 years 282.15% 305.66% 383.59% 304.10% 253.58% 215.55% 305.66% <-Median-> 3 Paid Median Price
Cost covered if held 20 years 412.34% #NUM! <-Median-> 0 Paid Median Price
Yield if held 5 yrs 13.24% 16.49% 15.87% 16.27% 16.56% 14.73% 12.53% 6.59% 5.52% 6.79% 6.74% 5.99% 6.07% 5.74% 4.97% 9.66% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 27.41% 29.12% 35.79% 19.04% 16.43% 14.49% 12.95% 11.05% 8.51% 6.58% 7.52% 17.74% <-Median-> 8 Paid Median Price
Yield if held 15 yrs 23.98% 25.59% 31.58% 24.60% 19.59% 16.04% 25.59% <-Median-> 3 Paid Median Price
Yield if held 20 yrs 26.55% #NUM! <-Median-> 0 Paid Median Price
Graham No. $9.22 $10.02 $11.46 $12.50 $14.11 $15.10 $14.91 $12.53 $13.59 $14.06 $14.04 $15.40 $15.35 $16.01 $16.25 53.68% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.97 1.08 1.27 1.51 1.17 1.14 1.34 1.63 1.59 1.77 1.74 1.72 1.88 1.55 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Hi 1.11 1.28 1.61 1.81 1.42 1.28 1.51 1.80 1.74 1.94 1.89 1.92 2.13 1.77 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.84 0.89 0.93 1.20 0.92 1.00 1.18 1.47 1.44 1.61 1.59 1.53 1.63 1.32 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Cl 1.11 1.25 1.43 1.47 1.14 1.19 1.41 1.55 1.70 1.81 1.89 1.98 1.67 1.60 1.57 1.51 <-Median-> 10 Price/GP Ratio
Prem/Disc CL 10.83% 24.75% 43.25% 47.40% 14.39% 18.84% 41.46% 54.82% 70.32% 80.76% 89.20% 98.26% 66.73% 59.86% 57.43% 51.11% <-Median-> 10 Graham Price
Month Year Dec-04 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
pre-split '06 $28.95 $36.00
Price Close $9.65 $12.00 $15.53 $20.93 $16.90 $19.00 $20.62 $20.15 $22.39 $25.74 $26.20 $28.67 $25.59 $25.59 $25.59 138.92% <-Total Growth 10 Stock Price
Increase 16.92% 24.35% 29.42% 34.77% -19.25% 12.43% 8.53% -2.28% 11.12% 14.96% 1.79% 9.43% -10.74% 0.00% 0.00% 9.10% <-IRR #YR-> 10 Stock Price
P/E 12.48 13.48 13.87 15.98 10.83 11.24 13.05 16.93 16.71 19.50 20.31 20.05 17.29 15.89 15.42 6.81% <-IRR #YR-> 5 Stock Price
Trailing P/E 13.04 15.52 17.45 18.69 12.90 12.18 12.20 12.75 18.82 19.21 19.85 22.22 17.90 17.29 15.89 16.15% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 7.05% 4.74% % Tot Ret 43.67% 41.05% Price Inc 9.43% P/E: 16.34 19.50 11.56% <-IRR #YR-> 5 Price & Dividend
-$12.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.67
-$20.62 $0.00 $0.00 $0.00 $0.00 $28.67
-$12.00 $0.90 $1.15 $1.35 $1.32 $1.42 $1.05 $1.04 $1.12 $1.16 $29.87
-$20.62 $1.05 $1.04 $1.12 $1.16 $29.87
Month Year Jan-05 Jan-06 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16 Jan-17 Jan-18 Jan-19
pre-split '06 $30.65
Price Close $10.22 $12.50 $16.41 $18.42 $16.14 $17.94 $21.09 $19.40 $23.14 $25.42 $26.56 $30.53 $25.59 $25.59 $25.59 144.24% <-Total Growth 10 Stock Price D. per yr 6.25% 5.31%
Increase 29.71% 22.35% 31.28% 12.25% -12.38% 11.15% 17.56% -8.01% 19.28% 9.85% 4.48% 14.95% -16.18% 0.00% 0.00% 9.34% <-IRR #YR-> 10 Stock Price 4.54%
P/E 13.21 14.04 14.65 14.06 10.35 10.62 13.35 16.30 17.27 19.26 20.59 21.35 17.29 15.89 15.42 7.68% <-IRR #YR-> 5 Stock Price 5.69%
Trailing P/E 13.81 16.16 18.44 16.45 12.32 11.50 12.48 12.28 19.45 18.97 20.12 23.67 17.90 17.29 15.89 16.05% <-IRR #YR-> 10 Price & Dividend 10.79%
Median 10, 5 Yrs D. per yr 6.71% 4.57% % Tot Ret 41.80% 37.31% Price Inc 9.85% P/E: 15.48 19.26 12.25% <-IRR #YR-> 5 Price & Dividend 11.01%
-$12.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $30.53
-$21.09 $0.00 $0.00 $0.00 $0.00 $30.53
-$12.50 $0.90 $1.15 $1.35 $1.32 $1.42 $1.05 $1.04 $1.12 $1.16 $31.73
-$21.09 $1.05 $1.04 $1.12 $1.16 $31.73
Price Median H/L $8.96 $10.86 $14.57 $18.85 $16.50 $17.20 $20.03 $20.44 $21.60 $24.94 $24.41 $26.52 $28.85 144.27% <-Total Growth 10 Stock Price
Increase 15.94% 21.15% 34.22% 29.34% -12.47% 4.27% 16.42% 2.07% 5.65% 15.49% -2.13% 8.62% 8.79% 9.34% <-IRR #YR-> 10 Stock Price
P/E 11.59 12.20 13.01 14.39 10.57 10.18 12.67 17.18 16.12 18.89 18.92 18.54 19.49 5.78% <-IRR #YR-> 5 Stock Price
Trailing P/E 12.11 14.04 16.37 16.83 12.59 11.03 11.85 12.94 18.15 18.61 18.49 20.55 20.17 17.11% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 12.78 14.41 17.20 19.49 14.59 13.09 13.79 13.94 14.67 17.51 18.16 20.18 21.02 10.75% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 17.10 17.41 20.92 24.14 18.31 17.07 18.16 17.67 17.71 19.53 18.37 19.17 20.33 12.44 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 7.77% 4.98% % Tot Ret 45.40% 46.28% Price Inc 5.65% P/E: 15.25 18.54 Count 18 Years of data
-$10.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.52
-$20.03 $0.00 $0.00 $0.00 $0.00 $26.52
-$10.86 $0.90 $1.15 $1.35 $1.32 $1.42 $1.05 $1.04 $1.12 $1.16 $27.72
-$20.03 $1.05 $1.04 $1.12 $1.16 $27.72
High Months Jan 05 Dec 05 Sep 06 Nov 07 Apr 08 Dec 09 Nov 10 Feb 11 Dec 12 Nov 13 Jan 15 Oct 15 Feb 16
pre-split '06 $31.74
Price High $10.22 $12.83 $18.50 $22.68 $19.99 $19.35 $22.48 $22.50 $23.59 $27.28 $26.56 $29.54 $32.71 130.24% <-Total Growth 10 Stock Price
Increase 20.24% 25.54% 44.19% 22.59% -11.86% -3.20% 16.18% 0.09% 4.84% 15.64% -2.64% 11.22% 10.73% 8.70% <-IRR #YR-> 10 Stock Price
P/E 13.22 14.42 16.52 17.31 12.81 11.45 14.23 18.91 17.60 20.67 20.59 20.66 22.10 5.61% <-IRR #YR-> 5 Stock Price
Trailing P/E 13.81 16.59 20.79 20.25 15.26 12.40 13.30 14.24 19.82 20.36 20.12 22.90 22.87 14.32 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 4.84% P/E: 17.46 20.59 19.24 P/E Ratio Historical High
-$12.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.54
-$22.48 $0.00 $0.00 $0.00 $0.00 $29.54
Low Months May 04 Nov 05 Feb 06 Mar 07 Oct 08 Jun 09 May 10 Oct 11 Feb12 Apr 13 Sep 14 Jun 15 Oct 16
Price Low $7.70 $8.88 $10.64 $15.01 $13.00 $15.05 $17.57 $18.38 $19.60 $22.60 $22.26 $23.49 $24.98 164.53% <-Total Growth 10 Stock Price
Increase 10.69% 15.32% 19.82% 41.07% -13.39% 15.77% 16.74% 4.61% 6.64% 15.31% -1.50% 5.53% 6.34% 10.22% <-IRR #YR-> 10 Stock Price
P/E 9.96 9.98 9.50 11.46 8.33 8.91 11.12 15.45 14.63 17.12 17.26 16.43 16.88 5.98% <-IRR #YR-> 5 Stock Price
Trailing P/E 10.41 11.48 11.96 13.40 9.92 9.65 10.40 11.63 16.47 16.87 16.86 18.21 17.47 9.97 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 5.53% P/E: 13.04 16.43 7.64 P/E Ratio Historical Low
-$8.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.49
Long Term Debt $195.13 $225.49 $240.55 Debt
Ratio to Market Cap 0.15 0.15 0.19 0.15 <-Median-> 2 % of Market C.
Goodwill & Intangibles $46.30 $50.94 $56.14 $69.87 $70.50 Intangibles Goodwill
Ratio to Market Cap 0.04 0.04 0.04 0.05 0.06 0.04 <-Median-> 4 % of Market C.
Market Cap $494 $605 $794 $891 $781 $868 $1,020 $939 $1,120 $1,231 $1,288 $1,481 $1,241 $1,241 $1,241 144.97% <-Total Growth 10 Market Cap
Diluted 47.69 48.56 48.41 48.43 48.46 48.51 48.53 48.58 48.66 48.71 48.78 48.98 2.28% <-Total Growth 10 Diluted
Change 1.82% -0.31% 0.04% 0.06% 0.10% 0.03% 0.11% 0.16% 0.11% 0.15% 0.40% 0.11% <-Median-> 10 Change
Average # of Sh in M 47.75 47.69 47.56 47.72 47.65 47.80 48.18 48.38 48.38 48.41 48.43 48.51 48.52 1.71% <-Total Growth 10 Average
Change -0.14% -0.13% -0.28% 0.33% -0.14% 0.32% 0.79% 0.41% 0.01% 0.06% 0.04% 0.16% 0.03% 0.11% <-Median-> 10 Change
Difference 1.3% 1.4% 1.7% 1.4% 1.5% 1.2% 0.4% 0.0% 0.0% 0.0% 0.1% 0.0% 0.0% 0.27% <-Median-> 10 Difference
$142.53 <-12 mths 7.17%
# of Share in Millions 48.38 48.38 48.38 48.38 48.38 48.38 48.38 48.38 48.39 48.43 48.50 48.52 48.51 48.51 48.51 0.03% <-IRR #YR-> 10 Shares
Change 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.02% 0.08% 0.15% 0.05% -0.02% 0.00% 0.00% 0.06% <-IRR #YR-> 5 Shares
CF fr Op $M $48.9 $75.3 $81.5 $93.6 $90.2 $108.0 $110.9 $114.7 $129.0 $80.0 $116.0 $133.0 $118.9 $140.7 76.64% <-Total Growth 10 Cash Flow
Increase -26.74% 53.89% 8.23% 14.86% -3.65% 19.73% 2.72% 3.38% 12.50% -37.95% 44.98% 14.61% -10.62% 18.37% SO
5 year Running Average $51.9 $59.8 $66.4 $73.2 $77.9 $89.7 $96.8 $103.5 $110.5 $108.5 $110.1 $114.5 $115.4 $117.7 91.47% <-Total Growth 10 CF 5 Yr Running
CFPS $1.01 $1.56 $1.68 $1.93 $1.86 $2.23 $2.29 $2.37 $2.67 $1.65 $2.39 $2.74 $2.45 $2.90 76.11% <-Total Growth 10 Cash Flow per Share
Increase -26.74% 53.89% 8.23% 14.86% -3.65% 19.73% 2.72% 3.38% 12.48% -38.00% 44.77% 14.54% -10.61% 18.37% 5.85% <-IRR #YR-> 10 Cash Flow
5 year Running Average $1.09 $1.24 $1.37 $1.51 $1.61 $1.85 $2.00 $2.14 $2.28 $2.24 $2.27 $2.36 $2.38 $2.43 3.70% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 8.86 6.98 8.65 9.74 8.85 7.71 8.73 8.62 8.10 15.09 10.20 9.67 11.77 0.00 5.82% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 10.10 8.03 9.74 9.52 8.66 8.04 9.20 8.19 8.68 15.38 11.10 11.14 10.44 8.82 3.63% <-IRR #YR-> 5 Cash Flow per Share
18.80% Diff M/C 6.67% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $13.70 -$9.86 -$3.84 -$0.74 $17.54 $6.68 $0.10 $10.22 $4.68 $62.44 $23.66 $24.76 $0.00 $0.00 3.39% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $62.6 $65.4 $77.6 $92.9 $107.7 $114.7 $111.0 $124.9 $133.7 $142.5 $139.7 $157.7 $118.9 $140.7 141.09% <-Total Growth 10 Cash Flow less WC
Increase -15.97% 4.48% 18.67% 19.58% 16.01% 6.44% -3.18% 12.50% 7.04% 6.58% -1.95% 12.92% -24.65% 18.37% 9.20% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $60.0 $63.5 $67.9 $74.6 $81.3 $91.7 $100.8 $110.2 $118.4 $125.3 $130.3 $139.7 $138.5 $139.9 7.28% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $1.29 $1.35 $1.60 $1.92 $2.23 $2.37 $2.29 $2.58 $2.76 $2.94 $2.88 $3.25 $2.45 $2.90 8.20% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase -15.97% 4.48% 18.67% 19.58% 16.01% 6.44% -3.18% 12.50% 7.02% 6.50% -2.10% 12.86% -24.64% 18.37% 6.75% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $1.26 $1.32 $1.41 $1.54 $1.68 $1.89 $2.08 $2.28 $2.45 $2.59 $2.69 $2.88 $2.86 $2.88 9.17% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 6.92 8.03 9.08 9.82 7.41 7.26 8.73 7.92 7.82 8.48 8.47 8.16 11.77 0.00 7.22% <-IRR #YR-> 5 CFPS - Less WC
P/CF on High Price 7.89 9.49 11.53 11.82 8.98 8.16 9.80 8.72 8.54 9.27 9.22 9.09 13.35 0.00 9.15 <-Median-> 10 P/CF High Price
P/CF on Low Price 6.92 8.03 9.08 9.82 7.41 7.26 8.73 7.92 7.82 8.48 8.47 8.16 11.77 0.00 8.32 <-Median-> 10 P/CF Low Price
P/CF on Closing Price 7.89 9.24 10.22 9.60 7.25 7.57 9.19 7.52 8.38 8.64 9.22 9.39 10.44 8.82 8.16% <-IRR #YR-> 10 CFPS 5 yr Running
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 8.79 5 yr 9.67 P/CF Med 10 yr 8.32 5 yr 8.16 25.61% Diff M/C 6.72% <-IRR #YR-> 5 CFPS 5 yr Running
-$1.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.74 Cash Flow per Share
-$2.29 $0.00 $0.00 $0.00 $0.00 $2.74 Cash Flow per Share
-$1.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.36 CFPS 5 yr Running
-$2.00 $0.00 $0.00 $0.00 $0.00 $2.36 CFPS 5 yr Running
-$65.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $157.7 Cash Flow less WC
-$111.0 $0.0 $0.0 $0.0 $0.0 $157.7 Cash Flow less WC
-$63.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $139.7 CF less WC 5 Yr Run
-$100.8 $0.0 $0.0 $0.0 $0.0 $139.7 CF less WC 5 Yr Run
-$1.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.25 CFPS - Less WC
-$2.29 $0.00 $0.00 $0.00 $0.00 $3.25 CFPS - Less WC
-$1.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.88 CFPS 5 yr Running
-$2.08 $0.00 $0.00 $0.00 $0.00 $2.88 CFPS 5 yr Running
Change in non-cash working capital -$0.1 -$4.0 $10.8 -$10.4 $9.2 $5.9
Taxes paid -$6.2 -$15.5 -$52.0 -$32.9 -$30.7
           
-$0.1 -$10.2 -$4.7 -$62.4 -$23.7 -$24.8
Google -$9.2 -$4.7 -$62.4 -$23.7 -$24.8
OPM 6.20% 8.86% 8.62% 8.79% 6.48% 7.48% 7.66% 7.67% 8.52% 5.19% 7.14% 7.40% -16.44% <-Total Growth 10 OPM
Increase -27.29% 42.85% -2.68% 1.95% -26.35% 15.44% 2.46% 0.13% 11.13% -39.14% 37.73% 3.65% Should increase or be stable.
Diff from Median -18.0% 17.1% 14.0% 16.2% -14.4% -1.2% 1.2% 1.3% 12.6% -31.5% -5.6% -2.2% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 7.57% 5 Yrs 7.40% should be zero, it is a check on calculations
Current Assets $207.64 $218.74 $226.16 $254.06 $285.09 $285.84 $289.30 $295.84 $303.90 $299.07 $315.84 $335.58 $337.21 Liquidity ratio of 1.5 and up, best
Current Liabilities $87.44 $95.47 $122.78 $134.90 $175.30 $171.95 $185.38 $128.00 $190.18 $209.74 $150.23 $155.50 $143.54 1.75 <-Median-> 10 Ratio
Liquidity 2.37 2.29 1.84 1.88 1.63 1.66 1.56 2.31 1.60 1.43 2.10 2.16 2.35 2.10 <-Median-> 5 Ratio
Liq. with CF aft div 2.60 2.76 2.15 2.16 1.77 1.92 1.79 2.81 2.01 1.55 2.50 2.64 2.76 2.50 <-Median-> 5 Ratio
Liq. CF re Inv+Div 2.09 2.21 1.67 1.25 1.38 1.43 1.50 2.08 1.60 1.29 1.87 1.77 2.76 1.77 <-Median-> 5 Ratio
Curr Long Term Debt $77.80 $6.27 $0.00 $0.00
Liquidity Less CLTD 2.27 2.19 2.16 2.35
Assets $413.64 $423.85 $441.87 $529.67 $609.17 $623.80 $620.48 $626.92 $651.39 $670.51 $724.30 $793.80 $796.38 Debt Ratio of 1.5 and up, best
Liabilities $177.35 $181.28 $189.94 $273.37 $334.76 $333.87 $317.99 $343.21 $355.14 $348.07 $395.02 $436.18 $453.19 1.85 <-Median-> 10 Ratio
Debt Ratio 2.33 2.34 2.33 1.94 1.82 1.87 1.95 1.83 1.83 1.93 1.83 1.82 1.76 1.83 <-Median-> 5 Ratio
Book Value $236.3 $242.6 $251.9 $256.3 $274.4 $289.9 $302.5 $283.7 $296.3 $322.4 $329.3 $357.6 $343.2 $343.2 $343.2 47.42% <-Total Growth 10 Book Value
Book Value per share $4.88 $5.01 $5.21 $5.30 $5.67 $5.99 $6.25 $5.86 $6.12 $6.66 $6.79 $7.37 $7.07 $7.07 $7.07 46.98% <-Total Growth 10 Book Value per Share
Change 3.42% 2.66% 3.86% 1.74% 7.07% 5.65% 4.34% -6.21% 4.40% 8.76% 1.97% 8.54% -4.02% 0.00% 0.00% 3.17% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.83 2.16 2.80 3.56 2.91 2.87 3.20 3.49 3.53 3.75 3.60 3.60 4.08 2.00 P/B Ratio Historical Median
P/B Ratio (Close) 2.09 2.49 3.15 3.48 2.85 2.99 3.37 3.31 3.78 3.82 3.91 4.14 3.62 3.62 3.62 3.93% <-IRR #YR-> 10 Book Value per Share
Change 25.42% 19.18% 26.40% 10.33% -18.16% 5.20% 12.67% -1.92% 14.25% 1.01% 2.46% 5.90% -12.67% 0.00% 0.00% 3.34% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 1.75 1.75 1.75 2.07 2.22 2.15 2.05 2.21 2.20 2.08 2.20 2.22 2.32 2.18 <-Median-> 10 A/BV
Debt/Equity Ratio 0.75 0.75 0.75 1.07 1.22 1.15 1.05 1.21 1.20 1.08 1.20 1.22 1.32 1.18 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.51 5 yr Med 3.60 3.17% Diff M/C 2.15 Historical Leverage (A/BK)
-$5.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.37
-$6.25 $0.00 $0.00 $0.00 $0.00 $7.37
$65.27 <-12 mths -24.37%
Comprehensive Income $54.14 $60.32 $81.89 $77.41 $75.71 $42.99 $62.33 $79.67 $62.33 $86.30 59.40% <-Total Growth 9 Comprehensive Income
Increase 11.42% 35.76% -5.47% -2.20% -43.22% 45.00% 27.81% -21.76% 38.46% 27.81% <-Median-> 5 Comprehensive Income
5 Yr Running Average $69.90 $67.66 $68.07 $67.62 $64.60 $66.72 5.32% <-IRR #YR-> 9 Comprehensive Income
ROE 26.7% 25.0% 15.2% 21.0% 24.7% 18.9% 24.1% 2.65% <-IRR #YR-> 5 Comprehensive Income
5Yr Median 24.7% 21.0% 21.0% -0.92% <-IRR #YR-> 5 Comprehensive Income
% Difference from NI -5.4% -1.2% -25.8% -4.3% 24.0% -0.9% 23.7% -0.92% <-IRR #YR-> 5 Comprehensive Income
Median Values Diff 5, 10 yr -1.2% -0.9% 21.0% <-Median-> 5 Return on Equity
-$54.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $86.3
-$75.7 $0.0 $0.0 $0.0 $0.0 $86.3
-$69.9 $0.0 $0.0 $0.0 $0.0 $66.7
-$69.9 $0.0 $0.0 $0.0 $0.0 $66.7
Current Liability Coverage Ratio 0.72 0.69 0.63 0.69 0.61 0.67 0.60 0.98 0.70 0.68 0.93 1.01 CFO / Current Liabilities
5 year Median 0.64 0.69 0.69 0.69 0.69 0.67 0.63 0.67 0.67 0.68 0.70 0.93 0.93 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 15.14% 15.44% 17.57% 17.53% 17.68% 18.38% 17.89% 19.92% 20.52% 21.25% 19.29% 19.87% CFO / Total Assets
5 year Median 14.15% 15.14% 15.44% 17.53% 17.53% 17.57% 17.68% 17.89% 18.38% 19.92% 19.92% 19.92% 19.9% <-Median-> 5 Return on Assets
Return on Assets ROA 9.0% 10.1% 12.1% 11.9% 12.4% 13.1% 12.3% 9.2% 10.0% 9.6% 8.7% 8.8% Net Income/Assets Return on Assets
5Yr Median 8.2% 8.7% 9.0% 10.1% 11.9% 12.1% 12.3% 12.3% 12.3% 10.0% 9.6% 9.2% 9.2% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 15.8% 17.7% 21.3% 24.6% 27.5% 28.2% 25.3% 20.4% 22.0% 19.9% 19.1% 19.5% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 15.6% 15.7% 15.8% 17.7% 21.3% 24.6% 25.3% 25.3% 25.3% 22.0% 20.4% 19.9% 19.9% <-Median-> 5 Return on Equity
$69.78 <-12 mths 0.00%
Net Income $37.27 $42.89 $53.66 $62.99 $75.38 $81.81 $76.59 $57.96 $65.15 $64.26 $62.88 $69.78 62.69% <-Total Growth 10 Net Income
Increase 4.30% 15.09% 25.11% 17.39% 19.66% 8.54% -6.38% -24.33% 12.40% -1.36% -2.15% 10.97% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $33 $36 $41 $47 $54 $63 $70 $71 $71 $69 $65 $64 4.99% <-IRR #YR-> 10 Net Income
Operating Cash Flow $48.93 $75.29 $81.49 $93.59 $90.18 $107.97 $110.91 $114.66 $128.99 $80.04 $116.04 $132.99 -1.85% <-IRR #YR-> 5 Net Income
Investment Cash Flow -$21.63 -$23.90 -$35.48 -$98.12 -$49.44 -$59.37 -$36.00 -$45.14 -$48.78 -$42.39 -$50.31 -$75.81 5.96% <-IRR #YR-> 10 5 Yr Running Average
Total Accruals $9.97 -$8.50 $7.65 $67.52 $34.64 $33.21 $1.68 -$11.56 -$15.06 $26.61 -$2.84 $12.61 -1.80% <-IRR #YR-> 5 5 Yr Running Average
Total Assets $413.64 $423.85 $441.87 $529.67 $609.17 $623.80 $620.48 $626.92 $651.39 $670.51 $724.30 $793.80 Balance Sheet Assets
Accruals Ratio 2.41% -2.01% 1.73% 12.75% 5.69% 5.32% 0.27% -1.84% -2.31% 3.97% -0.39% 1.59% -0.39% <-Median-> 5 Ratio
EPS/CF Ratio 0.60 0.66 0.70 0.68 0.70 0.71 0.69 0.46 0.49 0.45 0.45 0.44 0.58 <-Median-> 10 EPS/CF Ratio
-$42.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $69.8
-$76.6 $0.0 $0.0 $0.0 $0.0 $69.8
-$35.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $64.0
-$70.1 $0.0 $0.0 $0.0 $0.0 $64.0
Chge in Close 29.71% 22.35% 31.28% 12.25% -12.38% 11.15% 17.56% -8.01% 19.28% 9.85% 4.48% 14.95% -16.18% 0.00% 0.00% Count 19 Change in Close
up/down/neutral down down down Count 5
Meet Prediction? yes % right Count 2 40.00%
With Financial Cash Flow down down down down down down down down down down down down down Count 17
Meet Prediction? yes yes % right Count 4 23.53%
Financial Cash Flow -$32.49 -$40.85 -$45.50 $1.12 -$36.75 -$47.05 -$70.96 -$73.77 -$68.52 -$53.97 -$58.95 -$50.17 C F Statement Financial Cash Flow
Total Accruals $42.45 $32.35 $53.15 $66.40 $71.38 $80.27 $72.64 $62.21 $53.46 $80.59 $56.11 $62.78 Accruals
Accruals Ratio 10.26% 7.63% 12.03% 12.54% 11.72% 12.87% 11.71% 9.92% 8.21% 12.02% 7.75% 7.91% 8.21% <-Median-> 5 Ratio
Cash $21.73 $25.73 $27.28 $31.23 $26.98 $38.68 $22.35 $29.13 $37.24 $43.10 Cash
Cash per share $0.45 $0.53 $0.56 $0.65 $0.56 $0.80 $0.46 $0.60 $0.77 $0.89 $0.60 <-Median-> 5 Cash per Share
Percentage of Stock Price 2.44% 3.30% 3.14% 3.06% 2.88% 3.45% 1.82% 2.26% 2.51% 3.47% 2.51% <-Median-> 5 % of Stock Price
Taxes
Dividend 13% 17% 19% 0% 0% 0%
Cap Gain 0% 0% 0% 0% 0% 0%
Taxable Inc 87% 83% 81% 100% 100% 100%
Ret of Cap. 0% 0% 0% 0% 0% 0%
Total 100% 100% 100% 100% 100% 100%
For Tax Cr
October 29, 2016. Last estimates were for 2016, 2017 and 2018 of $1788M, $1866M and $1955M for Revenue, $1.51, $1.63 and $1.78 for EPS, $1.97 and $1.94 for CFPS for 2016 and 2017.
October 28, 2015. Last estimates were for 2015, 2016 and 2017 of $1592M, $1650M and $1678M for Revenue, $1.16, $1.22 and $1.32 for EPS, $1.94 and $1.87 for CFPS for 2015 and 2016.
October 21, 2014. Last estimates were for 2014 and 2015 of $1529M and $1570M ($1646M for 2016) for Revenue, $1.39 and $1.50 for EPS and $1.58 and $1.87 for CFPS.
Sept 22, 2013. Last estimates for the financial years ending in January 2013 and 2013 were $1563.6M and $1625.2M for Revenue, $1.35, $1.45 and ($1.58 for 2015) for EPS.
August 12, 2012. Last estimates were for 2012 and 2013 of $1.26 and $1.39 for EPS and for 2011 and 2012 of $1.98 and $2.15 for CF.
Feb 4, 2011. The last time I looked at this stock I got 2010 and 2011 estimates of $1.65 and $1.72 for earnings and $1.96 and $2.06 for cash flow.
May 2, 2011. The common shares of North West will commence trading under the symbol "NWC", change from NWF
Company has changed to a stock company. From The North West Company Fund to The North West Company. Symbol from NWF.UN to NWF.
Company does not use FFO or Distributable Cash. It does its comparisons to Cash Flow. Distributions are not expected to be decreased until after 2011 and by an amount of 30% or less. The reduction will probably be in the low 20% range.
It seems to have gone public in April 1997
The Northern Stores Division of Hudson's Bay Company, in April 1987, was acquired by a group of investors.
The company traces its history back to the North West Company, a fur trading business. It was merged into the Hudson's Bay Company in 1821.
Would I buy this company and Why.
This is a dividend growth stock, so I would consider it. Because it is in the retail sector there will be volitility.
Dividends
Dividends are paid cycle 1, that is April, July, October and January. The dividends are declared in one month and paid in the following month.
For example, the Dividend declared for Shareholders of record of March 31, 2014 was paid on April 15, 2014.
Why am I following this stock.
I wanted to review all the income trust stocks touted in the Money Show of 2009. There was a lot of talk at this show about some of the Income Trust being currently good buys with
very good yields. This stock changed from an income trust to a corporation in 2011.
How they make their money.
The North West Company is a leading retailer of food and everyday products and services to rural communities and urban neighborhoods in Canada, Alaska, the South Pacific and the Caribbean. North West
operates 225 stores under the trading names Northern, NorthMart, Giant Tiger, AC Value Center, and Cost-U-Less.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.
Also, for the Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Aug 27 2012 Sep 23 2013 Aug 14 2014 Oct 28 2015 Oct 29 2016
Kennedy, Edward Stephen 0.264 0.55% 0.264 0.54% 0.264 0.54% 0.304 0.63% 0.304 0.63%
CEO - Shares - Amount $6.105 $6.705 $7.016 $9.279 $7.780
Options - percentage 0.757 1.56% 0.960 1.98% 0.866 1.78% 1.379 2.84%
Options - amount $19.240 $25.490 $26.438 $35.285
King, John 0.056 0.12% 0.063 0.13% 0.070 0.14% 0.074 0.15%
CFO - Shares - Amount $1.434 $1.680 $2.130 $1.891
Options - percentage 0.089 0.18% 0.114 0.24% 0.093 0.19% 0.169 0.35%
Options - amount $2.275 $3.035 $2.835 $4.333
Beaulieu, Michael 0.022 0.05% 0.005 0.01%
Officer - Shares - Amount $0.668 $0.119
Options - percentage 0.011 0.02% 0.026 0.05%
Options - amount $0.343 $0.656
Bains, Dalbir Singh 0.001 0.00%
Officer - Shares - Amount $0.021
Options - percentage 0.056 0.12%
Options - amount $1.421
Evans, Frances Wendy 0.005 0.01% 0.000 0.00% 0.005 0.01% must of forgottent o
Director - Shares - Amount $0.141 $0.000 $0.136 update in 2015
Options - percentage 0.023 0.05% 0.000 0.00% 0.029 0.06%
Options - amount $0.617 $0.000 $0.732
Riley, Sanford 0.011 0.02% 0.000 0.00% 0.011 0.02% must of forgottent o
Chairman - Shares - Amt $0.292 $0.000 $0.281 update in 2015
Options - percentage 0.053 0.11% 0.000 0.00% 0.065 0.13%
Options - amount $1.411 $0.000 $1.651
Increase in O/S Shares 0.037 0.08% 0.071 0.15% 0.026 0.05%
due to SO $0.942 $1.897 $0.798
Book Value $0.711 $0.623 $0.450
Insider Buying -$2.379 -$0.179
Insider Selling $0.207 $0.000
Net Insider Selling $0.692 -$2.172 -$0.179
% of Market Cap 0.05% -0.15% -0.01%
Directors 9 8 10 11
Women 2 22% 3 38% 3 30% 3 27%
Minorities 0 0% 0 0% 0 0% 1 9%
Institutions/Holdings 39 28.23% 49 46.42% 36 25.00% 58 38.79% 68 30.93%
Total Shares Held 13.659 28.23% 22.505 46.47% 12.107 24.96% 18.813 38.79% 15.006 30.93%
Increase/Decrease -0.163 -1.18% 0.840 3.88% -0.089 -0.73% 0.375 2.03% -0.921 -5.78%
Starting No. of Shares 13.822 21.665 12.196 18.438 15.927
Copyright 2008 Website of SPBrunner. All rights reserved.