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:

	A	B
1	Pricple	$10,000.00
2	Percentage of year one	4%
3	Percentage of year two	5%
4	Percentage of year three	6%
5	Receivable in end of year three	11575.2