Hi

Excel has a function that calculates loan payments. Is there a similar
function to calculate loan payments with a residual payment at the end
of the loan period ? If not, anyone knows what is the applicable
formula ?

Thanks/Brgds
Joao