I have mentioned this a few times in various comments I've left, but I wanted to share with everyone this little spreadsheet that has come very handy to me while figuring a lot of loan-related things: car loan and mortgage mainly.
I found the Loan amortization schedule template on the Microsoft template website.
Once you've entered all the information in the gray cells, it automatically displays your whole payment schedule, with how much you're paying for towards interest and capital. You can see the impact that making extra payment has on your total interest payment, as well as on the actual number of payments you will end up making. I think it's a fantastic little tool.
--------- EDIT ---------
This is not brand new, but I just found out that MIT offers free online courses from Aeronautics and Astronautics to Writing and Humanistic Studies. I have actually already used it to get a refreshing course in Java.
My favorite spreadhseet and Free MIT courses?
January 5th, 2007 at 03:58 pm