14 Financial Statement Analysis
14 Financial Statement Analysis
14 Financial Statement Analysis
Topic Percentages changes Trend percentages Common size statements Measures of liquidity Multiple-step income statements Real World: Kimberly Clark Corporation, ROI Computing and interpreting rates of change Research problem
Real World: Home Depot Management analysis and discussion Evaluating employment opportunities Ratios for a retail store Computing ratios Current ratio, debt ratio, and earnings per share
3, 4, 6 4, 6 7 7 6, 7
Skills Analysis Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment Analysis, communication Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment, research, technology Communication, judgment, research Analysis, communication, judgment Analysis, communication, judgment Analysis Analysis
Topic Ratio analysis for two similar companies Real World: Johnson & Johnson. Ratio analysis
Learning Objectives 7 6, 7
Problems Sets A, B 14.1 A,B 14.2 A,B 14.3 A,B 14.4 A,B
Topic Comparing operating results with average performance in the industry Analysis to identify favorable and unfavorable trends Measures of liquidity Real World: The Kroger Company & Cheese, Inc. Liquidity Balance sheet measures of liquidity and credit risk Financial statement analysis Real World: Medtronics Basic ratio analysis Ratios; consider advisability of incurring long-term debt Ratios; evaluation of two companies
Learning Objectives 1, 5 3, 5 3, 4 3, 4, 7
Skills Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment, research Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment Analysis, communication, judgment
14.5 A,B 14.6 A,B 14.7 A,B 14.8 A,B 14.9 A,B
3, 4, 7 4, 5, 7 4, 5, 7 5, 7 5, 7, 8
Critical Thinking Cases 14.1 Seasons greetings 14.2 14.3 14.4 Evaluating debt-paying ability Strategies to improve current ratio Real World: Calpers Evaluating corporate governance quality (Ethics, fraud, and corporate governance) Real World: Amazon.com Business Week Case Evaluating liquidity and profitability (Internet)
1 35 4 8
Analysis, communication, judgment Analysis, communication, judgment Communication, judgment Analysis, communication, judgment, research, technology
14.5 14.6
1, 2 7, 8
14.2 A,B
25 Medium
14.3 A,B
15 Easy
14.4 A,B
25 Easy
14.5 A,B
35 Medium
14.6 A,B
45 Strong
14.7 A,B
Medtronics/Balsum Corporation Compute the current ratio and working capital at both the beginning and end of the year and also the returns on assets and on stockholders equity for the year. Evaluate whether debt-paying ability is increasing or deteriorating and whether management appears to be using resources efficiently. Zachery, Inc./Clips Systems, Inc. Requires computation of the following: inventory turnover, accounts receivable turnover, total operating expenses, gross profit percentage, rate earned on average stockholders equity, and rate earned on average assets. Also calls for a decision on advisability of the company incurring long-term debt. Another World and Imports, Inc./ THIS Star, and THAT Star, Inc. Computation for two companies of various ratios and turnover rates relating to liquidity. Students are asked to evaluate the companies from the viewpoint of a short-term creditor.
25 Medium
14.8 A,B
25 Medium
14.9 A,B
35 Medium
14.2
15 Easy
14.3
25 Strong
14.4
14.5
20 Easy
14.6
3.
5.
6.
The purpose of classifications in financial statements is to develop useful subtotals, which help users analyze the statements. The most commonly used classifications are: In a balance sheet: current assets, plant and equipment, other assets, current liabilities, longterm (or noncurrent) liabilities, and stockholders equity. In a multiple-step income statement: revenue, cost of goods sold, operating expenses, and nonoperating items. The operating expense section often includes subclassifications for selling expenses and for general and administrative expenses. In a statement of cash flows: cash flows provided by or used in operating activities, investing activities, and financing activities.
7.
In classified financial statements, similar items are grouped together to produce subtotals which may assist users in their analyses. Comparative financial statements show financial statements for two or more time periods in side-by-side columns. Consolidated statements include not only the financial statement amounts for a single company but also for any subsidiary companies that it owns. The financial statements of large corporations often possess all three of these characteristics. Current assets are expected to be converted into cash (or substituted for cash), or used up, within one year or an operating cycle, whichever is the longer period of time. The receivables of a company that regularly sells merchandise on 24- or 36-month installment plansare current assets, because the collection of these receivables is part of the companys operating cycle. The quick ratio is the most liquid, or quick assets (cash, marketable securities, and receivables), divided by current liabilities. Short-term creditors may consider the quick ratio more useful than the current ratio if inventories consist of slow-moving merchandise, or are unusually large in dollar amount. In a multiple-step income statement, different categories of expenses are deducted from revenue in a series of steps, thus resulting in various subtotals, such as gross profit and operating income. In a single-step income statement, all expenses are combined and deducted from total revenue in a single step. Both formats result in the same amount of net income. Ratios and other measures used in evaluating profitability include (four required): Percentage change in net income from the prior year (dollar amount of the change divided by the amount in the prior year). Gross profit rate (dollar gross profit divided by net sales). Operating income (revenue from primary business activities less the cost of goods sold and operating expenses). Net income as a percentage of net sales (net income divided by net sales). Earnings per share (in the simplest case, net income divided by the number of shares of capital stock outstanding). Return on assets (operating income divided by average total assets). Return on stockholders equity (net income divided by average stockholders equity).
8.
9.
10.
11.
12. Operating income is the difference between (1) revenue earned from customers, and (2) expenses closely related to the production of that revenue. Items such as income taxes, interest expense, and gains and losses from sales of investments are specifically excluded in the computation of operating income. Thus, operating income measures the profitability of the companysbasic business activities. Net income, in contrast, is a broader measure of the profit or loss resulting from all business operations. 13. Expenses (including the cost of goods sold) have been increasing at an even faster rate than net sales. Thus, Oneida is apparently having difficulty in effectively controlling its expenses. 14. A large corporation may have thousands or even millions of individual stockholders. The extent of each stockholders ownership of the business is determined by the number of shares that he or she owns. Thus, the earnings per share measurement helps stockholders relate the total earnings of the business to their ownership investments. In addition, stock prices are stated on a per-share basis. Earnings per share information may be useful in assessing how well the company is doing in terms of earning a profit in comparison with the price to buy a share of stock. 15. P/e ratios reflect investors expectations concerning future profits. If Congress announced an intention to limit the prices and profits of pharmaceutical companies, these expectations would likely be abruptly lowered. [Note to the instructor: President Clinton made such an announcement in 1993. As a result, the p/e ratios and stock prices of major pharmaceutical companies fell significantly. In the months following the Presidents announcement, Mercks stock price dropped from the low $50s to the mid-$30s, and the stock of Bristol-Myers/Squibb dropped from the low $70s to the mid-$50s.] 16. If the companys earnings are very low, they may become almost insignificant in relation to stock price. While this means that the p/e ratio becomes very high, it does not necessarily mean that investors are optimistic. In fact, they may be valuing the company at its liquidation value rather than a value based upon expected future earnings. 17. From the viewpoint of Spencers stockholders, this situation represents a favorable use of leverage. It is probable that little interest, if any, is paid for the use of funds supplied by current creditors, and only 11% interest is being paid to long-term bondholders. Together these two sources supply 40% of the total assets. Since the firm earns an average return of 16% on all assets, the amount by which the return on 40% of the assets exceeds the fixed-interest requirements on liabilities will accrue to the residual equity holdersthe common stockholdersraising the return on stockholders equity. 18. The length of the operating cycle of the two companies cannot be determined from the fact that one companys current ratio is higher. The operating cycle depends on how long it takes to sell its inventory and then to collect receivables from sales on account.
19. The investor is calculating the rate of return by dividing the dividend by the purchase price of the investment ($5 $50 = 10%). A more meaningful figure for rate of return on investment is determined by relating dividends to current market price, since the investor at the present time is faced with the alternative of selling the stock for $100 and investing the proceeds elsewhere or keeping the investment. A decision to retain the stock constitutes, in effect, a decision to continue to invest $100 in it, at a return of 5%. It is true that in a historical sense the investor is earning 10% on the original investment, but this is interesting history rather than useful decision-making information. 20. Felkers current ratio would probably be higher during July. At this time the amount of both current assets and current liabilities are likely to be at a minimum, and the ratio of current assets to current liabilities is thus likely to be larger. In general, it would be advisable for the company to end its fiscal year as of July 31. At this time inventories and receivables will be at a minimum; therefore, the chance of error in arriving at a valuation for these assets will be minimized, the work of taking inventories will be reduced, and a more accurate determination of net income is probable.
Quick ratio:
B.Ex. 14.6 ($50,000 + $150,000)/$424,000 = 47.2% B.Ex. 14.7 Net income: $560,000 ($240,000 + $130,000) = $190,000 Net income as a % of sales: $190,000/$560,000 = 33.9% B.Ex. 14.8 Net income: $890,000 ($450,000 + $200,000) = $240,000 EPS: $240,000/10,000 shares = $24
SOLUTIONS TO EXERCISES
Ex. 14.1 a. b. c. Accounts receivable decreased 21% ($34,000 decrease $160,000 21% decrease). Marketable securities decreased 100% ($250,000 decrease $250,000 100% decrease). A percentage change cannot be calculated because retained earnings showed a negative amount (a deficit) in the base year and a positive amount in the following year. A percentage change cannot be calculated because of the zero amount of notes receivable in 2008, the base year. Notes payable increased 9% ($70,000 increase $800,000 9% increase). Cash increased 5% ($4,000 increase $80,000 5% increase). Sales increased 7% ($60,000 increase $910,000 % increase). 2009 163% 195% 2008 148% 160% 2007 123% 135% 2006 118% 123% 2005 100% 100%
d. e. f. g. Ex. 14.2
The trend of sales is favorable with an increase each year. However, the trend of cost of goods sold is unfavorable, because it is increasing faster than sales. This means that the gross profit margin is shrinking. Perhaps the increase in sales volume is being achieved through cutting sales prices. Another possibility is that the companys purchasing policies are becoming less efficient. Investigation of the cause of the trend in cost of goods sold is essential.
Ex. 14.3
Common size income statements for 2008 and 2009. Sales . Cost of goods sold .. Gross profit .. Operating expenses Net income .. 2009 100% 66 34% 26 8% 2008 100% 67 33% 29 4%
The changes from 2008 to 2009 are all favorable. Sales increased and the gross profit per dollar of sales also increased. These two factors led to a substantial increase in gross profit. Although operating expenses increased in dollar amount, the operating expenses per dollar of sales decreased from 29 cents to 26 cents. The combination of these three favorable factors caused net income to rise from 4 cents to 8 cents out of each dollar of sales.
Ex. 14.4 a. (1) Quick assets: Cash and short-term investments Receivables . Total quick assets . Current assets: Quick assets [part a (1) ] Inventories . Prepaid expenses and other current assets .. Total current assets . Quick ratio: Total quick assets (part a ) .. Current liabilities .. Quick ratio ($207 $130.1) . Current ratio: Total current assets (part a ) . Current liabilities .. Current ratio ($311.3 $130.1) .. Working capital: Total current assets (part a ) .. Less: Current liabilities . Working capital
(Dollars in Millions) $ 47.3 159.7 $ 207.0 $ 207.0 72.3 32.0 311.3 207.0 130.1 1.6 to 1 311.3 130.1 2.4 to 1 311.3 130.1 181.2
(2)
$ $
b.
(1)
(2)
(3)
$ $
c.
By traditional standards, Roys Toys seems to be quite liquid. Both its quick ratio and current ratio appear satisfactory, and its working capital balance is substantial. As a large and well-established company, it is quite possible that Roys Toys might be able to meet its current obligations even if its liquidity measures became lower than they are at the present time.
Ex. 14.5
(Dollars in thousands, except per share amounts) a. LINK, INC. Statement of Earnings For the Year Ended December 31, 2009 Net sales . Less: Cost of goods sold Gross profit Less: Operating expenses Operating income Nonoperating items: Interest revenue $ 15,797 Income tax expense (204,820) Net earnings Earnings per share
$ $
b.
(1) Gross profit rate: Gross profit $ # Net sales $ Gross profit rate ($1,573,798 $4,395,253) (2) Net income as a percentage of net sales: Net income $ Net sales $ Net income as a percentage of net sales ($380,379 $4,395,253) (3) Return on assets: Operating income $ Average total assets $ Return on assets ($569,402 $2,450,000) (4) Return on equity: Net income $ Average equity $ Return on equity ($380,379 $1,825,000)
1,573,798 4,395,253 35.8% 380,379 4,395,253 8.7% 569,402 2,450,000 23.2% 380,379 1,825,000 20.8%
c.
The net sales figure represents the companys primary source of revenue from operations. Thus, interest revenue is a nonoperating source of revenue. To include interest revenue in the gross profit computation would overstate both gross profit and operating income.
Ex. 14.6
a.
Return on assets
Operating income Average total assets $2,616 [($17,067 + $18,440) 2] Net income Average total stockholders equity $1,823 [($6,097 + $5,224) 2] = $ $ 1,823 = 5,661 32.20% = $ $ 2,616 = 17,754 14.70%
b.
Return on equity
c. The two most common reasons why a company's stockholders' equity would go down during a period are (1) a net loss reported in the income statement, and (2) an increase in the investment in treasury stock. (Remember that treasury stock reduces stockholders' equity, so if the investment in treasury stock increases, the total stockholders' equity goes down.) We know from the information provided that Kimberly-Clark reported a net income in the year being analyzed, so a net loss is not the explanation for an overall decline in stockholders' equity. The company did, in fact, significantly increase its treasury stock holdings during the year, going from approximately 23 million common treasury shares to almost 58 million common treasury shares. All other elements of stockholders' equity either stayed the same or increased. Ex. 14.7 a. Computation of percentage changes: (1) (2) b. (1)
Net sales increased 10% ($200,000 increase $2,000,000 10% increase). Total expenses increased 11% ($198,000 increase $1,800,000 11% increase).
Total expenses grew faster than net sales. Net income cannot also have grown faster than net sales, or the sum of the parts would exceed the size of the whole. Net income must represent a smaller percentage of net sales in 2009 than it did in 2008. Again, the reason is that total expenses have grown at a faster rate than net sales. Thus, total expenses represent a larger percentage of total sales in 2009 than in 2008, and net income must represent a smaller percentage.
(2)
Ex. 14.8
a. The financial measures computed by the students will vary depending upon the companies they select. Industry norm figures may also vary depending upon the investment services available in the library. It is important for students to realize that industry norms represent benchmark averages that should always be used with caution when evaluating the performance and financial condition of a business.
b. Based on their findings, students should comment on the price volatility of their stocks during the past 52 weeks, and attempt to assess investor expectations as reflected by the p/e ratio of the companies they select. c. Investment recommendations will vary depending upon the companies students select. Students should be cautioned that investment recommendations should never be based solely upon annual report data. The prudent investor must take into account industry characteristics, the potential effects of current economic trends, and the opportunities and threats facing the firm being analyzed.
Ex. 14.9 a. Home Depot has significantly increased its size, as indicated by the number of stores, during the ten-year period from 1998 through 2007. The number of stores has increased from 761 to 2,234, almost a 300% increase. This represents an annual growth rate of 13.6%. The average square footage per store has remained relatively constant in 105,000 109,000 range. b. The trend in the relationship of net earning to sales is variable. From 1998-2005, it was generally positive, though not increasing every year. Since 2005, the percentage has declined to a level (5.4%) that is approximately the same as 1998 (5.3%). c. As measured by the current ratio, liquidity has declined. This ratio is lower in many years than in the previous year over the ten-year period. It began at 1.73 (to 1) in 1998 and ended at 1.15, a significant decline over the ten-year period. Another factor from the ten-year summary which sheds light on liquidity is that the inventory turnover has declined during the ten-year period from 5.4 in 1998 to 4.2 in 2007. This indicates how often inventory "turns over" or sells and is converted into receivables or cash. Generally, the higher this turnover is, the more liquid is the company because inventory is being converted into cash more rapidly.
Ex. 14.10
Accepting the job offer from Alpha Research might be justified in terms of the companys liquidity, profitability, and the growth potential of its common stock. Liquidity: At first glance, the high current and quick ratios of Omega Scientific make it appear to be more liquid than Alpha Research. However, these figures may also indicate that the company is having problems converting accounts receivable and inventories into cash. Alpha Research, on the other hand, reports liquidity ratios that are much more in line with industry norms. Further investigation regarding the ability of each firm to consistently generate adequate operating cash flow is certainly needed. Profitability: Alpha Research appears to be more efficient than Omega Scientific at generating a return on its assets and its equity. Furthermore, Alphas profitability by far exceeds industry norms, whereas Omegas ability to earn adequate returns falls somewhat short of industry standards. Judging from its high p/e ratio, it appears that market expectations that Alpha will continue its earnings growth are optimistic. Stock growth: Stock prices of relatively new and aggressive companies often appreciate in value at a faster rate than the stocks of older, more conservative, firms. Thus, if Alpha Research continues to gain market share, generate adequate cash flows, and increase its profitability, the prospects for the companys common stock investors may be very bright. As a result, the appreciation of the stock sold to Alphas employees at a reduced rate may more than offset its lower starting salaries.
Note to instructor: Students should be cautioned not to rely completely upon financial information in the decisions they make. In deciding which job offer to accept, for example, one should take into consideration the people, fringe benefits, career growth opportunities, geographic location, potential long-term stability of each firm, etc.
Ex. 14.11
a.
(1) Gross profit percentage: 2008: 33% [($610,000 $408,000) $610,000] 2009: 34% [($750,000 $495,000) $750,000] (2) Inventory turnover: 2008: 4 times ($408,000 $102,000 average inventory) 2009: 4.5 times ($495,000 $110,000 average inventory) (3) Accounts receivable turnover: 2008: 6.1 times ($610,000 $100,000 average accounts receivable) 2009: 5 times ($750,000 $150,000 average accounts receivable)
b.
There are three favorable trends. First, the growth in net sales from $610,000 to $750,000. This represents an increase of 23% ($140,000 increase, divided by $610,000 in the prior year). Next, the gross profit rate increased from 33% in 2008 to 34% in 2009. Not only is SellFast, Inc. selling more, but it is selling its merchandise at a higher profit margin. Finally, the inventory turnover has increased, indicating that the company has increased its sales without having to proportionately increase its investment in inventories. There is only one negative trend. The accounts receivable turnover rate has declined. One question immediately should come to mind: Has SellFast liberalized its credit policies as part of its strategy to increase sales? If so, the slowdown in the receivables turnover may have been expected and be no cause for concern. On the other hand, if the company has not changed its credit policies, it apparently is encountering more difficulty in collecting its accounts receivable on a timely basis.
Ex. 14.12
Current ratio: 3.9 to 1 ($580,000 $150,000) Quick ratio: 1.7 to 1 ($250,000 $150,000) Working capital: $430,000 ($580,000 $150,000) Debt ratio: 41% ($510,000 $1,240,000) Accounts receivable turnover: 19 times ($2,950,000 $155,000) Inventory turnover: 6.8 times ($1,834,000 $270,000) Note: Cost of goods sold (item f) is $2,950,000 $1,116,000, or $1,834,000. g. Book value per share of capital stock: $12.17 ($730,000 60,000 shares) Note: Common stock outstanding is $300,000 $5 par, or 60,000 shares. a. b. c. d. e. f. 2009 2008 Current ratio: 2.0 to 1 ($160,000 $80,000) 1.3 to 1 ($130,000 $100,000) 46% ($150,000 $325,000) Debt ratio: 45% ($180,000 $400,000) Earnings per share: $3.05 [($45,000 increase in retained earnings + $16,000 dividends) 20,000 shares] Note: Common stock outstanding is $100,000 $5 par, or 20,000 shares.
Ex. 14.13
a. b. c.
Ex. 14.14
a. b.
c.
d.
Brazil Italian Stone Marble Co. Products 54,000 Net income ($1,800,000 x .03) $ $ 60,000 ($1,200,000 .05) Net income as a percentage of stockholders equity 9% ($54,000 $600,000) .. 20% ($60,000 $300,000) Accounts receivable turnover 9 times ($1,800,000 $200,000) 12 times ($1,200,000 $100,000) Inventory turnover 4.5 times ($1,800,000 .60) $240,000 . 6 times ($1,200,000 .70) $140,000 ..
Brazil Stone Products is stronger on all four financial measures: Net income is a higher percentage of sales Net income is a higher percentage of stockholders equity Accounts receivable turnover is higher Inventory turnover is higher Combined, these measures indicate that Brazil Stone Products is in the stronger financial position. Ex. 14.15 Gross profit rate 2007 $43,344 / $61,095 = 71% 2006 $38,267 / $53,324 = 72% The trend in the gross profit rate, based on only two data points, is flat (i.e., virtually the same). Net income as a percentage of sales 2007 $10,576 / $61,095 = 17% 2006 $11,053 / $53,324 = 21% The trend in net income as a percentage of sales, based on only two data points, is negative (i.e., declined). Current ratio 2007 $29,945 / $19,837 = 1.51 (to 1) 2006 $22,975 / $19,161 = 1.20 (to 1) The trend in the current ratio, based on only two data points, is significantly positive, increasing nearly 26% in one year.
20 Minutes, Easy
Sales (net) Cost of goods sold Gross profit on sales Operating expenses: Selling General and administrative Total operating expenses Operating income Income tax expense Net income
b. Campers, Inc.s operating results are significantly better than the average performance within the industry. As a percentage of sales revenue, operating income and net income are nearly twice the average for the industry. As a percentage of total assets, profits amount to an impressive 23% as compared to 14% for the industry. The key to success for Campers, Inc. seems to be its ability to earn a relatively high rate of gross profit. The companys exceptional gross profit rate (51%) probably results from a combination of factors, such as an ability to command a premium price for the companys products and production efficiencies which led to lower manufacturing costs. As a percentage of sales, Campers, Inc.s selling expenses are five points higher than the industry average (21% compared to 16%). However, these higher expenses may explain the companys ability to command a premium price for its products. Since the companys gross profit rate exceeds the industry average by 8 percentage points, the higher-than-average selling costs may be part of a successful marketing strategy. The companys general and administrative expenses are significantly lower than the industry average, which indicates that Campers, Inc.s management is able to control expenses effectively.
25 Minutes, Medium
a.
2,880,000 $ 2,520,000
b.
Cost of goods sold in dollars: ($2,880,000 net sales - $1,008,000 gross profit) ($2,520,000 net sales - $1,134,000 gross profit)
1,872,000 $ 1,386,000
Cost of goods sold as a percentage of net sales: ($1,872,000 $2,880,000) ($1,386,000 $2,520,000)
65% 55%
c.
Operating expenses in dollars: ($1,008,000 gross profit - $230,400 income before tax) ($1,134,000 gross profit - $252,000 income before tax)
777,600 $ 882,000
27% 35%
d. DARWIN, INC. Condensed Comparative Income Statement For the Year Ended December 31, 2009 and December 31, 2008 2009 $ 2,880,000 Net sales 1,872,000 Cost of goods sold $ 1,008,000 Gross profit 777,600 Operating expenses $ 230,400 Income before income tax 57,600 Income tax expense 172,800 $ Net income
$ $ $ $ $ $
15 Minutes, Easy
a.
Current assets: Cash Marketable securities Accounts receivable Inventory Unexpired insurance Total current assets Current liabilities: Notes payable Accounts payable Salaries payable Income tax payable Unearned revenue Total current liabilities
$ $
67,600 175,040 230,540 179,600 4,500 657,280 70,000 127,500 7,570 14,600 10,000 229,670
b.
The current ratio is 2.86 to 1. It is computed by dividing the current assets of $657,280 by the current liabilities of $229,670. The amount of working capital is $427,610, computed by subtracting the current liabilities of $229,670 from the current assets of $657,280. The company appears to be in a strong position as to short-run debt-paying ability. It has almost three dollars of current assets for each dollar of current liabilities. Even if some losses should be sustained in the sale of the merchandise on hand or in the collection of the accounts receivable, it appears probable that the company would still be able to pay its debts as they fall due in the near future. Of course, additional information, such as the credit terms on the accounts receivable, would be helpful in a careful evaluation of the companys current position.
25 Minutes, Easy
a.
Current assets: Cash Receivables Merchandise inventories Other current assets Total current assets
$ $
b.
(1) Current ratio: Current assets (part a) Current liabilities Current ratio ($7,114 / $8,689)
(2) Quick ratio: Quick assets (part a) Current liabilities Quick ratio ($1,704 $8,689)
(3) Working capital: Current assets (part a) Less: Current liabilities Working capital
$ $
35 Minutes, Medium
a.
(1) Quick assets: Cash Marketable securities (short-term) Accounts receivable Total quick assets (2) Current assets: Cash Marketable securities (short-term) Accounts receivable Inventories Prepaid expenses Total current assets (3) Current liabilities: Notes payable to banks (due within one year) Accounts payable Dividends payable Accrued liabilities (short-term) Income taxes payable Total current liabilities
b.
(1) Quick ratio: Quick assets (part a) Current liabilities Quick ratio: ($129,104 $55,306) (2) Current ratio: Current assets (part a) Current liabilities (part a) Current ratio ($167,050 $55,306) (3) Working capital: Current assets (part a) Less: Current liabilities (part a) Working capital (4) Debt ratio: Total liabilities (given) Total assets (given) Debt ratio ($81,630 $353,816)
$ $
$ $ $
$ $
45 Minutes, Strong
Parts a, c, e, and f appear on the following page. b. (1) Current ratio: Current assets: Cash Accounts receivable Inventory Total current assets Current liabilities Current ratio ($380,000 $150,000) (2) Quick ratio: Quick assets: Cash Accounts receivable Total quick assets Current liabilities Quick ratio ($180,000 $150,000) (3) Working capital: Current assets [(part b (1)] Less: Current liabilities Working capital (4) Debt ratio: Total liabilities Total assets Less: Total stockholders' equity Total liabilities Total assets Debt ratio ($700,000 $1,000,000) d. (1) Return on assets: Operating income: Net sales Less: Cost of goods sold Operating expenses Operating income Total assets (at year-end) Return on assets ($105,000 $1,000,000) (2) Return on equity: Net income Total stockholders' equity (at year-end) Return on equity ($15,000 $300,000)
$ $
$ $ $
$ $
$ $ $
$ $
$ $
15,000 300,000 5%
c.
e.
25 Minutes, Medium
a.
Current ratio: (1) Beginning of year ($10,377 $4,406) (2) End of year ($7,918 $2,563)
2.36 to 1 3.09 to 1
b. Working capital:
(1) (2) Beginning of year (10,377 - $4,406) End of year ($7,918 - $2,563)
$ $
5,971 5,355
d. (1)
Return on average total assets: Operating income Average total assets [($19,665 + $19,512)/2]
Return on average total assets [$3,669 $19,589]
$ $
(2)
$ $
[$2,802 $10,180]
c. Medtronics short-term debt-paying ability has improved as evidenced by its higher current ratio at the end of the year (2.36 vs. 3.09). The dollar amount of working capital however, has declined ($5,971 million to $5,355 million) which means that the company has less of a 'cushion' between its currently-maturing obligations and its most liquid assets. e. Yes, Medtronics management is using the companys' assets to generate a strong return on both assets and stockholders' equity, while maintaining strong liquidity with which to satisfy its obligations as they mature.
25 Minutes, Medium
a.
(1)
= 4.68 times
(2)
Accounts receivable turnover: Credit Sales, $2,750,000 Average Accounts Receivable, $290,000
= 9.48 times
(3) Total operating expenses: Sales Less: Cost of goods sold Gross profit Less: Interest expense (non-operating item) Income tax expense (non-operating item) Net income Operating expenses
288,000 707,000
(4) Gross profit percentage: Sales, $2,750,000 cost of goods sold, $1,755,000 = gross profit, $995,000. $995,000 $2,750,000 = 36% (5) Return on average stockholders equity, $159,000 $895,000 = 17.8%
(6) Return on average assets: Operating income: Sales Cost of goods sold Gross profit Operating expenses Operating income Average investment in assets Return on average assets ($288,000 $1,800,000)
$ $ $ $
35 Minutes, Medium
a.
(1) Working capital: ($51,000 + $75,000 + $84,000 - $105,000) ($20,000 + $70,000 + $160,000 - $100,000)
105,000 $ 150,000
(2) Current ratio: ($51,000 + $75,000 + $84,000) $105,000 ($20,000 + $70,000 + $160,000) $100,000
2 to 1 2.5 to 1
1.2 to 1 .9 to 1
(4) Number of times inventory turned over during the year: ($504,000 cost of goods sold $84,000 inventory) ($480,000 cost of goods sold $160,000 inventory) Average number of days required to turn over inventory: (365 6 times) (365 3 times)
6 times 3 times
(5) Number of times accounts receivable turned over: ($675,000 credit sales $75,000 accounts receivable) ($560,000 credit sales $70,000 accounts receivable) Average number of days required to collect accounts rec.: (365 9 times) (365 8 times)
9 times 8 times
41 days 46 days
20 Minutes, Easy
Sales (net) Cost of goods sold Gross profit on sales Operating expenses: Selling General and administrative Total operating expenses Operating income Income tax expense Net income
b. Bathrooms' operating results are significantly better than the average performance within the industry. As a percentage of sales revenue, operating income is three times the industry average and net income more than four times the average for the industry. As a percentage of total assets, profits amount to an impressive 20% as compared to 12% for the industry. The key to success for Bathrooms, Inc. seems to be its ability to earn a relatively high rate of gross profit. The companys exceptional gross profit rate (39%) probably results from a combination of factors, such as an ability to command a premium price for the companys products and production efficiencies which led to lower manufacturing costs. As a percentage of sales, Bathrooms, Inc.'s selling expenses are five points higher than the industry average (15% compared to 10%). However, these higher expenses may explain the companys ability to command a premium price for its products. Since the companys gross profit rate exceeds the industry average by 9 percentage points, the higher-than-average selling costs may be part of a successful marketing strategy. The companys general and administrative expenses are significantly lower than the industry average, which indicates that Bathrooms, Inc.'s management is able to control expenses effectively.
25 Minutes, Medium
a.
1,875,000 $ 1,700,000
b.
Cost of goods sold in dollars: ($1,875,000 net sales - $720,000 gross profit) ($1,700,000 net sales - $800,000 gross profit)
1,155,000 $ 900,000
Cost of goods sold as a percentage of net sales: ($1,155,000 $1,875,000) ($900,000 $1,700,000)
61.6% 52.9%
c.
Operating expenses in dollars: ($720,000 gross profit - $200,000 income before tax) ($800,000 gross profit - $220,000 income before tax)
520,000 $ 580,000
27.7% 34.1%
d. SLOW TIME, INC. Condensed Comparative Income Statement For the Year Ended December 31, 2009 and December 31, 2008 2009 $ 1,875,000 Net sales 1,155,000 Cost of goods sold $ 720,000 Gross profit 520,000 Operating expenses $ 200,000 Income before income tax 50,000 Income tax expense $ 150,000 Net income
$ $ $ $ $ $
15 Minutes, Easy
a.
Current assets: Cash Marketable securities Accounts receivable Inventory Unexpired insurance Total current assets Current liabilities: Notes payable Accounts payable Salaries payable Income taxes payable Unearned revenue Total current liabilities
b.
The current ratio is 2.85 to 1. It is computed by dividing the current assets of $641,000 by the current liabilities of $225,200. The amount of working capital is $415,800, computed by subtracting the current liabilities of $225,200 from the current assets of $641,000. The company appears to be in a strong position as to short-run debt-paying ability. It has almost three dollars of current assets for each dollar of current liabilities. Even if some losses should be sustained in the sale of the merchandise on hand or in the collection of the accounts receivable, it appears probable that the company would still be able to pay its debts as they fall due in the near future. Of course, additional information, such as the credit terms on the accounts receivable, would be helpful in a careful evaluation of the companys current position.
25 Minutes, Easy
a.
Current assets: Cash Receivables Merchandise inventories Prepaid expenses Total current assets
$ $
b.
Current ratio: Current assets (part a) Current liabilities Current ratio ($1,713.8 $2,500.0)
Quick ratio: Quick assets (part a) Current liabilities Quick ratio ($222.8 $2,500.0)
Working capital: Current assets (part a) Less: Current liabilities Working capital
$ $ $
35 Minutes, Medium
a.
(1) Quick assets: Cash Marketable securities (short-term) Accounts receivable Total quick assets (2) Current assets: Cash Marketable securities (short-term) Accounts receivable Inventories Prepaid expenses Total current assets (3) Current liabilities: Notes payable to banks (due within one year) Accounts payable Dividends payable Accrued liabilities (short-term) Income tax payable Total current liabilities
b.
(1) Quick ratio: Quick assets (part a) Current liabilities (part a) Quick ratio: ($140,870 $64,700) (2) Current ratio: Current assets (part a) Current liabilities (part a) Current ratio ($190,720 $64,700) (3) Working capital: Current assets (part a) Less: Current liabilities (part a) Working capital (4) Debt ratio: Total liabilities (given) Total assets (given) Debt ratio ($90,000 $600,000)
$ $
$ $
$ $
45 Minutes, Strong
Parts a, c, e, and f appear on the following page. b. (1) Current ratio: Current assets: Cash Accounts receivable Inventory Total current assets Current liabilities Current ratio ($435,000 $190,000) (2) Quick ratio: Quick assets: Cash Accounts receivable Total quick assets Current liabilities Quick ratio ($210,000 $190,000) (3) Working capital: Current assets [(part b (1)] Less: Current liabilities Working capital (4) Debt ratio: Total liabilities Total assets Less: Total stockholders' equity Total liabilities Total assets Debt ratio ($800,000 $1,300,000) d. (1) Return on assets: Operating income: Net sales Less: Cost of goods sold Operating expenses Operating income Total assets (at year-end) Return on assets ($105,000 $1,300,000) (2) Return on equity: Net income Total stockholders' equity (at year-end) Return on equity ($21,000 $500,000)
$ $
$ $ $
$ $
$ $ $
$ $
$ $
c.
e.
25 Minutes, Medium
a.
Current ratio: (1) Beginning of year ($43,000 $54,000) (2) End of year ($82,000 $75,000)
.80 to 1 1.09 to 1
b. Working capital:
(1) (2) Beginning of year ($43,000 $54,000) End of year ($82,000 - $75,000)
$ $
(11,000) 7,000
d. (1)
Return on average total assets: Operating income Average total assets [($230,000 + $390,000)/2]
Return on average total assets ($74,000 $310,000)
$ $
(2)
$ $
($51,000 $162,500)
c. and e. c. Balsums short-term debt-paying ability appears to be improving. In the course of the year, the companys current ratio has improved, and its working capital has increased from a negative amount of $11 million to a positive amount of $7 million (an $18 million turnaround). e. Balsums management appears to be utilizing the companys resources in more than a reasonably efficient manner. The companys return on assets and return on equity both are well above the companys cost of borrowing money, the norms in many industries, and the rates of return that investors can safely achieve from, say, putting their money in a bank.
25 Minutes, Medium
a.
(1)
= 7.14 times
(2)
Accounts receivable turnover: Credit Sales, $4,800,000 Average Accounts Receivable, $380,000
= 12.63 times
(3) Total operating expenses: Sales Less: Cost of goods sold Gross profit Less: Interest expense (non-operating item) Income tax (non-operating item) Net income Operating expenses
$ $
410,000 1,390,000
(4) Gross profit percentage: Sales, $4,800,000 cost of goods sold, $3,000,000 = gross profit, $1,800,000. $1,800,000 $4,800,000 = 37.5% (5) Return on average stockholders equity, $280,000 $1,000,000 = 28%
(6) Return on average assets: Operating income: Sales Cost of goods sold Gross profit Operating expenses Operating income Average investment in assets Return on average assets ($410,000 $2,600,000)
$ $ $ $
35 Minutes, Medium
a.
(1) Working capital: ($90,000 + $100,000 + $50,000 - $120,000) ($40,000 + $90,000 + $160,000 - $110,000)
120,000 $ 180,000
(2) Current ratio: ($90,000 + $100,000 + $50,000) $120,000 ($40,000 + $90,000 + $160,000) $110,000
2 to 1 2.64 to 1
1.58 to 1 1.18 to 1
(4) Number of times inventory turned over during the year: ($700,000 cost of goods sold $50,000 inventory) ($640,000 cost of goods sold $160,000 inventory) Average number of days required to turn over inventory: (365 14 times) (365 4 times)
14 times 4 times
26 days 91 days
(5) Number of times accounts receivable turned over: ($900,000 credit sales $100,000 accounts receivable) ($840,000 credit sales $90,000 accounts receivable) Average number of days required to collect accounts rec.: (365 9 times) (365 9.33 times)
41 days 39 days
PROBLEM 14.9B THIS STAR, INC. AND THAT STAR, INC. (concluded)
b. Although THAT Star, Inc., has a larger dollar amount of working capital and a higher current ratio, THIS Star, Inc. has the higher-quality working capital. The quality of working capital is determined by the nature of the current assets comprising the working capital and the length of time required to convert these assets into cash. Over half of THIS Star's current assets consist of cash and receivables. Most of THAT Star's, working capital is inventory, which is a less liquid asset. The computation of each companys quick ratio shows that THIS Star has highly liquid assets (cash and receivables) in excess of its current liabilities, whereas THAT Star does not have as high a ratio.
THIS Star is also able to sell its inventory and to collect its receivables more quickly than THAT Star. THIS Star requires only 26 days to sell its average inventory, while THAT Star requires 91 days. The overall operating cycle for THIS Star is over two months shorter than for THAT Star. Thus, THIS Star is able to convert its current assets into cash more quickly than THAT Star. A supplier should prefer selling $50,000 in merchandise on a 30-day open account to THIS Star rather than to THAT Star. THIS Star clearly has a greater potential for paying off this account when it becomes due.
a. Wallace computed the 350% increase in fourth-quarter profits by comparing the fourthquarter profits of 2009 to those of the third quarter. The computation is: $450 $100 $100 = 350%
Wallaces conclusion that profits for the entire year were up by over 100% came from comparing the total profits of calendar year 2009 to calendar year 2008. The resulting percentage increase is 102%, computed as follows: $1,111 $550 $550 = 102%
b. The 350% increase in fourth-quarter profits, developed by comparing fourth-quarter profits to those of the third quarter, is misleading because of the cyclical nature of Holiday Greeting Cards business. The third quarter (July through September) contains no major greeting-card holidays, whereas the fourth quarter contains the Christmas season. Therefore, fourth-quarter profits should exceed those of the third quarter whether the company was growing or not. The over 100% increase in profits for the year is also misleading, because it is based upon a comparison of calendar year 2009 with calendar year 2008. Since Holiday Greeting Cards was in operation for only part of 2008, this is not a valid comparison. Thus, neither of Wallaces percentage change statistics represents a realistic measure of Holidays rate of growth. c. The appropriate computation of the percentage change in Holidays fourth-quarter earnings for 2009 is a decrease of 10%, computed as follows: Fourth quarter 2009, $450 Fourth quarter 2008, $500 Fourth quarter 2008, $500 = 10%
By using the fourth quarter of the prior year as a base (rather than the third quarter of the current year), we are able to eliminate the effects of seasonal fluctuations in the companys business. This analysis shows that Holiday Greeting Cards level of economic activity in the fourth quarter of 2009 has declined relative to that of 2008. Thus, the companys profitability appears to be declining rather than growing.
15 Minutes, Easy
a.
Current assets .. Current liabilities .. Current ratio: ($75,000 $30,000) .. ($24,000 $30,000) .. Working capital: ($75,000 $30,000) .. ($24,000 $30,000)
b. Based solely upon the financial data presented here, neither restaurant appears to be a good risk for a $250,000 loan. Although Texas Steak Ranch has a strong current ratio now, the addition of a $250,000 current liability would reduce it to about .27 to 1. The $45,000 in working capital pales in significance when compared with the need to repay a $250,000 loan in one year. The numbers for The Stockyards show even weaker financial position. Considering the form of business organization, however, The Stockyards appears to be the better credit risk. The reason is that this business is organized as a sole proprietorship. A loan to this business is actually a loan to its owner, Dan Scott, as he is personally liable for the debts of the business. Scott, a billionaire, is a far better candidate for a $250,000 loan than is either of these two business entities. Texas Steak Ranch, on the other hand, is organized as a corporation. Therefore, the owner (Scott) is not personally responsible for the debts of the business. In seeking payment, creditors may look only to the assets of the corporate entity. An interesting question arises as to why Scott doesnt put more of his own money into these businesses. In the case of Texas Steak Ranch, it may simply be that he recognizes the risks inherent in the restaurant business and doesnt want to have his own money at risk. Indeed, this is probably the reason that the business was organized as a corporation in the first place. Note to instructor: It is a common practice for wealthy individuals to organize businesses as corporations for the specific purpose of limiting the owners personal liability. c. Texas Steak Ranch would become as good a credit risk as The Stockyards if Scott would personally guarantee the loan to the corporation. This essentially removes the difference in risk that the bank is taking in loaning to the two companies.
Note to instructor: It is also common practice for banks making loans to small businesses organized as corporations to insist that one or more stockholders personally guarantee the loan.
25 Minutes, Strong
a.
(1) Increase. Paying current liabilities reduces current assets and current liabilities by the same dollar amount. As the current ratio exceeds 1 to 1, however, reducing both current assets and current liabilities by an equal amount will increase the ratio.
Note to instructor: This concept can be illustrated by assuming that all of the current liabilities were paid. In this case, some current assets would remain, current liabilities would be reduced to zero, and the current ratio would be infinite. (2) Decrease. Purchasing inventory on account increases current assets and current liabilities by the same amount. This tends to force the current ratio closer to 1 to 1 which, for Nashville Do-It-Yourself Centers, would be a decline. In essence, purchasing inventory on account has the opposite effect of paying current liabilities, discussed in part (1). (3) Decrease. Offering customers a cash discount to speed up the collection of accounts receivable would replace accounts receivable with a somewhat smaller amount of cash. Cash on hand would increase. However, as both cash and accounts receivable are current assets, total current assets and the current ratio would decrease. b. One means of improving the current ratio is to increase current assets without increasing current liabilities. This could be done by selling noncurrent assets, by borrowing cash on a longterm basis, or by the owners investing cash in the business. The increase in the current ratio would be magnified if the proceeds from these transactions were used to reduce current liabilities. A second legitimate strategy is to seize any opportunities to sell existing current assets at prices higher than their carrying value in the accounting records. Selling inventory at a price above cost, for example, replaces the inventory (valued at cost) with either cash or accounts receivable in the amount of the sales price. Therefore, a year-end clearance sale may help improve the current ratio. In part a (2) we stated that purchasing inventory on account would reduce the current ratio. The reverse strategy, not making normal purchases to replace sold merchandise, increases the current ratio, because current assets and current liabilities both fall beneath normal levels. Also, delaying until after year-end any routine transactions that reduce current assets, such as purchases of equipment or expenditures for repairs or maintenance, will improve the current ratio.
CASE 14.4 EVALUATING CORPORATE GOVERNANCE QUALITY ETHICS, FRAUD & CORPORATE GOVERNANCE
Although there are many possible "solutions" to this case, depending on the companies that students choose for analysis, students should talk about most of these factors in evaluating the quality of a company's board of directors. Board composition The board of directors should be comprised of a majority of independent directors (i.e., an independent director is a director with no ties to the company or its management other than his or her service as a director). In fact, the NYSE and Nasdaq now require that listed companies have boards with a majority of independent directors. Nominating committee Companies should have a separate committee of the board to handle the process of nominating individuals to join the board of directors. The nominating committee should be comprised of independent directors. The NYSE now requires its listed companies to maintain a nominating committee comprised of independent directors. Nasdaq requires either an independent nominating committee, or that the independent members of the board of directors handle the nominating process. Compensation committee Companies should have a separate committee of the board to handle the process of determining compensation of senior company officers. The compensation committee should be comprised of independent directors. The NYSE requires its listed companies to maintain a compensation committee comprised of independent directors. Nasdaq requires either an independent compensation committee, or that the independent members of the board of directors handle the process of setting the compensation of senior company officers. Board structure Shareholder activists prefer boards where directors stand for reelection each year, as compared to boards where the directors serve staggered terms. A typical staggered term results in 1/3 of the directors standing for elections each year. Staggered board terms make it more difficult for a company to be acquired by another company, and may increase the likelihood that a poorly performing board and management team will be able to remain in power. Board size Smaller boards are generally viewed as more effective than larger boards. A board size of between eight and 12 is often viewed as optimal. Board Expertise It is typically advantageous if board members have experience serving on the boards of other public companies. However, serving on too many boards concurrently may prevent a director from spending enough time on the affairs of each company. A rule of thumb is that an individual should not concurrently sit on the boards of more than three public companies, particularly if the director works full-time for another company.
20 Minutes, Easy
a.
Tools of analysis include: (1) Dollar and Percentage Changes the difference between the amount for a comparison year and the amount for a base year expressed in either dollars or percentages. The percentage change is the dollar change divided by the base year dollars. (2) Trend Percentages the changes in financial statement items from a base year to following years. (3) Component Percentages the relative size of each component included in the total. (4) Ratios the mathematical expression of the relationship of one item to another. Ratios can be stated as percentages or as a fraction. (5) Standards of Comparison a base against which to judge whether performance is favorable or unfavorable. Examples of standards include past performance of the company or the performance of other companies in the same industry.
b.
To assess Amazon.com, Tice could use trend percentages and component percentages. For example, Tice concludes that rising sales do not convert to rising profits. A combination of dollar and percentage changes and trend analysis would make this clear. Trends would show that sales are rising but that profits were not following suit. Also, trend analysis combined with component percentages analysis would provide evidence that sales were slowing in the core businesses and increasing in the consumer electronics business.
a.
Student responses will vary, but they should indicate an understanding that companies have unique operating characteristics, and understanding those before diving into financial analysis will allow one to better understand the financial information. For example, a merchandising company has significant inventory issues that a service company does not have. Some companies rely heavily on plant and equipment-type assets while others do not. Some companies have significant international activities while others operate primarily in a single country. These and other operating characteristics are important to understand as one begins to do serious financial analysis. Because students can choose both the company and the ratios they compute, no set answer can be given for this question. The following are probably the ratios in the categories of liquidity and profitability that are most likely to be selected by students: Liquidity Current ratio Quick ratio Inventory turnover Receivables turnover Profitability Gross profit rate Net income as a percentage of net sales Basic earnings per share Return on assets Return on equity
b.
c.
Again, student responses will likely vary, but reasons for the popularity of the Internet for receiving financial information include the following: Timeliness and ease and frequency with which information can be updated. Availability of extensive amounts of information from a single source. Technology-based access and ease of storing and printing information. Ease of transferring information and applying it to analytical techniques.