Docstoc

Salary Calculator - Download as Excel

Document Sample
Salary Calculator - Download as Excel Powered By Docstoc
					                                     Basic Salary prior to Implementation

                   Out of Hours Intensity Band prior to Implementation

                     Discretionary Points Held prior to Implementation

                    Age at Implementation (Enter value directly to box)

                     Month Of Appointment to Current Consultant Post

                                                  Current Daytime Intensity

RESULTS              Current Salary incl any Out of Hours            Dec
                    and Daytime Intensity & Discretionary            2003
                                    Points                      On assimilation
TOTAL SALARY                       £71,830.00                   £      76,910
                 New Salary Scale Point                             Basic 4
                   Annual Salary Rise                           £         5,080
                 Cumulative Salary Rise                         £         5,080
               Monthly Amount Over Current                      £           423

                      % Rise each year                                        7.1%
             % Cumulative rise from current pay                               7.1%
  Current Value of Discretionry Points (DP) Carried Forward                      0
              Committment Award (CA) Given
       The CA and DP are included in the Total Salary                            0
                                                                Retirement age of 65 is indicated by shaded are
RESULTS Contd        Current Salary incl any Out of Hours            Dec
                    and Daytime Intensity & Discretionary            2011
                                    Points
TOTAL SALARY                       £71,830.00                   £      87,735
                  New Salary Scale Point                            Basic 6
                   Annual Salary Rise                           £               -
               Cumulative Annual Salary Rise                    £          15,905
                       Monthly Rise                             £           1,325

                      % Rise each year                                       0.0%
             % Cumulative rise from current pay                             22.1%
  Current Value of Discretionry Points (DP) Carried Forward                     0
                                                   CA Awarded
      The CA and DP are included in the salaries above                        5670
                                                                Retirement age of 65 is indicated by shaded are
RESULTS Contd        Current Salary incl any Out of Hours            Dec
                    and Daytime Intensity & Discretionary            2019
                                    Points                             1
TOTAL SALARY                       £71,830.00                   £      96,240
                  New Salary Scale Point                            Basic 6
                   Annual Salary Rise                           £         2,835
               Cumulative Annual Salary Rise                    £        24,410
                       Monthly Rise                             £           2,034

                      % Rise each year                                       3.9%
             % Cumulative rise from current pay                             34.0%
  Current Value of Discretionry Points (DP) Carried Forward                     0
                                                   CA Awarded                yes
      The CA and DP are included in the salaries above                      14175
                                                                Retirement age of 65 is indicated by shaded are
RESULTS Contd        Current Salary incl any Out of Hours            Dec
                    and Daytime Intensity & Discretionary            2027
                                    Points                             1
TOTAL SALARY                      £71,830.00                    £     101,910
                 New Salary Scale Point                             Basic 6
                  Annual Salary Rise                            £               -
              Cumulative Annual Salary Rise                     £          30,080
                      Monthly Rise                              £           2,507

                      % Rise each year                                       0.0%
             % Cumulative rise from current pay                             41.9%
  Current Value of Discretionry Points (DP) Carried Forward                     0
                                                   CA Awarded
      The CA and DP are included in the salaries above                      19845
                                                                Retirement age of 65 is indicated by shaded are
                     70715                             Simply fill in your details from the drop down
                                                       boxes in the purple cells for an indication
                       0                               of your salary under the proposed Welsh Scheme
                                                 Use the 'Tab' Key to move between cells
                       0                         Salary indicated is for a 10 session Full time contract.
                                                 Any additional sessions will be extra to the indicated salaries
                       50                        Part Timers will be remunerated pro rata.
                                              NB ALL AMOUNTS RELATE TO CURRENT (2003-4) RATES. THE FUTURE
                      Sep                        RATES WILL BE FURTHER INCREASED IN LINE WITH DDRB (Doctors
                                                 & Dentists Review Body) RECOMMENDATION AS NORMAL, ANNUALLY
                      Full                       BEGINNING IN APRIL 2004
                                                 No account is made for A/B Distinction Awards which should be added.
                     Dec                 Dec         Dec            Dec           Dec            Dec
                     2004                2005        2006           2007          2008          2009

                 £      79,485       £     82,065      £     82,065      £     84,900      £     84,900      £     84,900
                     Basic 5             Basic 6           Basic 6           Basic 6           Basic 6           Basic 6
                 £         2,575     £        2,580    £           -     £        2,835    £            -    £            -
                 £         7,655     £       10,235    £      10,235     £       13,070    £       13,070    £       13,070
                 £           638     £           853   £         853     £        1,089    £        1,089    £        1,089

                              3.6%             3.6%             0.0%               3.9%              0.0%              0.0%
                             10.7%            14.2%            14.2%              18.2%             18.2%             18.2%
                                 0                0                0                  0                 0                 0
                                                                                   yes
                                0                  0                 0             2835               2835              2835
