Exercise 4-24
Score:
Key Code:
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 12 –
Accounts Receivable 90 –
Supplies 8 –
Prepaid Insurance 12 –
Land 190 –
Equipment 50 –
Accum. Depreciation – 4
Accounts Payable – 36
Wages Payable – –
Brenda Schultz, Capital – 260
Brenda Schultz, Drawing 8 –
Fees Earned – 200
Wages Expense 110 –
Rent Expense 12 –
Insurance Expense – –
Utilities Expense 6 –
Supplies Expense – –
Depreciation Expense – –
Miscellaneous Expense 2 –
500 500
2
Cells with non-gray backgrounds are protected and cannot be edited.
Section:
0%
Name:
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2016
Adjustments
Unadjusted Trial Balance
Exercise 4-24
Solution
Scoring:
Instructions
Answers are entered in the cells with gray backgrounds.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 12 – – – 12 –
Accounts Receivable 90 – (a) 13 – 103 –
Supplies 8 – – (b) 4 4 –
Brenda Schultz, Capital – 260 – – – 260
Brenda Schultz, Drawing 8 – – – 8 –
An asterisk (*) will appear to the right of an incorrect entry.
ALERT SECURITY SERVICES CO.
Name:
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2016
Unadjusted Trial Balance
Adjustments
Exercise 4-25
Score:
Key Code:
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 12 –
Accounts Receivable 103 –
Supplies 4 –
Prepaid Insurance 2 –
Land 190 –
Equipment 50 –
Accum. Depreciation – 7
Accounts Payable – 36
Wages Payable – 1
Brenda Schultz, Capital – 260
Brenda Schultz, Drawing 8 –
Fees Earned – 213
Wages Expense 111 –
Rent Expense 12 –
Insurance Expense 10 –
Utilities Expense 6 –
Supplies Expense 4 –
Depreciation Expense 3 –
Miscellaneous Expense 2 –
517 517
ALERT SECURITY SERVICES CO.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2016
Income Statement
Adjusted Trial Balance
Student
2
Cells with non-gray backgrounds are protected and cannot be edited.
Section:
0%
Name:
Exercise 4-25
Solution
Scoring:
Instructions
Answers are entered in the cells with gray backgrounds.
For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank.
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 12 – – – 12 –
Accounts Receivable 103 – – – 103 –
Brenda Schultz, Drawing 8 – – – 8 –
Fees Earned – 213 – 213 – –
Wages Expense 111 – 111 – – –
Rent Expense 12 – 12 – – –
Insurance Expense 10 – 10 – – –
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2016
Adjusted Trial Balance
Income Statement
An asterisk (*) will appear to the right of an incorrect entry.
ALERT SECURITY SERVICES CO.
Name:
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Key Code:
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
Total expenses
Net income
Current assets: Current liabilities
Total liabilities
Total current assets
Property, plant, and equipment:
Total property, plant, and equipment
Total assets Total liabilities and owner’s equity
Section:
0%
Expenses:
2
Cells with non-gray backgrounds are protected and cannot be edited.
ALERT SECURITY SERVICES CO.
Income Statement
Revenues:
For the Year Ended October 31, 2016
Brenda Schultz, capital, October 31, 2016
Brenda Schultz, capital, November 1, 2015
Owner’s Equity
ALERT SECURITY SERVICES CO.
Balance Sheet
ALERT SECURITY SERVICES CO.
Liabilities
Name:
Statement of Owner’s Equity
October 31, 2016
Exercise 4-26
Assets
For the Year Ended October 31, 2016
Scoring:
Instructions
Increase in owner’s equity
Less withdrawals
Wages payable
Brenda Schultz, capital
Supplies
Prepaid insurance
Equipment
Accumulated depreciation
Accounts receivable
Answers are entered in the cells with gray backgrounds.
213$
111$
12
10
260$
65$
Current assets: Current liabilities
12$ 36$
Brenda Schultz, capital, November 1, 2015
Wages expense
ALERT SECURITY SERVICES CO.
Statement of Owner’s Equity
Rent expense
Name:
Section:
ON
Accounts payable
Cash
An asterisk (*) will appear to the right of an incorrect entry.
Fees earned
Net income for the year
ALERT SECURITY SERVICES CO.
Cells with non-gray backgrounds are protected and cannot be edited.
ALERT SECURITY SERVICES CO.
Income Statement
For the Year Ended October 31, 2016
Revenues:
Expenses:
Balance Sheet
October 31, 2016
Assets
Liabilities
Insurance expense
Exercise 4-26
Solution
For the Year Ended October 31, 2016
Depreciation expense
Miscellaneous expense
Utilities expense
Supplies expense