Difference between revisions of "Documentation/How Tos/Calc: FVSCHEDULE function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE: FVSCHEDULE function}}
 +
{{Documentation/CalcFunc FinancialTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_FV_function
 +
|NextPage=Documentation/How_Tos/Calc:_IPMT_function
 +
}}__NOTOC__
  
 
== FVSCHEDULE ==
 
== FVSCHEDULE ==
Line 7: Line 12:
 
<tt>'''FVSCHEDULE(principal; interestrates)'''</tt>
 
<tt>'''FVSCHEDULE(principal; interestrates)'''</tt>
 
: <tt>'''principal'''</tt>: the initial value of the lump sum.
 
: <tt>'''principal'''</tt>: the initial value of the lump sum.
−
: <tt>'''interestrates'''</tt>: a range or array containing a schedule of interest rates which apply each period.
+
: <tt>'''interestrates'''</tt>: a range or array containing a schedule of interest rates which apply to each period.
  
  
Line 18: Line 23:
 
: 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|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: FV function|FV]]
 
* [[Documentation/How_Tos/Calc: FV function|FV]]
  

Latest revision as of 15:52, 30 January 2024

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 to 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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_FVSCHEDULE_function&oldid=259739"
Views
Personal tools
Navigation
Tools
In other languages