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