Back to all functions

The NPER function returns the amount of payments of a given amount that must be made, in order to pay back a loan of a given size, and a given interest rate.

By multiplying the 15 years we have to pay back the loan by 12, we get our initial number of 180 monthly payments.
But if we don’t have the option of doing this, we can get the amount by using the NPER function. We’ll write Equals, NPER, and select the rate, payment amount, present value, and future value.
We are given the same value as earlier, but now we have the ability to change the amount we want to pay each period and get the amount of periods it would take to pay back the loan.

For example, if we want to pay 2500 Euros every month, we’ll have paid back the loan in full in just under 35 months, which is less than three years.
In this lesson we have shown how to get the amount of periods needed to pay back a loan using the NPER function.

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...

Vi hjälper dig att välja rätt onlinekurser för företaget

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.