You can use below formula logic:-

New Balance = a1+a4-a3-a2+(3.25%*(a1-a2-a3))

where a4=purchases, a1 = begining balance, a2 = payments and a3 = credits

If you face any challenge, upload a sample workbook.. thanks.


Regards,
DILIPandey
<click on below * if this helps>