+ Reply to Thread
Results 1 to 3 of 3

PMT Function Question

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    The Beach
    MS-Off Ver
    Excel 2003
    Posts
    1

    PMT Function Question

    I am trying to calculate the monthly payment of a 12% ANR loan.

    My questions is: what is the correct way to convert the 12% to a monthly rate.

    Most forums state that I should simply take 12% and divide by 12, or =PMT(12%/12,...).

    However, I know you can also find the effective monthly rate by entering =(12%+1)^(1/12)-1.

    Does anyone know which version is correct, as they yield slightly different monthly interest rates. I believe the second version is more precise, but am not certain.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: PMT Function Question

    Who Knows !!!
    When I look at a loan example from a particular loan company, I can deduce by the repayments that they use the (1+INT) ^(1/12), but as you are aware the PMT function uses (Int/12)
    I look forward to someone enligthening both of us.
    Regards Mick

  3. #3
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: PMT Function Question

    ANR? I hadn't heard of it and could not find a match on Google or on acronym finders. What does it stand for?

    Pauley

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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