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

Microsoft Excel Formula Training - Ebook