| Company Name: | Canadian National Railway Company | | Ticker Symbol: | CNR | | | WWW Address: | http://www.cn.ca | | CEO: | E. Hunter Harrison | | No. of Employees: | 22,227 | | Common Issue Type: | CS | | Business Description: | The Company is engaged in the rail and related transportation business.
|
| | | Industry Information: | TRANSPORTATION - Railroads [more like this] |
|
| Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 57.47 |  0.0 | 57.21 | 57.21 | 0 | 58.20 | 57.15 | - |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 27,016.6 | 470.1 | 0.46 | 3.95 | 0.92 | 14.9 | 1.8 | 58.20 - 37.85 |
|
| KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 57.47 | $ | | PE Ratio - LTM | 14.9 | |
| Market Capitalisation | 27,016.6 | mil |
| Latest Shares Outstanding | 470.1 | mil |
| Earnings pS (EPS) | 3.95 | $ |
| Dividend pS (DPS) | 0.92 | ¢ |
| Dividend Yield | 1.8 | % |
| Dividend Payout Ratio | 23 | % |
| Revenue per Employee | 381,608 | $ |
| Effective Tax Rate | 25.5 | % |
| Float | 0.0 | mil |
| Float as % of Shares Outstanding | 0.0 | % |
| Foreign Sales | 2,850 | mil |
| Domestic Sales | 5,632 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 26.00 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 69.8 | % |
| EBITDA Margin | 43.8 | % |
| Pre-Tax Profit Margin | 30.7 | % |
| Assets Turnover | 0.3 | % |
| Return on Assets (ROA) | 7.2 | % |
| Return on Equity (ROE) | 16.2 | % |
| Return on Capital Invested (ROCI) | 10.3 | % |
| Current Ratio | 1.2 | |
| Leverage Ratio (Assets/Equity) | 2.3 | |
| Interest Cover | 6.5 | |
| Total Debt/Equity (Gearing Ratio) | 0.68 | |
| LT Debt/Total Capital | 36.0 | % |
| Working Capital pS | 0.43 | $ |
| Cash pS | 0.50 | $ |
| Book-Value pS | 24.26 | $ |
| Tangible Book-Value pS | 20.32 | $ |
| Cash Flow pS | 4.68 | $ |
| Free Cash Flow pS | -0.22 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 2.37 | |
| Price/Tangible Book Ratio | 2.83 | |
| Price/Cash Flow | 12.3 | |
| Price/Free Cash Flow | -259.8 | |
| P/E as % of Industry Group | 30.0 | % |
| P/E as % of Sector Segment | 101.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 10/20/2009 |
| Dividend Ex-Date | 12/07/2009 |
| Dividend Record Date | 12/09/2009 |
| Dividend Pay Date | 12/30/2009 |
| Dividend Amount | 252 |
| Type of Payment | Cash Payment |
| Dividend Rate | 1.01 |
| Current Dividend Yield | 1.8 |
| 5-Y Average Dividend Yield | 1.5 |
| Payout Ratio | 23.0 |
| 5-Y Average Payout Ratio | 19.0 |
|  | | Share price performance previous 3 years |
|
 | | | Share price performance intraday |
|
 | |
