Overview
Part 3: Complete using MS Excel – up to 25 points (You can create in Google Sheets and then save as an Excel sheet to submit)
In ARP part #2, you prepared horizontal and vertical analysis. In this part, you will prepare ratio analysis. Refer to Chapter 13 of the text for a summary of the ratios. You may also refer to the chapters where the ratios were originally covered in the text.
For the past two years (2023 & 2022), calculate Ratios summarized in EXHIBIT 13.16 using Excel. Be sure to use Excel formulas in the cells where you are making computations. Typing computational results in the cells is not acceptable and will result in zero points. Failure to do so will be an automatic deduction of points. Failure to have your name and company name typed in the left-hand corner or added as a header on every page will result in point deductions. This part is worth twenty-five points.
You did part 2 for me and here is part 3 of that assignment. If you have any other questions or need me to send part 1 and 2 of this assignment let me know!