1

I use IPMT formula in google spreadsheets to compute interest payment after 1st month like this:

IPMT(annualRate/12, 1, loanYears*12, loanReceived) - this return for my specific case, 40568 loan for 3.52%, 22 years - 119

Now I try to cumulate the interest (for 1 month) with following formula: CUMIPMT(annualRate/12, loanYears*12, loanReceived, 1, 2, 0) - I receive 237

They should represent the same thing isn't it ?

3

Now I try to cumulate the interest (for 1 month) with following formula: CUMIPMT(annualRate/12, loanYears*12, loanReceived, 1, 2, 0) - I receive 237

That formula is calculating the first two months. That is why the answer, 237, is about double the 119 from the first formula.

1
  • Right ! I saw some examples and I had the impression I need to increase the second index in CUMIPMT for 1 month.
    – Ghita
    Jan 29 at 14:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.