Question

Initial investment $150,000 Required rate of return 10% Required: (a) Compute the net present value of this investment. Period Net Cash Flows Present Value of Net Cash Flows 1 $10,000 ($706,773) 2 25,000 3 50,000 4 37,500 5 100,000 Totals $222,500 Initial investment Net present value Verify the value of cell C18 using the NPV function (b) Should the machinery be purchased?

          Initial investment $150,000
Required rate of return 10%

Required:
(a) Compute the net present value of this investment.

Period Net Cash Flows Present Value of Net Cash Flows
1 $10,000 ($706,773)
2 25,000
3 50,000
4 37,500
5 100,000
Totals $222,500
Initial investment
Net present value

Verify the value of cell C18 using the NPV function

(b) Should the machinery be purchased?

Initial investment 150,000
Required rate of return 10%

Required:
(a) Compute the net present value of this investment.

Period Net Cash Flows Present Value of Net Cash Flows
110,000 (706,773)
2 25,000
3 50,000
4 37,500
5 100,000
Totals222,500
Initial investment
Net present value

Verify the value of cell C18 using the NPV function

(b) Should the machinery be purchased?

Added by Dylan J.

Horngren’s Cost Accounting

Srikant M. Datar, Madhav V. Rajan 16th Edition

Instant Answer

Solved by Expert Akash M

07/25/2023

Step 1

To calculate the present value of each net cash flow, we need to discount each cash flow by the required rate of return (10%). The formula to calculate the present value is: Present Value = Net Cash Flow / (1 + Required Rate of Return)^Period Using this Show more…

Show all steps

Thanks for your feedback!

A company is considering a $150,000 investment in machinery with the following net cash flows. The company requires a 10% return on its investments. Required: (a) Compute the net present value of this investment. Period Net Cash Flows Present Value of Net Cash Flows 1 $10,000 ($706,773) 2 25,000 3 50,000 4 37,500 5 100,000 Totals $222,500 Initial investment Net present value Verify the value of cell C18 using the NPV function (b) Should the machinery be purchased?