RyanParr
7 years agoQrew Assistant Captain
Depreciating Value by Month
I need help with a formula that depreciates the value of an item each month until it's value hits $0.00
I have a single table that contains these fields:
- Depreciation Start Date (Date Field) i.e. 6/28/2018
- Depreciation Term (Numeric) i.e. 36 months
- Item Cost (Currency) i.e. $100
- Monthly Deprecation Value (Currency): Item Cost / Depreciation Term i.e. $2.77
- Remaining Deprecation Value (Formula ? Currency): This is the field that should display the remaining value, and it should stop at $0.
Please ask any questions - any help is greatly appreciated!