Hello,

What do you think is the best formula to calculate in Excel an extimated
value in january 1st 2008 of the used car bought new in july 1st 2004, only
having the following data of it?

(today value - new: $9900)
today's value - used car bought new in july 1st 2004: $6200
today's value - used car bought new in january 1st 2004: $5700
today's value - used car bought new in july 1st 2003: $5200

I would like to find a formula that doesn't return a negative value if I use
it for example on an extimation on 1/1/2100 instead of 1/1/2008, like the
standard forecast formula do.

Any ideas?

Thanks in advance
Luci