0
It depends on the kind of payment. There are a number of functions to check out. PMT, PPMT, IPMT and ISPMT. They are used for different kinds of payment.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
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.
Where could I find an amortization calculator for excel?
You may find an amortization calculator for excel at http://office.microsoft.com/en-us/excel-help/using-the-loan-amortization-and-loan-analysis-templates-HA001034640.aspx.
Which menu contains the Find and Replace commands when using Excel?
The Edit menu.
Where can I find the option for using a data pivot table in Excel?
In versions up to Excel 2003, it is on the Data menu. From version 2007 onwards, you can find it on the Insert tab on the ribbon.
Can I get a payment plan to help with excel lessons?
There are some free excel lessons that you can find online! Try these out, and if you are still interested in taking them in the library, do so. Setting up a payment plan would be something that you need to do through the library, normally a lot of places have options for payments plans!
What does daverage do in Excel?
It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.
How do you identify duplicate rows in a table in Excel?
Using the Table Tools you can find duplicates. They can be eliminated if necessary.
Does Microsoft Excel find gross pay?
Yes, Microsoft Excel can be used to find gross pay. You would need to set up the necessary formulas to do so, but it can be done. There are many payment system used around the world, so there is not a definitive set of formulas that can always be used.
Which Excel function calculates the principal portion of a loan payment?
The PPMT function.
Excel helps organize and identify your files by using what?
Excel can access a file manager. Excel helps you organize and identify your files by using Document Properties.
What is an excel query?
Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.
