A. Open a new spreadsheet tab and name the tab “Mergent Ratios”.
B. Download the Mergent Online “ratios” for the most recent FIVE years for Your Company.
C. Compare the “Mergent Online” ratios to your FASP 9e ratios on the “Analysis” tab in the FASP 9e spreadsheet file, rows 23 – 43 and 77 – 101. That is, check to see if your FSAP 9e ratios agree with the ratios in Mergent Online for your company.
D. Investigate and explain any differences between the FSAP 9e ratios on the “Analysis” tab and Mergent Online ratios.
2. Review the “PROFITABILITY FACTORS” and “RISK FACTORS” ratios in the “Analysis” tab in rows 23 – 43 and 77 – 101.
3. Create another new spreadsheet tab titled “Ratio Trends”.
A. In this tab prepare a written analysis of the trends in the ratios on the “Analysis” tab in rows 23 – 43 and 77 – 101, over the five-year period.
B. Your written analysis must include a discussion of the trends for each of the “PROFITABILITY FACTORS” and “RISK FACTORS” ratios in the “Analysis” tab over the five-year period.
C. In your comments, provide a reason or reasons why these trends may have occurred.
