NPV helps determine whether a proposed project will add value, i.e., generate a profit. As such it ... equals the return of capital. The Excel formula for calculating the discount rate is ...