Part 3 Preparation of receipts from accounts receivable schedule and cash budget Rainbow Enterprises has presented the following estimates relating to 2016 activities: Quarter ending 31 March 30 June 30 September 31 December Sales revenue $600,000 $700,000 $800,000 $850,000 Purchases 385,000 410,000 390,000 420,000 Cost of sales 300,000 350,000 400,000 425,000 Marketing and administration expenses 150,000 150,000 150,000 150,000 Occupancy expenses 68,000 68,000 68,000 68,000 Depreciation expense 12,500 12,500 12,500 12,500 Sales in the December quarter of 2015 were $500,000. All sales are on credit, of which 70% are collected in the quarter of sale and 30 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 $510) for December 2016 will not be paid until January 2017. A major IT hardware acquisition of $25,400, to be paid for in cash, is expected in the December quarter. The bank balance at 31 December 2015 was $18,260. To complete Part 3: • Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2016. • Prepare a cash budget (on a quarterly basis) for the 12 months ending 31 December 2016. • Assess the cash position of the entity for 2016. Justify your response.
© 2015 MSA Homework Help All Rights Reserved
Disclaimer: MSA Homework Help provides reference papers to the student and we strongly recommend you not to submit the papers as it is. Please use our solutions as model answer to improve your skills.