Wednesday, January 12, 2011

Amortization Schedule

I am always interested in how to pay off loans faster.

"How would it affect my loan if I make an extra payment?"

This question is answered down to the approximate penny with this amortization schedule calculator. All you have to do is download the spreadsheet (there are no macros) and enter in the initial loan amount, interest rate, loan term (in years), and first payment date and you will be presented with a schedule that separates exactly how much money you'll be expecting to spend on interest vs. principle from the loan origination date through the last payment of the loan.

If you have questions on how to use this spreadsheet, please post a question and I'll work on getting it answered as soon as possible!

Note: This spreadsheet is protected so that you only edit the cells that are meant to be edited. If you are an advanced finance person and would like to edit this spreadsheet's formulas, the password is given on the spreadsheet itself.

Download [download id="1"]

5 comments:

information technology said...

Thanks for some quality points there. I am kind of new to online , so I printed this off to put in my file, any better way to go about keeping track of it then printing?

Vonda Hempel said...

I have been reading out a few of your posts and it's pretty good stuff. I will surely bookmark your site.

Jaress said...

I'm not sure what you mean. Can you explain your question a little more?

Jady said...

IJWTS wow! Why can't I think of tnhigs like that?

Vinnie said...

Weeeee, what a quick and easy souliotn.