+ Reply to Thread
Results 1 to 2 of 2

PMT() Formula

  1. #1
    Registered User
    Join Date
    04-18-2006
    Posts
    34

    PMT() Formula

    Hello all, I need a wee bit of help with Excel's PMT formula, because I was given a worksheet with two different formulas and I seem to get two different results.

    I have the following values:
    Loan: 1861.52
    APR: 24.99%
    Loan Time (in months): 24

    So to calculate the interest on the number of "Odd" days (not a full month), I use:
    =ROUND(1861.52*(1+24.99/36500)^17,2)
    My result is 21.79, which means I get to charge 21.79 in interest for 17 days. With this, the monthly (30 days) interest comes out to be $38.62.

    So, 1861.52+21.79 = 1883.31.

    So then, I assume they used this formula to calculate the monthly payment with 24.99% APR over 24.99 payments.

    =PMT(24.99/1200,24,1883.31,0,0)

    The resulting interest over these 24 months comes out to be $550.62, which on a monthly basis is about $21.78 dollars.

    Does the PMT() formula use a different method to calculate interest? When I do it manually, my result says that the monthly interest needs to be $38.62...

    I could attach the workbook, if need be, but I hope that you can understand it from this post.

    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    I think you need attach the workbook
    And there are some questions:
    Does this loan interest calculated on a Day to Day base, or monthly?
    Is it paid monthly?
    Why did you use 1883.31 as the PV, not 1861.52?
    Please Login or Register  to view this content.
    I need your support to add reputations if my solution works.


+ 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. Formula for bond price
    By Dracan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 11:17 AM
  2. A formula template
    By ajaysehgal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2013, 06:12 AM
  3. Reset Formula without Editing Formula?
    By Ogey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2007, 08:44 PM
  4. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  5. use cell content as cell address in formula
    By nnsc in forum Excel General
    Replies: 4
    Last Post: 11-05-2006, 03:12 AM

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