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.
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Transcontinental Inc TSX: TCL.A http://www.transcontinental.com/ Fiscal Yr: Oct 31
Year 10/31/00 10/31/01 10/31/02 10/31/03 10/31/04 10/31/05 10/31/06 10/31/07 10/31/08 10/31/09 10/31/10 10/31/11 10/30/12 10/30/13 10/30/14 #Y
Accounting Rules C GAAP
Revenue* $1,628.1 $1,781.8 $1,778.0 $1,907.2 $2,048.0 $2,202.0 $2,282.3 $2,326.2 $2,429.3 $2,294.6 $2,091.6 $2,043.6 $2,203.0 $2,232.0 14.69% <-Total Growth 10 Revenue
Increase 5.13% 9.44% -0.21% 7.27% 7.38% 7.52% 3.65% 1.92% 4.43% -5.54% -8.85% -2.29% 7.80% 1.32% 1.38% <-IRR #YR-> 10 Revenue
Rev per Share $21.83 $21.60 $20.05 $21.51 $23.05 $24.66 $26.53 $27.82 $30.07 $28.40 $25.89 $25.22 $27.27 $27.63 -2.19% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 0.41 0.52 0.95 1.00 1.04 0.84 0.73 0.73 0.40 0.46 0.59 0.50 0.48 0.47 1.56% <-IRR #YR-> 10 Rev per share
*Revenue in M CDN $  P/S 10 yr  0.73 5 yr  0.50 -1.00% <-IRR #YR-> 5 Rev per share
-$1,781.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,043.6
-$2,282.3 $0.0 $0.0 $0.0 $0.0 $2,043.6
-$21.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.22
-$26.53 $0.00 $0.00 $0.00 $0.00 $25.22
EPS* $0.82 $0.26 $1.45 $1.61 $1.44 $1.55 $1.55 $1.42 $0.08 -$1.02 $2.06 $0.96 $1.98 $2.11 $1.73 269.23% <-Total Growth 10 Earnings
Increase 34.43% -68.29% 457.69% 11.03% -10.56% 7.64% 0.00% -8.39% -94.37% -1375% -302% -53% 106% 7% -18% 13.95% <-IRR #YR-> 10 Earnings
Earnings Yield 9.3% 2.3% 7.6% 7.5% 6.0% 7.5% 8.0% 7.0% 0.7% -7.9% 13.5% 7.6% 15.3% 16.3% 13.3% -9.14% <-IRR #YR-> 5 Earnings
* ESP per share (Cdn GAAP) E/P 10 Yrs 7.48% 5Yrs 6.98%
-$0.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.96
-$1.55 $0.00 $0.00 $0.00 $0.00 $0.96
pre-split 03
Div* $0.10 $0.10 $0.12 $0.14 $0.17 $0.21 $0.25 $0.28 $0.31 $0.32 $0.35 $0.49 $0.54 $0.54 $0.54 390.00% <-Total Growth 10 Dividends
Increase 25.00% 0.00% 20.00% 16.67% 21.43% 23.53% 19.05% 10.00% 12.73% 3.23% 9.38% 40.00% 10.20% 0.00% 0.00% 17.86% <-Median-> 10 Dividends
Yield H/L Pr. 1.10% 0.99% 0.75% 0.74% 0.68% 0.88% 1.29% 1.31% 1.97% 3.62% 2.58% 3.56% #DIV/0! #DIV/0! #DIV/0! 1.30% <-Median-> 10 Dividends
Yield on High  Pr. 0.98% 0.83% 0.57% 0.62% 0.61% 0.77% 1.19% 1.21% 1.53% 2.64% 2.27% 2.86% 1.20% <-Median-> 10 Dividends
Yield on Low Pr. 1.27% 1.20% 1.12% 0.91% 0.77% 1.03% 1.40% 1.42% 2.76% 5.73% 3.00% 4.71% 1.41% <-Median-> 10 Dividends
Yield on Cl Pr. 1.13% 0.90% 0.63% 0.65% 0.71% 1.02% 1.29% 1.35% 2.60% 2.46% 2.29% 3.86% 4.16% 4.16% 4.16% 1.32% <-Median-> 10 Dividends
Payout Ratio 12.2% 38.5% 8.3% 8.7% 11.8% 13.5% 16.1% 19.4% 387.5% -31.4% 17.0% 51.0% 27.3% 25.6% 31.2% 14.84% <-Median-> 10 DPR EPS
Payout Ratio CF 5.3% 3.1% 4.2% 5.7% 4.7% 6.1% 10.1% 9.5% 8.8% 32.8% 17.2% 12.9% 16.3% 15.3% #DIV/0! 9.18% <-Median-> 10 DPR CF
Payout Ratio CF NC 4.6% 4.2% 4.6% 4.9% 5.5% 7.1% 7.9% 8.0% 8.4% 10.4% 8.9% 12.6% 16.3% 15.3% #DIV/0! 7.94% <-Median-> 10 DPR CF NC
Median Values Div Yd 4.82% 5 5.59% 10 Yield  2.58% 2.46% Payout 19.37% 12.89% 17.22% <-IRR #YR-> 10 Dividends
* Dividends per share  3.0% Years 3.0% Years Curr diff 61.12% Last Div Inc ---> $0.11 $0.14 22.7% 14.41% <-IRR #YR-> 5 Dividends
-$0.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.49
-$0.25 $0.00 $0.00 $0.00 $0.00 $0.49
H/LYield held 5 yrs 2.28% 1.88% 2.17% 1.97% 2.06% 2.32% 2.46% 1.72% 1.64% 1.28% 1.47% 2.53% 2.57% 3.44% 6.11% 2.02% <-Median-> 10 Dividends
H/LYield held 10 yrs 5.16% 4.79% 3.47% 2.85% 3.70% 4.79% 4.70% 4.96% 4.36% 3.88% 3.86% 4.83% 3.38% 2.85% 2.16% 4.12% <-Median-> 10 Dividends
H/LYield held 15 yrs 4.87% 5.86% 10.84% 11.98% 7.94% 6.32% 6.96% 7.99% 9.22% 9.75% 7.59% 6.55% 7.94% <-Median-> 9 Dividends
H/LYield held 20 yrs 10.78% 11.03% 18.06% 23.47% 15.60% 11.00% 11.75% 14.55% <-Median-> 4 Dividends
Graham No. $10.87 $6.30 $16.76 $18.84 $18.90 $20.78 $21.47 $21.21 $4.96 $4.98 $25.69 $18.12 $26.07 $26.91 $24.36 187.68% <-Total Growth 10 Graham Price
Prem /Disc.Med H/L -16.6% 61.1% -4.6% 0.4% 32.5% 14.2% -9.7% -0.8% 217.1% 77.3% -47.2% -24.0% -0.19% <-Median-> 10 Graham Price
Prem /Disc. High -5.7% 90.5% 26.6% 19.1% 48.6% 30.4% -2.4% 7.2% 307.5% 142.8% -39.9% -5.4% 22.82% <-Median-> 10 Graham Price
Prem /Disc. Low -27.5% 31.7% -35.9% -18.2% 16.4% -2.0% -16.9% -8.9% 126.7% 11.9% -54.6% -42.6% -12.90% <-Median-> 10 Graham Price
Prem /Disc. Cl -18.6% 76.8% 14.1% 14.6% 27.3% -0.7% -9.7% -4.1% 140.6% 160.6% -40.4% -29.9% -50.2% -51.8% -46.7% 6.72% <-Median-> 10 Graham Price
pre-split 03
Price Cl $8.85 $11.14 $19.13 $21.60 $24.06 $20.64 $19.40 $20.34 $11.93 $12.99 $15.31 $12.70 $12.98 $12.98 $12.98 14.00% <-Total Growth 10 Stock Price
Increase -7.33% 25.88% 71.72% 12.91% 11.39% -14.21% -6.01% 4.85% -41.35% 8.89% 17.86% -17.05% 2.20% 0.00% 0.00% 1.32% <-IRR #YR-> 10 Stock Price
P/E 10.79 42.85 13.19 13.42 16.71 13.32 12.52 14.32 149.13 -12.74 7.43 13.23 6.56 6.15 7.50 -8.12% <-IRR #YR-> 5 Stock Price
Trailing P/E 14.51 13.59 73.58 14.90 14.94 14.33 12.52 13.12 8.40 162.38 -15.01 6.17 13.52 6.56 6.15 3.47% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs D.  per yr 2.15% 2.17% % Tot Ret 62.00% -36.53% Price Inc 4.85% P/E:  13.27 13.23 -5.95% <-IRR #YR-> 5 Price & Div
-$11.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.70
-$19.40 $0.00 $0.00 $0.00 $0.00 $12.70
-$11.14 $0.12 $0.14 $0.17 $0.21 $0.25 $0.28 $0.31 $0.32 $0.35 $13.19
-$19.40 $0.28 $0.31 $0.32 $0.35 $13.19
Price H/L Median $9.07 $10.15 $15.99 $18.93 $25.05 $23.73 $19.40 $21.04 $15.72 $8.84 $13.56 $13.78 35.71% <-Total Growth 10 Stock Price
Increase 10.01% 11.97% 57.49% 18.39% 32.34% -5.25% -18.25% 8.43% -25.27% -43.77% 53.34% 1.62% 3.10% <-IRR #YR-> 10 Stock Price
P/E 11.05 39.04 11.02 11.75 17.39 15.31 12.52 14.81 196.50 -8.67 6.58 14.35 -6.62% <-IRR #YR-> 5 Stock Price
Trailing P/E 14.86 12.38 61.48 13.05 15.56 16.48 12.52 13.57 11.07 110.50 -13.29 6.69 5.26% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs D.  per yr 2.15% 2.09% % Tot Ret 41.00% -46.23% Price Inc 1.62% P/E:  13.43 14.35 -4.53% <-IRR #YR-> 5 Price & Div
-$10.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.78
-$19.40 $0.00 $0.00 $0.00 $0.00 $13.78
-$10.15 $0.12 $0.14 $0.17 $0.21 $0.25 $0.28 $0.31 $0.32 $0.35 $14.27
-$19.40 $0.28 $0.31 $0.32 $0.35 $14.27
Hi Mths Mar Aug May Dec May 08 Oct 09 Oct 10 Jan 11
pre-split 03
Price Hi $10.25 $12.00 $21.22 $22.43 $28.09 $27.10 $20.95 $22.75 $20.20 $12.10 $15.45 $17.15 42.92% <-Total Growth 10 Stock Price
Increase 0.00% 17.07% 76.83% 5.70% 25.23% -3.52% -22.69% 8.59% -11.21% -40.10% 27.69% 11.00% 3.64% <-IRR #YR-> 10 Stock Price
P/E 12.50 46.15 14.63 13.93 19.51 17.48 13.52 16.02 252.50 -11.86 7.50 17.86 -3.92% <-IRR #YR-> 5 Stock Price
Trailing P/E 16.80 14.63 81.62 15.47 17.45 18.82 13.52 14.68 14.23 151.25 -15.15 8.33
Median 10, 5 Yrs Price Inc 8.59% P/E:  15.33 16.02
-$12.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.15
-$20.95 $0.00 $0.00 $0.00 $0.00 $17.15
Low Mths Nov Oct Mar Aug Oct 08 Mar 09 May 10 Oct 11
Price Low $7.88 $8.30 $10.75 $15.42 $22.00 $20.36 $17.85 $19.32 $11.24 $5.58 $11.66 $10.40 25.30% <-Total Growth 10 Stock Price
Increase 26.48% 5.33% 29.52% 43.44% 42.67% -7.45% -12.33% 8.24% -41.82% -50.36% 108.96% -10.81% 2.28% <-IRR #YR-> 10 Stock Price
P/E 9.61 31.92 7.41 9.58 15.28 13.14 11.52 13.61 140.50 -5.47 5.66 10.83 -10.24% <-IRR #YR-> 5 Stock Price
Trailing P/E 12.92 10.12 41.35 10.63 13.66 14.14 11.52 12.46 7.92 69.75 -11.43 5.05
Median 10, 5 Yrs Price Inc -10.81% P/E:  11.17 10.83
-$8.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.40
Market Cap $660 $919 $1,697 $1,915 $2,138 $1,843 $1,669 $1,701 $964 $1,050 $1,237 $1,029 $1,049 $1,049 $1,049
# of Sh in M 74.57 82.50 88.70 88.66 88.86 89.31 86.04 83.61 80.78 80.79 80.79 81.02 80.79 80.79 80.79 -1.79% <-Total Growth 10 Shares
Increase 0.58% 10.63% 7.51% -0.05% 0.23% 0.50% -3.66% -2.82% -3.39% 0.02% 0.00% 0.28% -0.28% 0.00% 0.00% 0.01% <-Median-> 10 Shares
CF fr Op $M $141.2 $267.1 $251.0 $217.5 $318.9 $308.0 $214.0 $241.0 $284.0 $78.8 $164.2 $308.1 $267.4 $285.2 15.35% <-Total Growth 10 Cash Flow
OPS $1.89 $3.24 $2.83 $2.45 $3.59 $3.45 $2.49 $2.88 $3.52 $0.98 $2.03 $3.80 $3.31 $3.53 17.45% <-Total Growth 10 Cash Flow
Increase -17.93% 70.96% -12.60% -13.32% 46.31% -3.90% -27.88% 15.88% 21.98% -72.26% 108.38% 87.11% -12.95% 6.65% 1.62% <-IRR #YR-> 10 Cash Flow
Non-Cash CF $22.00 -$70.19 -$21.83 $38.38 -$42.95 -$43.90 $57.10 $48.10 $12.9 $168.7 $153.8 $6.3 $0.0 $0.0 8.86% <-IRR #YR-> 5 Cash Flow
OPS non-cash $2.19 $2.39 $2.58 $2.89 $3.11 $2.96 $3.15 $3.46 $3.68 $3.06 $3.94 $3.88 $3.31 $3.53 4.98% <-IRR #YR-> 10 CF - non cash
Increase 5.39% 9.05% 8.24% 11.70% 7.61% -4.77% 6.55% 9.73% 6.30% -16.66% 28.48% -1.41% -14.70% 6.65% 4.25% <-IRR #YR-> 5 CF - non cash
P/O on Cl 4.04 4.67 7.40 7.49 7.75 6.98 6.16 5.88 3.25 4.24 3.89 3.27 3.92 3.68
*Operational Cash Flow per share P/CF 10 Yrs 5.63 5 Yrs 4.11
-$3.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.80
-$2.49 $0.00 $0.00 $0.00 $0.00 $3.80
-$2.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.88
-$3.15 $0.00 $0.00 $0.00 $0.00 $3.88
OPM 8.7% 15.0% 14.1% 11.4% 15.6% 14.0% 9.4% 10.4% 11.7% 3.4% 7.9% 15.1% should be zero, it is a check on calculations
Diff from Ave -24.87% 29.84% 22.25% -1.25% 34.86% 21.14% -18.79% -10.27% 1.25% -70.26% -32.01% 30.58% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 11.55% 5 Yrs 10.36%
Curr Assets $311.07 $315.69 $249.13 $308.42 $400.20 $496.05 $384.30 $367.90 $445.80 $482.60 $633.00 $644.60 Liq ratio of 1.5 and up, best Assets
Curr Liab. $396.83 $393.20 $420.27 $388.27 $493.32 $553.27 $536.70 $499.90 $745.00 $457.10 $445.90 $643.60 0.80 <-Median-> 10 Liabilities
Liquidity 0.78 0.80 0.59 0.79 0.81 0.90 0.72 0.74 0.60 1.06 1.42 1.00 1.00 <-Median-> 5 Ratio
Liq. with CF aft div 1.12 1.46 1.16 1.32 1.43 1.42 1.07 1.17 0.95 1.17 1.72 1.42 1.17 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.68 1.08 0.53 0.96 0.88 0.97 0.73 0.74 0.66 0.72 1.52 1.31 0.74 <-Median-> 5 Ratio
Assets $1,505.8 $1,340.7 $1,702.9 $1,719.7 $2,014.1 $2,249.1 $2,262.4 $2,369.6 $2,615.0 $2,549.7 $2,594.7 $2,453.6 A/L ratio of 1.5 and up, best Assets
Liab. $1,015.2 $768.7 $937.6 $849.5 $1,033.0 $1,142.4 $1,122.6 $1,191.9 $1,511.9 $1,433.7 $1,346.9 $1,123.8 1.96 <-Median-> 10 Liabilities
A/L Ratio 1.48 1.74 1.82 2.02 1.95 1.97 2.02 1.99 1.73 1.78 1.93 2.18 1.93 <-Median-> 5 Ratio
Non-Cont. Int $13.3 $12.2 $1.4 $1.4 $1.2 $0.8 $2.2 $0.1 $0.1 $0.8 $0.8 $0.8
Total Book Value $1,103.0 $1,115.2 $1,247.0 $1,329.0
Preferrerd Shares $0.0 $96.8 $96.8 $96.8
Book Value $477.3 $559.8 $763.9 $868.7 $979.9 $1,105.9 $1,137.6 $1,177.6 $1,103.0 $1,115.2 $1,150.2 $1,232.2 $1,232.2 $1,232.2 $1,232.2 120.13% <-Total Growth 10 Book Value
BV per share $6.40 $6.78 $8.61 $9.80 $11.03 $12.38 $13.22 $14.08 $13.65 $13.80 $14.24 $15.21 $15.25 $15.25 $15.25 124.14% <-Total Growth 10 Book Value
Change 4.38% 6.01% 26.94% 13.78% 12.54% 12.29% 6.78% 6.52% -3.05% 1.09% 3.14% 6.82% 0.28% 0.00% 0.00% 0.5708 Current/Historical Book Value
P/BV (CL) 1.38 1.64 2.22 2.20 2.18 1.67 1.47 1.44 0.87 0.94 1.08 0.84 0.85 0.85 0.85 8.41% <-IRR #YR-> 10 Book Value
Change -11.22% 18.74% 35.28% -0.76% -1.02% -23.60% -11.97% -1.57% -39.50% 7.72% 14.27% -22.35% 1.92% 0.00% 0.00% 2.84% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 3.15 2.40 2.23 1.98 2.06 2.03 1.99 2.01 2.37 2.29 2.26 1.99 2.04 <-Median-> 10 A/BV
Debt/Equity Ratio 2.13 1.37 1.23 0.98 1.05 1.03 0.99 1.01 1.37 1.29 1.17 0.91 1.04 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Ave 1.49 5 yr Ave 1.03
-$6.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.21
-$13.22 $0.00 $0.00 $0.00 $0.00 $15.21
ROE 9.3% 0.0% -5.5% 14.3% 10.4% 9.32% <-Median-> 5 Compreh. Inc
Comprehensive Inc $109.7 $0.3 -$61.2 $164.2 $127.6 Compreh. Inc
ROE 12.8% 3.7% 16.2% 16.5% 13.1% 12.6% 11.9% 10.2% 0.6% -7.3% 14.5% 6.3% Net Income/Shareholders' equity
5Yr Median 9.2% 9.2% 10.0% 12.8% 13.1% 13.1% 13.1% 12.6% 11.9% 10.2% 10.2% 6.3%
Net Income $61.08 $20.73 $124.01 $143.01 $128.86 $138.95 $135.80 $120.60 $6.60 -$81.80 $166.60 $77.80 275.39% <-Total Growth 10 Net Income
Oper C. F. $141.23 $267.11 $250.97 $217.45 $318.90 $308.00 $214.00 $241.00 $284.00 $78.80 $164.20 $308.10 C F Statement  Oper C. F.
Invest. C. F -$252.89 -$138.94 -$500.19 -$148.32 -$307.44 -$257.89 -$251.80 -$287.80 -$325.40 -$285.50 -$61.40 -$52.70 C F Statement  Invest. C. F
Total Accruals $172.74 -$107.45 $373.23 $73.88 $117.41 $88.85 $173.60 $167.40 $48.00 $124.90 $63.80 -$177.60 Accruals
Total Assets $1,506 $1,341 $1,703 $1,720 $2,014 $2,249 $2,262 $2,370 $2,615 $2,550 $2,595 $2,454 Balance Sheet Assets
Accruals Ratio 11.47% -8.01% 21.92% 4.30% 5.83% 3.95% 7.67% 7.06% 1.84% 4.90% 2.46% -7.24% Ratio
up/down/neutral
Chge in Close -7.33% 25.88% 71.72% 12.91% 11.39% -14.21% -6.01% 4.85% -41.35% 8.89% 17.86% -17.05%
Any Predictions?
Fin. C. F $67.73 -$24.24 $168.49 -$4.77 $31.12 $32.44 -$94.20 $9.20 $78.10 -$154.30 -$99.70 -$217.00 C F Statement  Fin. C. F
Total Accruals $105.01 -$83.21 $204.74 $78.65 $86.28 $56.41 $267.80 $158.20 -$30.10 $279.20 $163.50 $39.40 Accruals
Accruals Ratio 6.97% -6.21% 12.02% 4.57% 4.28% 2.51% 11.84% 6.68% -1.15% 10.95% 6.30% 1.61% Ratio
Feb 7, 2012.  Last Estimates I got for 2011 and 2012 are $1.89 amd $2.01 for EPS and $3.24 and $3.60 for CF.
2007 - I think the only way to make money on this stock on a long term basis, is buy at or below the Graham price.
Class A Subordinate Voting Shares, and Class B shares.
How they make their money.
Transcontinental, one of Canada's top media groups, is the largest printer in Canada and Mexico and the fourth-largest in North America. In addition to commercial printing, it operates 150 websites and is  
a leading publisher of consumer magazines, French-language educational resources and community newspapers in Quebec and the Atlantic provinces.
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.
Copyright © 2008 Website of SPBrunner. All rights reserved.
Marcoux, Rémi; Officer of the company 13.210 $171,463,723
Ownes most of the Category B shares.
Dubois, Claude 0.004 $51,920
Institutions 53.277
0.515 0.96%
53.792