I know there's some kind of formula, but I don't know what it is.

It's called Amortization. I'll bet if you Googled on "Amortization Worksheet" you'd find a bunch of web-based forms which will do this for you.

edit: Yup. Bunch of them. here's one of the first ones on the list.