BE$,02\mathrm{.}08.$EXCEL.ALGO

EX$\mathrm{.}02\mathrm{.}11.$EXCEL.ALGO

Account balances

Consider the changes in the accounts payable, accounts receivable, and cash accounts. Use $T$ accounts to find the missing values. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

a$.$ During February, $$187,000$ was paid to creditors on account, and purchases on account were $$203,400.$ Assuming the February $28$ balance of Accounts Payable was $$57,300,$ determine the account balance on February $1.$

$ $x$

b$.$ On October $1,$ the accounts receivable account balance was $$117,600.$ During October, $$447,600$ was collected from customers on account. Assuming the October $31$ balance was $$137,240,$ determine the fees billed to customers on account during October. $

C$.$ On April $1,$ the cash account balance was $$44,340.$ During April, cash receipts totaled $$253,100$ and the April $30$ balance was $$52,350.$ Determine the cash payments made during April. $

Feedback

T Check My Work

Progress: $\frac{2}{2}$ items

Previous

Assignment Score: $0\mathrm{.}0\%$