Question

Is this correct Small Builders, Inc. Depreciation Schedule Hint: Asset # 1001 IF=(condition, value if true,...

Is this correct

Small Builders, Inc. Depreciation Schedule
Hint:
Asset # 1001 IF=(condition, value if true, value if false) - Cell G12
Asset Display Cases IF=[condition, value if true, value if false(condition, value if true, value if false)] - Cells G13-G16
Date acquired 1/1/2015 X should switch
Cost $        15,000.00 - do not switch
Depreciation method DDB
Salvage value
Estimated useful life 5
Year Depreciation Expense Accumulated Depreciation Straight-Line Test Switch* Depreciation Expense Accumulated Depreciation
2015 $6,000.00 $6,000.00 $3,750.00 - 6000 $6,000.00
2016 $3,600.00 $9,600.00 $2,250.00 - 3600 $9,600.00
2017 $2,160.00 $11,760.00 $1,800.00 - 2160 $11,760.00
2018 $1,296.00 $13,056.00 $1,620.00 X 1620 $13,380.00
2019 $777.60 $13,833.60 $1,944.00 X 1620 $15,000.00
**If a switch is appropriate then the straight-line depreciation expense will be used, otherwise the depreciation expense for
double-declining balance will be used.
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Is this correct Small Builders, Inc. Depreciation Schedule Hint: Asset # 1001 IF=(condition, value if true,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • If the salvage value was decreased for Asset 1002, what affect would there be on depreciation...

    If the salvage value was decreased for Asset 1002, what affect would there be on depreciation expense? What affect on the Accumulated Depreciation Small Builders, Inc. Depreciation Schedule Asset # 1001 IF=(condition, value if true, value if false) - Cell G12 Asset Display Cases IF=[condition, value if true, value if false(condition, value if true, value if false)] - Cells G13-G16 Date acquired 1/1/2015 X should switch Cost $        15,000.00 - do not switch Depreciation method DDB Salvage value Estimated useful...

  • deprecaion ror partial periods. Save the worbook as ha-OS student name (replacing student name with your na...

    deprecaion ror partial periods. Save the worbook as ha-OS student name (replacing student name with your name). Print the newly created worksheet Chapter 4 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique owned the following fixed assets as of December 31, 2018: Description 102 103 101 Asset # Building Computer System Phone System Asset Date acquired Cost $625,000 $95,000 $25,000 $4,000 25 years $84,000 $5,000 5 years Salvage value Estimated useful life 4 years Excel for Part 1 08 You are...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT