Deferred Comp Calculation Tool by 98MO0hY9

VIEWS: 0 PAGES: 3

									                     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.

								
To top