Forumula for calculating Corportation Tax and NI.

marleyuk

New Member
Joined
Jul 6, 2012
Messages
17
Hi,

I'd like help attempting to create a forumula for calculating how much corportation tax is due after each months invoices have been submitted.

I've set it up to confirm expenses, wages and dividends each month so i'd like to use this information to produce the figures for the above.

I.e. If I draw £800 salary each month, and the allowance is £650, Id like to calculate the tax payable on the remaining £150.

And if I was to draw dividends out monthly or quaterly, if I hit the threshold (£25k or what ever it is at 11%) how much additional tax would be payable on the remaining dividends (as an example it may go up to 20% payable).

The % isnt that important as I could change that anytime but the forumula itself seems like it could be quite complex.

If this doesnt make any sense let me know.

Cheers,
Ian.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

radfordc

New Member
Joined
Dec 7, 2006
Messages
28
would need to see a sample workbook,
are you using a separate sheet for each month?
will you be doing a running total on salary etc,
is dividends different to salary?
 

marleyuk

New Member
Joined
Jul 6, 2012
Messages
17
would need to see a sample workbook,
are you using a separate sheet for each month?
will you be doing a running total on salary etc,
is dividends different to salary?

Thanks for the reply.

It is currently a seperate sheet for each month. There is a summary page which produces the running total on income, expenses, and wages & dividends is currently combined (although it could be split).

The company is fairly new so I am paying a minimum salary to myself and taking dividends every few months when needed.

With that in mind, Im thinking the calc would probably be something like upto the first £7k, no tax due, after that, its 11% because its a dividend. Does that sound correct?

Cheers,
Ian.
 

radfordc

New Member
Joined
Dec 7, 2006
Messages
28
As i said I would need to see a workbook you are using to make a better contribution BUT i have done a simplistic table to enable you to carry on!
Formula are under the relevant columns, can be done similar for dividands

a b c d e

salary allowance difference tax rate tax payable
£800.00 £600.00 £200.00 0.20 £40.00
=A6-B6 =C6*D6
 

Watch MrExcel Video

Forum statistics

Threads
1,122,805
Messages
5,598,173
Members
414,217
Latest member
Mystix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top