Corporate Finance
Excluding the reference and the excel file, word count cannot exceed 1050,
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
Note: All ratios must be calculated using Excel. Show all data inputs. Show all calculations. You will not receive grading points for ratios not calculated in your Excel worksheet(s). Do not submit more than one Excel file. The best approach is to use one or more tabs for input financial statements and a separate tab for the ratios.
Analyze in 1,050 words why each ratio is important for financial decision making.
Submit your analysis as well as your calculations.