Techy Tuesday Tax Tool Q&A

Last Updated: 3 Jun 25 5 min read

Methodology Matters

Can the tool calculate the position with a joint investment bond, using each individual's ISA allowances each year?

The tool is designed for a single investor only but you can just run it for each investor separately and halve the bond investment amount. It’s likely that they will have different incomes and if the investments are 50/50 then halving the investment should get you to the same position.

How does the tool work out dividends for capital gains for Acc funds (or does it just assume the funds are INC funds)?

The tool has been built to use income units.

So there isn't the ability to bed n ISA the collective but not the bond?

The tool will bed and ISA from the collectives and the bonds (onshore and offshore). It was mentioned during the presentation and is a caveat on the tool that whilst using the AEA to rebase the gain, the tool ignores the bed and breakfasting rules.

Does the ISA wrap take funds from the bond each year, and would contributing to ISA and withdrawing mean a double withdrawal from the bond?

If ISA wrapping has been selected this will be done over all three investments. If you select an additional withdrawal this will be on top of the withdrawal for the ISA allowance. If you select ISA wrapping and a £10,000 withdrawal, £30,000 gross will be withdrawn at the end of the tax year in total.

With the ISA Wrap - does it assume to use the AEA? or if you say to use the AEA - is that separate?

If using the AEA has been selected the tool will factor this in. It will firstly look to see from the collectives if enough income has been generated to use for the ISA investment. If this is not enough and using the AEA has been factored in then the amount turned over in the collectives will be used for ISA wrapping. If that is not enough then additional units will be sold.

Can the tool be adapted to illustrate encashment / income over multiple years?

No, the tool is built on the assumption that the investment will be fully encashed at the end of the selected term. But the tool does display what OEIC capital gain or Bond gain has been generated. This could be used as a starting point for an extraction strategy.

Does it factor in ongoing adviser fees for bonds and impact on 5%?

The tool doesn’t factor in any fund based ongoing adviser charges, but you could factor in a static ongoing advise fee in the regular withdrawal input section.

How does it work with an MPS within a GIA, especially when funds have been switched since inception and sale?

The tool doesn’t factor this in, as it’s assumed that this is new money being invested.

Does the overall income take into account the total tax paid?

Any tax displayed for the investments are the explicit tax increase for the individual caused by that investment. The tool doesn’t show what their tax is based on their existing income, but does factor in what tax is caused by each investment. 

Tax Matters

Support Matters

Great session and love the updated tool. Will there be a user guide available and can we print a report showing all the information?

We have the glossary at present to help with inputs and outputs and what they mean. The Tax Analysis tab can show most of the information. It’s always recommended to print these to PDF as the tools cease to function at the end of the tax year (a PDF will not be affected by this) and this will show all of the information.

Here we go !!. This always stops me . How do I enable macros without joining Microsoft 365 !. On a windows 11 computer.

In all of our excel tool landing pages we do state that macros need to be enabled and they all have a link to this page which should fix the issue for you.

Presentation is great and I would like to go through it with a Trainee Adviser. Will I receive or have access to the full presentation with the spoken content?

Yes, a recording of the session will be available on our Tech Matters site by the end of this week in the On Demand section.

 

Miscelleneous Matters

 

Where would you get the Investment assumptions for a fund for savings, dividend and capital gain please?

There is no exact place to get these, but broadly speaking from a fund fact sheet you can get the total return and the investment yield. In any one year the total return less the investment yield should be the capital growth. If your firm has an investment team they might be able to provide you with expected yields for the portfolios you are considering.

Is there a tool for Ltd Company investment in Bonds with underlying investments which are either dividend paying only or in the PruFund Growth Fund(in bond)?

We don't presently have a calculator that can support this. 

Can the TWCT cope with reductions in the ISA allowance intimated by Angela Rayner?

We can only go with the rules that we have in place at the moment. The rumours we have heard on this was a restriction on how mucjh can be placed in cash. This tool deals with Stocks and Shares ISAs.

Tech Matters

Related

Ask an expert

Submit your details and your question and one of your Account Managers will be in touch.

Submit a question

Find us on LinkedIn

Sign up below where you will be the first to see any news, views or support we think matters. 

Sign up