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

36.41
 
USD
  
0.68
  
(1.90%)
Optionable: Yes  Market Cap: 37,176 M  90-day average vol: 3,294,992

Previous close: 35.73  Open: 35.89  Bid: 35.7  Ask: 36.41
52 week range    
32.52   
   42.49
Peers   
ENB / 
EPD / 
WMB / 
SE / 
KMI / 
PAA / 
ENB-CA / 
TAC / 
UGP / 
Last updated: Friday 3rd May 2024
51
MarketXLS Rank
65
Value
46
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

Financials

TRP Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-28 M-3 M-87 M-38 M-49 M-42 M-55 M-93 M-190 M-190 M
(Increase) Decrease in other current assets-385 M-272 M315 M203 M45 M-15 M-221 M-141 M118 M118 M
(Increase) Decrease in other current liabilities16 M-25 M
(Increase) Decrease in payables377 M-97 M424 M151 M-70 M352 M-162 M890 M-83 M-83 M
(Increase) Decrease in receivables-189 M-65 M-482 M-576 M-69 M31 M129 M-925 M-575 M-575 M
Acquisitions-497 M-729 M-14,373 M-1,681 M-1,015 M-373 M-88 M-1,210 M-307 M
AssetImpairmentCharge3,745 M1,388 M1,257 M801 M2,775 M3,501 M3,501 M
Cash at beginning of period927 M489 M850 M1,016 M1,089 M446 M1,343 M1,530 M673 M673 M
Cash at end of period489 M850 M1,016 M1,089 M446 M1,343 M1,530 M673 M620 M620 M
Cash flow4,226 M4,384 M5,069 M5,230 M6,555 M7,082 M7,058 M6,890 M6,375 M6,375 M
CashFlowFromContinuingInvestingActivities-4,291 M-4,879 M-18,783 M-3,699 M-10,019 M-6,872 M-6,052 M-7,712 M-7,009 M-7,009 M
ChangeInAccountPayable377 M-97 M424 M151 M-70 M352 M-162 M890 M-83 M
ChangeInAccruedExpense36 M91 M62 M12 M41 M-33 M-18 M-18 M91 M91 M
ChangeInInterestPayable36 M91 M62 M12 M41 M-33 M-18 M-18 M91 M91 M
ChangeInPayablesAndAccruedExpense413 M-6 M486 M163 M-29 M319 M-180 M872 M8 M8 M
ChangeInWorkingCapital-189 M-346 M248 M-273 M-102 M293 M-327 M-287 M-639 M-639 M
ChangesInAccountReceivables-189 M-65 M-482 M-576 M-69 M31 M129 M-925 M-575 M-575 M
CommonStockDividendPaid-1,345 M-1,446 M-1,436 M-1,339 M-1,571 M-1,798 M-2,987 M-3,317 M-3,279 M-3,279 M
CommonStockPayments-294 M-14 M-1,205 M1,905 M1,905 M
Current deferred income taxes686 M-102 M196 M-238 M117 M55 M-58 M-185 M174 M174 M
Deferred income taxes686 M-102 M196 M-238 M117 M55 M-58 M-185 M174 M174 M
Depreciation2,584 M2,584 M
Depreciation unreconciled1,611 M1,765 M1,939 M2,055 M2,350 M2,464 M2,590 M2,522 M2,584 M2,584 M
DepreciationAndAmortization1,611 M1,765 M1,939 M2,055 M2,350 M2,464 M2,590 M2,522 M2,584 M2,584 M
EarningsLossesFromEquityInvestments-522 M-440 M-514 M-773 M-714 M-920 M-1,019 M-898 M-29 M-29 M
Effect of exchange rate changes112 M-127 M-39 M73 M-6 M-19 M53 M94 M94 M
FinancingCashFlow-373 M744 M14,007 M-1,419 M2,748 M693 M-800 M-88 M487 M487 M
Free cash flow4,226 M4,384 M5,069 M5,230 M6,555 M7,082 M7,058 M6,890 M
Issuance of capital stock47 M82 M7,962 M499 M1,197 M253 M91 M148 M
Issuance of debt817 M1,656 M-220 M1,003 M
IssuanceOfCapitalStock47 M82 M7,962 M499 M1,197 M253 M91 M148 M
IssuanceOfDebt878 M2,475 M6,400 M1,064 M3,505 M2,614 M1,573 M4,470 M2,944 M2,944 M
Net cash from financing activities-373 M744 M14,007 M-1,419 M2,748 M693 M-800 M-88 M487 M487 M
Net cash from investing activities-4,291 M-4,879 M-18,783 M-3,699 M-10,019 M-6,872 M-6,052 M-7,712 M-7,009 M-7,009 M
Net cash from operating activities4,226 M4,384 M5,069 M5,230 M6,555 M7,082 M7,058 M6,890 M6,375 M6,375 M
Net change in cash & cash equivalents-438 M361 M166 M73 M-643 M897 M187 M-857 M-147 M-147 M
Net income from continuing operations1,993 M-1,140 M485 M3,395 M3,517 M4,433 M4,913 M2,046 M785 M785 M
NetBusinessPurchaseAndSale-497 M-729 M-14,373 M-1,681 M-1,015 M-373 M-88 M-1,210 M-307 M
NetCapitalExpenditureDisposals-6,727 M-6,727 M
NetCommonStockIssuance47 M-212 M7,948 M-706 M1,197 M253 M91 M148 M1,905 M1,905 M
NetForeignCurrencyExchangeGainLoss63 M5 M-53 M86 M41 M28 M28 M
NetIntangiblesPurchaseAndSale-49 M-49 M
NetInvestmentPropertiesPurchaseAndSale-602 M-765 M-1,210 M-3,433 M-3,444 M
NetInvestmentPurchaseAndSale-602 M-765 M-1,210 M-3,433 M-3,444 M
NetIssuancePaymentsOfDebt878 M2,475 M6,400 M1,064 M3,505 M2,614 M1,573 M4,470 M2,944 M2,944 M
NetLongTermDebtIssuance878 M2,475 M6,400 M1,064 M2,688 M958 M1,793 M3,467 M2,944 M2,944 M
NetPPEPurchaseAndSale-6,678 M-6,678 M
NetPreferredStockIssuance240 M243 M1,474 M-500 M-1,000 M-1,000 M
Operating (gains) losses-602 M-271 M316 M-1,405 M-914 M-897 M-902 M-892 M-30 M-30 M
Other financing charges net-99 M-224 M-279 M-283 M-225 M-216 M682 M-748 M23 M
Other investing changes net531 M270 M165 M5,149 M789 M2,099 M2,936 M-651 M519 M530 M
Other non-cash items-73 M-118 M-198 M-382 M-419 M-345 M-178 M-258 M3,501 M3,501 M
Payment of cash dividends1,439 M1,538 M1,536 M1,494 M1,729 M1,958 M3,146 M3,458 M3,385 M3,385 M
PensionAndEmployeeBenefitExpense37 M44 M-3 M-64 M-35 M-45 M-19 M-5 M-29 M-29 M
PreferredStockDividendPaid-94 M-92 M-100 M-155 M-158 M-160 M-159 M-141 M-106 M-106 M
PreferredStockIssuance440 M243 M1,474 M
PreferredStockPayments-200 M-500 M-1,000 M-1,000 M
Purchase of short term investments1,947 M4,580 M13,553 M8,149 M6,238 M4,460 M5,770 M11,225 M3,516 M3,516 M
PurchaseOfIntangibles-49 M-49 M
PurchaseOfInvestment-602 M-765 M-1,210 M-3,433 M-3,444 M
PurchaseOfLongTermInvestments-3,433 M-3,444 M
PurchaseOfPPE-6,678 M-6,678 M
Repayment of debt-1,069 M-2,105 M-7,153 M-7,085 M-3,550 M-3,502 M-3,977 M-7,758 M-572 M-572 M
RepaymentOfDebt-1,069 M-2,105 M-7,153 M-7,085 M-3,550 M-3,502 M-3,977 M-7,758 M
Repurchase of capital stock-294 M-14 M-1,205 M1,905 M1,905 M
SaleOfPPE33 M
UnrealizedGainLossOnInvestmentSecurities74 M58 M-149 M-149 M220 M-134 M-103 M194 M135 M135 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