which has a built-in function to determine a project's IRR. When calculating IRR, you're solving for an NPV of zero. You'll then need the number of years you plan to hold the investment (N), as ...