The Book-keepers Forum (BKF)

Post Info TOPIC: Using a Ltd Company to Save Tax.


Senior Member

Status: Offline
Posts: 133
Date:
Using a Ltd Company to Save Tax.
Permalink Closed


Hi Everyone,

Could someone explain how this work for me please?

I understand that directors can take a dividend rather than drawing a salary and paying income tax and NI? Dividends are taxed at a lower rate of 10%. Is this still the case as I seem to recall Inland Revenue was cracking down on this with IR35.

Can anyone offer any advice with perhaps an example / comparison....or point my in the direction of an example on line somewhere.  I.e. Payment via dividend vs Payment via Salary or how to optimise the mix between both?

 

Many thanks,

Jay



__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Jay
I have just responded to your other thread and for clarification, it might be better having the answer to that perhaps before this is answered, given the two questions appear to be interconnected.

The notional 10% rule was changed with effect from 6 April - you may have seen some press comment. Here is some info on the new tax regime to get you started www.book-keepers.org.uk/t60870081/bookkeeping-for-my-ltd-company/

Clients will often tax a mix of salary and dividends and it is dependent on their personal circumstances, other income from other sources plus a few other issues (eg  will there be any pfoits available to take divis/tax bracket etc)

Is IR35 a specific issue with your business?



-- Edited by Cheshire on Sunday 17th of April 2016 09:45:57 AM

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Shareholders receive dividends. Directors don't. If they are shareholders they do then :) It's not difficult to work out, maths wise, but you'll need all the figures, which we don't have. IMO it is better to pay 'some ni' than none. Think of state pension for a start. As Joanne questions - which trade / setup in regards to IR35?

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

abacus12345 wrote:

Shareholders receive dividends. Directors don't. 


 Excellent point Johnny.  

 



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Good point about the fact that Directors arent always shareholders Johnny.

Re Ni, you can pay none if wages are below the Lower earning limit but still get the benefits of paying, which is one I like, given I almost have my qualifying 30 years!


__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Speaking of 30 years - I've had a play with the new online digital tax area - beta version I believe - needed to file a p50, anyway - you can top up 'missing' amounts of NI online, from this new account 'thing' now...

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

To add to Joannes response.

many go down the incorporation route because larger businesses will not trade with the self employed (ask yourself why all direct contractors for the banks are limited companies).

Also, it is not tax that you save on but NI.... Or at least that used to be the case but IR35 and successive additions to attempt to reinforce it are aimed at eradicating the NI asnomally between the self employed and one man limited's.

Remember that dividends are from taxed company profits (no profit / no dividend) where salary is an expense which will reduce taxable profit.

Note also that taking a salary will give credits towards your state pension where dividends do not.

Lets take a quickly squibbled calculation of someone paid a £45k salary compared to salary equivalent to personal allowance plus dividends under the old FA15 rules to demonstrate the point. Note that as noted by Joanne above the rules around the tax credits have now changed so I also include an example using the new rules but with FA15 tax bands to make the figures comparable.

All figures are rounded to the nearest £.

quick salary comp calc.jpg



I have purposfully not included my claculations as for a challenge for yourself try to do a calculation for each of the three given scenarios to see if you can get figures close to those above.

Fingers crossed I've not made a whoopsi myself as they are very quick calculations.

Doing this excercise will help you to understand the tax in this area. If you are looking at the above and left scratching your head then I would suggest the purchase of Taxation (FA15 version) by Alan Melville.

HTH,

Shaun.



Attachments
__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Tut, and whilst I was calculating that out a whole conversation happened!

Hi Johnny, snap on the pensions consideration.


__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Everyone,

Thanks for such fantastic input it's very much appreciated.

I'll need to take some time to read through it all and I'll get back to you with any questions.

Thanks,
Jay =D

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Shamus,

I managed to find a post from you from a while back!

www.book-keepers.org.uk/t60825496/setting-up-a-ltd-company-to-save-on-tax/

