FVSCHEDULE


Returns the future value of a lump sum, with changing future interest rates.

Syntax:

FVSCHEDULE(principal, interestrates)

principal: the initial value of the lump sum.
interestrates: a range or array containing a schedule of interest rates which apply each period.

FVSCHEDULE calculates the future value by applying each interest rate in turn, and compounding. The formula is:


where  is the  interest rate in interestrates.

Example:

FVSCHEDULE(1000, {.05, .06, .07})
returns 1,190.91, the future value of 1000 in 3 years time, where you believe the appropriate interest rates will be 5% in the first year, 6% in the second year and 7% in the third year.






 
Created with Zapof