Crystal Reports for Eclipse Designer Guide

PV

Description
PV returns a Number specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.
Overloads
  • PV (rate, nPeriods, payment)
  • PV (rate, nPeriods, payment, futureValue)
  • PV (rate, nPeriods, payment, futureValue, type)
  • Arguments
  • rate is a Number that specifies the interest rate per period.
  • nPeriods is a positive Number that specifies the total number of payment periods in the annuity. The units used for specifying rate and nPeriods must consistent. For example, if nPeriods is the number of periods in months, then rate is a monthly interest rate.
  • payment is a Number or Currency that specifies payment to be made each period.
  • futureValue is an optional Number or Currency that specifies the future value or cash balance you want after you've made the final payment. If omitted, 0 is assumed.
  • type is an optional Number that specifies when payments are due. Specify 0 if payments are due at the end of the payment period, and 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.
  • Returns
    Number value
    Action
    PV returns a Number specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.
    Example
    Suppose that you want to buy a condo and can make payments of $1100 twice a month (24 annual payments). If the mortgage rates are 7 percent, and you want to pay off the condo in 10 years, what is the maximum loan that you can take out?
    PV (0.07 / 24, 10 * 24, -1100)
    Returns 189668 (rounded to the nearest dollar). Thus you can afford a loan of about $190,000. Notice that the payment argument is negative since you are paying out the money each month.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/