Excel help!!

[kwlodarc]

I'm so confused! Please help!

I'm trying to put together a spreadsheet to keep track of how much I've paid on a loan. So, what I want is the principal amount and then a list of all the payments I've made plus a function to keep track of how much I still owe. Can someone help me

Thanks!
kwlodarc

[dl65]

kwlodarc

I think if you go to the page I have given the link for, you will find exactly what your looking for.

http://www.mortgagesexposed.com/Book_Contents/spreadsheet_summary.htm


dl65 

[soybean]

This can be set with formulas if you understand how to do it.  But, for an easier approach, I suggest downloading a template from Microsoft.  They have many free templates for a wide variety of purposes.  Here's a loan calculator template that looks like it will serve your purpose: Loan calculator

Edit: Ah, I see dl65 beat me to it.  Well, not you have two sources from which to choose.