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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

NGL Income Statement

Annual
Mar-13Mar-14Mar-16Mar-17Mar-18Mar-19Mar-20Mar-21Mar-22Mar-23
AccruedPreferredStockDividends30 M-60 M112 M189 M93 M104 M125 M
AcquiredInProcessRnD-3 M-48 M
Amortization of intangibles-44 M-73 M-108 M-115 M-119 M116 M139 M133 M90 M83 M
Basic EPS from continuing operations0.51-2.350.99-1.080.75-7.47-11.35-4.44
Basic EPS total0.960.51-2.350.99-1.084.03-9.18-11.36-4.44
Basic weighted shares outstanding53 M126 M105 M108 M121 M123 M127 M129 M130 M
BasicDiscontinuousOperations3.28-1.71-0.01
Cost of sales-4,039 M-9,133 M-10,839 M192 M16,536 M7,983 M6,604 M4,494 M7,139 M7,650 M
Depreciation69 M121 M229 M223 M209 M212 M265 M317 M289 M274 M
Depreciation unreconciled69 M121 M229 M223 M209 M212 M265 M317 M289 M274 M
Diluted EPS total0.960.51-2.350.99-1.085.29-6.3-5.69-2.22
Diluted normalized net income/share2.01-4.59-5.68-2.22
Diluted weighted shares outstanding53 M126 M105 M112 M121 M123 M127 M129 M130 M
DilutedDiscontinuousOperations3.28-1.71-0.01
Earnings from equity interest2 M16 M3 M8 M3 M1 M2 M1 M4 M
EarningsFromEquityInterestNetOfTax2 M16 M3 M8 M3 M1 M2 M1 M4 M
ExplorationDevelopmentAndMineralPropertyLeaseExpenses170 M260 M401 M308 M201 M
GainOnSaleOfBusiness14 M0.088 M408 M
GainOnSaleOfPPE-4 M-321 M209 M17 M-34 M-262 M-475 M-94 M-87 M
GainOnSaleOfSecurity1 M103 M-56 M-117 M11 M86 M-84 M-117 M-5 M
GainsLossOnDisposalOfDiscontinuedOperations157 M420 M-218 M53000.0
GeneralAndAdministrativeExpense53 M76 M140 M117 M98 M107 M114 M70 M64 M72 M
Gross operating profit379 M567 M951 M12,830 M16,907 M706 M980 M733 M809 M1,045 M
ImpairmentOfCapitalAssets-380 M-15 M-6 M-8 M-22 M-42 M-37 M-85 M
Income before tax50 M50 M-187 M12,276 M16,188 M-78 M-180 M-641 M-183 M53 M
Income restructuring and M&A-83 M7 M21 M-5 M9 M6 M-6 M10 M
Income taxes2 M937000.0-367000.02 M1 M1 M345000.0-3 M971000.0271000.0
InterestExpenseNonOperating33 M59 M133 M150 M199 M165 M181 M199 M272 M275 M
InterestIncomeOperating-23 M
LossAndLossAdjustmentExpectedIncurred-3 M3 M343000.0216000.0678000.0
MinorityInterests250000.01 M-12 M-7 M-1 M21 M2 M-632000.0-655000.0-1 M
MiscOtherSpecialCharges-4 M86000.06 M28 M7 M-43 M3 M-53 M4 M35 M
Net income from total operations51 M64 M-151 M12,267 M16,185 M360 M-397 M-640 M-185 M51 M
NetIncomeCommonStockholders51 M64 M-151 M12,237 M16,185 M248 M-585 M-732 M-289 M-73 M
NetIncomeContinuousOperations51 M64 M-151 M12,267 M16,185 M360 M-397 M-640 M-185 M51 M
NetIncomeDiscontinuousOperations157 M420 M-218 M53000.0
NetNonOperatingInterestIncomeExpense-33 M-59 M-105 M-150 M-199 M-165 M-181 M-199 M-272 M-275 M
NetOperatingInterestIncomeExpense-23 M
Normalized income-204 M-108 M40 M
Operating income87 M110 M181 M12,183 M16,399 M127 M-3 M-391 M83 M289 M
Operating income before depreciation (EBITDA)161 M241 M195 M12,664 M16,612 M308 M278 M-111 M395 M619 M
OperatingExpense-170 M-260 M-401 M648 M508 M231 M333 M255 M286 M314 M
Other income net4 M2 M299 M-265 M-32 M75 M257 M527 M89 M48 M
Other special charges14 M-14 M-14 M
OtherGandA53 M76 M140 M117 M98 M107 M114 M70 M64 M72 M
OtherOperatingExpenses-1 M-2 M-6 M-1 M-590000.0231 M333 M255 M286 M314 M
OtherunderPreferredStockDividend30 M-60 M112 M189 M93 M104 M125 M
PreferredStockDividends30 M-60 M112 M189 M93 M104 M125 M
PromotionAndAdvertising-1 M
RentAndLandingFees-84 M-98 M-125 M-124 M-122 M92 M
RestructringAndMnAIncome-83 M7 M21 M-5 M9 M6 M-6 M10 M
SalariesAndWages-10 M-18 M
Selling Gen & administrative expense53 M76 M140 M117 M98 M107 M114 M70 M64 M72 M
SellingAndMarketingExpense-1 M
Special income/charges-3 M-83 M21 M21 M-5 M9 M6 M-6 M10 M
Total Income available for interest expense (EBIT)83 M109 M-54 M12,426 M16,387 M87 M984000.0-442 M89 M328 M
Total common shares outstanding55 M81 M104 M121 M122 M126 M129 M130 M131 M132 M
Total net income51 M64 M-151 M12,267 M16,185 M360 M-397 M-640 M-185 M51 M
Total ordinary shares133 M133 M133 M133 M133 M133 M133 M133 M133 M133 M
Total revenues4,418 M9,699 M11,790 M13,022 M16,907 M8,689 M7,583 M5,227 M7,948 M8,695 M
TotalExpenses-4,209 M-9,392 M-11,240 M840 M508 M8,214 M6,937 M4,748 M7,425 M7,964 M
TotalRevenue4,418 M9,699 M11,742 M13,022 M16,907 M8,689 M7,584 M5,227 M7,948 M8,695 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