Difference between revisions of "Manuals/calci/PVIF"
Jump to navigation
Jump to search
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|Conversion}} | ||
==See Also== | ==See Also== |
Revision as of 15:20, 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
- PVIF(9,3) = 1000
- PVIF(7.3,13) = 887187064230.8887
- PVIF(3.65,45) = 1.0848829404063244e+30
Related Videos
See Also
References