Docstoc

Budget Spreadsheet

Document Sample
Budget Spreadsheet Powered By Docstoc
					   Worksheet Instructions

                       Print this sheet so you can refer to it as you learn how to use the worksheets.

       General Information
     1 Fields with dashes ( - ) are formula fields. Do not change or function of sheet will be invalidated.
     2 As a safeguard against accidental format or formula changes, all of these worksheets have been protected.
       If it is necessary to change a formula you can "unprotect" the sheet by selecting "Tools" then
       "Protection" and "Unprotect Sheet." It is recommended you re-protect the worksheet after changes.
     3 Since the sheet is protected, you can navigate from cell to cell by pressing the "Tab" key. You can return
       to a previous cell by holding down the "Shift" key and then pressing "Tab."

       Income & Expenses (Budget)
     1 Click on Budget tab in lower left to select worksheet.
     2 Enter Name in Cell M1. (It will automatically replicate on all other worksheets.) Then, press "Tab."
     3 Pressing "Tab" will take you to a label cell, then a green shaded $$ entry field, and then to a blank cell (for
       any brief notation entry).
     4 Make entries as noted. Skip non-applicable cells. Change cell labels as appropriate.
     5 For annual or semi-annual expenses such as Vacation, Christmas Gifts, Car Insurance, etc., enter a
       monthly budget figure. You can have Excel calculate this amount for you as follows. Begin cell entry with
       "=" followed by annual amount divided by 12. Example: =1000/12, press "Tab" or "Enter" to complete
       calculation. Cell will show monthly amount of 83.33.
     6 Be sure to enter paycheck deductions in the appropriate categories.
     7 NOTE: Worksheet automatically calculates catergory subtotals, the percent each category is of the Net
       Spendable Income, and compares Total Expenses to Net Spendable Income .

       Allocations Sheet
     1 Click on allocations tab in lower left to select worksheet.
       This worksheet helps you allocate each paycheck to cover the items in your monthly budget. It will adapt
       to a monthly, bi-monthly or bi-weekly pay cycle. Extra Check 1 & 2 are for those months you receive 3
       bi-weekly checks in a month.
     2 Enter Gross Income in "green" shaded field in dollars and cents (e.g., $1245.90).
       Enter Tithe and Taxes… Net Spendable will automatically calculate. NOTE: This will not be the same as
       your net take home pay.
     3 Be sure to enter the paycheck deductions in the appropriate category.
     4 Enter allocated $$ in appropriate category field. Allocated $$ will autosum in "red" shaded field.
     5 Rename sub-category fields as needed. Do not alter the major, numbered categories.
     6 As $$ are allocated, the Miscellaneous balance will reduce. This same balance will appear in body of
       worksheet automatically.
     7 As you scroll down the list, the summary section at top of worksheet remains frozen so you always see
       total allocations and remaining balance.

       Balances Sheet
     1 Click on Balances tab in lower left to select Category Balances worksheet.
       This worksheet helps you track expenses as they occur so you know how much money is left to spend in
       each category.
     2 Most often tracked categories are already listed. You can change categories heading as needed.
     3 Enter Category $$ Allocation in "green" shaded field in dollars and cents (e.g., $1245.90).
     4 Enter Spent $$ in expense section. Total expenses will autosum in "red" shaded area.
     5 Remaining Category balance ("yellow" cell) auto-calculates.

       Tips for Using Balances Sheet
     1 Each time you allocate more money to a category (ie, you just got paid again), select appropriate "green"
       cell, press "=", enter balance amount shown in the "yellow" cell, press "+", enter new $$ you are allocating.
       Example: =25.50+100.00. When you press enter, the cell will show 125.50 as the new balance.
     2 Then delete the column of individual expense amounts for that category to start your expense tracking over.




ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls
Created by Tim Johnson                                                                                        Revised 8/13/03
   Worksheet Instructions

       Financial Statement
     1 This sheet summarizes your Assets and Liabilities, autosums each, and calculates Net Worth.
     2 Navigation through the worksheet is similar to Income & Expenses.

       Debt List
     1 This is a listing of all debts, including Mortgage, real estate, car loans, credit card debt and other notes.
     2 Enter amount owed in dollars and cents beginning with the largest debt to the smallest.
     3 The "Payments Left" cell is automatically calculated after "Pay Off Amount" "Monthly Payment" and
       "Annual Int. Rate" is entered. Increasing the "Monthly Payment" will decrease the payments left.
     4 All debts listed will autosum in the Grand Total cells at the bottom of the worksheets.
     5 To total the Credit Card debt, create a formula in the cell and add together the appropriate cells in the
       column above. Do this for both the "Pay Off Amount" and the "Monthly Payment."




ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls
Created by Tim Johnson                                                                                         Revised 8/13/03
 Monthly Income and Expenses                                                                                                     Type Name in M1


