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.