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
The stock price of Baskett Co. is $53.40. Investors require a return of 12 percent on similar stocks. If the company plans to pa
Gemiola [76]

Answer:

Growth Rate = 5.73%

Explanation:

The present value of stock formula can be used here to solve this problem.

The formula is:

P_0=\frac{Div_1}{r-g}

Where

P_0  is the current stock price

Div_1  is the dividend to be paid next year

r is the rate of return required

g is the growth rate expected

Now, the first 3 variables are given, we need to find g. Substituting, we find our answer:

P_0=\frac{Div_1}{r-g}\\53.40=\frac{3.35}{0.12-g}\\53.40(0.12-g)=3.35\\6.408-53.40g=3.35\\53.40g=3.058\\g=0.0573\\

In percentage, it is

<u>Growth Rate = 5.73%</u>

7 0
3 years ago
What does the IS curve​ show? A. It shows equilibrium points in the goods marketlong dashthe combinations of the real interest r
Mariana [72]

Answer:

Option (A) is correct.

Explanation:

Investment spending curve refers to the curve shows various combination of real interest rate and the equilibrium output. There is a negative relationship between the real interest rate and output which means that an increase in the real interest rate will reduce the output of an economy and if there is a fall in the real interest rate then as a result there is an increase in the output.

7 0
3 years ago
Meadow Company produces hand tools. A sales budget for the next four months is as follows: March 10,800 units, April 13,300, May
elixir [45]

Answer:

Production= 11,300 units

Explanation:

Giving the following information:

Sales:

March 10,800 units

April 13,300

Meadow Company’s ending finished goods inventory policy is 20% of the following month’s sales.

March 1 beginning inventory is projected to be 2,160 units.

<u>To calculate the production for March, we need to use the following formula</u>:

Production= sales + desired ending inventory - beginning inventory

Production= 10,800 + (13,300*0.2) - 2,160

Production= 11,300 units

8 0
3 years ago
If you own 15 comma 000 shares of stock of Nike and it pays a dividend of $ 0.21 per​ share, then what is the total dividend you
DanielleElmas [232]

Answer:

$3,150

Explanation:

Data provided in the question

Number of shares owned = 15,000 shares

Dividend per share = $0.21

So, the total dividend received is

= Number of shares owned × Dividend per share

= 15,000 shares × $0.21 per share

= $3,150

We simply multiplied the number of shares owed with the dividend per share so that the total dividend could come

8 0
2 years ago
Suppose that when the Fed decreases the money​ supply, households and firms initially hold less money than they want​ to, relati
solmaris [256]

Answer:

The correct answer is A

Explanation:

When Fed decreases the money supply in the market, then there prevails the shortage of the money at the prevailing rate of interest. So, the interest rate need to be increased in order to dissuade people from holding the money. Therefore, the households and the firms will sell the treasury bills and other kind of financial assets by decreasing the prices and which lead to increase in the interest rate.

3 0
3 years ago
Other questions:
  • Consumer surplus
    14·1 answer
  • Some part of income inequality is likely to be the result of discrimination. But other factors responsible for inequality includ
    6·1 answer
  • The total number of items that the company carries within its product lines refers to the ___________ of the product mix.
    9·1 answer
  • Your grandmother has promised to give you $5,000 when you graduate from college. She is expecting you to graduate two years from
    8·1 answer
  • Many cities in southeast Michigan are struggling with financial problems due to current economic conditions. At the same time, s
    5·1 answer
  • EBay A. is a market because buyers and sellers are brought together to buy and sell. B. cannot function as a market. C. would be
    13·1 answer
  • Bubbles Inc. produces gummy bears. The company purchases raw materials, stores them in warehouse, and then runs them through two
    5·1 answer
  • What happens when the federal reserve decreases the money supply?
    7·1 answer
  • What are the kitchen tools and equipment needed to cook pancake.​
    9·1 answer
  • Given a fixed supply of money and a downward sloping aggregate demand curve, an increase in money demand will ________ the price
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!