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

ERJ Balance Sheet

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""5 M11 M12 M12 M
Accounts payable825 M892 M358 M502 M510 M767 M
Accounts receivable297 M318 M167 M203 M189 M203 M
Accrued expenses1,154 M1,186 M522 M753 M751 M1,087 M
AllowanceForLoansAndLeaseLosses53 M
Cash and equivalents6 M6 M8 M5 M4 M12 M
CashCashEquivalentsAndShortTermInvestments6 M6 M8 M5 M4 M12 M
CashEquivalents887 M1,156 M270 M765 M971 M
Common stock equity4,064 M3,846 M3,518 M2,795 M2,668 M2,568 M
CurrentCapitalLeaseObligation58 M5 M11 M12 M12 M
CurrentDeferredRevenue189 M186 M248 M246 M
CurrentDeferredTaxesAssets171 M132 M94 M106 M142 M
CurrentDeferredTaxesLiabilities258 M254 M272 M475 M506 M371 M
CurrentProvisions124 M117 M103 M99 M109 M127 M
Deferred revenues1,259 M1,299 M921 M1,508 M1,710 M1,840 M
DividendsPayable37 M5 M1 M1 M
FinancialAssets2,622 M1,931 M425 M871 M816 M670 M
Finished goods90 M146 M106 M137 M55 M
Float term debt347 M17 M14 M10 M
GoodwillAndOtherIntangibleAssets1,882 M1,899 M894 M2,076 M2,213 M2,247 M
Gross fixed assets (Plant Property & Equipment)2,105 M1,965 M1,007 M2,018 M1,748 M1,714 M
Inventories2,149 M2,507 M1,304 M2,438 M1,986 M2,329 M
InventoriesAdjustmentsAllowances-102 M-46 M-6 M-35 M
Invested capital4,411 M3,863 M3,531 M2,795 M2,668 M2,568 M
LongTermCapitalLeaseObligation34 M53 M52 M59 M
LongTermDebtAndCapitalLeaseObligation347 M17 M47 M53 M52 M59 M
LongTermProvisions136 M126 M100 M114 M121 M150 M
Minority interest113 M94 M97 M113 M107 M257 M
Net fixed assets (net PP&E)2,105 M1,965 M1,007 M2,018 M1,748 M1,714 M
NonCurrentAccountsReceivable2 M
NonCurrentDeferredAssets13 M22 M700000.0105 M98 M48 M
NonCurrentDeferredLiabilities126 M198 M34 M271 M312 M535 M
NonCurrentDeferredTaxesAssets13 M22 M700000.0105 M98 M48 M
NonCurrentPrepaidAssets104 M
Number of employees18320.018320.018320.018320.018320.018320.0
Other current assets518 M857 M120 M317 M197 M352 M
Other equity adjustments37 M2,471 M37 M37 M37 M40 M
Other non-current assets633 M143 M5,327 M122 M493 M186 M
Other non-current liabilities5,566 M1,788 M5,102 M5,818 M5,158 M2,986 M
Other receivable2 M1 M9 M10 M51 M
OtherCurrentLiabilities516 M4,091 M1,670 M531 M705 M2,017 M
OtherEquityInterest2,743 M2,434 M2,110 M1,378 M1,302 M1,194 M
OtherPayable292 M288 M163 M250 M241 M320 M
Payables1,154 M1,186 M522 M753 M751 M1,087 M
Prepaid expenses29 M31 M30 M48 M70 M
Raw materials405 M424 M225 M576 M446 M
Retained earnings-103 M-146 M-155 M-146 M-194 M-190 M
TaxesReceivable120 M94 M65 M50 M77 M
Total assets11,975 M11,293 M10,573 M10,516 M10,155 M10,142 M
Total current assets7,080 M7,071 M8,571 M6,116 M5,876 M5,757 M
Total current liabilities2,803 M3,029 M6,386 M2,429 M2,829 M3,217 M
Total equity4,064 M3,846 M3,518 M2,795 M2,668 M2,568 M
Total liabilities7,797 M7,353 M6,958 M7,609 M7,380 M7,318 M
Total non-current assets4,895 M4,222 M2,001 M4,400 M4,279 M4,386 M
Total non-current liabilities4,994 M4,325 M572 M5,180 M4,551 M4,101 M
TotalEquityGrossMinority4,178 M3,940 M3,583 M2,908 M2,775 M2,824 M
TotalEquityGrossMinorityInterest4,178 M3,940 M3,583 M2,908 M2,775 M2,824 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest11,975 M11,293 M10,573 M10,516 M10,155 M10,142 M
TotalNonCurrentLiabilitiesNetMinorityInteres4,994 M4,325 M572 M5,180 M4,551 M4,101 M
Treasury stock-52 M-31 M-26 M-26 M-28 M-28 M
UnearnedIncome75 M18 M
UnrealizedGainLoss37 M2,471 M37 M37 M37 M40 M
Work in progress612 M892 M440 M631 M688 M
Working capital4,276 M4,042 M2,185 M3,687 M3,047 M2,539 M
ltinv938 M1,057 M435 M1,049 M1,749 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