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!
Any one good at maths?
Skinnylatte
Posts: 1,244 Forumite
Hi, I've tried all sorts of over payment calculators, but can't find one that goes far enough into the future to work this out for me. I was hoping someone here could point me in the right direction, or is really good at maths and can do it for me!
My mortgage currently stands at £98776 interest rate is 2.49% and my repayments are £607.
I can afford to pay £193 additional per month.
Question 1: If I over payed for 9 years, what would my outstanding mortgage be?
Question 2: If for 9 years I paid £193 into my pension, then took this as a tax free lump sum and paid into my mortgage what would my outstanding mortgage be?
Other info
I am a 40% tax payer and will be 60 in 9 years.
I already have a reasonable pension pot so would not exceed the 25% tax free lump sum rule.
I will assume the lowest rate of growth on my pension at 2% (although over the last 10 years I've had an average growth of 10% pa)
Thank you kindly in advance
My mortgage currently stands at £98776 interest rate is 2.49% and my repayments are £607.
I can afford to pay £193 additional per month.
Question 1: If I over payed for 9 years, what would my outstanding mortgage be?
Question 2: If for 9 years I paid £193 into my pension, then took this as a tax free lump sum and paid into my mortgage what would my outstanding mortgage be?
Other info
I am a 40% tax payer and will be 60 in 9 years.
I already have a reasonable pension pot so would not exceed the 25% tax free lump sum rule.
I will assume the lowest rate of growth on my pension at 2% (although over the last 10 years I've had an average growth of 10% pa)
Thank you kindly in advance
Pay off Car Loan £17,047 £10580 by Christmas 2022
Mortgage 1 @ 23/03/2019 [STRIKE]£101297[/STRIKE] £84457 16.6% DI [STRIKE]£6.95[/STRIKE] £6.15
Mortgage 2 @ 12/04/2015 [STRIKE]£136121[/STRIKE] £100,546 26.1
% DI [STRIKE]£9.13[/STRIKE] £6.07
1st LBM 02/06/2013 £[STRIKE]21595[/STRIKE] Debt Free Day 27/03/2015
Mortgage 1 @ 23/03/2019 [STRIKE]£101297[/STRIKE] £84457 16.6% DI [STRIKE]£6.95[/STRIKE] £6.15
Mortgage 2 @ 12/04/2015 [STRIKE]£136121[/STRIKE] £100,546 26.1
% DI [STRIKE]£9.13[/STRIKE] £6.07
1st LBM 02/06/2013 £[STRIKE]21595[/STRIKE] Debt Free Day 27/03/2015
0
Comments
-
Whats the options on getting a better mortgage rate? As 2.49% seems a bit high0
-
Assuming your payments start in 1 mths time and the mortgage stays at 2.49%, you get 40% tax relief on the net £193pm pension payment:Skinnylatte wrote: »Hi, I've tried all sorts of over payment calculators, but can't find one that goes far enough into the future to work this out for me. I was hoping someone here could point me in the right direction, or is really good at maths and can do it for me!
My mortgage currently stands at £98776 interest rate is 2.49% and my repayments are £607.
I can afford to pay £193 additional per month.
Question 1: If I over payed for 9 years, what would my outstanding mortgage be?
Question 2: If for 9 years I paid £193 into my pension, then took this as a tax free lump sum and paid into my mortgage what would my outstanding mortgage be?
Other info
I am a 40% tax payer and will be 60 in 9 years.
I already have a reasonable pension pot so would not exceed the 25% tax free lump sum rule.
I will assume the lowest rate of growth on my pension at 2% (although over the last 10 years I've had an average growth of 10% pa)
Thank you kindly in advance
Approx:
Mortgage balance paying £607 = £49,950
Mortgage balance paying +£193 = £26,650
Diff = £23,300
Pension using the £193pm end balance at 2% = £37,800 (before and tax on withdrawal)
Pension using the £193pm end balance at 4% = £41,6000 -
http://www.whatsthecost.com/mortgage.aspx
Can do the mortgage calc for you.
Payment using intrest only set term to 9 years.
There is also a saving calculator that can do the pension0 -
I don't think that calculator will help because the term is not 9yrs.getmore4less wrote: »http://www.whatsthecost.com/mortgage.aspx
Can do the mortgage calc for you.
Payment using in test only set term to 9 years.
There is also a saving calculator that can do the pension0 -
-
Payment seems to be the answer not a variable?getmore4less wrote: »Term does not matter only the payment does.
op want to know what's left in 9 yearsEnter amount, rate, payment, set term to 9 years
Try this one:
https://calculator.me/real-estate/mortgage-balance.php0 -
It's not a 25% tax free sum you need to worry about it's going over the £ 1 million pound pension pot when you get hit with 55% tax.
You can only take 25% as a tax free lump sum.
Why not save into your pension and overpay the mortgage as well.0 -
Payment seems to be the answer not a variable?
Try this one:
https://calculator.me/real-estate/mortgage-balance.php
Set to interest only you can set any payment you like
I meant to say that in the first post it came out wrong on the phone fixed now.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.4K Banking & Borrowing
- 253.7K Reduce Debt & Boost Income
- 454.4K Spending & Discounts
- 245.5K Work, Benefits & Business
- 601.3K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.3K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards
