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.
Resources Required
Microsoft® Excel®
Content
Met
Partially Met
Not Met
Comments:
Selected a Fortune 500 Company from one of the following industries:
Pharmaceutical
Energy
Retail
Automotive
Computer Hardware
Reviewed the balance sheet and income statement in the company’s 2015 Annual Report.
Calculated 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