here are the instructions
here is the ENTIRE problem. I need help with the rest of the Comparative Income Statement. All of the instructions that were given to me are in the photo.
Mastery Problem: Financial Statement Analysis Liquidity and Solvency Measures Balance Sheet Profitability Measures Com Profitability Measures Shaded cols have feedback. X aded cells Match each computation to one of the profitability measures in the table. intage (Decrease) Profitability Measures Computations 13.6 Assel turnover $8,280,000 = [(55,781,000 - $5,591,000) 2] 19.0 Return on total assets ($801,420 +$127,000) + [(56,605,000 + $6,415,000) + 2] 8.8 Return on stockholders' equity $801,420 + ($4,075,000 + $3,871,250) + 2] 25.0 Return on common stockholders' equity (5801,420 - $65,000)+($3,587,500 $3,444,000) + 2] Earnings per share on common stock ($801,420 - $65,000) + 250,000 shares Price-earnings ratio 35 3.05 Dividends per share $175,000 + 250,000 shares Dividend yield $0.70 + $35 Mastery Problem: Financial Statement Analysis Liquidity and Solvency Measures Balance Sheet Profitability Measures Comparative Income Statement Shaded Celshave f aci For the Years Ended December 31, 2016 and 2045 2016 2015 Amount Percentage Increase (Decrease) Increase (Decrease) 5993,000.00 656,000.00 Sales 58.280,000.00 $7.287,000.00 Cost of goods sold 3.444,000.00 Gross profit $3,843,000.00 $337,000.00 4,100,000.00 $4,180,000.00 $1,821,600.00 1.242,000.00 Selling expenses $1.457,600.00 $364,000.00 Administrative expenses 1.106,000.00 136,000.00 $2.563,600.00 Total operating expenses Income from operations $1.279.400.00 Interest expense 120.600.00 10 Income before income tax $1.158,800.00 11 Income tax expense 181,980,00 12 Net income $976,820.00 Mastery Problem: Financial Statement Analysis Liquidity and Solvency Measures Balance Sheet Profitability Measures Comparative Income Statement Shaded cels have feedoack Use the following comparative income statement form to enter amounts you identity from the computations on the city and Solvency Measures panel and on the Profitability Measures panel Compute any missing amounts and complete the horizontal analysis columns. Enfer percentages as decimal amounts, rounded to one decimal place When rounding, look only at the figure to the right of one decimal place. If round down and 5 round up. For example, for 32.048% enter 320%. For 32050% enter 32.1% Scores 61/128 Comparative Income Statement For the Years Ended December 31, 2046 and 2045 2016 2015 Amount Percentage Increase (Decrease) Increase (Decrease $993,000.00 136 656.000.00 Cost of goods sold 58.280,000.00 4.100.000.00 54.180,000.00 51,821,600.00 Gross profit 57.287.000.00 3,444.000.00 53.843.000.00 $1.457.600.00 con 5337.000.00 5364,000.00 Selling expenses Liquidity and Solvency Measures Shaded cels nave feedback 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 Inventory turnover $4,100,000 = [($1,072,000 $1,100,000) + 2] Number of days' sales in receivables [($714,000 - $740,000) + 2]+($8,280,000 - 365) Accounts receivable turnover $8,280,000+ [($714,000 $740,000) +2] Ratio of fixed assets to long-term liabilities $2,690,000+ $1,690,000 Working capital $3,091,000 - $840,000 Times interest earned ($989,400+ $127.000) = $127,000 Current ratio $3,091,000 = $840,000 Quick ratio $1,866,000 = $840,000 Number of days' sales in inventory [($1,072,000 $1,100,000) = 2] = ($4,100,000 + 365) Ratio of liabilities to stockholders' equity $2,530,000 - $4,075,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 th how they are related to amounts in other computations. Balance Sheet Shaded cells have feedback. X Use the following balance sheet form to enter amounts you identity from the computations on the Liquidity and Solvency Measures panel. You will identity other amounts for the balance sheet on the Profitability Measures panel. 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. Score: 64/64 Balance Sheet December 31, 2046 Assets Current assets: Cash $823,000.00 Marketable securities 329.000,00 Accounts receivable (net) Inventory 714,000.00 1.072,000.00 153.000.00 Prepaid expenses Shaded cells have feedoack Balance Sheet Total current assets $3,091,000.00 . Long-term investments 824.000.00 2.690.000.00 10 Property, plant, and equipment (net) 11 Total assets 56.605,000.00 Liabilities 13 Current liabilities 14 Long-term Liabilities $840,000.00 1,690,000.00 $2.550,000.00 15 Total liabilities Stockholders' Equity 11 Preferred stock. $10 par 18 Common stock, 55 par 19 Retained earings $487,500.00 1.250.000.00 2.337.500.00 $4,075,000.00 56.605,000.00 20 Total stockholders' equity 21 Total liabilities and stockholders' equity Profitability Measures Shaded cells have feedback Match each computation to one of the profitability measures in the table. Profitability Measures Computations Asset turnover $8,280,000+ [(55,781,000 $5,591,000) 2] Return on total assets (5801,420 - $127,000) + f($6,605,000 + $6,415,000) + 2] Return on stockholders' equity $801,420 + (($4,075,000 $3,871,250) 42 Return on common stockholders' equity (5801,420 - $65,000) + $3,587,500 53.444,000) 21 Earnings per share on common stock Price-earnings ratio (5801.420 - $65,000) +250,000 shares $35 + $3.05 $175,000 + 250,000 shares Dividends per share Dividend yield 50.70 $35 Shaded cels have leedback Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures panel and on the Profitability Measures panel. 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
