Question

Warr Company is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC or negative, in both cases it will be rejected. Year 0 1 2 3 4 Cash flows -$1,300 $450 $450 $450 $450 14.16% 14.42% 15.31% 15.84% 16.23%

Answer 1

Answer:

Option B, IRR is 14.42%

Explanation:

The IRR is the rate of return that equates the cost of the project to the present value of cash flows receivable from the project in future.

Using an excel approach, the formula formula IRR is given as:

=irr(values)

The values in this case are

-$1300 in  year 0

$450 in year 1

$450 in year two

$450 in year 3

$450 in year 4

The irr gives 14.42% as shown in the spreadsheet attached

The cost of the investment of the investment project of $1300 equals the present values of its cash flows at 14.42% rate of return

Download xlsx