B Trial Balance Worksheet-January 1 to December 31, 2019 Account Cash Accounts receivable Prepaid re Office Supplies Furniture Accum. Depr-furniture Accounts payable Unearned Service Revenue Common stock Retained earnings-Jan. 1 Dividends Service revenue Salary expense Rent expense Utilities expense Supplies expense Depreciation expense TOTAL Adjustment data at December 31, 2019, include the following: Unadjusted TB Debit 3: In a separate tab: prepare the closing entries. 4: In a separate tab: prepare the post-closing trial balance 5,000 1,500 2,400 1,000 50,000 1,000 7,700 0 530 0 0 69,130 Credit 10,000 2,000 5,000 13,000 20,000 19,130 69,130 Adjustments Debit Credit Adjusted TB Debit Credit a) On January 1, 2019 two years of rent was paid ($100 a month). b) The amount of Office Supplies left at December 31, 2019 is only $200. c) The Furniture was purchased on January 1, 2017 and is expected to last 10 years. Yearly Depreciation Expense is $5,000 d) A customer put $5,000 deposit down (in advance payments by the customer for the services to be received), and so far has only received 50% of the services. (50% of the obligations are fulfilled by the end of December 31, 20191) Required: 1: Prepare the Above Trial balance worksheet (be sure to include formulas to add/subtract cells across rows as well as to add cells down columns). 2: In a separate tab: Create the Income Statement, Statement of Changes in Retained Earnings and Balance Sheet. Be sure to create formulas that link to cells in the Trial Balance worksheet.

Einsiteri dexichinted Einsiteri dexichinted