use the yahoo finace to see the income and balance sheet for the two companies i want to compare which are: ebay and etsy

follow the instructions in the photos and create a excel sheet calculating 9 ratios: ROA, ROE, Asset turnover, Profit margin, leverage ratio(assets/ equity), Inventory turnover, Average colection period, Current ratio, and cash coverage ratio

make sur eti show and include the formulas and inputs to show caluclations on the excel spreadsheet please!!

Please read Chapter 4, watch the lecture videos, and understand the ratios before you work on the analysis report. However, you may complete Step 1 before finishing reading. Chapter 4 Discussion analysis report ( 30 points) Step 1 (2 points): Deadline for picking the pair of furms for your analysis: Sep20, Wed, EOD. Step 2 (28 points): Deadline for the analysis report Oct 1, Sun, EOD. Step 1 instructions Step 2: Once you have chosen the pair of companies that you will research, go to yahoo. Einance B to research each company by searchiog the company's name in the Quote Lookup box. Then click on the "Financials" tab to read the financial statements. The Home Depot, Inc. (HD) 312.219.11(2.84%)313.35+1.14(+0.37%) Income Statement Use the information from the firm's financial statements to calculate the following 9 ratios of both firms: ROA, ROE, Asset Turnover, Profit Margin, Leverage ratio (Assets/Equity), Inventory turnover, Average collection period, Current ratio, and Cash coverage ratio. In your posting, please include the following: 1. Screenshots of the companies' balance sheets and income statements ( 3 points) 2. Excel spreadsheets that include the formulas and inputs to show your calculations. (Screenshots of calculations are not acceptable.) (10 points) Analysis report: Please compare the ratios and use your calculated ratios to answer the following questions in details (15 points) a. Btween the two firms, which firm is more profitable and why? b. Which one is more efficient and Why? c. Which one has higher liquidity and Whr? d. Which one has stronger solvency and Why? e. If you could provide some advice to the managers of the less profitable firm, how would you advise them to improve the firm's profitability? You may apply the DuPont Identity and also incorporate the industry's characteristics to make your advice reasonable and applicable