Difference between revisions of "Documentation/How Tos/Calc: FVSCHEDULE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 18: | Line 18: | ||
: returns <tt>'''1,190.91'''</tt>, 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. | : returns <tt>'''1,190.91'''</tt>, 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. | ||
− | + | {{Documentation/SeeAlso| | |
− | [[Documentation/How_Tos/Calc: FV function| | + | * [[Documentation/How_Tos/Calc: FV function|FV]] |
− | [[Documentation/How_Tos/Calc: Financial functions| | + | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 13:50, 25 February 2009
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.