Manuals/calci/FVSCHEDULE

FVSCHEDULE(Principal, Schedule)

where,

Principal - reprenets the present value.

Schedule - an array of interest rates to apply.

Calci returns the future value of an initial principal after applying a series of compound interest rates

The values in Schedule either number or blank cells, any other value returns NaN.

FVSCHEDULE

Lets see an example in (Column1, Row5)

=FVSCHEDULE(R1C1, R1C2:R1C4)

FVSCHEDULE returns 9.4536.

Consider another example (Column1, Row4)

=FVSCHEDULE(12,[0.5,1,"FDJHJ"])

It returns NaN.

Syntax

Remarks

Examples

Description