978-1337398169 Chapter 2 Excel Part 2

subject Type Homework Help
subject Pages 12
subject Words 1551
subject Authors Carl Warren, Jeff Jones

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Cash 11
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Accounts Receivable 12
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Supplies 13
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Prepaid Insurance 14
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Equipment 16
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Truck 18
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Balance
Balance
Balance
Balance
Balance
Balance
Notes Payable 21
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Accounts Payable 22
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Common Stock 31
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Dividends 33
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Fees Earned 41
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Balance
Balance
Balance
Balance
Balance
page-pf3
Wages Expense 51
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Rent Expense 53
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Utilities Expense 54
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Truck Expense 55
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
Miscellaneous Expense 59
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y9
Nov.
3.
Acct.
No.
Debit
Balances
Credit
Balances
Cash 11
Accounts Receivable 12
Supplies 13
Prepaid Insurance 14
Equipment 16
Truck 18
Notes Payable 21
Accounts Payable 22
Common Stock 31
Dividends
33
Fees Earned 41
Wages Expense 51
Rent Expense 53
Utilities Expense 54
Truck Expense 55
Miscellaneous Expense 59
4.
Balance
Balance
Balance
Balance
Balance
Heritage Designs
Unadjusted Trial Balance
November 30, 20Y9
5.
page-pf5
Enter the appropria team ounts/formu las in the answ er cells or select from the d rop-down list
In journal entrie s dates will not be grad ed Inthe ge neral ledger accoun ts onlythe final b alance of the account
will be grad ed An as terisk (*) will appea r tothe rig hto finco rrecte ntries in outline d answer cells
Essa y answ ers will not be graded
In the trial balance enter a zero where you would o therwise leave an am ount cell blank.
1.
Page 1
Post
Date Ref. Debit Credit
20Y9
Nov
111 50,000
31 50,000
153 4,000
11 4,000
616 15,000
22 15,000
818 38,500
21 33,500
11 5,000
#13 1,750
11 1,750
#11 11,500
41 11,500
#14 2,400
11 2,400
#12 22,300
41 22,300
#55 1,250
22 1,250
Page 2
Post
Date Ref. Debit Credit
20Y9
Nov
#54 4,500
11 4,500
#59 1,000
11 1,000
#11 9,000
12 9,000
#51 6,800
11 6,800
#22 3,000
11 3,000
#33 2,500
11 2,500
ON
Problem 2-3A
Solution
Accounts Payable
Instructions
Answers are entered in the cells with gra y backgro unds.
Cells with non-gray backgrounds are protected and cannot be edited.
JOURNAL
Description
Cash
Comm on Stock
Rent Expense
Cash
Equipm ent
Truck Expense
Truck
Notes Payable
Cash
Supplies
Cash
Cash
Fees Earned
Prepaid Ins urance
Cash
Accounts Receivable
Fees Earned
Accounts Payable
Accounts Payable
JOURNAL
Description
Utilities Expens e
Cash
Miscellane ous Expense
Cash
Cash
Accounts Receivable
Wages Expens e
Cash
Cash
Dividends
Cash
GENERAL LEDGER
page-pf6
2. Cash 11
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
1 1 50,000 50,000
1 1 4,000 46,000
8 1 5,000 41,000
# 1 1,750 39,250
# 1 11,500 50,750
# 1 2,400 48,350
# 2 4,500 43,850
# 2 1,000 42,850
# 2 9,000 51,850
# 2 6,800 45,050
# 2 3,000 42,050
# 2 2,500 39,550
Accounts Receivable 12
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 1 22,300 22,300
# 2 9,000 13,300
Supplies 13
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 1 1,750 1,750
Prepaid Insurance 14
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 1 2,400 2,400
Equipment 16
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
6 1 15,000 15,000
Truck 18
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
8 1 38,500 38,500
Balance
Balance
Balance
Balance
Balance
Balance
page-pf7
Notes Payable 21
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
8 1 33,500 33,500
Accounts Payable 22
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
6 1 15,000 15,000
# 1 1,250 16,250
# 2 3,000 13,250
Common Stock 31
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
1 1 50,000 50,000
Dividends 33
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 2 2,500 2,500
Fees Earned 41
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 1 11,500 11,500
# 1 22,300 33,800
Balance
Balance
Balance
Balance
Balance
page-pf8
Wages Expense 51
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 2 6,800 6,800
Rent Expense 53
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
1 1 4,000 4,000
Utilities Expense 54
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 2 4,500 4,500
Truck Expense 55
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 1 1,250 1,250
Miscellaneous Expense 59
Post
Date Item Ref. Dr Cr Dr Cr
20Y9
Nov
# 2 1,000 1,000
3.
Acct
No
Debit
Balances
Credit
Balances
Cash 11 39 ,550 -
Accounts Receivable 12 13,300 -
Supplies 13 1,750 -
Prepaid Ins urance 14 2,400 -
Equipm ent 16 15,000 -
Truck 18 38,500 -
Notes Payable 21 - 3 3,500
Accounts Payable 22 - 13,25 0
Comm on Stock 31 - 5 0,000
Dividends 33 2,500 -
Fees Earned 41 - 33,800
Wages Expens e 51 6,800 -
Rent Expense 53 4,000 -
Utilities Expens e 54 4,500 -
Truck Expense 55 1,250 -
Miscellane ous Expense 59 1,000 -
##### #####
4.
$16 250
5.
Some s upplies m ay have been used during Novem ber, but no supplie s expense has
been recorde d.
As will be dis cussed in Chapter 3, adjustm ents are necess ary at the en d of the
accounting pe riod to bring the accounts up to date. For exampl e, adjustments for
suppl ies used , insurance expired, and depre ciation would prob ably be required by
Heritage Des igns.
Balance
Balance
Balance
Balance
Balance
Heritage Designs
Unadjusted Trial Balance
November 30, 20Y9
Score:
Key Code:
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list.
In journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account
will be graded. An asterisk (*) will appear to the right of incorrect entries in outlined answer cells.
Essay answers will not be graded.
In the trial balance, enter a zero where you would otherwise leave an amount cell blank.
1.
Page 1
Post
Date Ref. Debit Credit
20Y4
Oct.
Page 2
Post
Date Ref. Debit Credit
20Y4
Oct.
0%
Problem 2-3B
Name:
Section:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
JOURNAL
Description
JOURNAL
Description
2.
GENERAL LEDGER
Cash 11
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Accounts Receivable 12
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Supplies 13
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Prepaid Insurance 14
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Equipment 16
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Truck 18
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Balance
Balance
Balance
Balance
Balance
Balance
Notes Payable 21
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Accounts Payable 22
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Common Stock 31
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Dividends 33
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Fees Earned 41
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Balance
Balance
Balance
Balance
Balance
Wages Expense 51
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Rent Expense 53
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Utilities Expense 54
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Truck Expense 55
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
Miscellaneous Expense 59
Post
Date Item Ref. Dr. Cr. Dr. Cr.
20Y4
Oct.
3.
Acct.
No.
Debit
Balances
Credit
Balance
Cash 11
Accounts Receivable 12
Supplies 13
Prepaid Insurance 14
Equipment 16
Truck 18
Notes Payable 21
Accounts Payable 22
Common Stock 31
Dividends 33
Fees Earned 41
Wages Expense 51
Rent Expense 53
Utilities Expense 54
Truck Expense 55
Miscellaneous Expense 59
Balance
Balance
Balance
Balance
Balance
Pioneer Designs
Unadjusted Trial Balance
October 31, 20Y4
4.
5.
(Key essay answer here)
page-pff
Enter the appropria team ounts/formu las in the answ er cells or select from the d rop-down list
In journal entrie s dates wil l not be graded In the general ledg er accounts only the final balance of the accoun t
will be grad ed An asteri sk (*) will appear to the righ tof incorre cten tries in outlined an swer cells
Essa y answ ers will not be graded
In the trial balance enter a zero where you would o therwise leave an am ount cell blank.
1.
Page 1
Post
Date Ref. Debit Credit
20Y4
Oct. 1 11 18,000
31 18,000
453 3,000
11 3,000
#18 23,750
21 20,000
11 3,750
#16 10,500
22 10,500
#13 2,100
11 2,100
#14 3,600
11 3,600
#11 8,950
41 8,950
Page 2
Post
Date Ref. Debit Credit
20Y4
Oct. # 22 2,000
11 2,000
# 12 14,150
41 14,150
#55 700
22 700
#54 2,240
11 2,240
#59 1,100
11 1,100
#11 7,600
12 7,600
#51 4,800
11 4,800
#33 3,500
11 3,500
ON
Problem 2-3B
Solution
Notes Payable
Instructions
Answers are entered in the cells with gra y backgro unds.
Cells with non-gray backgrounds are protected and cannot be edited.
JOURNAL
Description
Cash
Comm on Stock
Rent Expense
Cash
Truck
Accounts Payable
Cash
Equipm ent
Accounts Payable
Supplies
Cash
Prepaid Ins urance
Cash
Cash
Fees Earned
JOURNAL
Description
Wages Expens e
Cash
Accounts Receivable
Fees Earned
Truck Expense
Accounts Payable
Utilities Expens e
Cash
Miscellane ous Expense
Cash
Cash
Accounts Receivable
Cash
Dividends
Cash
GENERAL LEDGER
page-pf10
2. Cash 11
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. 1 1 18,000 18,000
4 1 3,000 15,000
# 1 3,750 11,250
# 1 2,100 9,150
# 1 3,600 5,550
# 1 8,950 14,500
# 2 2,000 12,500
# 2 2,240 10,260
# 2 1,100 9,160
# 2 7,600 16,760
# 2 4,800 11,960
# 2 3,500 8,460
Accounts Receivable 12
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 2 14,150 14,150
# 2 7,600 6,550
Supplies 13
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 2 ,100 2,100
Prepaid Insurance 14
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 3 ,600 3,600
Equipment 16
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 10,500 10,500
Truck 18
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 23,750 23,750
Balance
Balance
Balance
Balance
Balance
Balance
page-pf11
Notes Payable 21
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 20,000 20,000
Accounts Payable 22
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 10,500 10,500
# 2 2,000 8,500
# 2 700 9,200
Common Stock 31
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. 1 1 18,000 18,000
Dividends 33
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 2 3 ,500 3,500
Fees Earned 41
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 1 8,950 8,950
# 2 14,150 23,100
Balance
Balance
Balance
Balance
Balance
page-pf12
Wages Expense 51
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 2 4 ,800 4,800
Rent Expense 53
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. 4 1 3,000 3,000
Utilities Expense 54
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 2 2 ,240 2,240
Truck Expense 55
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct. # 2 700 700
Miscellaneous Expense 59
Post
Date Item Ref. Dr Cr Dr Cr
20Y4
Oct # 2 11 00 1 1 00
3.
Acct
.
No
Debit
Balances
Credit
Balance
Cash 11 8,460 -
Accounts Receivable 12 6,550 -
Supplies 13 2,100 -
Prepaid Ins urance 14 3,600 -
Equipm ent 16 10,500 -
Truck 18 23,750 -
Notes Payable 21 - 2 0,000
Accounts Payable 22 - 9,200
Comm on Stock 31 - 1 8,000
Dividends 33 3,500 -
Fees Earned 41 - 23,10 0
Wages Expens e 51 4,800 -
Rent Expense 53 3,000 -
Utilities Expens e 54 2,240 -
Truck Expense 55 700 -
Miscellane ous Expense 59 1,100 -
70,300 70 ,300
4.
$11,260
5.
Some s upplies m ay have been used during October, but no s upplies expens e has
been recorde d.
As will be dis cussed in Chapter 3, adjustm ents are necess ary at the en d of the
accounting pe riod to bring the accounts up to date. For exampl e, adjustments for
suppl ies used , insurance expired, and depre ciation would prob ably be required by
Pioneer Des igns.
Balance
Balance
Balance
Balance
Balance
Pioneer Designs
Unadjusted Trial Balance
October 31, 20Y4

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.