Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

NetWorth by 17EKTqfM

VIEWS: 0 PAGES: 16

									                        FINANCIAL PLANNING WORKSHEET                                                          Page 1
                                    ACTUAL                 PROJECTED                             REMARKS
NAME                                             SSN:                               11/17/2011
AGE
PAYGRADE (E1, W2,O1E, ETC.)                                                            Select from pulldown menu.
YEARS IN SERVICE                                                                      Select from pulldown menu.
DATE REPORTED/PRD (TRANSFER)                                                        Reported (Actual)/PRD (Projected)
MARITAL STATUS ( S, WD, P, G, D)    Gov't Qtrs              Gov't Qtrs              Select BAH from pulldown menu.
SPOUSE'S NAME
SPOUSE'S AGE                                                                         Required to compute FSGLI.
SPOUSE'S PLACE OF EMPLOYMENT
NUMBER OF CHILDREN and AGES                                                         Living with in act/away in proj.
HOME ADDRESS
WORK TELEPHONE
HOME TELEPHONE
COMMAND & REFERRED BY:                                                              Self, CMD, NMCRS, FFSC, Etc.
AMOUNT OF FSGLI ELECTED             100,000                  100,000                   Select from pulldown menu.
AMOUNT OF SGLI ELECTED              400,000                  400,000                   Select from pulldown menu.
TSP BASEPAY CONTRIBUTION                                                                Enter TSP Contribution %
TSP BONUS/INCENTIVE/SPECIAL PAY                                                            Enter Dollar Amount
MGIB MONTHLY CONTRIBUTION               0                        0                     Select from pulldown menu.
                                     STATEMENT OF NET WORTH
               ASSETS                                        LIABILITIES
CASH (On Hand)                                   Signature Loans
Checking Accounts                                Auto Loans or Lease
Saving Accounts                                  Consolidation Loans
Certificates of Deposits                         Student Loans
Cash value of life insurance                     NEX/AAFES (Star Card)
U.S. Savings Bonds                               Dept Store Credit Cards
Mutual Funds/Money Market                        Other Credit Cards
Stocks/Bonds                                     N&MCRS (Loan)
College Funds                                    Other (Friends, Relatives, etc.)
401(k)/403(b)/TSP                                Advance/Over Payments
Other (IRAs, etc.)
Real Estate (Market Value)                       Mortgages-Balances Due
Home                                             Home
Rental Property                                  Rental Property
Other (Vac Hm/Trailer/Time Share)                Other (Vac Hm/Trailer/Time Share)
Personal Property
Vehicles/Motorcycles/Boats
Furniture
Jewelry
Other (Collectibles, etc.)
TOTAL ASSETS                                     TOTAL LIABILITIES




NET WORTH


Counseling Provided By:


Counselor Phone #:
                                 MONTHLY INCOME                                                                                   Page 2
ENTITLEMENTS                                       ACTUAL                   PROJECTED                  REMARKS
Base Pay                                          $       -                 $        -
Basic Allowance for Housing (BAH I or II)         $       -       Gov't Qtrs$        -       Gov't QtrsSelect BAH from pulldown menu.
Overseas Housing Allowance (OHA)                                            $        -
Basic Allowance for Subsistence (BAS)             $       -         None $           -         None          Select F, P, R, N or C
Family Separation Allowance (FSA)                 $       -          No  $           -          No           Select Y=Yes or N=No
Flight Pay/Diving Pay/Flight Deck Pay             $       -              $           -
Submarine Pay                                     $       -         None $           -         None     N=N/A or select qualified years
Other Hazardous Duty Pay                          $       -              $           -
Sea Pay                                           $       -         None $           -         None     N=N/A or select qualified years
Taxable COLA                                      $       -                 $        -
Other (tax exempt/allowance eg. COLA/FSSA)        $       -                 $        -                      Non-tax, allowance line.
TOTAL MILITARY COMPENSATION (A)                   $       -                 $        -
Taxable pay (   )                                 $       -                 $        -                 Excludes pretax ded for TSP/MGIB
DEDUCTIONS: (Use CheckBox to include allotment in Spending Plan)
ALLOTMENT                                         $           -             $            -             For/ends?
ALLOTMENT                                         $           -             $            -             For/ends?
ALLOTMENT                                         $     -                   $      -                   For/ends?
ALLOTMENT                                         $     -                   $      -                   For/ends?
ALLOTMENT                                         $     -                   $      -                   For/ends?
ALLOTMENT                                         $     -                   $      -                   For/ends?
Meal Collection Deduction                         $     -                   $      -
Family SGLI (For Spouses)                           #NAME?                    #NAME?                   Amount from NetWorth Page
Servicemen's Group Life Insurance (SGLI)          $     -                   $      -                   Amount from NetWorth Page
Uniform Services TSP                              $     -                   $      -                   Amount from NetWorth Page
MGIB                                              $     -                   $      -                   Amount from NetWorth Page
FITW Filing Status Actual: Sin        0             #NAME?                    #NAME?                   Proj Status: Sin    0
FICA (Social Security)                            $       -                 $        -                 Base Pay only, Excludes MGIB
FICA (Medicare)                                   $       -                 $        -                 Base Pay only, Excludes MGIB
State Income Tax                                  $       -                 $        -                 State Claimed:
AFRH (Armed Forces Retirement Home)               $       -                 $        -
Tricare Dental Plan (TDP)                         $     12.69 Single        $      31.72 Family        None, Single, or Family.
Advance Payments                                                                                       Ends:
Over Payments                                                                                          Ends:
TOTAL DEDUCTIONS (B)                                  #NAME?                    #NAME?
CALCULATE NET INCOME             Hide Add Backs

