Question

Assignment 1
Create a monthly budget using Excel. Each of the rows should represent days in the month: 1st, 2nd, 3rd, etc. with the last row titled “Total.” Each of the columns should represent areas in which you spend money: groceries, restaurants, utilities, entertainment, school/work, car, shopping, misc., etc. At the bottom of each column on the Total row, use a SUM formula to add all of the rows for the whole month so that you can track your spending in each of the categories. If you haven’t tracked your spending this month and can’t look up transactions through your credit or debit card, then estimate your expenses. Then use a SUM formula to find the grand total spent all month. Format your spreadsheet in the following way:
• Title of spreadsheet in bold 14-pt. font • Column headings in bold • Cells of spreadsheet in 12-pt. font • Totals in bold
One recommended budgeting guideline is that you follow the 50/20/30 rule, which says that your expenses should be 50% essentials (housing, groceries, utilities), 20% financial priorities (paying down debt, savings), and 30% discretionary expenses (or- dering food, entertainment). Though following this rule can be impractical for a person just starting out, especially a college student whose only goal is to minimize expenses, compare your monthly expenses to the 50/20/30 rule. Write a paragraph that states how close or far you are from following the rule, whether you want to change your money habits, and how you plan to do it. To go with your paragraph, create at least one graph to illustrate your analysis. Write 1-2 sentences explaining why you chose to use the type of graph(s) that you did.

Answer 1