Crystal Reports for Eclipse Designer Guide

AmorDEGRC

Description
AmorDEGRC returns the depreciation of an asset in the accounting year specified.
Overloads
  • AmorDEGRC (cost, purchaseDate, firstPeriodEndDate, salvage, period, rate)
  • AmorDEGRC (cost, purchaseDate, firstPeriodEndDate, salvage, period, rate, basis)
  • Arguments
  • cost is a positive number or currency specifying the initial cost of the asset.
  • purchaseDate is a Date or DateTime specifying when the asset was purchased.
  • firstPeriodEndDate is a Date or DateTime specifying the end of the first period. This date must be after the purchase date.
  • salvage is a non-negative number or currency specifying the value of the asset after its useful life. This number must be equal to or less than the cost of the asset.
  • period is a non-negative number specifying which period the depreciation should be calculated for.
  • rate specifies the rate at which the asset depreciates.
  • basis is an optional number specifying the day basis system to use. The following types are supported:
    • 0 - American 30/360 (default)
    • 1 - actual/actual
    • 2 - actual/360
    • 3 - actual/365
    • 4 - European 30/360
  • Returns
    Currency value
    Action
    AmorDEGRC returns the depreciation of an asset in the accounting year specified. The accounting years are aligned with the firstPeriodEndDate. A depreciation factor is applied to the rate depending on the lifetime (1/rate) of the asset. The answer is rounded to the nearest whole number.
    lifetime (1/rate)
    depreciation factor applied
    less than or equal to 4
    1.5
    greater than 4 but less than 6
    2
    greater than or equal to 6
    2.5
    Examples
    Suppose a machine is purchased for $1500 on April 15, 2000. The machine can be sold for scrap at a price of $250 and depreciates at 10% per year. If the accounting periods start on January 1st of each year, then the first period after the purchase date is January 1, 2001. An actual/actual basis is used.
    AmorDEGRC(1500,DateValue(2000,4,15),DateValue(2001,1,1),250,0,.1,1)
    Returns $267 as the depreciation for the period of time between April 15, 2000 and December 31, 2000. Since the lifetime is ten years, the depreciation rate is 2.5 x 0.1 = 0.25.
    AmorDEGRC(1500,DateValue(2000,4,15),DateValue(2001,1,1),250,1,.1,1)
    Returns $308 as the depreciation during the first full year.
    AmorDEGRC(1500,DateValue(2000,4,15),DateValue(2001,1,1),250,6,.1,1)
    Returns $43 as the depreciation for the sixth full year.
    Comments
    This function is similar to 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/