• 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.