Hello I am needing help with calculating the Inventory Ratios and what to do on Q2 and so forth. 

 
 

Transcribed Image Text:

AutoSave Inventory Analysis (Empty) Formulas Data Review View Automate Tell me Home Insert Draw Page Layout A1 fx AMAZON.COM INC A 1 2 3 4 5 6 ASSETS: 7 Current Assets: 8 Cash 9 Accounts receivable 10 Inventory 11 Other current assets 12 Total Current Assets 13 Non-Current Assets: 14 Property, plant, and equipment 15 Intangible assets 16 Other non-current assets 17 Total Non-Current Assets 18 TOTAL ASSETS 19 20 LIABILITIES: 21 Current Liabilities: Accounts payable 22 23 Deferred revenue 24 Short-term debt 25 Other current liabilities B C D E F G H | J K L M N 2022 AMAZON.COM INC Balance Sheet (in millions of dollars) 2021 2020 2019 2018 2017 $ 70,384.0 34,800.0 $ 96,291.0 26,500.0 $ 84,629.0 $ 19,981.0 17,663.0 55,297.0 $ 41,668.0 13,310.0 $ 32,315.0 9,692.0 33,457.0 31,758.0 22,943.0 19,868.0 16,655.0 16,047.0 8,150.0 7,031.0 5,180.0 3,506.0 3,468.0 2,143.0 146,791.0 161,580.0 132,733.0 96,334.0 75,101.0 60,197.0 252,838.0 26,385.0 216,363.0 20,478.0 150,667.0 97,846.0 61,797.0 48,866.0 19,998.0 18,803.0 18,658.0 16,721.0 36,661.0 315,884.0 22,128.0 258,969.0 17,797.0 12,265.0 7,092.0 5,526.0 188,462.0 128,914.0 87,547.0 71,113.0 $ 462,675.0 $ 420,549.0 $ 321,195.0 $ 225,248.0 $ 162,648.0 $ 131,310.0 79,600.0 78,664.0 72,539.0 47,183.0 38,192.0 34,616.0 18,627.0 17,027.0 14,408.0 11,490.0 9,336.0 8,097.0 23,120.0 17,162.0 16,951.0 14,330.0 9,502.0 6,221.0 34,046.0 29,413.0 22,487.0 14,809.0 11,361.0 8,949.0 $ 142,266.0 $ 126,385.0 $ 87,812.0 $ 68,391.0 $ 57,883.0 122,595.0 17,443.0 140,038.0 87,789.0 13,617.0 101,406.0 63,205.0 39,787.0 37,926.0 12,171.0 75,376.0 10,921.0 50,708.0 $ 316,632.0 $ 282,304.0 $ 227,791.0 $ 163,188.0 $ 119,099.0 7,792.0 45,718.0 $ 103,601.0 26 Total Current Liabilities 27 Non-Current Liabilities: Long-term debt 28 29 Other non-current liabilities $ 155,393.0 146,818.0 14,421.0 161,239.0 30 Total Non-Current Liabilities 31 TOTAL LIABILITIES 32 33 OWNERS' EQUITY: 34 Common Stock 35 Retained Earnings 36 Other Equity 37 TOTAL OWNER'S EQUITY 38 39 TOTAL LIABILITIES & OWNER'S EQUITY 40 41 42 Footnotes: 67,337.0 78,706.0 53,706.0 84,539.0 41,033.0 52,371.0 31,826.0 30,234.0 24,959.0 18,590.0 19,557.0 8,152.0 $ 146,043.0 $ 138,245.0 $ 93,404.0 $ 62,060.0 $ 43,549.0 $ 27,709.0 $ 462,675.0 $ 420,549.0 $ 321,195.0 $ 225,248.0 $ 162,648.0 $ 131,310.0 Allowance for uncollectible accounts (in millions of 43 dollars) $ 1,400.0 $ 1,100.0 $ 1,100.0 $ 718.0 $ 495.0 S 348.0 44 45 Instructions Balance Sheet o P Q R S Comments Share T U V W BD Income Statement Q1) Inventory Ratios Q2) Gross Profit Ratio Q3) Inventory Turnover Ratio Q4) Average Days in Inventory + E + 100% Select destination and press ENTER or choose Paste AutoSave Inventory Analysis (Empty) Formulas Data Review View Automate Tell me Home Insert Draw Page Layout A1 fx AMAZON.COM INC A 1 2 3 4 5 6 ASSETS: 7 Current Assets: 8 Cash 9 Accounts receivable 10 Inventory 11 Other current assets 12 Total Current Assets 13 Non-Current Assets: 14 Property, plant, and equipment 15 Intangible assets 16 Other non-current assets 17 Total Non-Current Assets 18 TOTAL ASSETS 19 20 LIABILITIES: 21 Current Liabilities: Accounts payable 22 23 Deferred revenue 24 Short-term debt 25 Other current liabilities B C D E F G H | J K L M N 2022 AMAZON.COM INC Balance Sheet (in millions of dollars) 2021 2020 2019 2018 2017 $ 70,384.0 34,800.0 $ 96,291.0 26,500.0 $ 84,629.0 $ 19,981.0 17,663.0 55,297.0 $ 41,668.0 13,310.0 $ 32,315.0 9,692.0 33,457.0 31,758.0 22,943.0 19,868.0 16,655.0 16,047.0 8,150.0 7,031.0 5,180.0 3,506.0 3,468.0 2,143.0 146,791.0 161,580.0 132,733.0 96,334.0 75,101.0 60,197.0 252,838.0 26,385.0 216,363.0 20,478.0 150,667.0 97,846.0 61,797.0 48,866.0 19,998.0 18,803.0 18,658.0 16,721.0 36,661.0 315,884.0 22,128.0 258,969.0 17,797.0 12,265.0 7,092.0 5,526.0 188,462.0 128,914.0 87,547.0 71,113.0 $ 462,675.0 $ 420,549.0 $ 321,195.0 $ 225,248.0 $ 162,648.0 $ 131,310.0 79,600.0 78,664.0 72,539.0 47,183.0 38,192.0 34,616.0 18,627.0 17,027.0 14,408.0 11,490.0 9,336.0 8,097.0 23,120.0 17,162.0 16,951.0 14,330.0 9,502.0 6,221.0 34,046.0 29,413.0 22,487.0 14,809.0 11,361.0 8,949.0 $ 142,266.0 $ 126,385.0 $ 87,812.0 $ 68,391.0 $ 57,883.0 122,595.0 17,443.0 140,038.0 87,789.0 13,617.0 101,406.0 63,205.0 39,787.0 37,926.0 12,171.0 75,376.0 10,921.0 50,708.0 $ 316,632.0 $ 282,304.0 $ 227,791.0 $ 163,188.0 $ 119,099.0 7,792.0 45,718.0 $ 103,601.0 26 Total Current Liabilities 27 Non-Current Liabilities: Long-term debt 28 29 Other non-current liabilities $ 155,393.0 146,818.0 14,421.0 161,239.0 30 Total Non-Current Liabilities 31 TOTAL LIABILITIES 32 33 OWNERS' EQUITY: 34 Common Stock 35 Retained Earnings 36 Other Equity 37 TOTAL OWNER'S EQUITY 38 39 TOTAL LIABILITIES & OWNER'S EQUITY 40 41 42 Footnotes: 67,337.0 78,706.0 53,706.0 84,539.0 41,033.0 52,371.0 31,826.0 30,234.0 24,959.0 18,590.0 19,557.0 8,152.0 $ 146,043.0 $ 138,245.0 $ 93,404.0 $ 62,060.0 $ 43,549.0 $ 27,709.0 $ 462,675.0 $ 420,549.0 $ 321,195.0 $ 225,248.0 $ 162,648.0 $ 131,310.0 Allowance for uncollectible accounts (in millions of 43 dollars) $ 1,400.0 $ 1,100.0 $ 1,100.0 $ 718.0 $ 495.0 S 348.0 44 45 Instructions Balance Sheet o P Q R S Comments Share T U V W BD Income Statement Q1) Inventory Ratios Q2) Gross Profit Ratio Q3) Inventory Turnover Ratio Q4) Average Days in Inventory + E + 100% Select destination and press ENTER or choose Paste