Forum Replies Created

Viewing 1 post (of 1 total)
  • Profile photo of nqinqi
    Member
    @nqi
    Join Date: 2009
    Post Count: 1

    If you're using MS Excel then it's

    =pmt(rate,nper,pv,fv,type)

    rate = interest rate per period
    nper = number of payments
    pv = loan amount
    fv = zero if you are paying off the loan completely
    type = 1 or 0, depending if the payment is at the start or end of each period (it doesn't make much difference to the result)

    hope this helps

Viewing 1 post (of 1 total)