60.1K

Verified Solution

Link Copied!

Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2016:

Alert Security Services Co.

End-of-Period Spreadsheet

For the Year Ended October 31, 2016

1		Unadjusted	Unadjusted			Adjusted	Adjusted
2		Trial Balance	Trial Balance	Adjustments	Adjustments	Trial Balance	Trial Balance
3		Debit	Credit	Debit	Credit	Debit	Credit
4	Cash	18.00
5	Accounts Receivable	90.00
6	Supplies	14.00
7	Prepaid Insurance	14.00
8	Land	198.00
9	Equipment	53.00
10	Accumulated Depreciation-Equipment		7.00
11	Accounts Payable		37.00
12	Wages Payable		0.00
13	Common Stock		50.00
14	Retained Earnings		231.00
15	Dividends	5.00
16	Fees Earned		203.00
17	Wages Expense	108.00
18	Rent Expense	20.00
19	Insurance Expense	0.00
20	Utilities Expense	6.00
21	Supplies Expense	0.00
22	Depreciation Expense	0.00
23	Miscellaneous Expense	2.00
24	Totals	$528.00	$528.00

The data for year-end adjustments are as follows:

	Fees earned, but not yet billed, $13.
	Supplies on hand, $7.
	Insurance premiums expired, $7.
	Depreciation expense, $4.
	Wages accrued, but not paid, $2.

Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.

Answer & Explanation Solved by verified expert

See Answer