Simple spreadsheet for loan payments recieved.

[JR_Smiley]

Hi,

I'm collecting monthly payments over 5 years on $4,000. I'm looking for a spreadsheet that I can enter the date and amount received and it will calculate the interest and principal based on that date.

Sometimes they double their payment and sometimes not. I would like to enter what was received and the date. The interest is at 6%

Thanks for your help....

[aclawson]

Sounds like something like this is what you're looking for. The amortization date formulas aren't the best because I don't have the EOMONTH function add-in installed on my home computer.

Hope it helps.