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.

Performance ScorePayout as % of Target
0%0%
25%20%
63%56%
100%100%
125%140%
167%200%
200%240%
Every 1% Above 200%???

<tbody>
</tbody>

<tbody>
</tbody>


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

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,127,972
Messages
5,627,933
Members
416,282
Latest member
fchagas97

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
Top