Crystal Reports for Eclipse Designer Guide

SYD (cost, salvage, life, period)

Description
SYD returns a Number specifying the sum-of-years' digits depreciation of an asset for a single period.
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.
  • 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.
  • Returns
    Number value
    Action
    SYD returns a Number specifying the sum-of-years' digits depreciation of an asset for a single period.
    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 as follows:
    SYD (500000, 60000, 10, 1)
    Returns 80000. The first year's depreciation is $80,000.
    SYD (500000, 60000, 10, 4)
    Returns 56000. The fourth year's depreciation is $56,000.
    SYD (500000, 60000, 10, 10)
    Returns 8000. The final year's depreciation is $8,000.



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