Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Labor Economics

Authors: Campbell McConnell, Stanley Brue, David Macpherson

9th Edition

0073375950, 9780073375953

More Books

Students also viewed these Accounting questions