This is very long, excuse any typos and complete lack of grammer i have just tried to get my thoughts down and not got time to re read and correct.
No problem, in terms of the summarisation it really goes back to the notes info. The take away message is the summary table I've provided is not detailed enough in terms of market data, housing market, risk tolerance, current finance position salary savings etc to be able to use it for any informed decision.
The amount of detail included just isnt enough to be able to make a conclusion tbh. The final 10 year position will be hugely dependant on interest rates, market performance, economy etc and this table doesn't take into account any market analysis, it treats everything as acting the same and applies a consistent 6%. One of the only certaint3 I have is that this 100% won't reflect reality.
Not to be taken as advice at all but my personal view is house prices will slow, stall, or fall over the next 3-5 years in real terms, and then pick up, so the final house value in that scenario would be very very different.
Interest rate 3.5%, and isa /sipp gains 6% used in the cals I think are on the low side
I think investments will out perform house price increases in the next 10 years, but this also depends on what you invest in, which markets you are operating in for both the the ISA/SIPP investment and housing area
Considering real life changes is also key: If you were to become unable to work, your available monthly 2k available might be reduced. In this situation and the upsizing option, you would have a large debt to service (mortgage) and no savings. I don't know if you have any insurance products in place or if my statement re savings is true, all of this needs to play into your decision. Many people would have the solution of selling if they couldnt work, but if you are unable to pay the mortgage whilst in the process, you are in a difficult postion as you cant wait it out. house prices could be stagnent, housing market depressed, interest rates high etc you could be stuck for a period of time and ultimately walk away with similar equity as when you bought but with negative impact to credit worthiness because you haven't properly considered your financial profile.
Your age, current salary, future salary progression, and pension situation is really important to consider. As you can take a 25% lump sum tax free from DC pension and depending on your specific circumstances the tax relief combined with investment gains in certain cases is almost impossible to beat imo
Thats why you really need to go through all of your numbers and look at your wider picture from a personal circumstances POV. Then you can include all the variables and calculate impacts of different rates (interest, investment returns etc) and decide how much / what types of risk you want to take before making a decision.
I know its frustrating, but honestly there are so many considerations that the only way to get comfortable with a decision and hopefully not make a big mistake is to have detailed conversation with someone who is familar with financial planning mkong sure all you and DH finances are considered, and proper market analysis is performed to make the scanarios more realistic (including various rates, timing increases decreases etc). If you dont do that it really could end up costing you huge amount longer term.
Just to demonstrate the personal nature of all the above, in the last 2 years my friend and I have chosen two very different approaches, because our personal circumstances and finances are different.
My decision: purchased house well below mortgage capacity / affordability (below 2.5 x salary), amended lSA and Pension investments to accept more volatility with the aim of higher investment gains. Monthly I am overpaying on each mortgage payment by 35% to increase capital and mininse interest over mortgage term.
Doubled my pension contributions - this is 100% the most beneficial option for me given the tax relief, and importantly my long term retirement goals (age I retire and lifestyle I want etc).
Putting smaller regular amounts into S&S ISA just for secuirty of available cash
The above is very much right for me, from a pure financial POV I really should be ignoring my mortgage and putting that overpayment into my pension, I am just more comfortable with the mix. The key here, is i understand the choices and have made a fully informed decision that I am comfortable with.
My friends Decison: upsized, almost at the limit of mortage capacty with the plan to top up pension with capital increase/house appreciation, once they downsize, the pension would again likely be the most financially beneficial choice, but due to tax brackets not as significant as mine, for her the decision is heavily swayed by blending households and the want/need for a larger house when all the blended family are in one place. Her decision is also influenced by current savings / investments, but she has much less of a risk spread then I do. Again it was a very informed choice that is specific to her personal situation.
In terms of doing calcs - there are some resources that might help
Money saving experts mortgage overpayment calculator for mortgage rates 10 year impacts
Calculator net investment calculator
Hargreaves landown pension calculator
Obviously if you are know at excel you can do all the above in a spreadsheet.