Question

Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget.

1. Beginning cash balance on June 1, $94,300.
2. Cash receipts from sales, $414,500.
3. Budgeted cash disbursements for purchases, $269,500.
4. Budgeted cash disbursements for salaries, $95,300.
5. O ther budgeted cash expenses, $57,300.
6. Cash repayment of bank loan, $32,300.
7. Budgeted depreciation expense, $34,300.

A) $111,700 B) $54,400 C) $86,700 D) $77,400

Answer 1

The correct answer is:

$54,400 (B)

Step-by-step explanation:

In order to calculate the ending balance, we have to group the entries into income and expenditure, and compute the difference between them. However please note that the question asked us to calculate for the cash balance, hence the entry titled 'budget depreciation expense' will not be used for the calculation, because it is not a cash transaction.

particulars income($) expenditure($)

Beginning cash balance 94,300 -

cash receipt from sales 414,500 -

purchase disbursement - 269,500

salaries disbursement 95,300

other cash expenses 57,300

cash loan repayment 32,300

Total 508,800 454,400

Balance = Total income - Total expenditure

508,800 - 454,400 = $54,400