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%.
SQL Widget - Depreciation
Additional Info
- Date Created: Thursday, 23 July 2020
- Category: Items Inventory
Download attachments:
- depreciation_rate.txt (23 Downloads)
