Prepare in a excel document.

P4-4A Vang Management Services began business on January 1, 2017, with a capital Comple Worl prepare te ksheet; investment of $120,000. The company manages condominiums for owners (Service Reve- classified balance sheet, nue) and rents space in its own office building (Rent Revenue). The trial balance and entries, and post-closing trial balance. adjusted trial balance columns of the worksheet at the end of the first year are as follows. (LO 1, 2, 4) VANG MANAGEMENT SERVICES Worksheet For the Year Ended December 31, 2017 Adjusted Trial Balance Trial Balance cr Account Titles Dr. Dr 13,800 13,800 Cash Accounts Receivable 28,300 28,300 2,400 3,600 Prepaid Insurance 67,000 67,000 Land 127,000 127,000 Buildings 59,000 59,000 Equipment 12,500 12,500 Accounts Payable 1,500 Unearned Rent Revenue 120,000 120,000 Mortgage Payable 144,000 144,000 22,000 90,700 Owner's Capital 22,000 Owner's Drawings 90,700 Service Revenue 33,500 29,000 Rent Revenue 42,000 42,000 Salaries and Wages Expense 20,500 20,500 Advertising Expense 19,000 19,000 Utilities Expense 402,200 402,200 Totals