Question: Someone please help with the highlighted question! Thank you! Step #3 : Retrieve the following financial variables to calculate the financial ratios for 10 years
Someone please help with the highlighted question! Thank you!






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 liabilitie:s 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 computed. 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 liabilitie:s 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 computed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
