Back to all functions

Sometimes we want to find out how much of a payment is actually paying back the loan, and how much is interest.
To find the interest part of a payment, we use the IPMT function.
Just like for the PPMT function, we’ll write Equals, IPMT, and select the rate. We want this to remain unchanged, so we’ll make this reference absolute.
We’ll then select the payment number to the left, the number of payments, make it absolute, select the Present Value, the amount of the original loan, and make that absolute as well.
We will ignore the future value and type for this lesson.
We then receive the how much the interest is worth for that particular payment. Note that the two numbers together equal the amount of the payment for each period.
If we copy downward, we see how much of each of the twelve payments is Principal, and how much is interest, as well as how much total interest is payed.
In this lesson we have looked at the IPMT function, which returns the interest part of the payment of a loan

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.