Requirement 4. Prepare a worksheet as of December 31, 2018 The Unadjusted Trial Balance columns have been completed for you using the unadjusted trial balance you prepared in Requirement 3 Complete the worksheet one section at a time beginning with the Adjustments section. Enter the adjustments along with the adjustment letter references (a), (b), (c), etc.-into the columns as appropriate. In the following step, complete the Adjusted Trial Balance section of the worksheet. For this section, and for the Income Statement and Balance Sheet sections, enter a "0" on the normal side of the account for any accounts with a zero balance. Lastly, complete the worksheet by preparing the Income Statement and Balance Sheet columns. For the Income Statement and Balance Sheet sections, only enter the "O" for a zero balance if the account is typically included in that section of the worksheet (Abbreviations used: Acc. Accumulated, Dep. Depreciation, Exp. Expense.) (Click the icon to view the adjustment information.) Murphy Delivery Service Worksheet cember 31, 2018 Unadjusted Trial Balance DebitCredit Adjusted Balance Income Statement DebitCredit Debit Credit Debit Credit Adjustments Trial Balance Sheet Account Title 21,500 1,400 750 600 9,000 21,500 1,850 450 (C) 100 500 9,000 21500 1850 450 500 9000 () 450 Accounts Receivable Office Supplies Prepaid Insurance Truck Acc. Dep. Truck Accounts Payable Salaries Payable Unearned Revenue Common Stock Dividends Service Revenue (d) 300 (b) 100 100 0 800 1,500 22.000 (a) 800 800 1500 22000 2,200 (e) 700 22,000 2,500 2,500 2500 (e) 700 () 450 13,900 15,050 15050 1,600 100 100 150 1,400 300 (a) 800 (b) 100 Salaries Expense Dep. Exp.-Truck Insurance Expense 1600 100 100 150 1400 800 nse 150 Rent Expense 1,400 300 Supplies Expense 38,100 38,100 2.450 2,450 39,45039,450 615015050 33300 24400 Net income or loss 8900 8900 15050 15050 33300 Enter any number in the edit fields and then click Check Answer More Info a. Accrued Salaries Expense, $800 b. Depreciation was recorded on the truck using the straight-line method. Assume a useful life of five years and a salvage value of $3,000. c. Prepaid Insurance for the month has expired. d. Office supplies on hand, $450. e. Unearned Revenue earned during the month, $700. f. Accrued Service Revenue, $450. Print Done More Info Dec. 1Murphy Delivery Service began operations by receiving $13,000 cash and a truck with a fair value of $9,000 from Russ Murphy. The business issued Murphy shares of common stock in exchange for this contribution Paid $600 cash for a six-month insurance policy. The policy begins December 1 Paid $750 cash for office supplies. Performed delivery services for a customer and received $2,200 cash. Completed a large delivery job, billed the customer, $3,300, and received a promise to collect the $3,300 within one week. Paid employee salary, $800. Received $7,000 cash for performing delivery services. Collected S2,200 in advance for delivery service to be performed later. Collected $3,300 cash from customer on account. Purchased fuel for the truck, paying $150 on account. (Credit Accounts Payable) Performed delivery services on account, $1,400. Paid office rent, $1,400, for the month of December. Paid $150 on account. Cash dividends of $2,500 were paid to stockholders. 1 4 12 15 18 20 22 25 27 28 29 30 31
