Create Presentation
Download Presentation

Download Presentation
## Demonstration Problem

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**Accounting**What the Numbers Mean 9e Demonstration Problem Chapter 11 – Problem 9 Ratio Analysis – Comprehensive Problem**Problem Definition**• Presented below are summarized data from the balance sheet and income statement of Wiper, Inc.: Wiper, Inc. Condensed Balance Sheets December 31, 2011, 2010, and 2009 2011 2010 2009 Current assets . . . . . . . . . . . . . $ 677 $ 891 $ 736 Other assets. . . . . . . . . . . . . . . 2,413 1,920 1,719 $3,090 $2,811 $2,455 Current liabilities . . . . . . . . . . . . $ 562 $ 803 $ 710 Other liabilities. . . . . . . . . . . . . . 1,521 982 827 Owners’ equity. . . . . . . . . . . . . . . 1,007 1,026 918 $3,090 $2,811 $2,455**Problem Definition**Wiper, Inc. Selected Income Statement Data and Other Data For the Years Ended December 31, 2011 and 2010 (in millions) Income statement data: 2011 2010 Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $3,050 $2,913 Operating income . . . . . . . . . . . . . . . . . . . . . . . . . 296 310 Interest expense. . . . . . . . . . . . . . . . . . . . . . . . . . . 84 65 Net income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192 187 Other data: Average number of common shares outstanding. . 41.3 46.7 Total dividends paid . . . . . . . . . . . . . . . . . . . . . . . $ 50.0 $ 52.3**Problem Definition**• Calculate return on investment, based on net income and average total assets, for 2011 and 2010. Show both margin and turnover in your calculation. • Calculate return on equity for 2011 and 2010. • Calculate working capital and the current ratio for each of the past three years. • Calculate earnings per share for 2011 and 2010. e. If Wiper’s stock had a price/earnings ratio of 13 at the end of 2011, what was the market price of the stock? f. Calculate the cash dividend per share for 2011 and the dividend yield based on the market price calculated in part e.**Problem Definition**• Calculate the dividend payout ratio for 2011. • Assume that accounts receivable at December 31, 2011, totaled $309 million. Calculate the number of days’ sales in receivables at that date. • Calculate Wiper’s debt ratio and debt/equity ratio at December 31, 2011 and 2010. • Calculate the times interest earned factor for 2011 and 2010. • Review the results of these calculations, evaluate the profitability and liquidity of this company, and state your opinion about its suitability as an investment for a young, single professional with funds to invest in common stock.**Problem Definition**a. ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ROI = Margin x Turnover Net income Net income. Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover = 6.5% ROI ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover = 6.5% ROI 2010 ROI = ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover = 6.5% ROI 2010 ROI = ($187 / $2,913) ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover = 6.5% ROI 2010 ROI = ($187 / $2,913) * [$2,913 / (($2,455 + $2,811) / 2)] ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover = 6.5% ROI 2010 ROI = ($187 / $2,913) * [$2,913 / (($2,455 + $2,811) / 2)] = 6.4% margin * 1.106 turnover ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**a. 2011 ROI = ($192 / $3,050) * [$3,050 / (($2,811 + $3,090) / 2)] = 6.3% margin * 1.034 turnover = 6.5% ROI 2010 ROI = ($187 / $2,913) * [$2,913 / (($2,455 + $2,811) / 2)] = 6.4% margin * 1.106 turnover = 7.1% ROI ROI = Margin x Turnover Net income Net income Sales Average total assets Sales Average total assets**Problem Definition**• Calculate return on investment, based on net income and average total assets, for 2011 and 2010. Show both margin and turnover in your calculation. • Calculate return on equity for 2011 and 2010. • Calculate working capital and the current ratio for each of the past three years. • Calculate earnings per share for 2011 and 2010. e. If Wiper’s stock had a price/earnings ratio of 13 at the end of 2011, what was the market price of the stock? f. Calculate the cash dividend per share for 2011 and the dividend yield based on the market price calculated in part e.**Problem Definition**b. ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 / (($1,007 + $1,026) / 2) ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 / (($1,007 + $1,026) / 2) = 18.9% ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 / (($1,007 + $1,026) / 2) = 18.9% 2010 ROE = ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 / (($1,007 + $1,026) / 2) = 18.9% 2010 ROE = $187 ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 / (($1,007 + $1,026) / 2) = 18.9% 2010 ROE = $187 / (($1,026 + $918) / 2) ROE = Net income / Average owners’ equity**Problem Definition**b. 2011 ROE = $192 / (($1,007 + $1,026) / 2) = 18.9% 2010 ROE = $187 / (($1,026 + $918) / 2) = 19.2% ROE = Net income / Average owners’ equity**Problem Definition**• Calculate return on investment, based on net income and average total assets, for 2011 and 2010. Show both margin and turnover in your calculation. • Calculate return on equity for 2011 and 2010. • Calculate working capital and the current ratio for each of the past three years. • Calculate earnings per share for 2011 and 2010. e. If Wiper’s stock had a price/earnings ratio of 13 at the end of 2011, what was the market price of the stock? f. Calculate the cash dividend per share for 2011 and the dividend yield based on the market price calculated in part e.**Problem Solution**c. 2011 2010 2009 Current assets . . . . . . . . . . . . . $677 $891 $736**Problem Solution**c. 2011 2010 2009 Current assets . . . . . . . . . . . . . $677 $891 $736 Current liabilities . . . . . . . . . . (562) (803) (710)**Problem Solution**c. 2011 2010 2009 Current assets . . . . . . . . . . . . . $677 $891 $736 Current liabilities . . . . . . . . . . (562) (803) (710) Working capital (CA –CL) . . . $115 $ 88 $ 26**Problem Solution**c. 2011 2010 2009 Current assets . . . . . . . . . . . . . $677 $891 $736 Current liabilities . . . . . . . . . . (562) (803) (710) Working capital (CA –CL) . . . $115 $ 88 $ 26 Current ratio (CA / CL) . . . . . 1.2 1.1 1.0**Problem Definition**• Calculate return on investment, based on net income and average total assets, for 2011 and 2010. Show both margin and turnover in your calculation. • Calculate return on equity for 2011 and 2010. • Calculate working capital and the current ratio for each of the past three years. • Calculate earnings per share for 2011 and 2010. e. If Wiper’s stock had a price/earnings ratio of 13 at the end of 2011, what was the market price of the stock? f. Calculate the cash dividend per share for 2011 and the dividend yield based on the market price calculated in part e.**Problem Definition**d. EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 / 41.3 EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 / 41.3 = $4.65 EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 / 41.3 = $4.65 2010 EPS = EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 / 41.3 = $4.65 2010 EPS = $187 EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 / 41.3 = $4.65 2010 EPS = $187 / 46.7 EPS = Net income / Weighted average number of shares outstanding**Problem Definition**d. 2011 EPS = $192 / 41.3 = $4.65 2010 EPS = $187 / 46.7 = $4.00 EPS = Net income / Weighted average number of shares outstanding**Problem Definition**• Calculate return on investment, based on net income and average total assets, for 2011 and 2010. Show both margin and turnover in your calculation. • Calculate return on equity for 2011 and 2010. • Calculate working capital and the current ratio for each of the past three years. • Calculate earnings per share for 2011 and 2010. e. If Wiper’s stock had a price/earnings ratio of 13 at the end of 2011, what was the market price of the stock? f. Calculate the cash dividend per share for 2011 and the dividend yield based on the market price calculated in part e.**Problem Definition**e. Price/Earnings Ratio = Market Price / Earnings Per Share**Problem Definition**e. 13 = Price/Earnings Ratio = Market Price / Earnings Per Share**Problem Definition**e. 13 = $??? Price/Earnings Ratio = Market Price / Earnings Per Share**Problem Definition**e. 13 = $??? / $4.65 Price/Earnings Ratio = Market Price / Earnings Per Share**Problem Definition**e. 13 = $??? / $4.65 Market price = Price/Earnings Ratio = Market Price / Earnings Per Share**Problem Definition**e. 13 = $??? / $4.65 Market price = $60.45 Price/Earnings Ratio = Market Price / Earnings Per Share**Problem Definition**• Calculate return on investment, based on net income and average total assets, for 2011 and 2010. Show both margin and turnover in your calculation. • Calculate return on equity for 2011 and 2010. • Calculate working capital and the current ratio for each of the past three years. • Calculate earnings per share for 2011 and 2010. e. If Wiper’s stock had a price/earnings ratio of 13 at the end of 2011, what was the market price of the stock? f. Calculate the cash dividend per share for 2011 and the dividend yield based on the market price calculated in part e.**Problem Definition**f. Cash dividends per share = Total cash dividends / Weighted average shares outstanding