I was struggling to find it but it's a great post which I can work through. What it doesn't take in to account is the fact that a partner (wife) could also be treated as a director....if this were to happen could the tax advantages to 'the couple' who own the business be significantly improved if the business is the sole source of income??

You also mention about the Directors not looking out for the best interests of the company in you previous post. I think you were getting at corporate governance and agency theory. But where the directors and the shareholder are one of the same would this not eliminate the conflict?

Your post was really detailed so I will work through it when I have some time and work through all that you have said. I guess it's important to consider at what points tax can arise for example if you draw a salary then income tax / NI is due but PCTCT reduces and dividends are paid post profit. Then off course it's the issue relating to any profit which may remain in the company at the point of disposal at some future date.

It's a really interesting topic, maybe I should tax some tax exams...eeek!

Thanks for all your help it's very much appreciated!
Jay

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Can anyone answer/confirm this point please?

What it doesn't take in to account is the fact that a partner (wife) could also be treated as a director....if this were to happen could the tax advantages to 'the couple' who own the business be significantly improved if the business is the sole source of income??

Many thanks,
Jay

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Jay3 wrote:

Can anyone answer/confirm this point please?

What it doesn't take in to account is the fact that a partner (wife) could also be treated as a director....if this were to happen could the tax advantages to 'the couple' who own the business be significantly improved if the business is the sole source of income??

Many thanks,
Jay


Hi Jay,

For this one see this current thread where this matter is being discussed in some depth from the employment allowance perspective : http://www.book-keepers.org.uk/t61852547/employment-allowance-clarification/



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Jay3 wrote:

You also mention about the Directors not looking out for the best interests of the company in you previous post. I think you were getting at corporate governance and agency theory. But where the directors and the shareholder are one of the same would this not eliminate the conflict?


Whilst you would think that would be the case, is that not using the arguement that if someone is a childs parent then the child has no need of protection?

owner directors can be some of the worst culprits for treating companies like personal piggy banks.

 

 



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Jay3 wrote:

Can anyone answer/confirm this point please?

What it doesn't take in to account is the fact that a partner (wife) could also be treated as a director....if this were to happen could the tax advantages to 'the couple' who own the business be significantly improved if the business is the sole source of income??

Many thanks,
Jay


 If you're happy to let the wife become a 50% shareholder and assuming she has no other dividend income then there is a tax free allowance of £5000 for both spouses before dividend interest kicks in.

If dividends are likely to take a shareholder into the higher rate dividend tax, which is 32.5%, then adding a spouse means the dividend income would be shared, and again assuming no other income other than 11k salary, the spouse would be taxed (after the 5k allowance) at 7.5% on the next 27k ish of her dividend interest.

Each case is different and it is highly recommended that you seek an accountant's advice tailored to your needs.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Thanks Shamus and John!

I will spend some more time on this soon and post again if I have anymore question. Thanks for your help.

Jay

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Shamus, I've been looking at your figures in the example above and I'm confused by the rates you have used for EMPE 10% and EMPR 11% in you 'Using Salary' example. It's probably me as I don't do this thing very often but the rates on the .gov site seem to suggest 2% and 13.8%?


__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Lol, no idea where you got your percentages from Jay.

I thought that it would be you forgetting the grossing up on the second one that threw you rather than the first that you fell on.

Anyway, you tried so give me a sec and I'll post my calculations which will put you out of your misery as to where the figures came from (and they use 12% and 13.8% for the NI).



-- Edited by Shamus on Tuesday 3rd of May 2016 12:31:42 PM

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Actually, here you go

using salary.jpg

 

using old method.jpg

 

using new method.png



Attachments
__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Forgot to add the company tax calc

using company tax.jpg



Attachments
__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Shamus,

Thanks for this it's really helpful. Would you be able to forward me the spreadsheet so that I can play around with the figures? I would like to base it on T/O of £80k profit of £40k and then look at adding in an additional director or Employee.

Thanks,
Jay

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Can I also ignore the old method of using dividends as going forward we would need to use the new one right?

