Question: QUESTION 2 (50 marks) The Eagle Eyes' projected sales for the second half of year 2022 are shown in the corresponding table: July August September

QUESTION 2 (50 marks) The Eagle Eyes' projected sales for the second half of year 2022 are shown in the corresponding table: July August September RM255,000.00 October RM300,000.00 November RM215,000.00 December RM235,000.00 RM200,000.00 RM305,000.00 The cost of goods sold is 65 percent of sales, purchases are made in credit 2 months in advance of its sales. Twenty percent of the payment to suppliers was made during the month of purchase, 50 percent in the following month, and the remaining two months after the purchase. Thirty percent of sales were in cash, the remaining on credit. Collections are made in the following two months, in equal parts. Besides these, Eagle Eyes has certain expenses that have to be paid on a monthly basis. Rental is RM25,000.00; the interest expense is RM15,000.00; the sale's commission is RM45,000.00. Utilities will be 3 percent of monthly sales, and depreciation is fixed at RM4,500.00 per month. Tax prepayments of RM15,500.00 are made each quarter, beginning in March. Eagle Eyes tries to maintain a security balance, in cash, of RM30,000.00. Eagle Eyes can borrow at 12 percent annual rate if this amount is below the figure mentioned. Interest on short- term loans is paid monthly. Borrowing to meet estimated monthly cash needs, occurs at the beginning of the month with interest to be paid the following month. The cash balance for July 1, 2022, is RM50,000.00; the sales for April till June, 2022 are RM240,000.00, RM300,000.00, and RM280,000.00 respectively. The expected sales in January 2023 are RM350,000.00 and the expected sales in February are 320,000.00. REQUIRED: a. Prepare a cash budget for the second half of year 2022. [48.5 marks] b. Eagle Eyes has RM100,000.00 in notes payable due in December 2022 that must be repaid or renegotiated for an extension. Will the company have ample cash to repay the notes? (1.5 marks) QUESTION 2 (50 marks) The Eagle Eyes' projected sales for the second half of year 2022 are shown in the corresponding table: July August September RM255,000.00 October RM300,000.00 November RM215,000.00 December RM235,000.00 RM200,000.00 RM305,000.00 The cost of goods sold is 65 percent of sales, purchases are made in credit 2 months in advance of its sales. Twenty percent of the payment to suppliers was made during the month of purchase, 50 percent in the following month, and the remaining two months after the purchase. Thirty percent of sales were in cash, the remaining on credit. Collections are made in the following two months, in equal parts. Besides these, Eagle Eyes has certain expenses that have to be paid on a monthly basis. Rental is RM25,000.00; the interest expense is RM15,000.00; the sale's commission is RM45,000.00. Utilities will be 3 percent of monthly sales, and depreciation is fixed at RM4,500.00 per month. Tax prepayments of RM15,500.00 are made each quarter, beginning in March. Eagle Eyes tries to maintain a security balance, in cash, of RM30,000.00. Eagle Eyes can borrow at 12 percent annual rate if this amount is below the figure mentioned. Interest on short- term loans is paid monthly. Borrowing to meet estimated monthly cash needs, occurs at the beginning of the month with interest to be paid the following month. The cash balance for July 1, 2022, is RM50,000.00; the sales for April till June, 2022 are RM240,000.00, RM300,000.00, and RM280,000.00 respectively. The expected sales in January 2023 are RM350,000.00 and the expected sales in February are 320,000.00. REQUIRED: a. Prepare a cash budget for the second half of year 2022. [48.5 marks] b. Eagle Eyes has RM100,000.00 in notes payable due in December 2022 that must be repaid or renegotiated for an extension. Will the company have ample cash to repay the notes? (1.5 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
