Week 2 assignment 2 – industry competitor ratios: appendix d | BUS 401 Principles of Finance | Ashford University

DUE AUG 8, 2022 

Industry Competitor Ratios: Appendix D 

Ratios are rarely used in isolation. For a good understanding of a company’s financial performance, it is important to evaluate the company’s ratios relative to the industry in which it operates. For this assignment, you will use Mergent through the university library to download the most recent year of financial ratios for top competitors in your publicly traded company’s industry. You will download the competitor financial ratios into Excel. Once you have these competitor financial ratios in Excel, you will save that Excel sheet as a PDF and submit it to Waypoint.

Using Mergent, https://go.openathens.net/redirector/ashford.edu?url=http%3A%2F%2Fwww.mergentonline.com%2F  database in the university library, and following the instructions in the BUS401 | Retrieving a Company’s Ratios Using Mergent  https://ashford.mediaspace.kaltura.com/media/BUS401+%7C+Retrieving+a+Company%E2%80%99s+Ratios+Using+Mergent/1_snhk6rez video from above complete the following:

• Retrieve the industry competitor ratios for the most recent year.
• Download the competitor ratios you retrieved as an Excel document.
• Calculate the average ratio for the industry for each ratio.
• Format the Excel spreadsheet according to the video instructions.
• Then save competitor ratios as a PDF. Title this PDF file “Appendix D”

The Company Ratios: Appendix D,

• Must contain industry competitor ratios for the most recent year.
• Must include the calculations for the average ratio for the industry for each ratio.