Docstoc

cash flow income statement (Excel)

Document Sample
cash flow income statement (Excel) Powered By Docstoc
					                                                          Percentage to
Income Category                            Budget
                                                              Total

Alimony Received                                     $0                   -

Bonus Income                                         $0                   -
Child Support Received                               $0                   -

Dividend Income                                      $0                   -
Gifts Received                                       $0                   -

Gross Income                                  $4,000                67%

Investment Income                                    $0                   -
Other Income                                         $0                   -

Social Security Income                               $0                   -
Spouse Bonus                                         $0                   -

Spouse Income                                 $2,000                33%
Total Income                                  $6,000               100%

Savings

IRA / 401K                                      $600                10%

Savings                                         $300
Total Savings                                   $900                15%
                                                          Percentage to
Expense Category                           Budget
                                                              Total

Alimony Paid                                         $0                   -

Automobile: Fuel                                $200                 3%

Automobile: Insurance                           $100                 2%
Automobile: Maintenance                             $50              1%

Automobile: Registration                             $0                   -
Automobile: Payment                             $300                 5%

Charity                                              $0                   -

Child Support Paid                                   $0                   -

Church                                          $200                 3%
Clothing                                        $100                 2%

Dining: Coffee / Other Drinks                       $50              1%

Dining: Restaurant                              $150                 3%
Education                                            $0                   -

Entertainment                                   $200                 3%
Furniture                                            $0                   -

Gifts Given                                     $100                 2%

Groceries                                       $500                 8%
Household: Household products                        $0                   -

Household: Inside Maintenance                        $0                   -
Household: Outside Maintenance                       $0                   -
Life Insurance                                      $20              0%

Medical: Doctor / Hospital                      $100                 2%

Medical: Insurance premium                      $100                 2%
Medical: Prescriptions                              $50              1%

Mortgage                                      $1,250                21%
Personal Care: Gym membership                       $75              1%

Personal Care: Haircut                              $50              1%
Personal Care: Other                            $150                 3%

Pet Care                                            $25              0%
Taxes: Federal                                  $600                10%
Taxes: Property Taxes                           $200                 3%

Taxes: State Income                                  $0                   -

Utilities: Cable                                    $50              1%

Utilities: Cell phone                               $80              1%
Utilities: Heat/Energy                          $150                 3%

Utilities: Home phone                               $40              1%
Utilities: Internet                                 $50              1%

Utilities: Sewer                                    $40              1%
Utilities: Water                                    $40              1%
Total Expenses                                $5,020
Net Cash Flow With Investments & Savings        $980              16.3%
                         January
Date        Merchant                  Category         Amount

 1/1/2012              Mortgage                                 $1,250.00

 1/2/2012              Gross Income                             $4,000.00
 1/3/2012              Automobile: Payment                       $300.00
 1/4/2012              Groceries                                 $200.00
 1/5/2012              Gifts Given                                $25.00

 1/6/2012              Personal Care: Gym membership              $50.00
 1/7/2012              Dining: Restaurant                         $30.00
 1/8/2012              Utilities: Cable                           $70.00
 1/9/2012              Utilities: Cell phone                      $50.00
1/10/2012              Clothing                                  $100.00
Income                     Budget

Alimony Received               $0

Bonus Income                   $0

Child Support Received         $0

Dividend Income                $0

Gifts Received                 $0

Gross Income               $4,000

Investment Income              $0

Other Income                   $0
Social Security Income         $0

Spouse Bonus                   $0

Spouse Income              $2,000
Total Income               $6,000

Savings

IRA / 401K                   $600

Savings                      $300
Total Savings                $900
Expenses                   Budget

Alimony Paid                   $0

Automobile: Fuel             $200

Automobile: Insurance        $100

Automobile: Maintenance       $50

Automobile: Registration       $0

Automobile: Payment          $300

Charity                        $0

Child Support Paid             $0
Church                       $200

Clothing                     $100
Dining: Coffee / Other Drinks      $50

Dining: Restaurant                $150

Education                           $0

Entertainment                     $200

Furniture                           $0

Gifts Given                       $100

Groceries                         $500

Household: Household products       $0

Household: Inside Maintenance       $0
Household: Outside Maintenance      $0

Life Insurance                     $20

Medical: Doctor / Hospital        $100

Medical: Insurance premium        $100

