Budget+Assignment


 * ** Excel Budget Assignment **

// Objective: Use Excel to manage your money. //

You are living on your own in an apartment. You own a car and you are paying your own bills. Use the information below to create a budget for your first year of financial independence:
 * rent is **$700 a month**
 * utilities are **$100 a month** from January through May and October through December. From June through September, **utilities are $175 a month**. Why is it more in the summer?
 * you spend **$4800 a year on food**. You can divide this into 12 equal payments.
 * you will spend **$800 a year on travel.** You can take one trip or spend the money on less expensive trips. How can you input this into your budget?
 * school tuition is due January 1 and August 1-each tuition payment is **$2,928.95 per semester.** YES, multiply the tuition x2 before finding your monthly budget amount.
 * your car is paid off (it's a 65 Dodge Dart that your grandfather gave you).
 * You **pay $1600 a year** for insurance that is divided into twelve monthly payments. ||

Directions:
 * 1) Create an EXCEL worksheet that shows your expenses by month. Title the worksheet "Expenses". Type your name next to the title. Save as: last name_expenses

2) Use the months (January through December) as your column headings and rent, utilities, food, travel, tuition and car insurance as row headings.

3) Total each row and total each column. Add up all of your expenses. Use a formula.

4) Create a graph that shows monthly expenses for: rent, utilities, food, car insurance, tuition and travel by month. Use "Monthly Expenses" as the chart title in 14-point font. Include your name in the title.

6) Create a pie chart as a new sheet that shows total expenses for category. HINT: select only the data that you need by using the CTRL key and the mouse click. Title the pie graph "Overall Expenses" and include your name in the title.

7) Save as LAST NAME_ BUDGET.

8) Share with Mrs. Saxton using Google Drive. ||