BCAS Ltd is developing a cash budget for April, May and June 2022, and the following information was gathered: Cash Receipts 1 Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The forecasted sales revenue for April, May and June 2022 are $170,000, $220,000 and $280,000 respectively. Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. 2 Monthly rental income received is $60,000. 3 Interest income of $10,000 will be received in May 2022. Cash Disbursements 4 The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. 5 Monthly salaries paid is $70,000. 6 Commission is paid to its salesman at 2% of current month’s sales. 7 Renovation of all retail outlets amounting to $400,000 is scheduled for payment in June 2022. Use the template below to prepare the cash budget for April, May and June 2022: Cash Budget: Apr $ May $ Jun $ Total cash receipts Less: Total cash disbursements Net cash flow Add: Beginning cash Ending cash Minimum cash Required Financing Excess Cash Balance
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
BCAS Ltd is developing a
Cash Receipts |
|
1 |
Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The
Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. |
2 |
Monthly rental income received is $60,000. |
3 |
Interest income of $10,000 will be received in May 2022. |
Cash Disbursements |
|
4 |
The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. |
5 |
Monthly salaries paid is $70,000. |
6 |
Commission is paid to its salesman at 2% of current month’s sales. |
7 |
Renovation of all retail outlets amounting to $400,000 is scheduled for payment in June 2022. |
Use the template below to prepare the cash budget for April, May and June 2022:
Cash Budget:
|
Apr $ |
May $ |
Jun $ |
Total cash receipts |
|
|
|
Less: Total cash disbursements |
|
|
|
Net cash flow |
|
|
|
Add: Beginning cash |
|
|
|
Ending cash |
|
|
|
Minimum cash |
|
|
|
Required Financing |
|
|
|
Excess Cash Balance |
|
|
|
Trending now
This is a popular solution!
Step by step
Solved in 2 steps