Forum Discussion

RyanParr's avatar
RyanParr
Qrew Assistant Captain
7 years ago

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. 

If a user selects the Depreciation Start Date to be June 28th, 2018, then on June 1st, 2018 the Remaining deprecation value will be adjusted.  And on July 1st, August 1st, Sept 1st etc. it will be adjusted again until it?s value hits zero. (So, the Month contained in the Depreciation Start date is all that really matters...hopefully i'm making sense here)

Please ask any questions - any help is greatly appreciated!