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.

---

You SHOULD have got a contract that tells you how much you will actually pay for the car by the end of the payments.

---

Yes, I have that, but I like numbers and want to play with it. I'll be having it paid off in far less than 72 months.

---

That should save you alot of money, interest wise.

---

Hoping so bud. 🙂 I figure if I throw about 100 extra a month, plus half of my bonus and tax return every year, it should go down quick.

---

You bought a 100 thousand dollar car!?!?


(j/k!)LOL

---

lol, heck no! I owe 10k. You were only one ZERO away. 😉

---

Your such a Z2C 

Just go to ammortization schedule and pump in your loan amount, interest, and duration and then check the box to see full schedule.

---

Zero-I'd have to agree with Cheesey. Your loan example in your first post is for $100K...I'd sell your house and live in the car...