+ Reply to Thread
Results 1 to 3 of 3

PMT vs NPER

  1. #1
    Registered User
    Join Date
    08-04-2013
    Location
    toronto
    MS-Off Ver
    Excel 2003
    Posts
    2

    PMT vs NPER

    Hi, I am doing something wrote when using NPER and PMT

    I calculate nper(0.035/12, 100, 10000) which equals -87.9 which means I'll payoff the $10000 loan in 87.9 months by paying $100 every month.

    Then I calculate pmt(0.035/12, 87.9, 10000) which equals $-129.14

    Since I use the same 87.9 number of months in the PMT function, I would expect to get $100 as the payment amount, as I used in the NPER function.

    Can you tell me what I'm doing wrong??

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: PMT vs NPER

    To DECREASE a balance, one of the arguments needs to be negative...Typically, the payment.
    Try these:
    A1: =NPER(0.035/12, -100, 10000)
    =118.403360421205

    A2: =PMT(0.035/12,A1,10000)
    =100

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    08-04-2013
    Location
    toronto
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: PMT vs NPER

    Yes that was the problem! Thank you so much!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Solve for interest rate of a security when pv, fv, nper are know?
    By Pete at CitiStreet in forum Excel General
    Replies: 2
    Last Post: 08-16-2006, 09:15 AM
  2. how to calculate Rate when PMT, Nper & PV is known
    By Jess in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2006, 01:00 PM
  3. nper function calculation
    By bigfella in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2006, 10:05 AM
  4. Calculating NPER
    By rick wintomac in forum Excel General
    Replies: 2
    Last Post: 04-09-2006, 12:10 AM
  5. [SOLVED] NPER - Retirement Example
    By mschumacker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1