Superstar Berhad reported sales of RM70,000 in May and RM80,000 in June. The forecast sales for July, August and September are RM90,000, RM100,000, and RM110,000, respectively. The beginning cash balance on July 1 is RM3,000 and the firm wishes to maintain a minimum cash balance of RM5,000 every month. The total long-term liabilities of the company are RM25,000. Given the following data, prepare a cash budget for the months of July, August and September.
Additional information is as follows:
The firm makes 20% of sales for cash, 60% is collected in the next month, and the remaining 20% is collected in the second month following the sale.
The firm receives other income of RM 2,000 per month.
The firm’s actual or expected purchases, all made for cash, are RM65,000, RM70,000, and RM85,000 for the months of July through September, respectively.
Rent is RM5,500 per month.
Wages and salaries are 10% of the previous month’s sales.
The net income is RM30,000. Cash dividends is 20% of the net income and will be paid in August.
The payment of principal and interest of the long-term liabilities is 20% of the total long-term liabilities and the payment is due in August.
A cash purchase of equipment costing RM15,500 is scheduled in September.
The earnings before taxes is RM100,000. The taxes amount is 10% of the earnings before taxes and it is due in August.
