Name
PV Function
Class
Microsoft.VisualBasic.Financial
Syntax
PV(rate, nper, pmt[, fv [, due]])-
rate Use: Required
Data Type: Double
The interest rate per period
-
nper Use: Required
Data Type: Integer
The number of payment periods in the annuity
-
pmt Use: Required
Data Type: Double
The payment made in each period
-
fv Use: Optional
Data Type: Double
The future value of the loan or annuity
-
due Use: Optional
Data Type: DueDate
Either
DueDate.BegOfPeriodorDueDate.EndOfPeriod
Return Value
A Double specifying the present value of an annuity
Description
Calculates the present value of an annuity (either an investment or loan) based on a regular number of future payments of a fixed value and a fixed interest rate.
The present value is the current value of a future stream of equal cash flows discounted at some fixed interest rate.
Rules at a Glance
The time units used for the number of payment periods, the rate of interest, and the payment amount must be the same. In other words, if you state the payment period in months, you must also express the interest rate as a monthly rate and the amount paid per month.
The rate per period is stated as a fraction of 100. For example, 10% is stated as .10. If you are calculating using monthly periods, you must also divide the rate per period by 12. For example, 10% per annum equates to a rate per period of .00833.
The
fvargument indicates the future value or cash balance after the last payment. The default is 0, since that reflects the value of a loan after the final ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access