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

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Syntax:)
(13 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|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]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_RATE_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_PPMT_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Date_%26_Time_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Information_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</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:_AMORLINC_function|<div style="font-size: 120%;">Amorlinc]]
 +
* [[Documentation/How_Tos/Calc:_DB_function|<div style="font-size: 120%;">Db]]
 +
* [[Documentation/How_Tos/Calc:_DDB_function|<div style="font-size: 120%;">Ddb]]
 +
* [[Documentation/How_Tos/Calc:_SLN_function|<div style="font-size: 120%;">Sln]]
 +
* [[Documentation/How_Tos/Calc:_SYD_function|<div style="font-size: 120%;">Syd]]
 +
* [[Documentation/How_Tos/Calc:_VDB_function|<div style="font-size: 120%;">Vdb]]
 +
 
 +
<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_ADD_function|<div style="font-size: 120%;">Cumipmt Add]]
 +
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%;">Cumprinc]]
 +
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">Cumpinc Add]]
 +
* [[Documentation/How_Tos/Calc:_FV_function|<div style="font-size: 120%;">Fv]]
 +
* [[Documentation/How_Tos/Calc:_FVSCHEDULE_function|<div style="font-size: 120%;">Fvschedule]]
 +
* [[Documentation/How_Tos/Calc:_IPMT_function|<div style="font-size: 120%;">Ipmt]]
 +
* [[Documentation/How_Tos/Calc:_IRR_function|<div style="font-size: 120%;">Irr]]
 +
* [[Documentation/How_Tos/Calc:_ISPMT_function|<div style="font-size: 120%;">Ispmt]]
 +
* [[Documentation/How_Tos/Calc:_MIRR_function|<div style="font-size: 120%;">Mirr]]
 +
* [[Documentation/How_Tos/Calc:_NPER_function|<div style="font-size: 120%;">Nper]]
 +
* [[Documentation/How_Tos/Calc:_NPV_function|<div style="font-size: 120%;">Npv]]
 +
* [[Documentation/How_Tos/Calc:_PMT_function|<div style="font-size: 120%;">Pmt]]
 +
* [[Documentation/How_Tos/Calc:_PPMT_function|<div style="font-size: 120%;">Ppmt]]
 +
* [[Documentation/How_Tos/Calc:_PV_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Pv]]
 +
* [[Documentation/How_Tos/Calc:_RATE_function|<div style="font-size: 120%;">Rate]]
 +
* [[Documentation/How_Tos/Calc:_RRI_function|<div style="font-size: 120%;">Rri]]
 +
* [[Documentation/How_Tos/Calc:_XIRR_function|<div style="font-size: 120%;">Xirr]]
 +
* [[Documentation/How_Tos/Calc:_XNPV_function|<div style="font-size: 120%;">Xnpv]]
 +
 
 +
<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:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm]]
 +
* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
 +
* [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective]]
 +
* [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add]]
 +
* [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate]]
 +
* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
 +
* [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal]]
 +
* [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add]]
 +
* [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]]
 +
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]]
 +
 
 +
<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:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays]]
 +
* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]]
 +
* [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd]]
 +
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]]
 +
* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]]
 +
 
 +
<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:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]]
 +
}}__TOC__
  
 
== PV ==
 
== PV ==
−
Returns the present value of a stream of future payments.
+
Returns the present value of a stream of future payments with a final lump sum.
  
 
=== Syntax: ===
 
=== Syntax: ===
Line 13: Line 81:
 
:: 0 - at the end of each period.
 
:: 0 - at the end of each period.
 
:: 1 - at the start of each period (including a payment at the start of the term).
 
:: 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.
 
: 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.
  
−
: <tt>'''PV'''</tt> returns the value today, of a <tt>'''payment'''</tt> being made each period for <tt>'''numperiods'''</tt> periods, with fixed rate interest being compounded each period. Often, the interest used is that which applies to minimum risk investments, for example those issued by a government.
+
: <tt>'''PV'''</tt> returns the value today, of a <tt>'''payment'''</tt> being made each period for <tt>'''numperiods'''</tt> periods, with an additional lump sum payment (<tt>'''futurevalue'''</tt>) at the end of the term, at fixed rate interest, compounded each period.  
  
 
: The examples below clarify how the function may be used.
 
