Ipmt Excel Formula

What is the use of Ipmt formula?

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

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

Examples of Excel Ipmt formula:
ipmt(10%,3,12,-100000) = 9017.97


Buy Excel Formula E-book | Learn more about Excel Ipmt Formula

More Financial Functions : Fv | Ipmt | Npv | Pmt | Ppmt

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions