27.0 Select Home Insert Draw Page Layout Formulas Data Review View Tell me Arla 10 - A A ant General W Text Delete- Merge & Center S % 9 Conditional Format Cell Formatting as Table Styles Format B6 xf P4-1A The trial balance columns of the worksheet for Undercover Roofing at March 31, 2019, are as follows D E F G H 1 K L M N P 5 Solving Accounting Principles Problems Using Microsoft Excel for Windows by Rex A Schildhouse P4-1A The trial balance columns of the work sheet for Undercover Roofing at March 31, 2019, are as follows: 7 Undercover Roofing 8 Work Sheet 9 For the Month Ended March 31, 2019 10 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet 11 Accountides Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. 12 Cash $2,500 13 Accounts Receivable 1,800 14 Roofing Supplies 1,100 15 Equipment 6,000 16 Accumulated Depreciation - Equipment $1,200 17 Accounts Payable 1.400 18 Uneamed Revenue 300 19 1. Spy, Capital 7.000 20 1. Spy. Drawing 400 21 Service Revenue 3,000 Salaries Expense 700 23 Miscellaneous Expense 200 $12.900 $12.900 5 Supplies Expense 8 Depreciation Expense 7 Salaries Payable Totals Net Income Totals 1 2 Key: (a) Supplies Used; (b) Depreciation Expensed; (c) Service Revenue Earned; (d) Salaries Accrued. 5 Other data: 1. A physical count reveals only 2. Depreciation for March is 3. Unearned service revenue amounted to 4. Accrued salaries are $140 $200 of roofing supplies on hand. $350 $130 after adjustment on March 31, of roofing supplies on hand. Problem P4-1A + Edit MacBook Pro Aria 10 v AA Wrap Tent General Insert Paste BIU Mere & Center $ % 9 Conforme Find Formatting Table Styles Format XP-1A The trial balance columns of the worksheet for Undercover Roofing March 31, 2019, are as follows B D E F G H 1 K M N O O JO 40 Instructions: 41 (a) Utilize the work sheet, above, and complete the work sheet 42 (b) Prepare an income statement and owner's equity statement for the month of March and a classified balance sheet at March 31. 1. Spy did not make any additional Investments in the business in 43 March 44 UNDERCOVER ROOFING UNDERCOVER ROOFING 45 Income Statement Balance Sheet For the Month Ended March 31, 2019 March 31, 2019 47 Revenues Assets 48 Account title Amount Current assets 49 Expenses Account title Amount 50 Account tidlo Amount Account title Amount 51 Accountitle Amount Account title Amount 52 Account title Amount Total current assets Formula 53 Account title Amount Property, plant, and equipment 54 Total expenses Formula Account Amount 55 Not income Formula Account title Amount Formula 56 Total assets Formula 57 58 UNDERCOVER ROOFING Liabilities and Owner's Equity 59 Owner's Equity Statement Current liabilities 60 For the Month Ended March 31, 2019 Account title Amount 61 1. Spy. Capital, March 1 Amount Account title Amount 52 Title Amount Account title Amount 63 Formula Total current liabilities Formula 34 Title Amount Owner's equity 55 SpyCapital, March 31 Formula Account title Amount 36 Total liabilities and owner's equity Formula 38 59 TO 1 2 3 4 (c) Journalize the adjusting entries from the adjustments columns of the work sheet. Mar 31, 06 Account tid Amount Account tide (d) Journalize the closing entries from the financial statement columns of the work sheet. Mar 31,05 Account title Amount Account title Amount Amount Amount Mar 31.05 Account ttle Accountitle Problem P4-1A + Mar 31,05 Account tide Ancount Formula Amount Amunt Edit MacBook Pro sert Draw Page Layout Formulas Hervew View Tell me Share fo Aral 10 Wrap Text General - A A A 27.0 I Delete Merge & Carter $% Sort Conditional Format cal Formatting as Table Styles Format X f N-1A The trial balance columns of the work sheet for Undercover Roofing at March 31, 2019, are as follows E G J B D F H 1 L M N 0 R UNDERCOVER ROOFING Owner's Equity Statement For the Month Ended March 31, 2019 Spy, Capital, March 1 Tide Amount Amount Formula Amount Formula Liabilities and Owner's Equity Current liabilities Account title Amount Account title Amount Account title Amount Total current liabilities Owner's equity Account tine Total liabilities and owner's equity Formula Title 1. Spy. Capital, March 31 Amount Formula (c) Journalize the adjusting entries from the adjustments columns of the work sheet. Mar 31, 05 Account title Account title Amount (d) Journalize the closing entries from the financial statement columns of the work shoot Mar 31,05 Account title Amount Account title Amount Amount Mar 31,05 Account to Account title Amount Formula Amount Mar 31,05 Account tidle Accountide Account tide Account the Account Mar 31,05 Account title Account title Amount Amount Amount Amount Amount Amount Mar 31, 05 Account Account title Amount Mar 31.05 Accountitle Accountide Amount Amount Amount Mar 31, 05 Accountitle Account title Amount Amount Problem P4-1A + MacBook Pro