Crystal Reports for Eclipse Designer Guide

CumPrinc (rate, nPeriods, presentValue, startPeriod, endPeriod, type)

Description
CumPRINC returns the total paid towards the principal on a loan, between the start and end periods specified.
Arguments
  • rate is a positive, non-zero number that specifies the interest rate per period.
  • nPeriods is a positive number specifying the total number of payment periods.
  • presentValue is a positive number or currency representing the total value of the loan.
  • startPeriod is a positive number specifying the first period to be included in the calculation.
  • endPeriod is a number, greater than or equal to startPeriod, specifying the last period to be included in the calculation. The end period cannot be greater than the number of periods.
  • type is a number specifying when the payments are made. 0 = end of the payment period, 1 = start of the payment period.
  • Returns
    Currency value
    Action
    CumPRINC returns the total paid towards the principal on a loan, between the start and end periods specified. This function sums the value returned from PPMT for the periods specified. The value will be negative since it represents a sum of payments.
    Examples
    Suppose you have taken out a $5000, six-year loan with an annual interest rate of 8.3% with semiannual payments paid at the end of the month.
    CumPRINC(0.083/2,6*2,5000,3,4,0)
    Returns -$730.57 as the total principal paid off during the second year of the load. Note that both the interest rate and the duration have to be written on a per period basis.
    CumPRINC(0.083/2,6*2,5000,1,12,0)
    Returns -$5000 since over the duration of the loan you have paid off the entire principal. Note that both the interest rate and the duration have to be written on a per period basis.
    Comments
    This function is designed to work like the Excel function of the same name.



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