C18 A B C D 1 Requirement 2 2 3 MONTHEND JOURNAL ENTRIES: 4 STEP 1: Prepare the following monthend journal entries for April 30. 5 STEP 2: Post journal entries in the WORKSHEET tab. F G H General Ledger Account No. Debit Credit 6 7 8 Trans# 9 (a) Office supplies remaining on hand, $100. 10 (b) Food supplies remaining on hand, $8,000. 11 (c) 12 (d) 13 (e) Insurance expired during the month of April, $1,500. Depreciation on the fishing boats for the month of April, $1,000. Wages earned, but not yet paid, at the end of April, $500. 14 15 16 17 Date Trans# General Ledger Account Description 18 Apr 30 (a) 19 20 Apr 30 (b) 21 2222222 22 Apr 30 (c) 23 24 Apr 30 (d) 25 26 Apr 30 (e) 27 28 29 30 31 32 33 34 35 36 37 Total Debits and Credits Check Figure: 34,100 34,100 1 WORKSHEET 3 After posting the monthend journal entries, go to Instructions for Req 3 tab. Unadjusted Trial Balance Account Names Debit Hook & Sinker Resort Worksheet April 30, 20-- Adjustments Credt Trans# Debit 8 9 10 Cash 11 Office Supplies 12 Food Supples 14 Fishing Boats 15 16 Accounts Payable 13 Prepaid Insurance Accumulated Depreciation-Fishing Boats 17 Wages Payable 18 Jack Zeeman, Capital 19 Jack Zeeman, Drawing 20 Registration Fees 21 Wages Expense 22 Rent Expense 23 Office Supples Expense 24 Food Supplies Expense 25 Phone Expense 26 Uities Expense 27 Insurance Expense 28 Postage Expense 29 Depreciation Expense-Fishing Boats 30 31 32 33 34 Check figures 328,200 328,200 (0) (a) (b) (c) (d) Adjusted Trial Balance Income Statement Credit Trans Deb Credit Debit Credit Balance Sheet Debit Credit (a) (b) (c) (d) O " 34,100 34,100 329,700 329,700) Net Income 117,450 171,700 212.250 158,000 o 117,450 171,700 Income Statement 0 212.250 158,000 Balance Sheet ome Insert Draw Page Layout Formulas Data Review View AA Paste BIU v 3 F5 fx A 5 6 The following transactions took place during April 20--. B Wrap Text Merge & Center 7 Apr 1 B Jack Zeeman invested cash in business, $90,000. 9 Apr 1 10 Apr 2 11 Apr 2 12 23 Apr 2 13 Apr 3 Apr 5 14 15 Apr 7 16 Apr 10 Paid insurance premium for six-month camping season, $9,000. Paid rent for lodge and campgrounds for the month of April, $40,000. Deposited registration fees, $35,000. Purchased 10 fishing boats on account for $60,000. The boats have estimated useful lives of five years, at which time they will be donated to a local day camp. Arrangements were made to pay for the boats in July. Purchased food supplies from Acme Super Market on account, $7,000. Purchased office supplies from Gordon Office Supplies on account, $500. Deposited registration fees, $38,600. Deposited registration fees, $30,500. 17 Apr 10 18 Apr 14 19 Apr 16 Purchased food supplies from Acme Super Market on account, $8,200. Paid wages to fishing guides, $10,000. 20 Apr 17 21 Apr 18 22 Apr 21 23 Apr 24 24 Apr 24 25 Apr 28 26 Apr 29 27 Apr 30 28 Apr 30 29 Apr 30 30 Apr 30 Purchased food supplies from Acme Super Market on account, $9,000. Paid wages to fishing guides, $10,000. Paid postage, $150. Deposited registration fees, $35,600. Purchased food supplies from Acme Super Market on account, $8,500. Paid wages to fishing guides, $10,000. Deposited registration fees, $32,000. Paid wages to fishing guides, $10,000. Purchased food supplies from Acme Super Market on account, $6,000. Paid Acme Super Market on account, $32,700. Paid utilities bill, $2,000. Paid phone bill, $1,200. 31 Apr 30 33 Jack Zeeman withdrew cash for personal use. $6,000. Instructions for Fino 1 Beg 1 TACCOUNTS Rea WORKSHEET