Time-series True-False
1. analysis helps identify financial trends over time for a single company. 2. Managers' ability to freely choose among several alternative reporting methods makes it more difficult for a financial analyst to evaluate the activities and condition of a company. 3. GAAP filters data needed for a complete and faithful picture in the financial reports. 4. The first step to informed financial statement analysis is a careful examination of the auditor's opinion. 5. Common size income statements recast each statement item as a percent of total assets. 6. sales. Trend income statements recast each statement item as a percent of
estimate a company's default risk.
Multiple-Choice Questions
Select the best answer from those provided. 21. A type of analysis that helps identify similarities and differences across companies or business units at a single moment in time is a. trend analysis. b. common size statements. c. time-series analysis. d. cross-sectional analysis. 22. An analytical tool that measures a company's performance against a predetermined standard is a/an a. benchmark comparison analysis. b. profitability analysis. c. time-series analysis. d. common size statement. 23. a. b. c. d. The financial statement reporting "filter" is SEC reporting regulations that vary from GAAP for publicly traded companies. SEC required reporting regulations for all entities. management's manipulation of accounting data. management's discretion to choose alternative accounting procedures within GAAP.
7. Trend statements provide a clearer indication of growth and decline than do common size statements. 8. Asset turnover is defined as sales divided by total assets. 9. The statement of cash flow is the most useful source of information when analyzing a company's credit risk. 10. 11. The quick ratio measures the most immediate liquidity of a company. Activity ratios describe the profitability of a company.
12. The only way a company can increase its operating profits per asset dollar is to expand the amount of sales generated from each asset dollar. 13. The current asset turnover ratio helps the analyst identify efficiency gains from improved accounts receivable and inventory management. 14. Differences in the business strategies companies adopt give rise to economic differences that are reflected as differences in asset utilization only. 15. Credit risk analysis uses financial ratios that focus on an assessment of liquidity and solvency. 16. The financial structure leverage ratio measures the degree to which the company uses long-term debt to finance assets. 17. Financial leverage is beneficial when the company earns more than the incremental after-tax cost of debt. 18. Non-GAAP earnings like EBITDA ignore some real business costs and can result in an incomplete picture of a company's profitability. 19. Cash flows are more accurately measured with EBITDA and pro forma earnings. 20. The Z score model combines five financial ratios in a precise way to
24. Which one of the following help the analyst remove the effects of an information filter? a. Financial statements b. Form 10K c. Footnote disclosures d. Trend analysis Table 5-1 Manero Company included the following information in its annual report: 2006 2005 2004 Sales $178,400 $162,500 $155,500 Cost of goods sold 115,000 102,500 100,000 Operating expenses 50,000 50,000 45,000 Net income 13,400 10,000 10,500 25. Refer to Table 5-1. In a common size income statement for 2006, the
1
05-Financial Stratement Analysis
operating expenses are expressed as a. 28.0%. b. 30.3%. c. 43.8%. d. 100.0%. 26. Refer to Table 5-1. In a common size income statement for 2004, the cost of goods sold are expressed as a. b. c. d. 40.0%. 64.3%. 100.0%. 230.0%.
b. c. d.
total liabilities. total equity. total sales.
31. In a trend balance sheet, each balance sheet item is expressed as a percentage of a. b. c. d. total assets. the base year item. sales. equity.
27. Refer to Table 5-1. In a common size income statement for 2006, the cost of goods sold are expressed as a. b. c. d. 64.5%. 100.0%. 112.3%. 130.0%.
Table 5-2 Hansel Corporation's condensed balance sheets appear below: (Base Year) 2006 $55,000 495,000 20,000 $570,000 $40,000 395,000 135,000 $570,000
Assets Current assets Plant and equipment (net) Intangible assets (net) Total assets Liabilities & Stockholders' Equity Current liabilities Long-term liabilities Stockholders' equity Total liabilities & equity
2005 $56,500 410,000 27,500 $494,000 $ 35,000 310,000 149,000 $494,000
2004 $70,000 440,000 40,000 $550,000 $32,500 375,000 142,500 $550,000
28. Refer to Table 5-1. In a trend income statement for 2004, where 2004 is the base year, sales are expressed as a. b. c. d. 84.4%. 92.6%. 100.0%. 150.5%.
32. Refer to Table 5-2. In a common size balance sheet for 2005, Plant and equipment (net) is expressed as a. b. c. d. 83.0%. 83.6%. 91.1%. 100.0%.
29. Refer to Table 5-1. In a trend income statement for 2006, where 2004 is the base year, sales are expressed as a. b. c. d. 30. age of a. 87.2%. 100.0%. 114.7%. 148.7%. In a common size balance sheet, all items are expressed as a percenttotal assets.
33. Refer to Table 5-2. In a common size balance sheet for 2004, Total liabilities and equity are expressed as a. b. c. 89.9%. 96.5%. 100.0%.
2
05-Financial Stratement Analysis
d.
111.3%.
c. d.
profitability of sales. return on shareholders' investment.
34. Refer to Table 5-2. In a trend balance sheet for 2006, Long-term liabilities are expressed as a. 69.3%. b. 100.0%. c. 105.3%. d. 127.4%. 35. Refer to Table 5-2. In a trend balance sheet for 2005, Stockholders' equity is expressed as a. 10.2%. b. 100.0%. c. 104.6%. d. 110.4%. 36. Trend statements are better than common size statements at indicating which of the following? a. Stability b. Monetary changes c. Profitability d. Growth and decline 37. In a common size cash flow statement, all items are expressed as a percentage of a. sales. b. total assets. c. net income. d. total equity. 38. Net Operating Profit After Taxes (NOPAT) subtracts which one of the following groups of items from net income? a. Nonrecurring items, interest, and distortions related to accounting quality concerns b. Nonoperating items, after-tax interest, and distortions related to accounting quality concerns c. Nonoperating items, nonrecurring items, and after-tax interest d. Nonoperating and nonrecurring items, after-tax interest, and distortions related to accounting quality concerns 39. a. b. Return on Assets (ROA) measures a firm's cost effectiveness of its operating activities. profitable use of its assets.
40. Which one of the following successful strategies will increase the Return on Assets (ROA)? a. Increase the investment in assets used in the business b. Increase the operating profit margin c. Decrease sales volume d. Decrease the annual depreciation amounts of long-lived assets 41. The ratio that captures information about property, plant, and equipment utilization is a. current asset turnover. b. long-term asset turnover. c. asset turnover. d. property turnover. 42. Companies that consistently earn rates of return above the competitive floor in the industry are considered to possess a a. dominant market share. b. niche market. c. competitive advantage. d. monopolistic advantage. 43. a. b. c. d. Financial ratios used to determine credit risk include an assessment of liquidity and asset utilization. asset utilization and profitability. solvency and liquidity. profitability and solvency.
44. Post Corporation purchases from suppliers on net 30 day terms, has an Accounts Receivable Turnover of 8 times, and an Inventory Turnover of 12 times. Cash inflows and outflows are a. evenly matched. b. negatively mismatched by 60 days. c. positively mismatched by 30 days. d. negatively by mismatched 45 days. 45. by the a. b. c. The percentage of assets financed by long-term debt is best described debt to equity ratio. interest coverage ratio. long-term debt to asset ratio.
3
05-Financial Stratement Analysis
d.
long-term debt to tangible assets ratio.
a. b. c. d. 50. a. b. c. d. 51. a. b. c. d. 52. a. b. c. d. 53. a. b. c. d. 54. a. b. c. d.
1.7 times. 2.0 times. 2.2 times. 2.4 times. Refer to Table 5-3. The current ratio for 2006 is 1.4 to 1. 2.0 to 1. 2.7 to 1. 3.4 to 1. Refer to Table 5-3. The quick ratio for 2006 is 1.1 to 1. 1.4 to 1. 1.6 to 1. 2.8 to 1. Refer to Table 5-3. The accounts receivable turnover for 2006 is 2.0 times. 6.4 times. 6.6 times. 7.1 times. Refer to Table 5-3. The days receivable outstanding for 2006 is 51 days. 55 days. 60 days. 183 days. Refer to Table 5-3. The inventory turnover for 2006 is 2.61 times. 3.12 times. 3.45 times. 3.80 times.
46. When operating earnings and cash flows from operations are dissimilar, which of the following ratios is a better measure of long-term solvency? a. Interest coverage b. Long-term debt to asset c. Long-term debt to tangible assets d. Operating cash flow to total liabilities Table 5-3 Condensed financial data are presented below for the Phoenix Corporation: 2006 $267,500 312,500 670,000 50,000 825,000 252,500 77,500 1,640,000 982,500 10,000 77,500 127,500 71,000 (6,000) (62,500) 2005 $230,000 257,500 565,000 60,000 695,000 200,000 75,000
Accounts receivable Inventory Total current assets Intangible assets Total assets Current liabilities Long-term liabilities Sales Cost of goods sold Interest expense Income tax expense Net income Cash flow from operations Cash flow from investing activities Cash flow from financing activities Tax rate 30% 47. a. b. c. d. 48. a. b. c. d. 49.
Refer to Table 5-3. The return on assets ratio for 2006 is 16.3%. 16.9%. 17.7%. 18.2%. Refer to Table 5-3. The operating profit margin for 2006 is 7.9%. 8.2%. 8.5%. 16.3%. Refer to Table 5-3. The total assets turnover ratio for 2006 is
4
05-Financial Stratement Analysis
55. a. b. c. d. 56. a. b. c. d.
Refer to Table 5-3. The days inventory held for 2006 is 96 days. 106 days. 116 days. 138 days. Refer to Table 5-3. The long-term debt to assets for 2006 is 9.4%. 10.2%. 40.0%. 43.4%.
c. d.
41.4%. 43.4%.
61. Refer to Table 5-3. If there is no preferred stock, the common earnings leverage for 2006 is a. b. c. d. 92.0%. 94.8%. 100.0%. 104.7%.
62. Refer to Table 5-3. If there is no preferred stock, the financial structure leverage for 2006 is a. b. c. d. 0.6 times. 1.54 times. 1.66 times. 1.80 times.
57. Refer to Table 5-3. If the intangible assets in 2006 are $50,000, the long-term debt to tangible assets for 2006 is a. b. c. d. 58. a. b. c. d. 59. is a. b. c. d. 10.0%. 10.2%. 30.7%. 42.5%.
63. Refer to Table 5-3. The interest coverage for 2006 is 12.8 times. 13.8 times. 20.5 times. 21.5 times. Refer to Table 5-3. The operating cash flows to total liabilities for 2006 13.4%. 21.5%. 23.4%. 28.1%. a. b. c. d.
Pro forma earnings, cash earnings, and EBITDA all conform to GAAP standards. ignore some real costs of a business. are alternate terms for net income have concrete definitions.
64. Which of the following financial ratios is not a component of the Z score model? a. b. c. d. Working capital/total assets Sales/total assets Common stock/total assets Retained earnings/total assets
Explanation to Selected Multiple-Choice Questions
60. Refer to Table 5-3. If there is no preferred stock, the return on common equity for 2006 is a. b. 25.8%. 27.9%. 25. 26. 27. Operating expenses $50,000/Sales $178,500 = 28.0% Cost of goods sold $100,000/Sales $155,500 = 64.3% Cost of goods sold $115,000/Sales $178,400 = 64.5%
5
05-Financial Stratement Analysis
28. 29. 32. 33. 34. 35. 44. 47.
2004: $155,500/2004 $155,500 = 100% 2006: $178,400/2004 $155,500 = 114.7% Plant and equipment $410,000/Total assets $494,000 = 83.0% Total liabilities & equity $570,000/Total assets $570,000 = 100% L.T. liabilities 2006 $395,000/L.T. liabilities 2004 $375,000 = 105.3% S.E. 2005 $149,000/S.E. 2004 $142,500 = 104.6% Days: Purchases A/R Inventory = 30 45 30 = 45 days
55.
365 days = 106 days inventory turnover 3.45
OR
365 days average inventory ($312,500 + $257,500)/ 2 = 106 cost of goods sold $982,500
56.
net income $127,500 + after-tax interest expense $10,000 (1 - .30) = 17.5% average total assets ($825,000 + $695,000)/ 2
long-term debt $77,500 = 9.4% total assets $825,000 long-term debt $77,500 = 10.0% total assets $825,000 - intangible assets $50,000
48
net income $127,500 + after-tax interest expense $10,000 (1 - .30) = 8.2% sales $1,640,000
sales $1,640,000 = 2.2 times average total assets ($825,000 + $695,000)/ 2
57. 58
49.
net income $127,500 + int. exp. $10,000 + inc. taxes $77,500 = 215 times . interest expense $10,000
59. 50.
current assets $670,000 = 2.7 to 1 current liabilities $252,500 quick assets ($670,000 - $312,500) = 14 to 1 . current liabilities $252,500
operating cash flows $71,000 = 23.4% avg. current liab.($252,500 + $200,000)/ 2 + l.t. liab. $77,500
60.
51.
net income $127,500 = 27.9% average common equity ($495,000 + $420,000)/ 2
52.
sales $1,640,000 = 6.6 times average A/R ($267,500 + $230,000)/ 2 365 days = 55 days A/R turnover 6.6
OR
61.
net income $127,500 = 94.8% net income $127,500 + after-tax int. expense $10,000 (1 - .30)
62.
53.
average total assets ($825,000 + $695,000)/ 2 = 166 times . average common equity ($495,000 + $420,000)/ 2
365 days average A/R($267,500 + $230,000)/ 2 = 55 sales $1,640,000
54.
Essay and Computational Questions
65. List all GAAP and Non GAAP income measures you know
cost of goods sold $982,500 = 3.45 times average inventory ($312,500 + $257,500)/ 2
66. Reconcile EBITDA, Pro forma earnings and Analyst's operating earnings to GAAP net income
6
05-Financial Stratement Analysis
29. 67. a. b. c. d. List the pros and cons of each of the following earnings measures: GAAP net income EBITDA Pro forma earnings Analyst's operating earnings 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. 63.
M;(c) M;(a) M;(b) M;(a) M;(c) M;(c) M;(c) M;(d) E;(a) M;(d) M;(b) D;(b) M;(b) M;(c) M;(c) D;(d) E;(c) M;(d) M;(c) M;(b) M;(c) M;(c) M;(b) M;(c) M;(b) M;(c) M;(b) M;(a) M;(a) M;(d) M;(c) D;(b) D;(b) D;(c) M;(b)
Answers
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. E;True M;True M;True M;False M;False M;False M;True M;False E;True M;True E;False M;False M;True M;False M;True M;False M;True M;True M;False M;True E;(d) E;(a) M;(d) M;(c) M;(a) M;(b) M;(a) M;(c) 7
05-Financial Stratement Analysis
64.
M;(c)
65. Suggested Answer: GAAP net income, EBITDA, Pro forma earnings, Analyst's operating earnings 66 Suggested Answer: EBITDA: Add back income tax, depreciation and amortization expenses. Pro forma earnings, Analyst's operating earnings--not possible without exact detail of excluded items--there is no accepted definition. 67 Suggested Answer:
a. NI--Pros: components and guidelines are relatively clear (GAAP). Cons: subject to GAAP limitations (e.g., use of estimates). b. EBITDA--Pros: components and guidelines are relatively clear (adjusted GAAP). May provide a more comparable measure for companies with different capital structures or asset compositions. Cons: may ignore important information. c. Pro forma earnings--Pros: May allow management to convey relevant information. Cons: Subject to manipulation and opportunistic behavior (inclusion/exclusion of items). Components not always clear. d. Analyst's operating earnings--Pros: May convey relevant information. Cons: may not have a consistent definition across providers.
8
05-Financial Stratement Analysis