Excel Amoritized Loan question 1

[dawnd3]

Hi, I was wondering if someone knew of a way, or an existing program in Excel, or Function in Excel where someone could create an amoritization for a loan, but allowing for overpayments. i.e. If I pay 100 extra on this monthly, how much is my end result going to be and what date would that be paid off?

Thanks in advance

Dawn

http://www.calliopeconsulting.net

 

[AngO]

Dawn,
Try the Microsoft Template Gallery:

http://officeupdate.microsoft.com/templategallery/

They have a loan with extra payments already created in the Financial Section.
The whole site is cool, lots of good templates to download and use.
AngO

 

[dawnd3]

Thank you Ang0, that is exactly what I wanted!

Dawn

http://www.calliopeconsulting.net

 

[AngO]

Dawn,
Glad I could help! Have a great weekend!
AngO