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 5 months, the following sales billings are expected: May $84,000 June 100,800 July 77,000 August 87,000 September 90,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 $ $
Collection pattern = 20% in the month of billing, 50% in the month following billing and 25% in the second month following billing.
Schedule of the cash expected in payments on accounts receivable in August.
Expected cash collections from August billings (87,000*20%) | 17,400 |
Expected cash collections from July billings (77,000*50%) | 38,500 |
Expected cash collections from June billings (100,800*25%) | 25,200 |
Cash expected in payments on accounts receivable in August | 81,100 |
Schedule of the cash expected in payments on accounts receivable in September
Expected cash collections from September billings (90,000*20%) | 18,000 |
Expected cash collections from August billings (87,000*50%) | 43,500 |
Expected cash collections from July billings (77,000*25%) | 19,250 |
Cash expected in payments on accounts receivable in September | 80,750 |
Get Answers For Free
Most questions answered within 1 hours.