Financial Ratio Analysis, assignment help
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 (all ratios listed below) is important for financial decision making.
- 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
Submit your analysis as well as your calculations. So you are going to submit 2 different files.
1. Word document (minimum 1,050 words, The paper—including tables, graphs, and calculations)
2. Excel file showing all the calculations, tables, graphs
APA: Use headlines in the paper starting with introductions and conclusion.
References: minimum 2 peer reviewed references
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
