I need an excel expert
Budget: $30 – $250 USD
Below are ideas. I would like for you to put it in excel and model out the potential.
Part A: CEO Salary $300,000 annually
Part B: 50% of Base Salary available in an annual bonus based on 100% of Target.
Think of Target as a budget or specific goals each year set by owner of business.
It would flex down to 80% and up to 125%. At 80% of target, you would earn 80% of potential bonus (80% X 50% of Base Salary). The same math would apply up to 125%.
Part C: Incentive Vesting. We would target a CEO holds a 5% Phantom Equity position with a floor set at our purchase price which will reset to the combined purchase prices with each acquisition.
At exit, a CEO is entitled to the equity creation above the base (probably based on a pre-set equation like EBITDA X 4.5 multiple... minus base or debts, whichever is greater).
The vesting will also be over 4 years as follows:
* Vesting begins at 25% at 1 year.
* Thereafter, vesting grows Q'ly at a rate of 6.25%.
* Fully vested at 4 years.
Part A: CEO Salary $300,000 annually
Part B: 50% of Base Salary available in an annual bonus based on 100% of Target.
Think of Target as a budget or specific goals each year set by owner of business.
It would flex down to 80% and up to 125%. At 80% of target, you would earn 80% of potential bonus (80% X 50% of Base Salary). The same math would apply up to 125%.
Part C: Incentive Vesting. We would target a CEO holds a 5% Phantom Equity position with a floor set at our purchase price which will reset to the combined purchase prices with each acquisition.
At exit, a CEO is entitled to the equity creation above the base (probably based on a pre-set equation like EBITDA X 4.5 multiple... minus base or debts, whichever is greater).
The vesting will also be over 4 years as follows:
* Vesting begins at 25% at 1 year.
* Thereafter, vesting grows Q'ly at a rate of 6.25%.
* Fully vested at 4 years.