Create a Budget and Personal Net Worth Statement
AutoSave OFF ABC -- CO My Budget Data Review View Tell me Share Comments a Wraa Text y General Insert v v ' AY = = = - - Merge & Center $ % ) Delete Format Conditional Format Cell Formatting as Table Styles y v v Sort Filter y Find & Select C D E F G H 1 J K 1 0 0 0 0 0 Home Insert Draw Page Layout Formulas - X Arial v 12 v P A LG Paste BIU CA B3 + x fx Insert Your Name A B B 1 My Budget (pagos 91-105) 2 3 Insert Month Insert Your Name 4 5 6 INCOME 7 8 Wages #1 (gross) 9 Wages #2 (grass) 10 Interest Income 11 Dividend Income 12 Sales Commissions 13 Bonuses 14 Tips 15 Gifts 16 Tax Refunds 17 Other 18 Other 19 TOTAL INCOME 20 21 22 23 24 25 26 27 28 29 3D 31 32 33 34 Sheet1 Sheel2 Sheet3 + Ready 0 0 0 EXPENSES FIXED EXPENSES 4 Rent Mortgage 0 Home Insurance 0 Real Estate Taxes 0 Vehicle Loan #1 0 Vehicle Loan #2 0 Automobile Insurance 0 Life Insurance 0 Medical Insurance 0 Retirement Fund #1 0 Retirement Fund #2 0 Student Loan Payments 4 Federal Income Tax State Income Taxes City Income Taxes Social Security Taxes Personal Property Taxes Savings #1 Savings #2 Savings #3 Other Other Other Total Fixed Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 VARIABLE EXPENSES Food (home) Food (meals away) 0 0 + 120% AutoSave OFF ABC -- CO My Budget Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments I47 Arial v 12 v P A y ah Wras Text General v X [G Insert y Delete Format v Paste A = = = Merge & Center $ % ) Conditional Format Cell Formatting as Table Styles v Sort Filter y Find & Select BIU x fx Insert Your Name B3 A B C D E F G . 1 J K 0 0 0 0 0 24 35 38 37 38 39 40 41 42 43 44 0 0 0 0 0 0 45 46 47 48 Food (meals away) Food (for entertainment) Entertainment Electricity Natural Gas Water/Sewer Garbage Collection Cable TV Local Telephone Long Distance Cell Phone Medical Clothing Gifts Personal Care Personal Allowances Gasoline Vehicle Maintenance Education Expenses Charitable Contributions Other Other Other Other Miscellaneous Total Variable Expenses TOTAL EXPENSES SURPLUS (DEFICIT) 0 0 0 0 0 0 0 49 50 51 52 53 54 55 56 57 0 0 0 58 59 60 0 0 0 0 0 1 3.00 62 83 64 85 66 87 Sheet1 Sheel2 Sheet3 + Ready E + 120% AutoSave OFF ABC -- CO My Budget Data Review View Tell me Share Comments a Wraa Text y General Insert v v ' AY = = = - - Merge & Center $ % ) Delete Format Conditional Format Cell Formatting as Table Styles y v v Sort Filter y Find & Select C D E F G H 1 J K 1 0 0 0 0 0 Home Insert Draw Page Layout Formulas - X Arial v 12 v P A LG Paste BIU CA B3 + x fx Insert Your Name A B B 1 My Budget (pagos 91-105) 2 3 Insert Month Insert Your Name 4 5 6 INCOME 7 8 Wages #1 (gross) 9 Wages #2 (grass) 10 Interest Income 11 Dividend Income 12 Sales Commissions 13 Bonuses 14 Tips 15 Gifts 16 Tax Refunds 17 Other 18 Other 19 TOTAL INCOME 20 21 22 23 24 25 26 27 28 29 3D 31 32 33 34 Sheet1 Sheel2 Sheet3 + Ready 0 0 0 EXPENSES FIXED EXPENSES 4 Rent Mortgage 0 Home Insurance 0 Real Estate Taxes 0 Vehicle Loan #1 0 Vehicle Loan #2 0 Automobile Insurance 0 Life Insurance 0 Medical Insurance 0 Retirement Fund #1 0 Retirement Fund #2 0 Student Loan Payments 4 Federal Income Tax State Income Taxes City Income Taxes Social Security Taxes Personal Property Taxes Savings #1 Savings #2 Savings #3 Other Other Other Total Fixed Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 VARIABLE EXPENSES Food (home) Food (meals away) 0 0 + 120% AutoSave OFF ABC -- CO My Budget Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments I47 Arial v 12 v P A y ah Wras Text General v X [G Insert y Delete Format v Paste A = = = Merge & Center $ % ) Conditional Format Cell Formatting as Table Styles v Sort Filter y Find & Select BIU x fx Insert Your Name B3 A B C D E F G . 1 J K 0 0 0 0 0 24 35 38 37 38 39 40 41 42 43 44 0 0 0 0 0 0 45 46 47 48 Food (meals away) Food (for entertainment) Entertainment Electricity Natural Gas Water/Sewer Garbage Collection Cable TV Local Telephone Long Distance Cell Phone Medical Clothing Gifts Personal Care Personal Allowances Gasoline Vehicle Maintenance Education Expenses Charitable Contributions Other Other Other Other Miscellaneous Total Variable Expenses TOTAL EXPENSES SURPLUS (DEFICIT) 0 0 0 0 0 0 0 49 50 51 52 53 54 55 56 57 0 0 0 58 59 60 0 0 0 0 0 1 3.00 62 83 64 85 66 87 Sheet1 Sheel2 Sheet3 + Ready E + 120%
