Credit Risk Analysis and Interpretation 5e Full Test Bank - Financial Statement Analysis 5e Complete Test Bank by Easton. DOCX document preview.
Module 4
Credit Risk Analysis
and Interpretation
Learning Objectives – Coverage by question | |||||
True/False | Multiple Choice | Exercises | Problems | Essays | |
LO1 – Understand the demand for and supply of credit | 1-5 | 1, 2 | 1 | ||
LO2 – Explain the credit risk analysis process. | 6-8 | 3, 4, 6 | 2 | ||
LO3 – Compute and interpret credit risk measures. | 8-19, | 12-15 | 2-4 | ||
LO4 – Explain credit ratings and describe the credit rating process. | 6, 7 | 5 | |||
LO5 – Apply bankruptcy prediction models to evaluate bankruptcy risk. | 20-24 | 7-11, 16 | 5-7 |
Module 4: Credit Risk Analysis and Interpretation
Multiple Choice
Topic: Demand for Credit
LO: 1
1. Many companies have cyclical operating cash needs due to:
- Mergers and acquisitions
- The seasonality of sales
- Delays in customer payments
- Refinancing of debt
Topic: Demand for Credit
LO: 1
2. An example of a situation in which company needs credit for investing activities is:
- Mergers and acquisitions
- Seasonal sales patterns
- Start-up operating losses
- Refinancing of debt
Topic: Supply of Credit
LO: 1
3. A letter of credit:
- Ensures a company that funds will be available when needed
- Is analogous to a credit card that companies can draw on as needed
- Is a representation that a company has a high credit rating
- Provides a guarantee of payment from the buyer, reducing the credit risk to the seller
Topic: Supply of Credit
LO: 1
4. Commercial paper is issued with maturities that do not exceed 270 days because:
- Companies do not want to pay high interest rates.
- It exempts the borrowing from SEC regulation.
- Usually the collateral consists of short-term assets
- Companies use it to fund working capital needs.
Topic: Credit Risk Analysis Process
LO: 2
5. Expected credit loss is calculated as:
- Chance of default X Total Debt
- Chance of default X Z-Score
- Chance of default X Loss given default
- Chance of default X Market value of Equity
Topic: Credit Risk Analysis Process
LO: 2
6. The overarching purpose of credit risk analysis is to:
- Quantify potential credit losses
- Determine a company’s optimal capital structure
- Identify credit opportunities
- Provide information to banks about credit losses
Topic: Credit Risk Analysis Process
LO: 2
7. Which of the following is not one of Porter’s five forces that determine a company’s competitive intensity?
- Supplier power
- Threat of substitution
- Ability to obtain financing
- Threat of entry
Topic: Analyzing Credit Risk
LO: 3
8. Fey Company currently has a current ratio of 0.7. The company decides to borrow $5,000,000 from Huntington Bank for a period of nine months. After the borrowing Fey Company’s current ratio will be:
- Greater than 0.7
- 0.7
- Less than 0.7
- Unable to determine without more information
Wilmington Corporation Balance Sheet As of December 31, 2017 | ||
Dec. 31, 2017 | Dec. 31, 2016 | |
Current Assets | ||
Cash and cash equivalents | $ 576,843 | $ 305,088 |
Marketable securities | 166,106 | 187,064 |
Accounts receivable (net) | 258,387 | 289,100 |
Inventories | 424,493 | 391,135 |
Prepaid expenses | 55,369 | 25,509 |
Other current assets | 83,053 | 85,029 |
Total Current Assets | 1,564,251 | 1,282,925 |
Property, plant and equipment | 1,384,217 | 625,421 |
Long-term investment | 568,003 | 425,000 |
Total Assets | $3,516,471 | $2,333,346 |
Current Liabilities | ||
Short-term borrowings | $ 306,376 | $ 170,419 |
Current portion of long-term debt | 155,000 | 168,000 |
Accounts payable | 254,111 | 286,257 |
Accrued liabilities | 273,658 | 166,983 |
Income taxes payable | 97,735 | 178,911 |
Total Current Liabilities | 1,086,880 | 970,570 |
Long-term debt | 500,000 | 300,000 |
Deferred income taxes | 215,017 | 262,404 |
Total Liabilities | 1,801,897 | $1,532,974 |
Common stock | $ 425,250 | $ 125,000 |
Additional paid-in capital | 356,450 | 344,335 |
Retained earnings | 932,874 | 331,037 |
Total Stockholders' Equity | 1,714,574 | 800,372 |
Total Liabilities and Stockholders' Equity | $3,516,471 | $2,333,346 |
Selected Income Statement Data for the year ending December 31, 2017: | ||
Net sales | $4,885,340 | |
Cost of goods sold | (2,942,353) | |
Selling expenses | (884,685) | |
Operating income | 1,058,302 | |
Interest expense | (55,240) | |
Earnings before income taxes | 1,003,062 | |
Income tax expense | (401,225) | |
Net income | $ 601,837 | |
Selected Statement of Cash Flow Data for the year ending December 31, 2017: | ||
Cash flows from operations | $1,456,084 | |
Capital expenditures | $745,862 |
Topic: Analyzing Credit Risk
LO: 3
9. Wilmington Corporation’s current ratio in 2017 was:
- 0.92
- 1.44
- 0.69
- 2.02
Topic: Analyzing Credit Risk
LO: 3
10. Wilmington Corporation’s quick ratio in 2017 was:
- 0.92
- 0.81
- 1.09
- 1.44
Topic: Analyzing Credit Risk
LO: 3
11. Wilmington Corporation’s quick ratio changed by what percentage from 2016 to 2017?
- + 15.0%
- + 87.0%
- + 9.1%
- – 8.5%
Topic: Analyzing Credit Risk
LO: 3
12. Wilmington Corporation’s liabilities to equity ratio in 2017 was:
- 0.99
- 1.09
- 1.05
- 1.79
Topic: Analyzing Credit Risk
LO: 3
13. Wilmington Corporation’s total debt to equity ratio in 2017 was:
- 1.31
- 0.38
- 0.56
- 0.29
Topic: Analyzing Credit Risk
LO: 3
14. Wilmington Corporation’s times interest earned ratio in 2017 was:
- 18.15
- 20.57
- 10.89
- 19.16
Topic: Analyzing Credit Risk
LO: 3
15. Wilmington Corporation’s cash flow from operations to total debt ratio in 2017 was:
- 0.80
- 1.51
- 1.92
- 0.71
Topic: Analyzing Credit Risk
LO: 3
16. Wilmington Corporation’s free operating cash flow to total debt ratio in 2017 was:
- 1.57
- 0.80
- 0.74
- 1.92
Topic: Analyzing Credit Risk
LO: 3
17. Wilmington Corporation’s return on equity in 2017 was:
- 35.1%
- 20.6%
- 17.1%
- 47.9%
Topic: Analyzing Credit Risk
LO: 3
18. Wilmington Corporation’s return on assets in 2017 was:
- 35.1%
- 20.6%
- 17.1%
- 47.9%
Topic: Analyzing Credit Risk
LO: 3
19. Wilmington Corporation’s financial leverage in 2017 was:
- 2.33
- 0.94
- 1.75
- 0.43
Topic: Analyzing Credit Risk
LO: 3
20. What was Wilmington Corporation’s return on net operating assets (RNOA) in 2017? Assume a statutory tax rate of 37%.
- 20.6%
- 44.2%
- 67.5%
- 32.9%
Topic: Analyzing Credit Risk
LO: 3
21. What was Wilmington Corporation’s net operating profit margin (NOPM) in 2017? Assume a statutory tax rate of 37%.
- 32.8%
- 13.0%
- 20.5%
- 13.9%
Topic: Analyzing Credit Risk
LO: 3
22. Wilmington Corporation’s net operating assets (NOAT) in 2017 was:
- 0.19
- 3.58
- 0.72
- 5.18
Topic: Credit Limit
LO: 1, 2
23. A credit limit is:
- A company’s total debt
- The maximum that a company can borrow
- The maximum that a creditor will allow a customer to owe at any point in time
- The property that a company pledges to guarantee repayment
Topic: Covenants
LO: 2
24. Covenants represent:
- The property that a company pledges to guarantee repayment
- The maximum that a creditor will allow a customer to owe at any point in time
- Promises the company makes to the creditor
- Terms and conditions set forth in a lending agreement to reduce the probability of nonpayment
Topic: Bankruptcy Prediction Models
LO: 5
25. The variable Market Value of Equity divided by Total Liabilities in the Altman Z-Score measures which of the following concepts?
- Current level of profitability
- Current level of net operating assets
- Current level of leverage
- Current level of efficiency
Topic: Bankruptcy Prediction Models
LO: 5
26. Which of the following concepts is not captured by one of the variables in Altman’s Z-Score?
- Current level of profitability
- Current level of net operating assets
- Current level of liquidity
- Current level of efficiency
Topic: Bankruptcy Prediction Models
LO: 5
27. When considering the results of an Altman Z-Score analysis a score of 3.85 would suggest?
- The company is in financial distress and there is a high probability of bankruptcy in the short term future.
- The company is exposed to some risk of bankruptcy.
- The company is healthy and there is a low bankruptcy potential in the short-term.
- The company is healthy and there is a low bankruptcy potential in both the short and long-term.
Topic: Bankruptcy Prediction Models
LO: 5
28. The variable EBIT divided by Total Assets in the Altman Z-Score measures which of the following concepts?
- Current level of profitability
- Current level of leverage
- Current level of liquidity
- Current level of efficiency
Topic: Bankruptcy Prediction Models
LO: 5
29. When using Altman’s Z-Score a Type I error occurs when:
- The company’s Z-score indicates the company is healthy, and the company stays healthy.
- The company’s Z-score indicates the company is healthy, and the company goes bankrupt.
- The company’s Z-score indicates the company will go bankrupt, and the company stays healthy.
- The company’s Z-score indicates the company will go bankrupt, and the company stays bankrupt.
Topic: Bankruptcy Prediction Models
LO: 5
30. When using Altman’s Z-Score a Type II error occurs when:
- The company’s Z-score indicates the company is healthy, and the company stays healthy.
- The company’s Z-score indicates the company is healthy, and the company goes bankrupt.
- The company’s Z-score indicates the company will go bankrupt, and the company stays healthy.
- The company’s Z-score indicates the company will go bankrupt, and the company stays bankrupt.
Topic: Demand and Supply for Credit
LO: 1
1. Companies normally have a demand for credit due to the operating, investing and financing activities that they engage. For each activity provide a specific reason why a company would need credit.
Topic: Demand and Supply for Credit
LO: 1
2. Companies have many types of credit to access. Distinguish the differences between commercial paper and term loans.
Topic: Credit Risk Analysis Process
LO: 2
3. In the credit risk analysis process many parties assess the chance of default and loss given default. How do credit rating agencies methods differ from other parties?
Topic: Analyzing Credit Risk
LO: 2
4. When analyzing the chance of default many analysts use Porter’s Five Forces to assess broader business forces affecting a company in order to assess the company’s chance of default. What are five forces identified by Porter?
Topic: Credit Rating Process
LO: 4
5. Credit rating agencies provide ratings about a company’s ability to repay its obligations. While this is important information for creditors why should a company that is being rated care about its credit rating?
Topic: Analyzing Credit Risk
LO: 2
6. One way creditors attempt to minimize potential losses is by inserting covenants into the loan agreement. There are covenants that require borrowers take certain actions, covenants that restrict the borrower from taking certain actions and covenants that require the borrower to maintain specific financial ratios. For each of these types of covenants provide a specific example.
Topic: Bankruptcy Prediction Analysis
LO: 5
7. Below is selected information for Radek Corp. and Kitts, Inc. for fiscal 2017. Compute each company’s Z-score and provide an analysis of whether either company is expected to go bankrupt in the near future. (Round each computation to three decimal places.)
Radek Corp. | Kitts, Inc. | |
Current assets | $783,140 | $538,974 |
Current liabilities | 495,691 | 627,588 |
Total assets | 1,287,598 | 1,077,966 |
Total liabilities | 682,855 | 984,771 |
Shares outstanding | 211,000 | 289,455 |
Retained earnings | 346,988 | -75,412 |
Stock price per share | $42.86 | $8.00 |
Sales | 1,454,110 | 955,741 |
Earnings before interest and taxes | 338,977 | 43,569 |
Z-Score | Radek Corp. | Kitts, Inc. |
1.2 x (WC/TA) | 0.268 | -0.099 |
1.4 x (RE/TA) | 0.377 | -0.098 |
3.3 x (EBIT/TA) | 0.869 | 0.133 |
0.6 x (MVE/TL) | 7.946 | 1.411 |
0.99 x (Sales/TA) | 1.118 | 0.878 |
TOTAL Z-Score | 10.578 | 2.225 |
Working capital | $287,449 | -$88,614 |
MKT Value of Equity | $9,043,460 | $2,315,640 |
Topic: Bankruptcy Risk and Z-Score Analysis
LO: 5
8. Below is selected information for Innovative Components for fiscal 2017 and 2016. Compute the company’s Z-score for both years. Is the company’s bankruptcy risk increasing or decreasing over this period? (Round each computation to three decimal places.)
2017 | 2016 | |
Current ratio | 0.790 | 0.775 |
Working capital to total assets | -0.039 | -0.150 |
Retained earnings to total assets | -0.143 | -0.134 |
EBIT to total assets | 0.118 | 0.071 |
Market value of equity to total liabilities | 0.304 | 0.204 |
Sales to total assets | 0.922 | 0.838 |
Z-Score | 2017 | 2016 |
1.2 x (WC/TA) | -0.047 | -0.180 |
1.4 x (RE/TA) | -0.200 | -0.188 |
3.3 x (EBIT/TA) | 0.389 | 0.234 |
0.6 x (MVE/TL) | 0.182 | 0.122 |
0.99 x (Sales/TA) | 0.913 | 0.830 |
TOTAL Z-Score | 1.237 | 0.818 |
Topic: Bankruptcy Risk and Z-Score Analysis
LO: 5
9. Below is selected information for Butler Industries for fiscal 2017 and 2016. Compute the company’s Z-score for both years. Is the company’s bankruptcy risk increasing or decreasing over this period? (Round each computation to three decimal places.)
2017 | 2016 | |
Current ratio | 0.750 | 0.775 |
Working capital to total assets | -0.033 | -0.046 |
Retained earnings to total assets | -0.135 | -0.124 |
EBIT to total assets | 0.118 | 0.085 |
Market value of equity to total liabilities | 0.294 | 0.192 |
Sales to total assets | 0.920 | 0.819 |
Z-Score | 2017 | 2016 |
1.2 x (WC/TA) | -0.040 | -0.055 |
1.4 x (RE/TA) | -0.189 | -0.174 |
3.3 x (EBIT/TA) | 0.389 | 0.281 |
0.6 x (MVE/TL) | 0.176 | 0.115 |
0.99 x (Sales/TA) | 0.911 | 0.811 |
TOTAL Z-Score | 1.247 | 0.978 |
Topic: Bankruptcy Prediction Analysis
LO: 5
10. One method of assessing the likelihood that a company will go bankrupt is by computing its Z-score. Each variable in the Z-score relates to a measure of financial strength.
What are the five variables that comprise the Z-score and what measure of financial strength does each measure?
Topic: Bankruptcy Prediction Analysis
LO: 5
11. There are two types of errors that can arise when using the Z-score to assess the likelihood of bankruptcy. What are the two errors and what cost does each error create?
Topic: Compute and Interpret Liquidity, Solvency and Coverage Ratios
LO: 3
12. Below is selected balance sheet and income statement information from Fuller Enterprises.
2017 | 2016 | |
Current assets | $ 26,148 | $ 29,879 |
Current liabilities | 38,063 | 36,129 |
Total debt | 123,896 | 125,545 |
Total Liabilities | 206,493 | 209,242 |
Equity | 76,434 | 72,613 |
Earnings before interest and taxes | 27,777 | 27,476 |
Interest expense | 3,180 | 3,384 |
Net cash flow from operating activities | 18,812 | 18,620 |
- Compute the current ratio for each year and discuss any trend in liquidity. (Round to two decimal places.)
- Compute times interest earned, liabilities-to-equity, and cash from operations to total debt ratios for each year and discuss any trends for each. (Round to two decimal places.)
Topic: Compute and Interpret Liquidity, Solvency and Coverage Ratios
LO: 3
13. Below is selected balance sheet and income statement information from Pinto & Company.
2017 | 2016 | |
Current assets | $ 27,348 | $ 28,779 |
Current liabilities | 38,063 | 36,129 |
Total debt | 121,296 | 122,945 |
Total Liabilities | 202,160 | 204,908 |
Equity | 76,434 | 72,613 |
Earnings before interest and taxes | 27,847 | 27,416 |
Interest expense | 3,180 | 3,384 |
Net cash flow from operating activities | 23,312 | 22,120 |
- Compute the current ratio for each year and discuss any trend in liquidity. (Round to two decimal places.)
- Compute times interest earned, liabilities-to-equity, and cash from operations to total debt ratios for each year and discuss any trends for each. (Round two decimal places.)
Topic: Compute and Interpret Liquidity, Solvency and Coverage Ratios
LO: 3
14. Below is selected balance sheet and income statement information from Kerns Corporation.
(in millions) | 2017 | 2015 |
Cash Accounts receivable Current assets | $ 1,763.36 835.30 3,393.33 | $ 1,316.73 1,197.16 3,588.56 |
Current liabilities | 6,257.95 | 3,485.39 |
Long-term debt Short-term debt Total liabilities | 3,291.63 4,668.83 25,863.17 | 6,910.81 1,133.96 22,928.42 |
Interest expense | 1,438.29 | 1,666.90 |
Capital expenditures | 1,311.50 | 1,645.48 |
Equity | -7,152.90 | 4,687.67 |
Cash from operations | 295.98 | 121.89 |
Earnings before interest and taxes | 1,907.84 | 1,634.84 |
- Compute the following liquidity, solvency and coverage ratios for both years.
(Round each computation to two decimal places.)
- Current ratio
- Quick ratio
- Liabilities-to-equity
- Total debt-to-equity
- Times interest earned
- Cash from operations to total debt
- Free operating cash flow to total debt
- What is your overall assessment of the company’s credit risk? Explain. What differences do you observe between the two years?
Topic: Compute and Interpret Liquidity, Solvency and Coverage Ratios
LO: 3
15. Below is selected balance sheet and income statement information from Hudson & Company.
(in millions) | 2017 | 2015 |
Cash | $ 1,583.36 | $ 1,636.73 |
Accounts receivable | 835.30 | 1,197.16 |
Current assets | 3,018.33 | 4,013.56 |
Current liabilities | 6,257.95 | 3,485.39 |
Long-term debt | 3,611.63 | 17,620.81 |
Short-term debt | 4,668.83 | 1,133.96 |
Total liabilities | 26,463.17 | 23,318.42 |
Interest expense | 1,438.29 | 1,666.90 |
Capital expenditures | 1,211.50 | 1,645.48 |
Equity | -7,252.90 | 4,687.67 |
Cash from operations | 685.98 | 610.89 |
Earnings before interest and taxes | 2,002.84 | 1,594.84 |
- Compute the following liquidity, solvency and coverage ratios for both years.
(Round each computation to two decimal places.)
- Current ratio
- Quick ratio
- Liabilities-to-equity
- Total debt-to-equity
- Times interest earned
- Cash from operations to total debt
- Free operating cash flow to total debt
- What is your overall assessment of the company’s credit risk? Explain. What differences do you observe between the two years?
Topic: Bankruptcy Prediction Models
LO: 5
16. Wilmington Corporation Industries manufactures extreme weather survival equipment. Selected financial data for Wilmington Corporation is presented below.
As of | ||
Dec. 31, 2017 | Dec. 31, 2016 | |
Current Assets | ||
Cash and cash equivalents | $ 576,843 | $ 305,088 |
Marketable securities | 166,106 | 187,064 |
Accounts receivable (net) | 258,387 | 289,100 |
Inventories | 424,493 | 391,135 |
Prepaid expenses | 55,369 | 25,509 |
Other current assets | 83,053 | 85,029 |
Total Current Assets | 1,564,251 | 1,282,925 |
Property, plant and equipment | 1,384,217 | 625,421 |
Long-term investment | 568,003 | 425,000 |
Total Assets | $3,516,471 | $2,333,346 |
Current Liabilities | ||
Short-term borrowings | $ 306,376 | $ 170,419 |
Current portion of long-term debt | 155,000 | 168,000 |
Accounts payable | 254,111 | 286,257 |
Accrued liabilities | 273,658 | 166,983 |
Income taxes payable | 97,735 | 178,911 |
Total Current Liabilities | 1,086,880 | 970,570 |
Long-term debt | 500,000 | 300,000 |
Deferred income taxes | 215,017 | 262,404 |
Total Liabilities | 1,801,897 | $1,532,974 |
Common stock | $ 425,250 | $ 125,000 |
Additional paid-in capital | 356,450 | 344,335 |
Retained earnings | 932,874 | 331,037 |
Total Stockholders' Equity | 1,714,574 | 800,372 |
Total Liabilities and Stockholders' Equity | $3,516,471 | $2,333,346 |
Continued next page
Selected financial data for Wilmington Corporation continued:
Selected Income Statement Data – for the year ending December 31, 2017: | |||
Net sales | $4,885,340 | ||
Cost of goods sold | (2,942,353) | ||
Selling expenses | (884,685) | ||
Operating income | 1,058,302 | ||
Interest expense | (55,240) | ||
Earnings before income taxes | 1,003,062 | ||
Income tax expense | (401,225) | ||
Net income | $ 601,837 | ||
Selected Statement of Cash Flow Data – for the year ending December 31, 2017: | |||
Cash flows from operations | $1,456,084 | ||
Capital expenditures | $745,862 |
Assuming that Wilmington Corporation’s market value of equity at the end of 2017 is $27 million, calculate Wilmington Corporation’s Z-score?
WC/TA | RE/TA | EBIT/TA | MV/TL | Sales/TA | |
Altman's Z Variable* | 0.135753 | 0.265287 | 0.300956 | 14.984208 | 1.389274 |
FACTOR | x 1.2 | x 1.4 | x 3.3 | x 0.6 | x 0.99 |
Factor x Variable | 0.162904 | 0.371402 | 0.993155 | 8.990525 | 1.375381 |
* | Altman’s Z Variable | ||
WC / TA | $477,371 / $3,516,471 | = 0.135753 | |
RE / TA | $932,874 / $3,516,471 | = 0.265287 | |
EBIT / TA | $1,058,302 / $3,516,471 | = 0.300956 | |
MV / TL | $27,000,000 / $1,801,897 | = 14.984208 | |
Sales / TA | $4,885,340 / $3,516,471 | = 1.389274 |
Topic: Demand and Supply for Credit
LO: 1
- Companies have many types of credit to access. For each of the following terms provide a concise definition:
- Line of credit
- Letter of credit
- Revolving credit line
Topic: Credit Risk Analysis Process
LO: 2, 3
- When assessing a company’s chance of default analysts normally try to predict the company’s future performance and cash flow in order to determine the likelihood the company will be able to repay the loan.
What are the four steps that an analyst would take to determine a company’s chance of default?
Topic: Credit Risk Analysis Process
LO: 3
3. Refer to the fiscal 2017 income statement and balance sheet of Mullen, Inc. provided below:
Mullen, Inc. Balance Sheet | |||
As of December 31, | 2017 | 2016 | |
Assets: | |||
Cash and cash equivalents | $ 454,000 | $ 374,585 | |
Accounts receivable | 595,241 | 419,546 | |
Inventory | 518,543 | 548,521 | |
Current Assets | 1,567,784 | 1,342,652 | |
Property, plant and equipment | 1,085,741 | 924,652 | |
Less: Accumulated depreciation | (388,139) | (297,504) | |
Property, plant and equipment-net | 697,602 | 627,148 | |
Intangible assets | 748,545 | 698,545 | |
Total assets | $3,013,931 | $2,668,345 | |
Liabilities | |||
Accounts payable | $ 452,484 | $ 475,152 | |
Accrued expenses | 451,421 | 373,650 | |
Self-insurance liabilities | 255,854 | 179,652 | |
Income tax payable | 295,877 |
| 221,236 |
Current Liabilities | 1,455,636 | 1,249,690 | |
Long-term note payable | 710,622 | 655,270 | |
Total Liabilities | 2,166,258 | 1,904,960 | |
Stockholders’ Equity: | |||
Common stock | 51,200 | 51,200 | |
Capital in excess of par value | 458,000 | 458,000 | |
Retained earnings | 338,473 | 254,185 | |
Total Stockholders’ Equity | 847,673 | 763,385 | |
Total liabilities and stockholders’ equity | $3,013,931 | $2,668,345 |
Continued next page
Mullen, Inc. Income Statement For the year ended December 31, 2017 | |||
Revenues | $2,456,852 | ||
Cost of goods sold | 1,523,248 | ||
Gross profit | $933,604 | ||
Operating expenses | |||
Depreciation expense | 90,635 | ||
Salary expense | 270,254 | ||
Selling expense | 233,401 | ||
Administrative expense | 81,076 | ||
Interest expense | 61,200 | ||
Total operating expenses | 736,566 | ||
Income from operations | 197,038 | ||
Income tax expense | 59,111 | ||
Net income | $137,927 | ||
Dividends paid to common shareholders | $ 53,639 |
Required: Compute the following liquidity, solvency and coverage ratios for 2017 and 2016 for Mullen, Inc.:
- Current ratio
- Quick ratio
- Liabilities to equity ratio
- Total debt-to-equity ratio
- Times interest earned ratio (2017 only)
2017 | 2016 | |||
Current ratio | $1,567,784 / $1,455,636 | 1.08 | $1,342,652 / $1,249,690 | 1.07 |
Quick ratio | $1,049,241 / $1,455,636 | 0.72 | $794,131/$1,249,690 | 0.64 |
Liabilities to equity ratio | $2,166,258 / $847,673 | 2.56 | $1,904,960 / $763,385 | 2.50 |
Total debt-to-equity ratio | $710,622 / $847,673 | 0.84 | $655,270 / $763,385 | 0.86 |
Times interest earned ratio | ($197,038 + $61,200) / $61,200 | 4.22 | N/A |
Topic: Analyzing Credit Risk
LO: 3
4. Selected balance sheet and income statement information for Brighton Homes, a residential home builder, follows (all amounts in millions):
2017 | 2016 | 2015 | |
Current assets | $7,610.45 | $8,232.02 | $8,691.30 |
Inventory | 5,127.48 | 6,572.65 | 7,095.70 |
Total assets | 10,186.84 | 10,820.32 | 11,183.54 |
Current liabilities | 2,211.28 | 2,419.23 | 2,812.11 |
Total debt | 2,008.16 | 1,917.81 | 2,066.42 |
Total liabilities | 5,549.18 | 5,893.08 | 5,967.61 |
Shares outstanding | 158.88 | 157.01 | 153.90 |
Shareholders' equity | 4,637.66 | 4,927.24 | 5,215.93 |
Interest expense | 14.91 | 20.05 | 22.80 |
Earnings before interest and taxes | 200.53 | 314.10 | 1,425.59 |
Net cash flow from operating activities | 530.47 | 424.09 | 534.70 |
Required:
a. Compute the current ratio for each year and discuss any trend in liquidity. What additional information about the numbers might be useful in helping you assess liquidity?
b. Brighton Homes largest single current asset is its inventory of developed and undeveloped land. Does this change your conclusion about liquidity?
c. Compute times interest earned, liabilities to equity and cash from operations to total debt for each year and discuss any trends for each ratio.
2017 | 2016 | 2015 | |||
Current ratio | $7,610.45/$2,211.28 = 3.44 | $8,232.02/$2,419.23 = 3.40 | $8,691.30/$2,812.11 = 3.09 | ||
Times interest earned | $200.53/$14.91 = 13.45 | $314.10/$20.05 = 15.67 | $1,425.59/$22.80 = 62.53 | ||
Liabilities to equity | $5,549.18/$4,637.66 =1.20 | $5,893.08/$4,927.24 = 1.20 | $5,967.61.$5,215.93 = 1.14 | ||
CFO to total debt | $530.47/$2,008.16 =0.26 | $424.09/$1,917.81 = 0.22 | $534.70/$2,066.42 = 0.26 |
Topic: Predicting Bankruptcy Risk
LO: 5
5. Following is information concerning Howell Company (all amounts in millions):
2017 | 2016 | 2015 | |
Current assets | $7,110.45 | $7,732.02 | $8,191.30 |
Current liabilities | 2,211.28 | 2,419.23 | 2,812.11 |
Total assets | 8,086.84 | 8,720.32 | 9,083.54 |
Total liabilities | 4,849.18 | 5,193.08 | 5,667.61 |
Shares outstanding | 158.88 | 157.01 | 153.90 |
Retained earnings | 3,503.11 | 3,468.93 | 3,363.27 |
Stock price per share | 20.15 | 24.12 | 30.20 |
Sales | 3,858.21 | 5,646.98 | 7,123.45 |
Earnings before interest and taxes | 108.53 | 553.10 | 1,552.59 |
Required: Compute and compare the Altman Z-score for the three years provided, what trend appears? Is Howell Company more or less likely to go bankrupt given the Z-score in 2015 or 2017?
Z-Score | 2017 | 2016 | 2015 |
1.2 x (WC/TA) | 0.727 | 0.731 | 0.711 |
1.4 x (RE/TA) | 0.606 | 0.557 | 0.518 |
3.3 x (EBIT/TA) | 0.044 | 0.209 | 0.564 |
0.6 x (MVE/TL) | 0.396 | 0.438 | 0.492 |
0.99 x (Sales/TA) | 0.472 | 0.641 | 0.776 |
TOTAL Z-Score | 2.245 | 2.576 | 3.061 |
Working capital | $4,899.17 | $5,312.79 | $5,379.19 |
MKT Value of Equity | 3,201.43 | 3,787.08 | 4,647.78 |
Topic: Compute and Interpret Z-Scores
LO: 5
6. Selected balance sheet and income statement information for Camden Corporation follows. As of December 31, 2017 and 2016, there were approximately 434,264,432 and 440,445,630 shares outstanding. The company’s stock closed at $63.63 on December 31, 2017 and $55.55 on December 31, 2016. Dividends paid (in millions) were $405 and $462 in 2016 and 2017, respectively.
Income Statement | |||||||
Year Ended December 31 (In millions) |
| 2017 |
| 2016 | |||
Net sales | |||||||
Products | $ 31,518 | $ 30,202 | |||||
Service | 5,695 | 5,324 | |||||
37,213 | 35,526 | ||||||
Cost of sales | |||||||
Products | 28,800 | 27,879 | |||||
Service | 5,073 | 4,765 | |||||
Unallocated corporate costs | 803 | 914 | |||||
34,676 | 33,558 | ||||||
2,537 | 1,968 | ||||||
Other income and (expenses), net | 449 | 121 | |||||
Operating profit | 2,986 | 2,089 | |||||
Interest expense | 370 | 425 | |||||
Earnings before taxes | 2,616 | 1,664 | |||||
Income tax expense | 791 | 398 | |||||
Net earnings | $ 1,825 | $ 1,266 | |||||
Balance Sheet | ||||||
December 31 (In millions) |
| 2017 |
| 2016 | ||
Assets | ||||||
Cash and cash equivalents | $ 4,244 | $ 3,060 | ||||
Short-term investments | 429 | 396 | ||||
Receivables | 4,579 | 4,094 | ||||
Inventories | 1,921 | 1,864 | ||||
Deferred income taxes | 861 | 982 | ||||
Other current assets | 495 | 557 | ||||
Total current assets | 12,529 | 10,953 | ||||
Property, plant and equipment, net | 3,924 | 3,599 | ||||
Investments in equity securities | 196 | 812 | ||||
Goodwill | 10,047 | 9,492 | ||||
Purchased intangibles, net | 560 | 672 | ||||
Prepaid pension asset | 1,360 | 1,030 | ||||
Other assets | 2,728 | 2,596 | ||||
Total assets | $ 31,344 | $ 29,154 |
Table continued next page
Table continued
Balance Sheet—continued | |||||
December 31 (In millions) |
| 2017 |
| 2016 | |
Liabilities and stockholders' equity | |||||
Accounts payable | $ 1,998 | $ 1,726 | |||
Customer advances and amounts in excess of costs incurred | 4,331 | 4,028 | |||
Salaries, benefits and payroll taxes | 1,475 | 1,346 | |||
Current maturities of long-term debt | 202 | 15 | |||
Other current liabilities | 1,422 | 1,451 | |||
Total current liabilities | 9,428 | 8,566 | |||
Long-term debt | 6,284 | 6,604 | |||
Accrued pension liabilities | 2,097 | 1,660 | |||
Other postretirement benefit liabilities | 1,277 | 1,236 | |||
Other liabilities | 2,291 | 1,967 | |||
Total liabilities | 21,377 | 20,033 | |||
Stockholders' equity | |||||
Common stock, $1 par value per share | 432 | 438 | |||
Additional paid-in capital | 1,724 | 2,223 | |||
Retained earnings | 9,378 | 8,015 | |||
Accumulated other comprehensive loss | (1,553) | (1,532) | |||
Other | (14) | (23) | |||
Total stockholders' equity | 9,967 | 9,121 | |||
Total liabilities and stockholders' equity | $ 31,344 | $ 29,154 |
Required:
a. Compute and compare the Altman Z-scores for both years. What explains the apparent trend?
b. Is the company more likely to go bankrupt given the Z-score in 2017 compared to 2016? Explain.
Z-Score | 2017 | 2016 |
1.2 x (WC/TA) | 0.118721 | 0.098251 |
1.4 x (RE/TA) | 0.418874 | 0.384887 |
3.3 x (EBIT/TA) | 0.314376 | 0.236458 |
0.6 x (MVE/TL) | 0.775569 | 0.732794 |
0.99 x (Sales/TA) | 1.175372 | 1.206378 |
TOTAL Z-Score | 2.802912 | 2.658768 |
Working capital | $3,101 | $2,387 |
MKT Value of Equity | 27,632.2458 | 24,466.7547 |
Topic: Compute and Interpret Z-Scores
LO: 5
7. Selected balance sheet and income statement information for Aiello, Inc. follows. As of December 31, 2017 and 2016, there were approximately 525.5 million and 517.5 million shares outstanding. The company’s stock closed at $73.79 on December 31, 2017 and $62.84 on December 31, 2016. Dividends paid (in millions) were $19,668 and $23,251 in 2016 and 2017, respectively.
Income Statement | ||||||
Year Ended December 31 (In millions) | 2017 |
| 2016 | |||
Net sales | ||||||
Products | $94,078 | $89,066 | ||||
Service | 28,974 | 23,732 | ||||
123,052 | 112,798 | |||||
Cost of sales | ||||||
Products | 58,789 | 55,981 | ||||
Service | 11,589 | 10,873 | ||||
70,378 | 66,854 | |||||
Gross Profit | 52,674 | 45,944 | ||||
Other income and (expenses), net | 1,078 | 788 | ||||
Operating profit | 53,752 | 46,732 | ||||
Interest expense | 740 | 630 | ||||
Earnings before taxes | 53,012 | 46,102 | ||||
Income tax expense | 7,951 | 7,078 | ||||
Net earnings | $45,061 | $39,024 |
Balance Sheet | ||||||
December 31 (In millions) |
| 2017 |
| 2016 | ||
Assets | ||||||
Cash and cash equivalents | $ 16,976 | $ 13,240 | ||||
Short-term investments | 6,716 | 3,584 | ||||
Receivables | 18,316 | 16,376 | ||||
Inventories | 10,684 | 8,456 | ||||
Deferred income taxes | 6,444 | 4,928 | ||||
Other current assets | 4,980 | 3,228 | ||||
Total current assets | 64,116 | 49,812 | ||||
Property, plant and equipment, net | 17,696 | 15,396 | ||||
Investments in equity securities | 5,846 | 3,248 | ||||
Goodwill |
| 27,788 |
| 25,568 | ||
Purchased intangibles, net | 2,240 | 2,688 | ||||
Prepaid pension asset | 6,440 | 4,120 | ||||
Other assets | 13,076 | 11,252 | ||||
Total assets | $137,202 | $112,084 |
Table continued next page
Table continued
Balance Sheet—continued | ||||||||
December 31 (In millions) |
| 2017 |
| 2016 | ||||
Liabilities and stockholders' equity | ||||||||
Accounts payable | $ 7,992 | $ 6,904 | ||||||
Customer advances | 17,324 | 16,112 | ||||||
Salaries, benefits and payroll taxes | 5,900 | 5,384 | ||||||
Current maturities of long-term debt | 808 | 60 | ||||||
Other current liabilities | 5,688 | 5,804 | ||||||
Total current liabilities | 37,712 | 34,264 | ||||||
Long-term debt | 25,136 | 26,416 | ||||||
Accrued pension liabilities | 8,388 | 6,640 | ||||||
Other postretirement benefit liabilities | 5,108 | 4,944 | ||||||
Other liabilities | 9,164 | 7,868 | ||||||
Total liabilities | 85,508 | 80,132 | ||||||
Stockholders' equity | ||||||||
Common stock, $1 par value per share | 1,728 | 1,752 | ||||||
Additional paid-in capital | 6,896 | 8,892 | ||||||
Retained earnings | 49,338 | 27,528 | ||||||
Accumulated other comprehensive loss | (6,212) | (6,128) | ||||||
Other |
| (56) | (92) | |||||
Total stockholders' equity | 51,694 | 31,952 | ||||||
Total liabilities and stockholders' equity | $137,202 | $112,084 |
Required:
a. Compute and compare the Altman Z-scores for both years. What explains the apparent trend?
b. Is the company more likely to go bankrupt given the Z-score in 2017 compared to 2016? Explain.
Z-Score | 2017 | 2016 |
1.2 x (WC/TA) | 0.230935 | 0.166461 |
1.4 x (RE/TA) | 0.503442 | 0.343842 |
3.3 x (EBIT/TA) | 1.292850 | 1.375893 |
0.6 x (MVE/TL) | 0.272091 | 0.243496 |
0.99 x (Sales/TA) | 0.887899 | 0.996307 |
TOTAL Z-Score | 3.187217 | 3.125999 |
Working capital | $26,404 | $15,548 |
MKT Value of Equity | $38,776.645 | $32,519.700 |
Document Information
Connected Book
Explore recommendations drawn directly from what you're reading
Module 2 Review of Business Activities and Financial Statements
DOCX Ch. All in one
Module 3 Profitability Analysis and Interpretation
DOCX Ch. All in one
Module 4 Credit Risk Analysis and Interpretation
DOCX Ch. All in one Current
Module 5 Revenue Recognition and Operating Income
DOCX Ch. All in one
Module 6 Asset Recognition and Operating Assets
DOCX Ch. All in one