Analysis: After completing the budget and uploading it to Moodle, use the spreadsheet to modify the quantities so you can get the net monthly cash flow to zero and achieve as many of the goals as possible. You can do this by trimming and consolidating expenses and possibly recommending some realistic ways to increase income. 1. What was the original net monthly cash flow for the Davidsons? 2. What changes did you make to reach a net monthly cash flow to zero? Davidson Family Monthly Budget Action Plan Monthly Monthly Monthly INCOME Miscellaneous Income Salary Income Total 65.49 59.400.00 59.400.00 78.00 1979 109.45 39.56 1,349.00 112.50 PAYROLL DEDUCTIONS Federal Income Tax FICA Tax State Income Tax 401- Retirement Plan Payroll Deductions Total 15.94 291.83 EXPENSES Insurance Auto I Health Homeowner's Life Insurance Total Transportation Fuel Maintenance/Repairs Truck Payment Transportation Total EXPENSES Home Cable TV Cellular telephone Electricity Home Mortgage County Property Taxes Internet Landline telephone Natural Gas Water/Sewer/Garbage Home Total Daily Living Charitable Contributions Iclothing Credit Card Payment Dining Out Entertainment Groceries Health Club Dues Household Supplies Miscellaneous Pet Food/ Vet bills Daily Living Total 367.45 378.68 162.50 34.17 9 42.80 43.68 32.50 89.75 53.49 1.895.42 150.00 30.00 5816.00 766.00 Total Expenses 4,218.25 FAMILY SAVINGS Emergency Christmas Medica Dental Vision I Vacation Family Savings Total Net Monthly Cash Flow 54,238.95 0.00 60.00 90.00 95.00 125.00 65.00 635.00 48.00 35.00 70.00 42.00 1.265.00 Cash Flow Income-Deductions - Swing - Expenses Analysis: After completing the budget and uploading it to Moodle, use the spreadsheet to modify the quantities so you can get the net monthly cash flow to zero and achieve as many of the goals as possible. You can do this by trimming and consolidating expenses and possibly recommending some realistic ways to increase income. 1. What was the original net monthly cash flow for the Davidsons? 2. What changes did you make to reach a net monthly cash flow to zero? Davidson Family Monthly Budget Action Plan Monthly Monthly Monthly INCOME Miscellaneous Income Salary Income Total 65.49 59.400.00 59.400.00 78.00 1979 109.45 39.56 1,349.00 112.50 PAYROLL DEDUCTIONS Federal Income Tax FICA Tax State Income Tax 401- Retirement Plan Payroll Deductions Total 15.94 291.83 EXPENSES Insurance Auto I Health Homeowner's Life Insurance Total Transportation Fuel Maintenance/Repairs Truck Payment Transportation Total EXPENSES Home Cable TV Cellular telephone Electricity Home Mortgage County Property Taxes Internet Landline telephone Natural Gas Water/Sewer/Garbage Home Total Daily Living Charitable Contributions Iclothing Credit Card Payment Dining Out Entertainment Groceries Health Club Dues Household Supplies Miscellaneous Pet Food/ Vet bills Daily Living Total 367.45 378.68 162.50 34.17 9 42.80 43.68 32.50 89.75 53.49 1.895.42 150.00 30.00 5816.00 766.00 Total Expenses 4,218.25 FAMILY SAVINGS Emergency Christmas Medica Dental Vision I Vacation Family Savings Total Net Monthly Cash Flow 54,238.95 0.00 60.00 90.00 95.00 125.00 65.00 635.00 48.00 35.00 70.00 42.00 1.265.00 Cash Flow Income-Deductions - Swing - Expenses