978-1337398169 Chapter 3 Excel

subject Type Homework Help
subject Pages 10
subject Words 1258
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
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry.
1. Account Debit Credit
31
31
31
31
2.
are a planned part of the accounting
process.
are not planned but arise only when
necessary to correct errors.
Mar. 31
Problem 3-1A
Name:
Section:
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
page-pf2
Score:
1. Account Debit Credit
Supplies Expense 4,330
Supplies 4,330
31 Unearned Rent 1,250
Rent Revenue 1,250
31 Wages Expense 2,290
Wages Payable 2,290
31 Accounts Receivable 16,825
Fees Earned 16,825
31 Depreciation Expense 4,600
Accumulated Depreciation 4,600
2.
Adjusting entries
are a planned part of the accounting
process.
Mar. 31
Name:
Solution
Section:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
page-pf3
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry.
1. Account Debit Credit
31
31
31
31
2.
are a planned part of the accounting
process to update the accounts.
are not planned but arise only when
necessary to correct errors.
May 31
Problem 3-1B
Name:
Section:
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
page-pf4
Score:
1. Account Debit Credit
Accounts Receivable 19,750
Fees Earned 19,750
31 Supplies Expense 8,150
Supplies 8,150
31 Wages Expense 2,700
Wages Payable 2,700
31 Unearned Rent 3,000
Rent Revenue 3,000
31 Depreciation Expense 3,200
Accumulated Depreciation 3,200
2.
Adjusting entries
are a planned part of the accounting
process to update the accounts.
May 31
Name:
Solution
Section:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry.
In the trial balance, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
31
31
31
31
31
31
2.
Debit Balances Credit Balances
Cash
Accounts Receivable
Prepaid Insurance
Supplies
Land
Building
Accumulated Depreciation - Building
Equipment
Accumulated Depreciation - Equipment
Accounts Payable
Unearned Rent
Salaries and Wages Payable
Common Stock
Retained Earnings
Dividends
Fees Earned
Problem 3-5A
Name:
Section:
Sears Editing Company
Adjusted Trial Balance
January 31, 20Y1
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
20Y1
Jan. 31
Rent Revenue
Salaries and Wages Expense
Utilities Expense
Advertising Expense
Repairs Expense
Depreciation Expense - Building
Depreciation Expense - Equipment
Insurance Expense
Supplies Expense
Miscellaneous Expense
page-pf7
Score:
In the trial balance, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
Insurance Expense 4,800
Prepaid Insurance 4,800
31 Supplies Expense 1,730
Supplies 1,730
31 Depreciation Expense - Building 6,600
Accumulated Depreciation - Building 6,600
Accounts Receivable 53,400 -
Prepaid Insurance 2,400 -
Supplies 250 -
Land 112,500 -
Building 150,250 -
Accumulated Depreciation - Building - 94,150
Equipment 135,300 -
ON
Problem 3-5A
Name:
Solution
Section:
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
20Y1
Jan. 31
page-pf8
Unearned Rent - 2,750
Salaries and Wages Payable - 1,800
Common Stock - 75,000
Retained Earnings 146,000
Dividends 15,000 -
Fees Earned - 339,600
Rent Revenue - 4,000
Salaries and Wages Expense 195,170 -
Utilities Expense 42,375 -
Advertising Expense 22,800 -
Repairs Expense 17,250 -
Depreciation Expense - Building 6,600 -
Depreciation Expense - Equipment 3,500 -
Insurance Expense 4,800 -
Supplies Expense 1,730 -
Miscellaneous Expense 6,075 -
776,900 776,900
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry.
In the trial balance, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
31
31
31
31
31
31
2.
Debit Credit
Cash
Accounts Receivable
Prepaid Insurance
Supplies
Land
Building
Accumulated Depreciation - Building
Equipment
Accumulated Depreciation - Equipment
Accounts Payable
Unearned Rent
Salaries and Wages Payable
Common Stock
Retained Earnings
Dividends
Fees Earned
Problem 3-5B
Name:
Section:
Reece Financial Services Co.
Adjusted Trial Balance
July 31, 20Y9
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
20Y9
July 31
Rent Revenue
Salaries and Wages Expense
Utilities Expense
Advertising Expense
Depreciation Expense - Building
Repairs Expense
Insurance Expense
Depreciation Expense - Equipment
Supplies Expense
Miscellaneous Expense
page-pfb
Score:
In the trial balance, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
Depreciation Expense - Building 6,400
Accumulated Depreciation - Building 6,400
31 Depreciation Expense - Equipment 2,800
Accumulated Depreciation - Equipment 2,800
31 Salaries and Wages Expense 900
Salaries and Wages Payable 900
Accounts Receivable 44,950 -
Prepaid Insurance 1,500 -
Supplies 615 -
Land 50,000 -
Building 155,750 -
Accumulated Depreciation - Building - 69,250
Equipment 45,000 -
ON
Problem 3-5B
Name:
Solution
Section:
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
20Y9
July 31
page-pfc
Unearned Rent - 300
Salaries and Wages Payable - 900
Common Stock - 60,000
Retained Earnings - 93,550
Dividends 8,000 -
Fees Earned - 168,800
Rent Revenue - 3,300
Salaries and Wages Expense 57,750 -
Utilities Expense 14,100 -
Advertising Expense 7,500 -
Depreciation Expense - Building 6,400 -
Repairs Expense 6,100 -
Insurance Expense 4,500 -
Depreciation Expense - Equipment 2,800 -
Supplies Expense 1,110 -
Miscellaneous Expense 4,025 -
420,300 420,300
Score:
Key Code:
An asterisk (*) will appear to the right of an incorrect entry.
In the table, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
30
30
30
2.
= +
Reported amounts
Corrections:
Supplies used
Unbilled fees used
Equipment depreciation
Accrued wages
Corrected amounts
Problem 3-6A
Name:
Section:
Net
Income
Total
Assets
Total
Liabilities
Total
Stockholders'
Equity
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Apr. 30
page-pfe
Score:
In the table, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
Supplies Expense 2,750
Supplies 2,750
30 Accounts Receivable 23,700
Fees Earned 23,700
30 Depreciation Expense 1,800
Accumulated Depreciation 1,800
30 Wages Expense 1,400
Wages Payable 1,400
2.
= +
Reported amounts 120,000$ 750,000$ 300,000$ 450,000$
Corrections:
Supplies used (2,750) (2,750) - (2,750)
Unbilled fees used 23,700 23,700 - 23,700
Equipment depreciation (1,800) (1,800) - (1,800)
Accrued wages (1,400) - 1,400 (1,400)
Corrected amounts 137,750$ 769,150$ 301,400$ 467,750$
ON
Problem 3-6A
Name:
Solution
Section:
Net
Income
Total
Assets
Total
Liabilities
Total
Stockholders'
Equity
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Apr. 30
Score:
Key Code:
An asterisk (*) will appear to the left of an incorrect entry.
In the table, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
31
31
31
2.
= +
Reported amounts
Corrections:
Unbilled fees earned
Equipment depreciation
Accrued wages
Supplies used
Corrected amounts
Problem 3-6B
Name:
Section:
Net
Income
Total
Assets
Total
Liabilities
Total
Stockholders'
Equity
0%
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Aug. 31
page-pf10
Score:
Key Code:
In the table, enter a zero in cells you would otherwise leave blank.
1. Account Debit Credit
Accounts Receivable 31,900
Fees Earned 31,900
31 Depreciation Expense 7,500
Accumulated Depreciation 7,500
31 Wages Expense 5,200
Wages Payable 5,200
31 Supplies Expense 3,000
Supplies 3,000
2.
= +
Reported amounts 112,500$ 650,000$ 225,000$ 425,000$
Corrections:
Unbilled fees earned 31,900 31,900 - 31,900
Equipment depreciation (7,500) (7,500) - (7,500)
Accrued wages (5,200) - 5,200 (5,200)
Supplies used (3,000) (3,000) - (3,000)
Corrected amounts 128,700$ 671,400$ 230,200$ 441,200$
ON
Problem 3-6B
Name:
Solution
Section:
Net
Income
Total
Assets
Total
Liabilities
Total
Stockholders'
Equity
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the left of an incorrect entry.
Aug. 31

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.