Beginning cash balance

Add Receipts

Accounts receivable

Credit sales$-1$st

Credit sales$-2$nd

Credit sales$-3$rd

Credit sales$-4$th

Total cash receipts

Total cash available

Less Disbursements

Material purchases

Direct labour

Factory overhead

Selling and administrative expenses

Purchase of equipment

Total cash disbursements

Excess $($Deficiency$)$ of cash receipts over cash disbursements

Financing

Borrowing

Less Repayment

Less Interest expense

Total financing

Ending cash balance

I need the complete table, with the $4$ quarters. Also, please complete with borrowing, financing, etc needed. It said to keep a balance of minimum $10000$ please.