Problem 1. On a separate sheet of paper, prepare a cash budget for the first four months of 2006, showing the amount of cumulative excess cash (loan 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.
![Problem 1. On a separate sheet of paper, prepare a cash budget for the first four months of 2006, showing
the amount of cumulative excess cash (loan balance).
Basic company has planned a cash budget for the first four months. Estimates show that P60,000
should be collected in January and April for the dividends to be received from investments in stock of
other companies. Each month, operating expenses for wages, rents, lights and others estimated to be
P100,000 plus 10% of the preceding month sales. Sales and collections on accounts receivables are
estimated as follows:
50% collected in the month of sale
30% collected in the month following the sale
20% collected in the second month following the sale
Payments for the merchandise purchased are scheduled so that 60% of the payments are made in
the month of purchase with the balance paid the following month. The cash balance is estimated at
P175,000 for January 1, 2006. Estimated net sales and purchases for the months are as follows:
Net Sales
Purchases
P 320,000
380,000
November
P 560,000
550,000
December
January 2006
February
March
640,000
700,000
650,000
580,000
420,000
400,000
350,000
280,000
April
An income tax payment of P75,000 is to be made in January and final payment of P100,000 is to
be made in April. A loan repayment of P100,000 with P10,000 interest added will be made in February.
Capital asset acquisition is scheduled for January for P100,000 and in March for P125,000. A minimum
cash balance of Pl50,000 must be maintained at the end of each month. Amounts at bundles of P10,000
can be borrowed to finance any shortages which is assumed to be made at the beginning of every month.
Interest per month is 2%. Interest and principal amount is paid at the end of the period](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3a512eaa-d934-4498-9a98-0a040d4854ce%2Fdda8d252-a3d9-4d85-8a59-b70923d6cfb4%2F2le0z68_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Fundamentals Of Financial Management, Concise Edi…](https://www.bartleby.com/isbn_cover_images/9781337902571/9781337902571_smallCoverImage.jpg)