Assignment: Compute the Following Ratios for Two Years
Based on formulas in your textbook or other sources for financial ratios, compute the following ratios for two years. You may use Excel to compute your ratios.
1) Debt ratio
2) Gross profit margin
3) Free cash flow
4) Times interest earned
5) Accounts receivable turnover
6) Inventory turnover
Prepare a DuPont Analysis of ROE for two years, including computations of
1) Return on Sales
2) Asset Turnover
3) Return on Assets
4) Financial Leverage
5) Return on Equity
Write a 3 to 6 pages report evaluating trends in all of the above ratios. Discuss whether your company's profitability, efficiency, liquidity, and solvency are improving or deteriorating. Suggest ways the company can improve the ratios that show problems. The report should be well written with cover page, introduction, body of paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited.
Format your assignment according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.