Question

In: Finance

Net Present Value: The Lees are considering adding a new piece of equipment that will speed...

Net Present Value: The Lees are considering adding a new piece of equipment that will speed up the process of building the bobbleheads. The cost of the piece of equipment is $42000. It is expected that the new piece of equipment will lead to cash flows of $17000, $29000, and $40000 over the next 3 years. If the appropriate discount rate is 12%, what is the NPV of this investment? Explain the findings.

I need the excel answer please.

Solutions

Expert Solution

NPV= $24,768.40

Calculation in Excel is given below as screenshot:

While using Excel for calculating NPV, first period cash flow should be added to the result of the Excel function of NPV wherein the values of 2nd period onwards shall be given.


Related Solutions

Net Present Value Method and Present Value Index MVP Sports Equipment Company is considering an investment...
Net Present Value Method and Present Value Index MVP Sports Equipment Company is considering an investment in one of two machines. The sewing machine will increase productivity from sewing 150 baseballs per hour to sewing 270 per hour. The contribution margin is $0.52 per baseball. Assume that any increased production of baseballs can be sold. The second machine is an automatic packing machine for the golf ball line. The packing machine will reduce packing labor cost. The labor cost saved...
You are considering leasing a piece of equipment. Compute the Present Value of Leasing Costs (after...
You are considering leasing a piece of equipment. Compute the Present Value of Leasing Costs (after taxes). The details of the lease are as follows: Annual Lease Payments = $12,400 (due at Beginning of Year) Lease Term = 5 Years Corporate Tax Rate = 30% Present Value Discount Rate = 7% a) -54,401 b) -15,253 c) -48,297 d) -35,590 e) -39,149
TA, Inc. is considering replacing a piece of old equipment with a piece of new equipment....
TA, Inc. is considering replacing a piece of old equipment with a piece of new equipment. Details for both are given below: Old Equipment New Equipment Current book value $1,500,000 Current market value $2,500,000 Acquisition cost $6,200,000 Remaining life 10 years Life 10 years Annual sales $350,000 Annual sales $850,000 Cash operating expenses $140,000 Cash operating expenses $500,000 Annual depreciation $150,000 Annual depreciation $620,000 Accounting salvage value $0 Accounting salvage value $0 Expected salvage value after 10 years $240,000 Expected...
TA, Inc. is considering replacing a piece of old equipment with a piece of new equipment....
TA, Inc. is considering replacing a piece of old equipment with a piece of new equipment. Details for both are given below: Old Equipment New Equipment Current book value $1,800,000 Current market value $2,500,000 Acquisition cost $6,200,000 Remaining life 10 years Life 10 years Annual sales $350,000 Annual sales $850,000 Cash operating expenses $140,000 Cash operating expenses $500,000 Annual depreciation $180,000 Annual depreciation $620,000 Accounting salvage value $0 Accounting salvage value $0 Expected salvage value $240,000 Expected salvage value $750,000...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment would result in an annual increase in net income of $200000. the equipment will have an initial cost of $1200000 and have an 8 year life. the salvage value of the equipment is estimated to be $200000. the hurdle rate is 10%. what is accounting rate of return? b) what is the payback period? c) what is the net present value? d) what would...
You are considering the acquisition of a new piece of equipment with a useful life of...
You are considering the acquisition of a new piece of equipment with a useful life of five years. This new technology will make your clinical operation more efficient and allow for a reduction of 10 FTEs. The equipment purchase price is $4,500,000 plus 10% installation fee. The purchase price includes service for the first year, an item that has an annual cost of $10,000. There is a potential for additional volume of 150,000 units in the first year, growing by...
You are considering the acquisition of a new piece of equipment with a useful life of...
You are considering the acquisition of a new piece of equipment with a useful life of five years. This new technology will make your clinical operation more efficient and allow for a reduction of 10 FTEs. The equipment purchase price is $4,500,000 plus 10% installation fee. The purchase price includes service for the first year, an item that has an annual cost of $10,000. There is a potential for additional volume of 150,000 units in the first year, growing by...
Blossom Corp. is considering the purchase of a piece of equipment that costs $30000. Projected net...
Blossom Corp. is considering the purchase of a piece of equipment that costs $30000. Projected net annual cash flows over the project’s life are: Year Net Annual Cash Flow 1 $8000 2 15000 3 25000 4 9000 The cash payback period is
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment in one of two machines. The sewing machine will increase productivity from sewing 150 baseballs per hour to sewing 270 per hour. The contribution margin per unit is $0.42 per baseball. Assume that any increased production of baseballs can be sold. The second machine is an automatic packing machine for the golf ball line. The packing machine will reduce packing labor cost. The labor...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment in one of two machines. The sewing machine will increase productivity from sewing 180 baseballs per hour to sewing 324 per hour. The contribution margin per unit is $0.46 per baseball. Assume that any increased production of baseballs can be sold. The second machine is an automatic packing machine for the golf ball line. The packing machine will reduce packing labor cost. The labor...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT