Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

a) Iqbal Hanif Holdings is trying to estimate its cash requirement for the second quarter of 2022. The companys forecasted sales are as follows: Month

a) Iqbal Hanif Holdings is trying to estimate its cash requirement for the second quarter of 2022. The companys forecasted sales are as follows:

Month

Sales (RM)

Month

Sales (RM)

February

80,000

June

125,000

March

85,000

July

105,000

April

90,000

August

130,000

May

100,000

b) The company makes 50 percent cash sales, 40 percent is collected one month after sales, 10 percent is collected two months after sales. c) Purchases of raw materials are 70 percent of sales and are made one month before the sales occur. Payment is made equally in the two months after purchases.

d) Operating expenses will be 10 percent of the monthly sales. The company fixed monthly expenses are RM 20,000 for wages, RM 3,000 for rent, RM 13,000 for depreciation and RM2,000 for insurance.

e) A Quarterly dividend of RM 4,000 will be received at the end of each quarter.

f) Ending cash balance for March 31, 2022 is RM 55,000 and the minimum balance of RM 30,000 must be maintained at all times.

Based on the above information, prepare a cash budget for the second quarter period ending on 30 June 2022.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions

Question

Let {X(t), Answered: 1 week ago

Answered: 1 week ago