Difference between revisions of "Documentation/How Tos/Calc: FV function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 19: | Line 19: | ||
: <tt>'''FV'''</tt> returns the future value at the end of the term, of a lump sum payment (<tt>'''presentvalue'''</tt>) at the start of the term and a <tt>'''payment'''</tt> being made each period for <tt>'''numperiods'''</tt> periods, at fixed rate interest, compounded each period. | : <tt>'''FV'''</tt> returns the future value at the end of the term, of a lump sum payment (<tt>'''presentvalue'''</tt>) at the start of the term and a <tt>'''payment'''</tt> being made each period for <tt>'''numperiods'''</tt> periods, at fixed rate interest, compounded each period. | ||
| − | : See | + | : See * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' for the underlying formula. |
=== Example: === | === Example: === | ||
| Line 28: | Line 28: | ||
: returns a future value of <tt>'''-328.49'''</tt> in currency units. | : returns a future value of <tt>'''-328.49'''</tt> in currency units. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | [[Documentation/How_Tos/Calc: PV function| | + | * [[Documentation/How_Tos/Calc: PV function|PV]], |
| − | [[Documentation/How_Tos/Calc: IPMT function| | + | * [[Documentation/How_Tos/Calc: IPMT function|IPMT]], |
| − | [[Documentation/How_Tos/Calc: PMT function| | + | * [[Documentation/How_Tos/Calc: PMT function|PMT]], |
| − | [[Documentation/How_Tos/Calc: PPMT function| | + | * [[Documentation/How_Tos/Calc: PPMT function|PPMT]], |
| − | [[Documentation/How_Tos/Calc: RATE function| | + | * [[Documentation/How_Tos/Calc: RATE function|RATE]], |
| − | [[Documentation/How_Tos/Calc: NPER function| | + | * [[Documentation/How_Tos/Calc: NPER function|NPER]] |
| − | + | * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' | |
| − | [[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]]}} |
=== Issues: === | === Issues: === | ||
* Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. Choose the interest rate appropriately. | * Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. Choose the interest rate appropriately. | ||
Revision as of 13:50, 25 February 2009
FV
Returns the future value of an initial sum with a subsequent stream of payments.
Syntax:
FV(rate; numperiods; payment; presentvalue; type)
- rate: the (fixed) interest rate per period.
- numperiods: the total number of payment periods in the term.
- payment: the payment made each period. If presentvalue is given, this may omitted (defaults to 0).
- presentvalue: the lump sum payment at the start of the term (optional - defaults to 0). With a loan, this would normally be the sum borrowed; with a bond this would generally be 0.
- type: when payments are made (optional - defaults to 0):
- 0 - at the end of each period.
- 1 - at the start of each period (including a payment at the start of the term).
- The value of money is time-dependent; for example, $100 today would be worth $110 in a year if invested at a 10% interest rate.
- FV returns the future value at the end of the term, of a lump sum payment (presentvalue) at the start of the term and a payment being made each period for numperiods periods, at fixed rate interest, compounded each period.
- See * Derivation of Financial Formulas for the underlying formula.
Example:
FV(5%; 3; -1000; 0; 0)
- returns 3,152.50 in currency units. You pay 1,000 at the end of each year for 3 years. Assuming an interest rate of 5% you expect to receive 3,152.50 at the end of the term.
FV(7%; 10; -1400; 10000; 0)
- returns a future value of -328.49 in currency units.
Template:Documentation/SeeAlso
Issues:
- Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. Choose the interest rate appropriately.
