Originally Posted by
206 jock
The 'problem' with valuing most helicopters (let's exclude Robinsons as as different set of rules apply to them due to the 12 year thing) is that the value of the machine is aligned to a few different factors...a bit of age, a bit of upcoming maintenance, a bit of condition and a massive amount of component times remaining: but even this is further affected by the age of the components.
I am in full support of this statement. I am not sure if there are any software valuation tools out there that can compute the correct value, taking all those factors into consideration. It would be incredibly complex, and require a large number of input variables. Probably the holistic judgment of an expert (or the wisdom of crowds a.k.a. "the market") in this case yields better results than the best algorithm people have come up with.
Even for the Robinsons, the formula that only attempts determines that replacement value for the first 12 years or 2,200 HRS period would be at least as complex as this (and my still be inaccurate at that):
=(Q$85/(1+Q$95)^L81-(J81/2200-INT(J81/2201))*Q$93-IF((L81/12-INT(L81/12.01))*2200>(J81-INT(J81/2201)*2200);1;0)*((1-(J81/2200-INT(J81/2201)))-(1-(L81/12-INT(L81/12.01))))*Q$92-(J81/4400-INT(J81/4401))*Q$94)*W$86
With the variables being current new price, past annual average price increase, age, TTSN, non-utilisation-related depreciation, cost of 12-year inspection, and cost of 2,220 HRS overhaul, cost of replacing 4,400 HRS time-limited components.
So, yes, good luck!