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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Put some closing div tags.)
Line 2: Line 2:
 
|bookid=1234'''
 
|bookid=1234'''
 
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
+
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions</div>]]
 
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_FVSCHEDULE_function
 
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_FVSCHEDULE_function
 
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_CUMPRINC_ADD_function
 
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_CUMPRINC_ADD_function
Line 10: Line 10:
  
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Depreciation</div>
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Depreciation</div>
−
* [[Documentation/How_Tos/Calc:_AMORDEGRC_function|<div style="font-size: 120%;">Amordegrc]]
+
* [[Documentation/How_Tos/Calc:_AMORDEGRC_function|<div style="font-size: 120%;">Amordegrc</div>]]
−
* [[Documentation/How_Tos/Calc:_AMORLINC_function|<div style="font-size: 120%;">Amorlinc]]
+
* [[Documentation/How_Tos/Calc:_AMORLINC_function|<div style="font-size: 120%;">Amorlinc</div>]]
−
* [[Documentation/How_Tos/Calc:_DB_function|<div style="font-size: 120%;">Db]]
+
* [[Documentation/How_Tos/Calc:_DB_function|<div style="font-size: 120%;">Db</div>]]
−
* [[Documentation/How_Tos/Calc:_DDB_function|<div style="font-size: 120%;">Ddb]]
+
* [[Documentation/How_Tos/Calc:_DDB_function|<div style="font-size: 120%;">Ddb</div>]]
−
* [[Documentation/How_Tos/Calc:_SLN_function|<div style="font-size: 120%;">Sln]]  
+
* [[Documentation/How_Tos/Calc:_SLN_function|<div style="font-size: 120%;">Sln</div>]]  
−
* [[Documentation/How_Tos/Calc:_SYD_function|<div style="font-size: 120%;">Syd]]
+
* [[Documentation/How_Tos/Calc:_SYD_function|<div style="font-size: 120%;">Syd</div>]]
−
* [[Documentation/How_Tos/Calc:_VDB_function|<div style="font-size: 120%;">Vdb]]
+
* [[Documentation/How_Tos/Calc:_VDB_function|<div style="font-size: 120%;">Vdb</div>]]
  
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Payment Streams, Annuities, Loans</div>
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Payment Streams, Annuities, Loans</div>
−
* [[Documentation/How_Tos/Calc:_CUMIPMT_function|<div style="font-size: 120%;">Cumipmt]]
+
* [[Documentation/How_Tos/Calc:_CUMIPMT_function|<div style="font-size: 120%;">Cumipmt</div>]]
−
* [[Documentation/How_Tos/Calc:_CUMIPMT_ADD_function|<div style="font-size: 120%;">Cumipmt Add]]
+
* [[Documentation/How_Tos/Calc:_CUMIPMT_ADD_function|<div style="font-size: 120%;">Cumipmt Add</div>]]
−
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%;">Cumprinc]]
+
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%;">Cumprinc</div>]]
−
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">Cumpinc Add]]
+
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">Cumpinc Add</div>]]
−
* [[Documentation/How_Tos/Calc:_FV_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Fv]]  
+
* [[Documentation/How_Tos/Calc:_FV_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Fv</div>]]  
−
* [[Documentation/How_Tos/Calc:_FVSCHEDULE_function|<div style="font-size: 120%;">Fvschedule]]
+
* [[Documentation/How_Tos/Calc:_FVSCHEDULE_function|<div style="font-size: 120%;">Fvschedule</div>]]
−
* [[Documentation/How_Tos/Calc:_IPMT_function|<div style="font-size: 120%;">Ipmt]]
+
* [[Documentation/How_Tos/Calc:_IPMT_function|<div style="font-size: 120%;">Ipmt</div>]]
−
* [[Documentation/How_Tos/Calc:_IRR_function|<div style="font-size: 120%;">Irr]]
+
* [[Documentation/How_Tos/Calc:_IRR_function|<div style="font-size: 120%;">Irr</div>]]
−
* [[Documentation/How_Tos/Calc:_ISPMT_function|<div style="font-size: 120%;">Ispmt]]
+
* [[Documentation/How_Tos/Calc:_ISPMT_function|<div style="font-size: 120%;">Ispmt</div>]]
−
* [[Documentation/How_Tos/Calc:_MIRR_function|<div style="font-size: 120%;">Mirr]]
+
* [[Documentation/How_Tos/Calc:_MIRR_function|<div style="font-size: 120%;">Mirr</div>]]
−
* [[Documentation/How_Tos/Calc:_NPER_function|<div style="font-size: 120%;">Nper]]
+
* [[Documentation/How_Tos/Calc:_NPER_function|<div style="font-size: 120%;">Nper</div>]]
−
* [[Documentation/How_Tos/Calc:_NPV_function|<div style="font-size: 120%;">Npv]]  
+
* [[Documentation/How_Tos/Calc:_NPV_function|<div style="font-size: 120%;">Npv</div>]]  
−
* [[Documentation/How_Tos/Calc:_PMT_function|<div style="font-size: 120%;">Pmt]]
+
* [[Documentation/How_Tos/Calc:_PMT_function|<div style="font-size: 120%;">Pmt</div>]]
−
* [[Documentation/How_Tos/Calc:_PPMT_function|<div style="font-size: 120%;">Ppmt]]
+
* [[Documentation/How_Tos/Calc:_PPMT_function|<div style="font-size: 120%;">Ppmt</div>]]
−
* [[Documentation/How_Tos/Calc:_PV_function|<div style="font-size: 120%;">Pv]]
+
* [[Documentation/How_Tos/Calc:_PV_function|<div style="font-size: 120%;">Pv</div>]]
−
* [[Documentation/How_Tos/Calc:_RATE_function|<div style="font-size: 120%;">Rate]]
+
* [[Documentation/How_Tos/Calc:_RATE_function|<div style="font-size: 120%;">Rate</div>]]
−
* [[Documentation/How_Tos/Calc:_RRI_function|<div style="font-size: 120%;">Rri]]
+
* [[Documentation/How_Tos/Calc:_RRI_function|<div style="font-size: 120%;">Rri</div>]]
−
* [[Documentation/How_Tos/Calc:_XIRR_function|<div style="font-size: 120%;">Xirr]]
+
* [[Documentation/How_Tos/Calc:_XIRR_function|<div style="font-size: 120%;">Xirr</div>]]
−
* [[Documentation/How_Tos/Calc:_XNPV_function|<div style="font-size: 120%;">Xnpv]]  
+
* [[Documentation/How_Tos/Calc:_XNPV_function|<div style="font-size: 120%;">Xnpv</div>]]  
  
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Securities</div>
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Securities</div>
−
* [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint]]
+
* [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint</div>]]
−
* [[Documentation/How_Tos/Calc:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm]]
+
* [[Documentation/How_Tos/Calc:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm</div>]]
−
* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]]
+
* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc</div>]]
−
* [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration]]
+
* [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration</div>]]
−
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
+
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add</div>]]
−
* [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective]]
+
* [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective</div>]]
−
* [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add]]
+
* [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add</div>]]
−
* [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate]]
+
* [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate</div>]]
−
* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]]
+
* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration</div>]]
−
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
+
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add</div>]]
−
* [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal]]
+
* [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal</div>]]
−
* [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add]]
+
* [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add</div>]]
−
* [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]]
+
* [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice</div>]]
−
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]]
+
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield</div>]]
  
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div>
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div>
−
* [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs]]
+
* [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs</div>]]
−
* [[Documentation/How_Tos/Calc:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays]]
+
* [[Documentation/How_Tos/Calc:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays</div>]]
−
* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]]
+
* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc</div>]]
−
* [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd]]
+
* [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd</div>]]
−
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]]
+
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum</div>]]
−
* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]]
+
* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd</div>]]
  
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
 
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
  
−
* [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]]
+
* [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs</div>]]
−
* [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]]
+
* [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays</div>]]
 
}}__TOC__
 
}}__TOC__
  

Revision as of 05:01, 16 September 2013

CALC FUNCTIONS
FUNCTIONS
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous


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 a future value of 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. 1,000 is negative because you pay it. The future value is positive because you receive it.

FV(7%; 10; -1400; 10000; 0)

returns a future value of -328.49 in currency units. You borrow 10,000 at an interest rate of 7% and pay 1,400 at the end of each year for 10 years. 10,000 is positive because you have it. 1,400 is negative because you pay it. The future value is negative because this is the amount of money you owe at the end of the term.

FV(7%; 1; 0; 10000; 0)

returns a future value of -10,700 in currency units. You borrow 10,000 at an interest rate of 7% and don't pay any of it back. After 1 year you owe 10,700.

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.

Template:Documentation/SeeAlso

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_FV_function&oldid=231023"
Personal tools