We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 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!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

How do you work out the daily interest on the mortgage?

skaps
skaps Posts: 2,255 Forumite
in Mortgage-free wannabe
Hi am using the excel spreadsheet for my mortgage overpayments but wanted to know how to work out the daily interest on my mortgage?
MFW 2016 No 68 £1300/£8500 No new toiletries Cook sth different

Comments

  • chirpchirp
    chirpchirp Posts: 1,983 Forumite
    Part of the Furniture Combo Breaker
    Formulas is interest rate x amount outstanding divided by 365
  • skaps
    skaps Posts: 2,255 Forumite
    So mine would be 7.89x236000/365 = 5101? I don't think that is right
    MFW 2016 No 68 £1300/£8500 No new toiletries Cook sth different
  • shaven-monkey
    shaven-monkey Posts: 651 Forumite
    your interest rate is 0.0789
    "Gold is the money of kings; silver is the money of gentlemen; barter is the money of peasants; but debt is the money of slaves." - Norm Franz
  • skaps
    skaps Posts: 2,255 Forumite
    Thanks shaven monkey. :o

    Its more like £51 per day in interest
    MFW 2016 No 68 £1300/£8500 No new toiletries Cook sth different
  • Jonbvn
    Jonbvn Posts: 5,562 Forumite
    Part of the Furniture 1,000 Posts
    skaps wrote: »
    So mine would be 7.89x236000/365 = 5101? I don't think that is right

    As stated above, the interest rate is 7.89/100 = 0.0789.

    BTW, your interest rate is the highest mortgage rate I have ever seen. Some personal loans are lower. Can you reduce it?
    In case you hadn't already worked it out - the entire global financial system is predicated on the assumption that you're an idiot:cool:
  • skaps
    skaps Posts: 2,255 Forumite
    No I am on a fixed term till October next year.
    MFW 2016 No 68 £1300/£8500 No new toiletries Cook sth different
  • chirpchirp
    chirpchirp Posts: 1,983 Forumite
    Part of the Furniture Combo Breaker
    Sometimes it is worth ditching a fixed rate. Check out Martin's ditch your fix calculator.
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 354.3K Banking & Borrowing
  • 254.4K Reduce Debt & Boost Income
  • 455.4K Spending & Discounts
  • 247.2K Work, Benefits & Business
  • 603.9K Mortgages, Homes & Bills
  • 178.4K Life & Family
  • 261.4K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture