Docstoc

Budget Spreadsheet assignment

Document Sample
Budget Spreadsheet assignment Powered By Docstoc
					Personal Budget
                           Jan           Feb            March      April         May         June         July          August      Sept         Oct          Nov          Dec          Year
Total Expenses               $4,782            $4,782     $4,782     $4,782       $4,782       $4,782       $4,782         $4,782     $4,782      $4,782       $4,782       $4,782       $57,384
Cash Flow                        $218           $218        $218       $218        $218         $218             $218       $218       $218            $218         $218         $218     $2,616
Income
Wages (Net Income Taxes)         5,000          5,000      5,000       5,000       5,000        5,000        5,000          5,000      5,000       5,000        5,000        5,000        60,000
Total                            5,000          5,000      5,000       5,000       5,000        5,000        5,000          5,000      5,000       5,000        5,000        5,000        60,000
Expenses
Home
Mortgage                     $1,000            $1,000     $1,000     $1,000       $1,000       $1,000       $1,000         $1,000     $1,000      $1,000       $1,000       $1,000       $12,000
Property Taxes                   $250           $250        $250       $250        $250         $250             $250       $250       $250            $250         $250         $250     $3,000
Utilities                        $300           $300        $300       $300        $300         $300             $300       $300       $300            $300         $300         $300     $3,600
Home Telephone                    $45            $45         $45           $45         $45          $45           $45        $45           $45          $45          $45          $45      $540
Cell Phone                       $155           $155        $155       $155        $155         $155             $155       $155       $155            $155         $155         $155     $1,860
Homeowners Insurance              $50            $50         $50           $50         $50          $50           $50        $50           $50          $50          $50          $50      $600
Lawn-Tree Care                    $50            $50         $50           $50         $50          $50           $50        $50           $50          $50          $50          $50      $600
Repairs                          $100           $100        $100       $100        $100         $100             $100       $100       $100            $100         $100         $100     $1,200
Total                        $1,950            $1,950     $1,950     $1,950       $1,950       $1,950       $1,950         $1,950     $1,950      $1,950       $1,950       $1,950       $23,400
Daily Living
Groceries                        $200           $200        $200       $200        $200         $200             $200       $200       $200            $200         $200         $200     $2,400
Dry Cleaning                      $50            $50         $50           $50         $50          $50           $50        $50           $50          $50          $50          $50      $600
Clothing                         $100           $100        $100       $100        $100         $100             $100       $100       $100            $100         $100         $100     $1,200
Barber-Salon                      $80            $80         $80           $80         $80          $80           $80        $80           $80          $80          $80          $80      $960
Dining Out                        $75            $75         $75           $75         $75          $75           $75        $75           $75          $75          $75          $75      $900
Total                            $505           $505        $505       $505        $505         $505             $505       $505       $505            $505         $505         $505     $6,060
Transportation
Gas-Fuel                         $150           $150        $150       $150        $150         $150             $150       $150       $150            $150         $150         $150     $1,800
Car Payment                      $200           $200        $200       $200        $200         $200             $200       $200       $200            $200         $200         $200     $2,400
Auto Insurance                    $65            $65         $65           $65         $65          $65           $65        $65           $65          $65          $65          $65      $780
Repairs                          $100           $100        $100       $100        $100         $100             $100       $100       $100            $100         $100         $100     $1,200
Total                            $515           $515        $515       $515        $515         $515             $515       $515       $515            $515         $515         $515     $6,180
Health
Prescriptions                                                $10       $10      $10      $10         $10         $10          $10         $10          $10         $10            $10      $10     $120
Copayments                                                   $50       $50      $50      $50         $50         $50          $50         $50          $50         $50            $50      $50     $600
Life Insurance                                           $250         $250     $250     $250        $250        $250         $250        $250         $250        $250           $250     $250    $3,000
Total                                                    $310         $310     $310     $310        $310        $310         $310        $310         $310        $310           $310     $310    $3,720
Recreation-Vacation
Cable TV-Internet                                        $110         $110     $110     $110        $110        $110         $110        $110         $110        $110           $110     $110    $1,320
Movies                                                       $25       $25      $25      $25         $25         $25          $25         $25          $25         $25            $25      $25     $300
Vacation                                                 $100         $100     $100     $100        $100        $100         $100        $100         $100        $100           $100     $100    $1,200
Total                                                    $235         $235     $235     $235        $235        $235         $235        $235         $235        $235           $235     $235    $2,820
Dues-Subscriptions-Giving
LPN Lic-Ins Lic-Ins Cont Ed                                  $34       $34      $34      $34         $34         $34          $34         $34          $34         $34            $34      $34     $408
Newspaper                                                    $20       $20      $20      $20         $20         $20          $20         $20          $20         $20            $20      $20     $240
Religious Organizations                                  $640         $640     $640     $640        $640        $640         $640        $640         $640        $640           $640     $640    $7,680
Charity - World Vision                                       $30       $30      $30      $30         $30         $30          $30         $30          $30         $30            $30      $30     $360
Total                                                    $724         $724     $724     $724        $724        $724         $724        $724         $724        $724           $724     $724    $8,688
Financial Obligations-Education
Long-Term Savings                                        $150         $150     $150     $150        $150        $150         $150        $150         $150        $150           $150     $150    $1,800
Credit- Card Paymets                                     $125         $125     $125     $125        $125        $125         $125        $125         $125        $125           $125     $125    $1,500
School Loan                                              $205         $205     $205     $205        $205        $205         $205        $205         $205        $205           $205     $205    $2,460
Books                                                        $63       $63      $63      $63         $63         $63          $63         $63          $63         $63            $63      $63     $756
Total                                                    $543         $543     $543     $543        $543        $543         $543        $543         $543        $543           $543     $543    $6,516
Savings
Current Amount in Savings - $4000                      $4,218        $4,436   $4,654   $4,872     $5,090       $5,308      $5,526       $5,744      $5,962      $6,180          $6,398   $6,616   $6,616
Special Purchase
2012 Ford Focus
Data                                           Description
                                        4.29% Annual interest rate
                                            60 # of payments
                                    $16,640.00 Price
                                     $2,000.00 Down Payment
                                     ($271.54) Monthly Payment
Note: If I trade in my current car, I would be able to afford this car payment since I hope to have a down payment and I would be alleviating my current car payment of $205.
If you plug in the new car payment of $272 (rounded up) in the car payment cell above,it leaves a positive cash flow of $ 146.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:4/8/2012
language:Latin
pages:2