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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

HEP Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in other current liabilities15 M8 M9 M7 M-371000.0-4 M-2 M-8 M
(Increase) Decrease in other working capital788000.0-164000.04 M75000.0-398000.0-2 M-3 M1 M3 M6 M
(Increase) Decrease in payables7 M-676000.05 M1 M10 M4 M-5 M5 M
(Increase) Decrease in receivables4 M-5 M-401000.0-10 M-9 M6 M-6 M-8 M
Acquisitions-209 M-87 M-245 M-7 M-18 M-2 M-342 M
AssetImpairmentCharge36 M11 M
CapitalExpenditureReported52 M110 M163 M378 M45 M47 M30 M59 M90 M39 M
Cash at beginning of period5 M6 M3 M15 M4 M8 M3 M13 M22 M14 M
Cash at end of period6 M3 M81 M4 M8 M-3 M13 M22 M14 M11 M
Cash flow183 M187 M231 M236 M303 M290 M298 M317 M294 M331 M
CashFlowFromContinuingInvestingActivities-49 M-110 M-371 M-465 M-326 M-54 M-47 M-61 M-78 M-370 M
ChangeInAccountPayable7 M-776000.04 M-381000.08 M4 M-6 M5 M
ChangeInAccruedExpense13000.0-4 M137000.011 M-96000.0-2 M366000.07 M
ChangeInInterestPayable13000.0-4 M137000.011 M-96000.0-2 M366000.07 M
ChangeInPayablesAndAccruedExpense7 M-4 M6 M13 M10 M1 M-5 M12 M
ChangeInPrepaidAssets-255000.0-510000.0-626000.02 M-372000.0-1 M-255000.0-254000.0
ChangeInTaxPayable-85000.0100000.01 M2 M2 M193000.0550000.0-66000.0
ChangeInWorkingCapital27 M-2 M17 M75000.0-398000.0-2 M-3 M4 M-10 M2 M
ChangesInAccountReceivables4 M-5 M-401000.0-10 M-9 M6 M-6 M-8 M
CommonStockDividendPaid-139 M-155 M-169 M-192 M-235 M-265 M-273 M-174 M-149 M-170 M
CommonStockPayments-6 M-4 M-4 M-4 M-1 M-1 M-698000.0-2 M-2 M
Depreciation65 M62 M63 M70 M79 M98 M97 M100 M94 M99 M
Depreciation unreconciled68 M64 M65 M74 M82 M102 M100 M103 M98 M103 M
DepreciationAndAmortization68 M64 M65 M74 M82 M102 M100 M103 M98 M103 M
EarningsLossesFromEquityInvestments300000.0263000.072000.0961000.05 M1 M993000.02 M4 M20 M
FinancingCashFlow-133 M-81 M219 M-111 M52 M-248 M-241 M-247 M-223 M36 M
Free cash flow134 M77 M69 M-135 M195 M243 M269 M258 M211 M292 M
GainLossOnSaleOfPPE-2 M-375000.0-150000.0-319000.0-196000.0-229000.0-1 M-6 M-209000.0
InterestPaidSupplementalData74 M58 M50 M72 M
Issuance of capital stock73 M126 M52 M115 M
Issuance of debt-58 M208 M141 M-159 M459 M-89 M43 M-52 M-73 M-172 M
IssuanceOfCapitalStock73 M126 M52 M115 M
IssuanceOfDebt-58 M52 M141 M235 M251 M-89 M40 M-78 M-77 M224 M
Net cash from financing activities-133 M-81 M219 M207 M52 M-248 M-241 M-247 M-223 M36 M
Net cash from investing activities-49 M-110 M-371 M-143 M-286 M-54 M-47 M-61 M-78 M-370 M
Net cash from operating activities183 M187 M231 M243 M238 M290 M298 M317 M294 M331 M
Net change in cash & cash equivalents1 M-4 M79 M-11 M4 M-11 M10 M9 M-8 M-3 M
Net income from continuing operations86 M114 M146 M158 M202 M186 M233 M179 M226 M230 M
NetBusinessPurchaseAndSale-209 M-87 M-245 M-7 M-18 M-2 M-342 M
NetCommonStockIssuance68 M-4 M-4 M122 M52 M114 M-1 M-698000.0-2 M-2 M
NetInvestmentPropertiesPurchaseAndSale300000.0-36 M4 M11 M
NetInvestmentPurchaseAndSale300000.0-36 M4 M11 M
NetIssuancePaymentsOfDebt-58 M52 M141 M235 M251 M-89 M40 M-78 M-77 M224 M
NetLongTermDebtIssuance-156 M394 M-208 M-2 M-26 M-4 M396 M
NetPPEPurchaseAndSale-49 M-110 M-162 M-378 M-44 M-47 M-30 M-58 M-83 M-39 M
Operating (gains) losses-2 M8 M-303000.0811000.016 M1 M-34 M-7 M-30 M20 M
Other financing charges net-2 M26 M251 M46 M-7 M-7 M-6 M6 M5 M-17 M
Other investing changes net300000.0-36 M4 M11 M
Other non-cash items4 M4 M3 M4 M3 M3 M3 M38 M11 M-23 M
Payment of cash dividends139 M155 M169 M192 M235 M265 M273 M174 M149 M170 M
Purchase of property plant & equipment-49 M-110 M-162 M-378 M-44 M-47 M-30 M-58 M-83 M-39 M
Purchase of short term investments394 M102 M500 M400 M
PurchaseOfInvestment-103000.0
PurchaseOfLongTermInvestments-103000.0
PurchaseOfPPE-52 M-110 M-163 M-378 M-45 M-47 M-30 M-59 M-90 M-39 M
Repayment of debt-156 M-310 M-2 M-526 M-4 M-4 M
RepaymentOfDebt-369 M-590 M-833 M-713 M-820 M-426 M-325 M-837 M-558 M-686 M
Repurchase of capital stock-6 M-4 M-4 M-4 M-1 M-1 M-698000.0-2 M-2 M
Revenue per share3 M2 M2 M3 M3 M3 M3 M3 M4 M4 M
SaleOfPPE3 M1 M427000.0849000.0210000.0532000.01 M7 M279000.0
ShortTermDebtIssuance311 M642 M974 M554 M969 M337 M366 M259 M481 M510 M
ShortTermDebtPayments-369 M-434 M-833 M-713 M-510 M-426 M-323 M-310 M-554 M-682 M
StockBasedCompensation4 M4 M3 M4 M3 M3 M3 M2 M3 M2 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