Reviewed by Thomas J. Catalano Fact checked by Vikki Velasquez The discount rate refers to the interest rate used when ...

Internal rate of return (IRR) is one of several well ... In most cases, investors use an IRR calculator or an Excel spreadsheet, which has a built-in function to determine a project's IRR.

The NPV is zero if the discount rate equals the IRR. The project will break even and have an NPV of zero if the cost of capital equals the return of capital. The Excel formula for calculating the ...