FIN571 University of Phoenix CVS Pharmacy Financial Ratio Analysis

Would prefer to do this on CVS Pharmacy

Assignment Content

1. Resources

   • Financial Ratio Analysis Grading Guide
   • Microsoft^® Excel^®

   Purpose of Assignment

   The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions.

   Assignment Steps

   Select a Fortune 500 company from one of the following industries:

   • Pharmaceutical
   • Energy
   • Retail
   • Automotive
   • Computer Hardware

   Review the balance sheet and income statement in the company’s 2015 Annual Report.
   Calculate the following ratios using Microsoft Excel:

   • Current Ratio
   • Quick Ratio
   • Debt Equity Ratio
   • Inventory Turnover Ratio
   • Receivables Turnover Ratio
   • Total Assets Turnover Ratio
   • Profit Margin (Net Margin) Ratio
   • Return on Assets Ratio

   Analyze in 1,050 words why each ratio is important for financial decision making.
   Submit your analysis as well as your calculations.