!cost,salvage,life,period,factor!!Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify!is the initial cost of the asset!is the salvage value at the end of the life of the asset!is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)!is the period for which you want to calculate the depreciation. Period must use the same units as Life!is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method)!
Converting this query range to a list query range may cause some macro code and/or formulas not to function properly. Do ...
cost,date_purchased,first_period,salvage,period,rate,basis!Returns the prorated linear depreciation of an asset for each ...
cost,salvage,life!Returns the straight-line depreciation of an asset for one period!is the initial cost of the asset!is the ...
cost,salvage,life,per!Returns the sum-of-years' digits depreciation of an asset for a specified period!is the initial cost ...
cost,salvage,life,period,factor!Returns the depreciation of an asset for a specified period using the double-declining balance ...
cost,salvage,life,period,month!Returns the depreciation of an asset for a specified period using the fixed-declining balance ...
cost,salvage,life,start_period,end_period,factor,no_switch!Returns the depreciation of an asset for any period you specify, ...
could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying ...
Could not create any records from the XML document located at "|0". Check to make sure that the document exists, the path ...