Question
Ilona Ltd is preparing its cash budget for May. The following information is available regarding the monthly collection history of the company: Current months sales
Ilona Ltd is preparing its cash budget for May. The following information is available regarding the monthly collection history of the company:
Current months sales collections | 30% |
Prior months sales collections | 58% |
2 months prior sales collections | 6% |
3 months prior sales collections | 4% |
The remaining 2% is not collected and the company writes it off as bad debt. Credit sales to date are as follows:
February | R410 000 |
March | R295 000 |
April | R385 000 |
May | R400 000 |
The total cash disbursements for the month of May amounts to R420 000 and the cash balance on 1 May was R10 000.
REQUIRED
Calculate the cash balance on 31 May.Show all calculations clearly.
Comment on the cash flow positions on 31 May.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started