Difference between revisions of "Manuals/calci/PVIF"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''PVIF (Rate,NumberOfPayments)'''</div><br/> *<math>Rate</math> is the rate of interest. *<math>NumberOfPayments</math> . ==Description== *This ...")
 
 
(3 intermediate revisions by 2 users not shown)
Line 2: Line 2:
  
 
*<math>Rate</math> is the rate of interest.
 
*<math>Rate</math> is the rate of interest.
*<math>NumberOfPayments</math> .
+
*<math>NumberOfPayments</math> is the number of installments.
  
 
==Description==
 
==Description==
Line 18: Line 18:
 
# PVIF(7.3,13) = 887187064230.8887
 
# PVIF(7.3,13) = 887187064230.8887
 
# PVIF(3.65,45) =  1.0848829404063244e+30
 
# PVIF(3.65,45) =  1.0848829404063244e+30
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=RoWuvgZNwlA|280|center|PVIF}}
  
 
==See Also==
 
==See Also==
Line 25: Line 29:
  
 
==References==
 
==References==
*[[https://www.miniwebtool.com/pvif-calculator/ PVIF]
+
*[https://www.miniwebtool.com/pvif-calculator/ PVIF]
 +
 
  
 
*[[Z_API_Functions | List of Main Z Functions]]
 
*[[Z_API_Functions | List of Main Z Functions]]
  
 
*[[ Z3 |  Z3 home ]]
 
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:21, 22 February 2019

PVIF (Rate,NumberOfPayments)


  • is the rate of interest.
  • is the number of installments.

Description

  • This function shows the present value interest factor.
  • In , is the rate of intesrest.
  • is the number of installments.
  • The present value factor which is a factor used to calculate an estimate of the present value of an amount to be received in a future period.
  • The present value factor is also called present value interest factor.
  • The formula for PVIF is :

,where r = interest rate per period.n = number of periods.

  • This function will return the result as NaN when any one of the parameter is non numeric.

Examples

  1. PVIF(9,3) = 1000
  2. PVIF(7.3,13) = 887187064230.8887
  3. PVIF(3.65,45) = 1.0848829404063244e+30

Related Videos

PVIF

See Also

References