Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ilona ltd is preparing its cash budget for May. The following information is available regarding the monthly collection history of the company. Current month s

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 collection 30%
Prior months sales collection 58%
2 months prior sales collection 6%
3 months prior sales collection 4%
The remaining 2% is not collected and the company writes if off as bad debt. Credit sales are as follows:
February R410000
March 295000
April 385
May 400000
The total cash disbursement for the month of May amounts to 420000 and the cash balance on 1May was 10000.
REQUIRED
a. Calculate the cash balance at 31 May
b. Comment on the cash flow position on 31 May
ROUNDING OF AMOUNTS TO THE NEAREST RAND AT EACH INTERVAL. ROUNDING OF UNITS ONLY IN FINAL ANSWER.
ANSWER IN THE SPACE PROVIDED BELOW. SHOW CALCULATIONS CLEARLY. ONLY ANSWERS IN THIS SPACE WILL BE MARKED.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management Accounting Budgeting Tracking And Reporting Costs And Profitability

Authors: Kevin R. Callahan, Gary S. Stetz, Lynn M. Brooks

1st Edition

0470044691, 978-0470044698

More Books

Students also viewed these Accounting questions

Question

=+b) Form the F-statistic by dividing the two mean squares.

Answered: 1 week ago

Question

I felt sorry for the clerk.

Answered: 1 week ago

Question

How would you rate Indra Nooyi using the Blake-Mouton grid?

Answered: 1 week ago