Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fateh Co. is trying to estimate its need for funds of year 2022. The company sales are as follows: Actual Sales Forecasted Sales Month

Fateh Co. is trying to estimate its need for funds of year 2022. The company sales are as follows: Actual 

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.

Step by Step Solution

3.59 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

Fateh Co Cash Budget for the Third Quarter of 2022 July 2022 Cash Inflows Cash Sales RM3680 035 RM12... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Financial Management

Authors: Glen Arnold

5th edition

978-1292178066, 129217806X, 273758837, 978-0273758839

More Books

Students also viewed these Finance questions

Question

Estimate the moment of inertia of a bicycle wheel.

Answered: 1 week ago