Calculating your remaining balance and other things... - Toyota Yaris Forums

Sodium Duck · 12-04-2008, 07:24 PM

I'm trying to build a spreadsheet to keep track of all my money.

One big part is my car payments. I'm having trouble figuring out how this gets calculated. I just want to be able to put in whatever payment I make that month, and have my remaining balance show.

What's the trick? I mean to me, if my balance was $100, and paid $50, then my remaining balance should be $50. But of course it can't be that simple. So I have to figure out what my daily interest rate is, I think - I'm not sure?

Financed: $12,530.33
APR: 8.44%
Monthly payment varies from $256.72 (standard)-$270ish, depending on how frugal I'm feeling

Bah, I just don't get this interest thing. Math gods, please shine upon me! Show unto me the ways of your gilded calculators!

12-04-2008, 07:24 PM	#1
Sodium Duck ╚══════════RN Drives: 2008 Liftback Join Date: Oct 2008 Location: Western Mass. Posts: 999	Calculating your remaining balance and other things... I'm trying to build a spreadsheet to keep track of all my money. One big part is my car payments. I'm having trouble figuring out how this gets calculated. I just want to be able to put in whatever payment I make that month, and have my remaining balance show. What's the trick? I mean to me, if my balance was $100, and paid $50, then my remaining balance should be $50. But of course it can't be that simple. So I have to figure out what my daily interest rate is, I think - I'm not sure? Financed: $12,530.33 APR: 8.44% Monthly payment varies from $256.72 (standard)-$270ish, depending on how frugal I'm feeling Bah, I just don't get this interest thing. Math gods, please shine upon me! Show unto me the ways of your gilded calculators! __________________ 42.88