Prin & int

[bdiscount]

I have the formular for loan calc to find the mon. payments. What I need now is the formular forseparating the pincipal and the int on the monthly basis for a set time.can anyone help or send me to a site.

 

[klaus]

Sorry, but I don't understand your question.

What do you mean with principal and int on the monthly basis for a set time ?

 

[bdiscount]

I have a formula that $100000 for 15 Years(180 mon) with 5% interest gets $791 a month What I want to figure out is what principal and what interest for each month for 180 months(15yrs) etc.

 

[klaus]

Can you please post the formula you have.

 

[bdiscount]

M=P[i(1+i)n(expon)]/[(1+i)n(expon)-1]

$100000 15 yrs(180mon) at 5% = $791 rounded
1st mon 374 prin 416 int
2nd mon 375 prin 415int
etc to 180 787 prin 3 int
this is rough

I have a loan calc on Vista but I want one on the ppc
I would also like to include options for monthly quarterly or semi annual interest.

 

[klaus]

Here you have an example, I hope it will help you.

You can select what you want to calculate in function of the other parameters.
Mortage calculation is the default calculation.

The equations come from:
Math Forum: Ask Dr. Math FAQ: Loans and Interest
or
Mortgage calculations -- how it works

Best regards.

 

[bdiscount]

I already have a prog for the montly payments. But I'm sure those site will give me the info i need for the rest of the calculator. Thanks for the help.

 

[bdiscount]

This is what I have now hope to set other formular to be able to find int. or years