Question
Research the average monthly cost of food (groceries, eating out, etc.) in your chosen city. r If you did not do a mortgage in Section
Research the average monthly cost of food (groceries, eating out, etc.) in your chosen city. r If you did not do a mortgage in Section 3, you will need to research your housing costs (rent, utilities, etc.). Mathematics Section 4 8 r Research average monthly cost of the additional expenses: phone bill, insurance, and entertainment, utilities, and other. CALCULATIONS r Enter all of your information into the Excel Monthly Budget table. Put the names of the expenses (such as "Car Loan Payment") in left column and the actual dollar amount of the expenses in the right column. Be sure that all of your budget expenses are calculated as monthly expenses. r Once you have entered all of the necessary expenses, check to see that you have some money left over (at least $100)! You might have an unexpected car repair or perhaps just need an occasional Starbucks to keep you going. r If you do not have at least $100 left over, you will need to revisit previous sections and make some adjustments. You might need a less expensive mortgage or take longer to pay off your student loans. Or perhaps you will need to wait a little longer to retire. r Once your budget is finalized, you will then copy and paste your table neatly into your paper (see the "Formatting Tips Document" if you need a reminder how to do this). DISCUSSION GUIDANCE FOR YOUR PAPER r Introduce Section 4 and tell us what we can expect to find in this section of your paper. r Introduce your Excel Monthly Budget Table. Address where each budget line amount comes from. For example, you might say something like: "As shown in Table 4, my monthly expense for Federal Taxes was calculated in Section 1 of this paper. See Table 1 for details... (more stuff here) ...After some research, I found that the average single person living in Bozeman, MT spends about $547 per month on food (livingcost.org), etc." r Discuss your budget. Did you easily have enough money for everything or was your budget tight? Did you have to make any adjustments to make your budget work (buy a cheaper home, extend your length of loan, reduce the amount you're saving, change your retirement age)? r Any formulas used and your mathematical thinking must be included in your paper. Please include an introduction and con conclusion, there definitely needs to be some budget cuts, how might that be done? and consider my employer will match 5% of retirement. the figure below is straight out of pocket.
Monthly Budget Information | ||
Enter Gross Annual Salary: | $52,650.00 | |
Gross Monthly Salary: | $4,387.50 | |
Monthly Expenses | ||
Retirement | $2,857.90 | |
Student Loans | $155.14 | |
Groceries | $300.00 | |
Miscellaneous | $200.00 | |
Rent | $1,000.00 | |
Phone | $81.00 | |
Vehicle Insurance | $58.04 | |
Medical Insurance | $43.08 | |
Utilities | $308.00 | |
Gas | $160.00 | |
Federal Taxes Monthly | $369.67 | |
Entertainment | $49.00 | |
Kid | $200.00 | |
Life Insurance | $15.83 | |
Net Monthly Income after expenses: | -$1,410.16 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started