Preparing a schedule of cash receipts
The budget director of Camila’s Florist has prepared the following sales budget. The company had $200,000 in accounts receivable on July 1. Camila’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale.
Sales |
July |
August |
September |
Sales Budget |
|||
Cash sales |
60,000 |
$72,000 |
$86,400 |
Sales on account |
$90,000 |
108,000 |
129,600 |
Total budgeted sales |
$150,000 |
$180,000 |
$216,000 |
Schedule of Cash Receipts |
|||
Current cash sales |
? |
? |
? |
Plus collections from accounts receivable |
? |
? |
? |
Total budgeted collections |
$270,000 |
$162,000 |
$194,400 |
Required
a. Complete the schedule of cash receipts by filling in the missing amounts.
b. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet.