Tuesday, February 06, 2007

The budgets are coming along nicely.

Today you are going to compare your salary with what the government says is the average salary.

First, click here.

Find Miami. Do you make more than the average or less than the average in 2005? Put this in your Excel worksheet below your total salary.

You will be graded for the following:

  1. Calculating your salary correctly and finding the average salary for Miami.
  2. Including links for automobiles or bus passes, furniture, housing, communication, and gas (MPG).
  3. Color coding your worksheet and applying the proper formatting. If the numbers are hard to read and in a sloppy fashion I will take off points from this grade.
  4. Dividing everything correctly (pay for the larger purchases over the proper amount of time - autos 36 months and furniture and TVs 12 months) and summing everything up correctly.
This is a four grade assignment. Due at the end of class.

Save your Excel worksheet as "MyBudget.xls".

No comments: