Home Articles Downloads Forum Products Services Seminar Contact
Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Apr 2001
Posts: 260
Likes: 3
Master
OP Offline
Master
Joined: Apr 2001
Posts: 260
Likes: 3
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

Joined: Feb 2004
Posts: 14,324
Likes: 22
Super Hero
Offline
Super Hero
Joined: Feb 2004
Posts: 14,324
Likes: 22

What about factoring in "Accumlated Maintenance Expenditure" ... and "BER Level" (percentage), and what-have-you? think

Joined: Apr 2001
Posts: 260
Likes: 3
Master
OP Offline
Master
Joined: Apr 2001
Posts: 260
Likes: 3
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




Last edited by Joe Emmerson; 07/06/15 4:51 PM.
Joined: Jun 2001
Posts: 246
Master
Offline
Master
Joined: Jun 2001
Posts: 246
is there a link yet ?please


ERRATIC MEANS STATIC SO BE ERRATIC AND NOT STATIC
WE ARE ALL IN THE NHS AND THIS IS
"ERRATIC AND STATIC"
Joined: Feb 2003
Posts: 362
Likes: 3
Sage
Offline
Sage
Joined: Feb 2003
Posts: 362
Likes: 3
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/

Joined: Feb 2004
Posts: 14,324
Likes: 22
Super Hero
Offline
Super Hero
Joined: Feb 2004
Posts: 14,324
Likes: 22

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!


If you don't inspect ... don't expect.

Moderated by  DaveC in Oz, RoJo 

Link Copied to Clipboard
Who's Online Now
3 members (John Sandham, QiMed, 1 invisible), 205 guests, and 14 robots.
Key: Admin, Global Mod, Mod
Newest Members
Ana, daryl sebate, LabRat, kman247, jbuchan
9,828 Registered Users
Forum Statistics
Forums25
Topics10,731
Posts72,379
Members9,828
Most Online5,980
Jan 29th, 2020
Powered by UBB.threads™ PHP Forum Software 7.7.5