TVCH FORUMS HOME . JOIN . FAN CLUBS . ABOUT US . CONTACT . CHAT  
Bomis   Quick Links   TOPICS . TREE-VIEW . SEARCH . HELP! . NEWS . PROFILE
Any Math Geniuses?

The TVClubHouse: General Discussions: 2004 May - July: Any Math Geniuses? users admin

Author Message
Zachsmom
Member

07-13-2000

Tuesday, April 27, 2004 - 3:43 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
Could it be here at mathforum.org?

Weinermr
Member

08-18-2001

Tuesday, April 27, 2004 - 4:06 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
math is not my speciality - next time ask me a constitution question!!

Weinermr
Member

08-18-2001

Tuesday, April 27, 2004 - 5:43 pm   Edit Post Move Post Delete Post View Post    
I shoulda coulda been a math professor. In another life perhaps.

Mocha
Member

08-12-2001

Tuesday, April 27, 2004 - 5:46 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
Welllll I can call you Maestro. :-)

2? Are you sure?

Babyruth
Member

07-19-2001

Tuesday, April 27, 2004 - 6:29 pm   Edit Post Move Post Delete Post View Post    
Hi Professor MaestroWeiner :-)

Rupertbear
Member

09-19-2003

Tuesday, April 27, 2004 - 6:38 pm   Edit Post Move Post Delete Post View Post    
Or Weinermeistermeisterweiner....sort of a take off of the Bugermeistermeisterburger from Rudolph ;)

Kaykay
Member

01-21-2004

Tuesday, April 27, 2004 - 6:39 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
Weinermr, are you sure the answer is not closer to pi?

Weinermr
Member

08-18-2001

Tuesday, April 27, 2004 - 11:29 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
Rupertbear METALLICA ROCKS WOOOHOOOO!!!

*bangs his head into the wall* WOOO!! :o)

Rupertbear
Member

09-19-2003

Wednesday, April 28, 2004 - 12:50 pm   Edit Post Move Post Delete Post View Post    
LMAO!

You have a great sense of humour, kiddo !

Jed245
Member

11-01-2002

Thursday, April 29, 2004 - 12:02 am   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
and you said he had a wife huh? are they happy?

Rupertbear
Member

09-19-2003

Thursday, April 29, 2004 - 7:20 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
2+2=4

Wargod
Member

07-16-2001

Wednesday, May 12, 2004 - 3:25 pm   Edit Post Move Post Delete Post View Post    
Woo hoo, Ketch is doing my type of math!

Rupertbear
Member

09-19-2003

Wednesday, May 12, 2004 - 3:29 pm   Edit Post Move Post Delete Post View Post    
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.