Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(C) The following revenue and cost information have been compiled for ABC Berhad. Month August (actual) September (actual) October (forecast) November (forecast) December (forecast) Sales

image text in transcribedimage text in transcribed

(C) The following revenue and cost information have been compiled for ABC Berhad. Month August (actual) September (actual) October (forecast) November (forecast) December (forecast) Sales (RM) 3,000,000 4,500,000 1,000,000 1,500,000 2,000,000 Purchases (RM) 35,000,000 2,000,000 500,000 750,000 1,000,000 ABC Berhad collects 60 percent of sales for cash and 40 percent of its sales one month later. Interest income of RM50,000 on marketable securities will be received in December ABC Berhad pays cash for 40 percent of its purchases. ABC Berhad pays for 60 percent of its purchases the following month. Salaries and wages amount to 15 percent of the preceding month's sales. Sales commissions amount to 2 percent of the preceding month's sales. Lease payments of RM100,000 must be made each month. A principal and interest payment on an outstanding loan are due in December of RM150,000. ABC Berhad pays dividends of RM50,000 at the end of the quarter. Fixed assets costing RM600,000 will be purchased in December. Depreciation expense each month of RM45,000. ABC Berhad has a beginning cash balance in October of RM100,000 and maintains a minimum cash balance of RM200,000. Required: Prepare a cash budget for ABC Berhad in October, November, and December based on the information shown above. Based on these three months' cash budgets, recommend good liquidity management in managing the cash holdings for ABC Berhad in the short term. (14 marks)

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 Accounting questions