Finlandia Golf Trance Descobert. 2030 Chad Elche 15.00 7.000 Account Receivable - Members Allowance for Deful Acco ReReceivable 100 Shep Supplies 9.000 1.000 120,000 200 100.000 . 000 Accumulated Depreciation de == Accumunod Depreciation que Tyle Salaries and was the care Nutele CS Retained in Rew Green Revo Restem Ad Dut Deping Depecie - Expo Interest Salaries and Wages Expo 17. $4.000 200 Shop Supplies Esporte sites Maintenance and Repairs Erme In my TOTALS IX. Presented below is the trial balance of First Landing Golf Club as of December 31, 2020. The books are closed annually on December 31 130 words e following additional information is available for First Landing Golf Club at December 31, 2020 Prepare adjusting journal entries for First Landing Golf Club based on the trial balance and the following information a. The buildings have an estimated life of 30 years with no salvage value (straight-line method.) b. The equipment is depreciated over ten years using the straight-line method. c. Insurance expired during the year totaled $4,000. d. The rent revenue represents the amount received for 11 months for dining facilities. The December tent has not yet been received. e. It is estimated that 15% of the Accounts Receivable will be uncollectible. f. Employees had carned $3,800, by December 31, for which they had not been paid. g. Dues received in advance from members, 68.100 were recorded as Dues Revenue. 544 words h. The note payable of S100,000 was issued on April 1, 2019, with interest of 5% and is due April 1, 2020 i. Shop supplies remaining at December 31 were $900. Requirements: 1.2 points) Using Excel, setup a worksheet for First Landing Golf Club with columns for the unadjusted trial balance, adjusting journal entries, adjusted trial balance, closing entries, and post-closing trial balance - all formatted with numbers rounded to nearest dollar. (See Figure 1 for an example) 2. (2 points) Transfer unadjusted balances to the worksheet, use formulas to ensure columns balance across worksheet. (See Figure 1 for an example) 3. (18 points) Prepare adjusting journal entries using the included general journal worksheet and then post the entries to worksheet 4. (6 points) Using formulas, complete the adjusted trial balance columns. (See Figures 2 and 3 as a guide for creating formulas. Note that each cell in the debit and credit column will contain a formula, but there should only be one balance per account.) -No formulas, no points 5. (6 points) Prepare closing entries and post to the worksheet. (Check # - Net income - $26,900) 6. (6 points) Complete worksheet by preparing post-closing trial balance. Use formulas! (NOTE: Use formulas similar to ones created in Req, 4. Debit column=IF(B7-07-C7-E7+H7- 17>0,-B7+D7-C7-E7+H7-17. ). credit column=IF(B7-07- C7-E7+H7-17>0/+B7D7-C7-E7+H7-17)-1.)-again..no formulas, no points ---- Tilli + Sample formula: SUM(B3:B33) Figure 2 D 1 2 Adele Gengs Debit Credit Cred 2 13. 2 & 1 4 S 5 -IF(*C3-E3-D3-F320,+C3-E3-D3-F3," ") 544 words Figure 3 IFC3+E3-D3-F30,-B7+D7-C7-E7+H7-17. ). credit column=IF(B7-07- C7-E7+H7-17>0/+B7D7-C7-E7+H7-17)-1.)-again..no formulas, no points ---- Tilli + Sample formula: SUM(B3:B33) Figure 2 D 1 2 Adele Gengs Debit Credit Cred 2 13. 2 & 1 4 S 5 -IF(*C3-E3-D3-F320,+C3-E3-D3-F3," ") 544 words Figure 3 IFC3+E3-D3-F3
