Hi, I tried many time to get the right answers but im having a lot of trouble and would really appreaciate help with this question thank you :)
P12-2 Analyzing Comparative Financial Statements by Using Percentages and Selected Ratios L012-5, 12-6, 12-7, 12-8 The comparative financial statements prepared at December 31, 2017, for Goldfish Company showed the following summarized data: 2017 2016 Statement of Earnings Sales revenue Cost of sales $ 355,070* 305,540 $ 300,000 257,000 Gross margin Operating expenses and interest expense 49,530 31,810 43,000 28,800 Earnings before income taxes Income tax expense 17,720 5,880 14,200 4,500 Net earnings $ 11,840 $ 9,700 $ $ Statement of Financial Position Cash Accounts receivable (net) Inventory Property, plant, and equipment (net) 4,280 17,450 50,190 31,910 8,600 21,000 44,000 27,000 $ 103,830 $ 100,600 $ $ Current liabilities (no interest) Non-current liabilities (10% interest) Common shares (6,000 shares) Retained earnings 12, 110 40,380 24,000 27,340 14,700 38,900 24,000 23,000 $ 100,600 *One-third was credit sales. During 2017, cash dividends amounting to $7,500 were declared and paid. Required: 1. Present component percentages for 2017 only. (Input all amounts as positive values. Round the final answers to the nearest whole percent. Percentages may not add exactly due to rounding.) Component Percentages 2017 Statement of earnings: Sales revenue Cost of sales 0 % Gross margin Operating expenses and interest expense Earnings before income taxes Income tax expense Net earnings Statement of financial position: Cash % % 0 % Accounts receivable (net) Inventory Property, plant and equipment (net) Total assets Current liabilities % Long-term liabilities Common shares Retained earnings Total liabilities and shareholders' equity 0% Answer the following for 2017: 2- What was the average percentage markup on sales? (Round percentage answer to 1 decimal place a. (.e., 0.124 should be entered as 12.4).) Average percentage 2- What was the average income tax rate? (Round percentage answer to 1 decimal place (i.e., 0.124 b. should be entered as 12.4).) Average income tax 2-c. Compute the net profit margin ratio. Was it a good or poor indicator of performance? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Net profit margin ratio 2-d. What percentage of total resources was invested in property, plant, and equipment? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Percentage 1 2-e. Compute the debt-to-equity ratio. Does it look good or bad? (Round the final answer to 2 decimal places.) Debt-to-equity ratio 2-f. What was the return on assets? (Round intermediate calculations to 3 decimal places and percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Return on assets 2-g. What was the return on equity? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Return on equity 2-h. Compute the financial leverage percentage. Did borrowing from creditors benefit shareholders? (Round intermediate calculations and final answer to 2 decimal places.) Financial leverage percentage P12-2 Analyzing Comparative Financial Statements by Using Percentages and Selected Ratios L012-5, 12-6, 12-7, 12-8 The comparative financial statements prepared at December 31, 2017, for Goldfish Company showed the following summarized data: 2017 2016 Statement of Earnings Sales revenue Cost of sales $ 355,070* 305,540 $ 300,000 257,000 Gross margin Operating expenses and interest expense 49,530 31,810 43,000 28,800 Earnings before income taxes Income tax expense 17,720 5,880 14,200 4,500 Net earnings $ 11,840 $ 9,700 $ $ Statement of Financial Position Cash Accounts receivable (net) Inventory Property, plant, and equipment (net) 4,280 17,450 50,190 31,910 8,600 21,000 44,000 27,000 $ 103,830 $ 100,600 $ $ Current liabilities (no interest) Non-current liabilities (10% interest) Common shares (6,000 shares) Retained earnings 12, 110 40,380 24,000 27,340 14,700 38,900 24,000 23,000 $ 100,600 *One-third was credit sales. During 2017, cash dividends amounting to $7,500 were declared and paid. Required: 1. Present component percentages for 2017 only. (Input all amounts as positive values. Round the final answers to the nearest whole percent. Percentages may not add exactly due to rounding.) Component Percentages 2017 Statement of earnings: Sales revenue Cost of sales 0 % Gross margin Operating expenses and interest expense Earnings before income taxes Income tax expense Net earnings Statement of financial position: Cash % % 0 % Accounts receivable (net) Inventory Property, plant and equipment (net) Total assets Current liabilities % Long-term liabilities Common shares Retained earnings Total liabilities and shareholders' equity 0% Answer the following for 2017: 2- What was the average percentage markup on sales? (Round percentage answer to 1 decimal place a. (.e., 0.124 should be entered as 12.4).) Average percentage 2- What was the average income tax rate? (Round percentage answer to 1 decimal place (i.e., 0.124 b. should be entered as 12.4).) Average income tax 2-c. Compute the net profit margin ratio. Was it a good or poor indicator of performance? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Net profit margin ratio 2-d. What percentage of total resources was invested in property, plant, and equipment? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Percentage 1 2-e. Compute the debt-to-equity ratio. Does it look good or bad? (Round the final answer to 2 decimal places.) Debt-to-equity ratio 2-f. What was the return on assets? (Round intermediate calculations to 3 decimal places and percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Return on assets 2-g. What was the return on equity? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) Return on equity 2-h. Compute the financial leverage percentage. Did borrowing from creditors benefit shareholders? (Round intermediate calculations and final answer to 2 decimal places.) Financial leverage percentage
