Comparative Income Statement Use the following comparative income statement form to enter amounts you identify from...

Transcribed Image Text:

Comparative Income Statement Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If <5, round down and if 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%. Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 Increase/(Decrease) 20Y6 20Y5 Amount Percentage % Sales Cost of goods sold Gross profit $7,287,000 (3,444,000) % % $3,843,000 Selling expenses $(1,457,600) % Administrative expenses (1,242,000) (1,106,000) % Total operating expenses $(2,563,600) % % Operating income $1,279,400 Other expense (interest) (120,600) % Income before income tax expense $1,158,800 % % Income tax expense (181,980) Net income $976,820 % Feedback Chook My Works Profitability Measures Match each computation to one of the profitability measures in the table. Profitability Measures Asset turnover Return on total assets Return on stockholders' equity Computations $8,280,000 [($5,781,000 + $5,591,000) 2] ($801,420 + $127,000) [($6,605,000 + $6,415,000) 2] $801,420 [($4,055,000 + $3,852,250) 2] Return on common stockholders' equity ($801,420 - $65,000) [($3,567,500 + $3,424,800) 2] Earnings per share on common stock Price-earnings ratio Dividends per share Dividend yield ($801,420 - $65,000) 250,000 shares $35 $3.05 $175,000 250,000 shares $0.70 + $35 Feedback Check My Work Balance Sheet Use the following balance sheet form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part. You will identify other amounts for the balance sheet on the Profitability Measures part. If you have a choice of two amounts, assume the first amount in the ratio is for the end of the year. Compute any missing amounts. Current assets: Cash Balance Sheet December 31, 20Y6 Assets Marketable securities Accounts receivable (net) Inventory Prepaid expenses Total current assets Long-term investments Property, plant, and equipment (net) Total assets Liabilities Current liabilities Long-term liabilities Total liabilities Stockholders' Equity Preferred stock, $10 par Common stock, $5 par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $823,000 Mastery Problem: Financial Statement Analysis Liquidity and Solvency Measures Your friend, another accountant, has bet you that with your knowledge of accounting and just the computations for common analytical measures, you can figure out many aspects of a company's financial statements. You take the bet! Match each computation to one of the liquidity and solvency measures in the table. (Hint: Begin by looking for simple computations and identifying the amounts in those computations. Look for other measures that use those amounts.) Liquidity and Solvency Measures Computations Working capital Current ratio Quick ratio Accounts receivable turnover Number of days' sales in receivables Inventory turnover Number of days' sales in inventory $3,091,000 - $860,000 $3,091,000 $860,000 $1,866,000 $860,000 $8,280,000 [($714,000 + $740,000) 2] [($714,000 + $740,000) 2] ($8,280,000 365) $4,100,000 [($1,072,000 + $1,100,000) 2] [($1,072,000 + $1,100,000) 2] ($4,100,000 365) Ratio of fixed assets to long-term liabilities $2,690,000 $1,690,000 Ratio of liabilities to stockholders' equity Times interest earned $2,550,000 $4,055,000 ($989,400 + $127,000) $127,000 Feedback Check My Work Look for patterns in the computations and match them to ratios that are related to each other. Identify the amounts in the computations and consider how they are related to amounts in other computations. Balance Sheet Use the following balance sheet form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part. You will identify other amounts for the balance sheet on the Profitability Measures part. If you have a choice of two amounts, assume the first amount in the ratio is for the end of the year. Compute any missing amounts. Balance Sheet December 31, 20Y6 Assets Current assets: Comparative Income Statement Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If <5, round down and if 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%. Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 Increase/(Decrease) 20Y6 20Y5 Amount Percentage % Sales Cost of goods sold Gross profit $7,287,000 (3,444,000) % % $3,843,000 Selling expenses $(1,457,600) % Administrative expenses (1,242,000) (1,106,000) % Total operating expenses $(2,563,600) % % Operating income $1,279,400 Other expense (interest) (120,600) % Income before income tax expense $1,158,800 % % Income tax expense (181,980) Net income $976,820 % Feedback Chook My Works Profitability Measures Match each computation to one of the profitability measures in the table. Profitability Measures Asset turnover Return on total assets Return on stockholders' equity Computations $8,280,000 [($5,781,000 + $5,591,000) 2] ($801,420 + $127,000) [($6,605,000 + $6,415,000) 2] $801,420 [($4,055,000 + $3,852,250) 2] Return on common stockholders' equity ($801,420 - $65,000) [($3,567,500 + $3,424,800) 2] Earnings per share on common stock Price-earnings ratio Dividends per share Dividend yield ($801,420 - $65,000) 250,000 shares $35 $3.05 $175,000 250,000 shares $0.70 + $35 Feedback Check My Work Balance Sheet Use the following balance sheet form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part. You will identify other amounts for the balance sheet on the Profitability Measures part. If you have a choice of two amounts, assume the first amount in the ratio is for the end of the year. Compute any missing amounts. Current assets: Cash Balance Sheet December 31, 20Y6 Assets Marketable securities Accounts receivable (net) Inventory Prepaid expenses Total current assets Long-term investments Property, plant, and equipment (net) Total assets Liabilities Current liabilities Long-term liabilities Total liabilities Stockholders' Equity Preferred stock, $10 par Common stock, $5 par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $823,000 Mastery Problem: Financial Statement Analysis Liquidity and Solvency Measures Your friend, another accountant, has bet you that with your knowledge of accounting and just the computations for common analytical measures, you can figure out many aspects of a company's financial statements. You take the bet! Match each computation to one of the liquidity and solvency measures in the table. (Hint: Begin by looking for simple computations and identifying the amounts in those computations. Look for other measures that use those amounts.) Liquidity and Solvency Measures Computations Working capital Current ratio Quick ratio Accounts receivable turnover Number of days' sales in receivables Inventory turnover Number of days' sales in inventory $3,091,000 - $860,000 $3,091,000 $860,000 $1,866,000 $860,000 $8,280,000 [($714,000 + $740,000) 2] [($714,000 + $740,000) 2] ($8,280,000 365) $4,100,000 [($1,072,000 + $1,100,000) 2] [($1,072,000 + $1,100,000) 2] ($4,100,000 365) Ratio of fixed assets to long-term liabilities $2,690,000 $1,690,000 Ratio of liabilities to stockholders' equity Times interest earned $2,550,000 $4,055,000 ($989,400 + $127,000) $127,000 Feedback Check My Work Look for patterns in the computations and match them to ratios that are related to each other. Identify the amounts in the computations and consider how they are related to amounts in other computations. Balance Sheet Use the following balance sheet form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part. You will identify other amounts for the balance sheet on the Profitability Measures part. If you have a choice of two amounts, assume the first amount in the ratio is for the end of the year. Compute any missing amounts. Balance Sheet December 31, 20Y6 Assets Current assets: