Rainbow Enterprises has presented the following estimates relating to 2018 activities. Sales in the December quarter of
Question:
Rainbow Enterprises has presented the following estimates relating to 2018 activities.
Sales in the December quarter of 2017 were $690,000. All sales are on credit, of which 55 percent are collected in the quarter of sale and 45 per cent in the following quarter. Purchases are on credit, and entity policy is such that all purchases are paid for in the same quarter. The marketing and administration expenses incurred and paid are the same. Occupancy expenses incurred and paid are usually the same, except that the electricity bill (estimated to be $700) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $27300, to be paid for in cash, is expected in the December quarter. The bank balance at 31 December 2017 was $18,450.
Required
a. Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018.
b. Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2018.
c. Assess the cash position of the entity for 2018.
Step by Step Answer:
Accounting Business Reporting For Decision Making
ISBN: 9780730363415
6th Edition
Authors: Jacqueline Birt, Keryn Chalmers, Suzanne Maloney, Albie Brooks, Judy Oliver