Documentation/How Tos/Calc: FVSCHEDULE function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 06:37, 15 August 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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:
principal * (1+rate1) * (1+rate2) *(1+rate3) * ...
where ratei is the ith 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.

See also:

FV

Financial functions

Personal tools