DEFERRED COMP CALCULATION TOOL Annual Employee Infotype 0008 Comp service Soc. Sec. Retirement Local Deferral Type Name Pernr Hourly/ Salary Status Pay Amount Annual Hrs Sick Hrs Hrs months Hrs/ Week Taxable YTD Deferral YTD Plan Tax Rate Maximum amount of annual hours Enter Annual Service 0.00 Enter Employee Name The Link to KY Withholding Local Tax If employee is exempt from Codes can be found at Social Security enter http://personnel.ky.gov/persadmin/hradmi Sick balance after Annual conversion 0.00 Enter Annual Service "Exempt" ==> nistrators/tm-pi.htm under "Pay". Annual Deferred Comp Deferred Agency Cost Enter Deferral Amount Enter Deferral Amount Total Annual Cost $0.00 Total Comp Cost $0.00 Total Agency Cost $0.00 Annual Pay Out Comp Pay Out Annual Leave Hrs = 0.00 Comp Leave Hrs = 0.00 Hourly Pay Rate = $0.000 Retirement Rate Employee Total Net Pay and Deferral Total Annual and Comp Net Pay $0.00 Gross Pay = $0.00 $0.000 Soc. Sec. Tax = $0.00 Hourly Pay Rate = $0.00 Total Amount to be Deferred $0.00 Medicare Tax = $0.00 Gross Pay = $0.00 Federal Tax = $0.00 Soc. Sec. Tax = $0.00 State Tax = $0.00 Medicare Tax = $0.00 Local Tax Amount $0.00 Federal Tax = $0.00 Net Pay = $0.00 State Tax = $0.00 Local Tax = $0.00 ER Retirement = $0.00 Net Pay = $0.00 DISCLAIMER: revised 9/11 This Payout Calculator Spreadsheet was created as a tool to assist in calculations. Accuracy of results obtained by use of the tool depends upon the accuracy of the data entered. Users should carefully evaluate the accuracy and completeness of these calculations before relying on same. The Personnel Cabinet accepts no responsibility for the accuracy of the results arising from the calculation. This spreadsheet provides estimates ONLY. It is intended to be used as a calculation tool when an employee wants to defer their annual or comp payouts Final accruals and pay should be taken into consideration for the calculation. Users enter the information needed in the light blue fields across the top of the sheet. This includes: Deferral Type (has a drop-down box for Retirement, Nonretirement, Block 50) Employee name Pernr Hourly/Salary Status (has drop-down box) Infotype 0008 Pay Amt Annual Hrs Sick Hrs Comp Hrs Annual Service Months Hours/Week (has drop-down box) Social Security Txbl YTD Deferral YTD Retirement Plan (has drop-down box) Local Tax Rate and, in the two tables for calculation: Annual Deferred (as a dollar amount) Comp Deferred (as a dollar amount) Enter "Exempt" in the field to the right of "If employee is exempt from social security enter exempt" If the employee The green fields show the calculations. The black fields offer prompts and warnings in red letters. Upon the user-provided fields being entered, the sheet will perform calculations from gross to net using the information provided. This sheet is an estimate only. Users should verify the accuracy of the results. al or comp payouts exempt" If the employee does not pay Social Security to net using of the results.
Pages to are hidden for
"Deferred Comp Calculation Tool"Please download to view full document