18.8: Exercises- Unit 18
- Page ID
- 26301
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)QUESTIONS, EXERCISES AND PROBLEMS
➢ Through the use of turnover rates, explain why a firm might seek to increase the volume of its sales even though such an increase can be secured only at reduced prices.
➢ Indicate which of the relationships illustrated in the chapter would be best to judge:
- The short-term debt-paying ability of the firm.
- The overall efficiency of the firm without regard to the sources of assets.
- The return to owners (stockholders) of a corporation.
- The safety of long-term creditors’ interest.
- The safety of preferred stockholders’ dividends.
➢ Indicate how each of the following ratios or measures is calculated:
- Payout ratio.
- Earnings per share of common stock.
- Price-earnings ratio.
- Earnings yield on common stock.
- Dividend yield on preferred stock.
- Times interest earned.
- Times preferred dividends earned.
- Return on average common stockholders’ equity.
- Cash flow margin.
➢ How is the rate of return on operating assets determined? Is it possible for two companies with operating margins of 5 per cent and 1 per cent, respectively, to both have a rate of return of 20 per cent on operating assets? How?
➢ Cite some of the possible deficiencies in accounting information, especially regarding its use in analyzing a particular company over a 10-year period.
Exercises
Exercise A Income statement data for Boston Company for 2009 and 2010 follow:
2009 | 2010 | |
Net sales | $2,610,000 | $1,936,000 |
Cost of goods sold | 1,829,600 | 1,256,400 |
Selling expenses | 396,800 | 350,000 |
Administrative expenses | 234,800 | 198,400 |
Federal income taxes | 57,600 | 54,000 |
Prepare a horizontal and vertical analysis of the income data in a form similar to Exhibit 2. Comment on the results of this analysis.
Exercise B A company engaged in the following three independent transactions:
- Merchandise purchased on account, $ 2,400,000.
- Machinery purchased for cash, $ 2,400,000.
- Capital stock issued for cash, $ 2,400,000.
- Compute the current ratio after each of these transactions assuming current assets were $ 3,200,000 and the current ratio was 1:1 before the transactions occurred.
- Repeat part (a) assuming the current ratio was 2:1.
- Repeat part (a) assuming the current ratio was 1:2.
Exercise C A company has sales of $ 3,680,000 per year. Its average net accounts receivable balance is $ 920,000.
- What is the average number of days accounts receivable are outstanding?
- By how much would the capital invested in accounts receivable be reduced if the turnover could be increased to 6 without a loss of sales?
Exercise D Columbia Corporation had the following selected financial data for 2009 December 31: Net cash provided by operating activities
Net sales | $1,800,000 |
Cost of goods sold | 1,080,000 |
Operating expenses | 315,000 |
Net income | 195,000 |
Total assets | 1,000,000 |
Net cash provided by operating activities | 25,000 |
Compute the cash flow margin.
Exercise E From the following partial income statement, calculate the inventory turnover for the period.
Net sales | $2,028,000 | |
Cost of goods sold: | ||
Beginning inventory | $ 234,000 | |
Purchases | 1,236,000 | |
Cost of goods available for sale | $1,560,000 | |
Less: Ending inventory | 265,200 | |
Cost of goods sold | 1,294,800 | |
Gross margin | $ 733,200 | |
Operating expenses | 327,600 | |
Net operating income | $ 405,600 |
Exercise F Eastern, Inc., had net sales of $ 3,520,000, gross margin of $ 1,496,000, and operating expenses of $ 904,000. Total assets (all operating) were $ 3,080,000. Compute Eastern’s rate of return on operating assets.
Exercise G Nelson Company began the year 2010 with total stockholders’ equity of $ 2,400,000. Its net income for 2010 was $ 640,000, and $ 106,800 of dividends were declared. Compute the rate of return on average stockholders’ equity for 2010. No preferred stock was outstanding.
Exercise H Rogers Company had 60,000 shares of common stock outstanding on 2010 January 1. On 2010 April 1, it issued 20,000 additional shares for cash. The amount of earnings available for common stockholders for 2010 was $ 600,000. What amount of EPS of common stock should the company report?
Exercise I Smith Company started 2011 with 800,000 shares of common stock outstanding. On March 31, it issued 96,000 shares for cash, and on September 30, it purchased 80,000 shares of its own stock for cash. Compute the weighted-average number of common shares outstanding for the year.
Exercise J A company reported EPS of $ 2 (or ) for 2009, ending the year with 1,200,000 shares outstanding. In 2010, the company earned net income of $ 7,680,000, issued 320,000 shares of common stock for cash on September 30, and distributed a 100 per cent stock dividend on 2010 December 31. Compute EPS for 2010, and compute the adjusted earnings per share for 2009 that would be shown in the 2010 annual report.
Exercise K A company paid interest of $ 32,000, incurred federal income taxes of $ 88,000, and had net income (after taxes) of $ 112,000. How many times was interest earned?
Exercise L John Company had 20,000 shares of $ 600 par value, 8 per cent preferred stock outstanding. Net income after taxes was $ 5,760,000. The market price per share was $ 720.
- How many times were the preferred dividends earned?
- What was the dividend yield on the preferred stock assuming the regular preferred dividends were declared and paid?
Exercise M A company had 80,000 weighted-average number of shares of $ 320 par value common stock outstanding. The amount of earnings available to common stockholders was $ 800,000. Current market price per share is $ 720. Compute the EPS and the price-earnings ratio.
Problems
Problem A Loom’s comparative statements of income and retained earnings for 2010 and 2009 are given below.
Loom
Consolidated statement of earnings
For the years ended 2010 December 31, and 2009
(USD thousands, except per data share)
December 31 | ||
(1) | (2) | |
2010 | 2009 | |
Net sales | $ 2,403,100 | $ 2,297,800 |
Cost of sales | 1,885,700 | 1,651,300 |
Gross earnings | $ 517,400 | $ 646,500 |
Selling, general and administrative expenses | 429,700 | 376,300 |
Goodwill amortization | 37,300 | 35,200 |
Impairment write down of goodwill | 158,500 | 0 |
Operating earnings (loss) | $ (108,100) | $235,000 |
Interest expense | (116,900) | (95,400) |
Other expense-net | (21,700) | (6,100) |
Earnings (loss) before income tax (benefit) expense, extraordinary item and cumulative effect of change in accounting principles | $ (246,700) | $133,500 |
Income tax (benefit) expense | (19,400) | 73,200 |
Earnings (loss) before cumulative effect of change in account principles | $ (227,300) | $60,300 |
Cumulative effect of change in accounting principles: | ||
Pre-operating costs | (5,200) | 0 |
Net earnings (loss) | $ (232,500) | $60,300 |
Retained earnings, January 1 | 680,600 | 620,300 |
$ 448,100 | $680,600 | |
Dividends | 0 | 0 |
Retained earnings, December 31 | $ 448,100 | $680,600 |
Loom
consolidated balance sheet
As of 2010 December 31, and 2009
(USD thousands)
December 31 | ||
(1) | (2) | |
2010 | 2009 | |
Assets | ||
Current assets | ||
Cash and cash equivalents | $ 26,500 | $ 49,400 |
Notes and accounts receivable (less allowance for possible losses of $26,600,000 and $20,700,000, respectively) | 261,000 | 295,600 |
Inventories | ||
Finished goods | 522,300 | 496,200 |
Work in process | 132,400 | 141,500 |
Materials and supplies | 44,800 | 39,100 |
Other | 72,800 | 54,800 |
Total current assets | $ 1,059,800 | $ 1,076,600 |
Property, plant, and equipment | ||
Land | $ 20,100 | $ 19,300 |
Buildings, structures and improvements | 486,400 | 435,600 |
Machinery and equipment | 1,076,600 | 1,041,300 |
Construction in progress | 24,200 | 35,200 |
Total property, plant and equipment | $ 1,607,300 | $ 1,531,400 |
Less accumulated depreciation | 578,900 | 473,200 |
Net property, plant and equipment | $ 1,028,400 | $ 1,058,200 |
Other assets | ||
Goodwill (less accumulated amortization of $257,800,000 and $242,400,000, respectively). | $ 771,100 | $ 965,800 |
Other | 60,200 | 62,900 |
Total other assets | $831,300 | $ 1,028,700 |
Total assets | $ 2,919,500 | $ 3,163,500 |
Liabilities and stockholders’ equity | ||
Current liabilities | ||
Current maturities of long-term debt | $ 14,600 | $ 23,100 |
Trade accounts payable | 60,100 | 113,300 |
Accrued insurance obligations | 38,800 | 23,600 |
Accrued advertising and promotion | 23,800 | 23,400 |
Interest payable | 16,000 | 18,300 |
Accrued payroll and vacation pay | 15,300 | 33,100 |
Accrued pension | 11,300 | 19,800 |
Other accounts payable and accrued expenses | 123,900 | 77,200 |
Total current liabilities | $ 303,800 | $ 331,800 |
Noncurrent liabilities | ||
Long-term debt | 1,427,200 | 1,440,200 |
Net deferred income taxes | 0 | 43,400 |
Other | 292,900 | 222,300 |
Total noncurrent liabilities | $ 1,720,000 | $ 1,705,900 |
Total liabilities | $ 2,023,900 | $ 2,037,700 |
Common stockholders’ equity | ||
Common stock and capital in excess of par value, $.01 par value; authorized, Class A, 200,000,000 shares, Class B, 30,000,000 shares; issued and outstanding: | ||
Class A Common Stock, 69,268,701 and 69,160,349 shares, respectively | $ 465,600 | $ 463,700 |
Class B Common Stock, 6,690,976 shares | 4,400 | 4,400 |
Retained earnings | 448,100 | 680,600 |
Currency translation and minimum pension liability adjustments | (22,500) | (22,900) |
Total common stockholders’ equity | $ 895,600 | $ 1,125,800 |
Total liabilities and stockholders’ equity | $ 2,919,500 | $ 3,163,500 |
Perform a horizontal and vertical analysis of Loom’s financial statements in a manner similar to those illustrated in this chapter. Comment on the results of the analysis in (a).
Problem B Deere & Company manufactures, distributes, and finances a full range of agricultural equipment; a broad range of industrial equipment for construction, forestry, and public works; and a variety of lawn and grounds care equipment. The company also provides credit, health care, and insurance products for businesses and the general public. Consider the following information from the Deere & Company 2000 Annual Report:
(in millions) | 1997 | 1998 | 1999 | 2000 |
Sales | $12,791 | $13,822 | $11,751 | $13,137 |
Cost of goods sold | 8,481 | 9,234 | 8,178 | 8,936 |
Gross margin | 4,310 | 4,588 | 3,573 | 4,201 |
Operating expenses | 2,694 | 2,841 | 3,021 | 3,236 |
Net operating income | $ 1,616 | $ 1,747 | $ 552 | $ 965 |
- Prepare a statement showing the trend percentages for each item using 1997 as the base year.
- Comment on the trends noted in part (a).
Problem C The following data are for Toy Company:
December 31 | ||
2011 | 2010 | |
Allowance for uncollectible accounts | $72,000 | $57,000 |
Prepaid expenses | 34,500 | 45,000 |
Accrued liabilities | 210,000 | 186,000 |
Cash in Bank A | 1,095,000 | 975,000 |
Wages payable | -0- | 37,500 |
Accounts payable | 714,000 | 585,000 |
Merchandise inventory | 1,342,500 | 1,437,000 |
Bonds payable, due in 2005 | 615,000 | 594,000 |
Marketable securities | 217,500 | 147,000 |
Notes payable (due in six months) | 300,000 | 195,000 |
Accounts receivable | 907,500 | 870,000 |
Cash flow from operating activities | 192,000 | 180,000 |
- Compute the amount of working capital at both year-end dates.
- Compute the current ratio at both year-end dates.
- Compute the acid-test ratio at both year-end dates.
- Compute the cash flow liquidity ratio at both year-end dates.
- Comment briefly on the company’s short-term financial position.
Problem D On 2011 December 31, Energy Company’s current ratio was 3:1 before the following transactions were completed:
- Purchased merchandise on account.
- Paid a cash dividend declared on 2011 November 15.
- Sold equipment for cash.
- Temporarily invested cash in trading securities.
- Sold obsolete merchandise for cash (at a loss).
- Issued 10-year bonds for cash.
- Wrote off goodwill to retained earnings.
- Paid cash for inventory.
- Purchased land for cash.
- Returned merchandise that had not been paid for.
- Wrote off an account receivable as uncollectible. Uncollectible amount is less than the balance in the Allowance for Uncollectible Accounts.
- Accepted a 90-day note from a customer in settlement of customer’s account receivable.
- Declared a stock dividend on common stock.
Consider each transaction independently of all the others.
- Indicate whether the amount of working capital will increase, decrease, or be unaffected by each of the transactions.
- Indicate whether the current ratio will increase, decrease, or be unaffected by each of the transactions.
Problem E Digital Company has net operating income of $ 500,000 and operating assets of $ 2,000,000.
Its net sales are $ 4,000,000.
The accountant for the company computes the rate of return on operating assets after computing the operating margin and the turnover of operating assets.
- Show the computations the accountant made.
- Indicate whether the operating margin and turnover increase or decrease after each of the following changes. Then determine what the actual rate of return on operating assets would be. The events are not interrelated; consider each separately, starting from the original earning power position. No other changes occurred.
(a)Sales increased by $ 160,000. There was no change in the amount of operating income and no change in operating assets.
(b)Management found some cost savings in the manufacturing process. The amount of reduction in operating expenses was $ 40,000. The savings resulted from the use of less materials to manufacture the same quantity of goods. As a result, average inventory was $ 16,000 lower than it otherwise would have been. Operating income was not affected by the reduction in inventory.
(c) The company invested $ 80,000 of cash (received on accounts receivable) in a plot of land it plans to use in the future (a nonoperating asset); income was not affected.
(d)The federal income tax rate increased and caused income tax expense to increase by $ 20,000. The taxes have not yet been paid.
(e)The company issued bonds and used the proceeds to buy $ 400,000 of machinery to be used in the business. Interest payments are $ 20,000 per year. Net operating income increased by $ 100,000 (net sales did not change).
Problem F Polaroid Corporation designs, manufactures, and markets worldwide instant photographic cameras and films, electronic imaging recording devices, conventional films, and light polarizing filters and lenses. The following information is for Polaroid:
(in millions) | 2000 | 1999 |
Net sales | $13,994 | $14,089 |
Income before interest and taxes | 2,310 | 2,251 |
Net income | 1,407 | 1,392 |
Interest expense | 178 | 142 |
Stockholders’ equity (on 1998 December 31, $3,988) | 3,428 | 3,912 |
Common stock, par value $1, December 31 | 978 | 978 |
Compute the following for both 2000 and 1999. Then compare and comment.
- EPS of common stock.
- Net income to net sales.
- Net income to average common stockholders’ equity.
- Times interest earned ratio.
Problem G The Walt Disney Company operates several ranges of products from theme parks and resorts to broadcasting and other creative content. The following balance sheet and supplementary data are for The Walt Disney Company for 2000.
The Walt Disney Company
Consolidated balance sheet
For 2000 September 30
(USD millions)
Assets | ||
Cash and cash equivalents | $ 842 | |
Receivables | 3,599 | |
Inventories | 702 | |
Film and television costs | 1,162 | |
Other | 1,258 | |
Total current costs | $7,563 | |
Film and television costs | 5,339 | |
Investments | 2,270 | |
Theme parks, resorts, and other property, at cost | ||
Attractions, buildings, and equipment | $16,160 | |
Accumulated depreciation | (6,892) | |
9,718 | ||
Project in process | 1,995 | |
Land | 597 | |
Intangibles assets, net | 16,117 | |
Other assets | 1,428 | |
Total assets | $25,027 | |
Liabilities and stockholders’ equity | ||
Accounts payable and accrued liabilities | $ 5,161 | |
Current portion of borrowing | 2,502 | |
Unearned royalties | 739 | |
Total current liabilities | $ 8,402 | |
Borrowings | 6,959 | |
Deferred income taxes | 2,833 | |
Other long-term liabilities | 2,377 | |
Minority interest | 356 | |
Common shareholders’ equity | ||
Common shares ($.01 par value) | $12,101 | |
Retained earnings | 12,767 | |
Cumulative translation and other adjustments | (28) | |
Treasury shares | (740) | 24,100 |
Total liabilities and stockholders’ equity | $45,027 |
- Net income, $ 920.
- Income before interest and taxes, $ 3,231.
- Cost of goods sold, $ 21,321.
- Net sales, $ 25,402.
- Inventory on 1999 September 30, $ 796.
- Total interest expense for the year, $ 598.
Calculate the following ratios and show your computations. For calculations normally involving averages, such as average stockholders’ equity, use year-end amounts unless the necessary information is provided.
- Current ratio.
- Net income to average common stockholders’ equity.
- Inventory turnover.
- Number of days’ sales in accounts receivable (assume 365 days in 2000).
- EPS of common stock (ignore treasury stock).
- Times interest earned ratio.
- Equity ratio.
- Net income to net sales.
- Total assets turnover.
- Acid-test ratio.
Problem H Cooper Company currently uses the FIFO method to account for its inventory but is considering a switch to LIFO before the books are closed for the year. Selected data for the year are:
Merchandise inventory, January 1 | $1,430,000 |
Current assets | 3,603,600 |
Total assets (operating) | 5,720,000 |
Cost of goods sold (FIFO) | 2,230,800 |
Merchandise inventory, December 31 (LIFO) | 1,544,400 |
Merchandise inventory, December 31 (FIFO) | 1,887,600 |
Current liabilities | 1,144,000 |
Net sales | 3,832,400 |
Operating expenses | 915,200 |
- Compute the current ratio, inventory turnover ratio, and rate of return on operating assets assuming the company continues using FIFO.
- Repeat part (a) assuming the company adjusts its accounts to the LIFO inventory method.
Alternate problems
Alternate problem A Steel Corporation’s comparative statements of income and retained earnings and consolidated balance sheet for 2010 and 2009 follow:
Steel Corporation
Consolidated statement of Earnings
For the years ended 2010 December 31, 2009
(USDthousands)
December | 31 | |
(1) | (2) | |
2010 | 2009 | |
Net sales | $4,876.5 | $4,819.4 |
Costs and expenses: | ||
Cost of sales | $4,202.8 | $4,287.3 |
Depreciation | 284.0 | 261.1 |
Estimated restructuring losses | 111.8 | 137.4 |
Total costs | $4,598.6 | $4,685.8 |
Income from operations | $268.9 | $ 133.6 |
Financing income (expense): | ||
Interest and other income | 7.7 | 7.1 |
Interest and other financing costs | (60.0) | (46.2) |
Loss before income taxes and cumulative effect of changes in accounting | $ 216.6 | $ 94.5 |
Benefit (provision) for income taxes | (37.0) | (14.0) |
Net earning (loss) | $ 179.6 | $ 80.5 |
Retained earnings, January 1 | (859.4) | (939.9) |
$ (679.8) | $ (859.4) | |
Dividends | 0.0 | 0.0 |
Retained earnings, December 31 | $ (679.8) | (859.4) |
Steel Corporation
Consolidated balance sheet
As of 2010 December 31, and 2009
December | 31 | |
(1) | (2) | |
2010 | 2009 | |
Assets | ||
Current Assets | ||
Cash and cash equivalents | $ 180.0 | $ 159.5 |
Receivables | 374.6 | 519.5 |
Total | $ 554.6 | $ 679.0 |
Inventories | ||
Raw materials and supplies | $ 335.5 | $ 331.9 |
Finished and semifinished products | 604.9 | 534.9 |
Contract work in process less billings of $10.9 and $2.3 | 17.8 | 16.1 |
Total inventories | $ 958.2 | $ 882.9 |
Other current assets | $ 13.0 | $ 7.2 |
Total current assets | $ 1,525.8 | $ 1,569.1 |
Property, plant and equipment less accumulated depreciation of $4329.5 and $4167.8 | $ 2,714.2 | $ 2,759.3 |
Investments and miscellaneous assets | 112.3 | 124.2 |
Deferred income tax asset – net | 885.0 | 903.2 |
Intangible asset – Pensions | 463.0 | 426.6 |
Total assets | $ 5,700.3 | $ 5,782.4 |
Liabilities and stockholders’ equity | ||
Current liabilities | ||
Accounts payable | $ 381.4 | $ 387.0 |
Accrued employment costs | 208.0 | 165.8 |
Postretirement benefits other than pensions | 150.0 | 138.0 |
Accrued taxes | 72.4 | 67.6 |
Debt and capital lease obligations | 91.5 | 88.9 |
Other current liabilities | 146.3 | 163.9 |
Total current liabilities | $ 1,049.6 | $ 1,011.2 |
Pension liability | $ 1,115.0 | $ 1,117.1 |
Postretirement benefits other than pensions | 1,415.0 | 1,441.4 |
Long-term debt and capital lease obligations | 546.8 | 668.4 |
Other | 335.6 | 388.5 |
Total noncurrent liabilities | $ 3,412.4 | # 3,615.4 |
Total liabilities | $ 4,462.0 | $ 4,626.6 |
Common stockholders’ equity | ||
Preferred stock – at $1 per share par value (aggregate liquidation preference of $481.2); Authorized 20,000,000 shares | $ 11.6 | $ 11.6 |
Preference stock – at $1 per share par value (aggregate liquidation preference of $88.2); Authorized 20,000,000 shares | 2.6 | 2.6 |
Common stock – at $1 per share par value/Authorized 250,000,000 and 150,000,000 shares; Issued 112,699,869 and 111,882,276 shares | 112.7 | 111.9 |
Held in treasury, 1,992,189 and 1,996,715 shares at cost | (59.4) | (59.5) |
Additional paid-in capital | 1,850.6 | 1,948.6 |
Accumulated deficit | (679.8) | (859.4) |
Total common stockholders’ equity | $ 1,238.3 | $ 1,155.8 |
Total liabilities and stockholders’ equity | $ 5,700.3 | $ 5,782.4 |
- Perform a horizontal and vertical analysis of Steel’s financial statements in a manner similar to Exhibit 1 and Exhibit 2.
- Comment on the results obtained in part (a).
Alternate problem B Ford Motor Company is the world’s second-largest producer of cars and trucks and ranks among the largest providers of financial services in the United States. The following information pertains to Ford: (in millions)
(in millions) | 1998 | 1999 | 2000 |
Sales | $118.017 | $135,073 | $141,230 |
Cost of goods sold | 104,616 | 118,985 | 126,120 |
Gross margin | $ 13,401 | $ 16,088 | $ 15,110 |
Operating expenses | 7,834 | 8,874 | 9,884 |
Net operating income | $ 5,567 | $ 7,214 | $ 5,226 |
- Prepare a statement showing the trend percentages for each item, using 1998 as the base year.
- Comment on the trends noted in part (a).
Alternate problem C The following data are for Clock Company: Allowance for uncollectible accounts
December | 31 | |
2011 | 2010 | |
Notes payable (due in 90 days) | $75,200 | $60,000 |
Merchandise inventory | 240,000 | 208,000 |
Cash | 100,000 | 128,000 |
Marketable securities | 49,600 | 30,000 |
Accrued liabilities | 19,200 | 22,000 |
Accounts receivable | 188,000 | 184,000 |
Accounts payable | 112,000 | 72,000 |
Allowance for uncollectible accounts | 24,000 | 15,200 |
Bonds payable, due 2008 | 156,000 | 160,000 |
Prepaid expenses | 6,400 | 7,360 |
Cash flow from operating activities | 60,000 | 40,000 |
- Compute the amount of working capital at both year-end dates.
- Compute the current ratio at both year-end dates.
- Compute the acid-test ratio at both year-end dates.
- Compute the cash flow liquidity ratio at both year-end dates.
- Comment briefly on the company’s short-term financial position.
Alternate problem D Tulip Products, Inc., has a current ratio on 2010 December 31, of 2:1 before the following transactions were completed:
- Sold a building for cash.
- Exchanged old equipment for new equipment. (No cash was involved.)
- Declared a cash dividend on preferred stock.
- Sold merchandise on account (at a profit).
- Retired mortgage notes that would have matured in 2011.
- Issued a stock dividend to common stockholders.
- Paid cash for a patent.
- Temporarily invested cash in government bonds.
- Purchased inventory for cash.
- Wrote off an account receivable as uncollectible. Uncollectible amount is less than the balance of the Allowance for Uncollectible Accounts.
- Paid the cash dividend on preferred stock that was declared earlier.
- Purchased a computer and gave a two-year promissory note.
- Collected accounts receivable.
- Borrowed from the bank on a 120-day promissory note.
- Discounted a customer’s note. Interest expense was involved.
Consider each transaction independently of all the others.
- Indicate whether the amount of working capital will increase, decrease, or be unaffected by each of the transactions.
- Indicate whether the current ratio will increase, decrease, or be unaffected by each of the transactions.
Alternate problem E The following selected data are for three companies:
Operating Assets |
Net Operating Income |
Net Sales |
|
Company 1 | $ 1,404,000 | $ 187,200 | $ 2,059,200 |
Company 2 | 8,424,000 | 608,400 | 18,720,000 |
Company 3 | 37,440,000 | 4,914,000 | 35,100,000 |
- Determine the operating margin, turnover of operating assets, and rate of return on operating assets for each company.
- In the subsequent year, the following changes took place (no other changes occurred):
Company 1 bought some new machinery at a cost of $ 156,000. Net operating income increased by $ 12,480 as a result of an increase in sales of $ 249,600.
Company 2 sold some equipment it was using that was relatively unproductive. The book value of the equipment sold was $ 624,000. As a result of the sale of the equipment, sales declined by $ 312,000, and operating income declined by $ 6,240.
Company 3 purchased some new retail outlets at a cost of $ 6,240,000. As a result, sales increased by $ 9,360,000, and operating income increased by $ 499,200.
- Which company has the largest absolute change in:
- Operating margin ratio?
- Turnover of operating assets?
- Rate of return on operating assets?
- Which one realized the largest dollar change in operating income? Explain this change in relation to the changes in the rate of return on operating assets.
Alternate problem F One of the largest spice companies in the world, McCormick & Company, Inc., produces a diverse array of specialty foods. The following information is for McCormick & Company, Inc.:
2000 | 1999 | |
(USD thousands) | ||
Net sales | $2,123,500 | $2,006,900 |
Income before interest and taxes | 225,700 | 174,700 |
Net income | 137,500 | 98,500 |
Interest expense | 39,700 | 32,400 |
Stockholders’ equity | 359,300 | 382,400 |
Common stock, no par value, November 30 | 175,300 | 173,800 |
Assume average common shares outstanding for 2000 and 1999 are 69,600 and 72,000 (in thousands), respectively.
Compute the following for both 2000 and 1999. Then compare and comment. Assume stockholders’ equity for 1998 was $ 388,100.
- EPS of common stock.
- Net income to net sales.
- Return on average common stockholders’ equity.
- Times interest earned ratio.
Alternate problem G Parametric Technology Corporation is in the CAD/CAM/CAE industry and is the top supplier of software tools used to automate a manufacturing company. The following consolidated balance sheet and supplementary data are for Parametric for 2003:
Parametric Technology Corporation
Consolidated balance sheet
For 2003 September 30 (in thousands)
Assets | |
Current assets | |
Cash and cash equivalents | $ 325,872 |
Short-term investments | 22,969 |
Accounts receivable, net of allowances for doubtful account of $6,270 | 183,804 |
Other current assets | 95,788 |
Total current assets | $ 628,433 |
Marketable investments | 26,300 |
Property and equipment, net | 66,879 |
Other assets | 203,271 |
Total assets | $ 924,883 |
Liabilities and stockholders‘ equity | |
Current liabilities | |
Accounts payable and accrued expenses | $ 77,144 |
Accrued compensation | 52,112 |
Deferred revenue | 231,495 |
Income taxes | 1,601 |
Total currents liabilities | $ 362,352 |
Other liabilities | 33,989 |
Stockholders’ equity | |
Preferred stock, $.01 par value; 5,000 shares authorized; none issued | |
Common stock, $.01 par value; 500,000 shares authorized; 276,053 (2000) and 272,277 (1999) shares issued | 2,761 |
Additional paid-in capital | 1,641,513 |
Foreign currency translation adjustment | (12,629) |
Accumulated deficit | (1,036,456) |
Treasury stock, at cost, 6,456 (2000) and 2,113 (1999) shares | (66,647) |
Total liabilities and stockholders’ equity | $ 924,883 |
- Net loss, ($ 3,980).
- Loss before interest and taxes, ($ 4,700).
- Cost of goods sold, $ 244,984.
- Net sales, $ 928,414.
- Total interest expense for the year, $ 367.
- Weighted-average number of shares outstanding, 273,081.
Calculate the following ratios and show your computations. For calculations normally involving averages, such as average accounts receivable or average stockholders’ equity, use year-end amounts if the information is not available to use averages.
- Current ratio.
- Net income to average common stockholders’ equity.
- Number of days’ sales in accounts receivable (assume 365 days in 2003).
- EPS of common stock.
- Times interest earned ratio.
- Equity ratio.
- Net income to net sales.
- Total assets turnover.
- Acid-test ratio.
Alternate problem H Paper Company is considering switching from the FIFO method to the LIFO method of accounting for its inventory before it closes its books for the year. The January 1 merchandise inventory was $ 864,000. Following are data compiled from the adjusted trial balance at the end of the year:
Merchandise inventory, December 31 (FIFO) | $1,008,000 |
Current liabilities | 720,000 |
Net sales | 2,520,000 |
Operating expenses | 774,000 |
Current assets | 1,890,000 |
Total assets (operating) | 2,880,000 |
Cost of goods sold | 1,458,000 |
If the switch to LIFO takes place, the December 31 merchandise inventory would be $ 900,000.
- Compute the current ratio, inventory turnover ratio, and rate of return on operating assets assuming the company continues using FIFO.
- Repeat (a) assuming the company adjusts its accounts to the LIFO inventory method.
Beyond the numbers – Critical thinking
Business decision case A The comparative balance sheets of the Darling Corporation for 2011 December 31, and 2010 follow:
Darling Corporation
Comparative balance sheets
2011 December 31, and 2010
(USD millions)
2011 | 2010 | |
Assets | ||
Cash | $ 480,000 | $ 96,000 |
Accounts receivable, net | 86,400 | 115,200 |
Merchandise inventory | 384,000 | 403,200 |
Plant and equipment, net | 268,800 | 288,000 |
Total assets | $ 1,219,200 | $902,400 |
Liabilities and stockholders’ equity | ||
Accounts payable | $ 96,000 | $ 96,000 |
Common stock | 672,000 | 672,000 |
Retained earnings | 451,200 | 134,400 |
Total liabilities and stockholders’ equity | $1,219,200 | $902,400 |
Based on your review of the comparative balance sheets, determine the following:
- What was the net income for 2011 assuming there were no dividend payments?
- What was the primary source of the large increase in the cash balance from 2010 to 2011?
- What are the two main sources of assets for Darling Corporation?
- What other comparisons and procedures would you use to complete the analysis of the balance sheet?
Business decision case B As Miller Manufacturing Company’s internal auditor, you are reviewing the company’s credit policy. The following information is from Miller’s annual reports for 2008, 2009, 2010, and 2011:
2008 | 2009 | 2010 | 2011 | |
Nets accounts receivable | $ 1,080,000 | $ 2,160,000 | $ 2,700,000 | $ 3,600,000 |
Net sales | 10,800,000 | 13,950,000 | 17,100,000 | 19,800,000 |
Management has asked you to calculate and analyze the following in your report:
- If cash sales account for 30 per cent of all sales and credit terms are always 1/10, n/60, determine all turnover ratios possible and the number of days’ sales in accounts receivable at all possible dates. (The number of days’ sales in accounts receivable should be based on year-end accounts receivable and net credit sales.)
- How effective is the company’s credit policy?
Business decision case C Wendy Prince has consulted you about the possibility of investing in one of three companies (Apple, Inc., Baker Company, or Cookie Corp.) by buying its common stock. The companies’ investment shares are selling at about the same price. The long-term capital structures of the companies alternatives are as follows:
Apple, Inc. |
Baker Company |
Cookie Corp. |
|
Bonds with a 10% interest rate | $2,400,000 | ||
Preferred stock with an 8% dividend rate | $2,400,000 | ||
Common stock, $10 par value | $4,800,000 | 2,400,000 | 2,400,000 |
Retained earnings | 384,000 | 384,000 | 384,000 |
Total long-term equity | $5,184,000 | $5,184,000 | $5,184,000 |
Number of common shares outstanding | 480,000 | 240,000 | 240,000 |
Prince has already consulted two investment advisers. One adviser believes that each of the companies will earn $ 300,000 per year before interest and taxes. The other adviser believes that each company will earn about $ 960,000 per year before interest and taxes. Prince has asked you to write a report covering these points:
- Compute each of the following, using the estimates made by the first and second advisers.
(a)Earnings available for common stockholders assuming a 40 per cent tax rate.
(b)EPS of common stock.
(c) Rate of return on total stockholders’ equity.
- Which stock should Prince select if she believes the first adviser?
- Are the stockholders as a group (common and preferred) better off with or without the use of long-term debt in the companies?
Annual Report analysis D The following selected financial data excerpted from the annual report of Appliance Corporation represents the summary information which management presented for interested parties to review:
Appliance Corporation
Selected Financial Data
(USD thousands except per share data)
2010 | 2009 | 2008 | 2007 | 2006 | |
Net sales | $3,049,524 | $3,372,515 | $2,987,054 | $3,041,223 | $2,970,626 |
Cost of sales | 2,250,616 | 2,496,065 | 2,262,942 | 2,339,406 | 2,254,221 |
Income taxes | 74,800 | 90,200 | 38,600 | 15,900 | 44,400 |
Income (loss) from continuing operations | (14,996) | 151,137 | 51,270 | (8,254) | 79,017 |
Per cent of income (loss) from continuing operations to net sales | (0.5%) | 4.5% | 1.7% | (0.3%) | 2.7% |
Income (loss) from continuing operations per share | $ (0.14) | 1.42 | 0.48 | (0.08) | $ 0.75 |
Dividends paid per share | 0.515 | 0.50 | 0.50 | 0.50 | 0.50 |
Average shares outstanding (in thousands) | 107,062 | 106,795 | 106,252 | 106,077 | 105,761 |
Working capital | $ 543,431 | $ 595,703 | $ 406,181 | $452,626 | $ 509,025 |
Depreciation of property, plant and equipment | 102,572 | 110,044 | 102,459 | 94,032 | 83,352 |
Additions to property, plant and equipment | 152,912 | 84,136 | 99,300 | 129,891 | 143,372 |
Total assets | 2,125,066 | 2,504,327 | 2,469,498 | 2,501,490 | 2,535,068 |
Long-term debt | 536,579 | 663,205 | 724,65 | 789,232 | 809,480 |
Total debt to capitalization | 45.9% | 50.7% | 60.0% | 58.7% | 45.9% |
Shareowners’ equity per share of common stock | $ 6.05 | $ 6.82 | $ 5.50 | $ 9.50 |
- As a creditor, what do you believe management’s objectives should be? Which of the preceding items of information would assist a creditor in judging management’s performance?
- As an investor, what do you believe management’s objectives should be? Which of the preceding items of information would assist an investor in judging management’s performance?
- What other information might be considered useful?
Group project E Choose a company the class wants to know more about and obtain its annual report. In groups of two or three students, calculate either the liquidity, equity, profitability, or market test ratios. Each group should select a spokesperson to tell the rest of the class the results of the group’s calculations. Finally, the class should decide whether or not to invest in the corporation based on the ratios they calculated.
Group project F In a group of two or three students, go to the library and attempt to locate Dun & Bradstreet’s Industry Norms and Key Business Ratios. You may have to ask the reference librarian for assistance to see if this item is available at your institution. If it is not available at your institution, ask if it is available through an interlibrary loan. (Obviously, if you cannot obtain this item, you cannot do this project.) Then select and obtain the latest annual report of a company of your choice. Determine the company’s SIC Code (a code that indicates the industry in which that company operates). SIC Codes for specific companies are available on COMPACT DISCLOSURE, an electronic source that may be available at your library. As an alternative, you could call the company’s home office to inquire about its SIC Code. The annual report often contains the company’s phone number. From the annual report, determine various ratios for the company, such as the current ratio, debt to equity ratio, and net income to net sales. Then compare these ratios to the industry norms for the company’s SIC Code as given in the Dun & Bradstreet source. Write a report to your instructor summarizing the results of your investigation.
Group project G In a group of two or three students, obtain the annual report of a company of your choice Identify the major sections of the annual report and the order in which they appear. Would you recommend the order be changed to emphasize the most useful and important information? If so, how? Then describe some specific useful information in each section. Comment on your perceptions of the credibility that a reader of the annual report could reasonably assign to each section of the report. For instance, if such a discussion appears in the annual report you select, would you assign high credibility to everything that appears in the Letter to Stockholders regarding the company’s future prospects? Write a report to your instructor summarizing the results of your investigation.
Using the Internet—A view of the real world
Visit the following website for Eastman Kodak Company:
By following choices on the screen, locate the income statements and balance sheets for the latest two years. Calculate all of the ratios illustrated in the chapter for which the data are available. Compare the ratios to those shown for Synotech as presented in the chapter. Write a report to your instructor showing your calculations and comment on the results of your comparison of the two companies.
Visit the following website for General Electric Company:
By following choices on the screen, locate the income statements and balance sheets for the latest two years. Calculate all of the ratios illustrated in the chapter for which the data are available. Compare the ratios to those shown for Synotech as presented in the chapter. Write a report to your instructor showing your calculations and comment on the results of your comparison of the two companies.
Answers to self-test
True-false
True. Financial statement analysis consists of applying analytical tools and techniques to financial statements and other relevant data to obtain useful information.
False. Horizontal analysis provides useful information about the changes in a company’s performance over several periods by analyzing comparative financial statements of the same company for two or more successive periods.
False. Common-size statements show only percentage figures, such as percentages of total assets and percentages of net sales.
True. Liquidity ratios such as the current ratio and acid-test ratio indicate a company’s short-term debt-paying ability.
True. The accrual net income shown on the income statement is not cash basis income and does not indicate cash flows.
True. Analysts must use comparable data when making comparisons of items for different periods or different companies.
Multiple-choice
- b. Current assets: $ 136,000 + $ 64,000 + $ 184,000 + $ 244,000 + $ 12,000 = $ 640,000
Current liabilities: $ 256,000 + $ 64,000 = $ 320,000
Current ratio:
- c. Quick assets:
$ 136,000 + $ 64,000 + $ 184,000 = $ 384,000
Current liabilities:
256,000 + $ 64,000 = $ 320,000
Acid-test ratio:
- Net sales:
$ 4,620,000
Average accounts receivable:
Accounts receivable turnover:
- Cost of goods sold:
$ 3,360,000
Average inventory:
Inventory turnover:
- Income before interest and taxes, $ 720,000
Interest on bonds, 192,000
Times interest earned ratio: $ 720,000/$ 192,000 = 3.75 times
- Accounting Principles: A Business Perspective. Authored by: James Don Edwards, University of Georgia & Roger H. Hermanson, Georgia State University. Provided by: Endeavour International Corporation. Project: The Global Text Project . License: CC BY: Attribution