can I do a spreadsheet to keep up with what a debtor owes?

  • Thread starter Thread starter brycemassey
  • Start date Start date
B

brycemassey

I am owner financing a home to someone and was wondering if I could
create an excel spread sheet that would keep up with payments, interest
paid, principle paid, balance, etc....Could an excel worksheet
recognize when a payment is late and calculate the interest and
principle paid accordingly?
thanks
 
Yes, given the correct input. Google for Excel mortgage templates. If you
post specific stumbling blocks, you will get specific answers.
 
Hi brycemassey!

There's a Microsoft template for amortization and I have a few that
you can have (off newsgroup requests only!)

You'll also find that construction is covered in John Walkenbach's
Excel Formulas 2003.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First row where a cell is zero 1
mortgage payment 2
mortgage ammortization schedule 7
Figuring Late Payment on Mortgage 3
How do I use Excel 2007 to determine late payment amounts 3
How do I calculate present value of a single sum? 9
Financial Spreadsheet Help 2
What function do I use to calculate a Sum of Digits? 3

Back
Top