how to find a/p balance from june?

Poseys pays for 40% of its purchases in the month of purchase and 60% the month after purchase. Total budgeted purchases in March are $20,000.

Poseys ending cash balance on June 30 was $57,950.

Poseys non-production cash disbursements are estimated at $80,000 per month.

DM Cash Disbursements	July	August	September	Total
A/P balance from June	$	-	-	$24,837.00
July Purchases	$16,509.00	$24,763.50		$41,272.50
August Purchases		$17,553.00	$26,329.50	$43,882.50
September Purchases			$16,830.00	$16,830.00
Total DM cash disbursements	$41,346.00	$42,316.50	$43,159.50	$126,822.00
Other Cash Disbursements	$80,000.00	$80,000.00	$80,000.00	$240,000.00
Total Cash Disbursements	$121,346.00	$122,316.50	$123,159.50	$366,822.00

Posey's Pet Emporium
DM Cash Disbursements	July	August	September	Quarter
A/P balance from June*	[Insert formula]			[insert value}
July purchases	[Insert formula]	[Insert formula]		[insert value}
August purchases		[Insert formula]	[Insert formula]	[insert value}
September purchases			[Insert formula]	[insert value}
Total DM Cash Disbursements	[Insert formula]	[Insert formula]	[Insert formula]	[Insert formula]
Other Cash Disbursements	[Insert formula]	[Insert formula]	[Insert formula]	[Insert formula]
Total Cash Disbursements	[Insert formula]	[Insert formula]	[Insert formula]	[Insert formula]