Comprehensive Problem $1$

Part $5$: Work Sheet

The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts $1,2,3,4$ before completing part $5.$

Part $5$: Enter the unadjusted trial balance on an end$-$of$-$period spreadsheet $($work sheet$)$ and complete the spreadsheet using the following adjustment data.

Insurance expired during May is $$275.$

Supplies on hand on May $31$ are $$715.$

Depreciation of office equipment for May is $$330.$

Accrued receptionist salary on May $31$ is $$325.$

Rent expired during May is $$1,600.$

Unearned fees on May $31$ are $$3,210.$

If an amount box does not require an entry, leave it blank or enter $"0".$

Kelly Consulting

End$-$of$-$Period Spreadsheet $($Work Sheet$)$

For the Month Ended May $31,20$Y$8$

Account Title Unadjusted Trial

Balance Debit Unadjusted Trial

Balance Credit Adjustments

Debit Adjustments

Credit Adjusted Trial

Balance Debit Adjusted Trial

Balance Credit Income Statement

Debit Income Statement

Credit Balance Sheet

Debit Balance Sheet

Credit

Cash fill in the blank $1$

fill in the blank $2$

fill in the blank $3$

fill in the blank $4$

fill in the blank $5$

fill in the blank $6$

fill in the blank $7$

fill in the blank $8$

fill in the blank $9$

fill in the blank $10$

Accounts Receivable fill in the blank $11$

fill in the blank $12$

fill in the blank $13$

fill in the blank $14$

fill in the blank $15$

fill in the blank $16$

fill in the blank $17$

fill in the blank $18$

fill in the blank $19$

fill in the blank $20$

Supplies fill in the blank $21$

fill in the blank $22$

fill in the blank $23$

fill in the blank $24$

fill in the blank $25$

fill in the blank $26$

fill in the blank $27$

fill in the blank $28$

fill in the blank $29$

fill in the blank $30$

Prepaid Rent fill in the blank $31$

fill in the blank $32$

fill in the blank $33$

fill in the blank $34$

fill in the blank $35$

fill in the blank $36$

fill in the blank $37$

fill in the blank $38$

fill in the blank $39$

fill in the blank $40$

Prepaid Insurance fill in the blank $41$

fill in the blank $42$

fill in the blank $43$

fill in the blank $44$

fill in the blank $45$

fill in the blank $46$

fill in the blank $47$

fill in the blank $48$

fill in the blank $49$

fill in the blank $50$

Office Equipment fill in the blank $51$

fill in the blank $52$

fill in the blank $53$

fill in the blank $54$

fill in the blank $55$

fill in the blank $56$

fill in the blank $57$

fill in the blank $58$

fill in the blank $59$

fill in the blank $60$

Accum. Depreciation fill in the blank $61$

fill in the blank $62$

fill in the blank $63$

fill in the blank $64$

fill in the blank $65$

fill in the blank $66$

fill in the blank $67$

fill in the blank $68$

fill in the blank $69$

fill in the blank $70$

Accounts Payable fill in the blank $71$

fill in the blank $72$

fill in the blank $73$

fill in the blank $74$

fill in the blank $75$

fill in the blank $76$

fill in the blank $77$

fill in the blank $78$

fill in the blank $79$

fill in the blank $80$

Salaries Payable fill in the blank $81$

fill in the blank $82$

fill in the blank $83$

fill in the blank $84$

fill in the blank $85$

fill in the blank $86$

fill in the blank $87$

fill in the blank $88$

fill in the blank $89$

fill in the blank $90$

Unearned Fees fill in the blank $91$

fill in the blank $92$

fill in the blank $93$

fill in the blank $94$

fill in the blank $95$

fill in the blank $96$

fill in the blank $97$

fill in the blank $98$

fill in the blank $99$

fill in the blank $100$

Common Stock fill in the blank $101$

fill in the blank $102$

fill in the blank $103$

fill in the blank $104$

fill in the blank $105$

fill in the blank $106$

fill in the blank $107$

fill in the blank $108$

fill in the blank $109$

fill in the blank $110$

Retained Earnings fill in the blank $111$

fill in the blank $112$

fill in the blank $113$

fill in the blank $114$

fill in the blank $115$

fill in the blank $116$

fill in the blank $117$

fill in the blank $118$

fill in the blank $119$

fill in the blank $120$

Dividends fill in the blank $121$

fill in the blank $122$

fill in the blank $123$

fill in the blank $124$

fill in the blank $125$

fill in the blank $126$

fill in the blank $127$

fill in the blank $128$

fill in the blank $129$

fill in the blank $130$

Fees Earned fill in the blank $131$

fill in the blank $132$

fill in the blank $133$

fill in the blank $134$

fill in the blank $135$

fill in the blank $136$

fill in the blank $137$

fill in the blank $138$

fill in the blank $139$

fill in the blank $140$

Salary Expense fill in the blank $141$

fill in the blank $142$

fill in the blank $143$

fill in the blank $144$

fill in the blank $145$

fill in the blank $146$

fill in the blank $147$

fill in the blank $148$

fill in the blank $149$

fill in the blank $150$

Rent Expense fill in the blank $151$

fill in the blank $152$

fill in the blank $153$

fill in the blank $154$

fill in the blank $155$

fill in the blank $156$

fill in the blank $157$

fill in the blank $158$

fill in the blank $159$

fill in the blank $160$

Supplies Expense fill in the blank $16$