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
On November 30, 2020, a U.S. company purchased merchandise on credit from a Swiss supplier at an invoice price of CHF1,000, when
Ivanshal [37]

Answer:

The merchandise should be reported on the U.S. Company's December 31, 2020 balance sheet at:

b. $1,050

Explanation:

a) Data and Calculations:

November 30, 2020 Inventory purchase = CHF1,000

Exchange rate on this date = $1.05/CHF

Inventory worth = $1.05 * CHF1,000 = $1,050

b) The inventory should be reported on December 31, 2020 at $1,050.  It does not need to be reported at a value above or below this.  Even, the debt owed to the Swiss supplier will be reported at this price.  It is when payment for the invoice is being made on February 1, 2021 that consideration will be given to the exchange rate at which payment is made.

5 0
3 years ago
The ____ adds up the money earned by producers plus taxes paid to the government
SCORPION-xisa [38]
Gross Income. Net income is after taxes have been deducted.
7 0
3 years ago
Read 2 more answers
If the Federal Reserve takes actions to raise interest rates in the economy, this will most likely affect which of these risks f
Kitty [74]

Answer:

1. A. Financial risk

2. B. 1.0

3.A. By multiplying the probability of each state of nature with its return and add them together

4. C. Simulation

5. F. Neither statement 1 or 2

Explanation:

When the Central banks takes action to increase interest rates in the economy, they do so by controlling money supply. This will have an impact on the financial risk facing businesses in the US.

All probabilities must always add up to 1 to show that the events are mutually exclusive.

When computing expected return, you add up the products of all the returns given a particular probability that a state of nature will occur.

By using a Simulation, one can combine multiple variables to find out how they can relate and what will happen if they do to be able to create a clearer picture of the future.

Both statements are wrong because firstly, there is no such thing as a guaranteed investment especially when it comes to stock. Secondly, Treasury bonds will not always exceed inflation rates.

8 0
3 years ago
In some cases, individuals who start a business have special voting rights that help them exercise
ASHA 777 [7]
I would say that having special voting rights would allow the individuals who start a business the ability to control the direction of the business and ensure it performs according to his/her expectations and succeeds in selling its products or services correctly so as to make a profit.
6 0
3 years ago
Newport Company has sales of $2,025,000 for the current year. The book value of its fixed assets at the beginning of the year wa
Tom [10]

Answer:

b) 3.0

Explanation:

It is ratio of sales to the fixed asset of a company. It shows that how effectively the company using its fixed assets to generate the revenue. It measures the efficiency of the fixed asset in making sales.

It uses the net sales value and the average net fixed assets of the company.

Net Sales =

Average Fixed Assets = ($800,000 + $550,000) / 2 = $1,350,000 / 2 = $675,000

Fixed Asset Turnover = Net Sales / Average Net Fixed Assets

Fixed Asset Turnover = 2,025,000 / $675,000 = 3 times

7 0
3 years ago
Other questions:
  • A partner's interest: a. is the same as the partnership property. b. cannot be attached by creditors. c. cannot be transferred.
    9·1 answer
  • Committee chair Bill led a discussion with the rest of his committee about a club matter, then called for a vote. Since the comm
    9·1 answer
  • When you take a multiple-choice test, you are relying on ________, a means of retrieving information out of your long-term memor
    10·2 answers
  • 1. Which of the following accurately explains why scarcity forces individuals and society to incur opportunity costs? A. Because
    8·1 answer
  • B
    10·1 answer
  • What is the relationship between financial system and economy
    10·2 answers
  • Marginal cost is equal to average total cost when a. average variable cost is falling. b. marginal cost is at its minimum. c. av
    11·1 answer
  • A homebuyer took out a $350,000 30-year fixed rate loan at 4.5% interest with a monthly payment of $1,773.40. After making two m
    15·1 answer
  • 79% of employees believe that it is important to have what in the workplace?
    6·1 answer
  • Which of the following statements would be
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!