Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Eagle Eyes' projected sales for the second half of year 2022 are shown in the corresponding table: July RM255,000.00 October RM235,000.00 August RM300,000.00 November
The Eagle Eyes' projected sales for the second half of year 2022 are shown in the corresponding table: July RM255,000.00 October RM235,000.00 August RM300,000.00 November RM200,000.00 September RM215,000.00 December 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
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