, SOLUTION MANUAL FOR Excel Companion for Principles of Accounting
Courses Weinstein
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Practice Exercises Answer Key
Answer Key
Practice Exercises are completed in Excel. Once students complete their worksheet, they answer
a series of questions, which can be auto-graded in your LMS (if using). You may also want your
students to submit their Excel files to you so you can take a closer look.
This answer key shows the answers to all the questions that appear in the Practice Exercises
sections.
The Accounting Cycle
Check My Work: Tom’s Tutoring (answers also shown in the ebook)
1. $18,700
2. $1,410
3. Net loss
4. $10
5. $14,990
6. $17,290
Exercise 1: Pat’s Plumbing Exercise 3: Pina’s Piano Tuning
1. $37,000 1. $17,800
2. $1,430 2. $880
3. Net income 3. Net income
4. $3,070 4. $320
5. $35,070 5. $15,320
6. $35,570 6. $16,920
Exercise 2: Larry’s Landscaping Exercise 4: Cam’s Construction
1. $72,500 1. $62,800
2. $4,820 2. $1,400
3. Net income 3. Net income
4. $3,680 4. $5,400
5. $63,680 5. $55,400
6. $67,680 6. $61,400
Excel Companion for Principles of Accounting Courses Page 1 of 14
,Practice Exercises Answer Key
Inventory Costing
Check My Work: Appliance Kingdom (answers also shown in the ebook)
1. 150
2. $25,860
3. $13,540
4. $12,320
5. $14,160
6. $11,700
Exercise 1: Arcade Palace Exercise 3: Light Your World
1. 80 1. 95
2. $18,220 2. $115,460
3. $9,620 3. $78,110
4. $8,600 4. $37,350
5. $9,820 5. $78,560
6. $8,400 6. $36,900
Exercise 2: Computer Center Exercise 4: Pet Utopia
1. 250 1. 220
2. $27,590 2. $32,020
3. $20,090 3. $19,840
4. $7,500 4. $12,180
5. $20,390 5. $20,320
6. $7,200 6. $11,700
Excel Companion for Principles of Accounting Courses Page 2 of 14
,Practice Exercises Answer Key
Bank Reconciliation
Check My Work: Tightropes for All (answers also shown in the ebook)
1. $1,030
2. $710
3. $4,480
4. $660
5. Bank side
6. $46,620
Exercise 1: Sharon’s Sheds Exercise 3: Scoop Masters
1. $400 1. $1,120
2. $5,140 2. $1,880
3. $15,400 3. $1,840
4. $840 4. $400
5. Company side 5. Bank side
6. $157,060 6. $7,440
Exercise 2: Supreme Sailing Exercise 4: Beach Loungers
1. $3,650 1. $500
2. $560 2. $1,110
3. $820 3. $4,680
4. $1,930 4. $2,990
5. Bank side 5. Company side
6. $21,190 6. $72,490
Excel Companion for Principles of Accounting Courses Page 3 of 14
,Practice Exercises Answer Key
Aging of Accounts Receivable
Check My Work: Vincent Plumbing (answers also shown in the ebook)
1. $20,000
2. $33.20
3. $17,100
4. $241.80
5. $8,500
6. $925.20
Exercise 1: Granite Electric Exercise 3: Weston Painting
1. $8,400 1. $26,200
2. $29.40 2. $200.40
3. $6,800 3. $14,400
4. $176 4. $420
5. $4,100 5. $19,100
6. $681 6. $2,741.60
Exercise 2: Logan Exterminating Exercise 4: Montana Heating and
Cooling
1. $35,500 1. $38,500
2. $70.40 2. $180.60
3. $13,200 3. $17,300
4. $450 4. $618.80
5. $14,800 5. $9,300
6. $1,751.40 6. $2,474.20
Excel Companion for Principles of Accounting Courses Page 4 of 14
,Practice Exercises Answer Key
Depreciation Expense
Check My Work: Party Perfection (answers also shown in the ebook)
1. $10,000
2. $2,107
3. $218.18
4. $1,000
5. $0
6. $1,676.19
Exercise 1: Athlete Paradise Exercise 3: Tree People
1. $500 1. $300
2. $2,399.25 2. $258.07
3. $685.71 3. $685.71
4. $1,800 4. $100
5. $3,626.68 5. $288
6. $1,200 6. $727.27
Exercise 2: Gymnastic Funhouse Exercise 4: Personal Improvement
1. $6,000 1. $400
2. $912.68 2. $263.58
3. $7333.33 3. $933.33
4. $6,000 4. $1,000
5. $5,568 5. $24.28
6. $1,312.50 6. $1,066.67
Excel Companion for Principles of Accounting Courses Page 5 of 14
,Practice Exercises Answer Key
Payroll Register
Check My Work: Charlotte’s Salon (answers also shown in the ebook)
1. $6,527
2. $223.20
3. $317.87
4. $94.64
5. $439.86
6. $3,879.49
Exercise 1: Thompson Life Exercise 3: Abacus Accounting
Coaching
1. $7,644 1. $7,169
2. $37.20 2. $223.20
3. $139.13 3. $326.68
4. $110.84 4. $103.95
5. $641.29 5. $347.98
6. $4,839.03 6. $4,573.37
Exercise 2: King Financial Planning Exercise 4: Hometown Electric
1. $8,756 1. $8,071.50
2. $37.20 2. $378.20
3. $146.07 3. $475.63
4. $126.96 4. $117.04
5. $517.05 5. $456.45
6. $5,352.97 6. $4,873.83
Excel Companion for Principles of Accounting Courses Page 6 of 14
,Practice Exercises Answer Key
Bond Amortization
Check My Work: Golf World (answers also shown in the ebook)
1. $373.74
2. $7,394.19
3. $146,989.95
4. $420.40
5. $6,132.33
6. $145,677.63
Exercise 1: Johnson Furniture Exercise 3: Allentown Automotive
1. $1,227.83 1. $11,549.50
2. $12,926.43 2. $187,701.48
3. $211,572.75 3. $2,175,209.53
4. $1,421.36 4. $12,991.62
5. $8,658.95 5. $148,706.63
6. $207,091.90 6. $2,134,654.90
Exercise 2: Carolina Photography Exercise 4: Rick’s Diner
1. $353.80 1. $5,671.35
2. $4,747.63 2. $54,991.64
3. $64,361.27 3. $848,916.35
4. $403.74 4. $6,287.93
5. $3,535.62 5. $36,120.42
6. $63,094.72 6. $829,384.63
Excel Companion for Principles of Accounting Courses Page 7 of 14
, Practice Exercises Answer Key
Job Order Costing
Check My Work: Prometheus Auto (answers also shown in the ebook)
1. $720,000
2. $1,395,000
3. $306,000
4. $3,920,000
5. Overapplied
6. $12,000
Exercise 1: Triton Marine Exercise 3: Caan Entertainment
1. $310,000 1. $180,000
2. $590,000 2. $551,000
3. $56,000 3. $144,000
4. $3,950,000 4. $2,380,000
5. Underapplied 5. Underapplied
6. $18,000 6. $8,000
Exercise 2: Knotty Pine Furniture Exercise 4: Statham Uniforms
1. $55,000 1. $75,000
2. $163,000 2. $128,000
3. $80,000 3. $29,000
4. $1,730,000 4. $825,000
5. Overapplied 5. Overapplied
6. $3,000 6. $10,000
Excel Companion for Principles of Accounting Courses Page 8 of 14
Courses Weinstein
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Practice Exercises Answer Key
Answer Key
Practice Exercises are completed in Excel. Once students complete their worksheet, they answer
a series of questions, which can be auto-graded in your LMS (if using). You may also want your
students to submit their Excel files to you so you can take a closer look.
This answer key shows the answers to all the questions that appear in the Practice Exercises
sections.
The Accounting Cycle
Check My Work: Tom’s Tutoring (answers also shown in the ebook)
1. $18,700
2. $1,410
3. Net loss
4. $10
5. $14,990
6. $17,290
Exercise 1: Pat’s Plumbing Exercise 3: Pina’s Piano Tuning
1. $37,000 1. $17,800
2. $1,430 2. $880
3. Net income 3. Net income
4. $3,070 4. $320
5. $35,070 5. $15,320
6. $35,570 6. $16,920
Exercise 2: Larry’s Landscaping Exercise 4: Cam’s Construction
1. $72,500 1. $62,800
2. $4,820 2. $1,400
3. Net income 3. Net income
4. $3,680 4. $5,400
5. $63,680 5. $55,400
6. $67,680 6. $61,400
Excel Companion for Principles of Accounting Courses Page 1 of 14
,Practice Exercises Answer Key
Inventory Costing
Check My Work: Appliance Kingdom (answers also shown in the ebook)
1. 150
2. $25,860
3. $13,540
4. $12,320
5. $14,160
6. $11,700
Exercise 1: Arcade Palace Exercise 3: Light Your World
1. 80 1. 95
2. $18,220 2. $115,460
3. $9,620 3. $78,110
4. $8,600 4. $37,350
5. $9,820 5. $78,560
6. $8,400 6. $36,900
Exercise 2: Computer Center Exercise 4: Pet Utopia
1. 250 1. 220
2. $27,590 2. $32,020
3. $20,090 3. $19,840
4. $7,500 4. $12,180
5. $20,390 5. $20,320
6. $7,200 6. $11,700
Excel Companion for Principles of Accounting Courses Page 2 of 14
,Practice Exercises Answer Key
Bank Reconciliation
Check My Work: Tightropes for All (answers also shown in the ebook)
1. $1,030
2. $710
3. $4,480
4. $660
5. Bank side
6. $46,620
Exercise 1: Sharon’s Sheds Exercise 3: Scoop Masters
1. $400 1. $1,120
2. $5,140 2. $1,880
3. $15,400 3. $1,840
4. $840 4. $400
5. Company side 5. Bank side
6. $157,060 6. $7,440
Exercise 2: Supreme Sailing Exercise 4: Beach Loungers
1. $3,650 1. $500
2. $560 2. $1,110
3. $820 3. $4,680
4. $1,930 4. $2,990
5. Bank side 5. Company side
6. $21,190 6. $72,490
Excel Companion for Principles of Accounting Courses Page 3 of 14
,Practice Exercises Answer Key
Aging of Accounts Receivable
Check My Work: Vincent Plumbing (answers also shown in the ebook)
1. $20,000
2. $33.20
3. $17,100
4. $241.80
5. $8,500
6. $925.20
Exercise 1: Granite Electric Exercise 3: Weston Painting
1. $8,400 1. $26,200
2. $29.40 2. $200.40
3. $6,800 3. $14,400
4. $176 4. $420
5. $4,100 5. $19,100
6. $681 6. $2,741.60
Exercise 2: Logan Exterminating Exercise 4: Montana Heating and
Cooling
1. $35,500 1. $38,500
2. $70.40 2. $180.60
3. $13,200 3. $17,300
4. $450 4. $618.80
5. $14,800 5. $9,300
6. $1,751.40 6. $2,474.20
Excel Companion for Principles of Accounting Courses Page 4 of 14
,Practice Exercises Answer Key
Depreciation Expense
Check My Work: Party Perfection (answers also shown in the ebook)
1. $10,000
2. $2,107
3. $218.18
4. $1,000
5. $0
6. $1,676.19
Exercise 1: Athlete Paradise Exercise 3: Tree People
1. $500 1. $300
2. $2,399.25 2. $258.07
3. $685.71 3. $685.71
4. $1,800 4. $100
5. $3,626.68 5. $288
6. $1,200 6. $727.27
Exercise 2: Gymnastic Funhouse Exercise 4: Personal Improvement
1. $6,000 1. $400
2. $912.68 2. $263.58
3. $7333.33 3. $933.33
4. $6,000 4. $1,000
5. $5,568 5. $24.28
6. $1,312.50 6. $1,066.67
Excel Companion for Principles of Accounting Courses Page 5 of 14
,Practice Exercises Answer Key
Payroll Register
Check My Work: Charlotte’s Salon (answers also shown in the ebook)
1. $6,527
2. $223.20
3. $317.87
4. $94.64
5. $439.86
6. $3,879.49
Exercise 1: Thompson Life Exercise 3: Abacus Accounting
Coaching
1. $7,644 1. $7,169
2. $37.20 2. $223.20
3. $139.13 3. $326.68
4. $110.84 4. $103.95
5. $641.29 5. $347.98
6. $4,839.03 6. $4,573.37
Exercise 2: King Financial Planning Exercise 4: Hometown Electric
1. $8,756 1. $8,071.50
2. $37.20 2. $378.20
3. $146.07 3. $475.63
4. $126.96 4. $117.04
5. $517.05 5. $456.45
6. $5,352.97 6. $4,873.83
Excel Companion for Principles of Accounting Courses Page 6 of 14
,Practice Exercises Answer Key
Bond Amortization
Check My Work: Golf World (answers also shown in the ebook)
1. $373.74
2. $7,394.19
3. $146,989.95
4. $420.40
5. $6,132.33
6. $145,677.63
Exercise 1: Johnson Furniture Exercise 3: Allentown Automotive
1. $1,227.83 1. $11,549.50
2. $12,926.43 2. $187,701.48
3. $211,572.75 3. $2,175,209.53
4. $1,421.36 4. $12,991.62
5. $8,658.95 5. $148,706.63
6. $207,091.90 6. $2,134,654.90
Exercise 2: Carolina Photography Exercise 4: Rick’s Diner
1. $353.80 1. $5,671.35
2. $4,747.63 2. $54,991.64
3. $64,361.27 3. $848,916.35
4. $403.74 4. $6,287.93
5. $3,535.62 5. $36,120.42
6. $63,094.72 6. $829,384.63
Excel Companion for Principles of Accounting Courses Page 7 of 14
, Practice Exercises Answer Key
Job Order Costing
Check My Work: Prometheus Auto (answers also shown in the ebook)
1. $720,000
2. $1,395,000
3. $306,000
4. $3,920,000
5. Overapplied
6. $12,000
Exercise 1: Triton Marine Exercise 3: Caan Entertainment
1. $310,000 1. $180,000
2. $590,000 2. $551,000
3. $56,000 3. $144,000
4. $3,950,000 4. $2,380,000
5. Underapplied 5. Underapplied
6. $18,000 6. $8,000
Exercise 2: Knotty Pine Furniture Exercise 4: Statham Uniforms
1. $55,000 1. $75,000
2. $163,000 2. $128,000
3. $80,000 3. $29,000
4. $1,730,000 4. $825,000
5. Overapplied 5. Overapplied
6. $3,000 6. $10,000
Excel Companion for Principles of Accounting Courses Page 8 of 14
