ESTION 2 Transtar 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 is RM25,000. Given the following data, prepare a cash budget for the months of July, August and September. (1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale. (2) 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. (3) (4) Rent is RM5,500 per month. (5) Wages and salaries are 10% of the previous month's sales. (6) 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. (7) (8) 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. (9)

Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter9: Corporate Valuation And Financial Planning
Section: Chapter Questions
Problem 1P: Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million...
icon
Related questions
Question
QUESTION 2
Transtar 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 is
RM25,000. Given the following data, prepare a cash budget for the months of July, August and
September.
(1)
The firm makes 20% of sales for cash, 60% are collected in the next month, and the
remaining 20% are collected in the second month following sale.
(2)
The firm receives other income of RM 2,000 per month.
(3)
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.
(4)
Rent is RM5,500 per month.
(5)
Wages and salaries are 10% of the previous month's sales.
(6)
The net income is RM30,000. Cash dividends is 20% of the net income and will be
paid in August.
(7)
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.
(8)
A cash purchase of equipment costing RM15,500 is scheduled in September.
(9)
The earnings before taxes is RM100,000. The taxes amount is 10% of the earnings
before taxes and it is due in August.
Transcribed Image Text:QUESTION 2 Transtar 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 is RM25,000. Given the following data, prepare a cash budget for the months of July, August and September. (1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale. (2) The firm receives other income of RM 2,000 per month. (3) 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. (4) Rent is RM5,500 per month. (5) Wages and salaries are 10% of the previous month's sales. (6) The net income is RM30,000. Cash dividends is 20% of the net income and will be paid in August. (7) 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. (8) A cash purchase of equipment costing RM15,500 is scheduled in September. (9) The earnings before taxes is RM100,000. The taxes amount is 10% of the earnings before taxes and it is due in August.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Forecasting Financial Statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage