📨 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!

Excel guru help needed

Hi

I hope someone out there is an Excel whizz and can help me.
I've got a spreadsheet for my mortgage with interest rate, amount each day/month/year, payments and overpayments etc. What I'm after adding is how much interest each overpayment saves, and the length it shaves off the mortgage.

Can anyone help??

I've got locoblades sheet but it doesn't have these options as far as I can see.

Thanks!
Mortgage £126746 DEC14 £122423.53 DEC15 £115041.70 DEC16 Remortgaged Sep17 to pay off HtB loan £150000 - £140500 JUL19 Moved house Oct19 £230000 £230400 DEC20

Comments

  • dano17439
    dano17439 Posts: 366 Forumite
    Part of the Furniture 100 Posts
    I've got a great excel that I got off here many years ago. Drop me a PM with your email address and i'll whizz it over
  • That'd be great, thank you!
    Mortgage £126746 DEC14 £122423.53 DEC15 £115041.70 DEC16 Remortgaged Sep17 to pay off HtB loan £150000 - £140500 JUL19 Moved house Oct19 £230000 £230400 DEC20
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
  • 351.5K Banking & Borrowing
  • 253.3K Reduce Debt & Boost Income
  • 453.8K Spending & Discounts
  • 244.5K 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

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.