Good Morning Tutor,

I need help completing the attached assignment, please place formula and answers in an excel document.

Thank you

Markus Company's common stock sold for $2.75 per share at the end of this year. The company paid preferred stock dividends totaling $4,400 and a common stock dividend of $0.55 per share this year. It also provided the following data excerpts from this year's financial statements: 1. What is the earnings per share? 2. What is the price-earnings ratio? 3. What is the dividend payout ratio? 4. What is the dividend yield ratio? 5. What is the return on total assets (assuming a 30% tax rate)? 6. What is the return on common stockholders' equity? 7. What is the book value per share at the end of this year? 8. What is the amount of working capital and the current ratio at the end of this year? 9. What is the acid-test ratio at the end of this year? 10. What is the accounts receivable turnover? 11. What is the average collection period? 12. What is the inventory turnover? 13. What is the average sale period? 14. What is the time interest earned ratio? 15. What is the debt-to-equity ratio at the end of this year