how do i get the balance of the first month to be zero and the rest of the months to be "balance = balance + payment + interest" ? thanks
You need to rethink the logic of your operations, so that your reporting of the first month's balance happens before it's adjusted for the first payment.