Loan calculator with residual amount

J

JJ

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
 
T

Tom Ogilvy

Use the same function (PMT)

the fourth argument is the FV. Put the residual payment in as a negative
number for the Future Value of the Loan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top