How would i go about findinf question number 2 in excel? I need the excel formula for liquidity, activity, coverage ratio, and profitability.
1. Save the spreadsheet you downloaded with a new name. 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 this on tab 2-Ratios. Student Submission) be 17311 Us Om an ent BY THE S. RS or PE HUN Pata HUS BELIT De . ME D RO NA US Mi H ner tw ce UN SE BEX Os INS . IRO COS 15 43 LAS i ES PRON RF N 0.000 NO 1 MEN O ! WWF re 14.30 DEN MET NE 1 HOT 127 land I AN 438 BUNI 1 IN BUSS 401 HUN LRT PR CATE F ws F 13 12411 430 E . 11 1 5 we FREE UNE 6 1 1. rah F 1 BH MUR ne O 1 SA IN cam hod SESE CA V w LE ht IF TE IT LI 1 WWE . LS 1 1 HE IM w TE TE 1 RI 1 F 1 w ER TE 1 www 1 1 t - MARE LE 1. 1. N 1 TW TER NE 1 TRI H S 41 IN NH 5 ZOOM + 3 ota Page al TI NE IM NE NO ME 11 1 UN LE 1 SIT 1 LEN F 2 1 HT 11 LEN 1 IM SORT TOTT E 1 M THE 91 13 PIE NE 16 1 ARAN BUTY 1 . URE DICE ET REN w 1 ME 1 ET 1 1 IRL NET 1 asts a ZOOM + Q of 3 Page CLA 1. Save the spreadsheet you downloaded with a new name. 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 this on tab 2-Ratios. Student Submission) be 17311 Us Om an ent BY THE S. RS or PE HUN Pata HUS BELIT De . ME D RO NA US Mi H ner tw ce UN SE BEX Os INS . IRO COS 15 43 LAS i ES PRON RF N 0.000 NO 1 MEN O ! WWF re 14.30 DEN MET NE 1 HOT 127 land I AN 438 BUNI 1 IN BUSS 401 HUN LRT PR CATE F ws F 13 12411 430 E . 11 1 5 we FREE UNE 6 1 1. rah F 1 BH MUR ne O 1 SA IN cam hod SESE CA V w LE ht IF TE IT LI 1 WWE . LS 1 1 HE IM w TE TE 1 RI 1 F 1 w ER TE 1 www 1 1 t - MARE LE 1. 1. N 1 TW TER NE 1 TRI H S 41 IN NH 5 ZOOM + 3 ota Page al TI NE IM NE NO ME 11 1 UN LE 1 SIT 1 LEN F 2 1 HT 11 LEN 1 IM SORT TOTT E 1 M THE 91 13 PIE NE 16 1 ARAN BUTY 1 . URE DICE ET REN w 1 ME 1 ET 1 1 IRL NET 1 asts a ZOOM + Q of 3 Page CLA