Accounting family
| Accounting And Tax category | Home |
Functions used in Accounting and Tax.
| Component | What the name means |
|---|---|
| Depreciate | Depreciate |
| DepreciatedValue | Calculate the Depreciated Value |
| DepPoolWIP | Operate a Depreciation Pool using the WIP method |
| DepPoolRatio | Operate a Depreciation Pool using the Ratio method |
| DepPool | Operate a Depreciation Pool using either the WIP or the Ratio method |
| DepreciatePer | Depreciate Periodic |
| DepreciateGrowPer | Depreciate Periodic |
| DepreciateFcstPer | Depreciate Periodic |
| DepreciateIdxPer | Depreciate Periodic |
| LIFOPrice | Calculate the average price of a stock movement using LIFO (last in first out) |
| LIFOCalc array function | Does a full LIFO calculation to output all the columns of results |
There are two types of depreciation function in this family:
- Basic depreciation functionality is provided by Depreciate and DepreciatedValue. This pair of functions calculates the depreciation for an asset that has a single date at which depreciation starts, and you know the value of the asset to be depreciated. All the comon types of depreciation method are catered for.
- Depreciation Pooling, using a WIP account that is capitalised and depreciated possibly in stages, is provided by DepPool, DepPoolRatio, and DepPoolWIP.