Docstoc

monthly-budget-planner-template

Document Sample
monthly-budget-planner-template Powered By Docstoc
					            Month                             January-11
Date                Category   Expense                     Comment
01-Jan-11   Rent                     500.00
01-Jan-11   Electricity               30.00
02-Jan-11   Water                     37.00
04-Jan-11   Gas                       32.50
04-Jan-11   Phone                     45.00
06-Jan-11   Internet                  75.00
07-Jan-11   Cable                     27.50
08-Jan-11   Corner Store              50.00
09-Jan-11   Grocery                  200.00
10-Jan-11   Pocket Money             150.00
11-Jan-11   Mortgage                 775.00
12-Jan-11   Bus/Taxi fare            100.00
13-Jan-11   Medical                   50.00
14-Jan-11   Health Insurance          85.00
15-Jan-11   Life Insurance           100.00
16-Jan-11   Movies                   100.00
22-Jan-11   Restaurant                50.00
22-Jan-11   Other Expenses           100.00
18-Jan-11   Education                350.00
                                January-11
Monthly Expenses        Projected Expense Actual Expense          Difference
Rent                                 500.00          500.00               0.00   900.00
Water                                 30.00           37.00               7.00
Electricity                           30.00           30.00               0.00   800.00
Gas                                   32.50           32.50               0.00   700.00
Phone                                 45.00           45.00               0.00
Internet                              75.00           75.00               0.00   600.00
Cable                                 27.50           27.50               0.00
                                                                                 500.00
Corner Store                          50.00           50.00               0.00
Grocery                              200.00          200.00               0.00   400.00
Pocket Money                         150.00          150.00               0.00
Mortgage                             750.00          775.00              25.00   300.00
Education                            350.00          350.00               0.00
                                                                                 200.00
Bus/Taxi fare                        100.00          100.00               0.00
Medical                               50.00           50.00               0.00   100.00
Health Insurance                      85.00           85.00               0.00
                                                                                   0.00
Life Insurance                       125.00          100.00              25.00
Movies                               100.00          100.00               0.00
Restaurant                            50.00           50.00               0.00
Other Expenses                       100.00          100.00               0.00
Subtotals                          2,850.00           2,857.00           7.00

                                January-11
Monthly Income          Projected Income     Actual Income        Difference
Income 1                             1000.00             999.00           1.00
Income 2                             1000.00            1000.00           0.00
Income 3                              500.00             500.00           0.00
Income 4                              500.00             501.00           1.00
Subtotals                           3000.00            3000.00           0.00

                 January-11
Income-Expense Chart          Amount
Actual Income                      3,000.00
Actual Expense                     2,857.00
Balance                              143.00
                         January-11




Income-Expense Chart


      Actual
     Expense
     95.23%                      Other Expenses
                                     3.33%

                                   Restaurant
                                     1.67%

               Balance                         Movies
                                               3.33%
                4.77%
                              Life Insurance
                                  3.33%

                            Health Insurance
                                 2.83%
                                     Medical
                                     1.67%
                                  Bus/Taxi fare
                                     3.33%
                                                                        Projected Expense
                                                                        Actual Expense




                      Monthly Expenses            Electricity
                                                    1.00%
                                        Water
                                                   Gas
                                        1.23%
                                                  1.08%
                               Rent
                              16.67%               Phone
                                                   1.50% Internet
                                                          2.50%
er Expenses      Savings                                        Cable
                  4.77%                                         0.92%
                                                                   Corner Store
                                                                     1.67%

                                                     Grocery
        Movies                                       6.67%
        3.33%

                                                Pocket Money
                                                   5.00%




                  Education            Mortgage
                   11.67%               25.83%
                                          Enter value only in the following cells
for Changing Month (Sheet name has to be changed manually)
for Actual Expense
for Projected Expense
for Projected and Actual Income

Some Cells are highlighted with different colors based on their value.
Projected Expense - PE; Actual Expense - AE
If AE<=PE, Cell color is Green
If AE>PE and AE< =110% of PE, Cell color is Yellow
If AE>110% of PE, Cell color is Red

Projected Income - PI; Actual Income - AI
If AI<PI, Cell color is Red
If AI>=PI, Cell color is Green
he following cells
             D2
             B4 to E90
             H4 to H22
             G27 to I30

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:105
posted:8/17/2012
language:English
pages:10