The code works great, however, I don't understand how the residuals are calculated.  In the statement below why the residual is not the sum of the discounted cash flows:

SELECT @nResidual...