Skip to main content
Skip table of contents

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.

SyntaxDEPRECIATION(ValueNode, DepreciationTime [, TimeLevel])
Parameter
  • ValueNode: Input node with the values that are depreciated over time. Must have the TimeLevel.
  • DepreciationTime: Node that contains the matching depreciation times for the assets in the value node. If a depreciation time is not given or zero, no depreciation value will be calculated for the asset. Depreciation times must also be neither negative nor non-integer.
  • TimeLevel: Name of the time level to which the depreciation times correspond. Optional parameter, if omitted, the depreciation times are assumed to be years.

Example 1

Input Investments =

Year

Value

20181000
2019400

Input DepreciationTime =

Periods

4

Output DEPRECIATION('Investments', 'DepreciationTime') =

Year

Depreciation Amount

2018250
2019250 + 100
2020250 + 100
2021250 + 100
2022100
20230

Example 2

Input Investments =

Year
Category
Investment
2019A2000
2019B1000


Input DepreciationTime =

Category
Periods
A2
B4

Output DEPRECIATION('Investitionen', 'DepreciationTime') =

Year
Category
Depreciation Amount
2019A1000
2019B250
2020A1000
2020B250
2021A0
2021B250
2022A0
2022B250
2023A0
2024

B

0
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.