SQL Widget - dcT Depreciation

This SQL grid widget displays asset name, purchase date, the age of the asset and the current value of the asset. The age of the asset is calculated by taking the current date minus the purchase date; the current value is calculated based on exponential depreciation where current value = purchase price (1 - depreciation rate)age assuming a depreciation rate of 20%. 

  • Created by: Alexis Layne
  • Date Created: Thursday, 23 July 2020

Download attachments:

SQL
Read 27 times

Related items