Retirement age of 65 is indicated by shaded area
                     Dec                 Dec               Dec               Dec               Dec               Dec
                     2012                2013              2014              2015              2016              2017

                 £      87,735       £     90,570      £     90,570      £     90,570      £     93,405      £     93,405
                     Basic 6             Basic 6           Basic 6           Basic 6           Basic 6           Basic 6
                 £              -    £        2,835    £           -     £            -    £        2,835    £            -
                 £         15,905    £       18,740    £      18,740     £       18,740    £       21,575    £       21,575
                 £          1,325    £        1,562    £       1,562     £        1,562    £        1,798    £        1,798

                              0.0%             3.9%             0.0%               0.0%              3.9%              0.0%
                             22.1%            26.1%            26.1%              26.1%             30.0%             30.0%
                                 0                0                0                  0                 0                 0
                                               yes                                                   yes
                              5670             8505             8505                8505            11340             11340
Retirement age of 65 is indicated by shaded area
                     Dec                 Dec               Dec               Dec               Dec               Dec
                     2020                2021              2022              2023              2024              2025
                      min
                 £      96,240       £     96,240      £     99,075      £     99,075      £     99,075      £    101,910
                     Basic 6             Basic 6         Basic 6             Basic 6           Basic 6           Basic 6
                 £              -    £            -    £     2,835       £            -    £            -    £        2,835
                 £         24,410    £       24,410    £    27,245       £       27,245    £       27,245    £       30,080
                 £          2,034   £        2,034   £       2,270   £        2,270   £        2,270   £        2,507

                             0.0%             0.0%            3.9%             0.0%             0.0%             3.9%
                            34.0%            34.0%           37.9%            37.9%            37.9%            41.9%
                                0                0               0                0                0                0
                                                              yes                                                yes
                            14175            14175           17010            17010            17010            19845
Retirement age of 65 is indicated by shaded area
                     Dec                Dec              Dec             Dec              Dec              Dec
                     2028               2029             2030            2031             2032             2033
                      min
                 £    104,745       £    104,745     £ 104,745       £    104,745     £    104,745     £    104,745
                     Basic 6            Basic 6          Basic 6         Basic 6          Basic 6          Basic 6
                 £         2,835    £            -   £           -   £            -   £            -   £            -
                 £       32,915     £       32,915   £      32,915   £       32,915   £       32,915   £       32,915
                 £         2,743    £        2,743   £       2,743   £        2,743   £        2,743   £        2,743

                             3.9%             0.0%            0.0%             0.0%             0.0%             0.0%
                            45.8%            45.8%           45.8%            45.8%            45.8%            45.8%
                                0                0               0                0                0                0
                             yes
                            22680            22680           22680            22680            22680            22680
Retirement age of 65 is indicated by shaded area
ed Welsh Scheme


 o the indicated salaries

 T (2003-4) RATES. THE FUTURE
ED IN LINE WITH DDRB (Doctors
DATION AS NORMAL, ANNUALLY

 wards which should be added.
                      Dec
                      2010

                   £     87,735
                       Basic 6
                   £        2,835
                   £       15,905
                   £        1,325

                              3.9%
                             22.1%
                                 0
                              yes
                              5670

                       Dec
                       2018

                   £     93,405
                       Basic 6
                   £             -
                   £        21,575
                   £         1,798

                              0.0%
                             30.0%
                                 0

                             11340

                       Dec
                       2026

                   £    101,910
                       Basic 6
                   £             -
                   £        30,080
£        2,507

          0.0%
         41.9%
             0

         19845

    Dec
    2034

£    104,745
    Basic 6
£            -
£       32,915
£        2,743

          0.0%
         45.8%
             0

         22680

				
DOCUMENT INFO
Description: This is an example of salary calculator. This document is useful for calculating salary.