We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
How to work out payments?

Feanor
Posts: 513 Forumite
Hi all,
The purchase price of the flat we had an offer accepted on is £207, 500. We have 5% deposit.
Our AIP with the abbey was for £240k max, and then if we found somewhere with a lower purchase price we would look at other deals.
How do we work out what our payments will be with a rough interest rate of 5.5%?
Sorry i just cant seem to get my head around it !
The purchase price of the flat we had an offer accepted on is £207, 500. We have 5% deposit.
Our AIP with the abbey was for £240k max, and then if we found somewhere with a lower purchase price we would look at other deals.
How do we work out what our payments will be with a rough interest rate of 5.5%?
Sorry i just cant seem to get my head around it !
0
Comments
-
its not easy to work out my yourself.
if you have EXCEL spreadsheet the the following will work
=PMT(monthly interest rate, months,principal,0)
where monthly interest rate is 5.5%/12
months is number of months (25years is 300)
principal is amount borrowed.0 -
Yikes...
Sorry that went over my head a bit! I'll ask my other half to see if he can figure it out!
Thanks.0 -
example
loan of £150,000
25 years (=300 months)
loan interest rate 5.5%
then type in a EXCEL cell
=PMT(5.5%/12,150000,300,0)
and it comes out at -921 so its telling you your monthly repayment is 921 per month0 -
Ok, Let me see if I can work this out.
If you've had an offer accepted for £207,500 and have a deposit of 5%, then you are looking to mortgage for £197,125.
A repayment mortgage on that amount over 25 years and at 5.5% is approx £1,210 per month. On interest only this would be £903.49.
Does this help?
I just used this calculator http://money.guardian.co.uk/calculator/form/0,,603156,00.html
cara
x0 -
This seems to be a handy calculator I use alot
http://www.ucbhomeloans.co.uk/intermediaries/if3_payment.html0 -
Thats fantastic, thankyou very much!0
-
welcome. I found it very useful when comparing deals, changing the IO/repayment portions or even lengthening the loan. I can see instantly what the difference is and compare to my hearts content! lol0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.4K Banking & Borrowing
- 253.3K Reduce Debt & Boost Income
- 453.8K Spending & Discounts
- 244.4K Work, Benefits & Business
- 599.7K Mortgages, Homes & Bills
- 177.2K Life & Family
- 258K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards