Excel

Adjust the accounts; construct the financial statements) Consider the unadjusted trial balance of Spateness, Inc., at December 31, 2016, and the related month-end adjustment data. Adjustment data at December 31, 2016: Accrued service revenue at December 31, $3, 960. Prepaid rent expired during the month. The unadjusted prepaid balance of $3,000 relates to the period December 1, 2016, through February 28, 2017. Supplies used during December, $1, 880. Depreciation on furniture for the month. The estimated useful life of the furniture is five years. Accrued salary expense at December 31 for Monday, Tuesday, and Wednesday. The five-day weekly payroll of $20,000 will be paid on Friday. Using Exhibit 3-9 as an example, prepare the adjusted trial balance of Spateness, Inc., at December 31, 2016. Key each adjusting entry by letter. Prepare the single-step monthly income statement, the statement of retained earnings, and the classified balance sheet. Draw arrows linking the three statements