Prepare a balance sheet, owners equity statement, and income statement in excel.

P4-4A Vang Management Services began business on January 1, 2017, with a capital Complete wor prepare 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 Prepaid Insurance 3,600 67,000 67,000 Land 127,000 127,000 Buildings 59,000 59,000 Equipment 12,500 12,500 Accounts Payable 1,500 6,000 Unearned Rent Revenue 120,000 120,000 Mortgage Payable 144,000 144,000 22,000 90,700 Owners Capital 22,000 Owner's Drawings 90,700 Service Revenue 29,000 33,500 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