Formulas for mortgage collection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thumper - 19 Mar 2006 23:00 GMT

I have Microsoft Excel 2003. We are collecting mortage payments on a sale of
property. I need to know how to set up formulas for the spreadsheet to
reflect simple interest and irregular payments. I found the answers
separately but don't know how to do both in the same spreadsheet. Thank you

Signature

Grey Squirrel

Reply to this Message

Fred Smith - 20 Mar 2006 12:36 GMT

If you truly have simple interest, you would set up a spreadsheet with four
columns: date, payment, interest, balance.

You calculate the interest amount for each payment as:
PreviousBalance*(PaymentDate-PreviousPaymentDate)/365*InterestRate.

Also, don't bother comparing this to a compound interest mortgage, because
you'll find that agreeing to only simple interest was very costly.

Signature

Regards,
Fred

>I have Microsoft Excel 2003. We are collecting mortage payments on a sale of
> property. I need to know how to set up formulas for the spreadsheet to
> reflect simple interest and irregular payments. I found the answers
> separately but don't know how to do both in the same spreadsheet. Thank you

Reply to this Message