Now that you have completed the June bank reconciliation process, you are asked to complete the worksheet for Hi-Fi Way.

The worksheet is an internal document that exists outside the journals and ledgers. It is often used in the manual accounting system to help record adjusting entries and prepare financial statements. After you have prepared the worksheet, in the next section of the practice set you will be asked to use the completed worksheet to help journalize and post adjusting entries to general ledger. You will also use this worksheet to assist you in preparing the financial statements for Hi-Fi Way in a later section of this practice set.

The details of the end of month adjustments for June are as follows:

• Office Furniture owned by the business: original purchase price was $8,000, estimated useful life was 4 years, and estimated residual value was $1,500 at the end of the useful life. Depreciation is calculated on a monthly basis using the straight line method. The monthly depreciation charge is calculated as the yearly depreciation expense divided by the number of months in a year.
• Office Equipment owned by the business: original purchase price was $49,000, estimated useful life was 11 years, and estimated residual value was $5,500 at the end of the useful life. Depreciation is calculated on a monthly basis using the straight line method. The monthly depreciation charge is calculated as the yearly depreciation expense divided by the number of months in a year.
• The water usage for the month of June is estimated to be $120.
• The estimated electricity payable as at the end of June is $282.
• Sales staff work every single day during the week including weekends and are paid on a weekly basis. Wages were last paid up to and including 24 June. Wages incurred after that day (from June 25 to June 30 inclusive) are estimated to have been $1,890 per day.
• Interest expense incurred during the month of June but not yet paid to ZNZ Bank for the bank loan is $265.
• Office supplies totaling $1,944 are still on hand at June 30.
• One month of prepaid rent expired during June. Remember that at the beginning of June, the business paid two month's worth of rent in advance.
• 3 months of advertising remained pre-paid at the start of June.
• 5 months of insurance remained pre-paid at the start of June.

When calculating the portion of prepayments that expire during the month of June, you are asked to assume that an equal amount of expense is incurred per month.

After taking a physical count of inventory at the end of the month, the balance of inventory on hand as at June 30 is found to be equal to the closing balance of the Merchandise Inventory account. This means there is no adjusting entry required for inventory shrinkage.

Acct. No. 100 110 120 130 140 141 142 150 151 160 161 210 220 221 222 225 250 300 301 400 401 402 403 500 511 516 540 541 542 543 544 545 560 561 571 572 Account Name Cash ARC - Accounts Receivable Control Merchandise inventory Office supplies Prepaid rent Prepaid advertising Prepaid insurance Office furniture Accum Depn: Office furniture Office equipment Accum Depn: Office equipment APC - Accounts Payable Control Wages payable Electricity payabe Water payable Interest payable Bank loan payable Common stock Retained earnings Sales revenue Sales returns and allowances Sales discounts Interest revenue Cost of goods sold Advertising expense Wages expense Rent expense Electricity expense Water expense insurance expense Office supplies expense Salary expense Depn Expense: Office furniture Depn Expense: Office equipment Interest expense Admin. Expense - Bank charges Totals Unadjusted Trial Balance Debit Credit 149127 102312 66528 2700 8000 12000 4200 8000 3115 49000 22409 46843 52 114 53000 55000 204610 167296 1136 314 793 99672 45631 4600 12 553232 553232 Adjustments Debit Credit Adjusted Trial Balance Debit Credit Net income or loss Totals Income Statement Debit Credit Balance Sheet Debit Credit