I need help filling out a cash budget sheet here is the relevant information:

Cash Budget Information

The company plans to pay cash for selling and administrative equipment totaling $3,000,000 and production equipment totaling $15,000,000 (management plans to fully automate production with new machinery). Both will be purchased at the end of the fourth quarter and will not affect depreciation expense for the budgeted year.

The cash balance at the beginning of this coming year is expected to be $13,000,000. The company desires a minimum ending Cash Balance of $12,500,000 each quarter.

The company has an open line of credit at an interest rate of 10% annually. Borrowing is always at the beginning of the quarter and repayments are made at the end of a quarter. Repayments are not made until there is sufficient cash to make the repayment and not go below the minimum desired cash balance for the quarter. Interest is not paid until the payment is made.

Comprehensive Master Budget

IN-TENTS. INC.

Cash Budget

Year Ending December 31

Quarter

1

2

3

4

Year

Beginning Cash Balance

Cash collections from sales

Total Available Cash

Less Cash Disbursements:

Material Purchases

Direct labor

Manufacturing overhead

Selling and administrative

Dividends

Equipment Purchases

Total Disbursements

Excess (deficient) Cash

Financing:

Borrowing

Repayment

Interest

Total Financing

Ending cash balance