Exercise 5.3 (Algo) Worksheet through Adjusted Trial Balance. LO 5-1, 5-2

On January 31, 20X1, the general ledger of Johnson Company showed the following account balances.

Accounts Cash61,000Accounts receivable20,500Supplies7,000Prepaid insurance6,200Equipment89,500Accumulated depreciationEquipment0Accounts payable14,700Elicia Johnson, Capital79,950Fees income107,000Rent expense8,600Salaries expense8,850Supplies expense0Insurance expense0Depreciation expenseEquipment0

Additional information:

1. Supplies used during January totaled $4,700.
2. Expired insurance totaled $1,550.
3. Depreciation expense for the month was $1,325.

Complete the worksheet through the Adjusted Trial Balance section. Assume that every account has the normal debit or credit balance. The worksheet covers the month of January.