How to calculate what was paid and what is owed

I need to calculate a loan amount(50K) at 7% of interest and in the same time put several different amounts of payments that were made in a period of 2 years.
I need to be able to see how much of the total was paid each month on that loan and how much It was still owe every single month.
Is there a formula , a way to do that instead of calculating manualy cell by cell ?


Thanks a lot.

No, there is no formula. Because it is not clear when you made the payments. But it doesn't matter, because you don't have to enter anything cell by cell. That's what is good about spreadsheets. You enter the forumula once and then copy the formula to as many cells as you like.

I am trying to upload a video (zip) to show you, but I can't do it some error with this website. If you PM me with your email address, I will email it to you