Funkcja Arkuszy Google

NPER

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

Wygeneruj formułę z SI Ta sama funkcja w Excelu

Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.

Składnia

NPER(rate, pmt, pv, [fv], [type])

The NPER function calculates the total number of payment periods required to reach a specific financial goal or pay off a loan. It assumes that payments are constant and the interest rate remains unchanged throughout the duration of the investment.

Argumenty

ratewymaganeThe interest rate per period.
pmtwymaganeThe payment made each period; it cannot change over the life of the annuity.
pvwymaganeThe present value, or the lump-sum amount that a series of future payments is worth now.
fvopcjonalneThe future value or a cash balance you want to attain after the last payment is made.
typeopcjonalneThe number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

Przykłady

=NPER(0.05/12, -200, 10000)

Wynik: 54.55

Calculates the number of months to pay off a $10,000 loan with a 5% annual interest rate and $200 monthly payments.

Najczęstsze pytania

Why does NPER return a #NUM! error?

This usually happens if the payment amount is too low to cover the interest, making it impossible to reach the future value.

Powiązane funkcje

PMT PV FV RATE