Leverage Payouts on Percentages

exceldotcom

New Member
Joined
Jul 2, 2018
Messages
15
Hi everyone,

Happy Friday!

I'm trying to work out a couple of things regarding leveraged payouts, i.e. if I hit 120% of X production, I get paid out 140% of my X dollar payout.

Scenario: performance score of $1M. My bonus payout is targeted at $50,000 but the production of $1M represents a 50% weighting of that bonus payout ($25,000). Not sure if this is important or not for the calculation.

The formula I'm using to work out the payout at each breakpoints is "=AZ8*$AR$4*$AR$2" (="Payout % of Target (20%)"*Target($50,000)*Weighting(50%). This seems to get me to the number I need. However! At the end of my below grid is the phrase "Every 1% Above 200%". I'm trying to work out a formula that provides me with the $ value for each 1% above 200%. I'm totally blanking on this.

[TABLE="width: 320"]
<tbody>[TR]
[TD][TABLE="width: 320"]
<tbody>[TR]
[TD]Performance Score[/TD]
[TD]Payout as % of Target[/TD]
[/TR]
[TR]
[TD]0%[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]25%[/TD]
[TD]20%[/TD]
[/TR]
[TR]
[TD]63%[/TD]
[TD]56%[/TD]
[/TR]
[TR]
[TD]100%[/TD]
[TD]100%[/TD]
[/TR]
[TR]
[TD]125%[/TD]
[TD]140%[/TD]
[/TR]
[TR]
[TD]167%[/TD]
[TD]200%[/TD]
[/TR]
[TR]
[TD]200%[/TD]
[TD]240%[/TD]
[/TR]
[TR]
[TD]Every 1% Above 200%[/TD]
[TD]???[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Deeply appreciate any assistance than can be provided! Have a great weekend!
 
Last edited:

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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