Difference between revisions of "Pv"

 
Line 2: Line 2:
 
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
 
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
 
   
 
   
= Pv(rate,nper,pmt'',fv,type) =
+
== Pv(rate, nper, pmt'', fv, type'') ==
 
 
 
Returns the present value of an annuity in which you receive (or pay) a constant amount each period for a fixed number of periods, and then receive (or pay) a lump sum after the final payment.  The result is positive if you would receive money in exchange for the annuity (for example, if you receive a loan).  The result is negative if you would have to pay money to acquire the annuity.
 
Returns the present value of an annuity in which you receive (or pay) a constant amount each period for a fixed number of periods, and then receive (or pay) a lump sum after the final payment.  The result is positive if you would receive money in exchange for the annuity (for example, if you receive a loan).  The result is negative if you would have to pay money to acquire the annuity.
  
 
Parameters:
 
Parameters:
  Rate: Interest rate per period.
+
;«Rate»: Interest rate per period.
  Nper: Total number of periods for the annuity.
+
;«Nper»: Total number of periods for the annuity.
  Pmt:  Payment made each period.  If you make payments, like paying a loan,
+
;«Pmt»:  Payment made each period.   
        this is a negative number.  If you receive payments, this is a
+
:If you make payments, like paying a loan, this is a negative number.   
        positive number.
+
:If you receive payments, this is a positive number.
  Fv:   (Optional) The balance remaining at the end after the last payment is
+
;«Fv»: (Optional) The balance remaining at the end after the last payment is received.   
        received.  If you make payments, a negative number indicates the required
+
:If you make payments, a negative number indicates the required balloon payment at the end of the loan.   
        balloon payment at the end of the loan.  If you receive payments, a positive
+
:If you receive payments, a positive
  Type: (Optional) Indicates whether payments are at the beginning of the
+
;«Type»: (Optional) Indicates whether payments are at the beginning of the period.
        period.
+
:<code>True</code> = Payments due at beginning of period, with first payment due immediately.
        True = Payments due at beginning of period, with first payment  
+
:<code>False</code>= Payments due at end of period. (default)
                due immediately.
 
        False = Payments due at end of period. (default)
 
 
 
= Library =
 
  
 +
== Library ==
 
Financial Function  
 
Financial Function  
  
= Examples =
+
== Examples ==
  
 
A lottery winning pays $50,000 per year for 15 years, with the first payment occurring immediately.  Following the last payment, there is a final lump-sum payment of $250,000.  Assuming an 8% return, this "million dollar" prize is really worth:
 
A lottery winning pays $50,000 per year for 15 years, with the first payment occurring immediately.  Following the last payment, there is a final lump-sum payment of $250,000.  Assuming an 8% return, this "million dollar" prize is really worth:
  
:-[[Pv]]( 8%, 15, 50000, 250000, 1) &rarr; $541,022.28
+
:<code>-Pv(8%, 15, 50000, 250000, 1) &rarr; $541,022.28</code>
  
 
Note that the result of Pv is negative since you would have to pay money to acquire the equivalent of the lottery's future payments.
 
Note that the result of Pv is negative since you would have to pay money to acquire the equivalent of the lottery's future payments.
  
You are considering the purchase of an annuity that pays $500 per month for 10 years, with the first payment occuring at the end of the first month.  With a 6% annual yield (0.5% monthly), the value of this annuity is:
+
You are considering the purchase of an annuity that pays $500 per month for 10 years, with the first payment occurring at the end of the first month.  With a 6% annual yield (0.5% monthly), the value of this annuity is:
  
-[[Pv]]( 0.5%, 12*10, 500 ) &rarr; $45036.73
+
:<code>-Pv(0.5%, 12*10, 500) &rarr; $45036.73</code>
  
 
You can afford $1500 per month on mortgage payments, and are considering a 30 year fixed rate loan at .565% per month (= 7% APR). The size mortgage that you can afford is given by:
 
You can afford $1500 per month on mortgage payments, and are considering a 30 year fixed rate loan at .565% per month (= 7% APR). The size mortgage that you can afford is given by:
  
[[Pv]]( 0.565%, 30*12, -1500 ) &rarr; $230558.71
+
:<code>Pv(0.565%, 30*12, -1500) &rarr; $230558.71</code>
 
 
= See Also =
 
  
 +
== See Also ==
 
* [[Fv]]
 
* [[Fv]]
 
* [[Rate]]
 
* [[Rate]]
 
* [[NPer]]
 
* [[NPer]]
 +
* [[Financial functions]]
 +
* [[Financial library functions]]

Latest revision as of 01:48, 2 February 2016


Pv(rate, nper, pmt, fv, type)

Returns the present value of an annuity in which you receive (or pay) a constant amount each period for a fixed number of periods, and then receive (or pay) a lump sum after the final payment. The result is positive if you would receive money in exchange for the annuity (for example, if you receive a loan). The result is negative if you would have to pay money to acquire the annuity.

Parameters:

«Rate»
Interest rate per period.
«Nper»
Total number of periods for the annuity.
«Pmt»
Payment made each period.
If you make payments, like paying a loan, this is a negative number.
If you receive payments, this is a positive number.
«Fv»
(Optional) The balance remaining at the end after the last payment is received.
If you make payments, a negative number indicates the required balloon payment at the end of the loan.
If you receive payments, a positive
«Type»
(Optional) Indicates whether payments are at the beginning of the period.
True = Payments due at beginning of period, with first payment due immediately.
False= Payments due at end of period. (default)

Library

Financial Function

Examples

A lottery winning pays $50,000 per year for 15 years, with the first payment occurring immediately. Following the last payment, there is a final lump-sum payment of $250,000. Assuming an 8% return, this "million dollar" prize is really worth:

-Pv(8%, 15, 50000, 250000, 1) → $541,022.28

Note that the result of Pv is negative since you would have to pay money to acquire the equivalent of the lottery's future payments.

You are considering the purchase of an annuity that pays $500 per month for 10 years, with the first payment occurring at the end of the first month. With a 6% annual yield (0.5% monthly), the value of this annuity is:

-Pv(0.5%, 12*10, 500) → $45036.73

You can afford $1500 per month on mortgage payments, and are considering a 30 year fixed rate loan at .565% per month (= 7% APR). The size mortgage that you can afford is given by:

Pv(0.565%, 30*12, -1500) → $230558.71

See Also

Comments


You are not allowed to post comments.