Servicemember's Take Home Pay (A-B)                 #NAME?         #NAME?       #NAME?        #NAME?   Divide by 2 for Payday amount.
Servicemember's Other Earnings (less taxes)       $      -                  $        -
Spouse's Earnings (less taxes)                    $      -                  $        -
ALLOTMENT                                         $        -                $          -
ALLOTMENT                                         $        -                $          -
ALLOTMENT                                         $      -                  $        -
ALLOTMENT                                         $      -                  $        -
ALLOTMENT                                         $      -                  $        -
ALLOTMENT                                         $      -                  $        -
Meal Collection Deduction                         $      -                  $        -
Family SGLI (For Spouses)                           #NAME?                      #NAME?
Servicemen's Group Life Insurance (SGLI)          $      -                  $        -
Uniform Services TSP                              $      -                  $        -
MGIB                                              $      -                  $        -
Tricare Dental Plan (TDP)                         $    12.69                $      31.72
Advance Payments                                  $      -                  $        -
Over Payments                                     $      -                  $        -
Child Support/Alimony (Received/Income)           $      -                  $        -
Other Income (e.g. SSI, Rental Income)            $      -                  $        -
TOTAL NET MONTHLY INCOME                            #NAME?                      #NAME?
      MONTHLY SAVINGS AND LIVING EXPENSES                                                                                              Page 3
Note: Actual or Projected Figures are carried forward to spending plan.
          SAVINGS                                               ACTUAL         PROJECTED                REMARKS
     SAVINGS        Emergency Fund (1-3 Months)                                              Monthly Contribution Amount
   10% Minimum      Reserve Fund                                                             Monthly Contribution Amount
 Actual    Projected "Goal Getter" Fund                                                      Monthly Contribution Amount
                    Investments/IRAs/etc.                                                    Monthly Contribution Amount