| |
| PRICE/VOLUME | High | Low | Close | % Price Chg | % Price Chg vs. Mkt. | Avg. Daily Vol | Total Vol |
| 1 Week | - | - | - | -0.3 | 99 | 6,074 | 6,512 |
| 4 Weeks | 58.20 | 51.25 | 52.30 | 9.9 | 103 | 7,081 | 113,300 |
| 13 Weeks | 58.20 | 50.75 | 54.00 | 6.4 | 101 | 8,122 | 479,186 |
| 26 Weeks | 58.20 | 44.31 | 46.99 | 22.3 | 109 | 8,742 | 1,066,559 |
| 52 Weeks | 58.20 | 37.85 | 45.07 | 27.5 | 102 | 10,715 | 2,635,991 |
| YTD | 58.20 | 37.85 | - | 28.3 | 99 | 10,485 | 2,359,193 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 57.69 | 57.22 | 54.23 | 51.39 | 49.46 | 0.46 | 0.35 |
|
| |
| GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 4.31 | 72.0 | 1.12 |
| Income | 13.35 | 72.7 | 0.10 |
| Dividend | 21.23 | 95.5 | 14.50 |
| Capital Spending | 5.16 | NA | 2.94 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 13.31 | NA | 0.05 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | -12.7 | -18.3 | 7.4 |
| Earnings % | -3.8 | -16.5 | -12.2 |
| EPS % | -2.9 | -17.1 | -7.1 |
| EPS $ | -0.08 | -0.20 | -0.30 |
|
| |
| SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | -0.51 |
| Current Ratio | 0.9 |
| Quick Ratio (Acid Test) | 0.7 |
| Liquidity Ratio (Cash) | 0.22 |
| Receivables Turnover | 13.2 |
| Average Collection Period | 27 |
| Working Capital/Equity | -1.3 |
| Working Capital pS | -0.29 |
| Cash-Flow pS | 4.66 |
| Free Cash-Flow pS | 0.26 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 1.76 |
| Financial Leverage Ratio (Assets/Equity) | 2.5 |
| Debt Ratio | 60.5 |
| Total Debt/Equity (Gearing Ratio) | 0.75 |
| LT Debt/Equity | 0.70 |
| LT Debt/Capital Invested | 79.4 |
| LT Debt/Total Liabilities | 45.8 |
| Interest Cover | 7.8 |
| Interest/Capital Invested | 1.51 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 79.86 |
| Tobin's Q Ratio | 1.01 |
| Current P/E Ratio - LTM | 14.90 |
| Enterprise Value (EV)/EBITDA | 11.82 |
| Enterprise Value (EV)/Free Cash Flow | 289.96 |
| Dividend Yield | 1.8 |
| Price/Tangible Book Ratio - LTM | 2.83 |
| Price/Book Ratio - LTM | 2.37 |
| Price/Cash Flow Ratio | 12.3 |
| Price/Free Cash Flow Ratio - LTM | -259.8 |
| Price/Sales Ratio | 3.52 |
| P/E Ratio (1 month ago) - LTM | 13.7 |
| P/E Ratio (26 weeks ago) - LTM | 11.2 |
| P/E Ratio (52 weeks ago) - LTM | 10.2 |
| 5-Y High P/E Ratio | 17.3 |
| 5-Y Low P/E Ratio | 9.9 |
| 5-Y Average P/E Ratio | 13.6 |
| Current P/E Ratio as % of 5-Y Average P/E | 109 |
| P/E as % of Industry Group | 30.0 |
| P/E as % of Sector Segment | 101.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 14.9 |
| PER SHARE FIGURES |
| LT Debt pS | 15.82 |
| Current Liabilities pS | 4.04 |
| Tangible Book Value pS - LTM | 20.32 |
| Book Value pS - LTM | 24.26 |
| Capital Invested pS | 38.21 |
| Cash pS - LTM | 0.50 |
| Cash Flow pS - LTM | 4.68 |
| Free Cash Flow pS - LTM | -0.22 |
| Earnings pS (EPS) | 3.95 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 1.43 |
| Free Cash Flow Margin 5YEAR AVG | 7.49 |
| Net Profit Margin | 22.3 |
| Net Profit Margin - 5YEAR AVRG. | 23.7 |
| Equity Productivity | 0.80 |
| Return on Equity (ROE) | 17.9 |
| Return on Equity (ROE) - 5YEAR AVRG. | 19.1 |
| Capital Invested Productivity | 0.47 |
| Return on Capital Invested (ROCI) | 10.5 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 12.1 |
| Assets Productivity | 0.30 |
| Return on Assets (ROA) | 7.1 |
| Return on Assets (ROA) - 5YEAR AVRG. | 7.8 |
| Gross Profit Margin | 69.8 |
| Gross Profit Margin - 5YEAR AVRG. | 65.9 |
| EBITDA Margin - LTM | 43.8 |
| EBIT Margin - LTM | 36.2 |
| Pre-Tax Profit Margin | 30.0 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 32.3 |
| Effective Tax Rate | 25.5 |
| Effective Tax Rate - 5YEAR AVRG. | 27.1 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 54 |
| Revenue per Employee | 381,608 |
| Net Income per Employee | 85,257 |
| Average Collection Period | 39 |
| Receivables Turnover | 13.2 |
| Day's Inventory Turnover Ratio | 15 |
| Inventory Turnover | 23.3 |
| Inventory/Sales | 2.4 |
| Accounts Payble/Sales | 4.87 |
| Assets/Revenue | 3.33 |
| Net Working Capital Turnover | -62.37 |
| Fixed Assets Turnover | 0.34 |
| Total Assets Turnover | 0.3 |
| Revenue per $ Cash | 20.54 |
| Revenue per $ Plant | 0.37 |
| Revenue per $ Common Equity | 0.80 |
| Revenue per $ Capital Invested | 0.47 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 7.7 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 21.4 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
|
| |
 |  |