Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Is this correct Small Builders, Inc. Depreciation Schedule Hint: Asset # 1001 IF=(condition, value if true, value if false) - Cell G12 Asset Display Cases
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. | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Contemporary Labor Economics
Authors: Campbell McConnell, Stanley Brue, David Macpherson
9th Edition
0073375950, 9780073375953
