Select a Fortune 500 company from one of the following industries:AdminRATIO ANALYSIS: CVS PHARMACYWould prefer to do this on CVS PharmacyAssignment ContentResourcesFinancial Ratio Analysis Grading GuideMicrosoft® Excel®Purpose of AssignmentThe 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 StepsSelect a Fortune 500 company from one of the following industries:PharmaceuticalEnergyRetailAutomotiveComputer HardwareReview the balance sheet and income statement in the company’s 2015 Annual Report. Calculate the following ratios using Microsoft Excel:Current RatioQuick RatioDebt Equity RatioInventory Turnover RatioReceivables Turnover RatioTotal Assets Turnover RatioProfit Margin (Net Margin) RatioReturn on Assets RatioAnalyze in 1,050 words why each ratio is important for financial decision making. Submit your analysis as well as your calculations.I think everything is included, but would really like this done on CVS if possible.10 hours agoATTACHMENTSAnswer preview……….apa 1134 words $16.00 – Purchase Checkout Added to cart Share this paper