Okay, so I got a new car, blah blah. This loan stuff is confusing as hell to me.
I'd like to see a break down of every payment that I make and what I owe versus what the interest is as I go along.
I'm trying to do this in excel, but failing.
Do I apply the financing percent after every month, or every year? And is it the anniversary of the sale of the car, or Jan 1st?
Edit, kind of like this.