1 2 Previous Next 21 Replies Latest reply on Aug 7, 2017 7:58 AM by fmpdude

    Using PMT Function

    user22784

      I have a requirement to calculate regular monthly payments for loans which is fine with the PMT Function, however the PMT function seems to presume that the FIRST repayment is made 30 days after the loan is started. Can anyone suggest how I can adjust this calc where the first of the repayments is made immediately the loan is started and not 30 days in arrears ?

        1 2 Previous Next