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

TRP Stock Forecast, Price Targets, Chart, Dividends & Analysis

TransCanada Corporation logo

TransCanada Corporation

Sector: Energy   

Industry: Oil & Gas Midstream

45.79
 
USD
  
0.46
  
(1.01%)
Previous close: 45.33  Open: 45.0  Bid: 45.11  Ask: 46.49
52 week range    
34.95   
   50.37
Mkt Cap: 47,775 M  Avg Vol (90 Days): 2,920,998
Peers   
ENB / 
EPD / 
WMB / 
SE / 
KMI / 
PAA / 
ENB-CA / 
TAC / 
UGP / 
Last updated: Sunday 22nd December 2024

Stock Rankings

60
MarketXLS Rank
100
Value
30
Technical
50
Quality
How are these ranks calculated?
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ENB

0.064890 B22.0241.37

ENB-CA

EPD

KMI

0.042859 B23.326.85

PAA

SE

TAC

0.01224 B38.9213.85

UGP

UGPA3-BR

WMB

0.035565 B18.4253.49
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.84
Basic EPS total2.46-1.750.163.443.924.284.741.870.642.84
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 M6,468 M6,707 M8,050 M8,182 M
Depreciation2,584 M
Depreciation unreconciled2,620 M106 M
DepreciationAndAmortization2,620 M106 M
Diluted EPS total2.46-1.750.163.433.924.274.741.860.642.84
Diluted normalized net income/share2.46-1.750.163.433.924.274.741.860.642.84
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 M4 M
GainOnSaleOfSecurity-1000000.0298 M40 M-244 M
Gross operating profit6,265 M6,834 M7,881 M8,443 M9,843 M10,426 M6,531 M6,680 M6,927 M7,752 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 M1,836 M2,015 M2,183 M2,582 M
MinorityInterests153 M6 M252 M238 M-185 M293 M-297 M-91 M-37 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 M748 M2,922 M
NetIncomeCommonStockholders1,743 M-1,240 M124 M2,997 M3,539 M3,976 M4,457 M1,815 M641 M2,829 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 M2,446 M
Normalized income1,823 M6,507 M3,920 M4,593 M3,809 M3,458 M3,455 M4,070 M9,534 M5,043 M
Operating income3,292 M3,531 M4,020 M4,537 M5,681 M5,786 M5,804 M5,906 M10,975 M6,855 M
Operating income before depreciation (EBITDA)5,578 M1,998 M4,563 M7,429 M8,516 M9,929 M9,533 M6,703 M6,141 M9,176 M
OperatingExpense2,973 M3,303 M3,861 M3,906 M4,162 M4,640 M4,605 M4,872 M4,002 M897 M
Other income net730 M-3,267 M-1,288 M653 M533 M1,274 M1,358 M-1,824 M6,104 M-399 M
Other special charges-136 M-295 M-419 M-507 M-526 M-475 M-349 M-267 M
OtherCostofRevenue5,404 M
OtherImpairmentOfCapitalAssets3,048 M2,100 M
OtherOperatingExpenses2,973 M3,303 M3,861 M3,906 M3,593 M3,913 M3,878 M4,098 M534 M
OtherTaxes473 M517 M555 M569 M569 M727 M727 M774 M848 M897 M
OtherunderPreferredStockDividend97 M94 M109 M160 M163 M164 M159 M140 M107 M
PreferredStockDividends97 M94 M109 M160 M163 M164 M159 M140 M107 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 M6,943 M4,181 M3,557 M6,592 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 M748 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 M9,079 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