how do i calculate my mortgage payments
 

what sort of funtions are available to assist me with my mortgage payments


thx

mike

PMT - for monthly instalement
RATE - to find the rate
PV FV to find the loan value at any given point in time
IPMT - to find interest payment of a particular instalement

to name a few



"mike" wrote in message
...
what sort of funtions are available to assist me with my mortgage payments


thx

mike

Or a fast car?

"N Harkawat" wrote:

PMT - for monthly instalement
RATE - to find the rate
PV FV to find the loan value at any given point in time
IPMT - to find interest payment of a particular instalement

to name a few



"mike" wrote in message
...
what sort of funtions are available to assist me with my mortgage payments


thx

mike

mike

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 Tue, 25 Jan 2005 08:17:06 -0800, "mike"
wrote:

what sort of funtions are available to assist me with my mortgage payments


thx

mike