budget assignement

In this project you will create a personal expense analysis for a three month period and then create a chart of your expense data. Take a look at a sample spreadsheet to get an idea of what you’ll be doing.

1.Start Excel and begin a new blank workbook.

  • Type Personal Expenses and your first and last name at the top.
  • Type in the current month as your first column heading, and use the fill handle to create a series so that three consecutive months display as column headings.
  • Type Total and Percent of Total to the right of the months as your last two column headings.

2.Enter Income as your first row heading.

  • Below Income, enter at least six row headings for your monthly expenses. Some of the items you might list include, but are not limited to: Rent, Utilities, Daycare, etc.
  • After you have entered all of the categories, type Balance and Expense Total as the last two row headings.

3.Enter the amounts that you anticipate spending in each category for the next three months.

4.Create formulas to show totals.

In the Total column, enter formulas to calculate category totals.

  • In Percent of Total column, enter a formula to calculate the percentage of the overall total that goes towards each expense (category). Hint: If you use an absolute cell reference for the first formula, you can use the fill handle to copy it to the other cells.
  • In the Balance row, enter a formula that calculates income minus total expenses for each month.
  • In the Expense Total row, enter a formula that calculates total expenses for all three months.

5.Format the worksheet by adjusting column width and wrapping text, applying appropriate financial number formatting, adding borders and fill colors, and adjusting the fonts and font sizes of the title and column headings.

6.Create a 2-D Pie chart that shows the percentage breakdown of your expenses by category.

  • Make sure your pie chart includes data labels.
  • Size and move the chart so that it displays centered below the worksheet data.
  • Choose an appropriate layout and design.

Save your file as an Excel Workbook (.xlsx)
Include the term Budget and your First Name when saving your file. Example: Budget_David.xlsx
Upload your completed document using the Browse button, and then click the Submit button.

Points Possible: 40

15 points for setting up formulas

10 points for creating headings.

5 points for entering data

5 points for formatting

5 points for pie chart