Gross Income Per Month                                                         Summary of Net Spendable Income and Expenses

                       Salary 1                                                              Net Spendable Income                      -      100%

                       Salary 2                                                                        Less Expenses

                        Interest                                                      Unallocated Surplus Income                       -

                     Dividends

                          Other

Less                                                                       8 Enter. / Rec. (4%-8%)

   1 Tithe (10%)                                                                          Eating Out

   2 Tax (Est. - Incl. Fed, St, FICA)                                                   Baby Sitting

Net Spendable Income                               -                                  Activities/Trips

   3 Housing (38%-29%)                                                                      Vacation

              Mortgage (rent)                                                                      Pets

                     Insurance

                         Taxes                                             9 Clothing (5%-7%)

                     Electricity                                          10 Savings (5%)

                            Gas                                           11 Medical Expenses (5%-4%)

                         Water                                                                    Doctor

                    Sanitation                                                                Dentist

                    Telephone                                                                     Drugs

                 Maintenance

                          Cable                                           12 Miscellaneous (5%-8%)

                          Other                                                   Toiletry, cosmetic

   4 Food (14%-11%)                                                                  Beauty, barber

   5 Automobile(s) (14%-12%)                       -                              Laundry, Cleaning

                    Payments                                                    Allowance, lunches

                     Gas & Oil                                                        Men's/ Ladie's

                     Insurance                                                Gifts (incl. Christmas)

               License/Taxes                                                                       Cash

      Maint./Repair/Replace

   6 Insurance (5%)                                -

                            Life                                          13 Investments (5%)

                       Medical                                            14 School / Child Care (8%-5%)*

                                                                                             Lunches

   7 Debts (5%)                                    -                                        Materials

                Credit Card(s)                                                        Transportation

               Loans & Notes                                                               Day Care



                                                                        Total Expenses

NOTE: Enter whole dollar figures.                                       *Percentages in other categories must be altered if expenses in category 14.



ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls        Crown Financial Ministries at Casas
Inc & Exp (Budget)                         10801 N La Cholla Blvd - Tucson, AZ 85742 - 878-1103                                             4/15/2012
          Income Allocations                                                                                            Type Name in M1

                                             First   Second          Monthly       Extra       Monthly      Extra    Monthly    Extra
                                           Paycheck Paycheck          Total       Check 1       Total      Check 2    Total    Income
          Gross Income                                                      -
           1 Tithe                                                          -
           2 Taxes (Fed, Az, FICA)                                          -
          Net Spendable Income                  -             -           -             -                      -                   -
          Allocated                             -             -           -             -                      -                   -
          Misc. Balance                         -             -           -             -                      -                   -
           3 Housing                                                      -
              Mortgage (PITI) /Rent                                       -
              Electricity                                                 -
              Gas                                                         -
              Water                                                       -
              Sanitation                                                  -
              Telephone                                                   -
              Maintenance                                                 -
                                                                          -
                                                                          -
           4 Food                                                         -
           5 Automobiles                                                  -
             Payments                                                     -
             Gas & Oil changes                                            -
             Insurance                                                    -
             License/Taxes                                                -
             Maint/Repair/Replace                                         -
           6 Insurance                                                    -
             Life                                                         -
             Medical                                                      -
                                                                          -
           7 Debts                                                        -
             Credit Cards                                                 -
             Loans & Notes                                                -
                                                                          -
                                                                          -
           8 Enter. / Recreation                                          -
             Eating Out                                                   -
             Baby Sitting                                                 -
             Activities/Trips                                             -
             Vacation                                                     -
                                                                          -
           9 Clothing                                                     -
          10 Savings                                                      -
          11 Medical                                                      -
             Doctor                                                       -
             Dentist                                                      -
             Drugs                                                        -
                                                                          -
                                                                          -
          12 Miscellaneous                      -             -           -             -                      -                   -
             Toiletry, Cosmetic                                           -
             Beauty, Barber                                               -
             Laundry, Cleaning                                            -
             Allowance, Lunches                                           -
             Subscriptions                                                -
             Gifts (Inc. Christmas)                                       -
             Cash                                                         -
                                                                          -
                                                                          -
          13 Investments                                                  -
          14 School / Childcare                                           -
             Tuition                                                      -
             Materials                                                    -
             Transportation                                               -
             Day Care                                                     -
                                                                          -
                                                                          -


ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls                  Crown Financial Ministries at Casas
Allocations                                         10801 N La Cholla Blvd - Tucson, AZ 85742 - 878-1103                         Updated: 4/15/2012
     Allocation Balances                                                                                                                                                                       Type Name in M1

              Housing        Housing      Housing    Housing  Housing          Auto        Auto         Auto         Auto        Eating                          Emerg.    Medical /             Gifts /  School /
 Category                                                               Food                                                               Vacation   Clothing                         Misc.
              Elec/Gas        Water      Sanitation Telephone Maint.           Gas         Insur       Registr      Repair        Out                            Savings   Supplmnt             Christmas Childcare
 Allocated
  Amount
    Spent
                     -             -            -       -         -        -      -            -            -            -             -        -          -         -          -         -           -             -
   Amount
