Amsterdam Sdn. Bhd. has approached its bankers for loan facilities to be made available during...
90.2K
Verified Solution
Question
Accounting
Amsterdam Sdn. Bhd. has approached its bankers for loan facilities to be made available during the coming quarter. The bank has responded by requesting that a cash budget is prepared before any decision can be taken. The following information has been compiled:
June RM000 | July RM000 | August RM000 | |
Sales | 150 | 200 | 100 |
Purchases | 120 | 60 | 40 |
Wage payments | 20 | 22 | 15 |
Hire-purchase payments | 15 | 15 | 15 |
Cash expenses | 20 | 30 | 15 |
Depreciation | 5 | 5 | 5 |
Capital items | 13 | - | - |
Trade receivables on 1 June amount to RM 84,000 of which it is estimated RM 78,000 will be collected during the month and RM 4,000 in July. The balance is to be written off as a bad debt. The expected pattern of cash collection from sales is 25% during the month of sale, 70% in the month following sale and 4% in the next month.
On 1 June, the amount owing to trade payables for purchases was RM 90,000. Purchases and capital items are paid for in the month following the month of supply.
Required:
Prepare a cash budget for each of the months of June, July and August. The opening cash balance at 1 June is RM 20,500.
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.