Docstoc

Your Own Detailed Financial Planner

Document Sample
Your Own Detailed Financial Planner Powered By Docstoc
					                                                                                                      Questions?
                                                                                           Email at aamansec@yahoo.com




 Budget Planner - Overview / Help

Instructions
                                                                                                              Budget By
You may move from worksheet to worksheet by clicking on the dark blue buttons                 Quick Budget
                                                                                                               Month
located at the top of each worksheet or the blue tabs at the bottom of this workbook.

Enter data in only the white cells with gray borders:        400
Use the drop down boxes Aug To Date           to chart different time periods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)

Quick Budget
Create a quick and easy budget by filling out the white cells on the "Quick Budget" sheet. Enter the "Frequency" by using the drop down menu
provided in each cell. The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the "Comparison" sheet.
Make sure "Use this budget for comparison purposes" is selected. (If this box is not selected, the "Budget By Month" figures will be used for
comparison purposes instead.)

Budget by Month
Use the "Budget By Month" sheet to create a budget with greater detail. Select your first budget month by using the drop down box in
the "Income" section. To unhide future months, click the grey button at the top of the sheet labeled "Click here then Ctrl+Shift+0".
Make sure "Use this budget for comparison purposes" is selected if you are building 'a budget by month. (If this box is not selected,
the "Quick Budget" sheet figures will be used for comparison purposes instead.)

Tracking
Use this sheet to track your actual income and spending. Select your first tracking month by using the drop down box in the "Income" section.
These figures will be compared to your budgeted figures on the "Comparison" page.

Comparison
Use this sheet to monitor how well you are sticking to your budget. Compare different time periods by using the drop down box above the
"Income" section

Daily Spending
We've provided this sheet for those interested in tracking their spending on a daily basis. This simple record goes a long way in helping
you stick to your budget.
Quick Budget
                                                                                                                                      Chart: Monthly
Income                             Frequency     Amount      Monthly     Yearly                                  Budget Summary
Total Income (net)                                             9000.00   108000.00
  Salary/Wages                   Monthly                          0.00        0.00
  Salary/Wages (Spouse)          Monthly           9000.00     9000.00   108000.00   -24167
  Other                          Weekly                           0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00                                                  9000


Spending                Total:                                33166.67   398000.00
                                                                                                                                                               33167
Transportation                                                 9333.33   112000.00
  Auto Loan/Lease                Monthly           2500.00     2500.00    30000.00
  Insurance                      Monthly                          0.00        0.00   -$30,000    -$20,000   -$10,000   $0       $10,000    $20,000   $30,000    $40,000

  Gas                            Monthly           6000.00     6000.00    72000.00                           Balance     Income           Expense
  Maintenance                    Quarterly                        0.00        0.00
  Registration/Inspection        Yearly           10000.00      833.33    10000.00
  Bill's train pass              Monthly                          0.00        0.00
                                                                                                               Spending Summary
  Jane's bus pass                Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00                              0           0   0              0


Home                                                          23833.33   286000.00
  EMI                            Monthly          18500.00    18500.00   222000.00                                                            9333
  Rent                           Monthly                          0.00        0.00
  Maintenance                    Monthly                          0.00        0.00
  Insurance                      Monthly                          0.00        0.00
  Furniture                      Yearly                           0.00        0.00
  Household Supplies             Monthly           1000.00     1000.00    12000.00
  Groceries                      Weekly            1000.00     4333.33    52000.00                          23833
  Real Estate Tax                Semi-Annually                    0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00

Utilities                                                         0.00        0.00
   Phone - Home                  Monthly                          0.00        0.00              Transportation         Home                     Utilities
   Phone - Cell                  Monthly                          0.00        0.00
                                                                                                Health                 Entertainment            Miscellaneous
   Cable                         Monthly                          0.00        0.00
   Gas                           Monthly                          0.00        0.00
   Water                         Monthly                          0.00        0.00
   Electricity                   Monthly                          0.00        0.00
   Internet                      Monthly                          0.00        0.00
   Other                         Monthly                          0.00        0.00
   Other                         Monthly                          0.00        0.00

