978-0078025273 Chapter 12 Excel

subject Type Homework Help
subject Pages 8
subject Words 1102
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:
Account Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
25,010.00 25,010.00
1,340.00 1,340.00
860.00 a 280.00 580.00
9,000.00 b 1,500.00 7,500.00
1,620.00 c 135.00 1,485.00
360.00 d 90.00 270.00
12,050.00 12,050.00
e 125.00 125.00
6,400.00 6,400.00
f 80.00 80.00
16,700.00 16,700.00
4,500.00 4,500.00
g 52.00 52.00
4,800.00 h 400.00 4,400.00
28,220.00 28,220.00
2,000.00 2,000.00
8,000.00 h 400.00 8,400.00
3,200.00 3,200.00
220.00 220.00
160.00 160.00
a 280.00 280.00
b 1,500.00 1,500.00
c 135.00 135.00
e 125.00 125.00
f 80.00 80.00
d 90.00 142.00
g 52.00
62,220.00 62,220.00 2,662.00 2,662.00 62,477.00 62,477.00
Correct! Correct! Correct! Correct! Correct! Correct!
Net Income
Prepaid Rent
Supplies
Accounts Receivable
Cash
Accumulated Dep. - Office Equipment
Office Equipment
Accumulated Dep. - Office Furniture
Office Furniture
Prepaid Interest
Prepaid Insurance
Michael Brady, Drawing
Michael Brady, Capital
Unearned Consulting Fees
Interest Payable
Accounts Payable
Notes Payable
Rent Expense
Supplies Expense
Telephone Expense
Utilities Expense
Salaries Expense
Consulting Fees
Totals
Interest Expense
Depreciation Expense - Office Equipment
Depreciation Expense - Office Furniture
Insurance Expense
Balance Sheet
Income
Trial Balance
Adjustments
Trial Balance
Statement
Instructor
McGraw-Hill/Irwin
Problem 12.03A
Adjusted
Month Ended July 31, 2013
Worksheet
MICHAEL BRADY, CONSULTANT
page-pf2
25,010$ Dr.
1,340 Dr.
860 Dr.
9,000 Dr.
1,620 Dr.
360 Dr.
12,050 Dr.
6,400 Dr.
16,700 Cr.
4,500 Cr.
4,800 Cr.
28,220 Cr.
2,000 Dr.
8,000 Cr.
3,200 Dr.
220 Dr.
160 Dr.
9,000
1,620
360
12,050
7
1,550
6,400
5
1,600
7,800
4,800
Accumulated Dep. - Furniture
Furniture
Prepaid Interest
Prepaid Insurance
Given Data P12.03A:
Prepaid Rent
Supplies
Accounts Receivable
Cash
Unearned Consulting Fees
Interest Payable
Accounts Payable
Notes Payable
Accumulated Dep. - Equipment
Equipment
Telephone Expense
Utilities Expense
Salaries Expense
Consulting Fees
Michael Brady, Drawing
Michael Brady, Capital
Expected useful life in years
e. On July 1 purchased office furniture
d. On July 1 paid interest in advance on four-month bank note
c. On July 1 purchased a one-year insurance policy
b. On July 1 paid in advance for six months' rent
h. On July 1 received one-year's consulting fee in advance
g. On July 1 issued three-month, 8% note
Expected salvage value
Expected useful life in years
f. On July 1 purchased office equipment
Expected salvage value
MICHAEL BRADY, CONSULTANT
Month Ended July 31, 2013
General Ledger
page-pf3
Student Name:
Class:
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
5,700.00 5,700.00 5,700.00
2,600.00 2,600.00 2,600.00
52.00 c 210.00 262.00 262.00
11,300.00 b 12,321.00 a 11,300.00 12,321.00 12,321.00
1,200.00 d 925.00 275.00 275.00
960.00 e 480.00 480.00 480.00
8,100.00 8,100.00 8,100.00
1,500.00 f 1,500.00 3,000.00 3,000.00
1,600.00 1,600.00 1,600.00
280.00 g 280.00 560.00 560.00
2,625.00 2,625.00 2,625.00
430.00 i 113.46 543.46 543.46
98.00 i 26.54 124.54 124.54
j 14.64 14.64 14.64
j 98.82 98.82 98.82
h 1,830.00 1,830.00 1,830.00
25,457.00 25,457.00 25,457.00
20,000.00 20,000.00 20,000.00
90,048.00 90,048.00 90,048.00
1,100.00 1,100.00 1,100.00
46,400.00 46,400.00 46,400.00
430.00 430.00 430.00
6,000.00 6,000.00 6,000.00
590.00 590.00 590.00
14,100.00 h 1,830.00 15,930.00 15,930.00
1,270.00 i 140.00 1,523.46 1,523.46
j 113.46
a 11,300.00 b 12,321.00 11,300.00 12,321.00 11,300.00 12,321.00
d 925.00 925.00 925.00
e 480.00 480.00 480.00
f 1,500.00 1,500.00 1,500.00
g 280.00 280.00 280.00
120,920.00 120,920.00 28,889.46 29,099.46 137,104.46 137,314.46 86,028.46 102,799.00 51,076.00 34,515.46
120,920.00 120,920.00 28,889.46 29,099.46 137,104.46 137,314.46 86,028.46 102,799.00 51,076.00 34,515.46
c 210.00 210.00 210.00
120,920.00 120,920.00 29,099.46 29,099.46 137,314.46 137,314.46 86,238.46 102,799.00 51,076.00 34,515.46
Correct! Correct! Correct! Correct! Correct! Correct! 16,560.54 16,560.54
102,799.00 102,799.00 51,076.00 51,076.00
Correct! Correct! Correct! Correct!
Cash
Year Ended December 31, 2013
Worksheet
THE GREEN THUMB GALLERY
Account Name
Trial Balance
Adjustments
Trial Balance
Statement
Store Equipment
Prepaid Advertising
Supplies
Merchandise Inventory
Allowance for Doubtful Accounts
Accounts Receivable
Medicare Tax Payable
Social Security Tax Payable
Accounts Payable
Accumulated Dep. - Office Equipment
Office Equipment
Accumulated Dep. - Store Equipment
Sales
Beth Argo, Drawing
Beth Argo, Capital
Salaries Payable
State Unemployment Tax Payable
Federal Unemployment Tax Payable
Salaries Expense
Telephone Expense
Rent Expense
Purchases Returns and Allowances
Purchases
Sales Returns and Allowances
Depreciation Expense - Store Equip.
Advertising Expense
Supplies Expense
Income Summary
Payroll Taxes Expense
Net Income
Totals
Uncollectible Accounts Expense
Totals Brought Forward
Totals Carried Forward
Depreciation Expense - Off. Equipment
Instructor
McGraw-Hill/Irwin
Problem 12.04A
Balance Sheet
Adjusted
Income
page-pf4
5,700$ Dr.
2,600 Dr.
52 Cr.
11,300 Dr.
1,200 Dr.
960 Dr.
8,100 Dr.
1,500 Cr.
1,600 Dr.
280 Cr.
2,625 Cr.
430 Cr.
98 Cr.
12,321$
35,000$
0.60%
275$
960$
8,100$
5
600$
Prepaid Advertising
Cash
Supplies
Merchandise Inventory
Allowance for Doubtful Accounts
Accounts Receivable
Social Security Tax Payable
Accounts Payable
Accumulated Depr. - Office Equipment
Office Equipment
Accumulated Depr. - Store Equipment
Store Equipment
Federal Unemployment Tax Payable
Medicare Tax Payable
Percent deemed uncollectible
c. Net credit sales for 2013
a.-b. Merchandise Inventory on December 31
End of Month Adjustments
Expected salvage value
Expected useful life in years
f. Purchased store equipment on January 2:
signed on October 1.
e. Paid in advance for a six-month advertising contract
d. Supplies on hand at December 31
Given Data P12.04A:
THE GREEN THUMB GALLERY
General Ledger
Month Ended December 31, 2013
page-pf5
1,830$
6.20%
1.45%
0.80%
5.40%
SUTA tax rate percentage
j. FUTA tax rate percentage
Medicare tax rate percentage
Social Security tax rate percentage
i. Taxes owed on total accrued wages:
h. On December 31 owed salaries to be paid until 2014
page-pf6
Student Name:
Class:
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
30,100.00 30,100.00 30,100.00
35,200.00 35,200.00 35,200.00
420.00 c 2,800.00 3,220.00 3,220.00
86,000.00 b 78,000.00 a 86,000.00 78,000.00 78,000.00
10,400.00 d 9,220.00 1,180.00 1,180.00
5,400.00 e 3,600.00 1,800.00 1,800.00
8,300.00 8,300.00 8,300.00
2,650.00 f 1,325.00 3,975.00 3,975.00
28,000.00 28,000.00 28,000.00
9,600.00 g 4,800.00 14,400.00 14,400.00
32,000.00 32,000.00 32,000.00
12,200.00 12,200.00 12,200.00
h 640.00 640.00 640.00
1,680.00 j 310.00 1,990.00 1,990.00
388.00 j 72.50 460.50 460.50
k 40.00 40.00 40.00
k 270.00 270.00 270.00
i 5,000.00 5,000.00 5,000.00
108,684.00 108,684.00 108,684.00
56,000.00 56,000.00 56,000.00
653,778.00 653,778.00 653,778.00
10,000.00 10,000.00 10,000.00
350,000.00 350,000.00 350,000.00
9,200.00 9,200.00 9,200.00
a 86,000.00 b 78,000.00 86,000.00 78,000.00 86,000.00 78,000.00
36,000.00 36,000.00 36,000.00
2,200.00 2,200.00 2,200.00
160,000.00 i 5,000.00 165,000.00 165,000.00
13,000.00 j 382.50 13,692.50 13,692.50
k 310.00
d 9,220.00 9,220.00 9,220.00
e 3,600.00 3,600.00 3,600.00
830,600.00 830,600.00 182,512.50 192,077.50 914,292.50 923,857.50 675,712.50 740,978.00 238,580.00 182,879.50
830,600.00 830,600.00 914,292.50 923,857.50 675,712.50 740,978.00 238,580.00 182,879.50
f 1,325.00 1,325.00 1,325.00
g 4,800.00 4,800.00 4,800.00
c 2,800.00 2,800.00 2,800.00
h 640.00 640.00 640.00
830,600.00 830,600.00 192,077.50 192,077.50 923,857.50 923,857.50 685,277.50 740,978.00 238,580.00 182,879.50
Correct! Correct! Correct! Correct! Correct! Correct! 55,700.50 55,700.50
740,978.00 740,978.00 238,580.00 238,580.00
Correct! Correct! Correct! Correct!
Instructor
McGraw-Hill/Irwin
Problem 12.05A
Worksheet
HEALTHY HABITS FOODS CO
Balance Sheet
Adjusted
Income
Year Ended December 31, 2013
Trial Balance
Adjustments
Trial Balance
Statement
Depr. Expense - Warehouse Equip.
Depr. Expense - Office Equipment
Totals Brought Forward
Totals Carried Forward
Net Income
Totals
Interest Expense
Uncollectible Accounts Expense
Salaries Expense
Telephone Expense
Rent Expense
Income Summary
Insurance Expense
Supplies Expense
Payroll Taxes Expense
Phillip Tucker, Drawing
Phillip Tucker, Capital
Salaries Payable
State Unemployment Tax Payable
Purchases Returns and Allowances
Purchases
Sales Returns and Allowances
Sales
Accounts Payable
Notes Payable Bank
Accumulated Dep. - Warehouse Equip.
Warehouse Equipment
Federal Unemployment Tax Payable
Medicare Tax Payable
Social Security Tax Payable
Interest Payable
Account Name
Merchandise Inventory
Allowance for Doubtful Accounts
Accounts Receivable
Cash
Accumulated Dep. - Office Equipment
Office Equipment
Prepaid Insurance
Supplies
page-pf7
Cash 30,100.00 Dr.
Accounts Receivable 35,200.00 Dr.
Allowance for Doubtful Accounts 420.00 Cr.
Merchandise Inventory 86,000.00 Dr.
Supplies 10,400.00 Dr.
Prepaid Insurance 5,400.00 Dr.
Office Equipment 8,300.00 Dr.
Accumulated Dep. - Office Equipment 2,650.00 Cr.
Warehouse Equipment 28,000.00 Dr.
Accumulated Dep. - Warehouse Equip. 9,600.00 Cr.
Notes Payable Bank 32,000.00 Cr.
Accounts Payable 12,200.00 Cr.
Interest Payable
Social Security Tax Payable 1,680.00 Cr.
a.-b. Merchandise Inventory on December 31 78,000$
c. Net credit sales for 2013 560,000$
Percent deemed uncollectible 5.00%
d. Supplies on hand at December 31 1,180$
e. Paid in advance for a one-year insurance policy
on May 1. 5,400$
f. Purchased office equipment on January 2: 8,300$
Expected useful life in years
6
End of Month Adjustments
Given Data P12.05A:
HEALTHY HABITS FOODS COMPANY
General Ledger
Month Ended December 31, 2013
page-pf8
g. Purchased warehouse equipment on January 2: 28,000$
Expected useful life in years
5
Expected salvage value 4,000$
h. On November 1 issued a four-month, 12% note 32,000$
i. On December 31 owed salaries to be paid until 2014 5,000$
j. Taxes owed on total accrued wages:
Social Security tax rate percentage 6.20%
Medicare tax rate percentage 1.45%
k. FUTA tax rate percentage 0.80%
SUTA tax rate percentage 5.40%

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.