Consider the following cash flows that switch signs: IRR or NPV at 11%

Business FinanceCapital Budgeting

The question

Consider the following cash flows:

YearCash Flows
0-$14,000
17,000
2-1,500
39,800
4-2,000
58,500

a) Compute the IRR of this project. If the company requires a 10% rate of return on its capital investment projects, should this project be accepted? Should you use IRR to make your decision?

b) Is this project is acceptable? What method should you use?

Below is the Accuity problem: the same method with different numbers. We solve ours, so work through it and you'll know how to solve yours.

The Accuity problem

GreenField Solutions is evaluating a project with these cash flows:

YearCash Flows
0(15,500)
17,500
2(1,800)
310,500
4(2,300)
59,000
  1. Compute the project's IRR. If GreenField requires an 11% return on its capital investments, should the project be accepted? Should IRR be used to make this decision?
  2. Is the project acceptable, and which method should GreenField use to decide?

An Accuity original. We write our own version of each problem and solve it from scratch, so you learn the method rather than copying an answer.

Video solution

Covers the full step-by-step solution below, start to finish.

Jake Glidden, CPA, MSA

Solved by

Jake Glidden, CPA, MSA

Founder of Accuity

Jake started Accuity while studying accounting at UCF and has worked with hundreds of students in introductory and upper-level accounting classes. Accuity solutions are checked against the textbook before they're published.

Certified Public Accountant (CPA) · B.S.B.A. in Accounting, UCF · M.S. in Accounting, UCF

More about Accuity →

Step-by-step solution

The same steps the video works through, written out.

This problem tests IRR with non-conventional cash flows. A conventional project has one outflow followed by inflows (one sign change). This project flips between negative and positive four times, which can produce more than one IRR or none at all.

Requirement 1: IRR and the IRR decision

HP 10BII+:

  1. [shift] [C ALL], 1 [shift] [P/YR]
  2. 15500 [+/-] [CFj]
  3. 7500 [CFj]
  4. 1800 [+/-] [CFj]
  5. 10500 [CFj]
  6. 2300 [+/-] [CFj]
  7. 9000 [CFj]
  8. [shift] [IRR/YR] → 14.25

The IRR of 14.25% is above the 11% required return, so the IRR rule says accept.

But IRR should not be relied on here. With four sign changes, the NPV equation can have up to four solutions. When more than one IRR is possible, no single IRR can be compared to the hurdle rate with confidence. You have to check the NPV profile.

Discount rateNPV
0%$7,400
5%$4,240
10%$1,737
11%$1,299
15%($276)
20%($1,916)

NPV falls steadily and crosses zero only once, near 14.25%, so in this case there is just one IRR and it gives the right answer. That was not guaranteed in advance.

Answer 1: the IRR is about 14.25%, which exceeds 11%, so IRR says accept. IRR should not be the decision tool, because the cash flows change sign more than once.

Requirement 2: Use NPV

YearCash flowPV at 11%
0(15,500)(15,500.00)
17,5006,756.76
2(1,800)(1,460.92)
310,5007,677.51
4(2,300)(1,515.08)
59,0005,341.06
NPV1,299.33

On the calculator, after entering the cash flows: 11 [I/YR], [shift] [NPV] → 1,299.33.

MIRR gives the same answer and always has a single solution. Discount the outflows to year 0 at 11% ($18,476.00) and compound the inflows to year 5 at 11% ($33,322.58):

MIRR = ($33,322.58 ÷ $18,476.00)^(1/5) − 1 = 12.52%, which is above 11%.

Answer 2: the project is acceptable. Use NPV: it is $1,299.33 at 11%, so accept (MIRR of 12.52% agrees).

Mistakes to avoid

  • Entering the year 2 and year 4 amounts as positive. They are outflows.
  • Trusting the IRR without checking for multiple solutions when signs alternate.
  • Grouping repeated amounts with Nj when they are not consecutive.

More Capital Budgeting problems

Got a different wording of this problem?

Assignments vary by school and semester. Share the version you were given and we'll add it so other students can find this solution.

Studying Capital Budgeting for a class?

Accuity courses map to your actual syllabus — video lessons, exam-style practice, and walkthroughs for the problems you're assigned.

Ace your accounting classes.

Textbook questions are for reference. We show a textbook's question only so you can find the problem you were assigned. We don't solve textbook questions: every solution and video on this site works through our own Accuity problem, written to teach the same method with different numbers.

Educational use. Accuity problems are original teaching material — we write our own version of each problem and solve it on video so you learn the method. Don't submit our work as your own; that violates your school's academic integrity policy. If you believe content here infringes your rights, file a DMCA notice.