use yahoo finace very easy to find balance sheet and income statment which is all provided on yahoo fiance
My two corporation that I want to compare starbucks and dunkin donuts.
Just follow the instructions in the photos and creat an excel that include the formulas and inputs to show calculations.
make sure to find and calcualte fir both firms : ROA, ROE, Asset turnover, Profit margin , leverage ratio(assets / equity), inventory turnover, average collection period, current ratio, and cash coverage ratio
Use the information from the firm's financial statements to calculate the following 9 ratios of both firms: ROA, ROE, Asset Tumover, 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. Between 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 Why? 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 firms profitability? You may apply the DuPont Identity and also incorporate the industry's characteristics to make your advice reasonable and applicable. Step 1 instructions Step 2: Once you have chosen the pair of companies that you will research, go to name in the Quote Lookup box. Then click on the "Financials" tab to read the financial statements. to research each company by searching the company's The Home Depot, Inc. (HD) 312.219.11(2.84%)313.35+1.14(+0.37%) Use the information from the firm's financial statements to calculate the following 9 ratios of both firms: ROA, ROE, Asset Tumover, 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. Between 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 Why? 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 firms profitability? You may apply the DuPont Identity and also incorporate the industry's characteristics to make your advice reasonable and applicable. Step 1 instructions Step 2: Once you have chosen the pair of companies that you will research, go to name in the Quote Lookup box. Then click on the "Financials" tab to read the financial statements. to research each company by searching the company's The Home Depot, Inc. (HD) 312.219.11(2.84%)313.35+1.14(+0.37%)
