Which of the following formulas in cell CB, when copied to cells C9 through C12, would yield the correct amount of double-declining- balance depreciation? 1 2 Cost 3 Salvage 4 Life (in years) 5 6 78 A 9 10 11 12 Year 1 2 3 4 5 B $440,000 $40,000 5 January 1 book value $440,000 $264,000 $158,400 $95,040 $57,024 C Depreciation Expense $176,000 $105,600 $63,360 $38,016 $17,024 D Accumulated Depreciation $176,000 $281,600 $344,960 $382,976 $400,000 E December 31 book value $264,000 $158,400 $95,040 $57,024 $40,000

Income Tax Fundamentals 2020
38th Edition
ISBN:9780357391129
Author:WHITTENBURG
Publisher:WHITTENBURG
Chapter8: Depreciation And Sale Of Business Property
Section: Chapter Questions
Problem 6MCQ: Which of the following is not true about the MACRS depreciation system: A salvage value must be...
icon
Related questions
Topic Video
Question
Which of the following formulas in cell C8, when copied to cells C9 through C12, would yield the correct amount of double-declining-
balance depreciation?
A
1
2 Cost
3 Salvage
4 Life (in years)
5
6
7
8
9
10
11
12
Year
1
2
3
4
5
B
$440,000
$40,000
5
C
January 1 book Depreciation
value
Expense
$440,000
$264,000
$158,400
$95,040
$57,024
$176,000
$105,600
$63,360
$38,016
$17,024
D
Accumulated
Depreciation
$176,000
$281,600
$344,960
$382,976
$400,000
E
December 31
book value
$264,000
$158,400
$95,040
$57,024
$40,000
Transcribed Image Text:Which of the following formulas in cell C8, when copied to cells C9 through C12, would yield the correct amount of double-declining- balance depreciation? A 1 2 Cost 3 Salvage 4 Life (in years) 5 6 7 8 9 10 11 12 Year 1 2 3 4 5 B $440,000 $40,000 5 C January 1 book Depreciation value Expense $440,000 $264,000 $158,400 $95,040 $57,024 $176,000 $105,600 $63,360 $38,016 $17,024 D Accumulated Depreciation $176,000 $281,600 $344,960 $382,976 $400,000 E December 31 book value $264,000 $158,400 $95,040 $57,024 $40,000
Multiple Choice
O
O
=DB($B$2,$B$3,$B$4,48)
-DDB($B$2,$B$3,$B$4,A8)
DDB($B$2,$B$3,$B$4,$A$8)
-DDB($B$2,$B$3,$B$4,A$8)
Transcribed Image Text:Multiple Choice O O =DB($B$2,$B$3,$B$4,48) -DDB($B$2,$B$3,$B$4,A8) DDB($B$2,$B$3,$B$4,$A$8) -DDB($B$2,$B$3,$B$4,A$8)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Depreciation Accounting
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
Income Tax Fundamentals 2020
Income Tax Fundamentals 2020
Accounting
ISBN:
9780357391129
Author:
WHITTENBURG
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning