Chapter 4, Problem 4.23EX

Appendix 1

Completing an end-of-period spreadsheet

Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.:

Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31,2018
Account Title	Adjusted Trial Balance		Income Statement		Balance Sheet
	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.
Cash	12
Accounts Receivable	103
Supplies	4
Prepaid Insurance	2
Land	190
Equipment	50
Accum. Depr.—Equipment		7
Accounts Payable		36
Wages Payable		1
Common Stock		50
Retained Earnings		210
Dividends	8
Fees Earned		213
Wages Expense	111
Rent Expense	12
Insurance Expense	10
Utilities Expense	6
Supplies Expense	4
Depreciation Expense—Equip.	3
Miscellaneous Expense	2
Net income (loss)	517	517