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/ Q1 2017
MacDonald, Dettwiler & Associates TSX MDA OTC MDDWF www.mdacorporation.com Fiscal Yr: Dec 31
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
Accounting Rules C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$1,995.7 <-12 mths -3.30%
Revenue* $832.9 $1,052.5 $1,204.2 $1,168.5 $1,000.9 $689.0 $761.1 $875.7 $1,794.7 $2,098.8 $2,117.4 $2,063.8 $2,003.0 $2,332.0 $2,500.0 96.08% <-Total Growth 10 Revenue
Increase 10.85% 26.36% 14.42% -2.97% -14.34% -31.16% 10.46% 15.06% 104.94% 16.94% 0.88% -2.53% -2.95% 16.43% 7.20% 6.97% <-IRR #YR-> 10 Revenue 96.08%
5 year Running Average $652.5 $766.8 $893.5 $1,001.9 $1,051.8 $1,023.0 $964.8 $899.0 $1,024.3 $1,243.9 $1,529.6 $1,790.1 $2,015.5 $2,123.0 $2,203.2 22.08% <-IRR #YR-> 5 Revenue 171.15%
Revenue per Share $20.81 $25.51 $29.49 $28.94 $24.68 $16.78 $23.93 $27.49 $49.78 $58.12 $58.45 $56.73 $55.02 $64.05 $68.67 8.85% <-IRR #YR-> 10 5 yr Running Average 133.46%
Increase 8.69% 22.58% 15.63% -1.90% -14.72% -31.99% 42.60% 14.86% 81.08% 16.76% 0.56% -2.93% -3.02% 16.43% 7.20% 13.16% <-IRR #YR-> 5 5 yr Running Average 85.55%
5 year Running Average $17.07 $19.45 $22.26 $24.78 $25.88 $25.08 $24.76 $24.36 $28.53 $35.22 $43.55 $50.11 $55.62 $58.47 $60.58 8.32% <-IRR #YR-> 10 Revenue Per share 122.41%
P/S (Price/Sales) Med 1.51 1.71 1.56 1.14 1.25 11.64 2.09 1.84 1.41 1.47 1.48 1.38 18.84% <-IRR #YR-> 5 Revenue Per share 137.05%
P/S (Price/Sales) Close 1.80 1.68 1.42 0.75 1.73 3.01 1.97 2.04 1.65 1.63 1.42 1.18 1.14 0.98 0.92 9.92% <-IRR #YR-> 10 5 yr Running 157.59%
*Revenue in M CDN $  P/S 10 yr  1.47 5 yr  1.47 -22.47% Diff M/C 15.14% <-IRR #YR-> 5 5 yr Running 102.35%
-$1,053 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,064
-$761 $0 $0 $0 $0 $2,064
-$767 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,790
-$965 $0 $0 $0 $0 $1,790
-$25.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $56.73
-$23.93 $0.00 $0.00 $0.00 $0.00 $56.73
$2.79 <-12 mths -25.40%
EPS Basic $1.72 $2.04 $2.30 $1.20 $2.68 $1.00 $4.08 $2.71 $3.00 $1.31 $3.94 $3.84 88.24% <-Total Growth 10 EPS Basic
EPS Diluted* $1.68 $1.95 $2.18 $1.19 $2.67 $0.99 $4.08 $2.71 $3.00 $1.31 $3.84 $3.74 $2.37 $4.32 $3.67 91.79% <-Total Growth 10 EPS Diluted
Increase 26.32% 16.07% 11.79% -45.41% 124.37% -62.92% 312.12% -33.58% 10.70% -56.33% 193.13% -2.60% -36.63% 82.28% -15.05% 6.73% <-IRR #YR-> 10 Earnings per Share 91.79%
Earnings Yield 4.5% 4.6% 5.2% 5.5% 6.3% 2.0% 8.7% 4.8% 3.6% 1.4% 4.6% 5.6% 3.8% 6.9% 5.8% -1.73% <-IRR #YR-> 5 Earnings per Share -8.33%
5 year Running Average $1.12 $1.41 $1.65 $1.67 $1.93 $1.80 $2.22 $2.33 $2.69 $2.42 $2.99 $2.92 $2.85 $3.12 $3.59 7.54% <-IRR #YR-> 10 5 yr Running Average 106.80%
10 year Running Average $1.24 $1.40 $1.46 $1.82 $1.99 $2.18 $2.18 $2.39 $2.57 $2.59 $2.90 $3.00 5.62% <-IRR #YR-> 5 5 yr Running Average 31.41%
* Diluted ESP per share  E/P 10 Yrs 5.03% 5Yrs 4.61%
-$1.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.74
-$4.08 $0.00 $0.00 $0.00 $0.00 $3.74
-$1.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.92
-$2.22 $0.00 $0.00 $0.00 $0.00 $2.92
Special Dividend $0.00 $0.00 $0.00 $0.00 $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
Dividend* $1.30 $1.30 $1.30 $1.48 $1.48 $1.48 $1.48 $1.48 13.85% <-Total Growth 4 Dividends
Increase 0.00% 0.00% 13.85% 0.00% 0.00% 0.00% 0.00% Count 5 Years of data
Dividends 5 Yr Running $1.37 $1.41 $1.44 $1.48 #DIV/0! <-Total Growth 0 Dividends 5 Yr Running
Yield H/L Price 2.58% 1.85% 1.52% 1.71% 1.89% 2.15% 1.85% <-Median-> 5 Yield H/L Price
Yield on High  Price 2.13% 1.55% 1.37% 1.48% 1.60% 1.97% 1.55% <-Median-> 5 Yield on High  Price
Yield on Low Price 3.25% 2.31% 1.72% 2.04% 2.31% 2.36% 2.31% <-Median-> 5 Yield on Low Price
Yield on Close Price 2.32% 1.58% 1.37% 1.78% 2.21% 2.35% 2.35% 2.35% 1.78% <-Median-> 5 Yield on Close Price
Payout Ratio EPS 47.97% 43.33% 99.24% 38.54% 39.57% 62.45% 34.26% 40.33% 43.33% <-Median-> 5 DPR EPS
DPR EPS 5 Yr Running 46.99% 49.37% 46.34% 41.25% 46.99% <-Median-> 0 DPR EPS 5 Yr Running
Payout Ratio CFPS 28.10% 30.75% 60.04% 39.66% 31.16% 23.16% 18.55% 13.21% 31.16% <-Median-> 5 DPR CF
DPR CF 5 Yr Running 35.18% 33.11% 15.71% 16.10% 35.18% <-Median-> 1 DPR CF 5 Yr Running
Payout Ratio CFPS WC 21.80% 14.57% 17.50% 15.99% 15.55% 23.16% 18.55% 13.21% 15.99% <-Median-> 5 DPR CF WC
DPR CF WC 5 Yr Running 16.70% 16.96% 17.80% 16.69% 16.70% <-Median-> 0 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 1.85% 1.78% 5 Yr Med Payout 43.33% 31.16% 15.99% 3.30% <-IRR #YR-> 4 Dividends #DIV/0!
* Dividends per share  5 Yr Med and Cur. 27.09% 32.47% Last Div Inc ---> $0.33 $0.37 13.8% 3.30% <-IRR #YR-> 4 Dividends #DIV/0!
-$1.30 $0.00 $0.00 $0.00 $1.48
-$1.30 $0.00 $0.00 $0.00 $1.48
Historical Dividends Historical High Div 3.07% Low Div 1.39% Ave Div 2.23% Med Div 1.85% Close Div 1.78% Historical Dividends
High/Ave/Median Values Curr diff Exp. -23.30%     69.41% Cheap 5.60% Cheap 27.29% Cheap 32.47% High/Ave/Median 
Future Dividend Yield Div Yd 2.92% earning in 5.00 Years at IRR of 4.40% Div Inc. 24.02% Future Dividend Yield
Future Dividend Yield Div Yd 3.62% earning in 10.00 Years at IRR of 4.40% Div Inc. 53.82% Future Dividend Yield
Future Dividend Yield Div Yd 4.49% earning in 15.00 Years at IRR of 4.40% Div Inc. 90.77% Future Dividend Yield
Yield if held 5 yrs 2.83% 3.95% 4.21% 0.76% 2.96% 2.93% 2.11% 1.73% 2.96% <-Median-> 5 Paid Median Price
Yield if held 10 yrs 5.63% 5.68% 4.95% 4.70% 3.40% 3.22% 4.50% 4.79% 4.95% <-Median-> 5 Paid Median Price
Yield if held 15 yrs 7.91% 6.37% 6.41% 6.46% 5.63% 7.14% <-Median-> 2 Paid Median Price
Yield if held 20 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yield if held 25 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost cover if held 5 years 2.83% 7.91% 12.62% 2.75% 13.70% 13.95% 10.29% 8.67% 7.91% <-Median-> 5 Paid Median Price
Cost cover if held 10 years 5.63% 11.35% 14.85% 17.08% 15.77% 18.13% 29.87% 36.55% 14.85% <-Median-> 5 Paid Median Price
Cost cover if held 15 years 28.77% 29.51% 36.14% 42.88% 43.01% 29.14% <-Median-> 2 Paid Median Price
Cost cover if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost cover if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham No. $17.93 $22.32 $22.54 $18.74 $28.11 $17.10 $26.18 $22.57 $38.61 $25.62 $51.40 $51.77 $40.96 $55.29 $50.96 131.96% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.76 1.95 2.04 1.75 1.10 11.43 1.91 2.24 1.82 3.33 1.68 1.51 1.68 1.86 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 2.13 2.29 2.35 2.66 1.54 3.14 2.21 2.70 2.18 3.71 1.95 1.78 1.84 2.28 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.39 1.61 1.74 0.85 0.66 19.71 1.61 1.77 1.46 2.96 1.41 1.24 1.53 1.54 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 2.09 1.92 1.85 1.16 1.52 2.96 1.80 2.48 2.13 3.71 1.62 1.29 1.53 1.14 1.23 1.83 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 109.12% 91.76% 85.26% 16.32% 51.54% 195.80% 79.89% 147.99% 113.18% 270.67% 61.99% 29.20% 53.46% 13.67% 23.32% 82.57% <-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
Price Close $37.50 $42.80 $41.75 $21.80 $42.60 $50.57 $47.09 $55.96 $82.30 $94.95 $83.26 $66.89 $62.85 $62.85 $62.85 56.29% <-Total Growth 10 Stock Price
Increase 39.51% 14.13% -2.45% -47.78% 95.41% 18.71% -6.88% 18.84% 47.07% 15.37% -12.31% -19.66% -6.04% 0.00% 0.00% 4.57% <-IRR #YR-> 10 Stock Price 56.29%
P/E 22.32 21.95 19.15 18.32 15.96 51.08 11.54 20.65 27.43 72.48 21.68 17.89 26.52 14.55 17.13 7.27% <-IRR #YR-> 5 Stock Price 42.05%
Trailing P/E 28.20 25.48 21.41 10.00 35.80 18.94 47.57 13.72 30.37 31.65 63.56 17.42 16.80 26.52 14.55 5.71% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.  per yr 1.14% 2.53% % Tot Ret 19.97% 25.84% T P/E 30.37 P/E:  19.90 21.68 9.81% <-IRR #YR-> 5 Price & Dividend
-$42.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $66.89
-$47.09 $0.00 $0.00 $0.00 $0.00 $66.89
-$42.80 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 $1.30 $1.30 $1.48 $68.37
-$47.09 $1.30 $1.30 $1.30 $1.48 $68.37
Price H/L Median $31.51 $43.51 $46.00 $32.88 $30.92 $195.35 $50.06 $50.47 $70.16 $85.36 $86.40 $78.24 $68.95 79.83% <-Total Growth 10 Stock Price
Increase 19.93% 38.09% 5.73% -28.52% -5.98% 531.89% -74.38% 0.82% 39.03% 21.66% 1.22% -9.45% -11.87% 6.04% <-IRR #YR-> 10 Stock Price 79.83%
P/E 18.75 22.31 21.10 27.63 11.58 197.32 12.27 18.62 23.39 65.16 22.50 20.92 29.09 9.34% <-IRR #YR-> 5 Stock Price 56.30%
Trailing P/E 23.69 25.90 23.59 15.08 25.98 73.16 50.56 12.37 25.89 28.45 65.95 20.37 18.43 7.06% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 28.08 30.81 27.81 19.74 15.99 108.77 22.53 21.68 26.08 35.30 28.92 26.79 24.17 11.64% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 26.43 22.07 133.89 27.55 25.35 32.21 39.23 36.12 30.43 26.62 22.31 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 1.02% 2.30% % Tot Ret 14.44% 19.75% T P/E 25.89 P/E:  21.80 22.50 Count 17 Years of data
-$43.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $78.24
-$50.06 $0.00 $0.00 $0.00 $0.00 $78.24
-$43.51 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 $1.30 $1.30 $1.48 $79.72
-$50.06 $1.30 $1.30 $1.30 $1.48 $79.72
High Months Dec Apr May Jan Dec Nov May Aug Nov Dec Mar May Jan
Price High $38.11 $51.01 $52.85 $49.76 $43.36 $53.68 $57.92 $60.99 $84.00 $94.95 $100.22 $92.30 $75.19 80.94% <-Total Growth 10 Stock Price
Increase 30.78% 33.85% 3.61% -5.85% -12.86% 23.80% 7.90% 5.30% 37.73% 13.04% 5.55% -7.90% -18.54% 6.11% <-IRR #YR-> 10 Stock Price 80.94%
P/E 22.68 26.16 24.24 41.82 16.24 54.22 14.20 22.51 28.00 72.48 26.10 24.68 31.73 9.77% <-IRR #YR-> 5 Stock Price 59.36%
Trailing P/E 28.65 30.36 27.10 22.83 36.44 20.10 58.51 14.95 31.00 31.65 76.50 24.04 20.10 26.10 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 31.00 P/E:  25.39 26.10 54.39 P/E Ratio Historical High
-$51.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $92.30
-$57.92 $0.00 $0.00 $0.00 $0.00 $92.30
Low Months Jan Sep Nov Oct Mar Apr Oct Apr Jan Jan Sep Dec May
Price Low $24.90 $36.00 $39.15 $16.00 $18.47 $337.02 $42.19 $39.94 $56.32 $75.76 $72.58 $64.17 $62.70 78.25% <-Total Growth 10 Stock Price
Increase 6.41% 44.58% 8.75% -59.13% 15.44% 1724.69% -87.48% -5.33% 41.01% 34.52% -4.20% -11.59% -2.29% 5.95% <-IRR #YR-> 10 Stock Price 78.25%
P/E 14.82 18.46 17.96 13.45 6.92 340.42 10.34 14.74 18.77 57.83 18.90 17.16 26.46 8.75% <-IRR #YR-> 5 Stock Price 52.10%
Trailing P/E 18.72 21.43 20.08 7.34 15.52 126.22 42.62 9.79 20.78 25.25 55.40 16.71 16.76 18.04 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 20.78 P/E:  17.56 18.77 14.22 P/E Ratio Historical Low
-$36.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $64.17
Long Term Debt $983.6 $669.8 $879.6 Debt
Change -31.90% 31.32% -31.90% <-Median-> 1 Change
Debt/Market Cap Ratio 0.33 0.28 0.38 0.30 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $608.8 $688.4 $649.1 $816.1 $728.1 $40.8 $191.9 $974.1 $1,076.1 $1,190.1 $1,398.5 $1,384.4 $1,383.7 Intangibles Goodwill
Change 21.59% 13.09% -5.71% 25.73% -10.79% -94.40% 370.26% 407.72% 10.47% 10.59% 17.50% -1.00% -0.05% 10.53% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.41 0.39 0.38 0.93 0.42 0.02 0.13 0.55 0.36 0.35 0.46 0.57 0.60 0.40 <-Median-> 10 Intangible/Market Cap Ratio
Market Cap $1,501 $1,766 $1,705 $880 $1,728 $2,076 $1,498 $1,783 $2,967 $3,429 $3,016 $2,433 $2,288 $2,288 $2,288 37.78% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 40.66 40.93 39.14 31.84 35.06 36.09 36.23 36.52 36.48 -10.18% <-Total Growth 7 Diluted
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.68% -4.37% -18.67% 10.14% 2.92% 0.38% 0.81% -0.10% #DIV/0! <-Median-> 7 Change
Basic # of Shares in Millions 39.95 40.99 41.31 40.28 40.47 40.80 39.12 31.84 35.06 36.09 36.18 36.38 36.46 -11.25% <-Total Growth 10 Basic
Change 2.73% 2.60% 0.78% -2.48% 0.47% 0.80% -4.12% -18.62% 10.14% 2.92% 0.25% 0.56% 0.23% 0.51% <-Median-> 10 Change
Difference 0.2% 0.7% -1.2% 0.2% 0.2% 0.6% -18.7% 0.1% 2.8% 0.1% 0.1% 0.0% 0.00 0.11% <-Median-> 10 Difference
$147.83 <-12 mths -14.43% Cash Flow
# of Share in Millions 40.027 41.263 40.829 40.382 40.559 41.055 31.803 31.859 36.056 36.114 36.228 36.378 36.408 36.408 36.408 -1.25% <-IRR #YR-> 10 Shares -11.84%
Increase 1.99% 3.09% -1.05% -1.09% 0.44% 1.22% -22.54% 0.18% 13.18% 0.16% 0.32% 0.41% 0.08% 0.00% 0.00% 2.72% <-IRR #YR-> 5 Shares 14.39%
CF fr Op $M $108.9 $99.6 $52.5 $150.0 $165.0 $392.1 -$40.1 $147.4 $152.4 $78.2 $135.2 $172.8 $232.6 $290.5 $407.8 73.39% <-Total Growth 10 Cash Flow
Increase 84.23% -8.51% -47.33% 185.83% 10.03% 137.59% -110.24% 467.21% 3.42% -48.70% 72.89% 27.79% 34.67% 24.88% 40.35% ESPP Buy Backs S. Issues
5 year Running Average $57.6 $70.9 $71.8 $94.0 $115.2 $171.9 $143.9 $162.9 $163.4 $146.0 $94.6 $137.2 $154.2 $181.9 $247.8 93.49% <-Total Growth 10 CF 5 Yr Running
CFPS $2.72 $2.41 $1.29 $3.71 $4.07 $9.55 -$1.26 $4.63 $4.23 $2.17 $3.73 $4.75 $6.39 $7.98 $11.20 96.67% <-Total Growth 10 Cash Flow per Share
Increase 80.64% -11.25% -46.77% 188.99% 9.56% 134.72% -113.2% 466.57% -8.62% -48.79% 72.35% 27.26% 34.56% 24.88% 40.35% 5.66% <-IRR #YR-> 10 Cash Flow 73.39%
5 year Running Average $1.50 $1.79 $1.79 $2.33 $2.84 $4.21 $3.47 $4.14 $4.24 $3.86 $2.70 $3.90 $4.25 $9.19 $9.19 #NUM! <-IRR #YR-> 5 Cash Flow 530.42%
P/CF on Med Price 11.58 18.02 35.79 8.85 7.60 20.45 -39.66 10.91 16.60 39.42 23.15 16.47 10.79 7.00% <-IRR #YR-> 10 Cash Flow per Share 96.67%
P/CF on Closing Price 13.78 17.72 32.48 5.87 10.47 5.29 -37.31 12.10 19.47 43.85 22.31 14.09 9.84 #NUM! <-IRR #YR-> 5 Cash Flow per Share 476.29%
-40.52% Diff M/C 8.09% <-IRR #YR-> 10 CFPS 5 yr Running 117.71%
Excl.Working Capital CF -$7.1 $26.0 $113.2 -$9.8 $11.9 -$213.5 $215.2 $42.6 $169.2 $190.0 $200.2 $173.5 $0.0 $0.0 $0.0 2.35% <-IRR #YR-> 5 CFPS 5 yr Running 12.34%
CF fr Op $M WC $101.8 $125.6 $165.6 $140.1 $176.9 $178.6 $175.1 $190.0 $321.6 $268.2 $335.3 $346.3 $232.6 $290.5 $407.8 175.62% <-Total Growth 10 Cash Flow less WC
Increase 7.57% 23.47% 31.83% -15.39% 26.23% 0.96% -1.96% 8.49% 69.30% -16.61% 25.03% 3.26% -32.82% 24.88% 40.35% 10.67% <-IRR #YR-> 10 Cash Flow less WC 175.62%
5 year Running Average $76.7 $90.2 $111.4 $125.6 $142.0 $157.4 $167.3 $172.1 $208.4 $226.7 $258.1 $292.3 $300.8 $294.6 $322.5 14.61% <-IRR #YR-> 5 Cash Flow less WC 97.76%
CFPS Excl. WC $2.54 $3.04 $4.06 $3.47 $4.36 $4.35 $5.51 $5.96 $8.92 $7.43 $9.26 $9.52 $6.39 $7.98 $11.20 12.48% <-IRR #YR-> 10 CF less WC 5 Yr Run 224.07%
Increase 5.47% 19.77% 33.23% -14.45% 25.68% -0.26% 26.56% 8.31% 49.59% -16.75% 24.64% 2.84% -32.87% 24.88% 40.35% 11.81% <-IRR #YR-> 5 CF less WC 5 Yr Run 74.73%
5 year Running Average $2.00 $2.28 $2.77 $3.10 $3.50 $3.86 $4.35 $4.73 $5.82 $6.43 $7.41 $8.22 $8.30 $8.11 $8.87 12.07% <-IRR #YR-> 10 CFPS - Less WC 212.63%
P/CF on Med Price 12.39 14.29 11.34 9.47 7.09 44.90 9.09 8.46 7.86 11.49 9.33 8.22 10.79 11.57% <-IRR #YR-> 5 CFPS - Less WC 72.89%
P/CF on Closing Price 14.75 14.06 10.29 6.28 9.77 11.62 8.55 9.38 9.23 12.78 8.99 7.03 9.84 7.88 5.61 13.66% <-IRR #YR-> 10 CFPS 5 yr Running 259.68%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 16.53 5 yr  16.60 P/CF Med 10 yr 9.21 5 yr  8.46 6.77% Diff M/C 13.57% <-IRR #YR-> 5 CFPS 5 yr Running 88.94%
-$2.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.75 Cash Flow per Share
$1.26 $0.00 $0.00 $0.00 $0.00 $4.75 Cash Flow per Share
-$1.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.90 CFPS 5 yr Running
-$3.47 $0.00 $0.00 $0.00 $0.00 $3.90 CFPS 5 yr Running
-$125.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $346.3 Cash Flow less WC
-$175.1 $0.0 $0.0 $0.0 $0.0 $346.3 Cash Flow less WC
-$90.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $292.3 CF less WC 5 Yr Run
-$167.3 $0.0 $0.0 $0.0 $0.0 $292.3 CF less WC 5 Yr Run
-$3.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.52 CFPS - Less WC
-$5.51 $0.00 $0.00 $0.00 $0.00 $9.52 CFPS - Less WC
OPM 13.07% 9.47% 4.36% 12.84% 16.49% 56.91% -5.27% 16.83% 8.49% 3.73% 6.38% 8.37% -11.58% <-Total Growth 10 OPM
Increase 66.20% -27.60% -53.97% 194.58% 28.46% 245.12% -109% -419.16% -49.54% -56.14% 71.38% 31.11% Should increase  or be stable.
Diff from Median 55.1% 12.3% -48.3% 52.2% 95.6% 574.9% -162.5% 99.6% 0.7% -55.8% -24.3% -0.7% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 8.43% 5 Yrs 8.37% should be  zero, it is a   check on calculations
Current Assets $226.03 $257.69 $268.79 $290.79 $285.66 $1,122.80 $515.95 $645.22 $724.22 $858.01 $1,065.05 $901.79 $831.31 Liquidity ratio of 1.5 and up, best
Current Liabilities $371.89 $299.87 $257.27 $280.04 $281.38 $474.77 $353.03 $864.75 $1,024.82 $1,086.63 $1,090.88 $1,046.38 $786.90 1.00 <-Median-> 10 Ratio
Liquidity Ratio 0.61 0.86 1.04 1.04 1.02 2.36 1.46 0.75 0.71 0.79 0.98 0.86 1.06 0.79 <-Median-> 5 Ratio
Liq. with CF aft div 0.90 1.19 1.25 1.57 1.60 3.19 1.35 0.87 0.81 0.82 1.05 0.98 1.28 0.87 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.84 0.73 0.99 1.09 1.38 2.96 1.35 0.42 0.79 0.73 0.96 0.87 1.28 0.79 <-Median-> 5 Ratio
Curr Long Term Db $0.158 $0.075 $0.000 $0.132 $0.059 $0.000 $1.834 $48.207 $73.429 $41.308 $2.719 $136.811 $2.408
Liquidity Less CLTD 0.61 0.86 1.04 1.04 1.02 2.36 1.47 0.79 0.76 0.82 0.98 0.99 1.06 0.82 <-Median-> 5 Ratio
Liq. with CF aft div 0.90 1.19 1.25 1.57 1.60 3.19 1.35 0.92 0.87 0.85 1.05 1.12 1.29 0.92 <-Median-> 5 Ratio
Short by  $227.18 $187.31 $23.12 $7.77 -$46.82 Short by 
Assets $1,084.6 $1,243.8 $1,199.3 $1,456.5 $1,286.2 $1,371.8 $765.2 $2,314.8 $2,584.2 $2,981.4 $3,611.0 $3,438.9 $3,367.4 Debt Ratio of 1.5 and up, best
Liabilities $744.1 $775.3 $776.5 $926.7 $752.7 $833.1 $527.8 $2,048.7 $1,788.1 $2,177.4 $2,503.3 $2,280.2 $2,222.2 1.48 <-Median-> 10 Ratio
Debt Ratio 1.46 1.60 1.54 1.57 1.71 1.65 1.45 1.13 1.45 1.37 1.44 1.51 1.52 1.44 <-Median-> 5 Ratio
Book Value $340.50 $468.53 $422.76 $529.7 $533.5 $538.7 $237.4 $266.1 $796.2 $804.0 $1,107.7 $1,158.7 $1,145.2 $1,145.2 $1,145.2 147.32% <-Total Growth 10 Book Value
Book Value per share $8.51 $11.35 $10.35 $13.12 $13.15 $13.12 $7.46 $8.35 $22.08 $22.26 $30.58 $31.85 $31.45 $31.45 $31.45 180.53% <-Total Growth 10 Book Value per Share
Change 19.06% 33.48% -8.81% 26.68% 0.28% -0.25% -43.11% 11.88% 164.40% 0.82% 37.34% 4.18% -1.25% 0.00% 0.00% -47.87% P/B Ratio Current/Historical Median
P/B Ratio (Median) 3.70 3.83 4.44 2.51 2.35 14.89 6.71 6.04 3.18 3.83 2.83 2.46 2.19 3.83 P/B Ratio Historical Median
P/B Ratio (Close) 4.41 3.77 4.03 1.66 3.24 3.85 6.31 6.70 3.73 4.27 2.72 2.10 2.00 2.00 2.00 10.87% <-IRR #YR-> 10 Book Value 180.53%
Change 17.18% -14.49% 6.97% -58.78% 94.86% 19.01% 63.68% 6.22% -44.38% 14.43% -36.15% -22.88% -4.85% 0.00% 0.00% 33.67% <-IRR #YR-> 5 Book Value 326.71%
Leverage (A/BK) 3.19 2.65 2.84 2.75 2.41 2.55 3.22 8.70 3.25 3.71 3.26 2.97 2.94 3.10 <-Median-> 10 A/BV
Debt/Equity Ratio 2.19 1.65 1.84 1.75 1.41 1.55 2.22 7.70 2.25 2.71 2.26 1.97 1.94 2.10 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.51 5 yr Med 3.18 -43.00% Diff M/C 3.08 Historical A/BV
-$11.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.85
-$7.46 $0.00 $0.00 $0.00 $0.00 $31.85
$128.01 <-12 mths 43.30%
Comprehensive Income $95.57 -$33.43 $178.76 -$0.53 $7.59 $183.38 $71.50 $291.42 $49.91 $311.82 $89.33 -6.54% <-Total Growth 10 Comprehensive Income
Increase -134.98% 634.71% -100.29% 1540.42% 2316% -61.01% 307.61% -82.87% 524.76% -71.35% -61.01% <-Median-> 5 Comprehensive Income
5 Yr Running Average $49.59 $67.15 $88.14 $110.67 $120.76 $181.61 $162.80 -0.67% <-IRR #YR-> 10 Comprehensive Income -6.54%
ROE 20.4% -7.9% 33.7% -0.1% 1.4% 77.2% 26.9% 36.6% 6.2% 28.1% 7.7% -13.40% <-IRR #YR-> 5 Comprehensive Income -51.29%
5Yr Median 1.4% 1.4% 26.9% 26.9% 26.9% 28.1% 26.9% 21.91% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 14.3% -135.2% 268.6% -100.5% -81.3% 14.8% -17.1% 177.4% 5.9% 118.3% -36.0% 19.38% <-IRR #YR-> 5 5 Yr Running Average 142.42%
Median Values Diff 5, 10 yr -5.6% 5.9% 26.9% <-Median-> 5 Return on Equity
-$95.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $89.3
-$183.4 $0.0 $0.0 $0.0 $0.0 $89.3
-$49.6 $0.0 $0.0 $0.0 $0.0 $0.0 $162.8
-$67.2 $0.0 $0.0 $0.0 $0.0 $162.8
Current Liability Coverage Ratio 0.27 0.42 0.64 0.50 0.63 0.38 0.50 0.22 0.31 0.25 0.31 0.33   CFO / Current Liabilities
5 year Median 0.42 0.42 0.42 0.42 0.50 0.50 0.50 0.50 0.38 0.31 0.31 0.31 0.35 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 9.38% 10.10% 13.81% 9.62% 13.75% 13.02% 22.88% 8.21% 12.45% 9.00% 9.29% 10.07% CFO / Total Assets
5 year Median 10.96% 10.12% 10.12% 10.10% 10.10% 13.02% 13.75% 13.02% 13.02% 12.45% 9.29% 9.29% 11.3% <-Median-> 10 Return on Assets 
Return on Assets ROA 6.3% 6.7% 7.9% 3.3% 8.4% 3.0% 20.9% 3.7% 4.1% 1.6% 4.0% 4.1% Net  Income/Assets Return on Assets
5Yr Median 6.3% 6.7% 6.7% 6.3% 6.7% 6.7% 7.9% 3.7% 4.1% 3.7% 4.0% 4.0% 4.0% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 20.0% 17.8% 22.5% 9.2% 20.3% 7.6% 67.3% 32.4% 13.2% 5.9% 12.9% 12.0% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 18.7% 18.7% 19.2% 18.7% 20.0% 17.8% 20.3% 20.3% 20.3% 13.2% 13.2% 12.9% 13.0% <-Median-> 10 Return on Equity
$104.85 <-12 mths -24.91%
Net Income $68.15 $83.60 $94.97 $48.49 $108.39 $40.70 $159.76 $86.28 $105.05 $47.12 $142.84 $139.63 $139 $145 $134 67.02% <-Total Growth 10 Net Income
Increase 29.82% 22.67% 13.60% -48.94% 123.52% -62.45% 292.54% -46.00% 21.75% -55.14% 203.16% -2.25% -0.45% 4.32% -7.59% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $44.0 $57.0 $68.6 $69.5 $80.7 $75.2 $90.5 $88.7 $100.0 $87.8 $108.2 $104.2 $114.7 $122.7 $140.1 5.26% <-IRR #YR-> 10 Net Income
Operating Cash Flow $108.90 $99.64 $52.48 $149.99 $165.04 $392.13 -$40.14 $147.39 $152.43 $78.19 $135.19 $172.76 -2.66% <-IRR #YR-> 5 Net Income
Investment Cash Flow -$28.19 -$191.43 -$66.65 -$124.15 -$46.21 -$36.19 $726.00 -$924.99 -$30.83 -$135.77 -$105.49 -$132.34 6.22% <-IRR #YR-> 10 5 Yr Running Average
Total Accruals -$12.57 $175.39 $109.14 $22.64 -$10.44 -$315.24 -$526.10 $863.88 -$16.56 $104.70 $113.15 $99.21 2.86% <-IRR #YR-> 5 5 Yr Running Average
Total Assets $1,084.6 $1,243.8 $1,199.3 $1,456.5 $1,286.2 $1,371.8 $765.2 $2,314.8 $2,584.2 $2,981.4 $3,611.0 $3,438.9 Balance Sheet Assets
Accruals Ratio -1.16% 14.10% 9.10% 1.55% -0.81% -22.98% -68.75% 37.32% -0.64% 3.51% 3.13% 2.88% 3.13% <-Median-> 5 Ratio
EPS/CF Ratio 0.66 0.64 0.54 0.34 0.61 0.23 0.74 0.45 0.34 0.18 0.41 0.39 0.40 <-Median-> 10 EPS/CF Ratio
-$83.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $139.6
-$159.8 $0.0 $0.0 $0.0 $0.0 $139.6
-$57.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $104.2
-$90.5 $0.0 $0.0 $0.0 $0.0 $104.2
Chge in Close 39.51% 14.13% -2.45% -47.78% 95.41% 18.71% -6.88% 18.84% 47.07% 15.37% -12.31% -19.66% -6.04% 0.00% 0.00% Count 17 Years of data
up/down/neutral down down down up up down Count 9 52.94%
Any Predictions? yes yes yes % right Count 4 44.44%
Financial Cash Flow -$97.85 $105.52 $29.70 -$35.37 -$126.50 -$139.77 -$658.08 $583.25 -$94.69 $21.56 -$11.66 -$84.16 C F Statement  Financial Cash Flow
Total Accruals $85.28 $69.87 $79.44 $58.01 $116.06 -$175.47 $131.98 $280.64 $78.13 $83.13 $124.81 $183.37 Accruals
Accruals Ratio 7.86% 5.62% 6.62% 3.98% 9.02% -12.79% 17.25% 12.12% 3.02% 2.79% 3.46% 5.33% 3.46% <-Median-> 5 Ratio
Cash $13.35 $28.74 $38.91 $23.37 $14.77 $229.46 $254.83 $24.84 $50.31 $17.13 $41.56 -$5.11 -$14.03 Cash
Cash per Share $0.33 $0.70 $0.95 $0.58 $0.36 $5.59 $8.01 $0.78 $1.40 $0.47 $1.15 -$0.14 -$0.39 $0.78 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.89% 1.63% 2.28% 2.65% 0.85% 11.05% 17.02% 1.39% 1.70% 0.50% 1.38% -0.21% -0.61% 1.38% <-Median-> 5 % of Stock Price
Notes:
May 27, 2017.  Last estimaes were for 2016, 2017 and 2018 of $1233M, $2330M and $2486M for Revenue, $4.86, $5.82 and $6.20 for EPS, 6.99, $7.75 and $8.63 for CFPS and $186M, $226M and $268M for Net Income.
May 7, 2016.  Last estimates were for 2015, 2016 and 2017 of $2178M, $2314M and $2606M for Revenue, $4.75, $5.25 and $4.57 for EPS, $5.67, $8.57 and $8.36 for CFPS and $80.5M, $200M and $212M for Net Income.
September 25, 2015.  Last estimates were for 2014, 2015 and 2016 of $2096M, $2225M and $2350M for Revenue, $3.56, $4.88 and $5.86 for EPS, $6.23, $8.07 and $8.07 for CFPS, $138M, $183M and $205M for Net Income.
September 14, 2014.  Last estimates were for 2013, 2014 and 2015 of $1864M, $2069M and $2340M for Revenue, $5.25 and $6.10 and $7.22 for EPS, $6.75, $8.13 and $9.58 for CFPS.
Aug 16, 2013.  Revenue dropped in 2010 because of sale of business.
On November 5, 2010, the Company executed a definitive agreement for the sale of its Property Information business to a third party buyer.
Sector:
Tech
What should this stock accomplish?
Would I buy this company and Why.
Dividends
Dividends are paid semi-annually, in March and September.  Dividends are announced in one month for shareholders of the next month and paid in that month.
For example, the Dividend decalred on February 28, 2012 was for shareholders of record of March 15, 2012 and was paid on March 30, 2012.
Why am I following this stock. 
I read about this stock in MPL Communication's Advice Hotline dated October 10, 2012.  CanTech likes it also.  It is a Tech stock with dividends.
How they make their money.
MacDonald, Dettwiler & Associates Ltd. is a global communications and information company providing operational solutions to commercial and government organizations worldwide.
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 Shares %, Val $M
Date Aug 10 2013 Sep 15 2014 Sep 26 2015 May 7 2016 May 28 2017
Lance, Howard L. 0.000 0.00% 0.027 0.07%
CEO - Shares - Amount $0.000 $1.709
Options - percentage 0.000 0.00% 0.425 1.17%
Options - amount $0.000 $26.711
Friedmann, Daniel 0.042 0.12% 0.042 0.12% 0.027 0.07% 0.027 0.07%
CEO - Shares - Amount $3.431 $3.977 $2.252 $1.820
Options - percentage 0.604 1.67% 0.624 1.73% 0.422 1.16% 0.612 1.68%
Options - amount $49.668 $59.201 $35.108 $40.914
Wirasekara, Anil 0.028 0.08% 0.028 0.08% 0.011 0.03% 0.011 0.03% 0.017 0.05%
CFO - Shares - Amount $2.333 $2.691 $0.912 $0.732 $1.072
Options - percentage 0.217 0.60% 0.163 0.45% 0.153 0.42% 0.225 0.62% 0.287 0.79%
Options - amount $17.832 $15.477 $12.739 $15.050 $18.038
Stephenson, Bruce 0.000 0.00%
Officer - Shares - Amount $0.000
Options - percentage 0.067 0.18%
Options - amount $4.211
Louis, Peter 0.017 0.05% 0.014 0.04% 0.017 0.05% 0.017 0.05% Ceased to be insider Ayg 16
Officer - Shares - Amount $1.395 $1.345 $1.410 $1.143
Options - percentage 0.235 0.65% 0.181 0.50% 0.198 0.55% 0.298 0.82%
Options - amount $19.341 $17.218 $16.458 $19.911
Osborne, Donald 0.006 0.02%
Officer - Shares - Amount $0.404
Options - percentage 0.323 0.89%
Options - amount $20.322
Bentz, Brian C. 0.002 0.00%
Director - Shares - Amount $0.142
Options - percentage 0.007 0.02%
Options - amount $0.665
Chookaszian, Dennis 0.014 0.04% 0.014 0.04% 0.014 0.04% 0.014 0.04%
Director $1.158 $1.172 $0.941 $0.884
Options 0.012 0.03% 0.014 0.04% 0.015 0.04% 0.016 0.04%
deferred share unit $0.975 $1.143 $0.980 $1.026
Phillips, Robert L. 0.005 0.01% 0.005 0.01% 0.005 0.01% 0.006 0.02%
Chairman - Shares - Amt $0.475 $0.416 $0.334 $0.377
Options - percentage 0.020 0.06% 0.022 0.06% 0.024 0.06% 0.026 0.07%
Options - amount $1.925 $1.839 $1.581 $1.645
Deferred Share Unit- DSU
Share Appreciation Rights - SARs
Deferred Restricted Share Units -DRSU
Deferred share units: 0.007 0.02% 0.000 0.00%
Average price $0.594 $0.000
SARs Exercised 1.141 3.16% 0.665 1.84% Share Appreciation Rights
Employees paid for shares $56.957 $35.806
Price Co. for shares $26.243
Net Cost of Company? -$30.714
Increase in O/S Shares 1.580 4.38% 0.000 0.00% 0.051 0.14% 0.084 0.23%
Due to SO $69.805 $0.000 $4.219 $5.609
Book Value $0.098 $0.000 $4.792 $8.790
Insider Buying $0.000 -$0.055 -$0.055 -$2.525
Insider Selling $0.000 $7.038 $6.579 $3.473
Net Insider Selling $0.000 $6.983 $6.524 $0.948
% of Market Cap 0.00% 0.23% 0.22% 0.03%
Directors 7 8 8 8 10
Women 0 0% 0 0% 1 13% 1 13% 2 20%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 76 43.27% 99 44.99% 112 50.05% 100 59.36% 102 69.81%
Total Shares Held 16.671 46.24% 16.238 44.96% 18.121 50.02% 21.519 59.15% 25.428 69.84%
Increase/Decrease 3 Mths 0.418 2.57% 0.584 3.73% -0.243 -1.33% -0.130 -0.60% 2.546 11.13%
Starting No. of Shares 16.252 15.654 18.365 21.649 22.881
Copyright © 2008 Website of SPBrunner. All rights reserved.
Can Tech interview
http://www.cantechletter.com/2011/05/anil-wirasekara-macdonald-dettwiler-interview/ 
Macdonald Dettwiler gets US Government OK on Loral Acquisition
http://www.cantechletter.com/2012/09/macdonald-dettwiler-gets-us-government-ok-on-loral-acquisition/ 
donvillekent.us6.list-manage.com/track/click?u=90031b83688dd5c83d79fcf31&id=08ea5aaf7f&e=c85cdbb9b3
www.donvillekent.com/pdf/DKAM-Newsletter_July 2013_Final.pdf
Quotes from above report
MacDonald Dettwiler (MDA) - a communications and information company, provides operational solutions to commercial and government organizations worldwide. It offers 
commercial communications satellites; and supplies antenna solutions for communications satellites, as well as satellite payloads, antenna, and electronic subsystems. MDA has a 5 year average ROE of 37%.
So where do I see the next “big idea”? In my view, knowledge based companies are the place to be. What is a knowledge based company? They are companies that use 
technology, science and/or sophisticated and complex operations to create a value proposition that has two qualities. First, the company’s good or service can be sold at a 
significant premium to what it costs in terms of inputs and this is reflected in high profit margins. Second, the uniqueness of the product protects the company from the assault of 
potential competitors. A knowledge based company that possess these two attributes is typically a company that can generate a high ROE (20% +) on a sustained basis. I also 
believe that such companies are among the few that can generate high ROE’s in a low aggregate demand environment.