Please explain more clearly
PMT
The PMT function in Excel outputs a monthly loan payment amount.
The PMT function in Excel outputs a monthly loan payment amount.
The PPMT function.
How do you find the payoff balance on a personal loan?
How can you possibly expect there to be one answer for a question such as this! First and formost, ask your lender. They ALWAYS know what the loan payoff is.
Need payoff for a loan
The NPER() function.
The PMT function.
Cut & pase this link into your browser: http://rws.rwstools.com/templateroot/Calculators.asp?PVLID=26316 Or you can do it the hard way: payment = Balance*(int/(1-(1/(1+int)^term))) Balance = the balance of the loan int = the interest rate divided by 1200 term = the number of years to payoff the loan times 12 Also, if you have Microsoft Excel, there is a function that calculates loan payments.
You can go to the site calculator.bankrate.com. It will show you a free loan payoff calculator on their site and you can use it. Just type in your loan information and do it!
Call the loan company u went through and ask them for the payoff
Use PMT function in the excel sheet.