Budget_Project_Spreadsheet by tangshuming

VIEWS: 0 PAGES: 2

									                               Warning: Only type in yellow cells!                                               Follow these 7 steps in order to complete your budget:
    Name:                                                                                                        Step 1: Enter your name

                               Category Estimates                    Monthly Working Budget Goal

                      Yearly Income        Monthly Income                   INCOME
                                                                   0.00   Paycheck #1                            Step 2: Enter your Gross Annual (Yearly) Income
                                                                   0.00   Paycheck #2
     100%            $             -      $                 -                                                    The spreadsheet formulas will automatically figure your estimated amounts for the listed
                                                                   0.00   Other
                                                                                                                 categories - use these as a guide as you create your monthly working budget.
                                                                   0.00           INCOME TOTAL:

                     Yearly Expenses     Monthly Expenses                 EXPENSES
                                                                TAXES
                                                                                                                 Step 3: Using the Monthly Category Estimates, enter dollar amounts into all of the yellow
      18%            $             -      $                 -      0.00   Income Tax
                                                                                                                 boxes based on your spending habits and lifestyle.
                                                                   0.00                                 Total:
                                                                SAVINGS                                          Only enter dollar amounts into boxes that apply to you.
                                                                   0.00   Savings                                Use the estimates as a guide; however, you may adjust dollar amounts to make your
       3%            $             -      $                 -      0.00   Investments                            budget work for you. If you put more money toward one category, you need to take
                                                                   0.00   Miscellaneous                          money from other categories to make-up the difference.
                                                                   0.00                                 Total:
                                                                HOME
                                                                  0.00    Rent or Mortgage Payment               Step 4: Complete the other parts of the assignment (find a home and a car) and then
                                                                   0.00   Gas (utility)                          enter real data into the spreadsheet.
                                                                   0.00   Electric
                                                                   0.00   Garbage
                                                                   0.00   Water/Sewer
                                                                   0.00   Home Security
      30%            $             -      $                 -      0.00   Cable/Internet/Phone
                                                                   0.00   Cell Phone
                                                                   0.00   Home Maintenance
                                                                   0.00   Home Furnishings
                                                                   0.00   Home Electronics
                                                                   0.00   Miscellaneous
                                                                   0.00                                 Total:
                                                                TRANSPORTATION
                                                                   0.00  Car Payment
                                                                   0.00   Auto Insurance
                                                                   0.00   Auto Gas
      19%            $             -      $                 -      0.00   Vehicle Maintenance
                                                                   0.00   License/Registration
                                                                   0.00   Public Transportation
                                                                   0.00   Miscellaneous
                                                                   0.00                                 Total:
                                                                FOOD & GROCERY
                                                                  0.00   Food At Home
                                                                   0.00   Food Away From Home
      12%            $             -      $                 -      0.00   Personal Care Items
                                                                   0.00   Small Home Care Items
                                                                   0.00   Miscellaneous
                                                                   0.00                                 Total:
                                                                HEALTH & PERSONAL CARE
                                                                  0.00    Doctor Fees
                                                                   0.00   Dental Fees
                                                                   0.00   Prescriptions
                                                                   0.00   Vitamins
                                                                   0.00   Hair/Salon Service
       6%            $             -      $                 -      0.00   Gym Membership
                                                                   0.00   Life Insurance
                                                                   0.00   Gifts
                                                                   0.00   Donations
                                                                   0.00   Miscellaneous
                                                                   0.00                                 Total:

                                                                CLOTHING
                                                                   0.00  Clothes
       6%            $             -      $                 -      0.00   Shoes
                                                                   0.00   Dry Cleaning/Laundry
                                                                   0.00                                 Total:

                                                                ENTERTAINMENT
                                                                   0.00  Vacation
                                                                   0.00   Event Fees/Tickets
       6%            $             -      $                 -
                                                                   0.00   Pet Care
                                                                   0.00   Miscellaneous
                                                                   0.00                                 Total:
                                                                                                                 Step 5: When you think your budget is complete, check to make sure your budget is
     100%            $             -      $                 -                                                    balanced (What's Left section should be positive).
                                                                   0.00      EXPENSE TOTAL:
       0%            $             -      $                 -      0.00              WHAT'S LEFT:                Leftover money can be put into other categories, saved or left as spending money.


                                       Monthly Working Budget Goal
                                                                                                                 Step 6: Analyze the pie chart at left. Do you like how your money is spent?
                                           0.000.000%
                                            0.00 ; ;
                                         0.00 0.000%;0%
                                            0.00;;; 0% 0%
                                                0% 0%
                                              ; 0.00




                                                                                                                 Step 7: Print spreadsheet - document is already set-up to print correct area.


                                                                                       TAXES
                                                                                       SAVINGS
                                                                                       HOME
                                                                                       TRANSPORTATION
                                                                                       FOOD & GROCERY
                                                                                       HEALTH & PERSONAL CARE
                                                                                       CLOTHING
                                                                                       ENTERTAINMENT




4/14/2012; 1:36 AM
    Lender    Interest Rate   Balance     Credit Limit   Notes
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00
Lender Name      0.00%            $0.00         $0.00




               Total Debt         $0.00

								
To top