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

CPA Income Statement

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles131 M
Basic EPS from continuing operations8.582.085.81-14.281.038.5812.78
Basic EPS total8.582.085.81-14.281.038.5812.78
Basic weighted shares outstanding42 M42 M42 M42 M42601.040581.040 M
Cost of sales1,285 M1,171 M1,006 M244 M425 M1,349 M
CumulativeEffectOfAccountingChange35 M36 M
Depletion243 M56 M
Depreciation-12 M-107 M102 M-95 M36 M-74 M306 M
Depreciation unreconciled167 M277 M384 M502 M332 M268 M306 M
DepreciationAndAmortization167 M277 M282 M259 M240 M268 M306 M
Diluted EPS total8.582.085.81-14.281.037.8812.78
Diluted normalized net income/share8.582.071.037.8812.78
Diluted weighted shares outstanding89 M42 M42 M42 M42601.096 M40 M
Dividends paid per share0.75
ExciseTaxes211 M
Fuel573 M766 M878 M167 M383 M1,053 M
GainOnSaleOfSecurity-98 M
GeneralAndAdministrativeExpense135 M133 M103 M30 M70 M
Gross operating profit1,215 M1,479 M1,459 M538 M1,059 M1,577 M3,457 M
ImpairmentOfCapitalAssets-189 M-89 M-243 M-5 M-5 M
Income before tax413 M632 M786 M-1,041 M180 M388 M611 M
Income taxes49 M35 M46 M-24 M10 M265 M97 M
InsuranceAndClaims211 M70 M
Interest income18 M24 M24 M20 M11 M18 M50 M
InterestExpenseNonOperating51 M57 M73 M-76 M-88 M158 M
InterestExpenseOperating-49 M-52 M
MaintenanceAndRepairs132 M219 M128 M77 M42 M104 M
MarketingExpense130 M97 M
MiscOtherSpecialCharges148 M609 M55 M14 M6 M45 M7 M
Net income from total operations766 M597 M740 M-1,087 M170 M760 M514 M
NetIncomeCommonStockholders766 M597 M740 M-1,087 M170 M760 M514 M
NetIncomeContinuousOperations766 M597 M740 M-1,087 M170 M760 M514 M
NetIncomeDiscontinuousOperations2000.0
NetNonOperatingInterestIncomeExpense16 M-27 M-37 M20 M11 M18 M-108 M
NetOperatingInterestIncomeExpense49 M52 M
Normalized income449 M
Operating income826 M480 M749 M-784 M278 M1,087 M807 M
Operating income before depreciation (EBITDA)581 M910 M1,073 M-293 M344 M568 M1,075 M
OperatingExpense389 M999 M709 M1,322 M781 M490 M2,650 M
Other income net-3 M-609 M-63 M209 M102 M70 M91 M
Other special charges60 M
OtherCostofRevenue580 M186 M193 M
OtherGandA135 M133 M103 M30 M70 M
OtherImpairmentOfCapitalAssets28 M
OtherOperatingExpenses96 M124 M118 M72 M87 M125 M1,907 M
OtherTaxes210 M60 M
PromotionAndAdvertising131 M
ProvisionForGainLossOnDisposal2000.0
RealizedCapitalGain-74 M-80 M-88 M
RentAndLandingFees135 M133 M103 M
Research & development expense104 M
ResearchExpense104 M
SalariesAndWages-9 M284 M104 M717 M106 M-70 M437 M
Selling Gen & administrative expense135 M133 M103 M30 M256 M167 M
SellingAndMarketingExpense-200 M70 M256 M97 M
SellingExpense-5 M
Special income/charges28 M189 M89 M-60 M22 M31 M
Total Income available for interest expense (EBIT)413 M633 M791 M-552 M104 M301 M769 M
Total common shares outstanding42 M42 M42 M42 M42 M39 M
Total net income766 M597 M740 M-1,087 M170 M760 M514 M
Total ordinary shares31 M31 M31 M31 M31 M31 M31 M
Total revenues2,500 M2,650 M2,675 M782 M1,484 M2,926 M3,457 M
TotalExpenses1,674 M2,170 M1,715 M1,565 M1,206 M1,840 M2,650 M
TotalRevenue2,522 M2,650 M2,464 M782 M1,484 M2,965 M3,457 M
WriteDown-28 M-32 M-32 M-13 M-22 M-25 M
WriteOff36 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