Crystal Reports for Eclipse Designer Guide

VDB

Description
VDB returns the total depreciation between the start and end periods specified.
Overloads
  • VDB (cost, salvage, lifetime, startPeriod, endPeriod)
  • VDB (cost, salvage, lifetime, startPeriod, endPeriod, depreciationFactor)
  • VDB (cost, salvage, lifetime, startPeriod, endPeriod, noSwitch)
  • VDB (cost, salvage, lifetime, startPeriod, endPeriod, depreciationFactor, noSwitch)
  • Arguments
  • cost is a number or currency that specifies the initial cost of the asset.
  • salvage is a number or currency that specifies the value of the asset at the end of its useful life.
  • lifetime is a positive number specifying the number of periods in the lifetime of the asset.
  • startPeriod is a positive number specifying the starting point of the calculation for the depreciation total. The startPeriod is not included in the calculation.
  • endPeriod is a number specifying the last period that is used in the calculation of the depreciation. This number must be equal to, or greater than the start period, and cannot be larger than the lifetime of the asset.
  • depreciationFactor is a non-negative number specifying the rate at which the asset depreciates. The default value is two, based on the double declining balance method.
  • noSwitch is a boolean value determining if the function switches to a straight line depreciation if the declining balance method is less than the straight line method. The default FALSE value causes VDB to switch to the linear method while a TRUE value forces the declining balance method to be used.
  • Returns
    Currency value
    Action
    VDB returns the total depreciation between the start and end periods specified. If noSwitch is FALSE, then the sum of the depreciations over the lifetime of the asset will sum to the difference between the cost and the salvage.
    The switch between methods occurs when the remaining depreciation room, divided by the number of periods left in the lifetime, is more than the value calculated using the declining balance method. Depreciation room is the salvage and cumulative depreciation subtracted from the cost of the asset.
    Examples
    Suppose a machine is purchased for $1000, and has a salvage value of $250 and depreciates using the double-declining method. The lifetime is 10 periods (years).
    VDB (1000,250,10,0,5,2,FALSE)
    Returns $672.32 as the depreciation for the first 5 years of the machine's lifetime. The value is the same in this situation for noSwitch=TRUE.
    VDB (1000,250,10,5,6,1,FALSE)
    Returns $67.68 (rounded to the nearest cent) as the depreciation in only the sixth year of the machine's lifetime. The value calculated with noSwitch=FALSE is $59.05 (rounded). This shows that in the first case, VDB has switched to the linearly declining method, which means that all later periods will also have a depreciation of $67.68 per 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/