answersLogoWhite

0


Best Answer

Please explain more clearly

User Avatar

Wiki User

8y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

PMT

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What function in excel tells you how long it will take to payoff a loan?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Function takes rate payment and loan amount and outputs a monthly loan payment amount in excel?

The PMT function in Excel outputs a monthly loan payment amount.


What function in excel takes rate payment and loan amount and outputs a monthly loan payment amount?

The PMT function in Excel outputs a monthly loan payment amount.


Which Excel function calculates the principal portion of a loan payment?

The PPMT function.


How do you find the payoff balance on a personal loan?

How do you find the payoff balance on a personal loan?


Loan Payoff What is my loan payoff on a 2005 Chevrolet uplander?

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.


Does a buyer need to know what your payoff is?

Need payoff for a loan


What function calculates the number of periods required to pay off a loan or investment in excel?

The NPER() function.


Which Excel function would you use when you want to determine a monthly loan payment?

The PMT function.


How do i calculate loan payments?

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.


Where online can I find a loan payoff calculator?

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!


How can I get the payoff on my truck?

Call the loan company u went through and ask them for the payoff


What formulas can be used to correctly calculate your annual loan payments to Aunt Tillie for the car loan?

Use PMT function in the excel sheet.