need help with the cash budget

\fAll sales are on credit and are due 30 days after the sale. Cash payments for purchases are as follows: twothirds in the month of purchase; onethird in the month after that. Martin Ltd. collects 50% of a month's sales one month after the sale and 45% two months after the sale; 5% are uncollectible. The company purchases inventory as required under terms of 2110, net 30. It always takes the 2% discount, but records purchases at gross cost. Inventory costs $6 per unit, gross. Other expenses, all paid in cash as incurred, average about 30% of the sales dollar amount. Depreciation is part of these expenses and costs $3,450 per month. Martin Ltd. keeps a minimum cash balance of $4,600. MARTIN LTD. Cash Budget For the Month Ended January 31 Beginning cash balance Add Cash receipts Collections from November Collections from December Total cash receipts Total available cash Less v Disbursements Accounts payable-from December Merchandise purchases Operating costs Purchase of Equipment Total disbursements Excess (Deficiency) of cash available over cash disbursements Financing Borrowing Less v : Repayment Total financing Ending cash balance $