1 Home Paste X Insert Draw Page Layout v Calibri (Body) B 1 U G1 A Raquiral fx B Formulas Data Review View Automate 11 ' ' = A Tell me Wrap Text General Merge & Center S %" F Share Comments Insert M Conditional Format Formatting as Table Styles Cell Delata Format v v Sort & Filter Find & Select Analyze Data Sensitivity C D E F G H 1 J K L M N 0 P On the next tab-The Financial Statement Template, complete the income statement, the statement of owner's equity and the classified balance sheet by filling in the empty blue squares. The information needed to complete the financial statements is in the Adjusted Trial Balance below. Be sure to note the Additional Transactions to the right of the Adjusted Trial Balance. Tybalt Construction Adjusted Trial Balance 2 December 31, 2017 3 N. Account Title 4 101 Cash Duhit $ Creat 5 104 Short-term investments 5,000.00 23.000 6 126 Supplies 8,100 7 128 Prepaid insurance 7,000 a 167 Equipment 40.000 9 168 Accumulated depreciation-Equipment $ 20,000.00 10 173 Building 150,000 11 174 Accumulated depreciation-Building 50,000 12 169 Land 55.000 13 201 Accounts payable 16,500 14 208 Interest payable 2,500 15 208 Font payable 3,500 16 210 Wages payable 2,500 17 218 Property taxes payable 900 18 233 Unearned professional fees 7,500 19 251 Long-term notes payable 67,000 20 801 O. Tybalt. Capital 126,400 302 O. Tybalt. Withdrawals 13.000 22 401 Professional fees camed 97,000 406 Rent cared 14,000 24 407 Dividends earned 2,000 25 40 Interest carned 2,100 20 606 Depreciation expense Building 11,000 27 612 Depreciation expense-Equipment 5,000 28 623 Wages expense 32.000 633 Interest expense 5,100 637 Insurance expense 10.000 31 640 Rent expense 13.400 32 652 Supplies expense 7,400 682 Postage expense 4,200 683 Property taxes expense 5,000 684 Repairs expense 8,900 688 Telephone expense 3,200 GBC Utities expense 4.500.00 Tu $411,900.00 $411,900.00 Additional transactions Tybalt invested $5,000 cash in the business during year 2017 (the December 31, 2016, credit balance of the O. Tybalt, Capital account was $121,100). Tybalt Construction is required to make a $7,000 payment on its long-term notes payable during 2018. Q R 5 T U V W Y z