Please, it would be nice showing in excel. Thanks.

N. H D 1 P4-1A Prepare a worksheet financial statements, and adjusting and closing entries The trial balance columns of the worksheet for Lampert Roofing at March 31, 2015 are as follows. LAMPERT ROOFING Worksheet For the Month Ended March 31, 2015 Trial Balance & Account Titles Dr. O. 9 Cash 4.500 10 Accounts Receivable 3.200 11 Supplies 2.000 12 Equipment 11.000 13 Accumulated Depreciation Equipment 1.250 14 Accounts Payable 2.500 15 Uneamed Service Revenue 550 16 Common Stock 10.000 17 Retained Eaming 2.900 18 Dividends 1.100 19 Service Revenue 6.300 20 Salaries and Wages Expense 1.300 21 Miscellaneous Expense 400 22 23.500 23.500 23 24 Other data: 25 1. A physical count reveals only $550 of supplies on hand. 26 2. Depreciation for March is $250 27 3. Uneamed service revenue amounted to $210 at March 31, 28 4. Accrued salaries and wages are $700, 29 30 Instructions: 31 (a) Enter the trial balance on a worksheet and complete the worksheet. 32 (6) Prepare an income statement and retained eamings statement for the month of March 33 and a classified balance sheet at March 31 34 (c) Journalize the adjusting entries from the adjustments columns of the worksheet. 35 (d) Joumalize the closing entries from the financial statement columns of the worksheet. 36 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" 37 38 2 one on them the natatament cons of the worksheet OTE: Enter a number interesting venter either a number or a formula incet with . LAMPERTROOFING Worth For the Mad Max 2015 Account TB Adu Income Statement het 2 Asusted Tule 1 Value IN 4 500 3.200 2.000 11.000 Val B Vw V V V 17 7 Value Value 1.250 2.500 550 10 000 2.900 1 > Value 12 Value Value Vale Vale Value Val Value 1 100 Vie Gash Accounts Receivable Supplies Event Acumulated Depreciation Equipment Accounts Payable Uneamed Service Revenue Common Stock Retained and Dividends Service Revente Sales and Wappense Melanopene Total Suppliesen Depreciation Salaries and weate Total income Total Vok 100 Yake 12 V Val 1.100 400 23.500 VA Val VH 21.500 V Value Vie VA Var Vale Vale > Value Value ? 7 7 7 2 Value 7 2 71 Value 73 BSSRESERSERERS:636E. LAMPERTROOFING Income Statement For the Month Ended March 11, 2015 Havenues Service Revenues Expenses Salaries and wages expense Value Supplies expense Value Miscellaneous expense Value Depreciation expense Value Total expenses Net income 7 79 14 85 86 LAMPERT ROOFING Retained Earnings Statement For the Month Ended March 31, 2015 Retained Earnings, March 1 Add: Net income Value Value 7 Value ? ER Les Dividends Retained Earnings, March 31 19 90 91 92 91 LAMPERT ROOFING Balance Sheet March 11, 2015 Assets Current Assets Cash Accounts receivable Supplies Total current assets Property, plant and equipment Equipment Less: Accumulated depreciation equipment Total assets Value Value Value Value Value ? 7 95 96 97 98 99 100 103 102 103 104 305 106 107 300 109 110 111 112 113 114 115 Llabilities and Stockholder's Equity Current liabilities Accounts payable Value Salaries and wages payable Value Unearned service revenue Value Total current liabilities Stockholder's equity Common stock Value Retained earnings Value Total liabilities and stockholder's equity 7 Adjusting entries 118 (c) 119 120 May 31 Value Account Account Value Mar 31 Account Account Value Value Mar 31 Value Account Account Value Mar 31 Value Account Account Value 122 123 124 125 126 127 125 129 130 131 132 133 134 135 136 (d) 137 138 139 140 141 142 143 144 145 Closing entries Mar 31 Value Account Account Value Mar 31 Value Account Account Account Account Account Value Value Value Value 146 147 Mar 31 Value Account Account Value 149 150 151 152 153 154 155 156 357 15 Mar 31 Value Account Account Value