| Excel Worksheet 3.1 Personal Financial Planner: Household Budget |
| Directions: Use this worksheet to create a budget. (1) Complete the first column by entering your actual cash flows for the most recent year in the blue-shaded cells. Your net cash flow will calculate in the peach-shaded cell at the bottom of the column. (2) In the second column (First-Pass Budget), enter the expected inflation rate (e.g., 3%). The worksheet will calculate the new values for your cash inflows and outflows and the net cash flow in the peach-shaded cells. (3) Use the third column (Final Budget) to reconcile your budget, revising the first pass to reflect other information you have or to incorporate financial decisions you have made--e.g., to save more or to cut down on certain spending categories. When you are finished making adjustments, the Net Cash Personal Flow at the bottom of the column should be zero. |
| | Actual Current-Year Cash Flows | | First-Pass Budget for Next Year | | Final Budget for Next Year |
| Expected inflation rate: | | | 3.0% |
| Expected salary increase: | | | 3.0% |
| Cash Inflows |
| After-tax income | 293,506 | | 302,311 | | 302311 |
| Interest/dividend income | | |
|
| Rental income | | |
|
| Investment income | | |
|
| Child support and alimony | | |
|
| Other | | |
|
| Total Income | 293506 | | 302311.18 | | 302311 |
| Cash Outflows |
| Groceries and eating out | 85600 | | 88168 | | 55000 |
| Housing |
| Rent | | |
|
| Mortgage principal and interest | | |
|
| House repairs/expenses | | | | | 17000 |
| Property taxes and insurance | | |
|
| Utilities |
| Heating | 6500 | | 6695 | | 5000 |
| Electric | 9500 | | 9785 | | 6500 |
| Water and sewer | 4500 | | 4635 | | 3000 |
| Cable/phone/satellite | 12500 | | 12875 | | 8500 |
| Car loan payments | | | | | 22000 |
| Car maintenance/gas | | |
|
| Credit card payments | 25000 | | 25750 |
| Insurance |
| Life | 14600 | | 15038 | | 16000 |
| Health | 13200 | | 13596 |
| Auto | 4500 | | 4635 |
| Disability | 5000 | | 5150 |
| Clothing | 9600 | | 9888 | | 13400 |
| Gifts | 12400 | | 12772 | | 16000 |
| Other consumer goods (e.g., TVs) | | |
|
| Child-care expenses | | |
|
| Sports-related expenses | 23000 | | 23690 |
| Health club dues | 1500 | | 1545 |
| Uninsured medical expenses | | |
|
| Education/training | 12500 | | 12875 |
| College fund | | | | | 9800 |
| Vacations | 13560 | | 13966.8 | | 16500 |
| Entertainment | 22400 | | 23072 |
| Charitable contributions | | |
|
| Non-employer retirement contributions | | |
|
| Magazine subscriptions/books | | |
|
| Other payments/expenses | 17646 | | 18175.38 | | 113611 |
| Note:In Column 3; Other includes, Reduced Debt, save for retirement and Leave large nheritence |
| Total Expenses | 293506 | | 302311.18 | | 302311 |
| Net Personal Cash Flow | 0 | | 0 | | 0 |
meero181
ExcelWorksheet3.1PFPHouseholdBudget.xlsx
