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.

  1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f