The discount rate is the interest rate used to calculate ... 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 ...