Industry Competitor Ratios: Appendix D [WLOs: 2, 3] [CLOs: 1, 2]
Ratios are rarely used in isolation. For a good understanding of a companys financial performance, it is important to evaluate the companys 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 companys 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.
Prepare:
Prior to beginning work on this assignment,
- Complete the in Amplifire.
- Review Chapter 11 of .
- Watch the following video:
Construct Appendix D:
Using the database in the university library, and following the instructions in the 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 and submit it to Waypoint.
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.
