50.1K

Verified Solution

Link Copied!

Review the company information in the Course Project Folder on the Learning Modules page. You will need this information to complete this part of the project.

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

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

2) Next you have columns for Amazons 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.

3) Next, you have columns for Wal-Marts ratio calculations and results. In the heading for these columns, indicate the company name and the fiscal year.

Make sure to show your work so I can view your work. 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.

4) Finally, you have a column called Company with the 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 must show all of your calculations for your ratio results. If you do not show your calculations, points will be subtracted from your score. See the instructions above for showing your calculations.

i have the balance Sheet and income statement for both companies , but the website will not allow me to upload docs? Help please

Here is Walmart info -----Balance Sheet & Income statement

https://s2.q4cdn.com/056532643/files/doc_financials/2019/annual/Walmart-2019-AR-Final.pdf (Balance Sheet page 52)

https://s2.q4cdn.com/056532643/files/doc_financials/2019/annual/Walmart-2019-AR-Final.pdf ( Income statement page 50)

Here is Amazon Info

https://s2.q4cdn.com/299287126/files/doc_financials/annual/2018-Annual-Report.pdf (Balance sheet Page 39)

https://s2.q4cdn.com/299287126/files/doc_financials/annual/2018-Annual-Report.pdf ( Income Statement Page 38)

Answer & Explanation Solved by verified expert

See Answer