While I try to be accurate, I assume no responsibility for any figure in this spreadsheet.
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.
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ 7/31/11 Q1 2012
Evertz Technologies www.evertz.com TSX: ET Fiscal Yr: 30 Apr
Year 4/30/00 4/30/01 4/30/02 4/30/03 4/30/04 4/30/05 4/30/06 4/30/07 4/30/08 4/30/09 4/30/10 4/30/11 4/30/12 4/30/13 #Y
Accounting Rules C GAAP IFRS
Revenue* $98.1 $141.2 $200.7 $272.5 $315.9 $286.5 $307.9 $312.0 $344.0 213.85% <-Total Growth 6 Revenue
Increase 43.93% 42.12% 35.79% 15.93% -9.32% 7.48% 1.34% 10.26% #NUM! <-IRR #YR-> 10 Revenue
Rev per Share $1.51 $2.14 $2.78 $3.77 $4.32 $3.74 $4.18 $4.24 $4.67 16.87% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 0.00 5.14 5.85 5.04 3.91 3.74 3.80 3.02 2.74 #NUM! <-IRR #YR-> 10 Rev Per share
*Revenue in M CDN $  P/S 10 yr  3.91 5 yr  3.91 14.36% <-IRR #YR-> 5 Rev Per share
$0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $307.9
-$141.2 $0.0 $0.0 $0.0 $0.0 $307.9
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.18
-$2.14 $0.00 $0.00 $0.00 $0.00 $4.18
EPS* $0.02 $0.59 $0.83 $1.17 $1.36 $0.83 $1.03 $0.97 $1.18 5050.00% <-Total Growth 6 Earnings
Increase 2850% 40.68% 40.96% 16.24% -38.97% 24.10% -5.83% 21.65% #NUM! <-IRR #YR-> 10 Earnings
Earnings Yield 5.4% 5.1% 6.2% 8.0% 5.9% 6.5% 7.6% 9.2% 11.79% <-IRR #YR-> 5 Earnings
* ESP per share  E/P 10 Yrs 6.04% 5Yrs 6.16%
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.03
-$0.59 $0.00 $0.00 $0.00 $0.00 $1.03
Div* $0.20 $0.29 $0.32 $0.36 $0.46 $0.48 80.00% <-Total Growth 3 Dividends
Increase 45.00% 10.34% 12.50% 27.78% 4.35% 12.50% <-Median-> 3 Dividends
Yield H/L 0.73% 1.75% 2.17% 2.27% 1.96% <-Median-> 4 Dividends
Yield on High 0.48% 1.24% 1.88% 1.84% 1.54% <-Median-> 4 Dividends
Yield on Low 1.53% 2.97% 2.57% 2.95% 2.76% <-Median-> 4 Dividends
Yield on Cl 1.05% 1.72% 2.29% 2.26% 3.59% 3.75% 1.99% <-Median-> 4 Dividends
Payout Ratio 17.1% 21.3% 38.6% 35.0% 47.4% 40.7% 28.14% <-Median-> 4 Payout
Payout Ratio CF 17.5% 23.5% 41.0% 35.9% 44.2% 46.1% 29.73% <-Median-> 4 Payout
Payout Ratio CF NC 15.2% 18.6% 29.9% 30.3% 42.7% 44.5%
Median 5 Yrs Div Yd 5.79% 5 9.32% 10 Yield  1.96% 1.99% Payout 28.14% 29.73% 35.92% 41.04% #NUM! <-IRR #YR-> 10 Dividends
* Dividends per share  10.0% Years 10.0% Years Last Div Inc ---> $0.10 $0.12 20.0% 21.64% <-IRR #YR-> 3 Dividends
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.36
-$0.20 $0.00 $0.00 $0.36
H/LYield held 5 yrs 3.27% 3.22% 1.76% 3.27% <-Median-> 1 Dividends
H/LYield held 10 yrs #DIV/0! #NUM! <-Median-> 0 Dividends
Graham No. $1.27 $5.39 $8.28 $10.60 $8.72 $10.82 $10.43 $11.50 754.07% <-Total Growth 5 Graham Price
Prem /Disc.Med H/L 768.45% 164.74% 229.36% 56.15% 68.69% 46.84% 116.71% <-Median-> 6 Graham Price
Prem /Disc. High 768.45% 211.56% 400.39% 120.31% 94.88% 80.81% 165.94% <-Median-> 6 Graham Price
Prem /Disc. Low 768.45% 117.91% 58.34% -8.01% 42.49% 12.87% 50.42% <-Median-> 6 Graham Price
Prem /Disc. Cl 768.45% 201.36% 129.48% 59.46% 60.49% 46.98% 22.77% 11.31% 94.98% <-Median-> 6 Graham Price
Price Cl $11.00 $16.25 $19.00 $16.90 $14.00 $15.90 $12.80 $12.80 44.55% <-Total Growth 5 Stock Price
Increase #DIV/0! 47.73% 16.92% -11.05% -17.16% 13.57% -19.50% 0.00% #NUM! <-IRR #YR-> 10 Stock Price
P/E 18.64 19.58 16.24 12.43 16.87 15.44 13.20 10.85 7.65% <-IRR #YR-> 5 Stock Price
Trailing P/E 550.00 27.54 22.89 14.44 10.29 19.16 12.43 13.20 #NUM! <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs #NUM! 1.73% Div %  Ret. Price Inc 13.57% P/E:  16.55 16.24 9.38% <-IRR #YR-> 5 Price & Div
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.90
-$11.00 $0.00 $0.00 $0.00 $0.00 $15.90
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.20 $0.29 $0.32 $16.26
-$11.00 $0.00 $0.20 $0.29 $0.32 $16.26
Price H/L Median $11.00 $14.28 $27.27 $16.55 $14.72 $15.89 44.41% <-Total Growth 5 Stock Price
Increase 29.77% 91.03% -39.31% -11.09% 7.95% #NUM! <-IRR #YR-> 10 Stock Price
P/E 18.64 17.20 23.31 12.17 17.73 15.42 7.63% <-IRR #YR-> 5 Stock Price
Trailing P/E 550.00 24.19 32.86 14.15 10.82 19.14 #NUM! <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs #NUM! 1.73% Div %  Ret. Price Inc 7.95% P/E:  17.46 17.20 9.36% <-IRR #YR-> 5 Price & Div
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.89
-$11.00 $0.00 $0.00 $0.00 $0.00 $15.89
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.20 $0.29 $0.32 $16.25
-$11.00 $0.00 $0.20 $0.29 $0.32 $16.25
Hi Mths Apr 07 Dec 07 May 08 May 09 Mar 11 Stock Price
Price Hi $11.00 $16.80 $41.43 $23.35 $17.00 $19.56 77.82% <-Total Growth 5 Stock Price
Increase 52.73% 146.61% -43.64% -27.19% 15.06% #NUM! <-IRR #YR-> 10 Stock Price
P/E 18.64 20.24 35.41 17.17 20.48 18.99 12.20% <-IRR #YR-> 5 Stock Price
Trailing P/E 550.00 28.47 49.92 19.96 12.50 23.57
Median 10, 5 Yrs Price Inc 15.06% P/E:  19.62 20.24
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19.56
-$11.00 $0.00 $0.00 $0.00 $0.00 $19.56
Low Mths Jul 06 Mar 08 Dec 08 Dec 09 May-10 Stock Price
Price Low $11.00 $11.75 $13.11 $9.75 $12.43 $12.21 11.00% <-Total Growth 5 Stock Price
Increase 6.82% 11.57% -25.63% 27.49% -1.77% #NUM! <-IRR #YR-> 10 Stock Price
P/E 18.64 14.16 11.21 7.17 14.98 11.85 2.11% <-IRR #YR-> 5 Stock Price
Trailing P/E 550.00 19.92 15.80 8.33 9.14 14.71
Median 10, 5 Yrs Price Inc 6.82% P/E:  13.01 11.85
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.21
Market Cap $726 $1,174 $1,373 $1,236 $1,073 $1,170 $942 $942
# of Sh in M 64.82 66.03 72.22 72.28 73.11 76.61 73.61 73.61 73.61 Shares
Increase 1.87% 9.37% 0.08% 1.15% 4.79% -3.92% V 12 mths V 12 mths 1.51% <-Median-> 6 Shares
CF fr Op $M $15.3 $12.7 $31.4 $82.5 $90.1 $59.7 $73.8 76.7 76.7 382.18% <-Total Growth 6 Cash Flow
OPS $0.24 $0.19 $0.43 $1.14 $1.23 $0.78 $1.00 $1.04 $1.04 324.60% <-Total Growth 6 Cash Flow
Non-Cash CF -$12.0 $32.2 $31.8 $12.8 $23.8 $22.1 $13.6 $2.7 $2.7 #NUM! <-IRR #YR-> 10 Cash Flow
OPS non-cash $0.05 $0.68 $0.87 $1.32 $1.56 $1.07 $1.19 $1.08 $1.08 39.20% <-IRR #YR-> 5 Cash Flow
P/OCF on Close 0.00 16.18 18.58 14.40 10.85 13.10 13.40 11.88 11.88 #NUM! <-IRR #YR-> 10 CF - non cash
*Operational Cash Flow per share P/CF 10 yr 13.40 5 yr  13.40 11.78% <-IRR #YR-> 5 CF - non cash
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.00
-$0.19 $0.00 $0.00 $0.00 $0.00 $1.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.19
-$0.68 $0.00 $0.00 $0.00 $0.00 $1.19
OPM 15.60% 8.97% 15.63% 30.29% 28.51% 20.85% 23.96% 24.57% should be zero, it is a check on calculations
Diff from Median -14.5% -50.8% -14.3% 66.1% 56.3% 14.3% 31.4% 34.7% 0.14 <-Median-> 7 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 18.24% 5 Yrs 20.85% 23.96%
Curr Assets $49.30 $46.36 $115.04 $192.64 $255.88 $289.61 $353.04 $352.91 Liq ratio of 1.5 and up, best Assets
Curr Liab. $48.11 $47.17 $25.04 $28.50 $39.34 $25.45 $28.80 $32.54 6.50 <-Median-> 7 Liabilities
Liquidity 1.02 0.98 4.59 6.76 6.50 11.38 12.26 10.85 6.76 <-Median-> 5 Ratio
Liq. with CF aft div 1.34 1.25 5.85 9.15 8.25 12.76 13.90 12.16
Liq. CF re  Inv+Div  12.14 32.0442 10.98133 12.16111
Assets $60.40 $61.71 $144.00 $220.58 $316.45 $345.79 $409.86 $408.48 A/L ratio of 1.5 and up, best Assets
Liabilities $54.94 $53.73 $31.05 $32.26 $46.14 $32.21 $36.61 $40.68 6.84 <-Median-> 7 Liabilities
A/L Ratio 1.10 1.15 4.64 6.84 6.86 10.74 11.20 10.04 6.86 <-Median-> 5 Ratio
check $54.94 $53.73 $31.56 $32.36 $48.07 $33.62 $38.16 $41.84
Non-cont. Int $0.00 $0.00 $0.51 $0.10 $1.93 $1.41 $1.55 $1.16
Book Value $5.46 $7.98 $112.44 $188.22 $268.38 $312.17 $371.70 $366.64 6707.77% <-Total Growth 6 Book Value
BV per share $0.08 $0.12 $1.56 $2.60 $3.67 $4.07 $5.05 $4.98 $4.98 5894.83% <-Total Growth 6 Book Value
Change 43.48% 1188.25% 67.26% 40.97% 11.00% 23.92% -1.36% 0.6839 Current/Historical Book Value
P/BV (CL) 0.00 91.02 10.44 7.30 4.60 3.44 3.15 2.57 #NUM! <-IRR #YR-> 10 Book Value
Change #DIV/0! -88.53% -30.09% -36.90% -25.37% -8.35% -18.38% 110.96% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 11.06 7.73 1.28 1.17 1.18 1.11 1.10 1.11 1.18 <-Median-> 7 A/BV
Debt/Equity Ratio 10.06 6.73 0.28 0.17 0.17 0.10 0.10 0.11 0.17 <-Median-> 7 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Ave 4.60 5 yr Ave 4.60
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.05
-$0.12 $0.00 $0.00 $0.00 $0.00 $5.05
ROE 0.0% 0.0% 0.0% 0.0% 18.7% 21.0% 0.00% <-Median-> 5 Compreh. Inc
Comprehensive Inc $0.00 $0.00 $0.00 $0.00 $58.47 $78.00 Compreh. Inc
ROE 28.6% 498.2% 53.9% 46.4% 37.5% 19.7% 20.8% 20.2% Net Income/Shareholders' equity
5Yr Median 28.6% 263.4% 53.9% 50.2% 46.4% 46.4% 37.5% 20.8%
Net Income $1.56 $39.76 $60.66 $87.29 $100.72 $61.50 $77.39 $74.10 <-12 mths 4861.09% <-Total Growth 6 Net Income
Oper C. F. $15.30 $12.66 $31.36 $82.54 $90.06 $59.74 $73.77 C F Statement  Oper C. F.
Invest. C. F -$4.57 -$11.72 -$48.33 -$59.56 $12.59 $15.31 -$7.66 C F Statement  Invest. C. F
Total Accruals -$9.17 $38.82 $77.63 $64.31 -$1.93 -$13.55 $11.28 Accruals
Total Assets $60.40 $61.71 $144.00 $220.58 $316.45 $345.79 $409.86 Balance Sheet Assets
Accruals Ratio -15.18% 62.91% 53.91% 29.15% -0.61% -3.92% 2.75% Ratio
up/down/neutral
Chge in Close 0.00% #DIV/0! 47.73% 16.92% -11.05% -17.16% 13.57%
Any Predictions?
Fin. C. F $1.76 -$38.25 $37.98 -$13.42 -$30.68 -$22.98 -$23.21 C F Statement  Fin. C. F
Total Accruals -$10.93 $77.07 $39.65 $77.73 $28.75 $9.44 $34.49 Accruals
Accruals Ratio -18.10% 124.89% 27.53% 35.24% 9.09% 2.73% 8.42% Ratio
Oct 15, 2011.  This company was founded in 1966, but only went public in June 2006. Got financial statements from G&M as they are not on Evertz's site.
How they make their money.
Evertz Technologies Limited designs, manufactures and markets video and audio infrastructure equipment for the production, post production, 
broadcast and internet protocol television ("IPTV") industry.
Got idea to investigate this stock fom G&M Article. 
http://www.theglobeandmail.com/globe-investor/investment-ideas/number-cruncher/dividends-and-a-dollop-of-growth-mix-well/article2198878/ 
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. Q1 2012
% of shares % of value
Magarelli, Romolo 24.164 $309,299,200 32.83% 32.83% 32.83%
% of shares % of value
Campbell, Brian Scott 2.550 $33,649,485 3.46% 3.57% 3.57%
% of shares % of value
DeBruin, Douglas Anthony 24.164 $318,865,155 32.83% 33.84% 33.84%
Patel, Rakesh Thakor % of shares % of value
1.709 $22,553,072 2.32% 2.39% 2.39%
Owned by insiders 72.63%
Institutional Owners 3.788 $49,985,333 5.15% 5.31% 5.31%
0.005 $56,407 0.12% bought
3.783 77.94%