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/
Computer Modelling Group Ltd www.cmgl.ca TSX: CMG OTH: CMDXF Fiscal Yr: Mar 31
Year ----> 3/31/00 3/31/01 3/31/02 3/31/03 3/31/04 3/31/05 3/31/06 3/31/07 3/31/08 3/31/09 3/31/10 3/31/11 3/30/12 3/30/13 Value Calc #Y Description
Accting Rules C GAAP C GAAP
Revenue* $8.545 $9.310 $9.927 $11.222 $12.334 $15.164 $17.220 $23.715 $27.993 $43.942 $45.303 $51.827 $55.100 $59.530 456.66% <-Total Growth 10 Revenue
Increase 5.10% 8.96% 6.63% 13.04% 9.91% 22.94% 13.56% 37.72% 18.04% 56.97% 3.10% 14.40% 6.32% 8.04% 18.73% <-IRR #YR-> 10 Revenue
Rev per Share $0.25 $0.27 $0.35 $0.38 $0.40 $0.49 $0.53 $0.77 $0.83 $1.27 $1.27 $1.42 $1.51 $1.63 24.65% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 0.25 0.61 0.75 1.31 3.01 2.86 3.66 4.30 4.58 4.32 6.79 9.12 8.79 8.14 18.02% <-IRR #YR-> 10 Rev per share
*Revenue in M CDN $  P/S 10 yr  3.98 5 yr  4.58 21.70% <-IRR #YR-> 5 Rev per share
-$9.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $51.8
-$17.2 $0.0 $0.0 $0.0 $0.0 $51.8
-$0.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1.4
-$0.5 $0.0 $0.0 $0.0 $0.0 $1.4
EPS* -$0.03 $0.04 $0.08 $0.08 $0.08 $0.11 $0.12 $0.21 $0.22 $0.48 $0.40 $0.47 $0.54 $0.60 I 994.12% <-Total Growth 9 Earnings
Increase -80.00% -270.00% 76.47% 6.67% 3.13% 30.30% 13.95% 69.39% 7.23% 113.48% -15.79% 16.25% 16.13% 11.11% 27.03% <-IRR #YR-> 10 Earnings
* ESP per share (Cdn GAAP) 30.58% <-IRR #YR-> 5 Earnings
-$0.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.47
-$0.12 $0.00 $0.00 $0.00 $0.00 $0.47
Total Div $0.83 $0.09 $0.10 $0.13 $0.21 $0.32 $0.47 $0.47 $0.52 $0.42 422.22% <-Total Growth 6 Div Total
Pre-split 09 Sp D $0.05 $0.20 $0.20 $0.24 $0.18 $0.25
Pre-split 11 $0.10 $0.10 $0.12 $0.09 $0.13 $0.22 $0.17 $0.20
Special Div $0.05 $0.05 $0.06 $0.05 $0.06 $0.11 $0.09 $0.10 $0.00 $0.06 <-Median-> 7 Div Sp
Pre-split 09 Div $0.16 $0.20 $0.29 $0.65 $1.02
Pre-split 11 $0.08 $0.10 $0.15 $0.33 $0.51 $0.72 $0.77
Div* $0.04 $0.05 $0.07 $0.16 $0.26 $0.36 $0.39 $0.42 $0.42 862.50% <-Total Growth 6 Div Reg
Increase Reg D 25.00% 45.00% 124.14% 56.92% 41.18% 6.94% 9.09% 0.00% 43.09% <-Median-> 6 Div Reg
Increase Tot D Recent dividend increases 11.11% 32.50% 56.60% 53.01% 48.03% 0.00% 10.64% -19.23% 40.27% <-Median-> 6 Div Total
Yield H/L 3.39% 3.03% 2.72% 4.18% 5.60% 5.38% 3.63% 3.63% <-Median-> 7 Div Reg
Yield on High 2.86% 2.44% 2.03% 3.59% 4.49% 4.11% 2.97% 2.97% <-Median-> 7 Div Reg
Yield on Low 4.16% 3.99% 4.14% 5.00% 7.45% 7.78% 4.69% 4.69% <-Median-> 7 Div Reg
Yield on Cl 2.86% 2.56% 2.18% 4.28% 4.64% 4.17% 2.97% 3.16% 3.16% 2.97% <-Median-> 7 Div Reg
Payout Ratio 83.7% 81.6% 63.9% 93.3% 66.8% 117.5% 101.1% 96.3% 70.0% 83.72% <-Median-> 7 Div Reg
Payout Ratio CF 64.6% 71.0% 51.7% 79.4% 60.0% 100.9% 85.8% 71.02% <-Median-> 7 Div Reg
Average 5 Yrs Div Yd 5.32% in 5 yrs 8.97% in 10 yrs in 10 yrs Yield  4.18% 4.17% Payout 93.26% 79.43% 45.85% <-IRR #YR-> 6 Div Reg
* Dividends per share  11.00% 5 11.00% 10 10 Last Div Inc ---> $0.10 $0.11 5.0% 50.42% <-IRR #YR-> 5 Div Reg
-$0.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.39
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.39
I am earning Pension $6.31 2008 6.66%
Yield if held 5 yrs 0.00% 32.00% 29.85% 32.04% 38.24% 29.18% 30.51% 23.32% 15.78% 10.81% Ave H/L Yield on your 
Yield if held 10 yrs 12.89% 28.89% 219.35% 288.00% 229.85% 185.64% 98.82% Ave H/L original money
Graham No. $0.37 $0.61 $0.72 $0.82 $1.01 $1.13 $1.68 $1.72 $2.93 $2.77 $3.21 $3.45 $3.64 Cl Pr higher/lower by?
Prem/Disc High -37.7% -56.2% -24.1% 59.5% 37.8% 81.9% 112.2% 162.7% 93.9% 215.7% 305.0% 87.92% <-Median-> 10 Graham Price
Prem/Disc Low -71.6% -69.0% -58.6% -45.1% -5.1% 11.1% 4.0% 88.6% 17.0% 66.9% 156.0% 7.55% <-Median-> 10 Graham Price
Prem/Disc Cl -55.3% -56.6% -31.0% 46.6% 37.8% 73.0% 97.2% 120.6% 87.8% 211.2% 305.0% 285.0% 265.3% 80.40% <-Median-> 10 Graham Price
Pre-split 09 $0.25 $0.66 $1.05 $2.00 $4.78 $5.59 $7.80 $13.28 $15.20
Pre-split 11 $0.13 $0.33 $0.53 $1.00 $2.39 $2.80 $3.90 $6.64 $7.60 $10.99 $17.25 $25.96
Price Cl $0.06 $0.17 $0.26 $0.50 $1.20 $1.40 $1.95 $3.32 $3.80 $5.50 $8.63 $12.98 $13.30 $13.30 7766.67% <-Total Growth 10 Stock Price
Increase -61.54% 164.00% 59.09% 90.48% 139.00% 16.95% 39.53% 70.26% 14.46% 44.61% 56.96% 50.49% 2.47% 0.00% 54.73% <-IRR #YR-> 10 Stock Price
P/E -2.50 3.88 3.50 6.25 14.48 13.00 15.92 16.00 17.08 11.57 21.56 27.91 24.63 22.17 46.10% <-IRR #YR-> 5 Stock Price
Trailing P/E -0.50 -6.60 6.18 6.67 14.94 16.94 18.14 27.10 18.31 24.70 18.16 32.45 28.60 24.63 131.27% <-IRR #YR-> 10 Price & Div
Median 5 Yrs 6.97% 76.54% Div %  5, 10 yrs Price Inc 50.49% P/E: Y-T 17.08 24.70 53.07% <-IRR #YR-> 5 Price & Div
-$0.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.98
-$1.95 $0.00 $0.00 $0.00 $0.00 $12.98
-$0.17 $0.00 $0.83 $0.00 $0.09 $0.10 $0.13 $0.21 $0.32 $0.47 $13.45
-$1.95 $0.13 $0.21 $0.32 $0.47 $13.45
Price H/L Median $0.13 $0.17 $0.23 $0.43 $0.87 $1.18 $1.65 $2.66 $3.89 $4.55 $6.69 $10.59 6223.88% <-Total Growth 10 Stock Price
Increase 7.53% 34.00% 35.07% 87.85% 105.59% 35.05% 39.94% 61.17% 46.03% 17.08% 46.98% 58.39% 51.39% <-IRR #YR-> 10 Stock Price
P/E -5.00 3.94 3.02 5.31 10.59 10.98 13.48 12.83 17.47 9.58 16.72 22.78 45.02% <-IRR #YR-> 5 Stock Price
Trailing P/E -1.00 -6.70 5.32 5.67 10.92 14.30 15.36 21.72 18.73 20.45 14.08 26.48 129.40% <-IRR #YR-> 10 Price & Div
Median 5 Yrs 8.35% 78.01% Div %  5, 10 yrs Price Inc 46.98% P/E: Y-T 16.72 20.45 53.37% <-IRR #YR-> 5 Price & Div
-$0.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.59
-$1.65 $0.00 $0.00 $0.00 $0.00 $10.59
-$0.17 $0.00 $0.83 $0.00 $0.09 $0.10 $0.13 $0.21 $0.32 $0.47 $11.06
-$1.65 $0.13 $0.21 $0.32 $0.47 $11.06
Hi Mths Feb Mar Mar Jan Mar Mar Jul Mar May 08 Aug 08 Jul 09 Mar 11
Pre-split 09 $0.75 $0.92 $1.06 $2.20 $5.20 $5.59 $8.20 $14.29 $18.10
Pre-split 11 $0.38 $0.46 $0.53 $1.10 $2.60 $2.80 $4.10 $7.15 $9.05 $11.35 $17.50 $25.96
Price Hi $0.19 $0.23 $0.27 $0.55 $1.30 $1.40 $2.05 $3.57 $4.53 $5.68 $8.75 $12.98 5543.48% <-Total Growth 10 Stock Price
Increase 7.14% 22.67% 15.22% 107.55% 136.36% 7.50% 46.69% 74.27% 26.66% 25.41% 54.19% 48.34% 49.68% <-IRR #YR-> 10 Stock Price
P/E -7.50 5.41 3.53 6.88 15.76 13.00 16.73 17.22 20.34 11.95 21.88 27.91 44.65% <-IRR #YR-> 5 Stock Price
Trailing P/E -1.50 -9.20 6.24 7.33 16.25 16.94 19.07 29.16 21.81 25.51 18.42 32.45
Median 5 Yrs Price Inc 48.34% P/E: Y-T 20.34 25.51
-$0.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.98
-$2.05 $0.00 $0.00 $0.00 $0.00 $12.98
Low Mths Apr May Dec Jul/Aug May Sep May Aug Jan 08 Dec 08 Apr 09 Jun 10
Price Low $0.06 $0.11 $0.19 $0.30 $0.45 $0.96 $1.25 $1.75 $3.25 $3.43 $4.63 $8.21 7714.29% <-Total Growth 10 Stock Price
Increase 8.70% 68.00% 78.57% 60.00% 49.17% 115.08% 30.13% 39.72% 85.57% 5.47% 35.04% 77.41% 54.63% <-IRR #YR-> 10 Stock Price
P/E -2.50 2.47 2.50 3.75 5.42 8.95 10.22 8.43 14.60 7.21 11.56 21.31 45.63% <-IRR #YR-> 5 Stock Price
Trailing P/E -0.50 -4.20 4.41 4.00 5.59 11.67 11.65 14.29 15.65 15.39 9.74 22.79
Median 5 Yrs Price Inc 39.72% P/E: Y-T 11.56 15.39
-$0.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.21
Market Cap $2.14 $5.66 $7.41 $14.71 $37.17 $43.35 $63.01 $101.96 $128.18 $189.68 $307.57 $472.82 $484.48 $484.48
# of Sh in M 34.298 34.305 28.241 29.427 31.108 31.020 32.314 30.712 33.732 34.519 35.660 36.427 36.427 36.427 Share Capital Shares
Increase 0.00% 0.02% -17.68% 4.20% 5.71% -0.28% 4.17% -4.96% 9.83% 2.33% 3.31% 2.15% 0.00% 0.00% 0.88% <-Average 10 Shares
CF fr Op $M $0.3 $2.2 $0.8 $3.1 $3.9 $3.1 $4.4 $6.7 $10.1 $21.6 $9.2 $27.5 1133.65% <-Total Growth 10 Cash Flow
OPS $0.01 $0.07 $0.03 $0.11 $0.13 $0.10 $0.14 $0.22 $0.30 $0.63 $0.26 $0.76 1061.79% <-Total Growth 10 Cash Flow
Bef Non cash WC $0.70 $1.61 $1.78 $2.40 $3.54 $4.32 $4.55 $7.87 $8.81 $18.27 $16.62 $19.96 1139.44% <-Total Growth 10 CF less WC
OPS of above $0.02 $0.05 $0.06 $0.08 $0.11 $0.14 $0.14 $0.26 $0.26 $0.53 $0.47 $0.55 27.79% <-IRR #YR-> 10 Cash Flow
Increase -112.83% 662.95% -57.17% 281.28% 18.38% -20.90% 37.35% 60.09% 37.14% 108.53% -58.72% 192.68% 40.79% <-IRR #YR-> 5 Cash Flow
P/O on Cl 7.33 2.54 9.43 4.71 9.51 14.05 14.28 15.19 12.67 8.79 33.42 17.18 27.85% <-IRR #YR-> 10 CF less WC
*Operational Cash Flow per share P/CF 10 yr 13.36 5 yr  15.19 31.23% <-IRR #YR-> 5 CF less WC
-$0.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.76
-$0.14 $0.00 $0.00 $0.00 $0.00 $0.76
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.55
-$0.14 $0.00 $0.00 $0.00 $0.00 $0.55
OPM 3.4% 24.0% 7.9% 27.8% 31.7% 20.3% 25.6% 28.3% 36.1% 49.1% 20.3% 53.1%
Diff from Ave -87.8% -14.7% -71.8% -0.8% 12.9% -27.6% -8.7% 0.8% 28.7% 74.9% -27.6% 89.1% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 28.08% 5 Yrs 36.13%
Curr Assets $6.832 $7.892 $9.011 $11.663 $16.083 $19.687 $23.815 $29.080 $32.047 $46.880 $47.473 $56.135 Liq ratio of 1.5 and up, best Assets
Curr Liab. $4.458 $4.376 $4.039 $4.639 $5.579 $7.068 $9.778 $11.775 $13.352 $20.384 $19.463 $22.716 2.45 <-Median-> 10 Liabilities
Liquidity 1.53 1.80 2.23 2.51 2.88 2.79 2.44 2.47 2.40 2.30 2.44 2.47 2.44 <-Median-> 5 Ratio
Assets $8.27 $9.29 $10.172 $13.222 $16.717 $20.249 $24.668 $30.414 $33.339 $48.044 $49.906 $58.689 A/L ratio of 1.5 and up, best Assets
Liab. $4.84 $4.41 $4.039 $4.639 $5.579 $7.068 $9.778 $11.775 $13.352 $20.384 $19.463 $22.919 2.56 <-Median-> 10 Liabilities
Liquidity 1.71 2.11 2.52 2.85 3.00 2.87 2.52 2.58 2.50 2.36 2.56 2.56 2.56 <-Median-> 5 Ratio
Book Value $3.424 $4.889 $6.133 $8.583 $11.138 $13.181 $14.889 $18.639 $19.987 $27.660 $30.443 $35.770 $35.770 $35.770 631.67% <-Total Growth 10 Book Value
BV per share $0.10 $0.14 $0.22 $0.29 $0.36 $0.42 $0.46 $0.61 $0.59 $0.80 $0.85 $0.98 $0.98 $0.98 589.05% <-Total Growth 10 Book Value
Change -19.45% 42.73% 52.38% 34.32% 22.76% 18.68% 8.43% 31.72% -2.37% 35.23% 6.54% 15.02% 0.00% 0.00% 2.7919 Current/Historical
P/BV (CL) 0.63 1.16 1.21 1.71 3.34 3.29 4.23 5.47 6.41 6.86 10.10 13.22 13.54 13.54 21.29% <-IRR #YR-> 10 Book Value
Change -52.25% 84.96% 4.40% 41.81% 94.69% -1.46% 28.68% 29.26% 17.23% 6.93% 47.33% 30.84% 2.47% 0.00% 16.34% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 2.41 1.90 1.66 1.54 1.50 1.54 1.66 1.63 1.67 1.74 1.64 1.64 0.00 0.00 1.64 <-Median-> 10 A/BV
Debt/Equity Ratio 1.41 0.90 0.66 0.54 0.50 0.54 0.66 0.63 0.67 0.74 0.64 0.64 0.64 <-Median-> 10 Debt/Eq Ratio
Median P/BV 10 yr Ave 4.85 5 yr Ave 6.86
-$0.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.98
-$0.46 $0.00 $0.00 $0.00 $0.00 $0.98
ROE Cannot find for this stock #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! <-Median-> 0 Compreh. Inc
Comprehensive Inc $0.00 $0.00 $0.00 $0.00 $0.00 Compreh. Inc
ROE 29.9% 38.4% 28.0% 0.0% 26.4% 26.8% 37.3% 38.0% 240.3% 190.0% 192.0% Net Income/Shareholders' equity
5Yr Median 28.0% 26.8% 26.8% 26.8% 37.3% 38.0% 190.0%
Net Income -$0.65 $1.46 $2.36 $2.40 $0.00 $3.47 $3.99 $6.96 $7.60 $16.62 $14.46 $17.17 1072.72% <-Total Growth 10 Net Income
Oper C. F. $0.29 $2.23 $0.79 $3.12 $3.91 $3.08 $4.41 $6.71 $10.11 $21.58 $9.20 $27.52 Cash Flow Statement CF from continuing operations
Invest. C. F -$0.06 -$0.11 -$0.29 -$0.51 -$0.20 -$0.22 -$0.96 -$0.74 -$0.64 -$0.58 -$2.18 -$1.19 Cash Flow Statement
Total Accruals -$0.89 -$0.65 $1.86 -$0.22 -$3.71 $0.61 $0.53 $0.99 -$1.87 -$4.39 $7.44 -$9.16
Total Assets $8.27 $9.29 $10.17 $13.22 $16.72 $20.25 $24.67 $30.41 $33.34 $48.04 $49.91 $58.69 Balance Sheet
Accruals Ratio -10.74% -7.04% 18.30% -1.66% -22.22% 2.99% 2.16% 3.24% -5.62% -9.14% 14.90% -15.61%
up/down/neutral
Chge in Close -61.54% 164.00% 59.09% 90.48% 139.00% 16.95% 39.53% 70.26% 14.46% 44.61% 56.96% 50.49%
Any Predictions?
Fin. C. F $0.04 -$0.58 -$0.49 $0.59 $0.62 -$1.22 -$1.30 -$1.70 $6.77 -$9.79 -$12.91 -$13.40
Total Accruals -$0.93 -$0.07 $2.35 -$0.81 -$4.33 $1.82 $1.84 $2.69 -$8.64 $5.39 $20.34 $4.24
Accruals Ratio -11.19% -0.76% 23.08% -6.13% -25.93% 9.01% 7.45% 8.84% -25.93% 11.23% 40.76% 7.22%
Jun 18, 2011.  Last I looked I got estimates for 2011 and 2012 of $.92 and $1.05.  They have no debt and are paying almost all of their cash flow in dividends.
July 2010. When I last reviewed this stock in June 2009, I picked up 2010 and 2011 earnings of $.91 and $1.00.
Dividends started in 2004. Company stated Oct 1996, issued shares on 1 Apr 1997. 
How they make their money.
Computer Modelling Group Ltd. is a computer software technology and consulting company serving the oil and gas industry.  CMG is the leading supplier of advanced processes 
reservoir modelling software in the world with a blue chip client base of international oil companies and technology centers in approximately 50 countries.
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.
Some insiders own a lot in this company in dollars terms. They seem to be triming their exporsure to the company.  Sample below.
Insiders are given substantial amounts of options as part of their pay.
Dedeluk, Kenneth Michael CEO owns 0.624 $8,301,860
sold $2,364,690 22.17%
Pre-sell $10,666,550
Kutney, Ronald David owns 0.357 $4,753,420
Nghiem, Long owns 0.265 $3,528,490
CMG Reservoir Simulation Foundation 0.060 $798,000
Hesperian Capital Management Ltd. 0.558 $7,421,400