Financial Ratio Analysis
Assignment Format: The assignment must be submitted as a single Excel file. Only one file (Excel) is to be submitted with all work. Discussions must be justified in the cells, so that all columns are viewable in screen view. Assignment Steps Select a Fortune 500 Company from one of the following industries: Pharmaceutical, Energy, Retail, Automotive, or 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, and Return on Assets Ratio. To receive credit for this portion, you must submit your excel file, showing your formula/calculations for these ratios. In the same excel file with your ratios, on the same sheet, below your calculation for each ratio, in approximately 100 words for each ratio, develop why this ratio is important for financial decision making. In your discussion, develop how to interpret the ratio, and what the ratio results for your company tell you about the financial position of this company. Justify your data so all columns appear in the screen view.