Functions > Finance > Future Value
Future Value
fv(rate, nper, pmt, [[pv], [type]])—Returns the future value of an investment or loan based on periodic, constant payments over a given number of compounding periods nper using a fixed interest rate and a specified payment pmt.
fvadj(prin, sched)—Returns the future value of initial principal prin after applying a series of compound interest rates sched.
fvc(rate, cash)—Returns the future value of a series of cash flows occurring at regular intervals earning a specified interest rate.
Arguments
rate is the real, positive, scalar fixed interest rate per period. Typically, 0 ≤ rate < 1.
nper is the positive integer number of compounding periods.
pmt is the real payment made each period. It usually includes principal and interest but no other taxes and fees.
pv is the real, positive present (or initial) value loan. If omitted, pv = 0.
type (optional) is 0 for a payment made at the end of the period or 1 for the beginning. If omitted, type = 0.
prin is the real, positive initial principal.
sched is a vector of interest rates, each of which are applied over the same amount of time.
cash is a vector of cash flows assigned at regular intervals. Payments are entered as negative numbers and income as positive numbers.
Was this helpful?