Compute the value of altmans z-score for delta air lines

Assignment Help Risk Management

Reference no: EM13901653

COMPUTING AND INTERPRETING RISK AND BANKRUPTCY PREDICTION RATIOS FOR A FIRM THAT DECLARED BANKRUPTCY. Delta Air Lines is one of the largest airlines in the United States. It has operated on the verge of bankruptcy for several years. Exhibit 5.18 presents selected financial data for Delta Air Lines for each of the five years ending December 31, 2000, to December 31, 2004. Delta Air Lines filed for bankruptcy on September 14, 2005. We recommend that you create an Excel spreadsheet to compute the values of the ratios and the Altman's Z-score in Parts a and b, respectively.

Financial Data for Delta Air Lines
(amounts in millions except per share amounts) (Problem 5.15)

Financial Data for Delta Air Lines (amounts in millions except per share amounts) (Problem 1)
Year EndedDecember 31:	2004	2003	2002	2001	2000
Sales Net Income (Loss) before Interest and Taxes	$15,002 $(3,168)	$14,087 $ (432)	$13,866 $(1,337)	$13,879 $(1,365)	$15,657 $ 1,829
Interest Expense	$ 824	$ 757	$ 665	$ 499	$ 380
Net Income (Loss)	$(5,198)	$ (773)	$(1,272)	$(1,216)	$ 828
Current Assets	$ 3,606	$ 4,550	$ 3,902	$ 3,567	$ 3,205
Total Assets	$21,801	$25,939	$24,720	$23,605	$21,931
Current Liabilities	$ 5,941	$ 6,157	$ 6,455	$ 6,403	$ 5,245
Long-Term Debt	$12,507	$11,040	$ 9,576	$ 7,781	$ 5,797
Total Liabilities Retained Earnings (Deficit)	$27,320 $ (4,373)	$26,323 $ 844	$23,563 $ 1,639	$19,581 $ 2,930	$16,354 $ 4,176
Shareholders' Equity Cash Flow Provided by Operations	$ (5,519) $(1,123)	$ (384) $ 142	$ 1,157 $ 225	$ 4,024 $ 236	$ 5,577 $ 2,898
Outstanding	139.8	123.5	123.4	123.2	123.0
Market Price per Share	$ 7.48	$ 11.81	$ 12.10	$ 29.26	$ 50.18

Common Shares

Required

a. Compute the value of each the following risk ratios.

(1) Current Ratio (at the end of 2000-2004)

(2) Operating Cash Flow to Current Liabilities Ratio (for 2001-2004)

(3) Liabilities to Assets Ratio (at the end of 2000-2004)

(4) Long-Term Debt to Long-Term Capital Ratio (at the end of 2000-2004)

(5) Operating Cash Flow to Total Liabilities Ratio (for 2001-2004)

(6) Interest Coverage Ratio (for 2000-2004)

b. Compute the value of Altman's Z-score for Delta Air Lines for each year from 2000-2004.

c. Using the analyses in Parts a and b, discuss the most important factors that signaled the likelihood of bankruptcy of Delta Air Lines in 2005.

Reference no: EM13901653

Questions Cloud

How did the bankruptcy risk of circuit city change : How did the bankruptcy risk of Best Buy change between 2007 and 2008? Explain. How did the bankruptcy risk of Circuit City change between 2007 and 2008? Explain.

Is this change significant at the .05 level : The following table shows the number of defective, acceptable, and superior items in samples taken both before and after the introduction of a modification in the manufacturing process.

Compute descriptive statistics for each of the years : Compute descriptive statistics (5-number summary, mean, mode, range and standard deviation) for each of the years along with an explanation of what the descriptive statistics tell us about the different years. Are they continually growing, or is t..

Implement heuristic algorithm optimal ordering coordination : Compare your algorithm's performance with that of uncoordinated optimization of the EOQ of each individual item.

Compute the value of altmans z-score for delta air lines : Compute the value of Altman's Z-score for Delta Air Lines for each year from 2000-2004. Using analyses in Parts a and b, discuss most important factors that signaled the likelihood of bankruptcy of Delta Air Lines in 2005.

Find an equation for the parabola : A building has an entry with the shape of a parabolic arch 66 feet high and 46 feet wide at the base. Find an equation for the parabola if the vertex is placed at the origin of the coordinate system

What is quantity of trees she should purchase : If the purchase price for a tree is po = €30 which she then sells at ps = €50, assuming she cannot recover any value at all from any unsold tree, what is the quantity of trees she should purchase in order to maximize her expected pro..

Which firm appears to have more short-term liquidity risk : Compare the short-term liquidity ratios of Coca-Cola with those of PepsiCo discussed in the chapter. Which firm appears to have more short-term liquidity risk? Explain.

Why might level of value in altman model be more appropriate : Why might the levels of values in Altman's model be more appropriate for predicting bankruptcy and changes in values in Beneish's model be more appropriate for identifying earnings manipulation?

User Account

All Pages