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
Telstar Co. had severe financial difficulties and was considering the possibility of filing a bankruptcy petition. At that time, the company had the following assets (stated at net realizable value) and liabilities.
Assets (pledged against debts of $91,000) 150,800
Assets (pledged against debts of $169,000) 65,000
Other assets 104,000
Liabilities with priority 54,600
Unsecured creditors 60,000
A. Prepare a schedule to show the amount of total assets available to pay liabilities with priority and unsecured creditors
B. Prepare a schedule to show the amount of assets that are available for unsecured creditors after payment of liabilities with priority
C. Prepare a schedule to show the amount of total unsecured liabilities
D. Prepare a schedule…
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…
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
400
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 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_forwardtwo years ago a customer, GHI company, was approved for an unusally large credit sale of $5m. Recently the customer's business began to deteriorate due to the pandemic. To date it has paid only $2m against the order despite the fact that it has consumed all of the material purchased. The collections department has worked diligently to collet the remaining $3m without success. The GHI filed for bankruptcy this morning with essentially no assets to pay a large number of creditors. Evaluate the financial statement impact of the bankruptcy on the company. Assume our product cost is 40% of revenue and the bad debt reserve of $2m will be fully reestablished.arrow_forwardBelow is selected information for Cari Corp. and Nick, Inc. for fiscal 2014. Compute each company's Z-score and provide an analysis of whether either company is expected to go bankrupt in the near ------------- future. - -- . Cari Corp. $683,140 Nick, Inc. $488,974 Current assets Current liabilities 445,691 1,187,598 527,588 1,027,966 Total assets |Total liabilities 632,855 211,000 884,771 289,455 Shares outstanding Retained earnings Stock price per share 296,988 -25,412 $47.86 $9.56 Sales 1,254,110 288,977 855,741 18,569 Earnings before interest and taxesarrow_forward
- Ataway Company has severe financial difficulties and is considering filing a bankruptcy petition. At this time, it has the following assets and liabilities. The assets are stated at net realizable value. Assets (pledged against debts of $76,000) $128,000 Assets (pledged against debts of $142,000) 56,000 Other assets Liabilities with priority Other unsecured creditors 86,000 65,000 206,000 In a liquidation, how much money would be paid on the partially secured debt?arrow_forwardRistoni Company is in the process of emerging from a Chapter 11 bankruptcy. It will apply fresh start accounting as of December 31, 2017. The company currently has 30,000 shares of common stock outstanding with a $240,000 par value. As part of the reorganization, the owners will contribute 18,000 shares of this stock back to the company. A retained earnings deficit balance of $330,000 exists at the time of this reorganization.The company has the following asset accounts:The company’s liabilities will be settled as follows. Assume that all notes will be issued at reasonable interest rates.Accounts payable of $80,000 will be settled with a note for $5,000. These creditors will also get 1,000 shares of the stock contributed by the owners.Accrued expenses of $35,000 will be settled with a note for $4,000.• Note payable of $100,000 (due 2021) was fully secured and has not been renegotiated.• Note payable of $200,000 (due 2020) will be settled with a note for $50,000 and 10,000 shares of the…arrow_forwardRistoni Company is in the process of emerging from a Chapter 11 bankruptcy. It will apply fresh start accounting as of December 31, 2017. The company currently has 30,000 shares of common stock outstanding with a $240,000 par value. As part of the reorganization, the owners will contribute 18,000 shares of this stock back to the company. A retained earnings deficit balance of $330,000 exists at the time of this reorganization.The company has the following asset accounts: Book Value Fair value Accounts receivable $100000 $80000 Inventory 112000 90000 Land and buildings 420000 500000 Equipment 78000 65000 The company’s liabilities will be settled as follows. Assume that all notes will be issued at reasonable interest rates.∙ Accounts payable of $80,000 will be settled with a note for $5,000. These creditors will also get 1,000 shares of the stock contributed by the owners.∙ Accrued expenses of $35,000 will be settled with a note for $4,000. Note payable of…arrow_forward
- 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 Required: 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 Government claims to unpaid taxes Amounts $ 4,150 $ 7,700 19,525 4,150 5,930 8,250arrow_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_forwardPeltzer Manufacturing is experiencing financial difficulties. Rather than entering into a lengthy bankruptcy proceeding, the company has reached an agreement with its long-term creditors to restructure various loans. The restructured loans are described below.Loan A—This 12% debt has a principal balance of $4,000,000 and accrued interest of $80,000. Under the restructuring agreement, $500,000 of debt would be forgiven, and the balance of the amounts due would be refinanced at a rate of 10% with monthly installment payments of $50,000 and a term of eight years. Assets with a net realizable value of $2,500,000 would also be pledged as additional security against the restructured loan.Loan B—This debt has a principal balance of $1,000,000 and accrued interest of $25,000. Under the restructuring agreement, the accrued interest would be forgiven, and the principal amount would be exchanged for preferred stock with a par value of $500,000 and a fair value of $900,000.Loan C—This 12% debt has…arrow_forward
- Ataway Company has severe financial difficulties and is considering filing a bankruptcy petition. At this time, it has the following assets and liabilities. The assets are stated at net realizable value. In a liquidation, how much money would be paid on the partially secured debt?arrow_forwardhi 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_forwardAlpesharrow_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