Exercise 14-3 Preparing a schedule of cash receipts LO 14-2

The budget director of Heathers Florist has prepared the following sales budget. The company had $210,000 in accounts receivable on July 1. Heathers Florist normally collects 100 percent of accounts receivable in the month following the month of sale.

Required

1. Complete the schedule of cash receipts by filling in the missing amounts.

2. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

Required A

Complete the schedule of cash receipts by filling in the missing amounts.

	July	August	September
Sales Budget
Cash sales	$72,000	$83,000	$75,000
Sales on account	86,000	107,000	130,600
Total budgeted sales	$158,000	$190,000	$205,600
Schedule of Cash Receipts
Current cash sales
Plus: Collections from account receivable
Total budgeted collections	$282,000	$169,000	$182,000

• Required B

Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.

Accounts receivable