1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Amiraneli [1.4K]
2 years ago
5

A profitable company making earthmoving equipment is considering an investment of $150,000 on equipment that will have a 5 year

useful life and a $50,000 salvage value. Use a spreadsheet function to compute the MACRS depreciation schedule. Show the depreciation taken (=sum ()) as well as the PW of the depreciation charges discounted at the MARR%. If money is worth 10%m which one of the following three methods of depreciation would be preferable? (a) Straight line method), (b) double declining balance method, (c) MACRS method.
Business
1 answer:
Anuta_ua [19.1K]2 years ago
8 0

Answer:

Earthmoving Equipment Company

The preferable method of depreciation based on the Present Worth is:

(a) Straight line method

Explanation:

a) Data and Calculations:

Cost of equipment = $150,000

Estimated useful life = 5 years

Salvage value = $50,000

Depreciable amount = $100,000 ($150,000 - $50,000)

Annual Depreciation:

Straight-line method = $20,000 ($100,000/5)

Double-declining-balance method rate = 40% (100%/5 * 2)

Depreciation Schedules:

a) Straight line method

Year      Cost        Depreciation      Accumulated      Net Book Value

                                Expense          Depreciation  

Year 1  $150,000     $20,000             $20,000             $130,000

Year 2 $150,000     $20,000             $40,000              $110,000

Year 3 $150,000     $20,000             $60,000              $90,000

Year 4 $150,000     $20,000             $80,000              $70,000

Year 5 $150,000     $20,000           $100,000              $50,000

b) double declining balance method

Year      Cost        Depreciation      Accumulated      Net Book Value

                                Expense          Depreciation  

Year 1  $150,000    $60,000            $60,000              $90,000

Year 2 $150,000      36,000              96,000                 54,000

Year 3 $150,000       4,000              100,000                 50,000

Year 4 $150,000

Year 5 $150,000

c) MACRS method

Year      Cost        Depreciation      Accumulated      Net Book Value

                                Expense          Depreciation  

Year 1  $150,000    $30,000             $30,000              $120,000

Year 2 $150,000      48,000                78,000                  72,000

Year 3 $150,000      28,800              106,800                  43,200

Year 4 $150,000       17,280              124,080                  25,920

Year 5 $150,000      17,280                141,360                    8,640

Year 6 $150,000       8,640               150,000                    0

Discount rate (MARR) = 10%

PW of Straight-line Depreciation Charges:

PV annual factor = 3.791

PW = $75,820 ($20,000 * 3.791)

PW of Double-declining-balance:

Year 1 = $54,540 ($60,000 * .909)

Year 2 = $29,736 ($36,000 * .826)

Year 3 = $3,004 ($4,000 * .751)

PW =    $87,280

PW of MACRS:

Year 1 = $27,200 ($30,000 * .909)

Year 2 = $39,648 ($48,000 * .826)

Year 3 = $21,629 ($28,800 * .751)

Year 4 = $11,802 ($17,280 * .683)

Year 5 = $10,731 ($17,280 * .621)

Year 6 = $4,873 ($8,640 * .564)

PW =   $115,883

You might be interested in
What are products called that are special or different from those grown as commodities?
dybincka [34]

Answer:

unique prroducts

Explanation:

A product is a commodity when all units of production are identical, regardless of who produces them. However, to be a differentiated product, a company's product is different than those of its competitors. On the continuum between commodities and differentiated products are many degrees and combinations of the two.

6 0
3 years ago
Do you know why sustainable business is important?
guajiro [1.7K]

Answer:

In short, sustainability in business refers to the effect that companies have on the environment or society. A sustainable business strategy aims to positively impact one or both of those areas, thereby helping address some of the world's most pressing problems, such as climate change and income inequality.

Explanation:

yeah

8 0
3 years ago
In year 1000 a man named acholos nemroc celebrated him birthday, turning 100 years old, how old was he in -100?
Over [174]

Answer:

Okay

Explanation:

The answer is jjgxhkdyyffhohohugugojjhyfyffygihhhyghv28283939

3 0
2 years ago
Which work value is most likely to be important in a person's career choice?
matrenka [14]

Answer:

oD. being skilled at negotiating and bargaining with people

6 0
2 years ago
The mandala of jnanadakini shows what kind of balance?
Tems11 [23]

Answer:

radial

Explanation:

step by step explanation

8 0
2 years ago
Other questions:
  • The initial stage in the consumer purchase decision process involves perceiving a difference between a person's ideal and actual
    11·1 answer
  • Jean works for Fahrenheit Publishing which is a publisher of scientific journals. The company is dominated by low risk taking an
    9·1 answer
  • Which of the following tools is an example of monetary policy?
    8·2 answers
  • Bonita Industries reported the following year-end information: beginning work in process inventory, $190000; cost of goods manuf
    10·1 answer
  • Jane and Bart organized food truck business- Just Best Food Inc (JBF Inc.). JBF Inc. decided to follow accrual method of account
    13·1 answer
  • n e-mails, it is okay to send messages that are _____. a. Aggressive and mean-spirited in nature b. Filled with text abbreviatio
    13·1 answer
  • Aldo has just been audited by the IRS. He does not agree with the agent's findings but believes that he has only two choices: pa
    7·1 answer
  • Causes of low economic growth
    6·2 answers
  • which of the following agencies manages and deploys the Integrated Ballistic Identification System A. FTI B. FBI C. ATF D. DOJ
    10·1 answer
  • Analytic communicator
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!