Thanks,
Jay

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Jay
Would it not be better to have a go at creating your own? It gets the basic calculations into the brain better, so aids learning.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Jay3 wrote:

Can I also ignore the old method of using dividends as going forward we would need to use the new one right?

Thanks,
Jay


 Depends when the year end, divi taken is, would it not?



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

It would be easier if I had more time to just focus on this rather than coming back to it several days later each time. Apologies for that!

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Jay3 wrote:

It would be easier if I had more time to just focus on this rather than coming back to it several days later each time. Apologies for that!


Oh no worries Jay - I know exactly what you mean. Hardly time to do anything else other than work.  

When you get round to having a bash, if you pop your workings on here Im sure there will be one of us around to have a quick check of it.  Hope that helps!



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Thanks! this is such a great forum! Cheers =D

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Guys,

Could you take a look at sheet 2 for me and tell me if you agree with my figures?

Thanks,

Jay :)

 



Attachments
Tax Calc.xlsx (22.9 kb)
__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Jay,

I recognise that format, lol.

Not bad formatting but just a couple of minor points more about presentation than the actual calculations as such.

You need to seperate our personal and company liability. Personal liability would be personal tax and EMPE, Company is EMPR and corporation tax. (you show that in the comparison off to the right but the Company Liability section at the bottom of the boxes seems to confuse the segregation).

The reality is that the company pays a salary of £36,133 and the tax and EMPE payable on that are the employee's responsibility even though such are paid at source by the company. The companies liability is the EMPR (and corporation tax).

I think that you understand it in principle but its just the way that its presented that could be slightly improved.

On the right hand side the PAYE figure shown is only the NI where PAYE also includes the tax so it should be (for salary, I've only looked at the salary side, I'll let you do the dividend one)

Salary £27,658
PAYE £8,475
EMPR £3,867

You could if you wish show the PAYE as Tax and EMPE seperately which can help in the management accounts.

In my example calculations I used the old £10,600 code as I was comparing dividends under the old regime but for your calculations which are based only against the new method you should be adopting the £11k tax coding which is the code live at the time of the new dividend regime.

Hope that helps,

Shaun.



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Hi Jay

Having a bit of trouble with your dividend calculation.  You've got £28245 as the dividend figure, which has been calculated by taking the salary figure of £36133 and taking away the personal allowance, then adding £2712. 

First of all, what does the £2712 represent? (this is probably me being thick)

Secondly.  Your nett profit figure on the far right is £23245, so surely the tax free dividend band should come off this figure, not the £28245?

 



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi John,

I didn't take the second one but just glancing at it now I can tell you where the figures incorrectly come from.

The dividend figure would seem to have been reverse engineered.

If you look at the calculations off to the right the tax code salary is calculated out leaving £29,057, subtract the tax and the remainder is the figure allocated in its entirety to dividends.

The issue there is that to get Jays figures the remainder figure calculated should be the £28,245 not the 23,245 (whats happened is that £5k has been back added to the dividend available where the £28k figure is not actually the amount available for dividends). So if we replace 28,245 in the calculation with £23,245 and subtract the £5k from that then we actually get a tax figure of £1,368 on income of £33,845.

Jays driver was obviously the same turnover starting point and being left with nothing in the company rather than the income calculations being equivalents.

A quick calculation later and I get take home using salary is £27,658 and take home using dividends of £32,172 (still using the £10.6k tax code).

Do you concur with my figures John?

 

p.s. amended to add more figures to make my calculations clearer



-- Edited by Shamus on Monday 16th of May 2016 11:08:35 AM

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Hi Shaun

By heck, I do get the same figures as you.  I replaced the calculation in cell D29 with the nett profit figure from the right hand side, which gave me £18245 taxable dividend.

In this particular scenario I was also able to reduce the salary to £8060 (blame Portia for that one lol) and have a take home figure of £32261

It required the formula =E28-D28+5000 in cell F31 (to use up the personal allowance) but I reckon that's a pretty good dividend calculator now, so thanks Jay.  (also had to delete the minus £52 on the employers NI but I don't know how you would present a zero figure there)

 



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Thanks everyone!

John, would you mind posting the spreadsheet back with your formula fixes. That would be helpful.


Thanks Shamus for your feedback, I'll have to look at everything you've mentioned one I get some more time....possibly this afternoon.

Cheers,
Jay

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Leger wrote:

reduce the salary to £8060 (blame Portia for that one lol)

 


Wonder if she realises that she has a fan club over here? (count me in on that). Loved her "hello underlings" intro the other day.

You would think that as she seems to be getting banned by Aweb something like twice a day at the moment she would come over here where she's appreciated by the underlings who moderate this site which would make her pretty much bullet proof over here.

And on that whole mattter, what is up with Aweb! Are they really, really trying to p**s off all of their main contributors.

There current top five most liked threads :

 

 

 

And the next 11 most popular threads after the above are (with good reason) also all complaining about the new format.

I can see why SIFT (their site owners) want top make all of their sites the same format as you end up with a platform product and reduced maintenance costs... However. When you have a flagship site that people love why change that site to be like all of the others rather than changing all of the others to be like the flagship?

A few days back when their main contributors were looking at viable alternatives to Aweb I almost posted a link to this site over there... Then thought (a) it will get me banned and (b) I thought about our newstarts, student bookkeepers and more nervous posters here who would very unfairly be crucified by some of the posters from over there.

Taking people from Aweb one at a time and getting them used to our new start / career changer freindly culture is one thing but if we had a mass migration it would change the feel of this site dramatically.

I still think that Portia would fit in well here even if she doesn't take any prisoners. I'm all for us adopting her as our first Aweb convert.
 
So, anyway, sounds as though we're both members of the same fan clubs (Portia and Joanne.... Sorry, lets stick with safe sequencing, Joanne and Portia). Do you think that there should maybe be badges and membership numbers and such like?


__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Shamus wrote:
Leger wrote:

reduce the salary to £8060 (blame Portia for that one lol)

 


 <snip>
So, anyway, sounds as though we're both members of the same fan clubs (Portia and Joanne.... Sorry, lets stick with safe sequencing, Joanne and Portia). Do you think that there should maybe be badges and membership numbers and such like?

 Hey now I wouldn't go that far, even though I've been kind to her in my reply to Parmi just now.  Besides shes from Basingstoke!!

She can be funny, and the £8060 replies certainly were, but I dislike her sometimes acerbic style. On the other hand she is very knowledgeable in tax matters well above my level and will give a good reply when needed.

But I'm with you regards Joanne, who is definitely No. 1 smile  (loved your quick change of sequencing there, you nearly had to hand out a get out of jail free card biggrin )



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Shamus wrote:
I still think that Portia would fit in well here even if she doesn't take any prisoners. I'm all for us adopting her as our first Aweb convert.
 
So, anyway, sounds as though we're both members of the same fan clubs (Portia and Joanne.... Sorry, lets stick with safe sequencing, Joanne and Portia). Do you think that there should maybe be badges and membership numbers and such like?
Leger wrote:

But I'm with you regards Joanne, who is definitely No. 1 smile  (loved your quick change of sequencing there, you nearly had to hand out a get out of jail free card biggrin )


 


She would become a big softie, just as I have since joining BKN!!!!  I was often described as 'taking no prisoners' at work and mostly I like her style as long as Im not on the receiving end of it, of course.  I know thats bad!

Gosh, one goes MIA for a day and they are already finding some other floosie to fill my place on here as big pixie of the year. S haun handing himself a get out of jail free card is not going to work, is it John? Needs to be greater punishment after all the cakes I've made him!!! Am absolutely appalled that he didnt 'sequence' matters in the right order by editing!!!   Im now crying in a corner!  Although the use of the word 'safe' makes me realise that a certain Mr Mod knows how lethal I can be, lol

