Crystal Reports for Eclipse Designer Guide

DDB

Description
DDB returns a Number specifying the depreciation of an asset for a specific time period, using the double-declining balance method or some other method as specified by the factor argument.
Overloads
  • DDB (cost, salvage, life, period)
  • DDB (cost, salvage, life, period, factor)
  • Arguments
  • cost is a Number or Currency that specifies the initial cost of the asset. The value is non-negative and greater than or equal to salvage.
  • salvage is a Number or Currency that specifies the value of the asset at the end of its useful life. The value is non-negative.
  • life is a positive Number that specifies the length of the useful life of the asset.
  • period is a Number that specifies the period for which asset depreciation is calculated. The value is positive and less than or equal to life. The arguments life and period must have the same units.
  • factor is an optional positive Number that specifies the rate at which the balance declines. If omitted, 2 (double-declining method) is assumed.
  • Returns
    Number value
    Action
    DDB returns a Number specifying the depreciation of an asset for a specific time period, using the double-declining balance method or some other method as specified by the factor argument.
    Examples
    Suppose a company purchases a fleet of cars for $500,000. The cars have a lifetime of 10 years and a salvage value of $60,000. They are depreciated using the double-declining method.
    DDB (500000, 60000, 10, 1)
    Returns 100000. The first year's depreciation is $100,000.
    DDB (500000, 60000, 10, 4)
    Returns 51200. The fourth year's depreciation is $51,200.
    DDB (500000, 60000, 10, 10)
    Returns 7108.86 (rounded to the nearest cent). The final year's depreciation is $7,108.86.



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