Hi

I have an exam question that I am stuck with. Please can you solve urgently using Excel. Thanks!!


EBITDA Payout %
Budget: 76,500,000 16.67%
Max Target 91,417,500 100%

If EBTIDA Budget is achieved then 16.67% of Bonus Opportunity is paid

If EBTIDA Max is achieved then 100% of Bonus Opportunity is paid

EBITDA achievement between Budget and Max is paid on a straight line basis between 16.67% and 100%

What would be the % & GPD amount for TBS payout for achieving £85m EBITDA?
What would the EBITDA Acheivement need to be for the TBS to pay out 50% of bonus opportunity?