Question

In: Accounting

35. Net Present Value Analysis. Wood Products Company would like to purchase a omputerized wood lathe...

35. Net Present Value Analysis. Wood Products Company would like to purchase a omputerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The company’s required rate of return is 15 percent.

Required:

a. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.

b. Find the net present value of this investment using the format presented in.

Round to the nearest dollar.

c. Should the company purchase the wood lathe? Explain. Internal Rate of Return Analysis. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The company’s required rate of return is 15 percent (this is the same data as the previous exercise).

Solutions

Expert Solution

Req a. Cash inflows and outflows
Year Cash Flows
0 -100000 Initial investment
1 25000 Annual cash receipts less Annual maintenance cost
2 25000 Annual cash receipts less Annual maintenance cost
3 25000 Annual cash receipts less Annual maintenance cost
4 25000 Annual cash receipts less Annual maintenance cost
5 30000 Annual cash receipts less Annual maintenance cost + salvage value
Req b:
Year cashflows PVF @ 15% Present value
0 -100000 1 -100000
1 25000 0.869565 21739.13
2 25000 0.756144 18903.59
3 25000 0.657516 16437.91
4 25000 0.571753 14293.83
5 30000 0.497177 14915.3
Net present value -13710
Req C: No Company should not purchasse the machine, as the NPV of machine is (13710)
IRR:
NPV at 15% = ($13710)
NPV at 9%
Year cashflows PVF @ 9% Present value
0 -100000 1 -100000
1 25000 0.917431 22935.78
2 25000 0.84168 21042
3 25000 0.772183 19304.59
4 25000 0.708425 17710.63
5 30000 0.649931 19497.94
Net present value 491
IRR = Lower rate + (NOV at lower rate/ Difference in NOV) * Difference in Rates
9% + ( 491 / 14201)*6% = 9.21%

Related Solutions

35. Net Present Value Analysis. Wood Products Company would like to purchase a computerized wood lathe...
35. Net Present Value Analysis. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual net cash receipts resulting from this machine are predicted to be $45,000. The company’s required rate of return is 15 percent. Required: a. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from...
Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is...
Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000. Annual maintenance costs will total $20,000. Annual cash receipts resulting from this machine are predicted to be $45,000. The company’s required rate of return is 15 percent. Use Excel to calculate the net present value. (7.2) Use Excel to calculate the internal rate of return. (7.3) Based on your answer...
Problem 13-22 Net Present Value Analysis [LO13-2] The Sweetwater Candy Company would like to buy a...
Problem 13-22 Net Present Value Analysis [LO13-2] The Sweetwater Candy Company would like to buy a new machine that would automatically “dip” chocolates. The dipping operation currently is done largely by hand. The machine the company is considering costs $190,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the third year. These parts would cost $11,100, including installation. After five years, the machine...
Net Present Value Analysis Champion Company is considering a contract that would require an expansion of...
Net Present Value Analysis Champion Company is considering a contract that would require an expansion of its food processing capabilities. The contract covers five years. To provide the required products, Champion would have to purchase additional equipment for $80,000. Champion estimates the contract will provide annual net cash inflows (before taxes) of $35,000. For tax purposes, the equipment will be depreciated as follows: Year 1 $10,000 Year 2 20,000 Year 3 20,000 Year 4 20,000 Year 5 10,000 Although salvage...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $825,458 $525,954 $275,147 Annual net cash flows: Year 1 402,000 293,000 189,000 Year 2 374,000 264,000 130,000 Year 3 342,000 234,000 95,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $850,858 $518,264 $279,888 Annual net cash flows: Year 1 387,000 267,000 182,000 Year 2 360,000 240,000 126,000 Year 3 329,000 214,000 91,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $823,063 $515,770 $260,629 Annual net cash flows: Year 1 397,000 290,000 187,000 Year 2 369,000 261,000 129,000 Year 3 337,000 232,000 94,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $879,923 $581,375 $297,693 Annual net cash flows: Year 1 442,000 318,000 208,000 Year 2 411,000 286,000 144,000 Year 3 376,000 254,000 104,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $720,998 $429,044 $230,090 Annual net cash flows: Year 1 321,000 225,000 151,000 Year 2 299,000 203,000 104,000 Year 3 273,000 180,000 76,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $706,350 $461,534 $233,498 Annual net cash flows: Year 1 318,000 229,000 149,000 Year 2 296,000 206,000 103,000 Year 3 270,000 183,000 75,000 Present Value of $1 at Compound Interest Year 6%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT