Crystal Reports for Eclipse Designer Guide

Pmt

Description
Pmt returns a Number specifying the payment for an annuity based on periodic, fixed payments and a fixed interest rate.
Overloads
  • Pmt (rate, nPeriods, presentValue)
  • Pmt (rate, nPeriods, presentValue, futureValue)
  • Pmt (rate, nPeriods, presentValue, 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.
  • presentValue is a Number or Currency that specifies the present value or principal. That is, the amount that a series of payments in the future is worth now.
  • 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
    Pmt returns a Number specifying the payment for an annuity based on periodic, fixed payments and a fixed interest rate.
    Examples
    Suppose that you want to take out a $250,000 loan payable monthly over 15 years at an annual interest rate of 7 percent. The following formula returns your monthly loan payment. Note that the monthly interest rate is 0.07 / 12 and the number of months of the loan is 15 * 12.
    Pmt (0.07 / 12, 15 * 12, 250000)
    Returns the Number value -2247.07 (rounded to 2 decimals). The value is negative because it represents a payment out from you whereas the loan amount of $250,000 is positive because it represents a payment in to you.
    Now suppose that the payments are made at the beginning of the month instead of the end (as is the default). Your monthly loan payment is calculated as:
    Pmt (0.07 / 12, 15 * 12, 250000, 0, 1)
    Returns -2234.04 (rounded to 2 decimals). Note that your monthly payment is about $13 less each month than in the previous example where payments are made at the end of the month.
    Now suppose that you know that you'll receive $100,000 in 15 years so there is no need to fully pay off the loan; only to reduce the amount owed to $100,000 after 15 years. Note that the future value is negative since after 15 years you need to pay out $100,000 to clear the loan. Your monthly loan payment is calculated as:
    Pmt (0.07 / 12, 15 * 12, 250000, -100000)
    Returns -1931.58 (rounded to 2 decimals).
    Comments
    To find the total amount paid out over the whole loan, multiply the payment per period (the value returned by Pmt) by the total number of periods (nPeriods).



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