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

OCFT Income Statement

Annual
Invalid dateDec-19Dec-20Dec-21Dec-22
AcquiredInProcessRnD40000.0-1,962 M
AcquiredInProcessRnDIncome-27 M-1,282 M
AcquisitionExpense37 M
AllowancesForConstruction221 M150 M11 M
Amortization of intangibles-332 M-283 M-303 M-162 M
Basic EPS from continuing operations-12.7
Basic EPS total-17.7-12.7-11.6-0.8
Basic weighted shares outstanding94 M106 M111 M1,095 M
Cost of sales1,561 M2,069 M2,696 M-2,829 M
Depreciation-127 M-139 M-136 M-119 M
Depreciation unreconciled-460 M-421 M-439 M-281 M
DepreciationAndAmortization-460 M-421 M-439 M-281 M
DevelopmentExpense77 M
Diluted EPS total-17.7-12.7-11.6-0.8
Diluted weighted shares outstanding94 M106 M111 M2,401 M
Earnings from equity interest-15 M-68 M10 M-346 M
EarningsFromEquityInterestNetOfTax-15 M-68 M10 M-346 M
ExciseTaxes175 M
GainOnSaleOfBusiness-1,661 M
GainOnSaleOfPPE13 M1 M46 M106 M
GainOnSaleOfSecurity-1,582 M3 M-872 M
GeneralAndAdministrativeExpense757 M835 M842 M825 M
Gross operating profit592 M1,243 M1,437 M1,635 M
ImpairmentOfCapitalAssets45 M135 M72 M34 M
Income before tax-4,953 M-3,424 M-4,364 M-990 M
Income taxes-75 M13 M-112 M-62 M
Interest income128 M77 M29 M15 M
InterestExpenseNonOperating-173 M-135 M77 M-35 M
InterestIncomeOperating-1,962 M
MinorityInterests-27 M-61 M-49 M-56 M
MiscOtherSpecialCharges1,755 M2,722 M944 M-56 M
Net income from total operations-4,905 M-3,497 M-4,300 M-1,921 M
NetIncomeCommonStockholders-4,905 M-3,497 M-4,300 M-1,921 M
NetIncomeContinuousOperations-4,905 M-3,497 M-4,300 M-1,921 M
NetNonOperatingInterestIncomeExpense-1,453 M77 M-48 M15 M
Operating income-1,831 M-1,336 M-1,333 M-628 M
Operating income before depreciation (EBITDA)-5,585 M-3,980 M-4,726 M-1,307 M
OperatingExpense2,423 M2,579 M2,769 M2,620 M
Other income net1,624 M68 M2,758 M1,280 M
OtherGandA757 M835 M842 M825 M
OtherImpairmentOfCapitalAssets-23 M-6 M-10 M
OtherOperatingExpenses74 M-58 M-14 M-71 M
PromotionAndAdvertising-47 M-60 M-111 M-50 M
RealizedCapitalGain-1,487 M
RentAndLandingFees825 M
Research & development expense956 M1,173 M1,353 M1,418 M
ResearchExpense956 M1,173 M1,353 M1,418 M
Revenue per share-332 M-283 M-303 M-162 M
SalariesAndWages-1,481 M-1,643 M-1,629 M-1,602 M
Selling Gen & administrative expense1,392 M1,464 M1,430 M1,236 M
SellingAndMarketingExpense636 M629 M588 M411 M
SellingExpense636 M629 M588 M411 M
Special income/charges-45 M-2,097 M-72 M-34 M
Total Income available for interest expense (EBIT)-5,126 M-3,559 M-4,287 M-1,025 M
Total common shares outstanding110 M117 M117 M1,170 M
Total net income-4,905 M-3,497 M-4,300 M-1,921 M
Total ordinary shares39 M39 M39 M39 M
Total revenues2,328 M3,312 M4,132 M4,821 M
TotalExpenses3,984 M4,648 M5,465 M-209 M
TotalRevenue2,153 M3,312 M4,132 M4,464 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.

We respect your privacy and will never share your email.
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