Please include equations.

An associate with the First Landing Golf Club (FLGC) has come to you with the unadjusted trial balance their bookkeeper has prepared and asked you to help them with their year-end work. They would like you to prepare the adjusting journal entries which are needed for their year-end reporting, as well as the closing entries their bookkeeper will need to make. You have agreed to help! Using the information attached, prepare the appropriate entries and a spreadsheet in Excel as directed. This will provide FLGC with documentation they can then use to ensure the entries are posted properly. Date Account Description Debit Credit Presented below is the trial balance of First Landing Golf Club as of December 31, 2020. The books are closed annually on December 31. First Landing Golf Club Trial Balance December 31, 2020 Unadjusted Debit Credit Cash 42,224 Accounts Receivable - Members 8,900 Allowance for Doubtful Accounts 243 Rent Receivable Prepaid Insurance 9,000 Shop Supplies 3,576 Land 342,000 Buildings 120,000 Accumulated Depreciation - Buildings 40,000 Equipment 160,000 Accumulated Depreciation - Equipment 80,000 Interest Payable Salaries and Wages Payable Unearned Dues Note Payable 60,000 Common Stock 280,000 Retained Earnings 115,607 Dues Revenue 266,000 Green Fees Revenue 41,300 Rent Revenue 19,800 Bad Debt Expense Depreciation Expense - Buildings Depreciation Expense - Equipment Insurance Expense Interest Expense Maintenance/grounds Expense 63,750 Salaries and Wages Expense 86,250 Shop Supplies Expense Repairs Expenses 24,000 Utilities Expense 43,250 Income Summary TOTALS 902,950 902,950 The following information is available for First Landing Golf Club at December 31. 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 25 years with no salvage value and are depreciated using the straight-line method. b. The equipment is depreciated over ten years using the straight-line method. The expected residual value of the equipment is $0. c. The prepaid insurance account should have an adjusted balance of $2,250. d. The rent revenue represents the amount received for 11 months for dining facilities. The December rent has not yet been received. e. It is estimated that 12% of the accounts receivable will be uncollectible. f. Employees had earned $3,750, by December 31, for which they had not been paid. g. Dues received in advance from members, $4,400 were recorded as Dues Revenue. h. The note payable of $60,000 was issued on April 1, 2020, with interest of 5% and is due April 1, 2021. i. Shop supplies remaining as of December 31 were $451. Requirements: 1. (2.5 point) 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. (See Figure 1 for an example). Name your file using the following format: first initial_last name_FLGC_ACCT305. 2. (2.5 points) Transfer unadjusted balances to the worksheet, use formulas to ensure columns balance across worksheet. (see Figure 1 for an example) 3. (9 points) Prepare adjusting journal entries using attached general journal and then post 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 should contain a formula, but there should only be one balance per account. 5. (5 point) Prepare closing entries and post to the worksheet. (Net income = $69,750) 6. (5 points) Complete worksheet by preparing post-closing trial balance. Use formulas! (NOTE: Us formula similar to ones created in Req. 4. Debit column IF(B7+D7-C7-E7+H7-17>0,+B7+D7-C7-E7+H7-17, ""), credit column IF(87+D7-C7-E7+H7-17>0,(+B7+D7-C7-E7+H7-17)*-1, "") Figure 1 Adjusting Debit Credit Closing Debit Credit Adjusted Debit Credit 34,300 20,700 1,100 20,000 9,600 2,800 Post-Closing Debit Credit 34,300 20,700 1,100 20,000 9,600 2,800 1600 Unadjusted Debit Credit 34,300 20,700 2,700 20,000 4,800 2,800 0 6800 26,000 4800 Accounts Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Utilities Payable Deferred Revenue Common Stock (Dividends) Retained Earnings Plumbing Services Depreciation Expense Salaries Expense Supplies Expense Utilities Expense Income Summary 5400 1,400 26,000 1,400 26,000 29,000 36,300 7,300 69,000 7,300 74,400 5400 74,400 4800 31400 4,800 31,400 1,600 7,600 1600 4,800 31,400 1,600 7,600 74,400 7600 15 400 29,000 148,800 Totals 116,700 116,700 11,800 11,800 121,500 121,500 148,800 76,100 76,10C Sample formula: =SUM(B3:B33) Figure 2. Adjusting Debit Credit Closing Debit Credit Adjusted Debit Credit 34,300 20,700 1,100 20.000 9,600 2,800 Unadjusted Debit Credit 34,300 20,700 2,700 20.000 4,800 2,800 0 6800 26,000 Post-Closing Debit Credit 34,300 20,700 1,100 20,000 9,600 2,800 1600 4800 Accounts Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Utilities Payable Deferred Revenue Common Stock (Dividends) Retained Earnings Plumbing Services Depreciation Expense Salaries Expense Supplies Expense Utilities Expense Income Summary 5400 - 1,400 26,000 1,400 26,000 29,000 36,300 7,300 69,000 7,300 4,400 5400 74,400 4800 - 31400 - 4,800 31,400 1,600 7,600 4,800 31,400 1,600 7,600 1600 7600 Home Insert Page Layout formul X Cut opy 81 Totals 116,700 116,700 11,800 11 =IF(+C3+E3-D3-F3>0,+C3+E3-D3-F3," ") pore C D Trance Debit Credit 1 4 1 2 3 4 5 6 -C353-03-7330F3.7 logical revell H Adjusting Entries Adjusted Triw Balance Debit Credit Debit Credit 2. F3,"") 3 2 1 Closing Entries Debit Cred 3 Figure 3 Adjusting Debit Credit Closing Debit Credit Adjusted Debit Credit 34,300 20,700 1,100 20,000 9,600 1.800 Unadjusted Debit Credit 34,300 20,700 2,700 20,000 4,800 2,800 0 6800 26,000 Post-Closing Debit Credit 34,300 20,700 1,100 20,000 1600 4800 9,600 2,800 Accounts Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Utilities Payable Deferred Revenue Common Stock (Dividends) Retained Earnings Plumbing Services Depreciation Expense Salaries Expense Supplies Expense Utilities Expense Income Summary 5400 ,400 26,000 1,400 26,000 29,000 36,300 Part 2 Trial balance for 7,300 1,300 69,000 5400 74,400 74,400 AutoSave File Home Insert Page Layout Formulas Data Review View Help View Help Acrobat Search IXO Paste [Copy Format 31400 =IF(C3+E3-D3-F30,+B7+D7-C7-E7+H7-17, ""), credit column IF(87+D7-C7-E7+H7-17>0,(+B7+D7-C7-E7+H7-17)*-1, "") Figure 1 Adjusting Debit Credit Closing Debit Credit Adjusted Debit Credit 34,300 20,700 1,100 20,000 9,600 2,800 Post-Closing Debit Credit 34,300 20,700 1,100 20,000 9,600 2,800 1600 Unadjusted Debit Credit 34,300 20,700 2,700 20,000 4,800 2,800 0 6800 26,000 4800 Accounts Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Utilities Payable Deferred Revenue Common Stock (Dividends) Retained Earnings Plumbing Services Depreciation Expense Salaries Expense Supplies Expense Utilities Expense Income Summary 5400 1,400 26,000 1,400 26,000 29,000 36,300 7,300 69,000 7,300 74,400 5400 74,400 4800 31400 4,800 31,400 1,600 7,600 1600 4,800 31,400 1,600 7,600 74,400 7600 15 400 29,000 148,800 Totals 116,700 116,700 11,800 11,800 121,500 121,500 148,800 76,100 76,10C Sample formula: =SUM(B3:B33) Figure 2. Adjusting Debit Credit Closing Debit Credit Adjusted Debit Credit 34,300 20,700 1,100 20.000 9,600 2,800 Unadjusted Debit Credit 34,300 20,700 2,700 20.000 4,800 2,800 0 6800 26,000 Post-Closing Debit Credit 34,300 20,700 1,100 20,000 9,600 2,800 1600 4800 Accounts Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Utilities Payable Deferred Revenue Common Stock (Dividends) Retained Earnings Plumbing Services Depreciation Expense Salaries Expense Supplies Expense Utilities Expense Income Summary 5400 - 1,400 26,000 1,400 26,000 29,000 36,300 7,300 69,000 7,300 4,400 5400 74,400 4800 - 31400 - 4,800 31,400 1,600 7,600 4,800 31,400 1,600 7,600 1600 7600 Home Insert Page Layout formul X Cut opy 81 Totals 116,700 116,700 11,800 11 =IF(+C3+E3-D3-F3>0,+C3+E3-D3-F3," ") pore C D Trance Debit Credit 1 4 1 2 3 4 5 6 -C353-03-7330F3.7 logical revell H Adjusting Entries Adjusted Triw Balance Debit Credit Debit Credit 2. F3,"") 3 2 1 Closing Entries Debit Cred 3 Figure 3 Adjusting Debit Credit Closing Debit Credit Adjusted Debit Credit 34,300 20,700 1,100 20,000 9,600 1.800 Unadjusted Debit Credit 34,300 20,700 2,700 20,000 4,800 2,800 0 6800 26,000 Post-Closing Debit Credit 34,300 20,700 1,100 20,000 1600 4800 9,600 2,800 Accounts Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Utilities Payable Deferred Revenue Common Stock (Dividends) Retained Earnings Plumbing Services Depreciation Expense Salaries Expense Supplies Expense Utilities Expense Income Summary 5400 ,400 26,000 1,400 26,000 29,000 36,300 Part 2 Trial balance for 7,300 1,300 69,000 5400 74,400 74,400 AutoSave File Home Insert Page Layout Formulas Data Review View Help View Help Acrobat Search IXO Paste [Copy Format 31400 =IF(C3+E3-D3-F3