Question: Create one chart in Excel that shows your ratio calculations for both companies. Use the template provided. Show your work! The first column lists the
Create one chart in Excel that shows your ratio calculations for both companies. Use the template provided.
- Show your work! The first column lists the name of each ratio youre calculating. In your chart, you need to compute all of these ratios for both companies:
- Current ratio
- Accounts Receivables turnover
- Average collection period
- Inventory turnover
- Days in inventory
- Profit margin
- Asset turnover
- Return on assets
- Return on common stockholders equity
- Debt to total assets ratio
- Times interest earned
- Free cash flow
- For Amazon, go to the companys investor website, scroll down and click on SEC Filings at the left side of the page and click on Group: and select Annual reports. Click on Filing Year and select the year 2021 (filed Feb 3, 2021). From there, you will be able to view the financial statements in PDF, Excel, etc.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
