IMPORTANT: For the homework: Record the entries below, NOT the ones you see on the video. Delete the adjusting entries from Part $6$ above and insert the adjusting entries instead:

a$.$ Supplies on hand is $$12,000.$

e$.$ Unpaid salaries are $$1,500.$

b$.$ Depreciation for period was $$750.$

f$.$ Two$-$thirds of unearned revenue

c$.$ Accrued interest on notes payable has now been earned. is $$900.$

d$.$ One$-$third of insurance has expired.

g$.$ Received bill for Utilities Expense for $$300.($Use $\frac{A}{P})$

Excel Trainers, Inc.

Worksheet

Month Ended January $31$

$\backslash$table$[[,,$Trial Balance,Adjustments,Adjusted Trial Balance$],[,,$Debit,Credit,,Debit,,Credit,Debit,Credit$],[,$Cash,$60,000,,,,,,60,000,],[,$Accounts Receivable,$10,000,,,,,,10,000,],[,$Supplies,$19,000,,,,,0,19,000,],[,$Prepaid Insurance,$36,000,,,,,0,36,000,],[,$Equipment,$64,000,,,,,,64,000,],[2,$Accumulated Dep. $-$ Equipment,,$5,000,,,,,,5,000],[3,$Accounts Payable,,$12,000,,,,,,12,000],[4,$Notes Payable,,$30,000,,,,,,30,000],[5,$Unearned Revenue,,$3,000,,,,,,3,000],[16,$Interest Payable,,,,,,,,$],[17,$Salaries Payable,,$218,,,,,,],[18,$Common Stock,,$96,000,,,,,,96,000],[19,$Retained Earnings,,$7,000,,,,,,7,000],[20,$Service Income,,$70,000,,,,,,70,000],[21,$Salaries Expense,$28,000,\sqrt[\phantom{2}]{313},,,2,,28,000,],[22,$Insurance Expense,,,b$,0,,,,],[23,$Depreciation Expense,,,,,,,,$],[24,$Supplies Expense,,,a$,0,,,,],[25,$Utilities Expense,$6,000,,,-,,,6,000,],[26,$Interest Expense,,,,,,,,$],[27,$Totals,$223,000,223,000,0,,0,0,223,000,223,000]]$