Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 2 a) Iqbal Hanif Holdings is trying to estimate its cash requirement for the third quarter of 2017. The company's forecasted sales are as
QUESTION 2 a) Iqbal Hanif Holdings is trying to estimate its cash requirement for the third quarter of 2017. The company's forecasted sales are as follows: Month Sales (RM) Month Sales (RM) April 80,000 August 125,000 May 85,000 September 105,000 June 90,000 October 130,000 July 100,000 b) The company makes 50 percent cash sales, 40 percent is collected one month after sales, 5 percent is collected two months after sales and 5 percent is uncollected. 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, RM13,000 for depreciation and RM 2,000 for insurance. e) A quarterly dividend of RM4,000 will be received at the end of each quarter. f) A 7 percent semi-annually interest payment on RM 100,000 note payable is paid in July. g) Ending cash balance for June 30th 2017 is RM55.000 and the minimum balance of RM30,000 must be maintained at all times. Any short term financing needed if any, should be paid off in the month following the month of financing with an annual interest rate of 10 percent per annum. Based on the above information, prepare a cash budget for the third quarter period ending on 30th September 2017 (20 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started