Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
TransCanada Corporation logo

TransCanada Corporation

Sector: Energy   

Industry: Oil & Gas Midstream

35.91
 
USD
  
-0.12
  
(-0.33%)
Optionable: Yes  Market Cap: 37,363 M  90-day average vol: 3,138,016

Previous close: 36.03  Open: 36.0  Bid: 35.63  Ask: 37.0
52 week range    
32.52   
   42.49
Peers   
ENB / 
EPD / 
WMB / 
SE / 
KMI / 
PAA / 
ENB-CA / 
TAC / 
UGP / 
Last updated: Thursday 25th April 2024
45
MarketXLS Rank
70
Value
23
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 ($)

ENB

0.062686 B18.943.38

ENB-CA

EPD

KMI

0.061939 B22.317.46

PAA

SE

TAC

0.01453 B-5.710.73

UGP

UGPA3-BR

WMB

0.053437 B36.530.71
Financials

TRP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Basic EPS from continuing operations2.46-1.750.163.443.924.284.741.870.642.75
Basic EPS total2.46-1.750.163.443.924.284.741.870.642.75
Basic weighted shares outstanding708 M709 M759 M872 M902 M929 M940 M973 M995 M1,030 M
Cost of sales3,920 M4,519 M4,666 M5,006 M3,836 M2,829 M2,590 M2,609 M
Depreciation2,584 M2,778 M
Depreciation unreconciled2,620 M2,884 M
DepreciationAndAmortization2,620 M2,884 M
Diluted EPS total2.46-1.750.163.433.924.274.741.860.642.75
Diluted normalized net income/share2.46-1.750.163.433.924.274.741.860.642.75
Diluted weighted shares outstanding710 M709 M760 M874 M903 M931 M940 M974 M996 M1,030 M
Dividends paid per share1.922.082.262.52.763.03.243.483.63.72
Earnings from equity interest522 M440 M514 M773 M714 M920 M1,019 M898 M1,054 M1,377 M
EarningsFromEquityInterestNetOfTax522 M440 M514 M773 M714 M920 M1,019 M898 M1,054 M1,377 M
GainOnSaleOfPPE117 M-125 M-833 M631 M170 M-121 M-50 M30 M-4,479 M-4,883 M
GainOnSaleOfSecurity-1000000.0298 M40 M-244 M
Gross operating profit6,265 M6,834 M7,881 M8,443 M9,843 M10,426 M10,409 M10,778 M14,977 M15,934 M
ImpairmentOfCapitalAssets3,745 M1,388 M1,257 M801 M2,775 M453 M
Income before tax2,824 M-1,106 M837 M3,306 M3,949 M5,187 M5,107 M2,166 M2,596 M4,010 M
Income restructuring and M&A115 M
Income taxes831 M34 M352 M-89 M432 M754 M194 M120 M-589 M942 M
Interest income-45 M-132 M103 M184 M-76 M460 M173 M444 M146 M242 M
InterestExpenseNonOperating1,143 M1,339 M1,787 M2,068 M2,217 M2,278 M2,228 M2,360 M2,606 M3,157 M
MinorityInterests153 M6 M252 M238 M-185 M293 M297 M91 M37 M-146 M
MiscOtherSpecialCharges369 M575 M
Net income from total operations1,840 M-1,146 M233 M3,157 M3,702 M4,140 M4,616 M1,955 M3,222 M2,922 M
NetIncomeCommonStockholders1,743 M-1,240 M124 M2,997 M3,539 M3,976 M4,457 M1,815 M3,222 M2,922 M
NetIncomeContinuousOperations1,993 M-1,140 M485 M3,395 M3,517 M4,433 M4,913 M2,046 M3,185 M3,068 M
NetNonOperatingInterestIncomeExpense1,198 M1,370 M1,895 M1,884 M2,265 M1,873 M2,055 M1,916 M-2,460 M-2,915 M
Normalized income1,823 M6,507 M3,920 M4,593 M3,809 M3,458 M3,455 M4,070 M9,534 M9,930 M
Operating income3,292 M3,531 M4,020 M4,537 M5,681 M5,786 M5,804 M5,906 M10,975 M11,636 M
Operating income before depreciation (EBITDA)5,578 M1,998 M4,563 M7,429 M8,516 M9,929 M9,925 M7,048 M7,786 M9,751 M
OperatingExpense2,973 M3,303 M3,861 M3,906 M4,162 M4,640 M4,605 M4,872 M4,002 M4,298 M
Other income net730 M-3,267 M-1,288 M653 M533 M1,274 M1,358 M-1,824 M6,104 M5,031 M
Other special charges-136 M-295 M-419 M-507 M-526 M-475 M-349 M-267 M
OtherImpairmentOfCapitalAssets3,048 M2,100 M
OtherOperatingExpenses2,973 M3,303 M3,861 M3,906 M3,593 M3,913 M3,878 M4,098 M534 M517 M
OtherTaxes473 M517 M555 M569 M569 M727 M727 M774 M848 M897 M
OtherunderPreferredStockDividend97 M94 M109 M160 M163 M164 M159 M140 M
PreferredStockDividends97 M94 M109 M160 M163 M164 M159 M140 M
RestructringAndMnAIncome115 M
Revenue per share36 M106 M
Special income/charges253 M-3,575 M-1,802 M-119 M-105 M354 M299 M-2,478 M453 M
Total Income available for interest expense (EBIT)3,967 M233 M2,624 M5,374 M6,166 M7,465 M7,335 M4,526 M5,202 M7,167 M
Total common shares outstanding709 M709 M864 M880 M918 M938 M940 M981 M979 M
Total net income1,840 M-1,146 M233 M3,157 M3,702 M4,140 M4,616 M1,955 M3,222 M2,922 M
Total ordinary shares1,037 M1,037 M1,037 M1,037 M1,037 M1,037 M1,037 M1,037 M1,037 M1,037 M
Total revenues10,185 M11,353 M12,547 M13,449 M13,679 M13,255 M12,999 M13,387 M12,297 M13,232 M
TotalExpenses-6,893 M-7,822 M-8,527 M-8,912 M-7,998 M-7,469 M-7,195 M-7,481 M
TotalRevenue10,185 M11,353 M12,547 M13,449 M13,679 M13,255 M12,999 M13,387 M14,977 M15,934 M
WriteOff3,745 M1,388 M1,257 M801 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