Remaining
                     -             -            -       -         -        -      -            -            -            -             -        -          -         -          -         -           -             -
   Balance
    Listing
         of
 Individual
  Expense
  Amounts




   Listing
        of
Individual
 Expense
 Amounts




   Listing
        of
Individual
 Expense
 Amounts




     ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls                                        Crown Financial Ministries at Casas
     Balances                                                                   10801 N La Cholla Blvd - Tucson, AZ 85742 - 878-1103                                                            Updated:4/15/2012
 Financial Statement                                                                                                           Type Name in M1


                                   Assets                                                                 Liabilities
       Liquid Assets                                                                Liabilities
       (Checking, Savings, Money Market, Cash)                                      (Mortgages, Loans, Credit Card Debt, Other Debts)

                    Checking 1                                                                    Mortgage

                    Checking 2                                                                 Auto 1 Loan

                     Savings 1                                                                 Auto 2 Loan

                     Savings 2                                                     Total Credit Card Debt

                Money Market

                           Cash




                      Total Liquid Assets (A)             -

       Invested Assets
       (IRAs, TSAs, 401k, Investments, real estate, CDs,                                                Total Liabilities          -
       Life Ins. Cash Value, etc.)

                           401K

                            TSA

                             IRA

         Life Ins. Cash Value                                                             Summary of Assets, Liabilities & Net Worth

                   Investments                                                                                        As of:

                   Real Estate                                                                                Total Assets         -

                            CDs                                                                            Total Liabilities       -

                                                                                         Net Worth (Assets - Liabilities)          -



                   Total Invested Assets (B)              -

       Use Assets
       (Residence, Autos, Personal Belongings, Etc.)

                     Residence

                          Auto 1

                          Auto 2

                   Furnishings




                          Total Use Assets (C)            -

                        Total Assets (A+B+C)              -                   NOTE: Enter whole dollar figures.



ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls              Crown Financial Ministries at Casas
Financial Stmt                                   10801 N La Cholla Blvd - Tucson, AZ 85742 - 878-1103                                   4/15/2012
Current Debt List                                                                                                        Type Name in M1

                                           Phone Number                   Pay Off             Monthly     Annual     Date Due   Payments
         To Whom Owed
                                           Contact Name                   Amount              Payment    Int. Rate   in Month     Left




                                              Credit Card Total:

                                                  Grand Totals:                     -                -




ffeaaf9f-a427-4820-b472-83b9e3c6997a.xls           Crown Financial Ministries at Casas
Debt List                                     10801 N La Cholla Blvd - Tucson, AZ 85742 - 878-1103                                4/15/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:4/16/2012
language:
pages:7