#NAME?     #NAME? TSP
TOTAL SAVINGS AND INVESTMENTS (10%)                                                          Actual:
LIVING EXPENSES                                                 ACTUAL         PROJECTED                       REMARKS
                    Furnishings
   HOUSEHOLD        Maintenance/Repairs
                    Mortgage/Rent
                    Taxes/Fees
      FOOD          Dining Out
                    Food/Supplies
                    Lunches                                                                  Include school lunches and lunches at work
                    Vending Machines
                    Meal Deductions
     UTILITIES      Cable/Satellite TV
                    Cellular/Pagers/Phone Cards
                    Electricity
                    Internet Service
                    Natural Gas/Propane
                    Telephone                                                                Local = $________Long Distance = $ ________
                    Water/Garbage/Sewage
   CHILD CARE       Allowances
                    Daycare
                    Support                                                                  Include Other Dependant Care
   AUTOMOBILE       Gasoline
                    Maintenance/Repairs
                    Other
    CLOTHING        Laundry/Dry Cleaning
                    Purchases ($50 Monthly per Person)
    INSURANCE       Automobile
                    Health/Life                                                              Add additional insurance costs here.
                    Homeowners/Renters
                    SGLI/FSGLI                                    #NAME?         #NAME?      Both service member and Family SGLI
                    Tricare Dental                                    $12.69        $31.72
   HEALTHCARE       Dental
                    Eye care
                    Hospital/Physician
                    Prescriptions
    EDUCATION       Books
                    Fees (Other/Room & Board)
                    Tuition
                    MGIB                                                                     Montgomery GI Bill (MGIB)
 CONTRIBUTIONS      Charities (CFC/NMCRS)
                    Club Dues/Association Fees
                    Religious
     LEISURE        Athletic Events/Sporting Goods                                           Include Spectator Sports
                    Books & Magazines
                    Computer Products (Software/Hardware)
                    DVD/VHS & Video Games Rentals
                    DVD's & CD's
                    Entertaining
                    Lessons                                                                  Dance, Music, Self-Defense, Tutor, etc.
                    Toys & Games
                    Travel/Lodging
      GIFTS         Holidays
                    Birthdays/Anniversaries
 PERSONAL CARE      Barber/Beauty Shop
                    Beer/Liquor/Wine                                                         ABC, Package Store, etc.
                    Other
                    Tobacco Products
    PET CARE        Food/Supplies
                    Veterinarian/Service (Boarding/Grooming)
   JOB EXPENSE      Non-Reimbursed
                    Reimbursed
 MISCELLANEOUS      ATM Fees/Stamps/etc…
                    Other                                                                    Recommend $50-$150 Buffer
