Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Financial statements

Authors: Stephen Barrad

5th Edition

978-007802531, 9780324186383, 032418638X

More Books

Students also viewed these Finance questions

Question

How do books become world of wonder?

Answered: 1 week ago

Question

If ( A^2 - A + I = 0 ), then inverse of matrix ( A ) is?

Answered: 1 week ago