How to solve for financing + ending cash balance

Cash Budget
	July	Aug.	Sept.	Total
Beginning Cash Balance	$ 54,436	$ 53,048	$ 29,782	$ 137,266
Add: Collections from customers	448,400	380,800	456,400	1,285,600
Total cash available	502,836	433,848	486,182	1,422,866
Less: Cash Disbursements
Direct Materials	26,618	56,560	85,470	168,648
Direct Labor	110,500	138,125	204,000	452,625
Manufacturing Overhead	75,500	80,375	92,000	247,875
Selling and Admin Expenses	89,000	97,000	99,000	285,000
Equipment Purchases	8,000	10,000	6,000	24,000
Dividends	-
Total Cash Disbursements	309,618	382,060	486,470	1,178,148
Excess (deficiency) of cash available	193,218	51,788	(288)	244,718
Financing:			30,000
Borrowings (at the beginning of month)			30,288
Repayments (at end of month)	138,782	21,788
Interest (recorded when payments made)	1,387.82	217.88
Total Financing	140,170	22,006	30,288
Ending Cash Balance	$ 53,048	$ 29,782	$ 30,000		(30,000)