0% found this document useful (0 votes)
29 views22 pages

RAP Excel

The document presents a financial overview of Airbus, detailing its assets, equity, liabilities, and profit and loss statements for the years 2020 to 2022. It highlights a decrease in total assets from €107,180 million in 2020 to €104,800 million in 2021, along with a notable increase in profit for the period from €1,169 million in 2020 to €4,174 million in 2021. Additionally, it includes various financial ratios and metrics for assessing profitability and liquidity.

Uploaded by

Zain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
29 views22 pages

RAP Excel

The document presents a financial overview of Airbus, detailing its assets, equity, liabilities, and profit and loss statements for the years 2020 to 2022. It highlights a decrease in total assets from €107,180 million in 2020 to €104,800 million in 2021, along with a notable increase in profit for the period from €1,169 million in 2020 to €4,174 million in 2021. Additionally, it includes various financial ratios and metrics for assessing profitability and liquidity.

Uploaded by

Zain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 22

AirBus

Assets 2020 2021


Non-Current Assets

Intangible Assets € 16,199.00 € 16,367.00

Property Plant and Equiptment € 16,674.00 € 16,535.00


Investment Property € 2.00 € 41.00
Investments accounted for under the equity method € 1,578.00 € 1,672.00
Other Invetments and other long term finanial assets € 3,855.00 € 4,001.00
Non-Current contract assets € 48.00 € 27.00
Non-Current other finanical assets € 3,483.00 € 691.00
Deffered Tax Assets € 4,023.00 € 4,323.00
Non-Current Securities € 5,350.00 € 6,794.00

Total Non Current Assets € 51,212.00 € 50,451.00

Current Assets

Inventories € 30,401.00 € 28,538.00


Trade Receiveables € 5,132.00 € 5,063.00
Current Portion of other long term Financial Assets € 468.00 € 537.00
Current Contract Assets € 1,074.00 € 1,377.00
Current other Assets € 2,216.00 € 2,393.00
Current Tax Assets € 620.00 € 552.00
Current Securities € 1,618.00 € 1,317.00
Cash and Cash Equivilants € 14,439.00 € 14,572.00

Total Current Assets € 55,968.00 € 54,349.00


Total Assets € 107,180.00 € 104,800.00

Equity and Liability


Equity attribute to equity owners of the parent

Capital Stock € 785.00 € 787.00


Share Premium € 3,599.00 € 3,712.00
Retained Earnings € 250.00 € 6,834.00
Accumulated other Comprehensive Income € 1,853.00 € (1,822.00)
Treasury Shares € (42.00) € (45.00)

Total Equity attributable to equity owners of the parent € 6,445.00 € 9,466.00


Non-Controlling Intrests € 11.00 € 20.00

Total Equity € 6,456.00 € 9,486.00

Liabilities
Non-Current Liability

Non-current provisions € 14,298.00 € 10,771.00


Long-term financing liabilities € 14,082.00 € 13,094.00
Non-current contract liabilities € 19,212.00 € 18,620.00
Non-current other financial liabilities € 5,657.00 € 6,562.00
Non-current other liabilities € 436.00 € 583.00
Deferred tax liabilities € 451.00 € 116.00
Non-current deferred income € 32.00 € 8.00

Total Non-Current Liabilities € 54,168.00 € 49,754.00

Current Liability

Current provisions € 4,510.00 € 6,245.00


Short-term financing liabilities € 1,946.00 € 3,013.00
Trade liabilities € 9,693.00 € 8,722.00
Current contract liabilities € 23,906.00 € 24,675.00
Current other financial liabilities € 2,532.00 € 1,769.00
Current other liabilities € 3,532.00 € 3,160.00
Current tax liabilities € 1,057.00 € 1,311.00
Current deferred income € 631.00 € 576.00

Total Current Liabilities € 47,807.00 € 49,471.00


Total Liabilities € 101,975.00 € 99,225.00

Statement of Profit&Loss

Revenue € 49,912.00 € 52,149.00


Cost of Sales € (44,250.00) € (42,518.00)

Gross Margin € 5,662.00 € 9,631.00

Selling Expense € (717.00) € (713.00)


