l am having trouble completing the requirements for this accounting journal exercise. Please show all the work typed in an excel worksheet or word table and upload clearly. please make sure that nothing is cut off when uploaded. Thanks for your help!

The general ledger of Shiny Lake Golf Shop includes the following selected accounts, along with their account numbers: Number Account 111 Cash 131 Number Account 181 Equipment 211 Accounts Payable 564 Rent Expense 583 Utilities Expense Merchandise Inventory Prepaid Insurance Office Supplies 161 171 Transactions in December that affected purchases and cash payments follow: 8 Dec.2 Purchased merchandise inventory on credit from Tighe, $4,100. Terms were 3/10, 1/30 3 Paid monthly rent, debiting Rent Expense for $2,200. 5 Purchased office supplies on credit terms of 3/10, 1/30 from Rapid Supply, $470. Received and paid electricity utility bill, $510. 9 Purchased equipment on account from A-1 Equipment, $6,900. Payment terms were net 30. 10 Returned the equipment to A-1 Equipment. It was damaged. 11 Poid 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, $660. 14 Paid a semiannual insurance premium, debiting Prepaid Insurance, $1,200 16 Poid its account payable to Rapid Supply from December 5 18 Received and paid gas and water utility bills, $500. 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. 21 Requirements 1. Shiny Lake Golf Shop records purchase returns in the general journal. Use the appropriate journal to record the transactions in a purchases journal, 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