Question: rate on short term borrowing is 1% per month. Required: Prepare a monthly cash budget for the second quarter of 2021. (12 Marks) Mint Green


rate on short term borrowing is 1% per month. Required: Prepare a monthly cash budget for the second quarter of 2021. (12 Marks) Mint Green Berhad had projected its sales for the first six months of 2021 to be as follows: Month Januaryl February March RM 100,000 120,000 200,000 Month April May June RM 360,000 480,000 480,000 Cost of goods sold is 40% of sales. Purchases are made and paid for two months prior to the sale. 40% of sales are collected in the month of the sale, 40% are collected in the month following the sale, and the remaining 20% in the second month following the sale. Total other cash expenses are RM40,000 per month. Mint Green Berhad is planning to buy a used lorry worth RM25,000 cash in May 2021. The company's cash balance as of 31st March 2021 is projected to be RM40,000, and the company wants to maintain a minimum cash balance of RM20,000. Excess cash will be used to retire short-term borrowing (if any exists). The company has no short-term borrowing as of 31st March 2021. Assume that the interest
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
