Excel guru help needed
Options
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.
Categories
- All Categories
- 343.2K Banking & Borrowing
- 250.1K Reduce Debt & Boost Income
- 449.7K Spending & Discounts
- 235.3K Work, Benefits & Business
- 608K Mortgages, Homes & Bills
- 173.1K Life & Family
- 247.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 15.9K Discuss & Feedback
- 15.1K Coronavirus Support Boards