Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with formula for Capital replacement Cost 3

Status
Not open for further replies.
jeepdakota

jeepdakota

Technical User
Oct 3, 2003
12
US
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
Come up with Replacement Cost for 2004 for that particular item.

Hope you understand this, Thanks for any help
 
Sort by date Sort by votes
A2 = Amount
B2 = Purchase date
C2 = Replacement Date

=A2*(POWER(1.04,C2-B2))

Jim
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
=B1*(POWER(1.04,C1))



Blue [dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
THat was assuming that you had 1000 (Purchase Price in B1 and 6 (The number of years in C1.



Blue [dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
The first one would do if you were only inputting the year.
This will work if you are using the dates.


=B2*POWER(1.04,((D2-A2)/365))

Jim
 
Upvote 0 Downvote
How are your cells formatted?
And can you give cell locators with data?

Jim
 
Upvote 0 Downvote
Yes, Skip I did, unfortunately that didn't work either
 
Upvote 0 Downvote
Skip I just sent you my worksheet.

Jd, do you have an email, I could send it to you also?
 
Upvote 0 Downvote
Jeep, Jeep, Jeep,

I need to know WHAT YOU EXPECT THE REPLACEMENT COST TO BE!

You keep saying, IT'S WRONG!

Well TELL ME HOW YOU KNOW IT'S WRONG!

Am I off by a penny, a dime, a dollar.

Give,

x Purchase Cost
y Purchase Date
z Replacement Date

WHAT DO YOU EXPECT THE REPLACEMENT COST TO BE????????

Skip,
Skip@TheOfficeExperts.com
 
Upvote 0 Downvote
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.....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
302
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
174
TomSalvato
TomSalvato
Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
195
SkipVought
S
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
211
SkipVought
S
cneill
  • Locked
  • Question
Hi, I need some help with Pre an
Replies
7
Views
174
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top