You know the same details with an IRR, and you can solve for the NPV expressed as a percentage return ... return of capital. The Excel formula for calculating the discount rate is =RATE (nper ...