Build a worksheet in the following format

the following is the adjusted information for December.

These are the beginning balances

what additional information are you needing?

JW's Lock & Key Work Sheet Ad. Trial Balance Unadj. Trial Bal ance Credit Adjustments Credit Debit Income Staternent Debit Balance Sheet Credit Account Debit Debit Credit Credit Debit Cash Accounts Receivable Inventory E stimated Returns Inventory Office Supplies Prepaid Insurance Equipment Accum. Depreciation -Equip. Accounts Payable Refunds Payable Unearned Service Revenue Jake Walters, Jake Walters Service Revenue Capital Withdrawal Sales Revenue Sales Discounts Forfeited Cost of Merchandise Sold Advertising Expense Depreciation Expense Insurance Expense Office Supplies Expense Salary Expense Rent Expense Telephone Expense Utilities Expense Miscellaneous Expense TOTALS NET INCOME LOSS Prepare an Unadjusted Trial Balance, using the worksheet. Complete the worksh lowing adjustment information for December: Office supplies on hand on December 31 are $1,050. A physical count of inventory showed an ending inventory cost of $44,500. Recorded depreciation on equipment for the month, $4,200. Insurance expired during December is $300. Earned $1,700 worth of the unearned service revenue. Sales refunds estimated for the year $10,000 Cost of estimated returns for the year $2,000 a. b. . d. e. f. Beginning balances: Cash 154,931 A/R 4,108 Inventory 46,525 Estimated Returns 700 Office Supplies 1,235 Prepaid Insurance 300 Equipment 265,000 Accumulated Depreciation 115,500 A/P 3,433 Refund Payable 500 Unearned Service Revenue 500 Jake Walter's, Capital 262,643 Jake Walter's, Withdrawal 112,000 Service Revenue 167,050 Sales Revenue 312,900 Sales Discount Forfeited 2,450 Cost of Merchandise Sold 145,687 Advertising Expense 9,250 Depreciation Expense 38,500 Insurance Expense 3,500 Office Supplies Expense 3,280 Salary Expense 37,500 Rent Expense 27,500 Telephone Expense 4770 Utilities Expense 6,725 Misc. Expense 3,465 JW's Lock & Key Work Sheet Ad. Trial Balance Unadj. Trial Bal ance Credit Adjustments Credit Debit Income Staternent Debit Balance Sheet Credit Account Debit Debit Credit Credit Debit Cash Accounts Receivable Inventory E stimated Returns Inventory Office Supplies Prepaid Insurance Equipment Accum. Depreciation -Equip. Accounts Payable Refunds Payable Unearned Service Revenue Jake Walters, Jake Walters Service Revenue Capital Withdrawal Sales Revenue Sales Discounts Forfeited Cost of Merchandise Sold Advertising Expense Depreciation Expense Insurance Expense Office Supplies Expense Salary Expense Rent Expense Telephone Expense Utilities Expense Miscellaneous Expense TOTALS NET INCOME LOSS Prepare an Unadjusted Trial Balance, using the worksheet. Complete the worksh lowing adjustment information for December: Office supplies on hand on December 31 are $1,050. A physical count of inventory showed an ending inventory cost of $44,500. Recorded depreciation on equipment for the month, $4,200. Insurance expired during December is $300. Earned $1,700 worth of the unearned service revenue. Sales refunds estimated for the year $10,000 Cost of estimated returns for the year $2,000 a. b. . d. e. f. Beginning balances: Cash 154,931 A/R 4,108 Inventory 46,525 Estimated Returns 700 Office Supplies 1,235 Prepaid Insurance 300 Equipment 265,000 Accumulated Depreciation 115,500 A/P 3,433 Refund Payable 500 Unearned Service Revenue 500 Jake Walter's, Capital 262,643 Jake Walter's, Withdrawal 112,000 Service Revenue 167,050 Sales Revenue 312,900 Sales Discount Forfeited 2,450 Cost of Merchandise Sold 145,687 Advertising Expense 9,250 Depreciation Expense 38,500 Insurance Expense 3,500 Office Supplies Expense 3,280 Salary Expense 37,500 Rent Expense 27,500 Telephone Expense 4770 Utilities Expense 6,725 Misc. Expense 3,465