Merge & Center % 08 09 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clear Alignment Number F Editing Cells B C D E F G The balance sheet of a firm at the end of 2018 shows balances of $1,400 for inventory, $1,200 for accounts receivable, and $400 for accounts payable. The income statement shows sales of $8,000 and cost of sales of $5,000. Inventory purchases were also $5,000. The firm can finance short-term investments at an annual rate of 6.2%. Create a data input table for the information above. Sales $ || 8,000.00 inventory open $ 1,400.00 Accounts receivable $ 1,200.00 Accounts Payable $ 400.00 Cost of goods sold $ || 5,000.00 inventory purchases $ 1 5,000.00 rate 16.2% average inventory $ 3,200.00 total purchases $ 8,600.00 days 365 Calculate the following val. inventory turnover accounts receivable turnover accounts payable turnover AAI BETERE 1.56 6.67 21.5 ACP 233.6 54.75 29.20 APP Sheet1 ' O MIN e 9