, SOLUTION MANUAL FOR Excel Companion for Financial 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.
,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 Financial Accounting Courses Page 1 of 7
,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 Financial Accounting Page 2 of 7
,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 Financial Accounting Page 3 of 7
,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 Financial Accounting Page 4 of 7
,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 Financial Accounting Page 5 of 7
,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 Financial Accounting Page 6 of 7
,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 Financial Accounting Page 7 of 7
, Schedule Date: 12/31/2027
1-30 Days 31-60 Days 61-90 Days Over 90 Days
Customer A/R Balance Not Yet Due Past Due Past Due Past Due Past Due
Appleby Orange Grove $ 800 $ 800
Athena Construction $ 300 $ 300
Brown Audio Sales $ 5,800 $ 5,800
Daisy Frozen Foods $ 2,900 $ 2,900
Eli's Entertainment Corporatio $ 4,200 $ 4,200
Exotic Vets $ 1,800 $ 1,800
Green and Blue Enterprises $ 500 $ 500
Kitchner Consulting $ 5,900 $ 5,900
Personal Computing Advisors $ 3,500 $ 3,500
Phantom Roofing $ 6,600 $ 6,600
Sailboat Suppliers $ 3,100 $ 3,100
Screen Repair Company $ 6,400 $ 6,400
Ski Outfitters $ 1,700 $ 1,700
Sutherland Seating $ 7,000 $ 7,000
Twist Sweets $ 2,700 $ 2,700
Ventilation and More $ 1,300 $ 1,300
Window Covering Specialists $ 3,300 $ 3,300
Zorro Electric $ 5,400 $ 5,400
Total $ 63,200 $ 20,000 $ 8,300 $ 17,100 $ 9,300 $ 8,500
Percent Uncollectible 0.1% 0.4% 1.2% 2.6% 5.0%
Uncollectible Amount $ 20.00 $ 33.20 $ 205.20 $ 241.80 $ 425.00
Total Uncollectible Accounts Receivable: $ 925.20
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.
,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 Financial Accounting Courses Page 1 of 7
,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 Financial Accounting Page 2 of 7
,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 Financial Accounting Page 3 of 7
,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 Financial Accounting Page 4 of 7
,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 Financial Accounting Page 5 of 7
,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 Financial Accounting Page 6 of 7
,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 Financial Accounting Page 7 of 7
, Schedule Date: 12/31/2027
1-30 Days 31-60 Days 61-90 Days Over 90 Days
Customer A/R Balance Not Yet Due Past Due Past Due Past Due Past Due
Appleby Orange Grove $ 800 $ 800
Athena Construction $ 300 $ 300
Brown Audio Sales $ 5,800 $ 5,800
Daisy Frozen Foods $ 2,900 $ 2,900
Eli's Entertainment Corporatio $ 4,200 $ 4,200
Exotic Vets $ 1,800 $ 1,800
Green and Blue Enterprises $ 500 $ 500
Kitchner Consulting $ 5,900 $ 5,900
Personal Computing Advisors $ 3,500 $ 3,500
Phantom Roofing $ 6,600 $ 6,600
Sailboat Suppliers $ 3,100 $ 3,100
Screen Repair Company $ 6,400 $ 6,400
Ski Outfitters $ 1,700 $ 1,700
Sutherland Seating $ 7,000 $ 7,000
Twist Sweets $ 2,700 $ 2,700
Ventilation and More $ 1,300 $ 1,300
Window Covering Specialists $ 3,300 $ 3,300
Zorro Electric $ 5,400 $ 5,400
Total $ 63,200 $ 20,000 $ 8,300 $ 17,100 $ 9,300 $ 8,500
Percent Uncollectible 0.1% 0.4% 1.2% 2.6% 5.0%
Uncollectible Amount $ 20.00 $ 33.20 $ 205.20 $ 241.80 $ 425.00
Total Uncollectible Accounts Receivable: $ 925.20
