A project has an initial outlay of $1,939. It has a single cash flow at the end of year 5 of $4,276. What is the internal rate of return (IRR) for the project?

Round the answer to two decimal places in percentage form.

(1) Enter the 6 numbers 1939, 0, 0, 0,0, -4276 into 6 consecutive cells in the worksheet, say C1:C6

(2) Enter the following formula in another cell: =IRR(C1:C6, 10%) The result will be the answer (17%). The 10% is just an initial guess - it could be anything like 80% or 50% and it'll work.