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. |
Is this correct Small Builders, Inc. Depreciation Schedule Hint: Asset # 1001 IF=(condition, value if true,...
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 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...