5 6 Cost $20,000 Purchased equipment on January 1 of the current year. 7 Salvage value 8 Estimated useful life (Years) $2,000 6 Years 9 10 11 12 45 Amount of straight-line depreciation reported on the December 31 income statement. Amount of Accumulated Depreciation reported on the December 31 balance sheet. Book value of Equipment reported on the December 31 balance sheet. Which formula in cell B11 correctly calculates the amount of Accumulated Depreciation Equipment reported on the December 31 balance sheet?

Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter7: Fixed Assets, Natural Resources, And Intangible Assets
Section: Chapter Questions
Problem 7.3.4MBA
icon
Related questions
Question
None
Applying Excel 3: Accumulated Depreciation
A
B
C
D
E
F
1
Equipment
2
Jan. 1
20,000
3
4
5
6
Cost
7 Salvage value
8 Estimated useful life (Years)
$20,000
$2,000
6
Purchased equipment on January 1 of the current year.
Years
9
1120
Amount of straight-line depreciation reported on the December 31 income statement.
Amount of Accumulated Depreciation reported on the December 31 balance sheet.
Book value of Equipment reported on the December 31 balance sheet.
Which formula in cell B11 correctly calculates the amount of Accumulated Depreciation - Equipment reported on the December 31 balance sheet?
Multiple Choice
=+(86-87)/B8
=+86+B7/B8
=+86-B7/B8
Transcribed Image Text:Applying Excel 3: Accumulated Depreciation A B C D E F 1 Equipment 2 Jan. 1 20,000 3 4 5 6 Cost 7 Salvage value 8 Estimated useful life (Years) $20,000 $2,000 6 Purchased equipment on January 1 of the current year. Years 9 1120 Amount of straight-line depreciation reported on the December 31 income statement. Amount of Accumulated Depreciation reported on the December 31 balance sheet. Book value of Equipment reported on the December 31 balance sheet. Which formula in cell B11 correctly calculates the amount of Accumulated Depreciation - Equipment reported on the December 31 balance sheet? Multiple Choice =+(86-87)/B8 =+86+B7/B8 =+86-B7/B8
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting for Property, Plant and Equipment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning