chapter 4 Ultimate writer

chapter_4_q4.docx

Completing an end-of-period spreadsheet

Alert Security Services Co. offers security services to business clients.

Complete the end-of-period spreadsheet for Alert Security Services Co. Leave cells blank that do not require an entry.

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2016


1		Adjusted	Adjusted
2		Trial Balance	Trial Balance	Income Statement	Income Statement	Balance Sheet	Balance Sheet
3	Account Title	Debit	Credit	Debit	Credit	Debit	Credit
4	Cash	18.00
5	Accounts Receivable	105.00
6	Supplies	5.00
7	Prepaid Insurance	4.00
8	Land	196.00
9	Equipment	50.00
10	Accumulated Depreciation-Equipment		12.00
11	Accounts Payable		36.00
12	Wages Payable		2.00
13	Brenda Schultz, Capital		254.00
14	Brenda Schultz, Drawing	6.00
15	Fees Earned		224.00
16	Wages Expense	109.00
17	Rent Expense	10.00
18	Insurance Expense	8.00
19	Utilities Expense	6.00
20	Supplies Expense	5.00
21	Depreciation Expense	4.00
22	Miscellaneous Expense	2.00
23	Totals	$528.00	$528.00
24	Net income (loss)
25