Assignment ContentResourcesFinancial Ratio Analysis Grading GuideMicrosoft® Excel® Purpose of AssignmentThe purpose of this assignment is to help students gain a better understanding of the financi

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.

   Resources

   • Center for Writing Excellence
   • Reference and Citation Generator
   • Grammar and Writing Guides