DEPRECIATION
Basic Overview
Description | This function calculates the linear depreciation values of the ValueNode according to the matching depreciation times in the DepreciationTimesNode on the given time level. The result will be the depreciation value for each time period, not the remaining book value of the asset that is depreciated. The DepreciationTimesNode must not have any time level. |
Syntax | DEPRECIATION(ValueNode, DepreciationTime [, TimeLevel]) |
Parameter |
|
Example 1
Input Investments =
Year | Value |
---|---|
2018 | 1000 |
2019 | 400 |
Input DepreciationTime =
Periods |
---|
4 |
Output DEPRECIATION('Investments', 'DepreciationTime') =
Year | Depreciation Amount |
---|---|
2018 | 250 |
2019 | 250 + 100 |
2020 | 250 + 100 |
2021 | 250 + 100 |
2022 | 100 |
2023 | 0 |
Example 2
Input Investments =
Year | Category | Investment |
---|---|---|
2019 | A | 2000 |
2019 | B | 1000 |
Input DepreciationTime =
Category | Periods |
---|---|
A | 2 |
B | 4 |
Output DEPRECIATION('Investitionen', 'DepreciationTime') =
Year | Category | Depreciation Amount |
---|---|---|
2019 | A | 1000 |
2019 | B | 250 |
2020 | A | 1000 |
2020 | B | 250 |
2021 | A | 0 |
2021 | B | 250 |
2022 | A | 0 |
2022 | B | 250 |
2023 | A | 0 |
2024 | B | 0 |