Magic Aqua Ltd, which runs competitive swimming schools for children aged 8–16, has budgeted revenue for the first 6 months of 2025 as follows.

All revenue is provided on account and Magic Aqua Ltd posts out the account statements on the last day of each month for that month’s services. Customers are given 14 days to pay and 75% pay within the month. The other 25% usually pay the following month. At the end of December 2024 accounts receivable totalled $20 000.
Required Prepare a schedule of estimated cash collections from revenue for the first 6 months of 2025 for Magic Aqua Ltd.

Transcribed Image Text:

Month Budgeted revenue January $92.000 February 70 000 March 75 000 April 45 000 May 80 000 June 84 000