Prin & int

Discussion in 'Questions (Windows Mobile)' started by bdiscount, Aug 22, 2008.

  1. bdiscount

    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.
     
  2. klaus

    klaus Expert Licensed User

    Sorry, but I don't understand your question.

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

    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.
     
  4. klaus

    klaus Expert Licensed User

    Can you please post the formula you have.
     
  5. bdiscount

    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.
     
  6. klaus

    klaus Expert Licensed User

  7. bdiscount

    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.
     
  8. bdiscount

    bdiscount Active Member Licensed User

    This is what I have now hope to set other formular to be able to find int. or years
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice