Customize your cookie preferences

We respect your right to privacy. You can choose not to allow some types of cookies. Your cookie preferences will apply across our website.

We use cookies on our site to enhance your user experience, provide personalized content, and analyze our traffic.

[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y / ] [Home]
4chanarchives logo

Howdy /sci/, first time posterWorking on something for work (in my own time as a


Thread replies: 11
Thread images: 4

File: FockingFormulas.png (12KB, 433x154px) Image search: [Google] [Yandex] [Bing]
FockingFormulas.png
12KB, 433x154px
Howdy /sci/, first time poster

Working on something for work (in my own time as a bit of a project) and I'm stuck with an equation I need to reverse for working out wages.

The formulas we're provided with will calculate tax on a gross amount, which is withheld and the employees get paid the net amount after tax. I want to work it backwards.

We're given the following formula

>y=ax-b
>Where y=tax
>a=gross
>x= Coefficient x
>b= Coefficient b
>n= net

I'm bloody hopeless at math and even worse with algebra so the closest I've come is

>n=g-(gx-b)

But stuffed if I know how to solve it.

Pic is my silly table.
>>
File: 1447007615987.gif (991KB, 224x179px) Image search: [Google] [Yandex] [Bing]
1447007615987.gif
991KB, 224x179px
Bump
>>
>>7654230
Question is not clear. You're given
Gross = Net - Tax
Tax = Gross * X - B

And you want to solve for what as a function of what?
>>
File: aXcoQAe.jpg (3MB, 2448x1648px) Image search: [Google] [Yandex] [Bing]
aXcoQAe.jpg
3MB, 2448x1648px
>>7654253

In a real situation, we are only given the Net amount.

Given that I know what X and B are for that particular figure, I want to be able to figure out the tax on Net.
>>
>>7654259
What is tax on net, isn't the tax on the gross amount?
>>
>>7654269

Sorry yeah. I'm braindead from trying to figure this out.

The normal way to figure it out would be

>Gross -> Tax -> Net (being Gross - Tax)

I want to follow this backwards, being

>Net -> Tax -> Gross
Reason I'm trying to do this is nearly 100% of all small clients will draw a cash wage for their employees and tell us to work out the tax when they bring their books up, which takes ages as we need to work backwards from the tax rate tables (provided by our govt)

I was hoping I could automate this in a spreadsheet to make it a little quicker
>>
>>7654259

Tax = Gross * X - B
Since Gross = Net - Tax
Tax = (Net - Tax) * X - B
Tax = Net * X - Tax * X - B
Tax + Tax * X = Net * X - B
Tax (1+X) = Net * X - B
So
Tax = (Net * X - B)/(1+X)
and
Gross = Net - (Net * X - B)/(1+X)
>>
>>7654293

The tax formula doesn't seem to work...I'm getting $53.265 instead of $82.8358?

Thanks for helping out, by the way. So glad I'm finally getting somewhere with this project (been working on it for months!)
>>
>>7654312
My mistake, replace 1+X with 1-X since Gross = Net + Tax, not Net - Tax
>>
>>7654323

That works!

Thanks man. I owe you pic related
>>
>>7654340
You're welcome anon
Thread replies: 11
Thread images: 4
[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y / ] [Home]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
If a post contains personal/copyrighted/illegal content you can contact me at imagescucc@gmail.com with that post and thread number and it will be removed as soon as possible.
If a post contains illegal content, please click on its [Report] button and follow the instructions.
This is a 4chan archive - all of the content originated from them. If you need information for a Poster - you need to contact them.
This website shows only archived content and is not affiliated with 4chan in any way.
If you like this website please support us by donating with Bitcoin at 1XVgDnu36zCj97gLdeSwHMdiJaBkqhtMK