not your typical depreciation question

[excelnewbie1]

After days of researching I am at a loss. I need to work from a depreciation schedule of 10,000 assets. What I know is the date of purchase, asset, cost. I am valuing the assets as of 2012. I am an appraiser so I need to work a formula like this:
a one year old computer would be worth 50% of cost
a two year old computer would be worth 40% of cost
a three year old computer would be worth 30% of cost and so on possible up to 15 years....so is there a way to do a formula that can handle this computing???

 

[JoeMo]

After days of researching I am at a loss. I need to work from a depreciation schedule of 10,000 assets. What I know is the date of purchase, asset, cost. I am valuing the assets as of 2012. I am an appraiser so I need to work a formula like this:
a one year old computer would be worth 50% of cost
a two year old computer would be worth 40% of cost
a three year old computer would be worth 30% of cost and so on possible up to 15 years....so is there a way to do a formula that can handle this computing???

Welcome to the Board. From what you have posted it appears that the value is zero after six years. So anything from 7 to 15 years is worthless? Would a 6-month old computer be worth 75% of cost or ...? Your depreciation schedule does not appear to be linear so what is it (X% declining balance or ...)?