XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september october 195,000 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) vi) vii) vii) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. the company plans to pay rm 6,500 in cash for a brand-new computer in august. a quarterly dividend of rm 10,000 will be paid to ABC corporation in March, June, September and December. the firm's ending balance for June 30, 2011 is rm56,000 and the minimum balance the firm wishes to have for every month is rm 25,000. how to prepare cash budget for XYZ Sdn Bhd for the third quarter of year 2011?
XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september october 195,000 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) vi) vii) vii) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. the company plans to pay rm 6,500 in cash for a brand-new computer in august. a quarterly dividend of rm 10,000 will be paid to ABC corporation in March, June, September and December. the firm's ending balance for June 30, 2011 is rm56,000 and the minimum balance the firm wishes to have for every month is rm 25,000. how to prepare cash budget for XYZ Sdn Bhd for the third quarter of year 2011?
Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter21: Supply Chains And Working Capital Management
Section: Chapter Questions
Problem 3MC
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning