Working on a Mortgage Calculator

Hello everyone!

I've come here in the past for help and I've always been very happy with what I see.. so, I come to you once again. I am currently creating a mortgage calculator. I want it to look really good, but the GUI is all taken care of, no need to worry about that. I just need help on the functionality.

I have 3 text boxes: Principal, Annual Interest, and Length (in years). So, I'm wondering, what kind of script/code would I have to use to actually calculate the correct monthly payment? I've tried like 3 different formulas that I've found online, but they haven't worked.

Thanks in advance for your help!!

u can try the Rate function in vb6, i dont knw abt it, but it is used to calculate interest and something like that, just try it....

I looked into that and did a few tests, but nothing seems to get just what I'm wanting.