Administrative Expenses € (1,423.00) € (1,339.00)
Research and Development Expenses € (2,858.00) € (2,746.00)
Other Income € 132.00 € 594.00
Other Expenses € (1,458.00) € (201.00)
Share of Profit from investment accounted for under
the equity method € 39.00 € 40.00
Other income from investments € 113.00 € 76.00

Profit (Loss) before financial result and income taxes € (510.00) € 5,342.00

Interest income € 140.00 € 88.00


Interest expense € (411.00) € (334.00)
Other financial result € (349.00) € (69.00)
Total financial result € (620.00) € (315.00)
Income Taxes € (39.00) € (853.00)
Profit(Loss) for the Period € 1,169.00 € 4,174.00
AirBus Boeing
2022 2020 2021 2022

€ 16,768.00

€ 16,505.00
€ 37.00
€ 2,067.00
€ 4,190.00
€ 26.00
€ 781.00
€ 4,683.00
€ 6,014.00

€ 51,071.00 € - € - € -

€ 32,202.00
€ 4,953.00
€ 665.00
€ 1,501.00
€ 2,850.00
€ 704.00
€ 1,762.00
€ 15,823.00

€ 60,460.00 € - € - € -
€ 111,531.00 € - € - € -

€ 789.00
€ 3,837.00
€ 13,408.00
€ (5,016.00)
€ (68.00)

€ 12,950.00 € - € - € -
€ 32.00

€ 12,982.00 € - € - € -
€ 6,896.00
€ 10,631.00
€ 22,044.00
€ 10,117.00
€ 498.00
€ 164.00
€ 17.00

€ 50,367.00 € - € - € -

€ 4,127.00
€ 2,142.00
€ 13,261.00
€ 23,869.00
€ 4,073.00
€ 3,803.00
€ 817.00
€ 503.00

€ 52,595.00 € - € - € -
€ 102,962.00 € - € - € -

€ 58,763.00
€ (48,192.00)

€ 10,571.00 € - € - € -

-788
-1452
€ (3,079.00)
€ 471.00
€ (590.00)

€ 134.00
€ 58.00

€ 5,325.00 € - € - € -

€ 180.00
€ (412.00)
€ (18.00)
€ (250.00)
€ (939.00)
€ 4,136.00
Profitability Ratios

Gross profit Gross profit /Sales *100 %


Net profit Net profit / Sales *100 %
ROCE (Return on Capital Profit after tax/ total assets - current
Employed) liabilities*100 %

Liquidity ratios

Current Ratios Current Assets/ Current Liabilities times


Quick Ratios Current Assets - inventory/ Current Liabilities times

Operating Ratios

number of days of inventory inventory ratio *365 days


number of days of receivables Account Receivable ratio *365 days
number of days of payables Payable ratio *365 days

Activity / Turnover Ratios

Inventory Ratio Average inventory /cost of sales times


Account Receivable Ratio average receivables /Sales times
Account payables Ratio average payables/Cost of sales times
Total asset turnover Sales / Total assets times
Fixed assets turnover Sales / Fixed Assets times

Gearing Ratio

Total debt to equity Raito Total debt / Total shareholders' Equity times
Interest coverage Ratio Earnings before interest and taxes / Interest times
AirBus Boeing
2020 2021 2022 2020 2021 2022

1.051042 1.05619 1.08322


AirBus
Fiscal year is January-December. All values EUR Millions. 2022 2021 2020
Cash & Short Term Investments 17,585 15,889 16,057
Cash Only 15,823 14,572 14,439
Cash & Short Term Investments Growth 10.67% -1.05% 38.23%

Cash & ST Investments / Total Assets 15.17% 13.99% 14.58%


Total Accounts Receivable 9,994 8,978 9,009
Accounts Receivables, Net 6,454 6,440 6,206
Accounts Receivables, Gross 6,834 6,801 6,206
Bad Debt/Doubtful Accounts -380 -361 -

Other Receivables 3,540 2,538 2,803


Accounts Receivable Growth 11.32% -0.34% -18.29%

Accounts Receivable Turnover 5.88 5.81 5.54


