Author |
Message |
Zachsmom
Member
07-13-2000
| Tuesday, April 27, 2004 - 3:43 pm
I am having a hard time with solving for rate...any help would be greatly appreciated! pv*(1+rate)^(nper) + pmt(1+rate*type)*(((1+rate)^(nper)-1)/(rate))+fv=0
|
Rupertbear
Member
09-19-2003
| Tuesday, April 27, 2004 - 3:49 pm
Hi, Zmom...I know someone who has his PhD in Math at U. of Arcadia in N.S. I emailed it to him, so hopefully I'll get a reply back soon.
|
Draheid
Moderator
09-09-2001
| Tuesday, April 27, 2004 - 4:05 pm
Could it be here at mathforum.org?
|
Weinermr
Member
08-18-2001
| Tuesday, April 27, 2004 - 4:06 pm
Zmom, I found a site that discusses these calculations. It says that there is no single formula for the interest rate calculation, that the answer has to be found using related formulas through a series of iterations. Both Excel and Visual Basic have functions to perform these iterations. Here is one of several pages I reviewed. Investment Formulas Check the section under Interest Rate. I've found several sources for this information, but this one seemed the most helpful. Good luck.
|
Zachsmom
Member
07-13-2000
| Tuesday, April 27, 2004 - 4:20 pm
Thanks Rupertbear!! Let me know if he has any hints..or a solution! Draheid..I am off to check out the site... Weinermr..awesome site! Thanks!!!! I am actually trying to reverse engineer the rate() function in excel, we need the function on our SQL Server side not on the client side. I have reversed the pmt() function ... <i love my job i love my job i love my job>
|
Landi
Member
07-29-2002
| Tuesday, April 27, 2004 - 5:03 pm
math is not my speciality - next time ask me a constitution question!!
|
Weinermr
Member
08-18-2001
| Tuesday, April 27, 2004 - 5:43 pm
I shoulda coulda been a math professor. In another life perhaps.
|
Mocha
Member
08-12-2001
| Tuesday, April 27, 2004 - 5:46 pm
Looks like gibberish to me but then again I can't add 1 + 1. Never too late Weiner.
|
Weinermr
Member
08-18-2001
| Tuesday, April 27, 2004 - 5:55 pm
True Mocha, I know. Thanks. I'm pursuing ways of advancing myself in my current chosen field of trust and estate administration / estate tax / fiduciary income tax, so there's still a lot more I can do. There is always more to learn. Tax law changes frequently. Besides, what I would REALLY have wanted to be, if I had the talent to do so, would to have been an orchestra conductor. Unfortunately, my love of music is greater than my abilities in that area. P.S. The answer is 2 
|
Mocha
Member
08-12-2001
| Tuesday, April 27, 2004 - 6:09 pm
Welllll I can call you Maestro. 2? Are you sure?
|
Babyruth
Member
07-19-2001
| Tuesday, April 27, 2004 - 6:29 pm
Hi Professor MaestroWeiner 
|
Rupertbear
Member
09-19-2003
| Tuesday, April 27, 2004 - 6:38 pm
Or Weinermeistermeisterweiner....sort of a take off of the Bugermeistermeisterburger from Rudolph ;)
|
Kaykay
Member
01-21-2004
| Tuesday, April 27, 2004 - 6:39 pm
Oh my, god bless you for even knowing what the heck tha's all about. I'm better with Muni bonds and the Bond Market 
|
Juju2bigdog
Member
10-27-2000
| Tuesday, April 27, 2004 - 10:59 pm
Weinermr, are you sure the answer is not closer to pi?
|
Weinermr
Member
08-18-2001
| Tuesday, April 27, 2004 - 11:29 pm
It could be Juju. I'll have to get out my slide rule, and check it out. Rupertbear, that's way too many letters for me to type! Kaykay, I admire your knowledge of the bond market. I don't think that's something I could every specialize in. Hi BR!!
|
Jed245
Member
11-01-2002
| Wednesday, April 28, 2004 - 3:55 am
A rough guess... FV = (PMT*(1+rate*type)*(1-(1+ rate)^NPER)/rate)-PV*(1+rate)^NPER NPER = LOG10((PMT*(1+rate*type)-FV*rate)/(PMT*(1+rate*type)+PV*rate))/ LOG10(1+rate) PMT = (rate*(FV+PV*(1+ rate)^NPER))/((1+rate*type)*(1-(1+ rate)^NPER)) PV = (PMT*(1+rate*type)*(1-(1+rate)^NPER)-rate*FV)/(rate*(1+rate)^NPER) rate = Must be solved using iterative processes since it is an equation of variable order depending on the value of NPER. Jed. :o)
|
Rupertbear
Member
09-19-2003
| Wednesday, April 28, 2004 - 7:54 am
Lol,Herr Weiner Wow, Jed...you listen to Metallica and you're still that smart! hee hee hee ;) Zachsmom...still haven't heard back from the prof. Um, they are in the process of moving so he's busy but I can't believe he doesn't check his personal e-mail. *sigh*...Typical absent-minded scholar ;) just a little tease,'cos I know there are so many at this site )
|
Zachsmom
Member
07-13-2000
| Wednesday, April 28, 2004 - 8:55 am
Thanks Jed! It's going to be a pain, but having NPER really helps! Rupert..lol..thanks for helping..if he answers today..i will eternally greatful!
|
Bigd
Member
09-13-2001
| Wednesday, April 28, 2004 - 9:13 am
I am not a math genius, however, I was able to read this thread.
|
Jed245
Member
11-01-2002
| Wednesday, April 28, 2004 - 10:04 am
Rupertbear METALLICA ROCKS WOOOHOOOO!!! *bangs his head into the wall* WOOO!! :o)
|
Rupertbear
Member
09-19-2003
| Wednesday, April 28, 2004 - 12:50 pm
LMAO! You have a great sense of humour, kiddo !
|
Jed245
Member
11-01-2002
| Thursday, April 29, 2004 - 12:02 am
heheh Thanks Rupertbear. :o) The concert was awesome by the way. Hmm lemme see last time I went to a metallica concert I believe I body slammed bob. hmmm.....
|
Rupertbear
Member
09-19-2003
| Thursday, April 29, 2004 - 7:05 am
Might be an idea to get some insurance on yourself, before ya go, Jed ;) The prof's wife called a few minutes ago Zachsmom. Murphy's Law at work here. Their server has been down for two days but she said he'll look at the problem at work today but I said it might be too late by then but he'll have a look-see, if he can.
|
Zachsmom
Member
07-13-2000
| Thursday, April 29, 2004 - 6:24 pm
it's never too late Rupert! I really appreciate your (and the professors) help! I have been working on this off and on for a while now, and I am stumped!
|
Rupertbear
Member
09-19-2003
| Thursday, April 29, 2004 - 7:01 pm
Well, I'll send him another email, Zmom...the guy is somewhat of a procrastinator. Lol, it seems funny referring to him as a prof, 'cos he's at least 10 yrs younger than me 
|
Zachsmom
Member
07-13-2000
| Thursday, April 29, 2004 - 7:10 pm
Again, thank you! I tried going to a math forum, but they talk way over my head! LOL! (i am almost afraid to ask how old the prof is)
|
Rupertbear
Member
09-19-2003
| Thursday, April 29, 2004 - 7:12 pm
He's 36. Got his PhD about 8 yrs ago. He also taught at Cambridge & Durham in England.
|
Zachsmom
Member
07-13-2000
| Thursday, April 29, 2004 - 7:18 pm
and you said he had a wife huh? are they happy? 
|
Rupertbear
Member
09-19-2003
| Thursday, April 29, 2004 - 7:20 pm
Lmao...ya cute, Z Yeah...up to their eyes in it with 3 little ones under 5 yrs of age! lol
|
Ketchuplover
Member
08-30-2000
| Wednesday, May 12, 2004 - 3:23 pm
2+2=4
|
Wargod
Member
07-16-2001
| Wednesday, May 12, 2004 - 3:25 pm
Woo hoo, Ketch is doing my type of math!
|
Rupertbear
Member
09-19-2003
| Wednesday, May 12, 2004 - 3:29 pm
Rofl....no fair that was my answer! Well Zachsmom...I will probably never get an answer from him at this rate now. You won't believe this litany coming up but: 1) Their internet went down the day after I emailed the question. 2) They moved last weekend and still don't have a phone. The phone they did have was intermittent (dial-up service for computer). 3) He's going to England next week for his annual two week math symposium...duh...how exciting. ;) 4) He surely could have emailed me back from the university, so he is a rude scruff & I shall tell him so at Christmas.
|