I want to have my own Google Sheet to keep track of my mortgage repayments, work out the various outcomes if I overpay etc. I have it all working however, the issue is how BOI calculate interest, it seems to be every 3 months. So my numbers are off, but every three months or so are close enough.
Does anyone know if there is a formula I can use to mimic how BOI calculate?
Does anyone know if there is a formula I can use to mimic how BOI calculate?