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!
Excel guru help needed

TwentySomethingGirl
Posts: 201 Forumite


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!
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
0
Comments
-
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 over0
-
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 DEC200
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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