Household budget

Document Sample
Household budget Powered By Docstoc
					                                                                                  Expenditures
Category               Budget           Jan           Feb          Mar          Apr          May           Jun          Jul           Aug           Sep
Mortgage             $      1,100   $    1,100    $    1,100   $    1,100   $    1,100   $    1,100    $    1,100   $    1,100    $    1,100    $    1,100
Utilities            $        300   $      300    $      298   $      276   $      258   $      220    $      200   $      300    $      298    $      276
Cable & Internet     $         90   $       90    $       90   $       90   $       90   $       90    $       90   $       90    $       90    $       90
Grocery              $        350   $      389    $      350   $      330   $      376   $      444    $      435   $      462    $      350    $      330
Telephone            $        100   $      140    $       51   $      120   $       88   $       89    $      103   $      140    $       51    $       76
Car payment          $        450   $      450    $      450   $      450   $      450   $      450    $      450   $      450    $    1,000    $      450
Total                $      2,390   $    2,469    $    2,339   $    2,366   $    2,362   $    2,393    $    2,378   $    2,542    $    2,889    $    2,322
                     Under/(Over)   $      (79)   $       51   $       24   $       28   $       (3)   $       12   $     (152)   $     (499)   $       68


                                                                                     Savings
Category               Target         Jan           Feb          Mar          Apr          May           Jun          Jul           Aug           Sep
Retirement savings   $     6,000    $   800       $   500      $   120      $   600      $   550       $   240      $   800       $   500       $   120
College savings      $     3,000    $   200       $   250      $   120      $   300      $   250       $   150      $   200       $   250       $   120
Vacation savings     $     1,500    $   100       $   150      $   200      $   100      $   100       $     50     $   100       $   150       $   200


 $1,200
 $1,000
   $800
   $600
   $400
   $200
     $-
               Jan         Feb             Mar             Apr              May              Jun             Jul             Aug                Sep
    Oct          Nov           Dec              Trends
$    1,100   $    1,100    $    1,100
$      258   $      220    $      200
$       90   $       90    $       90
$      378   $      444    $      435
$       88   $       89    $      103
$      450   $      450    $      450
$    2,364   $    2,393    $    2,378
$       26   $       (3)   $       12




  Oct          Nov           Dec             Actual Totals
$   600      $   -         $   240       $                   5,070
$   300      $   250       $   150       $                   2,540
$   100      $   100       $     50      $                   1,400




                                                Mortgage
                                                Utilities
                                                Cable & Internet
                                                Grocery
                                                Telephone
                                                Car payment

    Oct            Nov             Dec

				
DOCUMENT INFO
Shared By:
Stats:
views:52
posted:6/4/2012
language:Latin
pages:2
Description: This template, professionally designed in Excel 2010, makes it easy to monitor household expenditures through Sparklines, conditional formatting, and a chart.