Garden Depot is a retaller that provided the following budgeted cash flows for next year: Total cash receipts Total cash disbursements 1st Quarter $ 280,000 $ 330,000 2nd Quarter $ 430,000 $ 300,000 3rd Quarter $ 310,000 $ 290,000 4th Quarter $ 330,000 $ 310,000 The company's beginning cash balance for next year will be $40,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year 0 0 0 0 0 0 0 0 0 0 0 0 $ 0 0 $ 0 $ 0
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.
![Garden Depot is a retaller that provided the following budgeted cash flows for next year:
Total cash receipts
Total cash disbursements
1st Quarter
$ 280,000
$ 330,000
2nd Quarter
$ 430,000
$ 300,000
3rd Quarter
$ 310,000
4th Quarter
$ 330,000
$ 290,000
$ 310,000
The company's beginning cash balance for next year will be $40,000. The company requires a minimum cash balance of $10,000 and
may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments,
based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not
compounded.
Required:
Prepare the company's cash budget for next year.
Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign.
Beginning cash balance
Total cash receipts
Total cash available
Total cash disbursements
Excess (deficiency) of cash available over disbursements
Financing:
Borrowings
Repayments
Interest
Total financing
Ending cash balance
Garden Depot
Cash Budget
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Year
0
0
0
0
0
0
0
0
0
0
0
0
$
0
0
$
0
$
0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F19a4ac56-36d7-4808-a803-2dfe72120de9%2Fa80921e5-cc56-421d-81dd-694191e05ae6%2F6tmchwe_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)