Question
In: Accounting
2. LEAF Company is considering the purchase of new computer equipment that will increase efficiencies within...
2. LEAF Company is considering the purchase of new computer equipment that will increase efficiencies within its hospital floors. The following estimates are available: Initial Outlay $1,000,000 Annual reduction in fixed costs $175,000 Cost of capital 10% Estimated life of computer equipment 5 years Estimated residual value of equipment $25,000 Determine the net present value of the computer equipment purchase
Solutions
Expert Solution
| Ref | Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| a | Annual operating cash flows | $ 175,000 | $ 175,000 | $ 175,000 | $ 175,000 | $ 200,000 | |
| b | Present value factor@ 10.000% | 0.909090909 | 0.826446281 | 0.751314801 | 0.683013455 | 0.620921323 | |
| c= a*b | Present value of annual cashflows | $ 159,090.91 | $ 144,628.10 | $131,480.09 | $119,527.35 | $124,184.26 | |
| Total present value of annual cash inflows | $ 678,910.72 | ||||||
| Less: investment | $ (1,000,000.00) | ||||||
| NPV | $ (321,089.28) |
NPV is negative
NPV is (321,089.28)
Please rate.
ekkarill92 answered 2 years agoRelated Solutions
A company is considering purchasing new equipment. The purchase of the equipment is expected to...
A company is considering purchasing new equipment. The purchase
of the equipment is
expected to generate after tax
savings of $12,600 each year for 8 years. The company can
borrow money at 6%. Assume annual
compounding.
Determine the present value of
the future cash inflows.
Hint: the $12,600 are your annuity payments
A company is considering the purchase of a new machine that will enable it to increase...
A company is considering the purchase of a new machine that will
enable it to increase its expected sales. The machine will have a
price of $100,000. In addition, the machine must be installed and
tested. The costs of installation and testing will amount to
$10,000. The machine will be depreciated using 3-years MACRS. (Use
MACRS table from class excel exercise by copying the table and
pasting it) The equipment will be operated for 5 years. The sales
in the...
2. The company is considering a project involving the purchase of new equipment. Change the data...
2. The company is considering a project involving the purchase
of new equipment. Change the data area of your worksheet to match
the following:
A
B
C
1
Chapter 8: Applying Excel
2
3
Data
4
Example E
5
Cost of
equipment needed
$160,000
6
Working
capital needed
$60,000
7
Overhaul of equipment in four years
$5,000
8
Salvage
value of the equipment in
$40,000
9
Annual
revenues and costs:
10
Sales revenues
$370,000
11
Cost of goods sold
$255,000...
2. The company is considering a project involving the purchase of new equipment. Change the data...
2. The company is considering a project involving the purchase
of new equipment. Change the data area of your worksheet to match
the following: Use Exhibit 12B-1 and Exhibit 12B-2. (Use
appropriate factor(s) from the tables provided.)
1
2
3
4
5
6
7
8
9
10
11
12
13
Chapter 12: Applying Excel
Data
Example E
Cost of equipment needed
$260,000
Working capital needed
$60,000
Overhaul of equipment in four
years
$20,000
Salvage value of the equipment in five...
Software Inc. is considering the purchase of new computer equipment totaling $150,000 with an estimated salvage...
Software Inc. is considering the purchase of new computer
equipment totaling $150,000 with an estimated salvage value of
$25,000 after three years. Maintenance, repairs, supplies, and
other operating costs are estimated to be $13,000 per year.
Determine the following:
The annual cost based on the depreciation.
The annual cost using a desired ROI of 15%.
If the funds to purchase the equipment are borrowed at a rate
of 8% for three years, what is the effect on the annual costs?...
Sinclair Company* A. EQUIPMENT REPLACEMENT Sinclair Company is considering the purchase of new equipment to perform...
Sinclair Company* A. EQUIPMENT REPLACEMENT
Sinclair Company is considering the purchase of new equipment to
perform operations currently being performed on different, less
efficient equipment. The purchase price is $250,000, delivered and
installed. A Sinclair production engineer estimates that the new
equipment will produce savings of $72,000 in labor and other direct
costs annually, as compared with the present equipment. She
estimates the proposed equipment’s economic life at five years,
with zero salvage value. The present equipment is in good...
A company is considering the purchase of new equipment for its production area. The equipment has...
A company is considering the purchase of new equipment for its
production area. The equipment has an initial cost of $ 3,000 with
operation and maintenance costs, as well as the market liquidation
value as shown in the following table:
Year
Costs of operation
Rescue value
1
$1,000
$1,500
2
$1,700
$1,000
3
$2,400
$500
4
$3,100
$0
Determine the Optimal Economic Life of this investment, if the
MARR of the company is 12%
Eggz, Inc., is considering the purchase of new equipment that will allow the company to collect...
Eggz, Inc., is considering the purchase of new equipment that
will allow the company to collect loose hen feathers for sale. The
equipment will cost $425,000 and will be eligible for 100 percent
bonus depreciation. The equipment can be sold for $25,000 at the
end of the project in 5 years. Sales would be $275,000 per year,
with annual fixed costs of $47,000 and variable costs equal to 35
percent of sales. The project would require an investment of
$25,000...
Eggz, Inc., is considering the purchase of new equipment that will allow the company to collect...
Eggz, Inc., is considering the purchase of new equipment that
will allow the company to collect loose hen feathers for sale. The
equipment will cost $440,000 and will be eligible for 100 percent
bonus depreciation. The equipment can be sold for $54,000 at the
end of the project in 5 years. Sales would be $287,000 per year,
with annual fixed costs of $50,000 and variable costs equal to 37
percent of sales. The project would require an investment of
$31,000...
Eggz, Inc., is considering the purchase of new equipment that will allow the company to collect...
Eggz, Inc., is considering the purchase of new equipment that
will allow the company to collect loose hen feathers for sale. The
equipment will cost $490,000 and will be eligible for 100 percent
bonus depreciation. The equipment can be sold for $84,000 at the
end of the project in 5 years. Sales would be $327,000 per year,
with annual fixed costs of $60,000 and variable costs equal to 35
percent of sales. The project would require an investment of
$51,000...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1. write SQL statements to create the following two tables: a) Department table that contains the...
- What is "intersectionality", and why is this a relevant concept in anthropology? Use examples in your...
- What are the differences between the economic theories and the reality of policy implementation?
- Designing A New Arena : You work for a company that has been tasked with designing...
- HOW DO YOU THINK HUMANS CAME TO HAVE LANGUAGE? WHAT IS THE DIFFERENCE BETWEEN HUMAN LANGUAGE...
- Gasoline is primarily a mixture of hydrocarbons and is sold with an octane rating that is...
- a) The electric potential at a position located a distance of 21.9 mm from a positive...
ADVERTISEMENT