swot and pest analysis for Boeing and airbus and conclusion part.

Snake1256
RatioAnalysisassignment.xlsx
Home>Business & Finance homework help>Accounting homework help>swot and pest analysis for Boeing and airbus and conclusion part.

Sheet1

Boeing
2018 2017 2016
Liquidity Ratios
Current Ratio= Current Assets / Current Liabilities 1.0764799608 1.1412763905 1.2464195955
Cash Ratio = Cash and Cash equivalent/ Current Liabilities 0.1049638436 0.1338548923 0.2000438824
Acid test ratio= ( Current Assets- Inventories)/Current Liabilities 0.3096335335 0.3189100847 0.384748873
Leverage Ratios
Debt Ratio= Total Liabilities/Total assets 0.996506446 0.9847546323 0.9902552307
Debt to Equity= Total Liabilities/ Shareholder's equity 344.982300885 66.8170289855 109.0820073439
Interest coverage ratio= Operating income/ interest expenses 24.9326315789 28.0916666667 22.8366013072
Profitability Ratios
Return on asset ratio= Net income/ Total assets 0.0891282305 0.075274559 0.0559351978
Return on equity= Net income/ Shareholder's equity 30.8554572271 5.1074879227 6.1615667075
Gross Margin ratio= Gross profit/Net sales 0.1941815737 0.1850220733 0.1547659793
Airbus
2018 2017 2016
Liquidity Ratios
Current Ratio= Current Assets / Current Liabilities 0.9645971112 1.0006978617 0.9894870528
Cash Ratio = Cash and Cash equivalent/ Current Liabilities 0.2052610799 0.2593898184 0.2239822197
Acid test ratio= ( Current Assets- Inventories)/Current Liabilities 0.4399532787 0.4685872774 0.4658152826
Leverage Ratios
Debt Ratio= Total Liabilities/Total assets 0.9156322158 0.9018538315 0.9671384737
Debt to Equity= Total Liabilities/ Shareholder's equity 10.8472850679 9.1905959032 29.3904840033
Interest coverage ratio= Operating income/ interest expenses 7.5045454545 3.1470019342 -0.8218390805
Profitability Ratios
Return on asset ratio= Net income/ Total assets 0.0265108769 0.0215716909 0.0089532362
Return on equity= Net income/ Shareholder's equity 0.3140682847 0.2198324022 0.2720809407
Gross Margin ratio= Gross profit/Net sales 0.1405497041 0.1164481041 0.0790615941
Boeing V/S Airbus
Liquidity Ratios 2018 2018
Current Ratio= Current Assets / Current Liabilities 1.0764799608 0.9645971112
Cash Ratio = Cash and Cash equivalent/ Current Liabilities 0.1049638436 0.2052610799
Acid test ratio= ( Current Assets- Inventories)/Current Liabilities 0.3096335335 0.4399532787
Leverage Ratios
Debt Ratio= Total Liabilities/Total assets 0.996506446 0.9156322158
Debt to Equity= Total Liabilities/ Shareholder's equity 344.982300885 10.8472850679
Interest coverage ratio= Operating income/ interest expenses 24.9326315789 7.5045454545
Profitability Ratios
Return on asset ratio= Net income/ Total assets 0.0891282305 0.0265108769
Return on equity= Net income/ Shareholder's equity 30.8554572271 0.3140682847
Gross Margin ratio= Gross profit/Net sales 0.1941815737 0.1405497041