Please read the instructions and the data included in the story of Ed & Lydia Goodman's income, expense, and budget worksheet. Then complete the worksheet using the data provided. Thank you.

File Home Insert Page Layout Formulas Data Review View Automate Help B8 X V A B BUDGET WORKSHEET INCOME ITEMS N Source of Income Amount Salary, Wages, Commissions, Tips, Etc. Husband's..monthly income.. $8500 Wife's monthly income..... $3500 Interest Earned On Savings Accounts Name of Institution: Bank Account Name of Institution: S 9 Interest Earned On Bonds 10 11 From: S_ From: $ 12 Dividend Income 13 14 From: From: 15 Other Investment Income 16 17 From: From: Social Security Benefits ........ 19 VA Benefits . Expenses (+ 1File Home Insert Page Layout Formulas Data Review View Automate Help B8 X A B C VA Benefits ....... $ 20 Pensions and/or Annuities Being Received . S 21 Other Income 22 23 From: S 24 From: From: 25 TOTAL INCOME: 26 EXPENSE ITEMS 27 28 Source of Expense Preliminary FIXED EXPENSES Mortgage Payment or Rent Personal Residence ....... Other: Car Payments S Vehicle: 29 S 30 Vehicle; BUDGET WORKSHEET (Continued) 31 EXPENSE ITEMS (Continued) 32 Preliminary 33 Source of Expense 34 Utilities Expenses (+File Home Insert Page Layout Formulas Data Review View Automate Help B8 X V A B C D 34 Utilities 35 For: 36 For: 37 For: 38 Loans/Credit Cards 39 For: 40 For: 41 For: 42 Insurance Premiums (Home, Life, Health, Car) 43 For: Life $39 44 For: Car $175 45 For: Condo $100 46 For: $ 47 Allowances For: 48 Food 49 Clothing.... 50 Medical $ 51 Savings 52 Taxes (Income, Property) 53 For: 54 For: $ 55 TOTAL FIXED EXPENSES: 0 56 VARIABLE EXPENSES 57 Personal Allowances For: 58 Husband $200 Expenses +File Home Insert Page Layout Formulas Data Review View Automate Help B8 X V fic A B C $200 58 Husband .. $200 59 Wife. $400 60 Children...... 61 Entertainment/Recreation ........ $200 62 Household Expenses/Repairs........... 63 Other Expenses (Explain) 64 For: 65 For: 66 For: TOTAL VARIABLE EXPENSES: 67 TOTAL EXPENSES (Fixed + Variable) 68 69 INCOME/EXPENSE SUMMARY: TOTAL INCOME 70 LESS TOTAL EXPENSES (from above) .. SURPLUS (Deficit) 71 72 73 74 75 76 77 78 79 80 81 82 83 Expenses +Income Expense Budget Worksheet Information Use the information below to compute the monthly expense worksheet information into the provided worksheet. You can use the worksheet that has been created in Excel or create your own worksheet. You must have totals for income and expense categories and determine if there if a monthly budget surplus or deficit. MHint, remember to take any annual numbers and divide by 12 to get monthly amounts. Remember, personal finances are usually managed MONTHLY. Read the following story of Ed 8: Lydia Goodman and then input and organize their financial data. Ed and Lydia are a married couple of about 10 years and have two young children. Recently, they began to think more deeply about their personal finances and thought it would be wise to organize and budget appropriately. Ed works as a professor at a Community College earning $102,000 annually. Lydia works in a local school district as an Administrative Assistant earning $42,000 per year. They have 525,000 in the bank earning 1% interest, they currently earn $125 per month on investments in bonds, and about $95 per month on dividends in their stock portfolio. They also have an investment on a business property that earns $1000 per month. They currently own their condo in Flushing but have a mortgage payment of $1783 per month {that includes maintenance charges]. They pay $2900 in real estate taxes annually. They own a Hyundai Santa Fe utility vehicle that they are currently financing at $375 per month. As for other expenses, they pay $125 per month for electric and $30 for gas. Their internet and cable i $220 per month. They have no outstanding loans or balances on their credit card. They have condo insurance that costs $100 per month, car insurance at $175 per month, medical premiums for health insurance come out of their paychecks. Ed has a life insurance policy of $200,000 which he pays $39 per month in premiums. In creating a solid spending plan, Ed and Lydia decide to allow for personal expenses monthly. They allow for personal expenses of $200 each per month for each of them to spend on whatever they like. Additionally, they set a budget of $400 per month for their children (clothing, etc.) and an additional $200 per month for entertainment such as going out to the movies, bowling with friends, etc