impt and cumimpt with a residual
 

I have been trying to create a monthly loan/lease calculation where there is
a residual at the end of a 5 year term. I am happy with each month (using
IPMT), but when tried to use CUMIPMT do make a compact form rather than 60
lines, the term involving residual (ie future value) is missing and the total
calc does not equal the sum of each month. Any leads?