Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Mortgage Calculation

  • 05-06-2012 10:11AM
    #1
    Registered Users, Registered Users 2 Posts: 7


    I am having a one sided conversation with a financial provider and his superior as to what the answer to the following question should be.

    How much should computed mortgage payments be, given the following parameters
    Outstanding Amount : €186,839.08
    Term : 20 Months
    Interest Rate : 4.95% per annum


    This is not a trick question!

    Anybody care to provide an answer? If so, thanks in advance and please briefly outline methodology used in computing the answer.


Comments

  • Registered Users, Registered Users 2 Posts: 1,049 ✭✭✭maggy_thatcher


    ALEXII wrote: »
    I am having a one sided conversation with a financial provider and his superior as to what the answer to the following question should be.

    How much should computed mortgage payments be, given the following parameters
    Outstanding Amount : €186,839.08
    Term : 20 Months
    Interest Rate : 4.95% per annum


    This is not a trick question!

    Anybody care to provide an answer? If so, thanks in advance and please briefly outline methodology used in computing the answer.

    Do you really mean 20 months? That's quite an aggressive payment plan (in the region of €9,400 a month).

    EDIT - I went on to onus.ie and asked it:

    Monthly Payment: 9751.85
    Total Interest: 8197.92
    Total Amount Repayable: 195037.00


  • Registered Users, Registered Users 2 Posts: 4,468 ✭✭✭rameire


    9,751.85

    open excel
    type
    =-pmt(4.95%/12,20,186839.08)

    🌞 3.8kwp, 🌞 Clonee, Dub.🌞



  • Registered Users, Registered Users 2 Posts: 7 ALEXII


    Hi maggy,

    20 months is correct

    Arises from coming off an interest only period.


  • Registered Users, Registered Users 2 Posts: 33,518 ✭✭✭✭dudara


    Moved to Banking & Insurance & Pensions

    dudara


Advertisement