Each piece of Equipment deprecates it’s value every 36 months that it’s been used by a client. So every calendar month that goes by, the equipment loses 1/36 of its value.
When a piece of equipment is sent to a client, the Start field date is filled out to reflect the first of whatever month it should be applied to and the status is set to ‘Assigned’.
If a particular piece of equipment is returned to us, the Status field is set to ‘Returned’. It should no longer be deprecating any value.
I need help with a formula to come up Remaining Value field that takes into account the Status, any takers?
For bonus points also include formula help to come up with the End Date, based off of the "Start Date" and "Term"