Tiff
How about a nice Mortgage Amortization Template?
http://office.microsoft.com/en-us/te...CT011377171033
Download and just type the data into the appropriate cells as instructed.
Gord Dibben Excel MVP
On Thu, 27 Jan 2005 12:01:00 -0800, "Tiff" wrote:
I'm trying to figure out how to create an amortization
calculation in Excel using a mortgage amount, interest
rate, & monthly payment amount. I'm looking to
automatically calculate the number of payments, total
interest paid, & the last payment.