FIN571 University of Phoenix CVS Pharmacy Financial Ratio Analysis

Description

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.