Difference between revisions of "Documentation/How Tos/Calc: FVSCHEDULE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
| (5 intermediate revisions by 4 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. | ||
| − | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: FV function|FV]] | * [[Documentation/How_Tos/Calc: FV function|FV]] | ||
| Line 25: | Line 30: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
| + | [[Category: Documentation/Reference/Calc/Financial functions]] | ||
Latest revision as of 15:52, 30 January 2024
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
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
