A. Please update the 5 adjusting entries in the debit/credit column in the "End of the Period Spreadsheet" (show formulas)

B. Prepare the following:

1. Income Statement
2. Statement of Stockholder's Equity
3. Balance Sheet

B D E F G H M N O Q R Crystal Consulting Company The Year End Adjustments, for Crystal Consulting Company are as follows: End of the Period Spreadsheet For the Year Ended December 31, 2018 a) Supplies on hand at December 31st are $1,500 b) Insurance premiums expired during the year are $250 Unadusted Adjusted c) Depreciation during the year of the building is $6,000 Trial Balance Adjustment Trial Balance d) Billed clients for December consulting fees $7,000 Debit Credit Debit Credit Debit Credit e) Wages accrued but not paid at December 31st are $2,220 8 Cash 27,500 9 Accounts Receivable 71,800 Please place the adjustments in the appropriate debit/credit column 10 Supplies 3,550 If you cannot remember what the appropriate accounts are, please 11 Prepaid Insurance 750 see Chapter 3 Exhibit 6 and/or Chapter 4 Exhibit 1 12 Land 55,000 Please update the Adjusted Trial Balance Buildings 250,000 Once complete with the above please prepare the following: 14 Accumulated Depreciation-Buildings 87,00 For the Year Ended December 31, 2018 Accounts Payable 16,100 Income Statement 6 Wages Payable 6,600 Statement of Stockholder's Equity 17 Unearned Rent 1.500 Balance Sheet Common Stoc 40,000 19 Retained Earnings 141,900 20 Dividends 30,000 Service Fees 675,500 22 Rent Revenue 9,000 23 Wages Expense 435,000 24 Rent Expense 65,000 25 Supplies Expense 11,850 26 Utilities Expense 8,800 27 Depreciation Expense-Buildings 10,000 28 Repairs Expense 4,250 29 Insurance Expense 3,000 0 Miscellaneous Expense 11,100 31 977,600 977,600 32 End of the Period Spreadsheet