17. Yearly Budget

Directions: A balanced budget means that you cannot spend more money than you make. In this assignment create an annual budget spreadsheet using Microsoft Excel that charts how much money you spend, how much money you give, and how much money you make.

  1. Create a new folder called math.
  2. Create an index.html math home page.
  3. Create an budget.xlsx that includes formulas to determine your annual budget.
  4. Save the budget.xlsx in the math folder.
  5. Link the budget.xlsxassignment to your math homepage.
  6. Create columns that include the Date, Item, Income, and Expense.
  7. Include at least 10 "REAL" yearly entries of money you make, spend, and give.
  8. Create a Total and Grand Total for the income and expense columns and make them bold.
  9. The grand total represents money you have saved. If it is a negative number then it means debt :(
  10. Include 3 formulas, example: =sum(c3:c10) and =c12-d12-e12.
  11. The document includes bold titles at the top of each column and for the totals.
  12. All cells containing numbers use a currency format.