ID EN
#Financial

FV

Excel Functions 🇮🇩 Bahasa Indonesia

Dapatkan nilai masa depan dari sebuah investasi

Syntax

EXCEL
=FV(rate, nper, pmt, [pv], [type])

Arguments

Parameter Deskripsi
rate The interest rate per period.
nper The total number of payment periods.
pmt The payment made each period. Must be entered as a negative number.
pv [optional] The present value of future payments. If omitted, assumed to be zero. Must be entered as a negative number.
type [optional] When payments are due. 0 = end of period, 1 = beginning of period. Default is 0.

Return Value

nilai masa depan

Details

Fungsi nilai masa depan (FV) menghitung nilai masa depan suatu investasi dengan asumsi pembayaran berkala dan konstan dengan tingkat bunga konstan.

See Also

PV RATE NPER PMT PPMT IPMT CUMPRINC CUMIPMT