# NPER function

Excel’s NPER function is a financial function that helps you calculate the number of periods needed to reach a specific financial goal, given a fixed interest rate, constant periodic payments, and an initial investment or loan amount. In simpler terms, it tells you how long it will take to pay off a loan or grow an investment to a desired amount.

## Syntax

NPER(rate, payment, present_value, [future_value], [type])

## How to Use

The NPER function is quite handy when you want to plan your finances or determine how long it will take to pay off a loan. Here’s how to use it:

Let’s say you take out a loan of \$10,000 with an annual interest rate of 5%, and you intend to make monthly payments of \$200. To find out how many months it will take to pay off the loan:

This formula calculates the number of months required to pay off the loan, given the monthly interest rate, monthly payment, and the initial loan amount.

Now, let’s look at another example where you want to determine how long it will take to accumulate \$50,000 by saving \$500 per month at an annual interest rate of 6%:

In this case, the function calculates the number of months needed to reach a savings goal of \$50,000, considering the monthly interest rate, monthly deposits, and a starting balance of \$0.

Remember to adjust the interest rate and payment values based on your specific financial situation.