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.

Syntax

DEPRECIATION(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

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




JavaScript errors detected

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

If this problem persists, please contact our support.