Reference no: EM131983515

Instructions:

1. In the first row of the spreadsheet enter your name

2. Enter the row titles given on the attached form, with the same formatting

3. Enter the career chosen

4. Income Section

a. Go online and find the average annual beginning salary for the job you chose

i. If you can only find salary per hour, take that number and multiply it by 2,080 (the number of hours worked in a year)

b. Enter the amount of federal taxes

i. Lawyer $22,670

ii. Teacher $8,516

iii. Nurse $10,664

iv. Taxi driver $2,650

v. Construction laborer $3,549

c. Enter the amount of state taxes

i. Lawyer $6,561

ii. Teacher $2,359

iii. Nurse $2,978

iv. Taxi driver $732

v. Construction laborer $948

d. Enter a formula to compute Salary after Taxes (Salary before taxes minus federal taxes and state taxes)

e. Enter a formula to compute Monthly Salary after Taxes (divide Salary after Taxes by 12)

5. Expenses Section

a. Medical insurance cost is $0 for lawyers, teachers and nurses (they get it paid for by work), otherwise it is $218 per month

b. Rent - go online to the Burlington Free Press web site and find an apartment available for rent - enter the monthly rent amount

c. Car - you have the option of buying one of the following three cars, enter the monthly loan amount for the car chosen

i. 2008 BMW 5 Series $847 per month

ii. 2005 Honda Accord $341 per month

iii. 2000 Chevy Impala $120 per month

d. Auto insurance -$129 is the average monthly auto insurance rate in Vermont

e. Food:

i. A month of breakfasts costs about $38

ii. A month of lunches costs about $218

iii. A month of dinners costs about $240

iv. A month of snacks costs about $60

v. Put a formula in the spreadsheet adding these numbers up

f. Clothing - figure out an appropriate amount that this person would spend on clothes in a month

g. Entertainment - figure out an appropriate amount that this person would spend on entertainment in a month (this includes, movies, music, concerts, sporting events and anything else that they might do for fun)

h. Student loans

i. Taxi drivers and construction laborers have no student loans

ii. Lawyers pay about $1,110 per month for student loans

iii. Teachers pay about $444 per month for student loans

iv. Nurses pay about $333 per month for student loans

i. Compute your total expenses (the sum of all of the expense amounts, use the SUM formula)

j. Compute your net income, the amount you save at the end of each month (monthly salary after taxes minus total expenses)

6. Pie Chart

a. Create a 3-D pie chart that shows your monthly expenses

b. Include an appropriate chart title, a legend, and labels for what each section of the chart represents

7. Print

a. Print out your spreadsheet (make sure it fits on one page) and hand it in.