Question

Preparing a Schedule of Cash Collections on Accounts Receivable

Kailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next five months, the following sales billings are expected:

May	$84,000
June	100,800
July	77,000
August	86,800
September	91,000

Required:

Prepare a schedule showing the cash expected in payments on accounts receivable in August and in September. If an amount box does not require an entry, leave it blank or enter "0". Be sure to enter percentages as whole numbers.

Kailua and Company Schedule
				August		September
June:
$ ×  %				$		$
July:
$ ×  %
$ ×  %
August:
$ ×  %
$ ×  %
September:
$ ×  %
Total cash receipts				$		$

Answer 1

--Requirement

Kailua and Company Schedule
				August		September
June:
$ ×  %	$100,800	x	25%	$25,200		$
July:
$ ×  %	$77,000	x	50%	$38,500
$ ×  %	$77,000	x	25%			$19,250
August:
$ ×  %	$86,800	x	20%	$17,360
$ ×  %	$86,800	x	50%			$43,400
September:
$ ×  %	$91,000	x	20%			$18,200
Total cash receipts				$81,060		$80,850