|
Answer» 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!
kwlodarckwlodarc
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 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.
|
