fv

Future value of an investment.

Syntax

v = fv(rate, nper, pmt, pv, type)

Description

Returns the future value after nper periods at periodic rate rate of an investment with periodic payment pmt and starting value pv.

Example

fv(0.06/12, 10*12, -100, 0)    % FV of $100/mo at 6% for 10y

See also

• pv — Present value of an investment.
• pmt — Periodic payment for a loan or annuity.
• nper — Number of payment periods for a loan or investment.
• rate — Periodic interest rate for an annuity.
• fvschedule — Future value with variable interest rates.