Complete the attached Excel spreadsheet template from Problem P2-6 on pages 100 and 101 in the textbook. You will answer all of P2-6's requirements except for 1. and 3.

The general ledger of the Karlin Company, a consulting company, at January 1, 2018, contained the following account balances: P 2-6 Accounting cycle LO2-2 through LO2-7 Account Title Debits Credits 30,000 15,000 20,000 Cash Accounts recelvable Equipment Accumulated depreciation Salaries payable Common stock Retained earnings Total 6,000 9,000 40,500 9,500 65,000 65,000 101 CHAPTER 2 Review of the Accounting Process The following is a summary of the transactions for the year: a. Sales of services, $100,000, of which $30,000 was on credit. b. Collected on accounts receivable, $27.300. c. Issued shares of common stock in exchange for $10,000 in cash. d. Paid salaries, $50,000 (of which $9,000 was for salaries payable). e. Paid miscellaneous expenses, $24,000. f. Purchased equipment for $15,000 in cash. g. Paid $2,500 in cash dividends to shareholders. Required: 1. Set up the necessary T-accounts and enter the beginning balances from the trial balance. 2. Prepare a general journal entry for each of the summary transactions listed above. 3. Post the journal entries to the accounts. 4. Prepare an unadjusted trial balance. 5. Prepare and post adjusting journal entries. Accrued salaries at year-end amounted to $1.000. Depreciation for the year on the equipment is $2,000. 6. Prepare an adjusted trial balance. 7. Prepare an income statement for 2018 and a balance sheet as of December 31, 2018. 8. Prepare and post closing entries. 9. Prepare a post-closing trial balance. WANAN G ww www. A A. Mind EL COMPANY de S. ALCORRENY A. KARLA CONTARY w w RACONY AN free Requirement 8: KARLIN COMPANY General Journal Debit Credit Account Closing entries at December 31, 2016 Service revenue Income summary 0.- Try again! 0. Try again! Income summary Salaries expense Miscellaneous expenses Depreciation expense Income summary Retained earnings 0