TOTAL MONTHLY LIVING EXPENSES (70%)                             #NAME?          #NAME?       Actual:
                                     INDEBTEDNESS (20%)                                                                                                 Page 4
          CREDITOR (ACCOUNT #/PHONE #)                PURPOSE         MO. PYMT       BALANCE       PROJ.PMT                                             APR
                                                                                                              REMARKS (MOS. BEHIND, PAID BY ALLOTMENT, ETC.)   (%)
1 US Govt.                                          Advance Pmts $          -                  $         -               Automatic Deduction
2 Gov't Credit Card                                 Over Payments $         -                  $         -               Automatic Deduction
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
                                                    TOTAL        $          -    $        -    $         -



                                                    ACTUAL       PROJECTED
     NET INCOME (Bottom of Page 2)                   #NAME?           #NAME?
     SAVINGS AND INVESTMENTS (Near Top of Page 3)
     LIVING EXPENSES (Bottom of Page 3)              #NAME?           #NAME?
     AMOUNT LEFT TO PAY DEBTS                        #NAME?           #NAME?
     DEBTS (Bottom of Page 4)
     SURPLUS OR DEFICIT                              #NAME?           #NAME?

     DEBT TO INCOME RATIO
                                                                                Page 5
                                ACTION PLAN

                              PROPOSED OPTIONS

Increase Income
1.
2.
3.
4.
5.
6.


Decrease Living Expenses
1.
2.
3.
4.
5.
6.


Decrease Indebtedness
1.
2.
3.
4.
5.
6.



                        REFERRALS/RECOMMENDED TRAINING

1.
2.
3.
4.
5.
6.



                              SETTING YOUR GOALS
                             (SHORT TERM & LONG TERM)


Goal              Cost            / Date Wanted   = Monthly Savings to Reach Goal
1.
2.
3.
4.
5.
6.
  Use Take Home/Actual                                                                                  SPENDING PLAN                                                                              Page 6
  TOTAL TAKE HOME PAY        #NAME?             Month                                                 Month                                                   Month
          BY PAYDAY                       1ST           #NAME?       15TH         #NAME?        1ST           #NAME?        15TH           #NAME?       1ST            #NAME?      15TH           #NAME?
      P=Planned/A=Actual                       P              A           P            A              P             A              P           A               P           A              P           A
Note: If using Take Home Pay, Subtract all savings or living expenses deducted from pay (e.g. TSP) or paid by allotment.
SAVINGS AND INVESTMENTS     $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
HOUSEHOLD                   $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
FOOD                        $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
UTILITIES                   $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
CHILD CARE                  $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
AUTOMOBILE                  $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
CLOTHING                    $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
INSURANCE                   $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
HEALTHCARE                  $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
EDUCATION                   $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
CONTRIBUTIONS               $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
LEISURE                     $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
GIFTS                       $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
PERSONAL CARE               $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
PET CARE                    $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
JOB EXPENSES                $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
MISCELLANEOUS               $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
CREDITORS:                  If using Take Home Pay, Do not include creditors paid by allotment (Use CheckBox to delete creditors paid by allotments.)
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                            $       -     $         -                $       -                   $        -                 $          -                $          -               $          -
                  TOTALS:   $       -     $         -   $       -    $       -     $       -     $        -    $      -     $          -   $       -    $          -   $       -   $          -   $       -
                              MONTHLY SPENDING RECORD
                                   Keep track of your daily spending for two weeks
Keep a record of how you spend your money for the next two weeks. The secret is to record it when you spend it.
Using a "stickie" note in your wallet or purse will help you track your expenditures. When you go for your money
make a note on your "stickie"; (put the amount and what you spent your money on). At the end of the day, transfer
the recorded amounts to this record. Be sure to include bills paid, along with sodas, lunches, etc.

Remember this is for tracking your take home pay, don't include allotments.

TAKE HOME PAY FOR TWO WEEKS                                                  Dates

DATE:                        DATE:                         DATE:                        DATE:
Item              Amount     Item              Amount      Item              Amount     Item                 Amount




DATE:                        DATE:                         DATE:                        DATE:
Item              Amount     Item              Amount      Item              Amount     Item                 Amount




DATE:                        DATE:                         DATE:                        DATE:
Item              Amount     Item              Amount      Item              Amount     Item                 Amount




DATE:                        DATE:                         DATE:                        Take
Item              Amount     Item              Amount      Item              Amount     Home Pay       +$


                                                                                        Amount
                                                                                        Spent           -$


                                                                                        Balance         $
                                                                                                             (+ or -)



                                                                                                                 Page 7
Keep a daily record like you did for the first two weeks. Remember to count ALL spending.

TAKE HOME PAY FOR TWO WEEKS                                            Dates
DATE:                      DATE:                      DATE:                      DATE:
Item            Amount     Item             Amount    Item             Amount    Item            Amount




DATE:                      DATE:                      DATE:                      DATE:
Item            Amount     Item             Amount    Item             Amount    Item            Amount




DATE:                      DATE:                      DATE:                      DATE:
Item            Amount     Item             Amount    Item             Amount    Item            Amount




DATE:                      DATE:                      DATE:                      Take
Item            Amount     Item             Amount    Item             Amount    Home Pay   +$


                                                                                 Amount
                                                                                 Spent      -$


                                                                                 Balance    $
                                                                                                 (+ or -)



                                                                                                     Page 8
Use MO.PYMT          FullSteam: Debt Reduction through use of Power Payments           Page 9
     Balance          Payment          Rate          # of Pmts         Account   # of Pmts with FS
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
                                                          #NAME?                      #NAME?
Total Balance
Total Payments          #NAME? W/O FullSteam         #NAME?
FullSteamPayments              FullSteam Time        #NAME?
Total Savings           #NAME? Time Saved            #NAME?

Total Interest          #NAME?
FullSteamInterest
Interest Savings        #NAME?

Extra Steam
1st Blast of Steam                in Month/Year
2nd Blast of Steam                in Month/Year
3rd Blast of Steam                in Month/Year
Use Actual                                                    TSP INVESTMENTS



                      10 yr average Contribution Percentage                      Current Contribution           $     -
Government Securities (4.62%)                                                   Current Age
Fixed Income Index          (6.39%)                                             Years left to Contribute
Common Stock Index         (0%)                                                 Investment Yrs until 59.5           59 1/2
Small Cap. Stock Index (1.69%)                                                  Total Contributions             $     -
International Stock Index (1.1%)                                                Interest Earned on Investment
L Income*                      (7.59%)                                          TSP Balance @ age 59.5
L 2010*                       (7.59%)
L 2020*                       (11.09%)
L 2030*                       (13.72%)
L 2040*                       (15%)
10% Example                  (10%)
Total Distribution

*Rates reflect 12 month return to 12/07
                                                    PAY AND ALLOWANCES 2011 WITH 1.4% INCREASE
                                                                                      Begin Date:
This sheet contains hidden columns, data in the hidden columns are formulas that are automatically updated.   1/1/2010
   BASE PAY                <2              2                3                4                6                8
     O10
      O9
      O8              $9,530.70       $9,842.70       $10,050.00       $10,107.90       $10,366.50       $10,798.20
      O7              $7,919.10       $8,287.20        $8,457.30        $8,592.60        $8,837.70        $9,079.80
      O6              $5,869.50       $6,448.50        $6,871.50        $6,871.50        $6,897.60        $7,193.40
      O5              $4,893.00       $5,512.20        $5,893.80        $5,965.80        $6,203.70        $6,346.20
      O4              $4,221.90       $4,887.30        $5,213.40        $5,286.00        $5,588.70        $5,913.30
      O3              $3,711.90       $4,208.10        $4,542.00        $4,951.80        $5,188.80        $5,449.20
      O2              $3,207.30       $3,652.80        $4,207.20        $4,349.10        $4,438.50        $4,438.50
      O1              $2,784.00       $2,897.40        $3,502.50        $3,502.50        $3,502.50        $3,502.50
     O3E                                                                $4,951.80        $5,188.80        $5,449.20
     O2E                                                                $4,349.10        $4,428.50        $4,580.10
     O1E                                                                $3,502.50        $3,740.40        $3,878.70
      W5
      W4              $3,836.10       $4,126.50        $4,245.00        $4,361.40       $4,562.10        $4,760.70
      W3              $3,502.80       $3,648.60        $3,798.60        $3,847.80       $4,004.70        $4,313.70
      W2              $3,099.90       $3,393.00        $3,483.30        $3,545.40       $3,746.40        $4,059.00
      W1              $2,721.00       $3,013.50        $3,092.40        $3,258.90       $3,456.00        $3,745.80
      E9
      E8                                                                                                 $3,794.10
      E7              $2,637.30       $2,878.50        $2,988.90        $3,135.00       $3,249.00        $3,444.60
      E6              $2,281.20       $2,510.10        $2,620.80        $2,728.50       $2,840.70        $3,093.60
      E5              $2,090.10       $2,230.20        $2,337.90        $2,448.30       $2,620.20        $2,800.50
      E4              $1,916.10       $2,014.20        $2,123.40        $2,230.80       $2,325.90        $2,325.90
E3   $1,729.80   $1,838.70   $1,950.00   $1,950.00   $1,950.00   $1,950.00
E2   $1,644.90   $1,644.90   $1,644.90   $1,644.90   $1,644.90   $1,644.90
E1   $1,467.60   $1,467.60   $1,467.60   $1,467.60   $1,467.60   $1,467.60
        <2           2           3           4           6           8
INCREASE                                           This sheet contains hidden columns, data in the hidden columns are form


      10          12          14          16            18             20             22             24
                                                                  $15,400.80     $15,475.80     $15,797.70
                                                                  $13,469.70     $13,663.80     $13,944.00
   $10,899.00 $11,308.80   $11,426.40 $11,779.80 $12,291.00       $12,762.30     $13,077.30     $13,077.30
    $9,359.70 $9,638.70     $9,918.60 $10,798.20 $11,540.70       $11,540.70     $11,540.70     $11,540.70
    $7,232.40 $7,232.40     $7,643.40  $8,370.30 $8,796.90         $9,222.90      $9,465.60      $9,711.30
    $6,659.40 $6,889.20     $7,186.20  $7,640.70 $7,856.70         $8,070.30      $8,313.30      $8,313.30
    $6,317.40 $6,632.10     $6,851.10  $6,976.50 $7,049.10         $7,049.10      $7,049.10      $7,049.10
    $5,617.80 $5,894.70     $6,039.00  $6,039.00 $6,039.00         $6,039.00      $6,039.00      $6,039.00
    $4,438.50 $4,438.50     $4,438.50  $4,438.50 $4,438.50         $4,438.50      $4,438.50      $4,438.50
    $3,502.50 $3,502.50     $3,502.50  $3,502.50 $3,502.50         $3,502.50      $3,502.50      $3,502.50
    $5,617.80 $5,894.70     $6,128.10  $6,262.20 $6,444.90         $6,444.90      $6,444.90      $6,444.90
    $4,818.60 $5,002.80     $5,140.20  $5,140.20 $5,140.20         $5,140.20      $5,140.20      $5,140.20
    $4,020.30 $4,158.90     $4,349.10  $4,349.10 $4,349.10         $4,349.10      $4,349.10      $4,349.10
                                                                   $6,820.80      $7,167.00      $7,424.70
   $4,961.40   $5,264.40   $5,529.60   $5,781.90    $5,988.30      $6,189.60      $6,485.40      $6,728.40
   $4,635.00   $4,786.20   $4,961.10   $5,142.00    $5,466.00      $5,685.30      $5,816.40      $5,955.60
   $4,213.50   $4,366.20   $4,552.50   $4,698.00    $4,830.00      $4,987.80      $5,091.60      $5,174.10
   $3,881.40   $4,070.40   $4,256.70   $4,403.10    $4,538.10      $4,295.10      $4,701.60      $4,701.60
   $4,634.70   $4,739.70   $4,872.00   $5,027.70    $5,184.60      $5,436.60      $5,649.30      $5,873.40
   $3,961.80   $4,065.60   $4,190.40   $4,325.10    $4,568.40      $4,691.70      $4,901.70      $5,017.80
   $3,554.70   $3,750.90   $3,913.50   $4,024.50    $4,143.00      $4,189.20      $4,342.80      $4,425.60
   $3,192.30   $3,382.80   $3,441.00   $3,483.60    $3,533.40      $3,533.40      $3,533.40      $3,533.40
   $2,947.50   $2,965.50   $2,965.50   $2,965.50    $2,965.50      $2,965.50      $2,965.50      $2,965.50
   $2,325.90   $2,325.90   $2,325.90   $2,325.90    $2,325.90      $2,325.90      $2,325.90      $2,325.90
$1,950.00   $1,950.00   $1,950.00   $1,950.00   $1,950.00   $1,950.00   $1,950.00   $1,950.00
$1,644.90   $1,644.90   $1,644.90   $1,644.90   $1,644.90   $1,644.90   $1,644.90   $1,644.90
$1,467.60   $1,467.60   $1,467.60   $1,467.60   $1,467.60   $1,467.60   $1,467.60   $1,467.60
    10          12          14          16          18          20          22          24
n columns are formulas that are automatically updated.


             26              30             34                38
        $16,358.40      $17,176.20     $18,034.80        $18,936.90   O10
        $14,433.00      $15,155.10     $15,912.90        $16,708.50   O9
        $13,077.30      $13,404.30     $13,739.40        $13,739.40   O8
        $11,599.50      $11,831.70     $11,831.70        $11,831.70   O7
        $10,187.70      $10,187.70     $10,391.10        $10,391.10   O6
         $8,313.30       $8,313.30      $8,313.30         $8,313.30   O5
         $7,049.10       $7,049.10      $7,049.10         $7,049.10   O4
         $6,039.00       $6,039.00      $6,039.00         $6,039.00   O3
         $4,438.50       $4,438.50      $4,438.50         $4,438.50   O2
         $3,502.50       $3,502.50      $3,502.50         $3,502.50   O1
         $6,444.90       $6,444.90      $6,444.90         $6,444.90   O3E
         $5,140.20       $5,140.20      $5,140.20         $5,140.20   O2E
         $4,349.10       $4,349.10      $4,349.10         $4,349.10   O1E
         $7,710.00       $8,095.80      $8,095.80         $8,095.80   W5
         $7,005.60       $7,145.70      $7,145.70         $7,145.70   W4
         $6,144.90       $6,144.90      $6,144.90         $6,144.90   W3
         $5,174.10       $5,174.10      $5,174.10         $5,174.10   W2
         $4,701.60       $4,701.60      $4,701.60         $4,701.60   W1
         $6,215.70       $6,526.20      $6,852.90         $7,195.80   E9
         $5,304.60       $5,411.10      $5,411.10         $5,411.10   E8
         $4,740.00       $4,740.00      $4,740.00         $4,740.00   E7
         $3,533.40       $3,533.40      $3,533.40         $3,533.40   E6
         $2,965.50       $2,965.50      $2,965.50         $2,965.50   E5
         $2,325.90       $2,325.90      $2,325.90         $2,325.90   E4
$1,950.00   $1,950.00   $1,950.00   $1,950.00    E3
$1,644.90   $1,644.90   $1,644.90   $1,644.90    E2
$1,467.60   $1,467.60   $1,467.60   $1,467.60    E1
    26          30          34          38    Paygrade

								
To top