Microsoft+Excel+5

= = My Family Budget

**Open Excel and begin....(see lesson 6 for a template!!)** Please read the following scenario: You are currently living in OKLAHOMA CITY You are: Married You have 1 girl, age 15 & 1 boy, age 4 You must name your spouse and children in the blanks below:

Spouse_____________________________

Child #1____________________________ Child #2____________________________

You are responsible for creating a monthly budget for your family for the month of December 2008. Your budget must be realistic and you must live within your means. Please create a spreadsheet that reflects your family's monthly income and expenditures with the following information:

§ Your occupation is: SOCIAL WORKER (Please find and print the annual income for this occupation in the city where you live, then divide that amount by 12, the number of months in a year, to determine your monthly income.)

Your spouse's occupation, if applicable: NURSE (Please find and print the annual income for this occupation in the city where you live, then divide that amount by 12 to determine your monthly income) If you are divorced, you have custody of the children and your monthly child support is:

§ You live in a 4 bedroom apartment with your family. (Please find the cost of the apartment per month)

§ If your apartment doesn't include garbage pickup, water, parking fees, gas, heating, and lights, please determine your monthly costs for these expenses.

§ You will need renter's insurance for the contents of your apartment. Please find this monthly expense.

§ Please determine your monthly telephone expenses. (Find any information that supports your findings.)

§ Please determine your monthly cable expenses. (Find any information that supports your findings.)

§ Please determine your automobile expenses - as in previous lesson, expenses must include - monthly payment including interest, insurance, routine maintenance and oil changes, car washes, and gas. (Please find all information that supports your findings.)

§ Calculate your monthly entertainment expenses. Please find at least two family entertainment venues in your city (ie. movies, games, theme park, etc.). Calculate the monthly cost for your family to attend those events.

§ Clothing expenses: Determine the monthly clothing expense for your family. Break down the items you will purchase for each family member.

§ Food expenses: Determine the monthly food expenses for your family.

§ Childcare expenses: Find and print the monthly childcare expenses for your family. Even if your children are school aged, you must budget for after school care.

§ Household items - ie. Toilet paper, shampoo, deodorant, cleaner, newspaper, etc. Please determine your monthly expenses for household items.

§ Personal Care: haircuts, manicure, etc. Please breakdown these expenses and calculate your family's total monthly expenses.

§ Birthdays/Valentine's Day: You must give your spouse and children Valentine's Day gifts. If any of your friends/relatives have a February birthday, you must also purchase a gift for them. Please find the gifts you will be giving and calculate your monthly expense.

§ Savings: The remainder of your income after all expenses are paid will go into a savings account. Please indicate the amount you will put in your savings account, monthly.

After you have gathered all of the above information, please create a spreadsheet showing your budget. Your spreadsheet should contain formulas so you can plug in different numbers each month and your spreadsheet will accurately calculate the current month's expenses.

Graph your spreadsheet using a graph style that you feel best illustrates the breakdown of your monthly expenses. Customize your graph to look visually pleasing.