CUMIPMT assumes a fully amortizing loan.
if there is a residual value you need to add an interest only calculation on
the residual to the CUMIPMT calculation

"zardozoz" wrote:

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?