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
 
G

Guest

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

Similar Threads

CUMIPMT 0
Creating an update query that uses multiple parameters 2
Help to create amortization schedule 0
loan calculator with residual balance 1
APR calculation for Mortgages with a balloon payment. 6
Loan calculator with extra payments 2
Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options 2
Loan Amortization in a cell 5

Top