The net is not really that net. Example Post
#18 . Gross 13,865,976 - tax 1,538,504 = 12,327,472 which is not equal the target net.
13,865,976 x 20% - 1,210,000 = 1,563,195.20. Gross 13,865,976 - 1,563,192.20 = 12,302,780.80 which is not the target net.
I think you misunderstand my calculations in post
#18 .
The "generated gross" is still 13,742,520 in B5. The calculated tax is still 13,742,520*20% - 1,210,000 = 1,538,504 in B6. And the calculated net is still 13,742,520 - 1,538,504 = 12,204,016 in B7. And that matches the target net in B2, as demonstrated by the comparison in E7.
-----
In post
#17 , you wrote: ``I would like to add whatever amount to the generated gross and would like to keep the net the same``.
I should have asked you to provide an example of the calculation.
And I should have asked what you call the "amount" to be added to the "generated gross", and what you call the result of adding that amount to the "generated gross".
I am asking you for that information now.
-----
I thought I understood. (Frankly, I still do.)
Lacking a concrete example, I made up my own "additional amount" (123,456 in in B4). And I add it to the "generated gross", creating 13,742,520 + 123,456 = 13,865,976 in B3.
I think you are confused because I also changed the names of things in order to conform to
typical salary terminology (in the USA, at least).
I assumed that 13,865,976 is the
contractual salary that the employee earns. In the US, we call
that amount the "gross".
And I assumed that 123,456 is the "deductions" from gross. In the US, that is the amounts that are subtracted from the contractual salary before calculating tax on the remainder.
So I renamed the "generated gross" to "taxable income". In the US, that is what we call remaining amount that is taxed.
I believe the calculations in post
#18 are correct, according to your specifications. Only the names have been changed.
The amount that I call "taxable income" is the amount that you call "generated gross".
And the amount that I call "gross" is the amount that results from "adding whatever amount to the generated gross, keeping the net the same", as you required.
-----
Be that as it made, all will be clearer if we continue to call the amount in B5 the "generated gross" the "gross".
And if you tell me what to call the amounts in B4 and B3: the amount added to the "generated gross" (B4); and the result of that addition (B3).