Fateh Co. is trying to estimate its need for funds of year 2022. The company sales...

 

Transcribed Image Text:

Fateh Co. is trying to estimate its need for funds of year 2022. The company sales are as follows: Actual Sales Forecasted Sales Month (RM'000) Month March 2022 2.230 July 2022 August 2022 September 2022 October 2022 November 2022 3,900 December 2022 3,780 April 2022 May 2022 June 2022 2.440 3,550 2.600 (RM'000) 3,680 3,800 4.250 4,000 The collection of sales is 35 percent for cash, whereas the balance is collected in the following month. >Fateh Co. purchases raw materials two months in advance. Amount of raw materials needed is 60 percent of its total sales. The supplier is paid 40 percent in the same month in which the purchase occur, while the balance will be paid equally in the two months after purchase. Rental of RM5,000 is received every month. e) Dividend of RM86,000 will be received in September. >Utilities expenses is 5 percent based on the current monthly sales. The company makes a monthly payment of RM85,000 for salaries and RM37,000 for other administrative expenses. The company will pay insurance premiums of RM15,500 every month and taxes of RM11,000 is payable in August. Ending balance for June is RM123,000 and the company intends to maintain a minimum balance of RM60,000 every month. Interest rate of 12 percent per year will be charged if the company makes a loan. Prepare a cash budget for the third quarter of 2022. Fateh Co. is trying to estimate its need for funds of year 2022. The company sales are as follows: Actual Sales Forecasted Sales Month (RM'000) Month March 2022 2.230 July 2022 August 2022 September 2022 October 2022 November 2022 3,900 December 2022 3,780 April 2022 May 2022 June 2022 2.440 3,550 2.600 (RM'000) 3,680 3,800 4.250 4,000 The collection of sales is 35 percent for cash, whereas the balance is collected in the following month. >Fateh Co. purchases raw materials two months in advance. Amount of raw materials needed is 60 percent of its total sales. The supplier is paid 40 percent in the same month in which the purchase occur, while the balance will be paid equally in the two months after purchase. Rental of RM5,000 is received every month. e) Dividend of RM86,000 will be received in September. >Utilities expenses is 5 percent based on the current monthly sales. The company makes a monthly payment of RM85,000 for salaries and RM37,000 for other administrative expenses. The company will pay insurance premiums of RM15,500 every month and taxes of RM11,000 is payable in August. Ending balance for June is RM123,000 and the company intends to maintain a minimum balance of RM60,000 every month. Interest rate of 12 percent per year will be charged if the company makes a loan. Prepare a cash budget for the third quarter of 2022.

Answer rating: 100% (QA)

Fateh Co Cash Budget for the Third Quarter of 2022 July 2022 Cash Inflows Cash Sales RM3680 035 RM12... View the full answer