Question How to set monthly depreciation

[Vector891]

Hi,

Does anyone know if it is possible to set an access database to take a depreciation value of lets say £10.00, and subtract this from the current value every month?

So far my database has a form where you can input the depreciable life, purchase price, current value and total depreciation. However the date and amount of depreciation has to be added manually into a data table for the text boxs to calculate how much it has depreciated and the current value.

 

[jdraw]

Have you tried google?

see http://en.wikipedia.org/wiki/Depreciation for some details and algorithms.

 

[Vector891]

I did try google, and I did see that page which helped me understand what exactly depreciation was.

However it doesn't shed any light on how to configure my database to reduce the current value of an asset at specific times throughout a year

 

[jdraw]

What exactly do you need to shed some light on the issue? Is you problem with
a)Depreciation or
b) Database?

You should review this tutorial if b) is the issue.

Consider something that you bought with initial cost of $1000.
If it depreciates $10/month, then it will be worth $0 after 100 months.

PresentValue = InitialValue - ($10 * NumberOfMonthsOfOwnership)

0 = 1000 - (10*100)

 

[MarkK]

This is basically a memorized transaction right? You can run code on startup that checks for memorized transactions, and enters them as required. Check for the last instance of the transaction, if it hasn't been entered yet, and the previous one is more than a month away, then enter the next one.

So is it possible? Absolutely!