Prepare a cash budget for Merdeka Holdings for the first 6 months of 2022. Determine its...

   

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)

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