Help!!! Need Mortgage formula...
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Help!!! Need Mortgage formula...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Ok Experts:

    Please help a newbie out. Here is the scenario:

    Principal of a loan is $90,000. Annual Interest rate is 7%. My monthly payment is $698.77.

    What is the formula for calculating how long it will take me to pay this loan off?

    Been banging my head against the wall trying to figure it out. Please help...Thanx in advance!!


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    you can use
    =NPER((0.07/12),-698.77,90000)

    I believe the British mortgage system would be
    =NPER((0.07/12),-698.77,90000,,1)

    note the rate must be adjusted to monthly

    [ This Message was edited by: IML on 2002-04-19 08:22 ]

    [ This Message was edited by: IML on 2002-04-19 08:23 ]

    [ This Message was edited by: IML on 2002-04-19 08:24 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com