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,20$Y$3$

Account Title Adjusted

Trial Balance

Dr$.$ Adjusted

Trial Balance

Cr$.$ Income

Statement

Dr$.$ Income

Statement

Cr$.$ Balance Sheet

Dr$.$ Balance Sheet

Cr$.$

Cash $118$

Accounts Receivable $862$

Supplies $39$

Prepaid Insurance $29$

Land $980$

Equipment $392$

Accum. Depr.$$Equipment $78$

Accounts Payable $353$

Wages Payable $39$

Common Stock $40$

Retained Earnings $1,666$

Dividends $78$

Fees Earned $960$

Wages Expense $235$

Rent Expense $118$

Insurance Expense $98$

Utilities Expense $69$

Supplies Expense $59$

Depreciation Expense$$Equip$.39$

Miscellaneous Expense $20$

Total $3,1363,136$

Question Content Area

Prepare an income statement for Alert Security Services Co$.$

Alert Security Services Co$.$

Income Statement

For the Year Ended October $31,20$Y$3$

Line Item Description Amount Amount

Fees earned

$Fees earned

$960$

Expenses:

Wages expense

$Wages expense

$39$

Rent expense

Rent expense

$118$

Insurance expense

Insurance expense

$98$

Utilities expense

Utilities expense

$69$

Supplies

Supplies

$59$

Depreciation expense$-$equipment

Depreciation expense$-$equipment

$39$

Miscellaneous expense

Miscellaneous expense

$20$

Total expenses Total expenses

$442$

Net income

$Net income

$518$

Question Content Area

Prepare a statement of stockholders$$ equity for Alert Security Services Co$.$ During the year ended October $31,20$Y$3,$ common stock of $$11$ was issued. If an amount box does not require an entry, leave it blank. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign.

Alert Security Services Co$.$

Statement of Stockholders$$ Equity

For the Year Ended October $31,20$Y$3$

Line Item Description Common

Stock Retained

Earnings

Total

Balances, October $31,20$Y$3$

$Balances, October $31,20$Y$3$

$Balances, October $31,20$Y$3$

$Balances, October $31,20$Y$3$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

Net income

Net income

Net income

Net income

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

Balances, November $1,20$Y$2$

$Balances, November $1,20$Y$2$

$Balances, November $1,20$Y$2$

$Balances, November $1,20$Y$2$

Question Content Area

Prepare a balance sheet for Alert Security Services Co$.$

Alert Security Services Co$.$

Balance Sheet

October $31,20$Y$3$

Line Item Description Amount Amount Amount

Assets

Current assets:

Cash

$Cash

Accounts receivable

Accounts receivable

Supplies

Supplies

Prepaid insurance

Prepaid insurance

Total current assets $Total current assets

Property, plant, and equipment:

Land

$Land

Equipment

$Equipment

Accumulated depreciation$-$equipment

Accumulated depreciation$-$equipment

Dividends

Dividends

Total property, plant, and equipment Total property, plant, and equipment

Total assets $Total assets

Liabilities

Current liabilities:

Accounts payable

$Accounts payable

Wages payable

Wages payable

Total liabilities $Total liabilities

Stockholders' Equity

$$-$ Select $-$

$-$ Select $-$

Total stockholders' equity Total stockholders' equity

Total liabilities and stockholders' equity $Total liabilities and stockholders' equity