Prepare a cash budget for Merdeka Holdings for the first 6 months of 2022. Determine its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare a cash budget for Merdeka Holdings for the first 6 months of 2022. Determine its cash shortages or cash surplus. Merdeka Berhad is estimating its funding needs for the year 2022. The company's actual and forecasted sales are as follows: Month Total Sales (RM) Oct 2021 1,500,000 Nov 2021 1,900,000 Dec 2021 2,000,000 Forecasted Sales in 2022 Jan 2,500,000 Feb 2,600,000 March 2,650,000 April 3,650,000 May 3,850,000 June 3,780,000 July 3,900,000 Aug 4,000,000 Additional information are as follows 1. The company's collection policy of sales are as follows: 20% are cash sales, 50% are collected in 1 month after sales and the remaining sales are collected 2 months after sales. ii. Purchases of materials are 70% of sales and are made 1 month before the sales occur. 50% of the purchases are on paid cash basis and the remainder will be paid equally in 2 months after the purchase. Monthly expenses are: Salaries-RM85,000 Rent.- RM10,000 Administrative expenses -1% of the monthly sales Utilities - RM10,000 EPF and SOCSO -1% of the monthly sales and insurance premium RM 15,000 Depreciation expenses - RM30,000 iv. Company's tax payment to the LHDN amounted RM20,000 are divided into 4 payments and are paid at the beginning month of each quarter. V. A machine costing of RM150,000 will be bought in December 2021 and payment for the machine is to be made into 12 equally payments starting from January 2022 onwards. vi. Dividend of RM 30,000 to shareholders will be paid at the end of each quarter. The company is expected to received dividend from Petronas shares amounted RM55,000 in February. viii. Interest income RM 25,000 from short term investment will be received in January and May. X. Interest on term loan of RM15,000 is payable at the beginning of every quarter. xi. The company's ending balance in December 2021 is RM100,000 and they expect to maintain a monthly minimum cash of RM35,000. (20 marks) Prepare a cash budget for Merdeka Holdings for the first 6 months of 2022. Determine its cash shortages or cash surplus. Merdeka Berhad is estimating its funding needs for the year 2022. The company's actual and forecasted sales are as follows: Month Total Sales (RM) Oct 2021 1,500,000 Nov 2021 1,900,000 Dec 2021 2,000,000 Forecasted Sales in 2022 Jan 2,500,000 Feb 2,600,000 March 2,650,000 April 3,650,000 May 3,850,000 June 3,780,000 July 3,900,000 Aug 4,000,000 Additional information are as follows 1. The company's collection policy of sales are as follows: 20% are cash sales, 50% are collected in 1 month after sales and the remaining sales are collected 2 months after sales. ii. Purchases of materials are 70% of sales and are made 1 month before the sales occur. 50% of the purchases are on paid cash basis and the remainder will be paid equally in 2 months after the purchase. Monthly expenses are: Salaries-RM85,000 Rent.- RM10,000 Administrative expenses -1% of the monthly sales Utilities - RM10,000 EPF and SOCSO -1% of the monthly sales and insurance premium RM 15,000 Depreciation expenses - RM30,000 iv. Company's tax payment to the LHDN amounted RM20,000 are divided into 4 payments and are paid at the beginning month of each quarter. V. A machine costing of RM150,000 will be bought in December 2021 and payment for the machine is to be made into 12 equally payments starting from January 2022 onwards. vi. Dividend of RM 30,000 to shareholders will be paid at the end of each quarter. The company is expected to received dividend from Petronas shares amounted RM55,000 in February. viii. Interest income RM 25,000 from short term investment will be received in January and May. X. Interest on term loan of RM15,000 is payable at the beginning of every quarter. xi. The company's ending balance in December 2021 is RM100,000 and they expect to maintain a monthly minimum cash of RM35,000. (20 marks)
Expert Answer:
Answer rating: 100% (QA)
Cash budget Amount in RM January2022 February2022 March2022 April2022 May2022 June2022 Beginning cash balance 100000 295000 715500 883750 1043250 1613... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Prepare a cash budget for the Ace Manufacturing Company, indicating receipts and disbursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $20,000....
-
The management of Tridell Corporation requested a cash budget for the coming quarter, January through March. The budget is to be prepared from the following data: Collections of accounts receivable...
-
Prepare a cash budget for Elmwood Manufacturing Company for the first three months of 2014 based on the following information: The company has found that approximately 40 percent of sales are...
-
The graph of f is given. (a) Why is f one-to-one? f is one-to-one because it passes the ---Select--- ? (b) What are the domain and range of f ? ?1 ?(Enter your answers in interval notation.) domain ?...
-
How do you determine what is ethical behavior and what is not?
-
Why is it impossible for a profit-maximizing monopolist to choose any price and any quantity it wishes?
-
explain the composition and impact of individual and organizational emotions and stress;
-
Andy McDowell Co. establishes a $100 million liability at the end of 2008 for the estimated site-cleanup costs at two of its manufacturing facilities. All related closing costs will be paid and...
-
Required information Use the following information for the Problems below. ( Algo ) [ The following information applies to the questions displayed below. ] Forten Company's current year income...
-
A 2 -year bond with a semiannual coupon rate of \(4 \%\) per annum is trading at par \((100 \%)\). (a) What is its spot semiannual yield? (b) Assume one can borrow at \(3 \%\) p.a. simple interest...
-
Robinson's, an electrical supply company, sold $6,600 of equipment to Jim Coates Wiring, Inc. Coates signed a promissory note May 12 with 3.8% interest. The due date was August 10. Short of funds,...
-
Why did Wild Water Sports choose to use QuickBooks Accountants job tracking feature?
-
What happens when you first establish beginning balances for Accounts Receivable and Accounts Payable?
-
Based on your responses to the Self-Assessment on page 375, are you a theory X or a theory Y leader?
-
The pressure in seawater where a submarine is sailing is measured to be \(1300 \mathrm{kPa}\). The submarine is in a water depth of (Take the density of water to be \(1000 \mathrm{~kg} /...
-
The free-vibration equation of a single-degree-of-freedom system with nonlinear damper and nonlinear spring is given by If \(x_{1}(t)\) and \(x_{2}(t)\) are two different solutions of Eq. (E.1), show...
-
what is small area of analysis primarily useful for
-
On July 1, 2011, Flashlight Corporation sold equipment it had recently purchased to an unaffiliated company for $480,000. The equipment had a book value on Flashlights books of $390,000 and a...
-
Describe zero-base budgeting and explain how it differs from traditional budgeting.
-
Kravitz Company's production schedule shows 10,000 units of X and 8,000 units of Y. Both articles are made from the same raw materials, but units of X and Y require estimated quantities of materials...
-
The manager of MusicKing Company is trying to decide whether to move his store to the new Market Shopping Mall or to keep it in its present location. Because of changing economic conditions, the...
-
Lucy and Nick Lars, local golf stars, opened the Chip-Shot Driving Range on March 1 , 2005, by investing $20,000 of their cash savings in the business. A caddy shack was constructed for cash at a...
-
Today companies must compete in a global economy. Nestle, a Swiss company, is the largest food company in the world. If you were interested in broadening your investment portfolio, you might consider...
-
Natalie Koebel spent much of her childhood learning the art of cookie making from her grandmother. They passed many happy hours together, mastering every type of cookie imaginable and later devising...
Study smarter with the SolutionInn App