Cash Budget & Short-Term Financing

Presented below are partial October, November, and December cash budgets for Holidays Events.

Loans are obtained in increments of $1,000 at the start of each month to maintain a minimum end-of-month balance of $12,000. Interest is one percent simple interest (no compounding) per month, payable when the loan is repaid. Repayments are made as soon as possible, subject to the minimum end-of-month balance.

Complete the short-term financing section of the cash budget and all missing figures.

Cash Balance for October is 23,000,

The collection on sales for October is 35,000,November is 40,000 and December is 80,000.

I need to determine what the cash balance is for November and December and the totals for both cash balance and collection on sales

Need to determine the cash available for operations for each month

Disbursement of operations is showing aOctober (50,000), November (60,000), December (40,000)....

What woudl be the ending cash before borrowings or replacements for each month and the total.

Short term finance:

New loans for each month

Repayments for each month

Interest for each month

Cash balance, ending