Homework answers / question archive / Create one chart in Excel that shows your ratio calculations for both companies

Create one chart in Excel that shows your ratio calculations for both companies

Accounting

Share With

Create one chart in Excel that shows your ratio calculations for both companies. Use the template provided.

1. Next you have columns for Amazon’s ratio calculations and results. In the heading for these columns, indicate the company name and fiscal year. Make sure to show your work, so I can view your work and award partial credit if applicable. Round your answers to 2 decimal places. Also, make notes for each calculation as to where you found the information. This will help you obtain partial information if appropriate.
2. Next, you have columns for Wal-Mart’s ratio calculations and results. In the heading for these columns,
3. Finally, you have a column called More Favorable Result. In this column you will identify which company has the more favorable result for each ratio and why it is more favorable. You only need to type in the company with the best ratio here.

Please save the file as an Excel document (.xlsx)