Someone please help with step 4! Answer in full detail please!

Step # 3 : Retrieve the following financial variables to calculate the financial ratios for 10 years ( from year 2008 to year 2017 ) and create their time - series plots of each ratio to see the 10 - year trend ( using Excel graph format ) Cash and cash equivalents over current liabilities cash and cash equivalents , current liabilities Receivables turnover ratio , Average collection period accounts receivable , sales revenue Inventory turnover ratio , Average days in inventory inventory , cost of goods sold Return on assets : net income before extraordinary , total assets Current ratio : current assets , current liabilities Debt to equity ratio : total liabilities , stockholders equity Return on equity : net income before extraordinary Step # 4 : Obtain the industry ratios above from the WRDS Analytics ( Financial ratios suite under Fama French 30 Industries ) , and evaluate with comparison and comments each company 's ratios with the industry ratios as well as the average of three companies computedConsolidation - Global Company Data Year - Industry Company Population Data Ticker Current Assets Key Data Date Fiscal Format Annual Source Symbol ISO Currency Code Total 3144 20081231 2008 INDL C D STD KO USD 12176 3144 20091231 2009 INDL STD KO USD 17551 3144 20101231 2010 INDL STD USD 21579 3144 20111231 2011 |INDL STD USD 25497 3144 20121231 2012 INDL STD USD 30328 3144 20131231 2013 INDL STD USD 31304 6 6 6 6 3144 20141231 2014 INDL STD USD 32986 3144 20151231 2015 INDL STD USD 33395 3144 20161231 2016 INDL STD USD 34010 3144 20171231 2017 INDL STD KO USD 36545 847 20081231 200 08 INDL STD PEP USD 10806 8479 20091231 2009 INDL STD PEP USD 12571 8479 20101231 2010 INDL STO PEP USD 17569 8479 20111231 2011 |INDL STD PEP USD 17441 8479 20121231 2012 INDL STD PEP USD 18720 8479 20131231 2013 INDL STD PEP USD 22203 8479 20141231 2014 INDL STD PEP USD 20663 8479 20151231 2015 INDL STD PEP USD 23031 8479 20161231 2016 INDL STD PEP USD 27089 8479 20171231 2017 INDL STD PEP USD 31027Global Company Key Assets - Total Cash Items Income Before Extraordinary Inventories - Total Current Liabilities - Other - Total Current Liabilities - Total Liabilities - Total Receivables - Revenue - Total Total 3144 40519 4701 5807 2187 4835 12988 19664 3090 31944 3144 48671 7021 6824 2354 5247 13721 23325 3758 30990 314 72921 8517 11809 2650 6972 18508 41604 4430 35119 3144 79974 12803 8572 3092 6837 24283 48053 4920 46565 3144 36174 8442 9019 3264 7507 27821 5300 4759 48017 3144 90055 10414 8584 3277 7644 27811 4873 46854 3144 92023 8958 7098 3100 720 32374 61462 7998 4466 45998 3144 90093 7309 7351 2902 26930 64329 3941 442 3144 87270 8555 6527 2675 7518 26532 64050 3856 41863 3144 87896 6006 1181 2655 7993 27194 6891 3667 35410 8479 35994 2064 5142 2522 5427 8787 23888 4683 43251 8479 39848 3943 5946 2618 5246 8756 22406 4624 43232 8479 581 5943 6320 3372 7058 15892 46677 6323 5783 38 8479 72882 4067 6443 3827 7674 18154 51983 6912 56504 8479 74638 6297 6178 3581 7452 17089 52239 7041 65492 8479 77478 9375 6740 3409 765 17839 53089 695 66415 8479 70509 6134 6513 3143 7889 18092 52961 6651 66683 8479 69667 9096 5452 2720 7961 17578 57637 6437 63056 8479 74129 9158 6329 2723 8085 21135 62930 6694 62799 8479 79804 10610 4857 2947 8290 20502 68823 7024 63525Global Company Key Current Liabilities - Total Liabilities - Total Receivables . Revenue Stockholders Equity - Active/Inactive Status Cost of Goods Total Total Parent Marker Sold 3144 12988 19664 3090 31944 20472 A 10308 3144 13721 23325 3758 30990 24799 A 10002 3144 18508 41604 4430 35119 31003 A 11132 3144 24283 48053 4920 46565 31635 A 16322 3144 27821 53006 4759 48017 32790 A 17157 3144 27811 56615 4873 46854 33173 A 16513 3144 32374 61462 4466 45998 30320 A 15985 3144 26930 64329 3941 44294 25554 A 15573 3144 26532 64050 3856 41863 23062 A 14729 3144 27194 68919 3667 35410 17072 A 12035 8479 8787 23888 4683 43251 12106 A 18841 8479 8756 22406 4624 43232 16804 A 18599 8479 15892 46677 6323 57838 21164 A 24056 8479 18154 51983 6912 66 20588 A 29071 8479 17089 52239 7041 65492 22294 A 28 8479 17839 53089 54 66415 24279 A 28771 8479 18092 52961 6651 66683 17438 A 28443 8479 17578 57637 6437 63056 11923 A 26136 8479 21135 62930 6694 62799 11095 A 25911 8479 20502 68823 7024 63525 10889 A 26484Cash and Cash Equivalents Recievables Turnover Inventory Turnover Debt-to- Ticker Symbol and Year Over Current Liabilities Ratio Ratio Return on Assests Current Ratio Equity Ratio Return on Equity KO (2008) KO (2009) 1.39277921 9.050817757 5.049075065 0.153021639 1.314238646 1.030461 3.926688307 KO (2010) 1.394058434 8.578163166 5.013329152 0.194239753 1.339104533 1.49112935 3.327751838 KO (2011) 1.854297922 9.960427807 5.189270243 0.112129239 1.191699189 1.53430825 3.104361906 KO (2012) 1.177077524 9.921892758 5.282051282 0.108565857 1.164133272 1.64551028 3.728042749 KO (2013) 1.37469474 9.728820598 4.515947467 0.0974187 1.125395456 1.71656838 3.769016645 KO (2014) 1.206708426 9.850733483 7.278732857 0.077966586 1.096153527 1.93602444 3.866853718 KO (2015) 0.96164726 10.5374093 7.236964981 0.080728766 1.126230946 2.30264524 3.537130597 KO (2016) 1.102732663 10.73823265 8.032053422 0.073600469 1.272305563 2.634935 3.32353365 KO (2017) 0.774418155 9.413797687 8.0763995 0.013484352 1.360421397 3.43444461 4.429683446 PEP (2008) PEP (2009) 0.738873794 9.290211669 7.236964981 0.156799662 1.433164225 1.55005189 2.739931518 PEP (2010) 0.966027308 10.56691331 8.032053422 0.117035953 1.42559234 2.45875474 3.316461647 PEP (2011) 0.552131415 10.04971666 8.0763995 0.091367391 1.024555014 2.49008431 3.26249901 PEP (2012) 0.832606109 9.38751523 7.775917927 0.083758134 1.06233862 2.43640688 3.451617898 PEP (2013) 1.240817947 9.4 491246874 8.23204578 0.088616582 1.271358223 2.27981878 3.663925149 PEP (2014) 0.789040391 9.802719588 8.682234432 0.088021245 1.150148896 2.53906081 2.914834935 PEP (2015) 1.147760252 9.635696822 8.915572233 0.077787924 1.291337258 3.92609244 2.024106612 PEP (2016) 1.141468279 9.564998858 9.520852471 0.088027483 1.399478211 5.46789469 1.983729662 PEP (2017) 1.295877863 9.261554162 9.341798942 0.063105377 1.490357134 6.26118996 4.48383776Cash and Cash Equivalents Over Recievables Turnover Ratio (KO) Current Liabilities (KO) Inventory Turnover Ratio (KO) 12 LD 2 10 1.5 8 1 st 0.5 2 0 0 1 2 3 6 9 10 1 2 9 10 1 3 6 8 10 Cash and Cash Equivalents Over Recievables Turnover Ratio (PEP) Inventory Turnover Ratio (PEP) Current Liabilities (PEP) 11 10 OLD 1.4 10.5 1.2 1 10 0.8 0.6 9.5 0.4 6 0.2 0 8.5 1 3 6 7 9 3 5 6 8 9Return on Assets ( KO ) Current Ratio ( KO ) Debt to - Equity Ratio ( KO ) Return on Equity ( KO ) Return on Assets ( PEP ) Current Ratio ( PEP ) Debt - to - Equity Ratio ( PEP ) Return on Equity ( PEP )