Please help complete the three requirements of this problem set with excel worksheet or word table including all headings and posted clearly showing all the data in the tables. Thank you!

P7-25A Using the purchases, cash payments, and general journals Learning Objective 3 Purchases Journal, Accounts Payable CR column total $19,540 The general ledger of Shiny Lake Golf Shop includes the following selected accounts, along with their account numbers: Number Account 111 131 Cash Merchandise Inventory Prepaid Insurance Office Supplies Number Account 181 Equipment 211 Accounts Payable 564 Rent Expense 583 Utilities Expense 161 171 Transactions in December that affected purchases and cash payments follow: Dec.2 Purchased merchandise inventory on credit from Tighe, $4,100. Terms were 3/10, n/30. 3 Paid monthly rent, debiting Rent Expense for 52,200. 5 Purchased office supplies on credit terms of 3/10, 1/30 from Rapid Supply, 5470 8 Received and paid electricity utility bill, 5510. 8 Received and paid electricity Utility bill 3510 9 Purchased equipment on account from A-1 Equipment, 56,900. Payment terms were net 30 10 Returned the equipment to A 1 Equipment. It was damaged 11 Paid Tighe the amount owed on the purchase of December 2 12 Purchased merchandise inventory on account from Crystal Golf, 54,900. Terms were 1/10, 1/30 13 Purchased merchandise inventory for cash, 5660 14 Paid a semiannual insurance premium, debiting Prepaid Insurance, 51,200 16 Paid its account payable to Rapid Supply from December 5 18 Received and paid gas and water utility bills, $500 21 Purchased merchandise inventory on credit terms of 1/10, 1/45 from Devin, Inc. $3,000 21 Paid its account payable to Crystal Golf from December 12. 22 Purchased office supplies on account from Office Stuff, Inc. $100. Terms were n/30 26 Returned to Devin, Inc. $1,000 of the merchandise inventory purchased on December 21 31 Pald Devin, Inc. the net amount owed from December 21 less the return on December 26 Requirements 1. Shiny Lake Golf Shop records purchase returns in the general journal. Use the appropriate journal to record the transactions in a purchases joumal, a cash payments journal (omit the Check No. column), and a general journal. The company uses the perpetual inventory system 2. Total each column of the special journals. Show that total debits equal total credits in each special journal 3. Show how postings would be made from the journals by writing the account numbers and check marks in the appropriate places in the journals