Deduction of value x% per year since purchase

J

Juulia

Is it possible to create a formula which will count the current value of an
item, based on the original price in one cell and the date of purchase in
another, deducting for example 25% per year?

Thanks
Juulia
 
M

meatshield

If you have the original price in Cell A1, the % of the value left
after a year (75% in your example) in B1, and the data of purchase in
cell C1, you can use the formula
=A1*(B1^DATEDIF(C1,TODAY(),"y"))
My example used
=100*(.75^4)) which returned 31.64.
Just make sure you format the cell as general, or number/currency,
because it would default to a date when I used the DATEDIF function
even though it was returning a number.
I hope that helps, please let me know if there is a problem.
 
Top