978-0078025273 Chapter 4 Excel

subject Type Homework Help
subject Pages 9
subject Words 1243
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:
Post
Description Ref Debit Credit
Sept.
1 1,400
1,400 Correct!
5 2,500
2,500 Correct!
6 1,350
1,350 Correct!
10 600
600 Correct!
11 840
840 Correct!
12 3,200
3,200 Correct!
15 4,200
4,200 Correct!
18 2,000
2,000 Correct!
19 2,250
2,250 Correct!
20 2,760
2,760 Correct!
21 950
950 Correct!
21 450
450 Correct!
22 3,260
3,260 Correct!
23 4,850
4,850 Correct!
26 460
460 Correct!
28 2,250
2,250 Correct!
30 4,200
4,200 Correct!
Cash
Problem 04.01A
McGraw-Hill/Irwin
Instructor
Rental Expense
Paid September rent, Check 1169
Cash
GENERAL JOURNAL
Date
2013
Telephone Expense
Performed services on credit
Fees Income
Accounts Receivable
Performed services for cash.
Fees Income
Cash
Paid for repairs, Check 1171
Cash
Equipment Repair Expense
Paid monthly telephone bill, Check 1170
Cash
Supplies
Paid semimonthly salaries, Checks 1172-1177
Cash
Salaries Expense
Received cash on account.
Accounts Receivable
Shop, Invoice 3108, payable in 30 days.
Purchased tennis rackets from The Tennis Supply
Accounts Payable
Equipment
Paid for supplies, Check 1178
Cash
Received cash on account.
Accounts Receivable
Cash
Purchased nets, Check 1179
Cash
Equipment
Performed services for cash
Fees Income
Cash
Returned damaged net for cash refund.
Equipment
Cash
Fees Income
Accounts Receivable
Cash
Salaries Expense
Paid monthly electric bill, Check 1181
Cash
Utilities Expense
Paid for supplies, Check 1180
Cash
Supplies
Performed services on account
page-pf2
30 4,200
4,200 Correct!
Owner withdrew cash for personal use, Check 1188
Cash
Patrice Rebello, Drawing
Paid semimonthly salaries, Checks 1182-1187
page-pf3
Date
Sept.
11,400$
52,500
61,350
10 600
11 840
12 3,200
15 4,200
18 2,000
19
2,250
20 2,760
21 950
21 450
22 3,260
23 4,850
26 460
28 2,250
30 4,200
30 4,200
Returned a damaged net and received a cash refund.
Issued Check 1188 to Patrice Rebello for personal expenses.
Issued Checks 1182-1187 for salaries.
Paid the monthly electric bill with Check 1181.
Issued Check 1180 to purchase supplies.
Performed services on credit.
Performed services for cash.
Received cash on account from credit clients.
Issued Check 1179 to purchase new nets.
Supply Shop; received Invoice 3108 payable in 30 days.
Purchased new tennis rackets on credit from the Tennis
Transactions
LANCASTER SPORTS ARENA
Paid for monthly telephone bill, issued Check 1170.
Performed services on credit.
Performed services for cash.
Issued Check 1169 to pay September rent.
Issued Check 1178 to purchase supplies.
Issued Checks 1172-1177 for salaries.
Received cash on account from credit clients.
Paid for equipment repairs with Check 1171.
page-pf4
Student Name: Journal
Class: References
J1
J2
Page 1
Post
Description Ref Debit Credit
Oct. 1101 50,000
301 50,000 Correct!
2514 2,500
101 2,500 Correct!
5141 14,000
202 14,000 Correct!
6151 2,700
101 2,700 Correct!
7121 1,050
101 1,050 Correct!
10 511 500
101 500 Correct!
12 101 3,600
111 1,400
401 5,000 Correct!
15 101 300
121 300 Correct!
18 141 2,500 Correct!
101 1,500
202 1,000
20 202 7,000
101 7,000 Correct!
26 111 3,900
401 3,900 Correct!
27 520 275
101 275 Correct!
30 101 3,200
111 3,200 Correct!
30 523 350
101 350 Correct!
30 517 7,500
101 7,500 Correct!
McGraw-Hill/Irwin
Instructor
2013
Cash
Paid monthly telephone bill, Check 1007
Cash
Problem 04.02A
Cash
Rent Expense
Beginning investment of owner
Wilson Adams, Capital
Purchased equipment from Office Furniture Mart,
Accounts Payable
Office Equipment
Paid October rent, Check 1001
Cash
Supplies
Purchased art equipment, Check 1002
Cash
Art Equipment
Inc., Invoice 6704, payable in 60 days.
Accounts Receivable
Cash
Paid for office cleaning, Check 1004
Cash
Office Cleaning Expense
Purchased supplies, Check 1003
Performed services on credit.
Fees Income
Accounts Receivable
Invoice 67040, Check 1006
Office Equipment
Returned damaged supplies for cash refund.
Accounts Receivable
Cash
Telephone Expense
Date
Paid monthly salaries, Checks 1009-1011
Cash
Salaries Expense
Paid monthly utility bill, Check 1008
Cash
Utilities Expense
Received cash on account.
Purchased equipment from Office Furniture Mart,
Accounts Payable
Supplies
Cash
Performed services for cash and on credit.
Fees Income
Cash
Paid Office Furniture Mart, Inc. on account,
Cash
Accounts Payable
Inc., Invoice 7108, Check 1005; bal. due in 30 days.
GENERAL JOURNAL
page-pf5
ACCOUNT NO. 101
Post Balance
Description Ref Debit Credit Debit Credit
Oct. 1 J1 50,000 50,000
2 J1 2,500 47,500
6 J1 2,700 44,800
7 J1 1,050 43,750
10 J1 500 43,250
12 J1 3,600 46,850
15 J1 300 47,150
18 J1 1,500 45,650
20 J2 7,000 38,650
27 J2 275 38,375
30 J2 3,200 41,575
30 J2 350 41,225
30 J2 7,500 33,725
Correct!
ACCOUNT NO. 111
Post
Description Ref Debit Credit Debit Credit
Oct. 12 J1 1,400 1,400
26 J2 3,900 5,300
30 J2 3,200 2,100
Correct!
ACCOUNT NO. 121
Post
Description Ref Debit Credit Debit Credit
Oct. 7 J1 1,050 1,050
15 J1 300 750
Correct!
ACCOUNT NO. 141
Post
Description Ref Debit Credit Debit Credit
Oct. 5 J1 14,000 14,000
18 J1 2,500 16,500
Correct!
ACCOUNT NO. 151
Post
Description Ref Debit Credit Debit Credit
Oct. 6 J1 2,700 2,700
Correct!
ACCOUNT NO. 202
Post
Description Ref Debit Credit Debit Credit
Oct. 5 J1 14,000 14,000
18 J1 1,000 8,000
20 J2 7,000 8,000
Correct!
ACCOUNT NO. 301
Post
Description Ref Debit Credit Debit Credit
Oct. 1 J1 50,000 50,000
Correct!
2013
2013
ACCOUNT
Date
2013
2013
Date
ACCOUNT
GENERAL LEDGER
ACCOUNT
Date
ACCOUNT
Balance
2013
Office Equipment
Balance
Date
ACCOUNT
Balance
Supplies
Balance
Date
ACCOUNT
Balance
Date
ACCOUNT
Balance
Date
2013
2013
Accounts Receivable
Cash
Wilson Adams, Capital
Accounts Payable
Art Equipment
page-pf6
ACCOUNT NO. 302
Post
Description Ref Debit Credit Debit Credit
Oct.
ACCOUNT NO. 401
Post
Description Ref Debit Credit Debit Credit
Oct. 12 J1 5,000 5,000
26 J2 3,900 8,900
Correct!
ACCOUNT NO. 511
Post
Description Ref Debit Credit Debit Credit
Oct. 10 J1 500 500
Correct!
ACCOUNT NO. 514
Post
Description Ref Debit Credit Debit Credit
Oct. 2 J1 2,500 2,500
Correct!
ACCOUNT NO. 517
Post
Description Ref Debit Credit Debit Credit
Oct. 30 J2 7,500 7,500
Correct!
ACCOUNT NO. 520
Post
Description Ref Debit Credit Debit Credit
Oct. 27 J2 275 275
Correct!
ACCOUNT NO. 523
Post
Description Ref Debit Credit Debit Credit
Oct. 30 J2 350 350
Correct!
2013
2013
2013
2013
2013
ACCOUNT
ACCOUNT
2013
ACCOUNT
Balance
Date
ACCOUNT
Office Cleaning Expense
Balance
Date
ACCOUNT
Balance
Fees Income
Date
ACCOUNT
Balance
Date
Balance
Date
Date
Balance
ACCOUNT
Utilities Expense
Telephone Expense
Salaries Expense
Rent Expense
Balance
Date
2013
Wilson Adams, Drawing
page-pf7
Assets
101
111
121
141
151
Liabilities
202
Owner's Equity
301
302
Revenue
401
Expenses
511
514
517
523
22,500
5
14,000
62,700
71,050
10 500
12 3,600
1,400
15 300
Chart of Accounts
WILSON ADAMS
Utilities Expense
Salaries Expense
Rent Expense
Office Cleaning Expense
Supplies
Accounts Receivable
Cash
Wilson Adams, Drawing
Wilson Adams, Capital
Accounts Payable
Art Equipment
Office Equipment
Fees Income
Returned damaged supplies for a cash refund.
Performed services on credit.
Furniture Mart.; received Invoice 6704 payable in 60 days.
Purchased desks and other office furniture from Office
Paid October office rent; issued Check 1001.
Performed services for cash
Issued Check 1004 for office cleaning service.
Purchased supplies with Check 1003.
Issued Check 1002 to purchase art equipment.
page-pf8
Student Name: Post
Class: Ref
J1
Page 1
Post
Description Ref Debit Credit
Nov.
1101 45,000
131 1,000
301 46,000 Correct!
2151 1,950
121 450
101 600
202 1,800 Correct!
10 101 500
111 1,400
401 1,900 Correct!
20 141 3,000 Correct!
101 1,000
202 2,000
ACCOUNT NO. 101
Post
Description Ref Debit Credit Debit Credit
Nov.
1 J1 45,000 45,000
2 J1 600 44,400
10 J1 500 44,900
20 J1 1,000 43,900
Correct!
ACCOUNT NO. 111
Post
Description Ref Debit Credit Debit Credit
Nov.
10 J1 1,400 1,400
Correct!
ACCOUNT NO. 121
Post
Description Ref Debit Credit Debit Credit
Nov.
2 J1 450 450
Correct!
ACCOUNT NO. 131
Post
Description Ref Debit Credit Debit Credit
Nov.
1 J1 1,000 1,000
Correct!
ACCOUNT NO. 141
Post
Description Ref Debit Credit Debit Credit
Nov.
20 J1 3,000 3,000
Correct!
ACCOUNT NO. 151
Post
Description Ref Debit Credit Debit Credit
Nov.
2 J1 1,950 1,950
Correct!
ACCOUNT NO. 202
Post
Description Ref Debit Credit Debit Credit
Nov.
2 J1 1,800 1,800
20 J1 2,000 3,800
Correct!
ACCOUNT NO. 301
Post
Description Ref Debit Credit Debit Credit
Nov.
1 J1 46,000 46,000
Correct!
ACCOUNT NO. 401
Post
Description Ref Debit Credit Debit Credit
Nov.
10 J1 1,900 1,900
Correct!
Cash
Accounts Receivable
Cash
payment, balance payable in 30 days.
Depot, Invoice 501; issued Check 100 for a down
2013
Balance due in 30 days.
Invoice 709; issued Check 101 for a down payment,
Purchased machinery from Cottle Machinery, Inc.
Accounts Payable
Cash
Machinery
Services for cash and credit.
Erwin Tobias, Capital
Tools
Problem 04.04A
McGraw-Hill/Irwin
Instructor
2013
2013
2013
2013
2013
2013
2013
GENERAL JOURNAL
Date
Purchased equipment and office supplies from Office
Accounts Payable
Cash
Office Supplies
Equipment
Beginning Investment of owner.
GENERAL LEDGER
ACCOUNT
Balance
Fees Income
Cash
Office Supplies
Date
ACCOUNT
Balance
Date
Accounts Receivable
2013
2013
Balance
Date
ACCOUNT
Balance
Machinery
ACCOUNT
Balance
Date
ACCOUNT
Tools
Date
ACCOUNT
Balance
Date
ACCOUNT
Balance
Date
Accounts Payable
Equipment
Date
ACCOUNT
Balance
ACCOUNT
Balance
Date
Fees Income
Erwin Tobias, Capital
page-pf9
101
111
121
131
141
151
202
301
401
Date
Nov.
1
45,000$
1,000
2
1,950
450
600
10
500
1,400
20
1,000
2,000
Balance due in 30 days
Tools at fair market value
Cash
Erwin Tabias invested to start the business:
Issued Check 100 as a down payment
Purchased supplies
Purchased equipment
Purchased from Office Depot , Invoice 501:
Transactions
Office Supplies
Accounts Receivable
Cash
Balance due in 30 days
Issued Check 101 as a down payment
Purchased machinery from Cottle Machinery, Inc., Invoice 709
Balance due in 30 days
Cash received from James Wilson
Performed services:
Given Data P04.04A:
FARM SUPPLY AND REPAIR
Chart of Accounts
FARM SUPPLY AND REPAIR
Fees Income
Erwin Tobias, Capital
Accounts Payable
Equipment
Machinery
Tools

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.