Thank you John for your kind words, I have re-organised the membership numbers to ensure VIP members are easily recognisable  - thats  all Im saying.    Plus dropping an email to Portia to tell her to back off BKN!  wink

Thank you Shaun evileyeevileye

 



-- Edited by Cheshire on Tuesday 17th of May 2016 01:36:11 AM

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Cheshire wrote:

Gosh, one goes MIA for a day and they are already finding some other floosie to fill my place on here as big pixie of the year. S haun handing himself a get out of jail free card is not going to work, is it John? Needs to be greater punishment after all the cakes I've made him!!! Am absolutely appalled that he didnt 'sequence' matters in the right order by editing!!!   Im now crying in a corner!  Although the use of the word 'safe' makes me realise that a certain Mr Mod knows how lethal I can be, lol

Thank you John for your kind words, I have re-organised the membership numbers to ensure VIP members are easily recognisable  - thats  all Im saying.    Plus dropping an email to Portia to tell her to back off BKN!  wink

Thank you Shaun evileyeevileye

 



-- Edited by Cheshire on Tuesday 17th of May 2016 01:36:11 AM


 <cough> You will notice that I wasn't easily persuaded by Shaun's attempt to replace you in pole position and that this will be remembered on the next cake run </cough>



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Slightly irrelevant, yet I digress..lol What I like with LTD, as an oppose to SE is that unless your profits are sky high, there is no need for POA. That to me is enough to incorporate - January 31 can be extremely expensive, even with low profits.

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Ssssh, don't give them any idea's Johnny!



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Leger wrote:


 <cough> You will notice that I wasn't easily persuaded by Shaun's attempt to replace you in pole position and that this will be remembered on the next cake run </cough>


Oh it was noticed. 

Just made me forget to look at Jay's spreadsheet, must do that when I have a minute



-- Edited by Cheshire on Tuesday 17th of May 2016 01:06:47 PM

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Jay3 wrote:

Thanks everyone!

John, would you mind posting the spreadsheet back with your formula fixes. That would be helpful.


Sorry Jay, nearly missed this.  I've tinkered a bit more now and if you alter the salary in box D28 it will change the details on the far right as well.  I've also worked out how to change the negative figures to zero too.  Will work fine now unless any of the dividends attract the 32.5% tax rate.



Attachments
Tax Calc.xlsx (23.4 kb)
__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Thanks John much appreciated. I'll take a look now. =D

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Guys & Gals,

Could someone take a look at my additions to the spreadsheet please and let me know your thoughts.

 

I have added an additional section for multiple directors taking Salary and Dividends in theory is what I have done correct?

Thanks,

Jayconfuse



Attachments
Tax Calc.xlsx (25.2 kb)
__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Anyone? :)



__________________


Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Hi Jay

Single Director one looks great, but the two director one won't work. You've made a glaring mistake on the dividends available 

Personally I would work out the total dividends available as per the right hand side and then do separate tallies for each director.  You could do that by having extra rows in far right dividend calculation 

eg Director/Shareholder 1 -  50% Director/Shareholder 2 - 50%   then add the necessary formula to the dividend total under the salary.   This would allow you to adjust the percentage ratio on unequal shareholdings.

Can I ask what P46 and P73 figures represent please?    



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi John

Thanks for pointing out that error I hadn't updated the cell reference for dividends to point to the new column I added for the multiple directors calc.

Hopefully this version makes more sense.  The P references were just comparing the tax savings compared to the Salary only model.

 

Thanks,

Jay



-- Edited by Jay3 on Saturday 21st of May 2016 09:47:21 PM

Attachments
__________________


Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Hi Jay

I see how you've done it and looks all good,

 



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Thanks Leger =D

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Jay,

just wondering why you have changed from referring to everyone by there real names to referring to everyone by their user names?

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Hi Shaun,

No reason, just tired and making silly mistakes! Oops!

Thanks,
Jay

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Whilst we are on that one, it's Joanne not Jo.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position

1 2  >  Last»  | Page of 2  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About