1.Save the spreadsheet you downloaded from your WileyPLUS course or that your instructor provided. On the first tab, you'll see the data needed for this assignment. On the second tab (Ratios- Student Submission) the first four columns of data have been copied over for you. Please use columns E-W to submit your answers.

2.Use the select data (tab 1) from most of the DOW 30 companies (excluding some financial and other companies) to calculate liquidity, activity, profitability and coverage ratios. (Reminder, do it on tab 2-Ratios- Student Submission)