« Home
About
Contact
Archives
Forum
Most Popular
Excel Tips
Charting
Excel Dashboards
Project Mgmt.
Free Downloads
Buy Stuff
Subscribe
Pmt Excel Formula
Excel Formulas
>
Financial Functions
> PMT
«
Npv
| Pmt |
Ppmt
»
What is the use of Pmt formula?
Tells you how much you should pay on your mortage (every month ..)
Syntax of Pmt formula:
pmt(at this rate, this many payments, for this much amount)
Examples of Excel Pmt formula:
pmt(10%,12,-100000) = 14676.33
Buy Excel Formula E-book
|
Learn more about Excel Pmt Formula
More Financial Functions :
Fv
|
Ipmt
|
Npv
|
Pmt
|
Ppmt
Mathematical Functions
|
Text Functions
|
Logical & Reference Functions
Date & Time Functions
|
Financial Functions
|
Information Functions