How do I calculate accounts payable as of June 30?

Schedule 5 Expected Cash Disbursements for Materials (US$) May June Quarter April Accounts payable Beginning Balance $ 55,000.00 $ 55,000.00 63,420 $ Cash Payments April Purchases $ Cash Payments May Purchases Cash Payments June Purchases Total Cash Payments for Materials $ $95,130 61,600 $ $ $156,730 $ $ 92,400 $ 37,800 $ 130,200 $ 158,550 154,000 37,800 405,350 118,420 Accounts Payable as of June 30