【股权激励指标测算工具】股权激励分红试算表-新版（超额非区间累计）

,,,,,,,,,,,,,,,,

,,超额利润分红机制（非区间累计）,,,,,,,比例区间,超额比例,利润目标超额情况,,,,

,,实际利润完成比例,,100%<A≤120%,120%<A≤150%,150%<A≤180%,A>180%,,0%,0,300,,,,

,,超额提成比例,,15%,20%,25%,30%,,100%,15%,360,,,,

,,黄色部分可根据公司实际修改，其他数据是自动生成的，不允许修改！,,,,,,,120%,20%,450,,,,

,,可以直接调整区间内的比例数字（如180%改200%）,,,,,,,150%,25%,540,,,,

,,公式在读取比例时使用了文本函数。所以比例格式不能有任何变化，多加空间或符号都会导致数据计算错误。,,,,,,,180%,30%,"90,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00",,,,

,,,,,,,,,注意：上表数据为字典表，自动生成数据，请勿修改数据与格式,,,,,,

,,利润目标,300,利润达成,1300,,,,,,,,,,

,,目标保底完成率,70%,保底目标,210,,,,,,,,,,

,,超额利润总额,1000.00,超额分红总额,300,,,,,,,,,,

,,在职分红核算基数,300.00,在职分红比例,10%,,,,,,,,,,

,,在职分红总额,30,在职分红总股本,100000,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,激励对象绩效考核系数,,,,,,,,,,,,,

,,考核结果,X≥85,75≤X＜85,65≤X＜75,60≤X＜65,X＜60,,,,,,,,

,,考核系数,1,0.8,0.6,0.5,0,,,,,,,,

,,各激励对象2017年分红试算表,,,,,,,,,,,,,

,,激励岗位,姓名,岗位分数,分配比例,"预授总股数

（股）",价值观系数,年终绩效考核分数,绩效考核系数,人才培养系数,实际获得股数,考核后实际分红比例,超额分红,在职分红,超额+在职

,,总经理,张三,1500,34.88%,34884,1,85,1,1,34884,34.88%,104.651,10.465,115.116

,,副总经理,李四,950,22.09%,22093,1,85,1,1,22093,22.09%,66.279,6.628,72.907

,,人力行政部经理,王五,400,9.30%,9302,1,85,1,1,9302,9.30%,27.907,2.791,30.698

,,财务部经理,赵六,450,10.47%,10465,1,85,1,1,10465,10.47%,31.395,3.140,34.535

,,市场部经理,陈七,500,11.63%,11628,1,85,1,1,11628,11.63%,34.884,3.488,38.372

,,客服部经理,黄八,500,11.63%,11628,1,85,1,1,11628,11.63%,34.884,3.488,38.372