Docstoc

family budget planner (Excel download)

Document Sample
family budget planner (Excel download) Powered By Docstoc
					 FAMILY BUDGET PLANNER                                                     By: www.ExcelTemplateSource.com


BALANCE                            -         2,340      4,680    7,020       9,360   11,700
SUMMARY
  Total Income                   5,040       5,040      5,040    5,040       5,040     5,040
  Total Expenditures             2,700       2,700      2,700    2,700       2,700     2,700
  Income - Expenditures          2,340       2,340      2,340    2,340       2,340     2,340

                                JAN         FEB        MAR      APR        MAY       JUN
INCOME
  Take-home pay (Mom)            2,400       2,400      2,400    2,400       2,400     2,400
  Take-home pay (Dad)            2,500       2,500      2,500    2,500       2,500     2,500
  Other income                     140         140        140      140         140       140
TOTAL INCOME                     5,040       5,040     5,040     5,040       5,040    5,040

EXPENDITURES
   Mortgage / rent                 650         650        650      650         650      650
   Credit-card payments            200         200        200      200         200      200
   Home-equity loans               100         100        100      100         100      100
   Car loan(s)                     500         500        500      500         500      500
   Other
 Insurance Premiums
   Auto                            200         200        200      200         200      200
   Health
   Home
   Other
 Savings / Investments
   Vacation fund
   Emergency fund
   Investment fund
   College fund
   Other
 Variable Expenditures
 Fuel and utilities
   Water and sewer                     50         50       50         50        50         50
   Transportation
   Telephone
   Household operation
   Heating
   Electricity                     100         100        100      100         100      100
 Pocket Money
   Mom                             100         100        100      100         100      100
   Dad                             100         100        100      100         100      100
   Kids
 Other variable expenditures
   Clothing                        100         100        100      100         100      100
   Automobile gas and repairs      200         200        200      200         200      200
   Recreation, entertainment       200         200        200      200         200      200
  Personal care (haircuts, etc.)
  Miscellaneous
  Medical / dental
  Food and beverages                 200     200     200     200     200     200
  Charity
TOTAL EXPENDITURES                 2,700   2,700   2,700   2,700   2,700   2,700
y: www.ExcelTemplateSource.com


                  14,040      16,380     18,720     21,060     23,400   25,740


                    5,040        5,040    5,040      5,040      5,040    5,040      60,480   Step 1: Enter your Begining
                                                                                             Balance in D3.
                    2,700        2,700    2,700      2,700      2,700    2,700      32,400
                    2,340        2,340    2,340      2,340      2,340    2,340      28,080
                                                                                             Step 2: Enter Income
                  JUL         AUG        SEP        OCT        NOV      DEC        TOTALS
                                                                                             Step 3: Enter Expenses

                    2,400        2,400    2,400      2,400      2,400    2,400      28,800   Some cells are protected to
                    2,500        2,500    2,500      2,500      2,500    2,500      30,000   conserve calculations. To
                      140          140      140        140        140      140       1,680   Unprotect type:
                    5,040      5,040      5,040      5,040      5,040    5,040     60,480


                        650       650       650        650        650      650       7,800
                        200       200       200        200        200      200       2,400
                        100       100       100        100        100      100       1,200
                        500       500       500        500        500      500       6,000
                                                                                       -

                        200       200       200        200        200      200       2,400
                                                                                       -
                                                                                       -
                                                                                       -

                                                                                       -
                                                                                       -
                                                                                       -
                                                                                       -
                                                                                       -


                         50         50         50         50       50         50       600
                                                                                       -
                                                                                       -
                                                                                       -
                                                                                       -
                        100       100       100        100        100      100       1,200

                        100       100       100        100        100      100       1,200
                        100       100       100        100        100      100       1,200
                                                                                       -

                        100       100       100        100        100      100       1,200
                        200       200       200        200        200      200       2,400
                        200       200       200        200        200      200       2,400
                                                   -
                                                   -
                                                   -
  200     200     200     200     200     200    2,400
                                                   -
2,700   2,700   2,700   2,700   2,700   2,700   32,400
      : Enter your Begining
Balance in D3.

      : Enter Income

      : Enter Expenses

Some cells are protected to
conserve calculations. To
           type:

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:224
posted:4/8/2012
language:English
pages:5