Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

# 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

**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