Incentive calculation formula after Tax

[Nandakumar]

Dear Experts,

I need assistance in creating a formula to calculate incentives after tax, considering multiple incentive slabs. The formula should factor in tax deductions applicable to each slab and provide a clear post-tax incentive amount for different levels of performance.

Below are the summary of the data:

Incentive slabs​

IF NP is upto or less than 110% achievement against budget, incentive will be 3.5%.If achievement is less than 100% achievement, no incentive.​

Anything above 110% achievement against budget, incentive will be 10%​

All incentive calculation will be after tax​

Please let me know if you need any additional details or data to proceed. Your expertise in structuring this calculation would be highly appreciated.

Looking forward to your response.

 

[vletm]

Nandakumar​

Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Your post has moved to Ask an Excel Question.

 

[Nandakumar]

OK Thanks for moving this to excel question.

Hope for the answers.

 

[Nandakumar]

Anyone can help?

 

[vletm]

How did You get those pictures values?
Could You send an Excel-file?
Could You name - which value needs formula?