Health                                                            0.00        0.00
  Dental                         Monthly                          0.00        0.00
  Medical                        Monthly                          0.00        0.00
  Medication                     Monthly                          0.00        0.00
  Vision/contacts                Semi-Annually                    0.00        0.00
  Life Insurance                 Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00

Entertainment                                                     0.00        0.00
  Memberships                    Monthly                          0.00        0.00
  Dining out                     Monthly                          0.00        0.00
  Events                         Monthly                          0.00        0.00
  Subscriptions                  Monthly                          0.00        0.00
  Movies                         Monthly                          0.00        0.00
  Music                          Monthly                          0.00        0.00
  Hobbies                        Weekly                           0.00        0.00
  Travel/ Vacation               Yearly                           0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00

Miscellaneous                                                     0.00        0.00
  Dry Cleaning                   Monthly                          0.00        0.00
  New Clothes                    Semi-Annually                    0.00        0.00
  Donations                      Monthly                          0.00        0.00
  Child Care                     Monthly                          0.00        0.00
  Tuition                        Monthly                          0.00        0.00
  College Loans                  Monthly                          0.00        0.00
  Pocket Money                   Weekly                           0.00        0.00
  Gifts                          Monthly                          0.00        0.00
  Credit Card                    Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00
  Other                          Monthly                          0.00        0.00
Budget By Month
                                                                                                                                             Chart:        March
                                                                                                     -2




Income                           Apr      May     Jun     Jul      Aug     0 Months                                                   Budget Summary
                                                                                       Oct to Date




Total Income (net)                 0.00    0.00    0.00     0.00    0.00        0.00                 0




  Salary/Wages                                                                  0.00                 0




  Salary/Wages (Spouse)                                                         0.00                 0            0
  Other                                                                         0.00                 0




  Other                                                                         0.00                 0




  Other                                                                         0.00                 0
                                                                                                                  0


Spending                Total:     0.00    0.00    0.00     0.00    0.00        0.00                 0
                                                                                                                  0
Transportation                     0.00    0.00    0.00     0.00    0.00        0.00                 0




  Auto Loan/Lease                                                               0.00                 0




  Insurance                                                                     0.00                 0
                                                                                                              0                0              0             1             1             1
  Gas                                                                           0.00                 0                             Balance        Income        Expense
  Maintenance                                                                   0.00                 0




  Registration/Inspection                                                       0.00                 0




  Bill's train pass                                                             0.00                 0


                                                                                                                                     Spending Summary
  Jane's bus pass                                                               0.00                 0




  Other                                                                         0.00                 0
                                                                                                                                                    00

Home                               0.00    0.00    0.00     0.00    0.00        0.00                 0




  EMI                                                                           0.00                 0




  Rent                                                                          0.00                 0




  Maintenance                                                                   0.00                 0




  Insurance                                                                     0.00                 0




  Furniture                                                                     0.00                 0




  Household Supplies                                                            0.00                 0




  Groceries                                                                     0.00                 0




  Real Estate Tax                                                               0.00                 0




  Other                                                                         0.00                 0




  Other                                                                         0.00                 0




Utilities                          0.00    0.00    0.00     0.00    0.00        0.00                 0




   Phone - Home                                                                 0.00                 0

                                                                                                                      Transportation           Home                   Utilities
   Phone - Cell                                                                 0.00                 0




                                                                                                                      Health                   Entertainment          Miscellaneous
   Cable                                                                        0.00                 0




   Gas                                                                          0.00                 0




   Water                                                                        0.00                 0                                Budget by Month
   Electricity                                                                  0.00                 0




   Internet                                                                     0.00                 0




   Other                                                                        0.00                 0    1
   Other                                                                        0.00                 0
                                                                                                          1
                                                                                                          1
Health                             0.00    0.00    0.00     0.00    0.00        0.00                 0
                                                                                                          1
  Dental                                                                        0.00                 0
                                                                                                          1
                                                                                                          1
  Medical                                                                       0.00                 0




                                                                                                          0
  Medication                                                                    0.00                 0




                                                                                                          0
  Vision/contacts                                                               0.00
                                                                                                          0
                                                                                                     0




  Life Insurance                                                                0.00                 0


                                                                                                          0
  Other                                                                         0.00                 0

                                                                                                          0
  Other                                                                         0.00                 0


                                                                                                                  Apr                May            Jun             Jul           Aug

Entertainment                      0.00    0.00    0.00     0.00    0.00        0.00                 0
                                                                                                                                           Expense         Income
  Memberships                                                                   0.00                 0




  Dining out                                                                    0.00                 0




  Events                                                                        0.00                 0




  Subscriptions                                                                 0.00                 0




  Movies                                                                        0.00                 0




  Music                                                                         0.00                 0




  Hobbies                                                                       0.00                 0




  Travel/ Vacation                                                              0.00                 0




  Other                                                                         0.00                 0




  Other                                                                         0.00                 0




Miscellaneous                      0.00    0.00    0.00     0.00    0.00        0.00                 0




  Dry Cleaning                                                                  0.00                 0




  New Clothes                                                                   0.00                 0




  Donations                                                                     0.00                 0




  Child Care                                                                    0.00                 0




  Tuition                                                                       0.00                 0




  College Loans                                                                 0.00                 0




  Pocket Money                                                                  0.00                 0




  Gifts                                                                         0.00                 0




  Credit Card                                                                   0.00                 0




  Other                                                                         0.00                 0




  Other                                                                         0.00                 0




  Other                                                                         0.00                 0
Tracking
                                                                                                            Chart:        September

Income                      Oct      Nov     Dec     Jan      Oct to Date                 Actual Income/Spend Summary
Total Income (net)            0.00    0.00    0.00     0.00          0.00
  Salary/Wages                                                       0.00
  Salary/Wages (Spouse)                                              0.00
                                                                                    0
  Other                                                              0.00
  Other                                                              0.00
  Other                                                              0.00           0

Spending
                                                                                    0
Total Spending:               0.00    0.00    0.00     0.00          0.00
Transportation                0.00    0.00    0.00     0.00          0.00
  Auto Loan/Lease                                                    0.00       0             0             0             1             1         1
  Insurance                                                          0.00                         Balance       Income        Expense
  Gas                                                                0.00
  Maintenance                                                        0.00
  Registration/Inspection                                            0.00                            Actuals by Month
  Bill's train pass                                                  0.00
  Jane's bus pass                                                    0.00
  Other                                                              0.00   1
                                                                            1
Home                          0.00    0.00    0.00     0.00          0.00   1
  EMI                                                                0.00
                                                                            1
  Rent                                                               0.00
                                                                            1
  Maintenance                                                        0.00
  Insurance                                                          0.00   1
  Furniture                                                          0.00   0
  Household Supplies                                                 0.00   0
  Groceries                                                          0.00   0
  Real Estate Tax                                                    0.00
                                                                            0
  Other                                                              0.00
                                                                            0
  Other                                                              0.00
                                                                                        Oct             Nov                Dec              Jan
                                                                                                       Expense           Income
Utilities                     0.00    0.00    0.00     0.00          0.00
   Phone - Home                                                      0.00
   Phone - Cell                                                      0.00
   Cable                                                             0.00
   Gas                                                               0.00
   Water                                                             0.00
   Electricity                                                       0.00
   Internet                                                          0.00
   Other                                                             0.00
   Other                                                             0.00

Health                        0.00    0.00    0.00     0.00          0.00
  Dental                                                             0.00
  Medical                                                            0.00
  Medication                                                         0.00
  Vision/contacts                                                    0.00
  Life Insurance                                                     0.00
  Other                                                              0.00
  Other                                                              0.00

Entertainment                 0.00    0.00    0.00     0.00          0.00
  Memberships                                                        0.00
  Dining out                                                         0.00
  Events                                                             0.00
  Subscriptions                                                      0.00
  Movies                                                             0.00
  Music                                                              0.00
  Hobbies                                                            0.00
  Travel/ Vacation                                                   0.00
  Other                                                              0.00
  Other                                                              0.00

Miscellaneous                 0.00    0.00    0.00     0.00          0.00
  Dry Cleaning                                                       0.00
  New Clothes                                                        0.00
  Donations                                                          0.00
  Child Care                                                         0.00
  Tuition                                                            0.00
  College Loans                                                      0.00
  Pocket Money                                                       0.00
  Gifts                                                              0.00
  Credit Card                                                        0.00
  Other                                                              0.00
  Other                                                              0.00
  Other                                                              0.00
Comparison                  Compare October                 to Budget                                    October

Income                       Budget      Oct Actual       Vs Budget                           Tracking vs Budget Summary
Total Income (net)               9,000             0          -9,000
  Salary/Wages                       0          0.00            0.00    -24166.66667
  Salary/Wages (Spouse)          9000           0.00       -9,000.00
                                                                         Budget                                       9000
  Other                              0          0.00            0.00
  Other                              0          0.00            0.00                                                                             33167
  Other                              0          0.00            0.00

                                                                                                               0
Spending
                                                                         Tracking                              0
Total Spending:                 33,167                0      -33,167
Transportation                   9,333             0          -9,333                                           0
  Auto Loan/Lease             2,500.00          0.00       -2,500.00
  Insurance                       0.00          0.00            0.00        (30,000) (20,000) (10,000)     0       10,000 20,000 30,000 40,000
  Gas                         6,000.00          0.00       -6,000.00
                                                                                           Balance (Savings)        Income        Expense
  Maintenance                     0.00          0.00            0.00
  Registration/Inspection       833.33          0.00         -833.33
  Bill's train pass               0.00          0.00            0.00
  Jane's bus pass                 0.00          0.00            0.00                              Spending Comparison
  Other                           0.00          0.00            0.00

Home                            23,833             0         -23,833              23,833
  EMI                        18,500.00          0.00      -18,500.00
  Rent                            0.00          0.00            0.00
  Maintenance                     0.00          0.00            0.00
  Insurance                       0.00          0.00            0.00
  Furniture                       0.00          0.00            0.00
  Household Supplies          1,000.00          0.00       -1,000.00         9,333
  Groceries                   4,333.33          0.00       -4,333.33
  Real Estate Tax                 0.00          0.00            0.00
  Other                           0.00          0.00            0.00
  Other                           0.00          0.00            0.00                          0   0   0        0      0      0     0         0    0      0

                                                                                            Budget                                Tracking
Utilities                            0             0              0
   Phone - Home                   0.00          0.00           0.00                  Transportation       Home                   Utilities
   Phone - Cell                   0.00          0.00           0.00                  Health               Entertainment          Miscellaneous
   Cable                          0.00          0.00           0.00
   Gas                            0.00          0.00           0.00
   Water                          0.00          0.00           0.00
   Electricity                    0.00          0.00           0.00
   Internet                       0.00          0.00           0.00
   Other                          0.00          0.00           0.00
   Other                          0.00          0.00           0.00

Health                               0             0              0
  Dental                          0.00          0.00           0.00
  Medical                         0.00          0.00           0.00
  Medication                      0.00          0.00           0.00
  Vision/contacts                 0.00          0.00           0.00
  Life Insurance                  0.00          0.00           0.00
  Other                           0.00          0.00           0.00
  Other                           0.00          0.00           0.00

Entertainment                        0             0              0
  Memberships                     0.00          0.00           0.00
  Dining out                      0.00          0.00           0.00
  Events                          0.00          0.00           0.00
  Subscriptions                   0.00          0.00           0.00
  Movies                          0.00          0.00           0.00
  Music                           0.00          0.00           0.00
  Hobbies                         0.00          0.00           0.00
  Travel/ Vacation                0.00          0.00           0.00
  Other                           0.00          0.00           0.00
  Other                           0.00          0.00           0.00

Miscellaneous                        0             0              0
  Dry Cleaning                    0.00          0.00           0.00
  New Clothes                     0.00          0.00           0.00
  Donations                       0.00          0.00           0.00
  Child Care                      0.00          0.00           0.00
  Tuition                         0.00          0.00           0.00
  College Loans                   0.00          0.00           0.00
  Pocket Money                    0.00          0.00           0.00
  Gifts                           0.00          0.00           0.00
  Credit Card                     0.00          0.00           0.00
  Other                           0.00          0.00           0.00
  Other                           0.00          0.00           0.00
  Other                           0.00          0.00           0.00
Daily Spending Record
Income
Spending                    1st          2nd          3rd          4th          5th          6th          7th          8th          9th          10th          11th          12th          13th          14th          15th          16th          17th          18th          19th          20th          21st          22nd      23rd      24th          25th          26th          27th          28th          29th          30th          31st          Month

