EBME Forums
Team effort from my guys:

Free application with customisable 'Depreciation Curves' to determine the value of a device after x years.

Use it if you want... link to follow


Model Configuration
To make it easily configurable depreciation models are saved inside an xml file.
This holds the parameters, model names and descriptions. Custom parameters, however, are stored as User settings (so each user may set their own custom parameters).

Other Settings
The range of purchase date years in the drop-down is dynamic and ranges from the current year to a number of years in the past. This number of years range can be changed with the standard Application settings (in the .config file)

The minimum and maximum lifespans, in the same way, are set with Application settings





[img:left][/img]

You can optionally call the app with parameters in the following format;

“Asset Value Calculator.exe PP=1000 YP=2010 L=10 M=ModelCustom PS=100 PE=20”

Where:
PP : Purchase Price
YP : Year of Purchase
L : Lifespan
M : Depreciation Model
PS : Percentage Start
PE : Percentage End

What about factoring in "Accumlated Maintenance Expenditure" ... and "BER Level" (percentage), and what-have-you? think
This software, although described as 'asset value calculator' can (and is) used to determine the BER limit (Beyond Economic Repair for non forces guys).

Obviously if your using the 100% linear depreciation model in there, then thats more a financial 'Value' rather than the BER which we use of 65/0 or 65/5

Because its not linked to any database system, accumalated maintenance expenditure is out i'm afraid, its just a simple app.

We did leave in some command line paramaters so it could play nice with your own applications though.

Its certainly not application of the centuary, but it might help some of those engineers who have that mentality of 'Repair at all costs' or help take out any indecision around repair (live by the sword, die by the sword, this is the sword)

We used a spreadsheet previously, but this is a bit nicer smile



is there a link yet ?please
With a bit of tweaking it might be useful to incorporate estimated replacement costs by utilising the standardised NHS Indices for inflation since purchase? Just a thought!

https://improvement.nhs.uk/resources/economic-assumptions-1617-to-2021/

Perhaps you need to think about working up something like this for each item on your equipment inventory. smile

With reference to the above post some of the values indicated depend upon global variables (set up elsewhere) such as:-

Price inflation % (general annual inflation rate)
- typically 3 %

Depreciation % (write-down per year)
- typically 7 %

Equipment inflation % (annual increase in replacement cost)
- typically 3 %

Equipment life years (expectancy)
- typically 20 years

PS: I posted that image in the Gallery as I could not find the Attachment Manager at this thread!
© EBME Forums: Biomedical and Clinical Engineering Discussion Forums.