​Financial Ratios Analysis for Delta Air Lines Case

timer Asked: Mar 2nd, 2018
account_balance_wallet $25

Question description

Financial Ratios Analysis for Delta Air Lines Case

Please check the financial ratios in excel and read the word file. Use the word file to help you completed this paper. I highlight the ratios you need to analyze in excel. You don’t need to analyze all ratios. You just need to use three significant ratios from my highlight to do the analysis. If the case has the competitor’s ratios, you need to compare the company ratio to its competitor’s ratios too. Remember that, all the ratios are relative. Find out the relationship of the three significant ratios you choose and combine the information from the case to analyze. For example, the net profit margin is decreasing from 2009 to 2013. You need to indicate what these % mean and you need to find out the reasonable reasons in the case to explain why the net profit margin is etc. Remember that, you only can use the information in the case, do not use any reasons that do not mention in the case. The case date is up to 2015. No introduction and conclusion require

Delta Air Lines cash and short-term investments reveivables inventories property depreciation asset a/p long term debt liabilities stockholders equity sale/turnover cost of good sold selling general and adm expense income taxes income before rxtraordinart items net income Net profit margin Return on Asset Return on Equity Debt to Asset Ratio Debt to Equity Ratio Equity Multiplier Asset Turnover 2013 5101 1360 327 20433 2924 43539 1249 15665 43294 245 28063 23481 2963 -344 -1237 -1237 2012 4019 1456 318 20307 4164 43188 1713 13179 42291 897 31755 24422 3145 15 593 593 2011 3920 1563 367 20223 5472 43499 1600 11847 44895 -1396 35115 28065 3310 -85 854 854 2010 3749 1693 1023 20713 6656 44550 2293 11082 46681 -2131 36670 29296 3182 16 1009 1009 2009 3926 1609 1063 21854 7792 52252 2300 9795 40609 11643 37773 29190 3123 -8013 10540 10540 -4.41% 1.87% 2.43% 2.75% 27.90% -2.84% 1.37% 1.96% 2.26% 20.17% -504.90% 66.11% -61.17% -47.35% 90.53% 99.44% 97.92% 103.21% 104.78% 77.72% 17671.02% 4714.72% -3215.97% -2190.57% 348.78% 17771.02% 4814.72% -3115.97% -2090.57% 448.78% 64.45% 73.53% 80.73% 82.31% 72.29%
MGMT 497 Some Notes on Financial Ratio Analysis Profitability Ratios (1) Gross Profit Margin (GPM) = Total Revenues  Cost of Sales  100% Total Revenues The gross margin indicates how much of every dollar of sales is left after paying out the costs of goods sold. The margin reflects the company’s pricing, cost structure and production efficiency. A healthy gross margin is important for keeping cash flow strong. This financial ratio is not available for some companies like banks and insurance companies. (2) Operating Profit Margin (OPM) = Operating Income  100 % Total Revenues Operating income (or operating profit), which equals gross profit minus operating expenses, tells us show how much income a company can generate from its own operations. It does not include income from investments in other businesses. Operating profit margin indicates how effective a company is at controlling the costs and expenses associated with their normal business operations. It shows how much a company makes (before interest and taxes) on each dollar of sales. A high operating margin gives management more flexibility in determining prices. (3) Net Profit Margin (NPM) = Net Income  100% Total Revenues This indicates how much a company actually keeps in earnings per dollar of sales after all expenses (including interest and taxes) are paid. It shows the company’s ability to sell a product or service at a low cost or a high price. NPM can be significantly different from OPM in size due to the impact of interest and tax expenses. (4) Return on Asset (ROA) = Net Income = Net Profit Margin  Asset Turnover Ratio Total Assets This is a measure of profit per dollar of assets, a common measure of managerial performance. It indicates how efficiently the firm uses its assets. Since the return on asset can be expressed as the net profit margin (which shows the level of operational efficiency) times the asset turnover ratio (which indicates the degree of asset use efficiency), the firm may increase ROA by expanding profit margins or increasing asset turnover. (5) Return on Equity (ROE) = Net Income = ROA  (1 + Debt-to-Equity Ratio) = ROA x Equity Shareholde rs' Equity Multiplier It measures how efficiently a company is using shareholders’ money to generate profits. It shows how efficiently the firm manages its overall operations (including operational efficiency, asset use efficiency, and use of financial leverage). Financial Leverage Ratios (for Debt Management) (6) Debt-to-Asset Ratio = Total Debt Total Assets The debt-to-asset ratio indicates the proportion of assets that are financed with debt (total liabilities that include all shortterm and long-term liabilities). It gauges the degree of the firm’s financing obligations and its ability to meet all these obligations. It also shows the firm’s ability to obtain additional financing for potential expansion and growth opportunities. (7) Total Debt Total Shareholde rs' Equity Equity Multiplier =Total Assets/Total Shareholders’ equity Debt-to-Equity Ratio = MGMT 497 Some Notes on Financial Ratio Analysis The debt-to-equity ratio indicates the relative use of debt and equity as sources of capital to finance the firm’s assets. (8) Interest Coverage Ratio = Income before Taxes  Interest Expense on Debt Interest Expense on Debt This ratio measures the company’s ability to generate enough income before interest and taxes (EBIT) – including both operating and non-operating income – to meet debt service payments. Liquidity and Efficiency Ratios (9) Current Ratio = Current Assets Current Liabilitie s The current ratio is one of the liquidity ratios for operation management. It indicates a firm’s ability to meet current obligations (including accounts payable, short-term notes payable, current portion of long-term debt, accrued income taxes, and other accrued expenses) with its current assets (including cash and cash equivalents, marketable securities, account receivables, prepaid expenses, and inventories). (10) Quick Ratio = Current Assets  Inventory Current Liabilitie s The quick ratio – also referred to as the acid test ratio – indicates a firm's ability to meet short-term obligations based on its most liquid assets without liquidating inventories, which are typically the least liquid of a firm’s current assets and may not be sold for their full price. (11) Inventory Turnover = Total Sales Inventory The inventory turnover ratio indicates the average number of times inventories are sold and re-stocked (or turned over) in a year. It gauges the firm’s ability to manage inventory efficiently. (12) Asset Turnover = Total Sales Total Asset The asset turnover ratio is one of the activity (or efficiency) ratios for asset use management. It indicates how effectively the firm is using its assets to generate sales. Illustrative Example Costco: Profitability Ratios Leverage Ratios Liquidity Ratios Efficiency Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Asset Return on Equity Debt-to-Asset Ratio Debt-to-Equity Ratio Interest Coverage Ratio Current Ratio Quick Ratio Inventory Turnover FY2011 10.69% 2.80% 1.68% 5.46% 11.63% 0.53 1.13 21.54 1.14 0.59 13.11 FY 2010 10.83% 2.72% 1.71% 5.47% 12.03% 0.55 1.20 19.50 1.16 0.60 13.53 FY 2009 10.81% 2.54% 1.55% 4.94% 10.84% 0.54 1.19 16.87 1.11 0.53 12.93 MGMT 497 Some Notes on Financial Ratio Analysis Asset Turnover 3.25 3.20 3.18

Tutor Answer

School: Purdue University



Financial analysis – Delta Case




Net margin
The net margin decreased from 27.90% in 2009 to 2.75% in 2010 financial year.
However, the net margin continued to decrease in 2011 and 2012 to close at -4.41% in 2013. As
such, in the 5-year period, the net margin had decreased by 32.31% from 2009 to 2013. On
average, Delta Airlines had a net profit margin of 6.11% indicat...

flag Report DMCA

The best tutor out there!!!!

Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors