Prin & int

bdiscount

Active Member
Licensed User
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.
 

bdiscount

Active Member
Licensed User
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.
 

bdiscount

Active Member
Licensed User
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

Expert
Licensed User
Longtime User

bdiscount

Active Member
Licensed User
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.
 
Top