Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Measure Logic Functions > DEPRECIATION function
DEPRECIATION function
Last Updated 8/26/2008 1:05 PM
The DEPRECIATION function calculates the depreciation on an asset, based on the life of the asset and the residual value (if specified).
Format: DEPRECIATION('ASSET', 'LIFE', 'RESIDUAL_VALUE')
where
ASSET is the cost value of the asset.
LIFE is the life of the asset in periods.
RESIDUAL_VALUE is the residual value of the asset after depreciating for LIFE periods.
EXAMPLE:
We want to depreciate our new asset acquisitions over 12 months from date of purchase.
'Asset'
'Life'
'Depn' = Depreciation('Asset', 'Life')
In this example, we are not specifying a residual value, so assuming a value in the measure 'Life' of 12, and an 'Asset' value of 50000, the 'Depn' would contain a value of 4166.67 for each period.
If we take the same example, but this time we want a residual value of 10000, we can use the following format.
'Asset'
'Life'
'Residual'
'Depn' = DEPRECIATION ('Asset', 'Life', 'Residual')
Now because we are assuming we will have a residual value at the end of the 'Life' of the 'Asset', our depreciation is adjusted accordingly, and we will have a depreciation figure of 3333.33 for each period.
See Also
PREVIOUS function
SUM function
MAX function
MIN function
INT function
ROUND function
ROUNDUP function
ROUNDDOWN function
IF Function
SWITCH Function
| 
Page URL: