Chapter 4

Appendix 1: Financial Statements From an End-of-Period Spreadsheet

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

Alert Security Services Co.
End-of-Period Spreadsheet
For the Year Ended October 31, 2019
	Adjusted Trial Balance				Income Statement		Balance Sheet
Account Title	Dr.		Cr.		Dr.	Cr.	Dr.	Cr.
Cash	205
Accounts Receivable	1,505
Supplies	68
Prepaid Insurance	51
Land	1,710
Equipment	684
Accum. Depr.Equipment			137
Accounts Payable			616
Wages Payable			68
Brenda Schultz, Capital			2,974
Brenda Schultz, Drawing	137
Fees Earned			1,676
Wages Expense	410
Rent Expense	205
Insurance Expense	171
Utilities Expense	120
Supplies Expense	103
Depreciation Expense	68
Miscellaneous Expense	34
Totals	5,471		5,471
Net income (loss)

Prepare an income statement for Alert Security Services Co.

Alert Security Services Co.
Income Statement
For the Year Ended October 31, 2019
		$
Expenses:
	$
Total expenses
		$

Prepare a statement of owner's equity for Alert Security Services Co. Negative amounts should be indicated by a minus sign.

Alert Security Services Co.
Statement of Owner's Equity
For the Year Ended October 31, 2019
		$
	$
		$

Prepare a balance sheet for Alert Security Services Co.

Alert Security Services Co.
Balance Sheet
October 31, 2019
Assets
Current assets:
		$
Total current assets			$
Property, plant, and equipment:
		$
	$
Total property, plant, and equipment
Total assets			$
Liabilities
Current liabilities:
		$
Total liabilities			$
Owner's Equity
Total liabilities and owner's equity			$