: The examples below clarify how the function may be used.
  
−
: See '''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' for the underlying formula.
+
: See [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] for the underlying formula.
  
 
=== Example: ===
 
=== Example: ===
Line 30: Line 99:
  
 
<tt>'''PV(7%/2; 3*2; 100; 1000; 0)'''</tt>
 
<tt>'''PV(7%/2; 3*2; 100; 1000; 0)'''</tt>
−
:  returns <tt>'''-1,346.36'''</tt> in currency units. A 3 year bond is issued, paying 100 semiannual coupons (payments) and 1000 on maturity. You require an annual rate of return of 7% (compounded semiannually) bearing in mind any risk, and hence you value the bond on issue at 1,346.36. The result is shown as negative, as you would have to pay for the bond.
+
:  returns <tt>'''-1,346.36'''</tt> in currency units. A 3 year bond is issued, paying 100 currency units semiannual coupons and 1000 currency units on maturity. You require an annual rate of return of 7% (compounded semiannually) bearing in mind any risk, and hence you value the bond on issue at 1,346.36. The result is shown as negative, as you would have to pay for the bond.
−
 
+
−
=== See also: ===
+
−
[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']],
+
−
[[Documentation/How_Tos/Calc: PMT function|'''PMT''']],
+
−
[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']],
+
−
[[Documentation/How_Tos/Calc: NPV function|'''NPV''']],
+
−
[[Documentation/How_Tos/Calc: IRR function|'''IRR''']],
+
−
[[Documentation/How_Tos/Calc: FV function|'''FV''']],
+
−
[[Documentation/How_Tos/Calc: NPER function|'''NPER''']],
+
−
[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
+
−
 
+
−
'''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]'''
+
−
 
+
−
[[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']]
+
  
 
=== 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.
 +
 +
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: IPMT function|IPMT]]
 +
* [[Documentation/How_Tos/Calc: PMT function|PMT]]
 +
* [[Documentation/How_Tos/Calc: PPMT function|PPMT]]
 +
* [[Documentation/How_Tos/Calc: NPV function|NPV]]
 +
* [[Documentation/How_Tos/Calc: FV function|FV]]
 +
* [[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|Financial functions]]
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Financial functions]]

Revision as of 09:34, 17 July 2018


PV

Returns the present value of a stream of future payments with a final lump sum.

Syntax:

PV(rate; numperiods; payment; futurevalue; 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 futurevalue is given, this may omitted (defaults to 0).
futurevalue: the cash balance you wish to attain at the end of the term (optional - defaults to 0). With a loan, this would normally be 0; with a bond this would be the redemption value.
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.
PV returns the value today, of a payment being made each period for numperiods periods, with an additional lump sum payment (futurevalue) at the end of the term, at fixed rate interest, compounded each period.
The examples below clarify how the function may be used.
See Derivation of Financial Formulas for the underlying formula.

Example:

PV(5%; 15; 1000; 0; 0)

returns -10,379.66 in currency units. You have the opportunity to buy an annuity, which would pay you 1000 at the end of each year for 15 years. You assume a constant interest rate of 5%. On this basis, the annuity is worth 10,379.66 today; if it is priced higher than this you might not wish to buy it. The result is negative, because you must pay for the annuity.

PV(5%/12; 3*12; -100; 0; 0)

returns 3,336.57 in currency units. You are considering a loan of 3,500, which would mean you paying back 100 at the end of each month for 3 years. You assume a constant interest rate of 5%. On this basis, the loan is only worth 3,336.57, so might be a poor deal. The monthly payment is negative because you pay it, and the result positive because the loan is paid to you.

PV(7%/2; 3*2; 100; 1000; 0)

returns -1,346.36 in currency units. A 3 year bond is issued, paying 100 currency units semiannual coupons and 1000 currency units on maturity. You require an annual rate of return of 7% (compounded semiannually) bearing in mind any risk, and hence you value the bond on issue at 1,346.36. The result is shown as negative, as you would have to pay for the bond.

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.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_PV_function&oldid=243603"
Views
Personal tools
Navigation
Tools