12345

The unadjusted trial balance of Epicenter Laundry at June 30,20Y6, the end of the fiscal year, follows: Chapter Four Homework eBook Spreadsheet Print item UNADJUSTED TRIAL BALANCE June 30, 20 Y6 The data neoded to determine year-end adjustments aro as follows: (a) Laundry supplies on hand at June 30 are $8,600 (b) Insurance premiums expired during the year are $5,700. (c) Depreciation of laundry equipment during the year is $6,500 (d) Wages accrued but not paid at June 30 are $1,100 Required: Note: Download the spreadsheet on the T Accounts panet sawing the Excel filo to your computer. Be sure to save your work in Excel. The spreadsheet input will not be included in your grade in CengagowOW on this probiem 1. For each account bsted in the unadjusted trial balance, enter the balance in a T account identify the balance as "Bal " 2 Using the Excel spreadsheet downiagded from the T Accounts panel cack the Wouk Shee tab. Enter the unadusted trial balance on the end of penod work sheet and complete the work sheet 3. a. Jounakize the aquating entries on page 10 of the journal. ACfusting entres are recorded on Juno 30 4 Prepare an adjusted trial balance. 5 a Prepare an income statement far the year ended June 30,20r6