Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. use excel and show formulas please you are getting

Use Excel and show formulas please You are getting paid lots of money to determine the...

Free

70.2K

Verified Solution

Question

Finance

Use Excel and show formulas please You aregetting paid lots of money to determine the best depreciationmethod for a piece of equipment that costs $50,000 and has a zerosalvage value at the end of a 10-year depreciable life. Compute thedepreciation schedules for each of the following methods:

a) straight line depreciation
b) double declining balance depreciation (DDB)
c) 100% bonus depreciation
d) MACRS

Answer & Explanation Solved by verified expert
4.2 Ratings (829 Votes)

a. Straight line = 50,000/10 = 5000 per year for 10 years

b. Double declining = 1/useful life * 2 = 1/10 * 2 = 20%

Year Cost Depreciation rate Depreciation Accumulated depreciation Book Value
1 $ 50,000.00 20% $    10,000.00 $                                10,000.00 $ 40,000.00
2 $ 40,000.00 20% $      8,000.00 $                                18,000.00 $ 32,000.00
3 $ 32,000.00 20% $      6,400.00 $                                24,400.00 $ 25,600.00
4 $ 25,600.00 20% $      5,120.00 $                                29,520.00 $ 20,480.00
5 $ 20,480.00 20% $      4,096.00 $                                33,616.00 $ 16,384.00
6 $ 16,384.00 20% $      3,276.80 $                                36,892.80 $ 13,107.20
7 $ 13,107.20 20% $      2,621.44 $                                39,514.24 $ 10,485.76
8 $ 10,485.76 20% $      2,097.15 $                                41,611.39 $   8,388.61
9 $   8,388.61 20% $      1,677.72 $                                43,289.11 $   6,710.89
10 $   6,710.89 20% $      1,342.18 $                                44,631.29 $   5,368.71

d) Modified Accelerated Cost recovery system-

Percentages for MACRS depreciation taken from the 7-year class personal property table-

Year MACRS
1 14.29% ($50,000) =$7,145
2 24.49%($50,000) =$12,245
3 17.49%($50,000) =$8,745
4 12.49%($50,000) =$6,245
5 8.93%($50,000) =$4,465
6 8.92%($50,000) =$4,460
7 8.93%($50,000) =$4,465
8 4.46%($50,000) =$2,230
9. 0

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Use Excel and show formulas please You aregetting paid lots of money to determine the best depreciationmethod for a piece of equipment that costs $50,000 and has a zerosalvage value at the end of a 10-year depreciable life. Compute thedepreciation schedules for each of the following methods:a) straight line depreciationb) double declining balance depreciation (DDB)c) 100% bonus depreciationd) MACRS

Other questions asked by students

Q

P 19–12 EPS; nonconvertible preferred stock; treasury shares;shares sold; stock dividend; options LO19–4 through...

Accounting
Q

A health study tracked a group of persons for five years. At the beginning of the...

Statistics
Q

Should we abandon copyright on internet or does in serve its purpose ?

Programming
Q

. (a)      Is it possible for the temperature of a substance to rise without heat flowing...

Physics
Q

5.?Calculate the WAAC with the following information: ??Equity Information????Debt Information ??10,000 shares????$200,000 in outstanding debt ?????????(face value) ??$60 per...

Finance
Q

Suppose the function f(t) = 55000e0.061t gives the number of subscribers to a particular YouTube...

Algebra
Q

Let f(x) = 3.3x + 8x - 162x7x + 3--1) The domain in interval notation...

Algebra
Q

f. Inventory turnover is cost of sales divided by average inventory. Cost of sales...

Accounting
Q

[The following information applies to the questions displayed below.] As of December 31 of the...

Accounting
Q

Tanto las NIIF como los PCGA exigen la divulgacin de a. polticas contables seguidas. b....

Accounting
Q

Which of the following is true of the assumption of a perfectly competitive labor market?...

Accounting
Q

A stock has an expected return of 13.89 percent. The beta of the stock is...

Finance