Week4Perform_Question6 - Microsoft Excel X ? -0 X File Home Insert Page Layout Formulas Data Review View E AutoSum Cut Calibri 11 AA Wrap Text Text Accent2 Accent3 Accent4 Fill Copy Paste BIU- -BA Merge & Center $ * % " Conditional Format as Accent Accento Comma Insert Delete Format Sort & Find & 2 Clear Format Painter Formatting * Table Filter . Select Clipboard Font Alignment Number Styles Cells Editing 45 The following information was taken from the accounting records for Aurora Manufacturing, Inc. A B D E G H K M N O P Q R S Formula: Add, Divide, Subtract; Cell Referencing J N Chapter 12. AP12.3. Using Excel to Perform Analytical Procedures Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with The following information was taken from the accounting records for Aurora Manufacturing, Inc. cell references to the Problem and work areas as indicated co a. Calculate the following information and ratios for years 2, 3, 4, and 5. 10 Year 5 Year 4 Year Year 2 Year 1 Year 5 Year 4 Audited Year 3 Audited Year 2 Audited 11 Unaudited Audited Audited Audited Audited Unaudited 12 Inventory $ 525,000 $ 460,000 $ 390,000 $ 310,000 $ 225,000 Purchases 13 Current assets 1,350,000 1,175,000 950,000 750,000 600,000 14 Accounts payable 115,000 113,000 97,500 85,000 70,000 Accounts payable turnover 15 Current liabilities 545,000 535,000 440,000 380,000 320,000 16 Sales 2,700,000 2,050,000 1,750,000 1,400,000 1,200,000 Accounts payable turnover 17 Cost of goods sold 1,650,000 1,225,000 1,025,000 850,000 725,000 in days 18 19 Industry Median Cost of goods sold to 20 Accounts payable turnover days 31 30 29 30 average accounts payable 21 Cost of goods sold to average 10.7 11.2 10.9 11.1 22 accounts payable Current ratio 23 Current ratio 1.9 2.2 2.3 2.1 24 25 26 27 28 29 30 31 32 33 1 4 ) Enter Answer + Ready : 0 90% 1 89F X 8:40 AM Partly sunny Q Search 20 w 9/29/2024