Results 1 to 2 of 2

PMT function: Did i do it correctly?

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2008
    Location
    singapore
    Posts
    22

    PMT function: Did i do it correctly?

    Hi to all who are in this GREAT forum....

    This is what i encountered but i do not know how to calculate.

    a. Loan amount: $500,000
    b. Period: 10 years
    c. Interest rate per annum: 3%
    d. Instalment: Quarterly

    So, how should i calcualte the payment at the end of this quarter?
    ________________________________________
    This is what i have calculated but i do not know if it is correct. So please help me. Thanks

    [I use the PMT Function]

    rate: 3%/4
    nper: 40
    pv: 500000

    Then the answer i got is $14,515.08/-
    So is this correct, or did i made a mistake in anywhere. Deeply appreciate your help Thanks in advance :D
    Last edited by excelplshelp1; 10-29-2008 at 10:52 PM. Reason: Add in more details

Thread Information

Users Browsing this Thread

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

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