Coronado, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Coronado desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) Please help me fill in the blanks with work so I can follow along.
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.
Coronado, Inc. prepared the following
Please help me fill in the blanks with work so I can follow along.
![October
November
December
Beginning cash balance
$
$15,500 $
16500
16850
Collections from sales
50,000
80000
103150
Total cash available
66,500
95,500
120,000
Less disbursements
Materials purchases
10,000
14,000
Direct labor
5,000
5,000
8,000
Manufacturing
20,000
23,500
22,000
overhead
Selling &
administrative
27,500
25,000
expenses
Equipment purchase
Dividends
5,000
Total disbursements
66,000
Excess (deficiency) of
cash
32,000
Minimum cash balance
15,000
15,000
15,000
Cash available
-14,500
9,000
(needed)
Financing:
Borrowings
Repayments
Interest
-150
Total financing
-15,150
Ending cash balance
$15,500
$16,850 $
%24](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc8255d54-aefa-4b8b-a065-03d53f3686c6%2Fa095bbf7-ab25-4377-84bf-4816960ab31d%2F82a42k_processed.png&w=3840&q=75)
![October
November
December
Quarter
$15,500 $
$16,500
16500
16850
50,000
80000
103150
233,150
66,500
95,500
120,000
249650
10,000
14,000
37,500
5,000
5,000
8,000
18,000
20,000
23,500
22,000
27,500
25,000
15,000
5,000
5,000
66,000
32,000
15,000
15,000
15,000
-14,500
9,000
15,000
-15,000
-150
-150
-15,150
-150
$15,500
$16,850 $
$
%24](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc8255d54-aefa-4b8b-a065-03d53f3686c6%2Fa095bbf7-ab25-4377-84bf-4816960ab31d%2Foen0bc_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 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)