Accounting Cycle Review Problem A Name: For this problem, the


Question Description:

35

I need help with the numbers one through twelve on attachment called “Problems”. Please use the excel provided for to fill in the answers. Any questions, please let me know. ExcelTemplate.xlsx Accounting Cycle Review Problem A Name: For this problem, the journal, ledger, and work sheet and statements are under separate tabs. Enter the appropriate amounts/formulas in the shaded (gray) cells, or select from the drop-down lists. Not all cells should be populated. An asterisk (*) will appear in the column to the right of an incorrect answer. 1. & 5. GENERAL JOURNAL Date Description Post. Ref. Page Debit 1 Credit 20-July 1 Invested cash in business. 2 Bought Blast Off!. 2 Paid one-year premium for insurance. 2 Bought inner tubes from Worn Tires. 3 Received payment for rental space for video games and food concessions. 5 Grand opening expenses from Party Rentals and City Star. 6 July payment on contract to All-Around Maintenance. GENERAL JOURNAL Date Description 20-July 6 Paid for employee picnic. 7 Received cash for services rendered. 9 Bought parts on account from Arlen’s Pool Supply. 14 Received cash for services rendered. 15 Paid wages for period July 1-July 14. 16 Paid Party Rentals and City Star on account. 16 Withdrawal for personal use. 17 Post. Ref. Page 2 Debit Credit Bought pool furniture from Pool Suppliers. GENERAL JOURNAL Date Description Post. Ref. Page 3 Debit Credit 20-July 18 Paid for costume alterations. 21 Received cash for services rendered. 21 Partial payment to Worn Tires. 23 Received allowance from Pool Suppliers for damaged chairs. 25 Received and paid telephone bill. 29 Paid wages for period July 15-July 28. 31 Received cash for services rendered. 31 Paid Arlen’s Pool Supply on account. 31 Received and paid water bill. GENERAL JOURNAL Date Description 20-July 31 Paid installment on mortgage. 31 Received and paid electric bill.. 31 Bought inner tubes from Worn Tires. 31 Withdrawal for personal use. 31 Additional revenue from concessions. Adjusting Entries 31 31 31 31 Post. Ref. Page 4 Debit Credit 31 10. GENERAL JOURNAL Date 20-July 31 31 31 31 Description Closing Entries Post. Ref. Page 5 Debit Credit Accounting Cycle Review Problem A Name: For this problem, the journal, ledger, and work sheet and statements are under separate tabs. Enter the appropriate amounts/formulas in the shaded (gray) cells, or select from the drop-down lists. Not all cells should be populated. An asterisk (*) will appear in the column to the right of an incorrect answer. Enter as per the transactions. 2. 6. & 11. GENERAL LEDGER Account Cash Date Account No. Item Post. Ref. 111 Balance Debit Credit Debit Credit 20-July Account Accounts Receivable Date Item Account No. Post. Ref. 112 Balance Debit Credit Debit Credit 20-July Account Prepaid Insurance Date Item Account No. Post. Ref. 114 Balance Debit Credit Debit Credit 20-July Account Land Date Account No. Item Post. Ref. 121 Balance Debit Credit Debit Credit 20-July Account Date Building Account No. Item Post. Ref. 122 Balance Debit Credit Debit Credit 20-July Account Date 20-July Accumulated Depreciation, Building Item Post. Ref. Account No. 123 Balance Debit Credit Debit Credit Account Date Pool/Slide Facility Item Account No. Post. Ref. 124 Balance Debit Credit Debit Credit 20-July Account Date Accumulated Depreciation, Pool/Slide Facility Item Post. Ref. Account No. 125 Balance Debit Credit Debit Credit 20-July Account Date Pool Furniture Item Account No. Post. Ref. 126 Balance Debit Credit Debit Credit 20-July Account Date Accumulated Depreciation, Pool Furniture Item Post. Ref. Account No. 127 Balance Debit Credit Debit Credit 20-July Account Date Accounts Payable Item Account No. Post. Ref. 221 Balance Debit Credit Debit Credit 20-July Account Date Wages Payable Item Account No. Post. Ref. 222 Balance Debit Credit Debit Credit 20-July Account Date Mortgage Payable Item Account No. Post. Ref. 223 Balance Debit Credit Debit Credit

Answer

35