Q1

Q2

Q3

Q4

Please Answer all 4 questions Please

The income before income tax expense was $686,400 and $600,600 for the current and prior years, respectively. a. Determine the ratio of liabilities to stockholders' equity at the end of each year. Round to one decimal place. b. Determine the times interest earned ratio for both years. Round to one decimal place. c. The ratio of liabilities to stockholders' equity have These results are the combined result of a compared to the previous year. and the times interest earned ratio has income before income taxes and from the previous year. interest expense in the current year The 20Y7 net income was $37,240, and the 20Y6 net income was $26,870. No dividends on common stock were declared between 20Y5 and 20Y7. Preferred dividends were declared and paid in full in 20Y6 and 20Y7. a. Determine the return on total assets, the return on stockholders' equity, and the return on common stockholders' equity for the years 20Y6 and 20Y7. Round percentages to one decimal place. b. The profitability ratios indicate that the company's profitability has 'eturn on stockholders' equity in both years, there must be - Since the rate of return on total assets is leverage from the use of debt. the Earnings per Share, Price-Earnings Ratio, Dividend Yield The following information was taken from the financial statements of Zeil Inc. for December 31 of the current fiscal year: Common stock, $45 par value (no change during the year) $11,250,0006,000,000 Preferred$4stock,$200par(nochangeduringtheyear) The net income was $470,000 and the declared dividends on the common stock were $62,500 for the current year. The market price of the common stock is $9.80 per share. For the common stock, determine (a) the earnings per share, (b) the price-earnings ratio, (c) the dividends per share, and (d) the dividend yield. If required, round your answers to two decimal places. a. Now create formulas in your new sheet using the data in the Financial Statement Data sheet that will reflect the correct percentages as described in the previous question. Instead of creating every formula one by one, how could you create just one formula in cell B2 that can be copied and pasted to all cells? Note that there are negative values in the Financial Statement Data sheet. Choose the correct formula. I. ='Financial Statement Data'!\$B2/'Financial Statement Data'!B2 II. ='Financial Statement Data'!B2/'Financial Statement Data'!\$B2 III. ='Financial Statement Data'!B2/'Financial Statement Data'!B $2 IV. ='Financial Statement Data'!B2/'Financial Statement Data'!\$B\$2 2. Vertical analysis: Create another new sheet to pertorm the vertical analysis, comparing each year's item to that year's net sales: a. Instead of creating every formula one by one, how can you create just one formula in cell B2 that can be copied and pasted to all cells? Note that there are negative values in the Financial Statement Data sheet. Choose the correct formula. I. =ABS('Financial Statement Data'!\$B2/'Financial Statement Data'!B2) II. =ABS('Financial Statement Data'!B2/'Financial Statement Data'!\$B2) III. =ABS('Financial Statement Data'!B2/'Financial Statement Data'!B\$2) IV. =ABS('Financial Statement Data'!B2/'Financial Statement Data'!\$B\$2) b. Again, copy and paste that one formula to all the relevant cells in your new sheet. Round your answers to two decimal places. Enter all percentages as positive numbers. 4. Explain the use of the common size financial statements. If you were a manager, which area would require further analysis? The input in the box below will not be graded, but may be reviewed and considered by your instructor