View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.