Medical: Prescriptions             $50

Mortgage                         $1,250

Personal Care: Gym membership      $75

Personal Care: Haircut             $50

Personal Care: Other              $150

Pet Care                           $25

Taxes: Federal                    $600
Taxes: Property Taxes             $200

Taxes: State Income                 $0

Utilities: Cable                   $50

Utilities: Cell phone              $80

Utilities: Heat/Energy            $150

Utilities: Home phone              $40
Utilities: Internet                $50

Utilities: Sewer                   $40
Utilities: Water                             $40
Total Expenses                             $5,020

Net Cash Flow With Investments & Savings    $980

Non-Discretionary Spending                 $3,920

Discretionary Spending                     $1,100
 Actual   Variance   Percentage

    $0         $0           0%    January

    $0         $0           0%    February

    $0         $0           0%    March

    $0         $0           0%    April

    $0         $0           0%    May

 $4,000        $0         100%    June

    $0         $0           0%    July

    $0         $0           0%    August
    $0         $0           0%    September

    $0         $0           0%    October

    $0     $2,000           0%    November
 $4,000    $2,000         100%    December



    $0      ($600)          0%

    $0      ($300)          0%
    $0       $900           0%
Amount    Variance   Percentage

    $0         $0           0%

    $0       $200           0%

    $0       $100           0%

    $0        $50           0%

    $0         $0           0%

  $300         $0           8%

    $0         $0           0%

    $0         $0           0%
    $0       $200           0%

  $100         $0           3%
   $0     $50    0%

  $30    $120    1%

   $0      $0    0%

   $0    $200    0%

   $0      $0    0%

  $25     $75    1%

 $200    $300    5%

   $0      $0    0%

   $0      $0    0%
   $0      $0    0%

   $0     $20    0%

   $0    $100    0%

   $0    $100    0%

   $0     $50    0%

$1,250     $0    31%

  $50     $25    1%

   $0     $50    0%

   $0    $150    0%

   $0     $25    0%

   $0    $600    0%
   $0    $200    0%

   $0      $0    0%

  $70    ($20)   2%

  $50     $30    1%

   $0    $150    0%

   $0     $40    0%
   $0     $50    0%

   $0     $40    0%
   $0      $40    0%
$2,075   $2,945   52%

$1,925    $945    48%

$1,870   $2,050   90%

 $205     $895    10%
Alimony Received

Bonus Income

Child Support Received

Dividend Income

Gifts Received

Gross Income

Investment Income

Other Income
Social Security Income

Spouse Bonus

Spouse Income




IRA / 401K

Savings
Alimony Paid                    Non-Discretionary

Automobile: Fuel                Non-Discretionary

Automobile: Insurance           Non-Discretionary

Automobile: Maintenance         Non-Discretionary

Automobile: Registration        Non-Discretionary

Automobile: Payment             Non-Discretionary

Charity                         Discretionary

Child Support Paid              Non-Discretionary

Church                          Discretionary

Clothing                        Discretionary
Dining: Coffee / Other Drinks   Discretionary

Dining: Restaurant              Discretionary
Education                       Discretionary

Entertainment                   Discretionary

Furniture                       Discretionary

Gifts Given                     Discretionary

Groceries                       Non-Discretionary

Household: Household products Discretionary

Household: Inside Maintenance   Discretionary

Household: Outside Maintenance Discretionary

Life Insurance                  Non-Discretionary
Medical: Doctor / Hospital      Non-Discretionary

Medical: Insurance premium      Non-Discretionary

Medical: Prescriptions          Non-Discretionary

Mortgage                        Non-Discretionary

Personal Care: Gym membership Discretionary

Personal Care: Haircut          Discretionary

Personal Care: Other            Discretionary

Pet Care                        Discretionary

Taxes: Federal                  Non-Discretionary

Taxes: Property Taxes           Non-Discretionary

Taxes: State Income             Non-Discretionary
Utilities: Cable                Non-Discretionary

Utilities: Cell phone           Non-Discretionary

Utilities: Heat/Energy          Non-Discretionary

Utilities: Home phone           Non-Discretionary

Utilities: Internet             Non-Discretionary

Utilities: Sewer                Non-Discretionary
Utilities: Water                Non-Discretionary

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:68
posted:4/16/2012
language:English
pages:82