Total Day's Spending:             0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
Transportation                    0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
  Auto Loan/Lease                                                                                                                                                                                                                                                                                                                                                                                                                                                0.00
  Insurance                                                                                                                                                                                                                                                                                                                                                                                                                                                      0.00
  Gas                                                                                                                                                                                                                                                                                                                                                                                                                                                            0.00
  Maintenance                                                                                                                                                                                                                                                                                                                                                                                                                                                    0.00
  Registration/Inspection                                                                                                                                                                                                                                                                                                                                                                                                                                        0.00
  Bill's train pass                                                                                                                                                                                                                                                                                                                                                                                                                                              0.00
  Jane's bus pass                                                                                                                                                                                                                                                                                                                                                                                                                                                0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00

Home                              0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
  EMI                                                                                                                                                                                                                                                                                                                                                                                                                                                            0.00
  Rent                                                                                                                                                                                                                                                                                                                                                                                                                                                           0.00
  Maintenance                                                                                                                                                                                                                                                                                                                                                                                                                                                    0.00
  Insurance                                                                                                                                                                                                                                                                                                                                                                                                                                                      0.00
  Furniture                                                                                                                                                                                                                                                                                                                                                                                                                                                      0.00
  Household Supplies                                                                                                                                                                                                                                                                                                                                                                                                                                             0.00
  Groceries                                                                                                                                                                                                                                                                                                                                                                                                                                                      0.00
  Real Estate Tax                                                                                                                                                                                                                                                                                                                                                                                                                                                0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00

Utilities                         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
   Phone - Home                                                                                                                                                                                                                                                                                                                                                                                                                                                  0.00
   Phone - Cell                                                                                                                                                                                                                                                                                                                                                                                                                                                  0.00
   Cable                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00
   Gas                                                                                                                                                                                                                                                                                                                                                                                                                                                           0.00
   Water                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00
   Electricity                                                                                                                                                                                                                                                                                                                                                                                                                                                   0.00
   Internet                                                                                                                                                                                                                                                                                                                                                                                                                                                      0.00
   Other                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00
   Other                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00

Health                            0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
  Dental                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00
  Medical                                                                                                                                                                                                                                                                                                                                                                                                                                                        0.00
  Medication                                                                                                                                                                                                                                                                                                                                                                                                                                                     0.00
  Vision/contacts                                                                                                                                                                                                                                                                                                                                                                                                                                                0.00
  Life Insurance                                                                                                                                                                                                                                                                                                                                                                                                                                                 0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00

Entertainment                     0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
  Memberships                                                                                                                                                                                                                                                                                                                                                                                                                                                    0.00
  Dining out                                                                                                                                                                                                                                                                                                                                                                                                                                                     0.00
  Events                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00
  Subscriptions                                                                                                                                                                                                                                                                                                                                                                                                                                                  0.00
  Movies                                                                                                                                                                                                                                                                                                                                                                                                                                                         0.00
  Music                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Hobbies                                                                                                                                                                                                                                                                                                                                                                                                                                                        0.00
  Travel/ Vacation                                                                                                                                                                                                                                                                                                                                                                                                                                               0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00

Miscellaneous                     0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00      0.00      0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00       0.00
  Dry Cleaning                                                                                                                                                                                                                                                                                                                                                                                                                                                   0.00
  New Clothes                                                                                                                                                                                                                                                                                                                                                                                                                                                    0.00
  Donations                                                                                                                                                                                                                                                                                                                                                                                                                                                      0.00
  Child Care                                                                                                                                                                                                                                                                                                                                                                                                                                                     0.00
  Tuition                                                                                                                                                                                                                                                                                                                                                                                                                                                        0.00
  College Loans                                                                                                                                                                                                                                                                                                                                                                                                                                                  0.00
  Pocket Money                                                                                                                                                                                                                                                                                                                                                                                                                                                   0.00
  Gifts                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Credit Card                                                                                                                                                                                                                                                                                                                                                                                                                                                    0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00
  Other                                                                                                                                                                                                                                                                                                                                                                                                                                                          0.00

				
DOCUMENT INFO
Description: This is a very helpful template for those wanting to be aware of their daily,weekly,monthly and yearly financial status!