Need some some help with Excel financial functions

[Jimmy]

I am usually pretty good with this stuff, but this is pissing me off, so if anyone can tell me WTF I am doing wrong let me know.

I am trying to find ROR of a project with a 5 year lifespan, initial cost of $31k, and annual cost of $18k

So, I used =RATE(5,18000,31000)

...and it gave me an error. I tried using negative values for both numbers (since they are both out going payments anyway) and still got an error which was expected because I still get a positive value when they are divided. I did it by hand and got a ROR of 51%, so why won't Excel do it? Because the fraction is positive?

[DOUG]

Can do for you at the office tomorrow.  Should the 5 be 60 for months?
Can't recall anything else now, driving!

[Jimmy]

I am looking at annual ROR, so its n=5. I made annual cost negative and present cost positive and it worked and matched what I did by hand, so I'll just keep doing that for now. Thanks anyway.

[Krawler00]

 ??? :

[Jimmy]

??? :

I am done with the engineering economy now. I can post what I am doing now, Thermodynamics 2, if you want to see some shit so nerdy your wang will get smaller just from reading it.

[urdaddyjeep]

well then i guess you have nothing to worry about huh Jimmy

[Jimmy]

well then i guess you have nothing to worry about huh Jimmy

Nope, I'm good to go. 

[urdaddyjeep]

??? :

I am done with the engineering economy now. I can post what I am doing now, Thermodynamics 2, if you want to see some shit so nerdy your wang will get smaller just from reading it.

this is what i was talking about... when i said i guess you have nothin to worry about...

[Jimmy]

I know, and I was saying you are correct in making that assumption 

[urdaddyjeep]

hahahahaha............ guess the soon -to-be-wife isnt happy then

[Jimmy]

hahahahaha............ guess the soon -to-be-wife isnt happy then

Ha! And soon-to-be-wife ain't so soon. Mention that next time she's around and see what she says, lol. Probably something like "he spends too much money on that damn Jeep of his to even buy a ring and propose!" lol.

[BigJerm]

Ha! And soon-to-be-wife ain't so soon. Mention that next time she's around and see what she says, lol. Probably something like "he spends too much money on that damn Jeep of his to even buy a ring and propose!" lol.

got it made son!  {toast}

Ask Megan about getting engaged and she says, "I got way to many other things I would like to buy right now then have a diamond ring."