Sorry for the frustration..... And lack of knowledge on my part. Thought that is what we are trying to give and get here. Maybe , maybe not?
I do thank everyone for there time and extreme effort in helping me out.
Skip
I'm sorry but I am trying to learn just everyone else here. It's obvious by your tone that you no everything and have run out of patience. So, thank you for your help. Have a nice weekend, I will try with someone else.
Skip
I thought i was being clear....
I need the replacement cost @4% per year of the life expectancy
Thought my example was clear....
purchase price x replacement date x 4% each year = Replacement cost.....
Doesn't work
Example of What I need
Date Purchased - Cost - Life Exp - Repl Date - Repl Cost
7/99 1000 6 yrs 2005 ?????
Question mark is the value I'm trying to find, @ 4% each year. I need a formula for this.
Thank You
Setting up capital budget workshee, I need to take the purchase date of 1 column and the replacement date of another. Then come up with replacement cost in the last column. I would like to add 4% to every year.
So it would be like this purchase 1999
Replacement date 2004
Add 4% to each year...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.