Can anyone help me with this maths question

richiwatts

Board Regular
Joined
Aug 27, 2002
Messages
131
Our local tax office couldn't answer this question and was hoping you can:

To work out how much it would cost a company to pay someone in Sweden you calculate as follows:

net + 33% tax + 32.82% employers tax = total cost
£1000 + 33% tax + 32.82% employers tax = £3096.50 total cost

But the problem is how do you calculate that backwards?

If the company can pay £4000 how would you get the amount for:
net = £
tax = £
Employers tax =£

Thank you in advance for any help
Richi
 
richiwatts,

Richie's right if tax is 33% of the gross. That's not how your question was phrased, so be careful with my solution.
 
Upvote 0

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Andrew,

You had it right, it was probably the way I worded the question but your solution gets me to the figure i need.

To get to the gross i have always added 33% to what i take out as net
 
Upvote 0

Forum statistics

Threads
1,216,180
Messages
6,129,342
Members
449,505
Latest member
Alan the procrastinator

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
Back
Top