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]
3 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]3 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
Question is in the image below! please help!
iogann1982 [59]

Based on the discount offered by Next furniture, the discounted price of a sofa would be $669.33

<h3>What is the discounted price of the sofa?</h3>

This can be found as:

= Original price x (1 - discount rate)

Solving gives:

= 999 x (1 - 33%)

= 999 x 0.67

= $669.33

Find out more on discount rates at brainly.com/question/1385340.

#SPJ1

6 0
2 years ago
Mike and Lon came to a party together. A friend offered Mike a ride home. However, there was no room in the car for Lon. What ar
Vikentia [17]
Mike could leave lon behind, walk lon home, offer to pay for a taxi or finally he could stay with him.

3 0
3 years ago
According to the video, what are some qualities Air Traffic Controllers need? Check all that apply.
sweet-ann [11.9K]

Answer:

It would be B,C,D on edge

have a great dauyyyy!!!

Explanation:

7 0
3 years ago
Read 2 more answers
Getaway Travel Company reported net income for 2016 in the amount of $50,000. During 2016, Getaway declared and paid $2,000 in c
PSYCHO15rus [73]

Answer:

Option (B) is correct.

Explanation:

Given that,

Net income = 50,000

Preferred dividend = 2,000

Outstanding common stock:

= (40,000 × 2) + (10,000 × 6/12 × 2)

= 80,000 + 10,000

= 90,000

2016 basic earnings per share:

= (Net income - Preferred dividend) ÷ Outstanding common stock

= (50,000 - 2,000) ÷ 90,000

= 48,000 ÷ 90,000

= $0.53 per share

Therefore, the 2016 basic earnings per share is $0.53.

4 0
4 years ago
Adirondak Marketing Inc. manufactures two products, A and B. Presently, the company uses a single plantwide factory overhead rat
tamaranim1 [39]

Answer:

Predetermined manufacturing overhead rate= $14.77 per direct labor hour

Explanation:

Giving the following information:

Estimated overhead cost for the period= $325,000

Estimated total direct labor hours for the period= 22,000

<u>To calculate the predetermined manufacturing overhead rate we need to use the following formula:</u>

Predetermined manufacturing overhead rate= total estimated overhead costs for the period/ total amount of allocation base

Predetermined manufacturing overhead rate= 325,000 / 22,000

Predetermined manufacturing overhead rate= $14.77 per direct labor hour

8 0
3 years ago
Other questions:
  • The Federal Advisory Council of the Federal Reserve decides if any changes to the money supply are needed.
    6·1 answer
  • Eastview Company uses a perpetual LIFO inventory system, and has the following purchases and sales:
    9·1 answer
  • Ann wants to buy a building. The annual NOI for the building will be $165,000. She wants to get a 20 year interest only fixed ra
    14·1 answer
  • Dexter Industries purchased packaging equipment on January 8 for $98,000. The equipment was expected to have a useful life of th
    11·1 answer
  • You are 20 years old and have completed your BBA and want to pursue further education but you don’t want to make money from your
    9·1 answer
  • Wisconsin Bank lends Local Furniture Company $110,000 on November 1. Local Furniture Company signs a $110,000, 6%, 4-month note.
    8·1 answer
  • According to current data, most caterers with an active business have _______ full-time employees.
    7·1 answer
  • On 1/1//2015, XYZ leases a machine from Super LeaseCo for four years. At the end of the lease term, title passes to XYZ. Payment
    7·1 answer
  • What is the communication principle contained within this verse James 1:19?
    6·2 answers
  • One of the disadvatages of using historical returns to estimates the market risk premium is that the past may not be good guide
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!