【股权激励指标测算工具】股权激励分红试算表-新版

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

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

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

,,超额提成比例,,15%,20%,25%,30%,,100%,15%,"1,200",,,,

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

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

,,公式在读取比例时使用了文本函数。所以比例格式不能有任何变化，多加空间或符号都会导致数据计算错误。,,,,,,,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",,,,

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

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

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

,,超额利润总额,300.00,超额分红总额,50,,,,,,,,,,

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

,,在职分红总额,100,在职分红总股本,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%,17.442,34.884,52.326

,,副总经理,李四,950,22.09%,22093,1,85,1,1,22093,22.09%,11.047,22.093,33.140

,,人力行政部经理,王五,400,9.30%,9302,1,85,1,1,9302,9.30%,4.651,9.302,13.953

,,财务部经理,赵六,450,10.47%,10465,1,85,1,1,10465,10.47%,5.233,10.465,15.698

,,市场部经理,陈七,500,11.63%,11628,1,85,1,1,11628,11.63%,5.814,11.628,17.442

,,客服部经理,黄八,500,11.63%,11628,1,85,1,1,11628,11.63%,5.814,11.628,17.44