financial ratio analysis 34
NO PLAGERIASM, MUST BE ORIGINAL WORK!!!
THIS IS A 2 PART ASSIGNMENT
1ST PART WORD DOCUMENT CONSISTING OF NO LESS THAN 1050 WORDS EXPLAINING FINANCIAL DECISIONS.
2ND PART EXCEL SHEET SHOWING ALL RATIOS LISTED BELOW FOR SET COMPANY. PLEASE INCLUDE AL FORMULAS WITHIN THE COLUMNS AS TO SHOW HOW THE ANSWERS CAME ABOUT.
MUST INCLUDE AT LEAST 2 IN TEXT CITATIONS WITH ALL REFERENCES LISTED IN APA FORMAT
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.