FVSCHEDULE(P, R)

 

Description

This function returns the future value of an initial principal after compounding by a series of interest rates.

 

Parameters

 

P

Principal, or present value.

 

R

An array of interest rates by which to compound.

 

Examples

 

FVSCHEDULE(100, A1:A4) = 133.4260

Where A1:A4 = 7.5%, 6.6%, 8%, 7%.