Crystal Reports for Eclipse Designer Guide

SLN (cost, salvage, life)

Description
SLN returns a Number specifying the straight-line 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 Number that specifies the length of the useful life of the asset. It must not equal 0.
  • Returns
    Number value
    Action
    SLN returns a Number specifying the straight-line depreciation of an asset for a single period.
    Example
    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. The depreciation per year is:
    SLN (500000, 60000, 10)
    Returns 44000. Thus the depreciation per year is $44,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/