Help with formula for Capital replacement Cost 3

[jeepdakota]

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

 

[SkipVought]

Hi,

Wouldn't the formula be...

=(ReplacementDate-PurchaseDate)/365*1.04

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jdhilljr]

A2 = Amount
B2 = Purchase date
C2 = Replacement Date

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

Jim

 

[SkipVought]

... of course, you'd have to factor that by the purchase cost...

=PurchaseCost*(ReplacementDate-PurchaseDate)/365*1.04

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jeepdakota]

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

 

[bluedragon2]

=B1*(POWER(1.04,C1))



Blue

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

THat was assuming that you had 1000 (Purchase Price in B1 and 6 (The number of years in C1.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

oop....

=PurchaseCost*(1+((ReplacementDate-PurchaseDate)/365)*0.04)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jdhilljr]

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

 

[jeepdakota]

Sorry, guys, but none of these work.....Challenge

 

[jdhilljr]

How are your cells formatted?
And can you give cell locators with data?

Jim

 

[jeepdakota]

JD

What are you using as D2 and A2??

 

[SkipVought]

Give us an example of each parameter and the expected result.

BTW, did you use my latest...

=PurchaseCost*(1+((ReplacementDate-PurchaseDate)/365)*0.04)

?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jeepdakota]

Yes, Skip I did, unfortunately that didn't work either

 

[SkipVought]

JEEP!!!!!!!!!

com'on!

EXAMPLE PLEASE!!!!!!!

INPUT/OUTPUT DATA!!!!!


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jeepdakota]

Skip I just sent you my worksheet.

Jd, do you have an email, I could send it to you also?

 

[jeepdakota]

Thank You guys for your help. In a bind here

 

[SkipVought]

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

http://www.TheOfficeExperts.com

 

[SkipVought]

BTW,

I did not need your workbook.

I JUST NEEDED AN EXAMPLE OF THE ABOVE STATED PARAMETERS!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jeepdakota]

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.....