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 you're calculating.

In your chart you need to compute all of these ratios for both companies:

CURRENT RATIO

ACCOUNTS RECIEVABLES TURNOVER

AVERAGE COLLECTION PERIOD

INVENTORY TURNOVER

DAYS IN INVENTORY

PROFIT MARGIN

ASSET TURNOVER

RETURN ON ASSETS

RETURN ON COMMON STOCK HOLDERS EQUITY

DEBT TO TOTAL ASSETS RATIO

TIMES INTEREST EARNED

FREE CASH FLOWS

Here are the balance sheets and income statements for Amazon and Walmart

here is the template we have to use.

ive added imcome statement twice.

AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (in millions) Year Ended December 31, 2017 2018 3,033 $ 10,073 $ 2019 $ 11,588 533 (538) 78 (108) (30) 533 (538) Net income Other comprehensive income (loss): Net change in foreign currency translation adjustments: Foreign currency translation adjustments, net of tax of $5, S6, and S(5) Reclassification adjustment for foreign currency translation included in "Other operating expense (income), net," net of tax of so, so, and $29 Net foreign currency translation adjustments Net change in unrealized gains (losses) on available-for-sale debt securities: Unrealized gains (losses), net of tax of $5, 50, and S(12) Reclassification adjustment for losses (gains) included in "Other income (expense), net," net of tax of SO, SO, and SO Net unrealized gains (losses) on available-for-sale debt securities Total other comprehensive income (loss) Comprehensive income (39) (17) 83 7 8 (4) (32) 501 3,534 $ (9) (547) 9.526 S 79 49 11.637 See accompanying notes to consolidated financial statements. AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) December 31, 2018 2019 $ 31,750 S 9,500 17,174 16,677 75,101 61,797 36,092 18,929 20,497 20,816 96,334 72,705 25.141 14,754 16,314 225.248 14,548 11,202 162,648 S s s ASSETS Current assets Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Operating leases Goodwill Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Accrued expenses and other Uneamed revenue Total current liabilities Long-term lease liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, So 01 par value Authorized shares 500 Issued and outstanding shares- none Common stock, S0.01 par values Authorized shares - 5,000 Issued shares_514 and 521 Outstanding shares- 491 and 498 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders equity 38,192 s 23,663 6,536 68,391 9,650 23.495 17,563 47,183 32,439 8,190 87,812 39,791 23,414 12.171 5 (1,837 26,791 (1035) 19,625 13549 162.618 5 (1.837) 33,658 (986) 31.220 225.248 Walmart Inc. Consolidated Statements of Comprehensive Income (Amounts in millions) Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart $ Fiscal Years Ended January 31, 2019 2018 2017 7,179 S 10,523 14,293 (509) (661) (650) 6,670 9,862 13,643 (226) 272 (290) 131 Other comprehensive income (loss), net of income taxes Currency translation and other Net investment hedges Cash flow hedges Minimum pension liability Unrealized gain on available for sale securities Other comprehensive income (loss), net of income taxes Other comprehensive (income) loss attributable to noncontrolling interest Other comprehensive income (loss) attributable to Walmart Comprehensive income, net of income taxes Comprehensive (income) loss attributable to noncontrolling interest Comprehensive income attributable to Walmart 2.540 (405) 437 147 1,501 4.220 (169) 4051 (3,027) 413 21 (397) 145 (2,845) 210 (2.635) (113) 188 75 7,066 (321) 6.745 14,743 (830) 13.913 11,448 (440) 11.008 S See accompanying notes Walmart Inc. Consolidated Balance Sheets As of January 31, 2019 2018 S 6,756 (Amount in millions) ASSETS Current assets Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net 7,7225 6,283 44.269 3.623 61,897 5.614 43,783 3,511 59,664 185,810 185.154 (77.479 107,675 104,317 12,760 (5.682) 7.078 12.703 (5,560) 7.143 18,242 Goodwill Other long-term assets Total assets 31,181 1402 219,295 11.79 5 204522 $ 5225 5 47.060 22.159 5.257 46.092 22.122 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities 545 1.876 3.738 77,477 43520 Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other 30.045 6,70 8.354 11.981 Commitments and contingencies 2.965 0.75 Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest 295 264 107 (1018 779 2953 7.135 79.534 $ 219 295 5 Total equity Total liabilities and equity 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 you're 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 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. 3) Next, you have columns for Wal-Mart's 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 riee can now 2) 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. 3) Next, you have columns for Wal-Mart's 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, male 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 our crore See the instructions above for showing your calculations. E Annual Report Course Project - Part 1 F Walmart's Ratio results - 20xx fiscal yea Calculation2 Result2 Amazon's ratio results - 20XX fiscal year Criteria Calculation Result Current ratio Accounts receivable turnover Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholder's equity Debt to total assets ratio Times interest earned Free cash flow Work Space