Google Sheets 함수

NPER

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

이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.

구문

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.

인수

rate필수The interest rate per period.
pmt필수The payment made each period; it cannot change over the life of the annuity.
pv필수The present value, or the lump-sum amount that a series of future payments is worth now.
fv선택The future value or a cash balance you want to attain after the last payment is made.
type선택The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

예시

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

결과: 54.55

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

자주 묻는 질문

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.

NPER

구문

인수

예시

자주 묻는 질문

관련 함수

NPER

구문

인수

예시

자주 묻는 질문

관련 함수