Hi Jennifer, The formula for Future Value is simply =FV(). Below is the syntax. =FV (rate, nper, pmt, pv, type) where 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 - The present value. If omitted, pv=0. type - Is a value representing the timing of a payment. Payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.
what's the excel formula for FV? thank you
Hi Jennifer,
The formula for Future Value is simply =FV(). Below is the syntax.
=FV (rate, nper, pmt, pv, type)
where
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 - The present value. If omitted, pv=0.
type - Is a value representing the timing of a payment. Payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.