Personal Budget Worksheets by cuiliqing

VIEWS: 9 PAGES: 4

									                                                                   Monthly Savings
                                                                  Needed to Reach A
Worksheet 1                                                              Goal
Name:                                                              Enter Name Here
Dollar Amount of the Goal                                                   $2,000.00
Annual Interest Rate (APY) or Rate of Return on Investment                     4.00%
Number of Months to Reach the Goal                                                 24
Financial Goal - Month Savings                                                 $80.18

Instructions:

1. Begin thinking about a specific financial goal to be achieved
2. Complete entries only in the yellow shaded cells
3. Be realistic in your goals and the time period needed to achieve them.
 4. Enter the interest rate or expected annual rate of return on row 4
Worksheet 2             My Cash-Flow Statement
       Name                  Enter Name Here
                        Insert Your Figures                                                       Insert Your Figures
      INCOME                                                               EXPENSES
                                                                    FIXED EXPENSES
Wages #1 (gross)                      4                                       Rent/Mortgage                 1
Wages #2 (gross)                      0                                     Home Insurance                  0
Interest Income                       0                                   Real Estate Taxes                 0
Dividend Income                       0                                      Vehicle Loan #1                0
Sales Commissions                     0                                      Vehicle Loan #2                0
Bonuses                               0                                Automobile Insurance                 0
Tips                                  0                                        Life Insurance               0
Gifts                                 0                                   Medical Insurance                 0
Tax Refunds                           0                                  Retirement Fund #1                 0
Other                                 0                                  Retirement Fund #2                 0
Other                                 0                             Student Loan Payments                   0
        TOTAL INCOME                  4                                  Federal Income Tax                 0
                                                                         State Income Taxes                 0
                                                                          City Income Taxes                 0
Instructions:                                                          Social Security Taxes                0
                                                                   Personal Property Taxes                  0
Step 1: Record income and expenses using checkbook register or bank statements Savings #1                   0
Step 2: Enter data only in yellow shaded cells                                     Savings #2               0
Step 3: Amount should be for a period of one month only                            Savings #3               0
                                                                                        Other               0
                                                                                        Other               0
                                                                                        Other               0
                                                                Total Fixed Expenses                        1

                                                                 VARIABLE EXPENSES
                                                                                 Food (home)                0
                                                                          Food (meals away)                 0
                                                                     Food (for entertainment)               0
                                                                                Entertainment               0
                                                                                    Electricity             0
                                                                                  Natural Gas               0
                                                                                 Water/Sewer                0
                                                                          Garbage Collection                0
                                                                                    Cable TV                0
                                                                             Local Telephone                0
                                                                              Long Distance                 0
                                                                                   Cell Phone               0
                                                                                     Medical                0
                                                                                      Clothing              0
                                                                                          Gifts             0
                                                                               Personal Care                0
                                                                        Personal Allowances                 0
                                                                                     Gasoline               0
                                                                        Vehicle Maintenance                 0
                                                                         Education Expenses                 0
                                                                     Charitable Contributions               0
                                                                                         Other              0
                                                                                         Other              0
                                                                                         Other              0
                                                                                         Other              0
                                                                               Miscellaneous                0
                                                                 Total Variable Expenses                    0
                                                                 TOTAL EXPENSES                             1
                                                                 SURPLUS (DEFICIT)                                3.00
                       My Balance Sheet
