Proiect B Using the excel spreadsheet also attached to this Canvas page, complete the accounting cycle. Answer all the questions in this problem. The trial balance columns of the worksheet for Marigold at March 31, 2019, are as follows. Marigold Worksheet For the Month Ended March 31, 2019 Account Titles Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Equipment Accounts Pavable Unearned Service Revenue Common Stock Retained Earnings Dividends Service Revenue Salaries and Wages Expense Miscellaneous Expense Trial Balance Dr. Cr. 5,000 2.800 1,740 11.088 1,260.0 2.000 440 10.295 2,873 1.170 6,500 1.100 470 23,368 23,368 Other data: 1. A physical count reveals only $400 of roofing supplies on hand. 2. Depreciation for March is $252. 3. Unearned service revenue amounted to $220 at March 31. 4. Accrued salaries are $700. Requirements: 1. Journalize the adjusting entries from the adjustments columns of the worksheet 2. Enter the trial balance on a worksheet and complete the worksheet. (Ladger) tries from the financial statement columns of the worksheet Prepare an income statement for the month of March 5. Prepare a retained earnings statement for the month of March 6. Prepare a classified balance sheet at March 31. Cash Date Explanation Ref. Debit Credit Balance Accounts Receivable Date Explanation Ref. Debit Credit Balance Supplies Date Explanation Ref. Debit Credit Balance Prepaid Insurance Date Explanation Ref. Debit Credit Balance Equipment Date Explanation Ref. Debit Credit Balance Credit Debit General Journal Account Titles Date mit Inn Mmmm ut in m m m m ut in mm m m Income Statement For the Month Ended March 31, 2019 - ON 000 Retained Earnings Statement For the Month Ended March 31, 2019 -am TO Balance Sheet March 31, 2019 Assets AWN- OG OVO AWN Liabilities and Stockholders' Equity 16600 V A B C D E F G H Dividends Ref. Date Explanation Debit Balance Income Summary Ref. Date Explanation Debit Credit Balance Service Revenue Ref. Date Explanation Debit Credit Balance Accumulated Depreciation - Equipment Explanation Ref. Debit Date Credit Balance Accounts Payable Ref. Date Explanation Debit Credit Balance Salaries and Wages Payable Explanation Ref. Debit Date Credit Balance Common Stock Date Explanation Ref Debit Credit Balance Retained Earnings Ref. Date Explanation Debit Credit Balance Cash Date Explanation Ref. Debit Credit Balance Accounts Receivable Date Explanation Ref. Debit Credit Balance Supplies Date Explanation Ref. Debit Credit Balance Prepaid Insurance Date Explanation Ref. Debit Credit Balance Equipment Date Explanation Ref. Debit Credit Balance Proiect B Using the excel spreadsheet also attached to this Canvas page, complete the accounting cycle. Answer all the questions in this problem. The trial balance columns of the worksheet for Marigold at March 31, 2019, are as follows. Marigold Worksheet For the Month Ended March 31, 2019 Account Titles Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Equipment Accounts Pavable Unearned Service Revenue Common Stock Retained Earnings Dividends Service Revenue Salaries and Wages Expense Miscellaneous Expense Trial Balance Dr. Cr. 5,000 2.800 1,740 11.088 1,260.0 2.000 440 10.295 2,873 1.170 6,500 1.100 470 23,368 23,368 Other data: 1. A physical count reveals only $400 of roofing supplies on hand. 2. Depreciation for March is $252. 3. Unearned service revenue amounted to $220 at March 31. 4. Accrued salaries are $700. Requirements: 1. Journalize the adjusting entries from the adjustments columns of the worksheet 2. Enter the trial balance on a worksheet and complete the worksheet. (Ladger) tries from the financial statement columns of the worksheet Prepare an income statement for the month of March 5. Prepare a retained earnings statement for the month of March 6. Prepare a classified balance sheet at March 31. Cash Date Explanation Ref. Debit Credit Balance Accounts Receivable Date Explanation Ref. Debit Credit Balance Supplies Date Explanation Ref. Debit Credit Balance Prepaid Insurance Date Explanation Ref. Debit Credit Balance Equipment Date Explanation Ref. Debit Credit Balance Credit Debit General Journal Account Titles Date mit Inn Mmmm ut in m m m m ut in mm m m Income Statement For the Month Ended March 31, 2019 - ON 000 Retained Earnings Statement For the Month Ended March 31, 2019 -am TO Balance Sheet March 31, 2019 Assets AWN- OG OVO AWN Liabilities and Stockholders' Equity 16600 V A B C D E F G H Dividends Ref. Date Explanation Debit Balance Income Summary Ref. Date Explanation Debit Credit Balance Service Revenue Ref. Date Explanation Debit Credit Balance Accumulated Depreciation - Equipment Explanation Ref. Debit Date Credit Balance Accounts Payable Ref. Date Explanation Debit Credit Balance Salaries and Wages Payable Explanation Ref. Debit Date Credit Balance Common Stock Date Explanation Ref Debit Credit Balance Retained Earnings Ref. Date Explanation Debit Credit Balance Cash Date Explanation Ref. Debit Credit Balance Accounts Receivable Date Explanation Ref. Debit Credit Balance Supplies Date Explanation Ref. Debit Credit Balance Prepaid Insurance Date Explanation Ref. Debit Credit Balance Equipment Date Explanation Ref. Debit Credit Balance
