EX 4-25 Completing an end-of-period spreadsheet (work sheet)
Zeidman Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet (work sheet) for Zeidman Security Services Co.
|
Zeidman Security Services Co. |
||||||
|
End-of-Period Spreadsheet (Work Sheet) |
||||||
|
For the Year Ended July 31, 2012 |
||||||
|
Adjusted |
Income |
Balance |
||||
|
Trial Balance |
Statement |
Sheet |
||||
|
Account Title |
Dr. | Cr. | Dr. | Cr. | Dr. | Cr. |
|
Cash |
12 |
|||||
|
Accounts Receivable |
89 |
|||||
|
Supplies |
3 |
|||||
|
Prepaid Insurance |
4 |
|||||
|
Land |
100 |
|||||
|
Equipment |
40 |
|||||
|
Accum. Depr.—Equipment |
8 |
|||||
|
Accounts Payable |
36 |
|||||
|
Wages Payable |
1 |
|||||
|
Alex Zeidman, Capital |
170 |
|||||
|
Alex Zeidman, Drawing |
8 |
|||||
|
Fees Earned |
99 |
|||||
|
Wages Expense |
21 |
|||||
|
Rent Expense |
12 |
|||||
|
Insurance Expense |
8 |
|||||
|
Utilities Expense |
6 |
|||||
|
Supplies Expense |
5 |
|||||
|
Depreciation Expense |
4 |
|||||
|
Miscellaneous Expense |
2 |
|||||
|
314 |
314 |
|||||
|
Net income (loss) |
||||||