Worksheet 3
Your Name                          Enter Name Here                                  Insert Your Figures                                                                          Insert Your Figures
ASSETS                 Assets                                                                                                             Liabilities
       Monetary Assets Monetary Assets                                                                                                    Short Term Liabilities
                       Cash                                                                    2                                          Credit Card #1                                 1
                       Checking Account #1                                                     0                                          Credit Card #2                                 0
                       Checking Account #2                                                     0                                          Credit Card #3                                 0
                       Savings Account #1                                                      0                                          Credit Card #4                                 0
                       Savings Account #2                                                      0                                          Medical Debts                                  0
                       Savings Account #3                                                      0                                          Past Due Utilities                             0
                       Cert. Of Deposit #1                                                     0                                          Past Due Rent                                  0
                       Cert. Of Deposit #2                                                     0                                          Personal Loans                                 0
                       Money Market Acc't                                                      0                                          Other                                          0
                       Other                                                                                                              Other
                       Other                                                                   0                                          Other                                          0
                                           Total Monetary Assets                               2                                                  Total Short Term Liabilities           1

         Tangible Assets Tangible Assets                                                                                                  Long-term Liabilities
                         Vehicle #1                                                            0                                          Vehicle Loan #1                                0
                         Vehicle #2                                                            0                                          Vehicle Loan #2                                0
                         Home #1                                                               0                                          Home Mortgage #1                               1
                         Home #2                                                               0                                          Home Mortgage #2                               0
                         Clothing                                                              0                                          Student Loan(s)                                0
                         Furniture                                                             0                                          Furniture Loans                                0
                         Entertainment Electronics                                             0                                          Computer Loans                                 0
                         Home Appliances & Equip.                                              0                                          Home Appliance Loans                           0
                         Computer Equipment                                                    0                                          Personal Loans                                 0
                         Computer Software                                                     0                                          Other                                          0
                         Jewelry                                                               0                                          Other                                          0
                         Recreation Items                                                      0                                                   Total Long-term Liabilities           1
                         Personal Property                                                     0                                          TOTAL LIABILITIES                              2
                         Other Tangible Assets                                                 0
                                              Total Tangible Assets                            0

       Investment Assets Investment Assets
                         Stocks                                                                0
                         Bonds                                                                 0
                         Mutual Fund #1                                                        0
                         Mutual Fund #2                                                        0
                         Employer Retirement Account(s)                                        0
                         IRA Accounts                                                          0
                         Life Ins. Cash Value(s)                                               0
                         Real Estate Investments                                               0
                         Collectibles                                                          0
                         Other Investment Assets                                               0
                                            Total Investment Assets                            0
                         TOTAL ASSETS                                                          2                                          NET WORTH                                    0.00



Instructions:

Step 1: Enter data for Tangible and Investment Assets - Use account statements, Kelly Blue Book or other sources
Step 2: Enter data for Short term and Long term Liabilities - Use account statements, checkbook register or promissory notes as sources
Step 3: Do Not enter data in orange shaded cells
Step 4: Save data entries using the square shaped disc in top left corner above
Step 5: Print worksheet using circle in top left corner of screen
Worksheet 4                                          My New Budget

Insert Month & Year                                  Insert Your Name



                      INCOME                                                                                                                                                           EXPENSES
                                                            Income Budgeted               Actual Income   Variance B/(W)   Variance % B(W)   Explain Variance (+/-) 5%        FIXED EXPENSES                    Budget Amount   Actual Spends   Variance B/(W) Variance % B(W)   Explain Variance (+/-) 5%
Wages #1 (gross)                                                  $4                       $0                  ($4)             -100%                                                       Rent/Mortgage            $4             $5               ($1)           -25%
Wages #2 (gross)                                                  $0                       $0                  $0              #DIV/0!                                                    Home Insurance             $0             $0                $0           #DIV/0!
Interest Income                                                   $0                       $0                  $0              #DIV/0!                                                  Real Estate Taxes            $0             $0                $0           #DIV/0!
Dividend Income                                                   $0                       $0                  $0              #DIV/0!                                                     Vehicle Loan #1           $0             $0                $0           #DIV/0!
Sales Commissions                                                 $0                       $0                  $0              #DIV/0!                                                     Vehicle Loan #2           $0             $0                $0           #DIV/0!
Bonuses                                                           $0                       $0                  $0              #DIV/0!                                               Automobile Insurance            $0             $0                $0           #DIV/0!
Tips                                                              $0                       $0                  $0              #DIV/0!                                                       Life Insurance          $0             $0                $0           #DIV/0!
Gifts                                                             $0                       $0                  $0              #DIV/0!                                                  Medical Insurance            $0             $0                $0           #DIV/0!
Tax Refunds                                                       $0                       $0                  $0              #DIV/0!                                                Retirement Fund #1             $0             $0                $0           #DIV/0!
Other                                                             $0                       $0                  $0              #DIV/0!                                                Retirement Fund #2             $0             $0                $0           #DIV/0!
Other                                                             $0                       $0                  $0              #DIV/0!                                             Student Loan Payments             $0             $0                $0           #DIV/0!
                                   TOTAL INCOME                   $4                       $0                  ($4)             -100%                                                  Federal Income Tax            $0             $0                $0           #DIV/0!
                                                                                                                                                                                      State Income Taxes             $0             $0                $0           #DIV/0!
                                                                                                                                                                                        City Income Taxes            $0             $0                $0           #DIV/0!
                                                                                                                                                                                     Social Security Taxes           $0             $0                $0           #DIV/0!
