Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN: 9781285190907
Author: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 16PC
Delta Air Lines, Inc., 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 Requirements a and b, respectively.
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 Requirements a and b, discuss the most important factors that signaled the likelihood of bankruptcy of Delta Air Lines in 2005.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A fire has destroyed a large percentage of the financial records of the Inferno Company. You have the task of piecing together information in order to release afinancial report. You have found the return on equity to be 14.3 percent. Sales were $1,735,000, the total debt ratio was 0.35, and total debt was $648,000.
What is the Return on Assets?
Please help me answer questions 1-5 on the screenshot. In addition can you please help me find the total asset turn over that is not listed? Below are the financial statements. Thank you
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 500,000 shares of common stock were outstanding. The interest rate on the bonds, which were sold at their face value, was 10%. The income tax rate was 40% and the dividend per share of common stock was $0.40 this year. The market value of the company’s common stock at the end of the year was $29. All of the company’s sales are on account.
Weller CorporationComparative Balance Sheet(dollars in thousands)
This Year
Last Year
Assets
Current assets:
Cash
$
1,190
$
1,280
Accounts receivable, net
10,300
7,100
Inventory
13,400…
Miner Company is being forced into bankruptcy. The Company’s creditors and stockholders have requested an estimate of the results of liquidation of the Company. Miner’s trial balance follows:
Accounts
Debit
Credit
Cash
P6,000
Accounts receivable
63,000
Allowance for bad debts
P2,000
Notes receivable
50,000
Accrued interest on notes receivable
1,200
Inventory
60,000
Buildings
182,000
Accumulated depreciation-Buildings
63,000
Equipment
14,600
Accumulated depreciation-Equipment
1,400
Prepaid insurance
1,100
Goodwill
8,500
Accrued wages
6,000
Taxes payable
2,400
Accounts payable and other liabilities
170,000
Notes payable
80,000
Accrued interest payable
1,600
Common stock
110,000
Retained earnings (deficit)
50,000
Total
P436,400
P436,400
The assets are expected to bring cash on…
Chapter 5 Solutions
Financial Reporting, Financial Statement Analysis and Valuation
Ch. 5 - Prob. 1QECh. 5 - Prob. 2QECh. 5 - A firm has experienced an increasing current ratio...Ch. 5 - A firm has experienced a decrease in its current...Ch. 5 - Prob. 5QECh. 5 - A firm had the following values for the four debt...Ch. 5 - Prob. 7QECh. 5 - Prob. 8QECh. 5 - Prob. 9QECh. 5 - Prob. 10QE
Ch. 5 - Market equity beta measures the covariability of a...Ch. 5 - Altmans bankruptcy risk model utilizes the values...Ch. 5 - Calculating and Interpreting Risk Ratios. Refer to...Ch. 5 - Refer to the financial state-ment data for...Ch. 5 - Refer to the profitability ratios of Coca-Cola in...Ch. 5 - Delta Air Lines, Inc., is one of the largest...Ch. 5 - Prob. 17PCCh. 5 - Prob. 18PCCh. 5 - Prob. 19PCCh. 5 - Prob. 20PCCh. 5 - Prob. 21PCCh. 5 - Prob. 22PCCh. 5 - Compute the values of each of the ratios in...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Miner Company is being forced into bankruptcy. The Company's creditors and stockholders have requested an estimate of the results of liquidation of the Company. Miner's trial balance follows: Accounts Debit Credit Cash P6,000 Accounts receivable 63,000 Allowance for bad debts P2,000 Notes receivable 50,000 Accrued interest on notes receivable 1,200 Inventory Buildings Accumulated depreciation-Buildings Equipment Accumulated depreciation-Equipment Prepaid insurance 60,000 182,000 63,000 14,600 1,400 1,100 Goodwill 8,500 Accrued wages Taxes payable Accounts payable and other liabilities Notes payable Accrued interest payable Common stock 6,000 2,400 170,000 80,000 1,600 110,000 50,000 Retained earnings (deficit) Total P436,400 P436 400 The assets are expected to bring cash on conversion in the following amounts Accounts receivable P50,000 Notes receivable including P1,000 accrued interest 40,800 Building 75,000 Prepaid insurance 400arrow_forwardMiner Company is being forced into bankruptcy. The Company's creditors and stockholders have requested an estimate of the results of liquidation of the Company. Miner's trial balance follows: Accounts Cash Debit Credit P6,000 63,000 Accounts receivable Allowance for bad debts P2,000 Notes receivable 50,000 1,200 Accrued interest on notes receivable Inventory Buildings Accumulated depreciation-Buildings Equipment Accumulated depreciation-Equipment Prepaid insurance 60,000 182,000 63,000 14,600 1,400 1,100 Goodwill 8,500 Accrued wages 6,000 2,400 170,000 80,000 1,600 Taxes payable Accounts payable and other liabilities Notes payable Accrued interest payable Common stock 110,000 Retained earnings (deficit) 50,000 Total P436,400 P436,400 The assets are expected to bring cash on conversion in the following amounts Accounts receivable P50,000 40,800 Notes receivable including P1,000 accrued interest Building 75,000 Prepaid insurance 400arrow_forwardWhich of the following statements about WorldCom is true? a. WorldCom filed for Chapter 11 bankruptcy in 2002. b. They overreported the line costs by recording them as liabilities. c. It began in 1999 as Long Distance Discount Services, Inc. d. Five techniques were used to cook its books.arrow_forward
- please see attached filearrow_forwardXavier Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $27,200 in free cash. The following debts, totaling $48,050, remain: Government claims to unpaid taxes $ 8,000 Salary during last month owed to Mr. Key (not an officer) 19,825 Administrative expenses 4,450 Salary during last month owed to Ms. Rankin (not an officer) 7,225 Unsecured accounts payable 8,550 Indicate how much money will be paid to the creditor associated with each debt.arrow_forwardHolmes Corporation has filed a voluntary petition with the bankruptcy court in hopes of reorganizing. A statement of financial affairs has been prepared for the company showing these debts: Holmes has 10,000 shares of common stock outstanding with a par value of $5 per share. In addition, it is currently reporting a deficit balance of $132,000. Company officials have proposed the following reorganization plan: • The company’s assets have a total book value of $210,000, an amount considered to be equal to fair value. The reorganization value of the assets as a whole, though, is set at $225,000. • Employees will receive a one-year note in lieu of all salaries owed. Interest will be 10 percent, a normal rate for this type of liability. • The fully secured note will have all future interest dropped from a 15 percent rate, which is now unrealistic, to a 10 percent rate. • The partially secured note payable will be satisfied by signing a new 6-year $30,000 note paying 10 percent annual…arrow_forward
- hi Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $27,400 in free cash. The following debts, totaling $49,050, remain: Government claims to unpaid taxes $ 8,200 Salary during last month owed to Mr. Key(not an officer) 20,025 Administrative expenses 4,650 Salary during last month owed to Ms. Rankin (not an officer) 7,425 Unsecured accounts payable 8,750 Indicate how much money will be paid to the creditor associated with each debt.arrow_forwardXavier Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $25,200 in free cash. The following debts, totaling $38,050, remain: Government claims to unpaid taxes Salary during last month owed to Mr. Key (not an officer) Administrative expenses Salary during last month owed to Ms. Rankin (not an officer) Unsecured accounts payable $6,000 17,825 2,450 5,225 6,550 Indicate how much money will be paid to the creditor associated with each debt. (Be sure to list liabilities in the order of priority.) Administrative expenses Salary during last month owed to Mr. Key and Ms. Rankin Government claims to unpaid taxesarrow_forwardShi Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $27,500 in free cash. The following debts, totaling $49,550, remain: Government claims to unpaid taxes $ 8,300 Salary during last month owed to Mr. Key (not an officer) 20,125 Administrative expenses 4,750 Salary during last month owed to Ms. Rankin (not an officer) 5,960 Unsecured accounts payable 8,850 Required: Indicate how much money will be paid to the creditor associated with each debt.arrow_forward
- Shi Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $27,500 in free cash. The following debts, totaling $49,550, remain: Government claims to unpaid taxes $ 8,300 Salary during last month owed to Mr. Key (not an officer) 20,125 Administrative expenses 4,750 Salary during last month owed to Ms. Rankin (not an officer) 5,960 Unsecured accounts payable 8,850 Required: Indicate how much money will be paid to the creditor associated with each debt.arrow_forwardXavier Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $26,800 in free cash. The following debts, totaling $46,050, remain: $ 7,600 Government claims to unpaid taxes Salary during last month owed to Mr. Key (not an officer) Administrative expenses 19,425 4,050 Salary during last month owed to Ms. Rankin (not an officer) Unsecured accounts payable 6,825 8,150 Indicate how much money will be paid to the creditor associated with each debt. Types of Debts Amountsarrow_forwardShi Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $26,600 in free cash. The following debts, totaling $45,050, remain: Government claims to unpaid taxes Salary during last month owed to Mr. Key (not an officer) Administrative expenses Salary during last month owed to Ms. Rankin (not an officer) Unsecured accounts payable $ 7,400 19,225 3,850 Indicate how much money will be paid to the creditor associated with each debt. Types of Debts Administrative expenses Salary during last month owed to Mr. Key and Ms. Rankin 6,625 7,950 Answer is complete but not entirely correct. Amounts 3,850 $12.850 $ 3,716 $26,600 Government claims to unpaid taxesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:Cengage
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Business Its Legal Ethical & Global Environment
Accounting
ISBN:9781305224414
Author:JENNINGS
Publisher:Cengage
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License