Account balances Consider the changes in the accounts payable, accounts receivable, and cash accounts Use Taccounts to find the missing values. This information has been collected in the Microso Excel Online Nile. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. x2 a. During February 1189,000 was paid to creditors on account, and purchases on account were $211,500. Assuming the February 20 balance of Accounts Payable was $54.200. determine the account balance on February 1 Round your answer to the nearest della 3 b. On October 1, the accounts receivable account balance was $123,600. During October $466,000 was collected from customers on account. Assuming the October 31 balance was 5128,990, determine the fous billed to customers on account during October Round your answer to the nearest dollar 1 con April 1, the cash account balance was 546,190 During April, cash receipts totaled $250,000 and the Apel 30 balance was $61,540. Determine the cash payments made during April. Round your answer to the nearest dollar 5 D E Account balances The following data are available for the changes in the accounts payable, accounts receivable, and cash accounts. Consider each case independently Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (C10, C16, C22) into the appropriate fields in CNOWV2 for grading a. Payments on account during February $189.000 Purchases on account during February $211,500 February 28 balance of Accounts Payable $64,200 Amount Formula Accounts Payable account balance on February 1 b. Balance of Accounts Receivable on October 1 $123,600 Collections on account during October $466,800 Balance of Accounts Receivable on October 31 $128.990 Amount Formula Foos billed to customers on account during October 0 Balance of Cash on April 1 $46,190 Cash receipts during April 5256,800 Balance of Cash on April 30 $61,540 Amount Formula Cash payments made during April 1