Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mike
 
Posts: n/a
Default how do i calculate my mortgage payments

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


thx

mike
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

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



  #3   Report Post  
gb_S49
 
Posts: n/a
Default

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




  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a formula to calculate the average percentage rat LD Excel Worksheet Functions 5 January 13th 05 07:17 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 03:33 AM
Not able to calculate. mark_kramarczyk Excel Worksheet Functions 1 December 29th 04 09:55 PM
Loan amortization schedule with bi-monthly payments McCarthy_MF Excel Worksheet Functions 0 December 9th 04 10:45 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 05:19 PM


All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"