142k views
4 votes
NPV/IRR. A new computer system will require an initial outlay of $20,000, but it will increase the firm's cash flows by $4,000 a year for each of the next eight years. (노 LOS-1) a. Is the system worth installing if the required rate of return is 9% ? b. What if the required return is 14% ? c. How high can the discount rate be before you would reject the project?

User Sean Ray
by
7.8k points

2 Answers

2 votes

Final answer:

The system is worth installing at a required rate of return of 9% but not at 14%. The discount rate can be as high as 13.71% before rejecting the project.

Step-by-step explanation:

To determine whether the computer system is worth installing, we need to calculate the net present value (NPV) and internal rate of return (IRR).

a) To calculate NPV at a required rate of return of 9%, we discount each year's cash flow by that rate and subtract the initial outlay. The NPV is positive ($8,749.71), indicating that the system is worth installing.

b) At a required return of 14%, the NPV is negative (-$776.58), so the system is not worth installing.

c) The discount rate can be as high as the IRR (13.71%) before rejecting the project.

User Keating
by
8.1k points
4 votes

a. Is the system worth installing if the required rate of return is 9%?

The system is worth installing at a required rate of return of 9%.

b. What if the required return is 14%?

Since the NPV is negative, the system is not worth installing at a required rate of return of 14%.

c. How high can the discount rate be before you would reject the project?

The IRR for this project is approximately 11.81%.

How to solve

The discount rate can be as high as 11.81% before the project would be rejected.

How to solve

a. Is the system worth installing if the required rate of return is 9%?

Using the NPV formula, we calculate the net present value (NPV) of the project at a discount rate of 9%:

NPV = -Initial Outlay + ∑ Discounted Cash Flows


NPV = -20,000 + (4,000 x (1 - (1 + 0.09)^-8)) / 0.09

NPV ≈ $13,077

Since the NPV is positive, the system is worth installing at a required rate of return of 9%.

b. What if the required return is 14%?

Using the NPV formula again, we calculate the NPV of the project at a discount rate of 14%:


NPV = -20,000 + (4,000 x (1 - (1 + 0.14)^-8)) / 0.14

NPV ≈ -$2,984

Since the NPV is negative, the system is not worth installing at a required rate of return of 14%.

c. How high can the discount rate be before you would reject the project?

The discount rate at which the NPV is zero is the internal rate of return (IRR). We can calculate the IRR using financial calculators or spreadsheet software. The IRR for this project is approximately 11.81%.

Therefore, the discount rate can be as high as 11.81% before the project would be rejected.

User Rob Fagen
by
7.3k points

Related questions

asked Jun 6, 2024 110k views
Don Gilbert asked Jun 6, 2024
by Don Gilbert
7.8k points
1 answer
4 votes
110k views
asked Jul 28, 2021 15.3k views
Dejohn asked Jul 28, 2021
by Dejohn
8.9k points
1 answer
0 votes
15.3k views