Need Formula For Excel For Incentive Plan Urgent

preeti008
Masters of Excel, please help. This is urgent.

For example:
Salary = 7000
Break-even point = 7000*3

Let incentive earn = 500000
The incentive has to be passed through these 3 stages:
Stage 1
63,000 - 1.00 Lac = 17%
Stage 2
1.00 - 1.50 Lac = 22% of the remaining amount
Stage 3
1.50 Lac and above = 27% of the remaining amount

Please suggest the formula for Excel.

For further assistance, please contact 9977266555. Please contact so that I can further explain.
Mani_2677
Madam,

I will help. Please clarify the points below:

1. What is Break Even Point?
2. What does it mean - 3 months or years?
3. The stages you have mentioned in [%], are they standard or subject to change?
4. How can we identify the values mentioned in the stages?

Thank you.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute