Manuals/calci/FVSCHEDULE

FVSCHEDULE(Principal, Schedule)

Where

• $Principal$ represents the present value, and
• $Schedule$ represents the array of interest rates to apply.
  • FVSCHEDULE() returns the future value of an initial principal after applying a series of compound interest rates.

Description

FVSCHEDULE(Principal, Schedule)

• Argument $Schedule$ can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message.
• Blank cells in the array of $Schedule$ argument are considered to be zero (0).

Examples

Consider the following example that shows the use of FVSCHEDULE function:

2	0.01
	0.56
	0.02

=FVSCHEDULE(A1,[B1,B2,B3]) : Calculates the future value with Principal in cell A1 and 
array of interests from cells B1 to B3. Returns 3.214224 as a result.
=FVSCHEDULE(1,[0.08,0.12]) : Calculates the future value with the mentioned argument values. 
Returns 1.2096000000000002 as a result.

Related Videos

FVSCHEDULE

See Also

• FV

References

• Future Value

• List of Main Z Functions

• Z3 home