978-0078025587 Chapter 2 Excel

subject Type Homework Help
subject Pages 6
subject Words 582
subject Authors Barbara Chiappetta, John Wild, Ken Shaw

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
Date Explanation Debit Credit
Mar 1 150,000
22,000
172,000 «- Correct!
6,000 «- Correct!
1,200
4,200 «- Correct!
4,000 «- Correct!
7,500 «- Correct!
4,200 «- Correct!
5,000 «- Correct!
3,500 «- Correct!
3,820 «- Correct!
5,100 «- Correct!
600 «- Correct!
500 «- Correct!
Accounts Receivable
Services Revenue
Cash
Cash
Office Supplies
Accounts Payable
Collected part of amount owed by client.
Prepaid six months' rent.
Purchased equipment and supplies on credit.
Received cash for services.
Billed client for completed work.
Paid balance due on account.
Paid premium for insurance.
Services Revenue
Services Revenue
Cash
Cash
Problem 02-02A
McGraw-Hill/Irwin
Instructor
Owner invested cash and equipment.
General Journal
VENTURE CONSULTANTS
Cash
Office Equipment
D. Brooks, Capital
Billed client for completed work.
Owner withdrew cash for personal use.
Purchased supplies on account.
Paid monthly utility bill.
Accounts Payable
Cash
page-pf2
Student Name:
Class:
Problem 02-02A
McGraw-Hill/Irwin
Instructor
Account No. 101
Date Explanation Debit Credit Balance
Mar 1 150,000 150,000
26,000 144,000
64,000 148,000
12 4,200 143,800
19 5,000 138,800
22 3,500 142,300
29 5,100 137,200
31 500 136,700
Correct!
Account No. 106
22 3,500 4,000
25 3,820 7,820
Correct!
Account No. 124
Mar 3 1,200 1,200
30 600 1,800
Correct!
Account No. 128
Date Explanation Debit Credit Balance
Account No. 131
Date Explanation Debit Credit Balance
Account No. 163
Date Explanation Debit Credit Balance
Correct!
Account No. 201
Date Explanation Debit Credit Balance
30 600 600
Correct!
Accounts Receivable
Cash
Accounts Payable
Office Equipment
Prepaid Rent
Prepaid Insurance
Office Supplies
General Ledger
VENTURE CONSULTANTS
page-pf3
Student Name:
Class:
Problem 02-02A
McGraw-Hill/Irwin
Instructor
Account No. 301
Date Explanation Debit Credit Balance
Mar 1 172,000 172,000
Correct!
Account No. 302
Date Explanation Debit Credit Balance
Mar 29 5,100 5,100
Correct!
Account No. 403
Date Explanation Debit Credit Balance
Mar 6 4,000 4,000
97,500 11,500
25 3,820 15,320
Correct!
Account No. 690
Date Explanation Debit Credit Balance
Mar 31 500 500
Correct!
Account Title Debits Credits
136,700$
7,820
25,000
600$
172,000
500
187,920$ 187,920$
Correct! Correct!
D. Brooks, Capital
Total
Cash
Accounts receivable
Office equipment
Accounts payable
D. Brooks, Capital
Utilities expense
VENTURE CONSULTANTS
Utilities Expense
Services Revenue
D. Brooks, Withdrawals
page-pf4
Mar 1 150,000$
22,000
26,000
33,000
1,200
64,000
97,500
12 4,200
19 5,000
22 3,500
25 3,820
29 5,100
30 600
31 500
Check figures:
(2) Ending balances
136,700$
7,820$
600$
(3) 187,920$
VENTURE CONSULTANTS
Given Data P02-02A:
page-pf5
Student Name:
Class:
64,300$ 3,500$
26,240
3,160
148,000
44,000 282,200
285,700$ Total liabilities and equity 285,700$
Correct! Correct!
1,960 73,500$
157,000
44,000
80,000
60,000 304,490
377,990$ 377,990$
Correct! Correct!
35,000
23,290
(36,000)
22,290$
19.4%
Net income earned in 2011
Debt Ratio
Debt Ratio Calculation
«- Correct!
Problem 02-04A
McGraw-Hill/Irwin
Instructor
Computation of 2013 Net Income
NETTLE DISTRIBUTION
Assets
Office equipment
Total assets
Office supplies
Trucks
Office equipment
Building
Land
Total Assets
Cash
Accounts receivable
Office supplies
Trucks
Owner investment
Add net income
Add withdrawals
Balance Sheet
NETTLE DISTRIBUTION
NETTLE DISTRIBUTION
Balance Sheet
December 31, 2013
Liabilities
Equity
December 31, 2012
Owner's Equity
page-pf6
2012 2013
64,300$ 15,640$
26,240 19,390
3,160 1,960
44,000 44,000
148,000 157,000
- 80,000
- 60,000
3,500 33,500
- 40,000
140,000$
100,000
40,000
35,000
3,000
Check figures:
(2) Net income 23,290$
(3) Debt ratio 19.40%
Land
NETTLE DISTRIBUTION
December 31
Given Data P02-04A:
December 31
Cash
Accounts receivable
Office supplies
Office equipment
Trucks
Building
Cash Nettle invested in business
Nettle's draws per month for personal use
Accounts payable
Note payable
Cost of building and land
Cash paid for building and land
Note payable signed for building and land

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.