Inventories 32,202 28,538 30,401
Finished Goods 4,158 4,556 5,228
Work in Progress 19,255 17,542 18,730
Raw Materials 3,744 3,068 3,328
Progress Payments & Other 5,045 3,372 3,115
Other Current Assets 2,773 1,896 2,376
Prepaid Expenses 161 392 191
Miscellaneous Current Assets 2,612 1,504 2,185
Total Current Assets 62,554 55,301 57,843
Net Property, Plant & Equipment 16,505 16,536 16,674
Property, Plant & Equipment - Gross 41,269 42,270 41,852
Buildings 10,536 10,344 9,767
Machinery & Equipment 21,982 23,697 23,650
Construction in Progress 2,241 1,890 2,310
Leases 2,578 2,486 2,426
Other Property, Plant & Equipment 3,932 3,853 3,699
Accumulated Depreciation 24,764 25,734 25,178
Buildings 5,539 5,324 5,086
Machinery & Equipment 15,286 16,609 16,582
Other Property, Plant & Equipment 3,107 3,013 2,888
Total Investments and Advances 13,088 13,199 14,268
LT Investment - Affiliate Companies 2,067 1,672 1,578
Other Long-Term Investments 11,021 11,527 12,690
Long-Term Note Receivable 26 27 48
Intangible Assets 16,768 16,367 16,199
Net Goodwill 13,165 13,028 12,999
Net Other Intangibles 3,603 3,339 3,200
Other Assets 2,320 1,294 1,040
Deferred Charges 934 916 915
Tangible Other Assets 1,386 378 125
Total Assets 115,944 113,578 110,095
Assets - Total - Growth 2.08% 3.16% -3.77%

Asset Turnover - - -
Return On Average Assets - - -

Liabilities & Shareholders' Equity


All values EUR Millions. 2022 2021 2020
ST Debt & Current Portion LT Debt 2,142 1,946 3,013
Short Term Debt 1,900 1,701 2,753
Current Portion of Long Term Debt 242 245 260
Accounts Payable 13,261 9,693 8,722
Accounts Payable Growth 36.81% 11.13% -41.10%

Income Tax Payable 817 1,057 1,311


Other Current Liabilities 36,375 35,111 36,725
Miscellaneous Current Liabilities 36,375 35,111 36,725
Total Current Liabilities 52,595 47,807 49,771
Current Ratio 1.19 1.16 1.16
Quick Ratio 0.58 0.56 0.55
Cash Ratio 0.33 0.33 0.32
Long-Term Debt 10,631 13,094 14,082
Long-Term Debt excl. Capitalized Leases 9,139 11,603 12,544
Non-Convertible Debt 9,139 11,603 12,544
Provision for Risks & Charges 6,896 10,771 13,998
Deferred Taxes -4,519 -4,207 -3,572

Deferred Taxes - Credit 164 6,647 451


Deferred Taxes - Debit 4,683 10,854 4,023
Other Liabilities 28,959 22,043 21,625
Other Liabilities (excl. Deferred Income) 6,898 3,415 2,381
Deferred Income 22,061 18,628 19,244
Total Liabilities 99,245 100,362 99,927
Non-Equity Reserves 3,717 3,730 3,712
Total Liabilities / Total Assets 85.60% 88.36% 90.76%
Common Equity (Total) 12,950 9,466 6,445
Common Stock Par/Carry Value 789 787 785
Additional Paid-In Capital/Capital Surplus 3,837 3,712 3,599
Retained Earnings 13,408 6,834 250
Cumulative Translation Adjustment/Unrealized For. Exch. G 1,307 1,170 943
Unrealized Gain/Loss Marketable Securities -635 456 648

Other Appropriated Reserves -5,688 -3,448 262

Treasury Stock -68 -45 -42

Common Equity / Total Assets 11.17% 8.33% 5.85%


