# Leverage Payouts on Percentages

#### exceldotcom

##### New Member
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 Score Payout 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:

### 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).

Replies
4
Views
313
Replies
0
Views
535
Replies
11
Views
1K
Replies
0
Views
216
Replies
1
Views
317

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.

### Which adblocker are you using?

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

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