Instructions:                                                                                                                                                                     Personal Property Taxes            $0             $0                $0           #DIV/0!
                                                                                                                                                                           Financial Goal - Month Savings           $80             $0               $80            100%
Step 1: Enter Income and Expense Data in yellow shade cells (not orange cells)                                                                                                                  Savings #2           $0             $0                $0           #DIV/0!
Step 2: Use Paystub, account statement or checkbook as sources                                                                                                                                  Savings #3           $0             $0                $0           #DIV/0!
Step 3: Save data entries using square shaped icon on top left of screen                                                                                                                              Other          $0             $0                $0           #DIV/0!
Step 4: Print formated worksheet using circle at top left of screen                                                                                                                                   Other          $0             $0                $0           #DIV/0!
Step 5: Be sure Personal Budget includes consideration for Financial goals                                                                                                                            Other          $0             $0                $0           #DIV/0!
Step 6: Compare Budget (Column I) with Actual Spends (Column J)                                                                                                          Total Fixed Expenses.                      $84             $5               $79             94%
Step 7: For Variances greater than 5% (Column L), input reason for variance in column M
Step 8: When writing your summary, be sure to explain what caused the                                                                                                    VARIABLE EXPENSES                      Budget Amount   Actual Spends   Variance B/(W) Variance % B(W)   Explain Variance (+/-) 5%
variances and include recommendations for improvement such as                                                                                                                                 Food (home)           $0              $0                $0           #DIV/0!
(Improve budget amount planned, reduce spending, defer spending, etc.)                                                                                                                  Food (meals away)           $0              $0                $0           #DIV/0!
                                                                                                                                                                                   Food (for entertainment)         $0              $0                $0           #DIV/0!
                                                                                                                                                                                             Entertainment          $0              $0                $0           #DIV/0!
                                                                                                                                                                                                  Electricity       $0              $0                $0           #DIV/0!
                                                                                                                                                                                               Natural Gas          $0              $0                $0           #DIV/0!
                                                                                                                                                                                              Water/Sewer           $0              $0                $0           #DIV/0!
                                                                                                                                                                                        Garbage Collection          $0              $0                $0           #DIV/0!
                                                                                                                                                                                                  Cable TV          $0              $0                $0           #DIV/0!
                                                                                                                                                                                          Local Telephone           $0              $0                $0           #DIV/0!
                                                                                                                                                                                            Long Distance           $0              $0                $0           #DIV/0!
                                                                                                                                                                                                Cell Phone          $0              $0                $0           #DIV/0!
                                                                                                                                                                                                   Medical          $0              $0                $0           #DIV/0!
                                                                                                                                                                                                   Clothing         $0              $0                $0           #DIV/0!
                                                                                                                                                                                                       Gifts        $0              $0                $0           #DIV/0!
                                                                                                                                                                                             Personal Care          $0              $0                $0           #DIV/0!
                                                                                                                                                                                      Personal Allowances           $0              $0                $0           #DIV/0!
                                                                                                                                                                                                   Gasoline         $0              $0                $0           #DIV/0!
                                                                                                                                                                                      Vehicle Maintenance           $0              $0                $0           #DIV/0!
                                                                                                                                                                                      Education Expenses            $0              $0                $0           #DIV/0!
                                                                                                                                                                                   Charitable Contributions         $0              $0                $0           #DIV/0!
                                                                                                                                                                                                      Other         $0              $0                $0           #DIV/0!
                                                                                                                                                                                                      Other         $0              $0                $0           #DIV/0!
                                                                                                                                                                                                      Other         $0              $0                $0           #DIV/0!
                                                                                                                                                                                                      Other         $0              $0                $0           #DIV/0!
                                                                                                                                                                                             Miscellaneous          $0              $0                $0           #DIV/0!
                                                                                                                                                                         Total Variable Expenses                    $0              $0                $0           #DIV/0!
                                                                                                                                                                         TOTAL EXPENSES                            $84              $5               $79            94%
                                                                                                                                                                         SURPLUS (DEFICIT)                         ($80)            ($1)             $79            -99%

								
To top