978-0078025273 Chapter 6 Excel

subject Type Homework Help
subject Pages 9
subject Words 1253
subject Authors John Price, M. David Haddock, Michael Farina

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
Page 3
Post
Date Ref Debit Credit
Adjusting Entries
###
Dec. 31 517 2,400
121 2,400 Correct!
31 526 3,000
131 3,000 Correct!
31 523 2,400
142 2,400 Correct!
Page 4
Post
Date Ref Debit Credit
Closing Entries
###
Dec. 31 401 75,000
399 75,000 Correct!
31 399 24,000 Correct!
517 2,400
526 3,000
523 2,400
511 14,400
514 1,800
31 309 51,000
301 51,000 Correct!
31 301 8,400
302 8,400 Correct!
ACCOUNT
ACCOUNT NO. 121
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 6,000
31 J3 2,400 3,600
Correct!
ACCOUNT
ACCOUNT NO. 131
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 24,000
31 J3 3,000 21,000
Correct!
ACCOUNT
ACCOUNT NO. 142
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 J3 2,400 2,400
Correct!
Accumulated Depr. - Equip.
Description
Adjusting
Description
Balance
Adjusting
Balance
Adjusting
Prepaid Advertising
Problem 06.02A
McGraw-Hill/Irwin
Instructor
Accumulated Depreciation - Equipment
Depreciation Expense - Equipment
Prepaid Advertising
Advertising Expense
Supplies
Supplies Expense
Income Summary
Income Summary
Fees Income
Utilities Expense
Salaries Expense
Depreciation Expense - Equipment
Advertising Expense
Supplies Expense
Gayle Warrior, Drawing
Gayle Warrior, Capital
Gayle Warrior, Capital
Income Summary
GENERAL LEDGER
Supplies
Description
GENERAL JOURNAL
Description
GENERAL JOURNAL
Description
page-pf2
ACCOUNT
ACCOUNT NO. 301
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 132,000
31 J4 51,000 183,000
31 J4 8,400 174,600
Correct!
ACCOUNT
ACCOUNT NO. 302
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 8,400
31 J4 8,400 -
Correct!
ACCOUNT
ACCOUNT NO. 399
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 J4 75,000 75,000
31 J4 24,000 51,000
31 J4 51,000 -
Correct!
ACCOUNT
ACCOUNT NO. 401
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 75,000
31 J4 75,000 -
Correct!
ACCOUNT
ACCOUNT NO. 511
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 14,400
31 J4 14,400 -
Correct!
ACCOUNT
ACCOUNT NO. 514
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 1,800
31 J4 1,800 -
Correct!
ACCOUNT
ACCOUNT NO. 517
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 J3 1,200 2,400
31 J4 2,400 -
Closing
Supplies Expense
Description
Adjusting
Utilities Expense
Description
Balance
Closing
Balance
Closing
Balance
Description
Closing
Salaries Expense
Fees Income
Description
Income Summary
Description
Closing
Closing
Closing
Balance
Closing
Description
Balance
Gayle Warrior, Drawing
Description
Closing
Closing
Gayle Warrior, Capital
page-pf3
Correct!
page-pf4
ACCOUNT
ACCOUNT NO. 523
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 J3 2,400 2,400
31 J4 2,400 -
Correct!
ACCOUNT
ACCOUNT NO. 526
Post Balance
Date Ref Debit Credit Debit Credit
###
Dec. 31 J3 3,000 3,000
31 J4 3,000 -
Correct!
Debit Credit
92,400
12,000
3,600
21,000
60,000
2,400
Accounts Payable
12,000
174,600
$189,000 $189,000
Correct! Correct!
Advertising Expense
Description
Adjusting
Closing
Description
Adjusting
Closing
Depreciation Exp. - Equip.
Supplies
Totals
Gayle Warrior, Capital
Accumulated Dep. - Equipment
Equipment
Prepaid Advertising
Accounts Receivable
Cash
Account Name
page-pf5
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
92,400 92,400 92,400
12,000 12,000 12,000
6,000 a 2,400 3,600 3,600
24,000 b 3,000 21,000 21,000
60,000 60,000 60,000
c2,400 2,400 2,400
12,000 12,000 12,000
132,000 132,000 132,000
8,400 8,400 8,400
75,000 75,000 75,000
a2,400 2,400 2,400
b3,000 3,000 3,000
c2,400 2,400 2,400
14,400 14,400 14,400
1,800 1,800 1,800
219,000 219,000 7,800 7,800 221,400 221,400 24,000 75,000 197,400 146,400
51,000 51,000
75,000 75,000 197,400 197,400
Trial Balance
Statement
Net Income
Totals
Utilities Expense
Salaries Expense
Balance Sheet
Adjusted
Income
The Warrior Group
Given Data P06.02A:
Gayle Warrior, Drawing
Gayle Warrior, Capital
Accounts Payable
Accumulated Dep. - Equip.
Depreciation Expense - Equip.
Advertising Expense
Supplies Expense
Fees Income
Cash
Account Name
Month Ended December 31, 2013
Worksheet
Equipment
Prepaid Advertising
Supplies
Accounts Receivable
Trial Balance
Adjustments
page-pf6
Student Name:
Class:
Page 4
Post
Date Ref Debit Credit
###
Dec. 31 401 138,000
399 138,000 Correct!
31 399 44,820 Correct!
511 4,800
514 900
517 3,600
519 28,800
523 6,720
31 399 93,180
301 93,180 Correct!
31 301 7,200
302 7,200 Correct!
ACCOUNT
ACCOUNT NO. 301
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 55,620
31 J4 93,180 148,800
31 J4 7,200 141,600
Correct!
ACCOUNT
ACCOUNT NO. 302
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 7,200
31 J4 7,200 -
Correct!
ACCOUNT
ACCOUNT NO. 399
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 J4 138,000 138,000
31 J4 44,820 93,180
31 J4 93,180 -
Correct!
ACCOUNT
ACCOUNT NO. 401
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 138,000
31 J4 138,000 -
Correct!
Balance
Closing
Fees Income
Balance
Description
Description
Closing
Closing
Closing
Income Summary
Balance
Balance
Description
Balance
Closing
Balance
Closing
Closing
Connie Youngblood, Drawing
Monica Cavazos, Drawing
GENERAL LEDGER
Monica Cavazos, Capital
Balance
Description
Rent Expense
Salaries Expense
Utilities Expense
Income Summary
Monica Cavazos, Capital
Monica Cavazos, Capital
Fees Income
Income Summary
Income Summary
Advertising Expense
Depreciation Expense - Equipment
Problem 06.03A
McGraw-Hill/Irwin
Instructor
Closing Entries
GENERAL JOURNAL
Description
CAVAZOS COMPANY
page-pf7
ACCOUNT
ACCOUNT NO. 511
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 4,800
31 J4 4,800 -
Correct!
ACCOUNT
ACCOUNT NO. 514
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 900
31 J4 900 -
Correct!
ACCOUNT
ACCOUNT NO. 517
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 3,600
31 J4 3,600 -
Correct!
ACCOUNT
ACCOUNT NO. 519
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 28,800
31 J4 28,800 -
Correct!
ACCOUNT
ACCOUNT NO. 523
Post
Date Ref Debit Credit Debit Credit
###
Dec. 31 6,720
31 J4 6,720 -
Correct!
Balance
Closing
Balance
Description
Utilities Expense
Balance
Closing
Salaries Expense
Balance
Description
Description
Balance
Closing
Rent Expense
Balance
Balance
Description
Balance
Closing
Balance
Closing
Depreciation Exp. - Equip.
Advertising Expense
Balance
Description
page-pf8
101 37,200$ Dr.
111 16,800 Dr.
121 3,000 Dr.
131 39,600 Dr.
141 54,000 Dr.
142 1,500$ Cr.
202 7,500 Cr.
301 55,620 Cr.
302 7,200 Dr.
401 138,000 Cr.
511 4,800 Dr.
514 900 Dr.
517 3,600 Dr.
519 28,800 Dr.
523 6,720 Dr.
405,240$
December 31, 2013
Ledger Account Balances
CAVAZOS COMPANY
Given Data P06.03A:
Depreciation Expense - Equipment
Advertising Expense
Fees Income
Monica Cavazos, Drawing
Totals
Utilities Expense
Salaries Expense
Rent Expense
Prepaid Rent
Supplies
Accounts Receivable
Cash
Monica Cavazos, Capital
Accounts Payable
Accumulated Dep. - Equipment
Equipment
page-pf9
Student Name:
Class:
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
31,050 31,050 31,050
4,950 4,950 4,950
4,000 a 1,600 2,400 2,400
3,000 b 1,400 1,600 1,600
20,000 20,000 20,000
c480 480 480
5,000 5,000 5,000
35,500 35,500 35,500
2,000 2,000 2,000
30,000 30,000 30,000
a1,600 1,600 1,600
b1,400 1,400 1,400
c480 480 480
4,800 4,800 4,800
700 700 700
70,500 70,500 3,480 3,480 70,980 70,980 8,980 30,000 62,000 40,980
Correct! Correct!
21,020 21,020
30,000 30,000 62,000 62,000
Correct! Correct! Correct! Correct!
Page 3
Post
Date Ref Debit Credit
Adjusting Entries
2013 a
Dec. ### 1,600
## 1,600 Correct!
b
### 1,400
## 1,400 Correct!
c
### 480
## 480 Correct!
Page 4
Post
NATIONWIDE AUTO DETAILING SERVICE
GENERAL JOURNAL
Description
Supplies Expense
Supplies
Advertising Expense
Prepaid Advertising
Depreciation Expense - Equipment
Accumulated Depreciation - Equipment
GENERAL JOURNAL
Statement
Trial Balance
Instructor
NATIONWIDE AUTO DETAILING SERVICE
Month Ended December 31, 2013
Worksheet
Balance Sheet
Adjusted
Income
Trial Balance
Problem 06.04A
McGraw-Hill/Irwin
Adjustments
Account Name
Net Income
Totals
Utilities Expense
Salaries Expense
Depreciation Expense - Equip.
Advertising Expense
Supplies Expense
Fees Income
Equipment
Prepaid Advertising
Supplies
Accounts Receivable
Richard Harris, Drawing
Richard Harris, Capital
Accounts Payable
Accumulated Dep. - Equip.
Cash
page-pfa
Date Ref Debit Credit
Closing Entries
2013
Dec. ### 30,000
## 30,000 Correct!
### 8,980 Correct!
## 4,800
## 700
## 1,600
## 480
## 1,400
### 21,020
## 21,020 Correct!
### 2,000
## 2,000 Correct!
Income Summary
Income Summary
Salaries Expense
Utilities Expense
Description
Fees Income
Richard Harris, Capital
Richard Harris, Capital
Richard Harris, Drawing
Supplies Expense
Depreciation Expense - Equipment
Advertising Expense
Income Summary
page-pfb
ACCOUNT ACCOUNT NO. 121
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #4,000
#J3 1,600 2,400
Correct!
ACCOUNT ACCOUNT NO. 131
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #3,000
#J3 1,400 1,600
Correct!
ACCOUNT ACCOUNT NO. 142
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #J3 480 480
Correct!
ACCOUNT ACCOUNT NO. 301
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #35,500
#J4 21,020 56,520
#J4 2,000 54,520
Correct!
ACCOUNT ACCOUNT NO. 302
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #2,000
#J4 2,000 -
Correct!
ACCOUNT ACCOUNT NO. 399
Closing
Income Summary
Richard Harris, Drawing
Balance
Description
Balance
GENERAL LEDGER
Balance
Description
Balance
Balance
Balance
Adjusting
Balance
Description
Balance
Richard Harris, Capital
Balance
Description
Closing
Description
Adjusting
Closing
Accumulated Depr. - Equip.
Prepaid Advertising
Adjusting
Supplies
page-pfc
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #J4 30,000 30,000
#J4 8,980 21,020
#J4 21,020 -
Correct!
ACCOUNT ACCOUNT NO. 401
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #30,000
#J4 30,000 -
Correct!
Balance
Closing
Fees Income
Balance
Description
Description
Closing
Closing
Closing
Balance
page-pfd
ACCOUNT ACCOUNT NO. 511
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #4,800
#J4 4,800 -
Correct!
ACCOUNT ACCOUNT NO. 514
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #700
#J4 700 -
Correct!
ACCOUNT ACCOUNT NO. 517
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #J3 1,600 1,600
#J4 1,600 -
Correct!
ACCOUNT ACCOUNT NO. 523
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #J3 480 480
#J4 480 -
Correct!
ACCOUNT ACCOUNT NO. 526
Post
Date
Ref
Debit Credit Debit Credit
2013
Dec. #J3 1,400 1,400
#J4 1,400 -
Correct!
Adjusting
Advertising Expense
Balance
NATIONWIDE AUTO DETAILING SERVICE
Closing
Description
Adjusting
Closing
Depreciation Exp. - Equip.
Balance
Description
Adjusting
Closing
Supplies Expense
Balance
Description
Balance
Description
Balance
Closing
Balance
Closing
Utilities Expense
Salaries Expense
Balance
Description
Post-closing Trial Balance
page-pfe
Debit Credit
31,050
4,950
2,400
1,600
20,000
480$
5,000
54,520
60,000 60,000
Correct! Correct!
Accounts Receivable
December 31, 2013
Cash
Account Name
Totals
Richard Harris, Capital
Accounts Payable
Accumulated Dep. - Equip.
Equipment
Prepaid Advertising
Supplies
page-pff
Debit Credit Debit Credit
31,050$
4,950
4,000 a 1,600
3,000 b 1,400
20,000
c480
5,000$
35,500
2,000
30,000
4,800
700
a1,600
b1,400
c480
70,500$ 70,500$ 3,480$ 3,480$
NATIONWIDE AUTO DETAILING SERVICE
Trial Balance
Adjustments
Month Ended December 31, 2013
Partial Worksheet
Given Data P06.04A:
Utilities Expense
Salaries Expense
Fees Income
Richard Harris, Drawing
Totals
Depreciation Expense - Equip.
Advertising Expense
Supplies Expense
Account Name
Prepaid Advertising
Supplies
Accounts Receivable
Cash
Richard Harris, Capital
Accounts Payable
Accumulated Dep. - Equip.
Equipment

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.