FvSchedule

Syntax

FvSchedule(Principal, Schedule)

Principal. The present value of the investments.

Schedule. A range of cells containing array of interest rate variables.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns a future value of the initial principal after a series (schedule) of compound interest rates have been applied.

The function is used to calculate the future investment value based on variable interest rate.

Formula	Result	Description
=FvSchedule(800,A0:C0)	1161,50	The future value of the initial principal after a series (schedule) of compound interest rates specified within the A0:C0 cell range have been applied. The A0:C0 range includes the following values: 0.01, 0.15, 0.25.
=FvSchedule(B6,A0:C0)	1797,21	The future value of the initial principal, specified in the B6 cell, after a series (schedule) of compound interest rates specified within the A0:C0 cell range have been applied. The A0:C0 range includes the following values: 0.1, 0.25, 0.25. The B6 cell contains the 1045.65 value.