Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions

Question

Find the capacity of this system

Answered: 1 week ago