Skip to main content

FVSCHEDULE

Definition of FVSCHEDULE

Calculates the future value of some principal based on a specified series of potentially varying interest rates.

Sample Usage

FVSCHEDULE(10000,A2:A100)

FVSCHEDULE(10000,{0.1,0.95,0.9,0.85})

FVSCHEDULE(A2,B2:B20)

Syntax

FVSCHEDULE(principal, rate_schedule)

  • principal - The amount of initial capital or value to compound against.

  • rate_schedule - A series of interest rates to compound against the principal.

    • rate_schedule must be either a range or array containing the interest rates to compound, in sequence. These should be expressed either as decimals or as percentages using UNARY_PERCENT, i.e.0.09 or UNARY_PERCENT(9) rather than 9.

See Also

PV: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

PPMT: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

PMT: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

NPER: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

IPMT: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

FV: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

To use the FVSCHEDULE Formula, simply begin with your edited Excellentable:

 

Then begin typing the FVSCHEDULE formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

Error.

User does not have sufficient privileges to access this Content
Learn More

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.