Retrieved from https://studentshare.org/finance-accounting/1638893-bonus-example-writing-assignment
https://studentshare.org/finance-accounting/1638893-bonus-example-writing-assignment.
BONUS Use the data below to answer the questions. Employee Salary Grade Annual Salary Performance Rating Sarah 10 58,000 3 Ben 12 80,000 Stephen 1164,0001Mary1278,0002Jennifer1060,0003Salary GradeBonus Target108%118%1210%1. Determine the monthly accrual amount for each of the 5 employees based on the target plus 1% accrual assumption.EmployeeSalary GradeAnnual SalaryPerformance RatingBonus TargetBonus AwardMonthly Accrual Amount (Bonus Award + 1% of Annual Salary)Sarah1058,00038%4,6405,220Ben1280,000110%8,0008,800Stephen1164,00018%5,1205,760Mary1278,000210%7,8008,580Jennifer1060,00038%4,8005,4002.
Determine the total payout for each employee based on the actual payout percentage; be sure to include any adjustments for performance.EmployeeSalary GradeAnnual SalaryPerformance RatingBonus TargetBonus AwardIncreased Bonus Award due to company’s performance (125%)Sarah1058,00038%4,6405,800Ben1280,000110%8,00010,000Stephen1164,00018%5,1206,400Mary1278,000210%7,8009,750Jennifer1060,00038%4,8006,000EmployeeIncreased Bonus Award due to company’s performance (125%)Performance RatingAdditional Bonus on Individual PerformanceIncreased Bonus AwardSarah5,8003-5,800Ben10,000120%12,000Stephen6,400120%7,680Mary9,750210%10,725Jennifer6,0003-6,000EmployeeIncreased Bonus AwardMonthly Accrual Amount (Bonus Award + 1% of Annual Salary)Total PayoutSarah5,8005,220580Ben12,0008,8003,200Stephen7,6805,7601,920Mary10,7258,5802,145Jennifer6,0005,4006003.
Assume these employees all pay 39% tax on their bonus. What is their total after tax take home bonus, per employee?EmployeeTotal PayoutTax on Bonus @39%After Tax BonusSarah580226.20353.80Ben3,2001,248.001,952.00Stephen1,920748.801,171.20Mary2,145836.551,308.45Jennifer600234.00366.004. Write a short (professional) email to the CFO of the company explaining the total bonus payout using the 125% of target, including all performance adjustments. Explain the differences between the total accrual and the total payout number.
Email:The Chief Financial Officer[Company Name]I am writing this email to you in respect of the annual bonus to employees for the financial year ended December 31, 2013. The bonus will be paid out to the employees on January 15, 2014.The company has decided to payout the bonus to employees at 125% of the target. The bonus target is set as a percentage of the employee’s salary and also depends on the employees’ salary grades; the higher the salary grade, the greater will be the bonus target.
For the year 2013, normal bonus award amounts to $30,360. The additional 125% of the bonus target is being paid out to the employees due to the company’s good performance. You will appreciate that this better performance may not be achieved without the hard efforts the employees have put in. So, they deserve to enjoy a portion of company’s profits that is the result of their untiring efforts. The annual bonus payout at 125% amounts to $37,950.Besides company’s performance, the employees are also awarded with bonuses on the basis of their individual performances as per company policy.
For evaluating individual performance, the company has maintained “Employee’s Performance System” through which all employees are given performance rating on the basis of their performance in the year. The bonus of the employees receiving performance rating 1 is increased by 20% and that of receiving performance rating 2 is increased by 10%. No increase in bonus is awarded to employees receiving bonus rating less than 2. The annual bonus due to performance rating is increased to $42,205.
The company has a policy to accrue each year bonus using the target bonus percentage plus 1% for performance fluctuations. The accrued bonus for the year amounts to $33,760. The gross bonus payout to employees amounts to $8,445 ($42,205-$33,760). The tax is payable on bonuses on cash basis @39%. The total tax payment amounts to $3,249. Thus the net after tax bonus for the employees is $5,151.I want to further explain to you regarding the difference between the total accrual and the total bonus payout.
The bonus is accrued at the percentage of target plus 1% of the annual salary. This accrual does not includes the effects of fluctuations in bonuses occurred due to company’s performance and individual performances of the employees. On the other hand, the total bonus payout is calculated after incorporating the effects of company as well as individual performances. Thus, the difference is necessarily exist between these two amounts.I believe that the above email will suffice your requirements regarding bonus payout calculations.
However, I shall be pleased to provide you any further information, should you so desire.Manager Finance[Your Name]
Read More