Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Canadian National Railway Company logo

Canadian National Railway Company

Sector: Industrials   

Industry: Railroads

129.32
 
USD
  
1.67
  
(1.31%)
Optionable: Yes  Market Cap: 81,947 M  90-day average vol: 985,246

Previous close: 127.65  Open: 128.2  Bid: 121.75  Ask: 135.25
52 week range    
103.96   
   134.02
Peers   
CSX / 
NSC / 
UNP / 
Last updated: Tuesday 23rd April 2024
59
MarketXLS Rank
50
Value
84
Technical
44
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CP-CA

CSX

0.011177 B20.433.65

NSC

0.018866 B22.4264.04

UNP

0.0195159 B24.6241.15
Financials

CNI Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Basic EPS from continuing operations3.864.424.697.285.895.855.016.97.468.55
Basic EPS total3.864.424.697.285.895.855.016.97.468.55
Basic weighted shares outstanding820 M801 M776 M754 M735 M720 M711 M709 M686 M658 M
Cost of sales7,142 M6,951 M6,642 M7,366 M8,359 M8,832 M8,048 M8,408 M2,518 M2,097 M
Depreciation1,729 M1,817 M
Depreciation unreconciled1,729 M1,817 M
DepreciationAndAmortization1,729 M1,817 M
Diluted EPS total3.854.394.677.245.875.835.06.897.448.53
Diluted normalized net income/share3.854.394.677.245.875.835.06.897.448.53
Diluted weighted shares outstanding824 M805 M779 M757 M738 M723 M713 M710 M688 M659 M
Dividends paid per share1.01.251.51.651.822.152.32.462.933.16
Fuel1,846 M1,285 M1,051 M1,362 M1,732 M1,637 M1,152 M1,513 M2,518 M2,097 M
GainOnSaleOfPPE120 M52 M93 M22 M365 M50 M-475 M160 M15 M136 M
GainOnSaleOfSecurity-486 M
GeneralAndAdministrativeExpense338 M359 M
Gross operating profit4,992 M5,660 M5,395 M5,675 M5,962 M6,085 M5,771 M6,069 M14,589 M14,731 M
Income before tax4,360 M4,874 M4,927 M5,089 M5,682 M5,429 M4,544 M6,333 M6,847 M6,488 M
Income restructuring and M&A-802 M
Income taxes1,193 M1,336 M1,287 M-395 M1,354 M1,213 M982 M1,441 M1,645 M863 M
Interest income498 M479 M
InterestExpenseNonOperating371 M439 M480 M481 M489 M538 M554 M610 M548 M722 M
MiscOtherSpecialCharges6 M-9 M
Net income from total operations3,167 M3,538 M3,640 M5,484 M4,328 M4,216 M3,562 M4,892 M5,202 M5,625 M
NetIncomeCommonStockholders3,167 M3,538 M3,640 M5,484 M4,328 M4,216 M3,562 M4,892 M5,202 M5,625 M
NetIncomeContinuousOperations3,167 M3,538 M3,640 M5,484 M4,328 M4,216 M3,562 M4,892 M5,202 M5,625 M
NetNonOperatingInterestIncomeExpense371 M439 M480 M481 M489 M538 M554 M610 M-50 M-243 M
Normalized income3,453 M3,924 M3,891 M5,104 M4,280 M4,432 M4,323 M4,199 M5,018 M4,633 M
Operating income4,992 M5,660 M5,395 M5,675 M-2,866 M-3,239 M5,771 M6,069 M6,840 M6,597 M
Operating income before depreciation (EBITDA)5,781 M6,471 M6,632 M6,851 M7,500 M7,529 M6,687 M8,541 M9,124 M9,027 M
OperatingExpense8,828 M9,324 M7,749 M8,134 M
Other income net-261 M-347 M12 M-105 M209 M-118 M-673 M874 M-50 M-127 M
Other special charges368 M394 M363 M432 M469 M492 M508 M506 M
OtherCostofRevenue3,917 M4,135 M3,991 M4,305 M4,831 M5,189 M4,875 M4,961 M
OtherGandA338 M359 M
OtherOperatingExpenses5,682 M5,958 M
RentAndLandingFees338 M359 M
RestructringAndMnAIncome-802 M
Selling Gen & administrative expense338 M359 M
Special income/charges248 M342 M270 M410 M104 M442 M983 M-456 M
Total Income available for interest expense (EBIT)4,731 M5,313 M5,407 M5,570 M6,171 M5,967 M5,098 M6,943 M7,395 M7,210 M
Total common shares outstanding809 M791 M767 M746 M728 M715 M712 M705 M708 M
Total net income3,167 M3,538 M3,640 M5,484 M4,328 M4,216 M3,562 M4,892 M5,202 M5,625 M
Total ordinary shares644 M644 M644 M644 M644 M644 M644 M644 M644 M644 M
Total revenues11,455 M12,611 M11,326 M12,293 M13,548 M14,198 M13,218 M13,888 M16,569 M16,236 M
TotalExpenses-7,142 M-6,951 M-6,642 M-7,366 M-17,187 M-18,156 M-8,048 M-8,408 M
TotalRevenue12,134 M12,611 M12,037 M13,041 M14,321 M14,917 M13,819 M14,477 M17,107 M16,828 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University