Ppmt Excel Formula

Excel Formulas > Financial Functions > PPMT

Pmt | Ppmt | Column

What is the use of Ppmt formula?

Tells you how much of your mortgage goes towards principle in specified month

Syntax of Ppmt formula:
ppmt(at this rate, on this payment, out of this many payments, for this much amount)

Examples of Excel Ppmt formula:
ppmt(10%,3,12,-100000) = 5658.36

Buy Excel Formula E-book | Learn more about Excel Ppmt 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