Problem 4-5B
Solution
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
In the general ledger accounts, only normal balance columns will be graded.
In the trial balances and work sheet, enter a zero in cells you would otherwise leave blank.
1. and 2.
Page 1
Post.
Ref. Debit Credit
Cash
Accounts Receivable
Salary Expense
Cash
Accounts Payable
April 1 11 20,000
12 14,700
14 3,300
18 12,000
31 50,000
518 8,000
21 8,000
611 11,700
12 11,700
10 59 350
11 350
Page 2
Post.
Ref. Debit Credit
Accounts Receivable
Salary Expense
Miscellaneous Expense
Cash
Cash
Miscellaneous Expense
Cash
April 17 11 6,600
41 6,600
18 14 725
11 725
20 12 16,800
41 16,800
24 11 4,450
41 4,450
26 11 26,500
30 11 5,160
41 5,160
30 12 2,590
41 2,590
Common Stock
Office Equipment
2016
Accounts Receivable
Supplies
Cash
JOURNAL
Date
Name:
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Description
Accounts Receivable
Cash
Fees Earned
Description
Cash
Supplies
Fees Earned
2016
Cash
Fees Earned
Cash
JOURNAL
Date
Accounts Payable
Cash
Office Equipment
Fees Earned
Accounts Receivable
Miscellaneous Expense
Cash
Cash
Fees Earned
Accounts Receivable
Prepaid Rent
Cash
Prepaid Insurance
Cash
Cash
Unearned Fees
30 33 18,000
11 18,000
2., 6., and 9.
Cash
11
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 1 1
20,000 20,000
1 1
6,000 14,000
2 1
4,200 9,800
4 1
9,400 19,200
27 2
1,650 57,675
29 2
540 57,135
30 2
760 56,375
30 2
5,160 61,535
30 2
18,000 43,535
Accounts Receivable 12
Post.
Item Ref. Dr. Cr. Dr. Cr.
Supplies 14
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 1 1
3,300 3,300
18 2
725 4,025
30 Adjusting 3
2,800 1,225
Prepaid Rent 15
Post.
Item Ref. Dr. Cr. Dr. Cr.
Post.
Item Ref. Dr. Cr. Dr. Cr.
Balance
Date
2016
Office Equipment 18
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 1 1
12,000 12,000
5 1
8,000 20,000
Accumulated Depreciation 19
Post.
Item Ref. Dr. Cr. Dr. Cr.
Post.
Item Ref. Dr. Cr. Dr. Cr.
Date
2016
2016
Balance
Date
Salaries Payable 22
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 30 Adjusting 3
275 275
Unearned Fees 23
Balance
Balance
Balance
Balance
2016
2016
Balance
GENERAL LEDGER
Date
2016
Date
2016
Balance
Date
2016
Balance
Date
Date
Date
2016
Dividends
Cash
11,700 30,900
350 30,550
6,400 24,150
1,650 22,500
6,600 29,100
725 28,375
4,450 32,825
26,500 59,325
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 4 1
9,400 9,400
30 Adjusting 3
7,050 2,350
Common Stock 31
Post.
Dividends 33
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 30 2
18,000 18,000
30 Closing 4
18,000 – –
Income Summary 34
Post.
Item Ref. Dr. Cr. Dr. Cr.
2016
Fees Earned 41
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 12 1 21,900 21,900
Salary Expense 51
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 14 1 1,650 1,650
27 2 1,650 3,300
30 Adjusting 3 275 3,575
30 Closing 4 3,575 – –
Supplies Expense 52
Post.
Post.
Item Ref. Dr. Cr. Dr. Cr.
Date
2016
Balance
Date
2016
Item Ref. Dr. Cr. Dr. Cr.
April 30 Adjusting 3 2,800 2,800
30 Closing 4 2,800 – –
Insurance Expense 55
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 30 Adjusting 3 350 350
30 Closing 4 350 – –
Balance
Balance
Date
2016
Balance
Balance
Date
2016
2016
Balance
2016
Balance
Date
Balance
Date
2016
Balance
Date
2016
Date
Date
Item Ref. Dr. Cr. Dr. Cr.
Post.
Item Ref. Dr. Cr. Dr. Cr.
Date
Balance
Date
2016
2016
Miscellaneous Expense 59
Post.
Item Ref. Dr. Cr. Dr. Cr.
April 10 1350 350
29 2540 890
30 2760 1,650
30 Closing 4 1,650 – –
3.
43,535 –
Accounts Receivable 17,790 –
4,025 –
6,000 –
4,200 –
5.
Account Title Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr.
Cash 43,535 – – 43,535 – – – 43,535 –
Accounts Receivable 17,790 – – 17,790 – – – 17,790 –
Supplies 4,025 – (b) 2,800 1,225 – – – 1,225 –
Prepaid Rent 6,000 – (e) 2,000 4,000 – – – 4,000 –
Prepaid Insurance 4,200 – (a) 350 3,850 – – – 3,850 –
Supplies Expense (b) 2,800 – 2,800 – 2,800 – – –
Rent Expense (e) 2,000 – 2,000 – 2,000 – – –
Depreciation Expense (c) 400 – 400 – 400 – – –
Insurance Expense (a) 350 – 350 – 350 – – –
6.
Page 3
Post.
Depreciation Expense
Salary Expense
Rent Expense
Unearned Fees
Ref. Debit Credit
April 30 55 350
16 350
30 52 2,800
14 2,800
7.
For the Month Ended April 30, 2016
April 30, 2016
Cash
Supplies
Prepaid Rent
Debit
Balances
Credit
Balances
Prepaid Insurance
2016
ROSEBUD CONSULTING
Unadjusted Trial Balance
Date
JOURNAL
Description
Balance
Sheet
Trial Balance
Statement
Income
Balance
Unadjusted Trial Balance
Adjusted
End-of-Period Spreadsheet (Work Sheet)
Date
Credit
Balances
ROSEBUD CONSULTING
Adjustments
April 30, 2016
ROSEBUD CONSULTING
Debit
Balances
Adjusted Trial Balance
2016
Adjusting Entries
Insurance Expense
Prepaid Insurance
Supplies Expense
Supplies
Accounts Payable
Office Equipment
Common Stock
Dividends
Accumulated Depreciation
Salaries Payable
Miscellaneous expense
Insurance expense
Total expenses
Depreciation expense
Office equipment
Retained earnings
Accumulated depreciation
Common stock
Prepaid insurance
Supplies
Unearned fees
Prepaid rent
43,535 –
Accounts Receivable 17,790 –
1,225 –
4,000 –
3,850 –
20,000 –
– 400
– 1,600
– 275
Unearned Fees – 2,350
8.
64,550$
3,575$
2,800
2,000
–$
53,775$
18,000
35,775
35,775$
Current assets: Current liabilities:
43,535$ 1,600$
17,790 275
9.
Page 4
Post.
Supplies Expense
Rent Expense
Depreciation Expense
Salary Expense
Income Summary
Ref. Debit Credit
April 30 41 64,550
34 64,550
30 34 10,775
30 32 18,000
33 18,000
Fees Earned
Income Summary
Income Summary
Liabilities
JOURNAL
Description
Accounts payable
Accounts Payable
Expenses:
Income Statement
For the Month Ended April 30, 2016
Revenues:
Prepaid Insurance
Office Equipment
Accumulated Depreciation
Salary expense
Supplies expense
Rent expense
ROSEBUD CONSULTING
Cash
Supplies
Prepaid Rent
Fees earned
Total revenues
Less dividends
Increase in retained earnings
Retained earnings, April 1, 2016
For the Month Ended April 30, 2016
Salaries Payable
ROSEBUD CONSULTING
Accounts receivable
Salaries payable
Assets
Balance Sheet
April 30, 2016
Retained earnings, April 30, 2016
ROSEBUD CONSULTING
Retained Earnings Statement
Date
2016
Closing Entries
Net income for the month
Cash
Retained Earnings
Dividends
Dividends
Common Stock
10.
43,535 –
Accounts Receivable 17,790 –
1,225 –
4,000 –
3,850 –
ROSEBUD CONSULTING
April 30, 2016
Debit
Balances
Credit
Balances
Cash
Supplies
Prepaid Rent
Prepaid Insurance
Post-Closing Trial Balance
Office Equipment
Accumulated Depreciation
Accounts Payable
Retained Earnings
Salaries Payable
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.
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 – –
Common Stock – 50
Retained Earnings – 210
Dividends 8 –
Fees Earned – 200
Wages Expense 110 –
Rent Expense 12 –
Insurance Expense – –
Utilities Expense 6 –
Supplies Expense – –
Depreciation Expense – –
Miscellaneous Expense 2 –
500 500
[Key code here]
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
Trial Balance
Unadjusted Trial Balance
Adjusted
Exercise 4-24
Solution
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
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 –
Prepaid Insurance 12 – – (c) 10 2 –
Land 190 – – – 190 –
Equipment 50 – – – 50 –
Wages Expense 110 – (e) 1 – 111 –
Rent Expense 12 – – – 12 –
Insurance Expense – – (c) 10 – 10 –
Utilities Expense 6 – – – 6 –
Supplies Expense – – (b) 4 – 4 –
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
Adjusted
Trial Balance
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.
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
Common Stock – 50
Retained Earnings 210
Dividends 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
[Key code here]
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
Income Statement
Balance Sheet
Adjusted Trial Balance
Exercise 4-25
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
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 –
Wages Payable – 1 – – – 1
Common Stock – 50 – – – 50
Retained Earnings 210 – – – 210
Dividends 8 – – – 8 –
Fees Earned – 213 – 213 – –
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.
Solution
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2016
Balance Sheet
Adjusted Trial Balance
Income Statement
Exercise 4-26
Score:
Key Code:
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
[Key code here]
Cells with non-gray backgrounds are protected and cannot be edited.
Section:
0%
Name:
Total expenses
Net income (loss)
Current assets: Current liabilities:
Total liabilities
Total current assets
Property, plant, and equipment:
Total stockholders’ equity
Total property, plant, and equipment
Total assets Total liabilities and stockholders’ equity
ALERT SECURITY SERVICES CO.
Income Statement
Retained earnings, November 1, 2015
ALERT SECURITY SERVICES CO.
Expenses:
Balance Sheet
For the Year Ended October 31, 2016
ALERT SECURITY SERVICES CO.
Revenues:
For the Year Ended October 31, 2016
Retained earnings, October 31, 2016
October 31, 2016
Assets
Liabilities
Stockholders’ Equity
Retained Earnings Statement
Exercise 4-26
Score:
Instructions
Less dividends
Net income for the year
Accumulated depreciation
Common stock
Retained earnings
Equipment
Answers are entered in the cells with gray backgrounds.
213$
111$
12
10
210$
Current assets: Current liabilities:
12$ 36$
103 1
4 Total liabilities 37$
2
Balance Sheet
October 31, 2016
Wages expense
Expenses:
An asterisk (*) will appear to the right of an incorrect entry.
Cells with non-gray backgrounds are protected and cannot be edited.
Fees earned
ALERT SECURITY SERVICES CO.
Income Statement
For the Year Ended October 31, 2016
Revenues:
Solution
Name:
Section:
ON
Rent expense
Retained earnings, November 1, 2015
Insurance expense
For the Year Ended October 31, 2016
ALERT SECURITY SERVICES CO.
Retained Earnings Statement
Cash
Accounts receivable
ALERT SECURITY SERVICES CO.
Assets
Liabilities
Prepaid insurance
Wages payable
Supplies
Accounts payable
Depreciation expense
Utilities expense
Supplies expense
Score:
Key Code:
Instructions
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
In the general ledger accounts, only normal balance columns will be graded. For correct grading in the
trial balances, work sheet, and ledger balance columns, enter a zero in cells you would otherwise leave blank.
1. and 2.
Page 5
Post.
Ref. Debit Credit
May 3
5
9
13
15
16
17
Page 6
Post.
Ref. Debit Credit
May 20
21
25
27
28
30
31
31
31
31
2., 6., and 9.
Cash
11
Post.
Item Ref. Dr. Cr. Dr. Cr.
May 1 Balance √22,100
3
5
9
13
16
Balance
Description
Date
2016
Description
GENERAL LEDGER
JOURNAL
Date
2016
Cells with non-gray backgrounds are protected and cannot be edited.
Section:
0%
2
Comprehensive Problem 1
JOURNAL
Date
2016
Name: