Loan calculator with residual amount

  • Thread starter Thread starter JJ
  • Start date Start date
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
 
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
APR calculation for Mortgages with a balloon payment. 6
Calculate Loan Term 1
Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options 2
calculate balance given varying payments? 1
loan calculator with residual balance 1

Back
Top