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

 

[jdhilljr]

I sent back the spreadsheet. All had the right idea. Mine didnt work at first because it was based on diff in years.
Skips didn't work because his was simple interest and the cells were different. Blue's didn't work because the time frame was in days.

We were all comparing apples to oranges.

Jim

 

[SkipVought]

Hsy Gang,

Actually jdhilljr got it before me & blue -- several post back

jdhilljr (Programmer) Oct 3, 2003
This will give you the results.
Make sure you format the cell for currency.


=G4*POWER(1.04,((I4-F4)/365))
Jim

and Jeep has not responded since that time...

except, all of us got STARS

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jdhilljr]

I know one thing if I need to post a question.

Include the word challenge and watch out.

Jim

 

[jeepdakota]

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.

 

[jdhilljr]

No problem you gave me my lunch time teaser.

And you threw out the word "challenge".

Beside any good programmer lives on caffeine and sugar
so they don't relax much.

Jim

 

[SkipVought]

Why is it that

CHALLENGE

evokes such an irrational response?


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Zathras]

Maybe we're all challenged?

 

[SkipVought]

A-"Person of neutral gender"!

My PC affirmation! ;-)


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com