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



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







Analyst Estimates

Financial Health





StockDividendMarket Cap (B)PEPrice ($)

ERJ Income Statement

Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquiredInProcessRnD247 M-178 M
AcquiredInProcessRnDIncome-45 M-444 M
Basic EPS from continuing operations0.22
Basic EPS total0.36-0.24-0.44-0.99-0.06-0.250.22
Basic weighted shares outstanding734 M734 M736 M1,471 M1,450 M734633.0735 M
Cost of sales-4,764 M-4,303 M-4,667 M-3,293 M-3,538 M-3,628 M4,359 M
Depreciation-196 M-74 M-114 M-164 M-107 M
Depreciation unreconciled-83 M-101 M
DepreciationAndAmortization-343 M-141 M-83 M-101 M-210 M
Diluted EPS total0.36-0.24-0.44-0.99-0.06-0.250.22
Diluted normalized net income/share0.22
Diluted weighted shares outstanding1,556 M1,427 M1,439 M1,471 M1,450 M1,628 M735 M
Earnings from equity interest1 M-400000.0-200000.03 M1 M9 M10 M
EarningsFromEquityInterestNetOfTax1 M-400000.0-200000.03 M1 M9 M10 M
GainOnSaleOfBusiness-347 M-185 M
GainOnSaleOfPPE-732 M
GainOnSaleOfSecurity-174 M-375 M
GainsLossOnDisposalOfDiscontinuedOperations90 M-112 M
GeneralAndAdministrativeExpense179 M136 M190 M143 M153 M185 M195 M
Gross operating profit1,095 M768 M796 M478 M660 M912 M910 M
ImpairmentOfCapitalAssets-58 M-61 M-72 M
Income before tax308 M-136 M-186 M-635 M27 M-206 M121 M
Income restructuring and M&A-6 M-69 M-37 M
Income taxes28 M-21 M130 M93 M71 M-2 M-44 M
Interest income-41 M6 M-116 M-607 M-199 M122 M128 M
InterestExpenseNonOperating319 M
InterestExpenseOperating3 M
InterestIncomeOperating-216 M
MinorityInterests16 M7 M6 M4 M1 M-18 M-300000.0
MiscOtherSpecialCharges5 M-523 M408 M-732 M4 M144 M
Net income from total operations560 M-342 M-633 M-1,457 M-87 M-407 M164 M
NetIncomeCommonStockholders560 M-342 M-633 M-1,457 M-87 M-407 M164 M
NetIncomeContinuousOperations560 M-342 M-633 M-1,457 M-87 M-407 M164 M
NetIncomeDiscontinuousOperations90 M-112 M
NetNonOperatingInterestIncomeExpense223 M6 M-116 M-607 M-199 M122 M-191 M
Operating income551 M-109 M270 M49 M200 M326 M161 M
Operating income before depreciation (EBITDA)651 M136 M24 M-343 M236 M5 M
OperatingExpense544 M307 M526 M429 M410 M587 M748 M
Other income net209 M174 M669 M729 M44 M621 M-154 M
Other special charges245 M
OtherCostofRevenue4,359 M
OtherGandA179 M136 M190 M143 M153 M185 M195 M
OtherOperatingExpenses-438 M-284 M-103 M-50 M-72 M149 M
RealizedCapitalGain-210 M-322 M
Research & development expense49 M20 M49 M30 M43 M110 M90 M
ResearchExpense49 M20 M49 M30 M43 M110 M90 M
RestructringAndMnAIncome-6 M-69 M-37 M
Revenue per share-146 M-67 M-96 M-128 M-104 M
SalariesAndWages-600000.062 M-13 M17 M
Selling Gen & administrative expense495 M288 M477 M337 M380 M459 M509 M
SellingAndMarketingExpense316 M151 M287 M194 M226 M274 M315 M
SellingExpense316 M151 M287 M194 M226 M274 M
Special income/charges65 M61 M72 M69 M-245 M
Total Income available for interest expense (EBIT)308 M-136 M-186 M-635 M27 M-206 M
Total common shares outstanding733 M735 M736 M736 M735 M735 M
Total net income560 M-342 M-633 M-1,457 M-87 M-407 M164 M
Total ordinary shares184 M184 M184 M184 M184 M184 M184 M
Total revenues5,859 M2,128 M5,463 M3,771 M4,147 M4,540 M5,269 M
TotalExpenses-4,220 M-3,996 M-4,142 M-2,864 M-3,128 M-3,041 M5,107 M
TotalRevenue5,859 M5,071 M5,463 M3,771 M4,197 M4,540 M5,269 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


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.


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