NPER

Dapatkan jumlah periode untuk pinjaman atau investasi

Syntax

EXCEL Copy

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

Arguments

Parameter	Deskripsi
rate	The interest rate per period.
pmt	The payment made each period.
pv	The present value, or total value of all payments now.
fv	[optional] The future value, or a cash balance you want after the last payment is made. Defaults to 0.
type	[optional] When payments are due. 0 = end of period. 1 = beginning of period. Default is 0.

Return Value

Jumlah periode

Details

Anda dapat menggunakan fungsi NPER untuk mendapatkan jumlah periode pembayaran pinjaman (atau investasi), berdasarkan jumlah, tingkat bunga, dan jumlah pembayaran berkala.

See Also

FV PV RATE NPER PMT PPMT IPMT CUMPRINC