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

Similar Threads

Excel Templates for Compound Interest Loans 2
FV Function (Excel) 3
Excel - Wich Function should I use? 1
Variable interest rate loan calculations- PLEASE HELP!!! 1
Calculate Loan Term 1
credit intrest on intrest 1
Calculate Payment Days and Date 7
loan calculator with residual balance 1

Top