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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

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