Total Shareholders' Equity 12,950 9,466 6,445
Total Shareholders' Equity / Total Assets 11.17% 8.33% 5.85%
Accumulated Minority Interest 32 20 11
Total Equity 12,982 9,486 6,456
Liabilities & Shareholders' Equity 115,944 113,578 110,095
Boeing
Fiscal year is January-December. All values U 2022 2021 2020 Profitability Ratios
Cash & Short Term Investments 17,220 16,244 25,590 ROCE
Cash Only 14,614 8,052 7,752 (Return
Gross profit
on Capital
Cash & Short Term Investments Growth 6.01% -36.52% 155.13% Net profit
Employed
)
Cash & ST Investments / Total Assets 12.56% 11.72% 16.82%
Total Accounts Receivable 11,305 11,378 10,051 Liquidity ratios
Accounts Receivables, Net 11,305 11,378 10,051
Accounts Receivables, Gross 11,421 11,768 10,495 Current Ratios
Bad Debt/Doubtful Accounts -116 -390 -444 Quick Ratios

Other Receivables -0.64% 13.20% -19.41% Operating Ratios


Accounts Receivable Growth 5.89 5.47 5.79
number of days of inv
Accounts Receivable Turnover 78,151 78,823 81,715 number of days of rec
Inventories 68,284 68,978 70,976 number of days of pa
Work in Progress 9,867 9,845 10,739
Activity / Turnover Ratios
Raw Materials 2,847 2,221 4,286
Other Current Assets 109,523 108,666 121,642 Inventory Ratio
Miscellaneous Current Assets 12,001 12,355 13,072 Account Receivable R
Total Current Assets 33,443 32,893 33,579 Account payables Rat
Net Property, Plant & Equipment 14,404 14,152 14,415 Total asset turnover
Property, Plant & Equipment - Gross 376 377 512 Fixed assets turnover
Buildings 15,844 15,692 16,060
Land & Improvements 1,368 1,235 1,340 Gearing Ratio
Machinery & Equipment 21,442 20,538 20,507
Construction in Progress - - - Total debt to equity R
Accumulated Depreciation 948 930 936 Interest coverage Rat
Total Investments and Advances 147 143 156
LT Investment - Affiliate Companies 1,450 1,695 1,936
Other Long-Term Investments 10,368 10,630 10,924
Long-Term Note Receivable 8,057 8,068 8,081
Intangible Assets 2,311 2,562 2,843
Net Goodwill - - -
Net Other Intangibles 2,600 4,056 3,384
Other Assets 137,100 138,552 152,136
Tangible Other Assets -1.05% -8.93% 13.85%
Total Assets
Assets - Total - Growth - - -
-
Asset Turnover
Return On Average Assets
Liabilities & Shareholders' Equity
All values USD Millions. 2022 2021 2020
ST Debt & Current Portion LT Debt 5,466 1,564 1,961
Short Term Debt 276 268 268
Current Portion of Long Term Debt 5,190 1,296 1,693
Accounts Payable 10,200 9,261 12,928
Accounts Payable Growth 10.14% -28.36% -16.88%

Income Tax Payable - 5 43


Other Current Liabilities - - -
Dividends Payable - - -
Accrued Payroll 6,351 6,573 7,121
Miscellaneous Current Liabilities 68,035 64,589 65,227
Total Current Liabilities 90,052 81,992 87,280
Current Ratio 1.22 1.33 1.39
Quick Ratio 0.35 0.36 0.46
Cash Ratio 0.19 0.2 0.29
Long-Term Debt 53,116 58,077 62,974
Long-Term Debt excl. Capitalized Leases 51,670 56,687 61,752
Non-Convertible Debt 51,670 56,687 61,752
Capitalized Lease Obligations 141 119 138
Provision for Risks & Charges 8,644 12,632 18,545
Deferred Taxes 167 141 924

Deferred Taxes - Credit 230 218 1,010


Deferred Taxes - Debit 63 77 86
Other Liabilities - - -
Other Liabilities (excl. Deferred Income) 906 479 402
Total Liabilities - - -
Total Liabilities / Total Assets 0.00% 0.00% 0.00%
Common Equity (Total) -15,883 -14,999 -18,316

Common Stock Par/Carry Value 5,061 5,061 5,061


Additional Paid-In Capital/Capital Surplus 9,947 9,052 7,787
Retained Earnings 29,473 34,408 38,610
Cumulative Translation Adjustment/Unrealized -167 -105 -30

Unrealized Gain/Loss Marketable Securities - 1 1


Other Appropriated Reserves -9,383 -11,555 -17,104

Treasury Stock -50,814 -51,861 -52,641


Common Equity / Total Assets -11.58% -10.83% -12.04%

Total Shareholders' Equity -15,883 -14,999 -18,316

Total Shareholders' Equity / Total Assets -11.58% -10.83% -12.04%

Accumulated Minority Interest 35 153 241


Total Equity -15,848 -14,846 -18,075

Liabilities & Shareholders' Equity 137,100 138,552 152,136


AirBus
Profitability Ratios 2020 2021 2022

Gross profit Gross profit /Sales *100 %


Net profit / Sales *100 %
Profit after tax/ total assets - current liabilities*100 %

Liquidity ratios

Current Ratios Current Assets/ Current Liabilities times


Quick Ratios Current Assets - inventory/ Current Liabilities times

Operating Ratios

number of days of invinventory ratio *365 days


number of days of recAccount Receivable ratio *365 days
number of days of paPayable ratio *365 days

Activity / Turnover Ratios

Inventory Ratio Average inventory /cost of sales times


Account Receivable Raverage receivables /Sales times
Account payables Rataverage payables/Cost of sales times
Total asset turnover Sales / Total assets times
Fixed assets turnover Sales / Fixed Assets times

Gearing Ratio

Total debt to equity RTotal debt / Total shareholders' Equity times


Interest coverage RatEarnings before interest and taxes / Interest times
Boeing
2020 2021 2022
Assets 2020 2021 2022
Non-Current Assets

Intangible Assets

Property Plant and Equiptment


Investment Property
Investments accounted for under the equity method
Other Invetments and other long term finanial assets
Non-Current contract assets
Non-Current other finanical assets
Deffered Tax Assets
Non-Current Securities

Total Non Current Assets € - € - € -

Current Assets

Inventories
Trade Receiveables
Current Portion of other long term Financial Assets
Current Contract Assets
Current other Assets
Current Tax Assets
Current Securities
Cash and Cash Equivilants

Total Current Assets € - € - € -

Equity and Liability


Equity attribute to equity owners of the parent

Capital Stock
Share Premium
Retained Earnings
Accumulated other Comprehensive Income
Treasury Shares

Total Equity attributable to equity owners of the parent€ - € - € -


Non-Controlling Intrests
Total Equity € - € - € -

Liabilities
Non-Current Liability

Non-current provisions
Long-term financing liabilities
Non-current contract liabilities
Non-current other financial liabilities
Non-current other liabilities
Deferred tax liabilities
Non-current deferred income

Total Non-Current Liabilities € - € - € -

Current Liability

Current provisions
Short-term financing liabilities
Trade liabilities
Current contract liabilities
Current other financial liabilities
Current other liabilities
Current tax liabilities
Current deferred income

Total Current Liabilities € - € - € -

Statement of Profit&Loss

Revenue
Cost of Sales

Gross Margin € - € - € -

Selling Expense
Administrative Expenses
Research and Development Expenses
Other Income
Other Expenses
Share of Profit from investment accounted for under
the equity method
Other income from investments

Profit (Loss) before financial result and income taxes € - € - € -


Interest income
Interest expense
Other financial result
Total financial result
Income Taxes

Profit(Loss) for the Period € 1,169.00 € 4,174.00 € 4,136.00


Profitability Ratios

Gross profit
Net profit
ROCE (Return on Capital
Employed)

Liquidity ratios

Current Ratios
Quick Ratios

Operating Ratios

number of days of inventory


number of days of receivables
number of days of payables

Activity / Turnover Ratios

Inventory Ratio
Account Receivable Ratio
Account payables Ratio
Total asset turnover
Fixed assets turnover

Gearing Ratio

Total debt to equity Raito


Interest coverage Ratio
2020 2021 2022

Gross profit /Sales *100 %


Net profit / Sales *100 %
Profit after tax/ total assets - current
liabilities*100 %

Current Assets/ Current Liabilities times


Current Assets - inventory/ Current Liabilities times

inventory ratio *365 days


Account Receivable ratio *365 days
Payable ratio *365 days

Average inventory /cost of sales times


average receivables /Sales times
average payables/Cost of sales times
Sales / Total assets times
Sales / Fixed Assets times

Total debt / Total shareholders' Equity times


Earnings before interest and taxes / Interest times
65

You might also like