Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

CIMAPRO19-P01-1 Exam - Topic 3 Question 130 Discussion

JL is preparing its cash budget for the next three quarters. The following data havebeen extracted from the operational budgets:Additional information is available as follows:* JL sells 20% of its goods for cash. Of the remaining sales value, 70% is received within the same quarter as sale and 30% is received in the following quarter. It is estimated that trade receivables will be $125,000 at the beginning of Quarter 1. No bad debts are anticipated.* 50% of payments for direct material purchases are made in the quarter of purchase, with the remaining 50% in the quarter following purchase. It is estimated that the amount owing for direct material purchases will be $60,000 at the beginning of Quarter 1.* JL pays labour and overhead costs when they are incurred. It has been estimated that labour and overhead costs in total will be $303,600 per quarter. This figure includes depreciation of $19,600.* JL expects to repay a loan of $100,000 in Quarter 3.* The cash balance at the beginning of Quarter 1 is estimated to be $49,400 positive.Required:Prepare a cash budget for each of the THREE quarters.What will the closing balance of cash flows in quarter THREE be?
E) $130 200
A) $100 200
B) $170 400
C) $145 000
D) $150 200
F) $160 690
G) $184 900

CIMAPRO19-P01-1 Exam - Topic 3 Question 130 Discussion

Actual exam question for CIMA's CIMAPRO19-P01-1 exam
Question #: 130
Topic #: 3
[All CIMAPRO19-P01-1 Questions]

JL is preparing its cash budget for the next three quarters. The following data have

been extracted from the operational budgets:

Additional information is available as follows:

* JL sells 20% of its goods for cash. Of the remaining sales value, 70% is received within the same quarter as sale and 30% is received in the following quarter. It is estimated that trade receivables will be $125,000 at the beginning of Quarter 1. No bad debts are anticipated.

* 50% of payments for direct material purchases are made in the quarter of purchase, with the remaining 50% in the quarter following purchase. It is estimated that the amount owing for direct material purchases will be $60,000 at the beginning of Quarter 1.

* JL pays labour and overhead costs when they are incurred. It has been estimated that labour and overhead costs in total will be $303,600 per quarter. This figure includes depreciation of $19,600.

* JL expects to repay a loan of $100,000 in Quarter 3.

* The cash balance at the beginning of Quarter 1 is estimated to be $49,400 positive.

Required:

Prepare a cash budget for each of the THREE quarters.

What will the closing balance of cash flows in quarter THREE be?

Show Suggested Answer Hide Answer
Suggested Answer: E

References:


Contribute your Thoughts:

0/2000 characters
Lisandra
15 hours ago
This question seems similar to one we did in class about cash collections and payments. I think I need to focus on the timing of the cash flows.
upvoted 0 times
...
Helga
6 days ago
I remember we practiced cash budgets, but I'm not sure how to calculate the cash inflows from sales accurately.
upvoted 0 times
...

Save Cancel