Student-budget-worksheet - Excel by cuiliqing

VIEWS: 340 PAGES: 2

									      Student budget worksheet

    YEARLY INCOME                    Estimate   Actual   Difference           YEARLY BUDGET SUMMARY
    Expected wages/tips (after tax) 15,000.00 15,500.00     (500.00)                                     Estimate        Actual   Difference
    Education savings plan            4,000.00  4,000.00        -                           Total Income 20,100.00      20,600.00    (500.00)
    Scholarships                          0.00      0.00        -                         Total Expenses 12,410.00      12,310.00     100.00
    Gifts                               100.00    100.00        -                                    NET 7,690.00        8,290.00    (600.00)
    Family contributions              1,000.00  1,000.00        -
    Other aid (bursary, osap)             0.00      0.00        -
    Other                                 0.00      0.00        -
       Total YEARLY INCOME          20,100.00 20,600.00     (500.00)

   LIVING EXPENSES/year                Estimate     Actual      Difference    SAVINGS/year                   Estimate     Actual   Difference
   Residence/rent/mortgage               8,000.00  8,000.00          -        Emergency fund                                             -
   Renters/home insurance                    0.00      0.00          -        Savings                                                    -
   Electricity                              50.00     50.00          -        Investments                                                -
   Gas                                      43.00     43.00          -        Other                                                      -
   Water                                     7.00      7.00          -              Total SAVINGS/year            -           -          -
   Phone                                   480.00    480.00          -
   Cable/satellite                         240.00    240.00          -        PAYMENTS/year                  Estimate     Actual   Difference
   Internet                                180.00    180.00          -        Student loan                                               -
   Furnishings/appliances                  500.00    400.00       100.00      Other Loan                                                 -
   Lawn/garden                               0.00      0.00          -        Credit Card #1                                             -
   Home supplies                           120.00    120.00          -        Credit Card #2                                             -
   Maintenance                               0.00      0.00          -        Credit Card #3                                             -
   Clothing                                480.00    480.00          -        Taxes                                                      -
   Other                                     0.00      0.00          -        Other                                                      -
Total LIVING EXPENSES/year             10,100.00 10,000.00        100.00         Total PAYMENTS/year              -           -          -

    PERSONAL/year                      Estimate     Actual      Difference    ENTERTAINMENT/year             Estimate     Actual   Difference
    Child care (Food, clothing etc.)         0.00        0.00         -       Videos/DVDs                                                -
    Pet care (Medical, food etc.)            0.00        0.00         -       Music                                                      -
    Laundry/drycleaning                    240.00      240.00         -       Games                                                      -
    Hair/body/beauty products              240.00      240.00         -       Rentals                                                    -
    Hair cuts                              480.00      480.00         -       Movies/theater                                             -
    Holiday/birthday gifts                 600.00      600.00         -       Concerts                                                   -
    Postage                                 50.00       50.00         -       Books                                                      -
    Travel (trips home)                    200.00      200.00         -       Hobbies                                                    -
    Computer                               500.00      500.00         -       Photos                                                     -
    Other                                    0.00        0.00         -       Sports                                                     -
        Total PERSONAL/year             2,310.00    2,310.00          -       Toys/gadgets                                               -
                                                                              Memberships                                                -
    FOOD/year                          Estimate     Actual      Difference    Subscriptions (newspaper, mag)                             -
    Groceries                                                          -      Other (alcohol, clubs)                                     -
    Meal Plan                                                          -   Total ENTERTAINMENT/year                -          -          -
    Meals out                                                          -
    Snacks                                                             -
    Other                                                              -      VACATION/year                  Estimate     Actual   Difference
              Total FOOD/year                -           -             -      Travel                                                     -
                                                                              Lodging                                                    -
    TRANSPORTATION/year                Estimate     Actual      Difference    Food                                                       -
    Car payments                                                       -      Rental Car                                                 -
    Car insurance                                                      -      Entertainment                                              -
    Gas                                                                -      Other                                                      -
    Bus/Taxi/Train/Subway fare                                         -          Total VACATION/year              -          -          -
    Maintenance and repairs                                            -
    Parking                                                            -
    Registration/license                                               -
    Other                                                              -
Total TRANSPORTATION/year                    -           -             -

    HEALTH/year                        Estimate     Actual      Difference
Medical insurance                                    -
Dental insurance                                     -
Doctor/dentist/eye care                              -
Prescriptions                                        -
Other                                                -
       Total HEALTH/year        -         -          -

EDUCATION/year             Estimate   Actual   Difference
Tuition                                              -
Books and supplies                                   -
Lab/library fees                                     -
Photocopying                                         -
Other                                                -
   Total EDUCATION/year         -         -          -

								
To top