Appendix 1 Completing an EndofPeriod Spreadsheet Alert Secur

Appendix 1: Completing 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, 2018 Adjusted Trial Balance Income Statement Balance Sheet Account Title Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment Accum. Depr. Equipment Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Equip Miscellaneous Expense Cr Cr. Dr. Cr 450 3,300 150 113 3,750 1,500 300 1,350 150 40 6,486 300 3,675 900 450 375 263 225 150 75 12,001 12,001 Complete the following end-of-period spreadsheet for Alert Security Services Co. If a box does not require an entry, leave it blank. Enter all amounts as positive numbers.

Solution

Plz find the solution below:

Income Statement
Particulars	Amount	Particulars	Amount
Wages expense	900	Fees Earned	3675
Rent Expense	450
Insurance Expense	375
Utilities Expense	263
Supplies expense	225
Depreciation expense	150
Miscellanous expense	75
Net profit	1237
	3675		3675
Dividend	300
Profit transferred to Balance sheet	937