The owner of Waltz Company has asked you to prepare a worksheet from the following trial balance and additional data:

Additional Data

1. Physical count of inventory on December 31, $4,805

2. Office supplies used up, $210

3. Rent expired, $195

4. Depreciation expense on office equipment, $550

5. Office salaries earned but not paid, $310

Trial Balance for Waltz Company

Transcribed Image Text:

WALTZ COMPANY TRIAL BALANCE DECEMBER 31, 2020 Dr. Cr. 540800 24000 Cash Petty Cash 251200 509200 616 00 94400 928000 Accounts Receivable Merchandise Inventory Prepaid Rent Office Supplies Office Equipment 760000 5964 00 547600 Accumulated Depreciation, Office Equipment Accounts Payable K. Waltz, Capital K. Waltz, Withdrawals 480000 52 48 4 00 9600 Sales Sales Returns and Allowances 240000 28 95 200 7408 00 2400 00 80000 57600 Sales Discounts Cost of Goods Sold Office Salaries Expense Insurance Expense Advertising Expense Utilities Expense 71 5 2400 71 52400