Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Depr

Use this function to calculate depreciation amounts.

Copy

Syntax

DEPR ("DB", Source, Rate/Life, "Compute"[, OpeningBalance], [Salvage])        

where:

  • Source is a symbol or value representing the value of the asset being depreciated.
  • Rate is either a number expressed as a percentage or number of periods. This must be a number between 0 and 1.
  • Compute indicates whether the period (PD) or year-to-date (YTD) depreciation is calculated (only YTD is supported currently). This parameter must be enclosed in double quotation marks.
  • OpeningBalance is a value repesenting the opening balance for the depreciation calculation.
  • Salvage is a value representing the salvage value of the asset.
Copy

Syntax example

DeprVal=DEPR("DB", A1000, 0.97, "YTD", 5000, 10)            
Published:

Depr

Use this function to calculate depreciation amounts.

Copy

Syntax

DEPR ("DB", Source, Rate/Life, "Compute"[, OpeningBalance], [Salvage])        

where:

  • Source is a symbol or value representing the value of the asset being depreciated.
  • Rate is either a number expressed as a percentage or number of periods. This must be a number between 0 and 1.
  • Compute indicates whether the period (PD) or year-to-date (YTD) depreciation is calculated (only YTD is supported currently). This parameter must be enclosed in double quotation marks.
  • OpeningBalance is a value repesenting the opening balance for the depreciation calculation.
  • Salvage is a value representing the salvage value of the asset.
Copy

Syntax example

DeprVal=DEPR("DB", A1000, 0.97, "YTD", 5000, 10)            
For an optimal Community experience, Please view on Desktop