Need assistance with a personal budget assignment... In the picture is the personal budget I have made for myself. Could someone assist with Part 2A and 2B? Thank you in advance!

Part 2 A: (must be completed in Excel) - Analysis:

Using the budget in part 1; Use as many time lines as you need forecast all your projected savings (investments) to get each investments future value. You will have to determine your PV, I/y, N, PMT then calc FV

If you dont have any idea on the I/y you could use 5 or 6% to be conservative. N depends on your current age and when you think you will retire. (I am 27 currently)

Savings

401k or (403B) whichever you use

IRAs.

Home Ect.

Once you add up all the future values from step 2 above, and do a time line to determine how much you will be able to spend each year assuming you are going to spend all your money. I.e. your future value will be 0. To calculate N, you have to make a lot of assumptions. For example, if you are planning on retiring at age 65 and think (hope) you will life until you are 90 (25 years) your N will be 25.

Part 2 B: (must be completed in Excel) - Scenario Analysis:

Run at least 3 different scenarios to see the impact of decisions. Some examples may include:

What happens if you delay start of Savings for 5 years?

What happens if you work 3 more years?

What if the interest rate is higher/lower?

What if you have more to save after student loans are paid off?

B C 2 3 Pay and Expenses Per one month Per one year 4 5 Gross Pay 3000 36000 6 Total est Deductions 7 Insurance (health, dental, vision) 50 500 8 403b Contributions 180 2160 9 Taxes 340 4080 10 Net Pay 2430 29160 11 12 Expenses 13 Rent 550 6600 14 Utility - electric 30 360 15 Utility - gas 30 360 16 Utility - water free with rent free with rent 17 Utility - trash free with rent free with rent 18 Internet 30 360 19 Phone 90 1080 20 Car insurance 170 2040 21 Car payment 205 2460 22 Avg spent on groceries 400 4800 23 Student loan payment 120 1440 24 Addition to personal savings 200 2400 25 26 Total expenses 1825 21900 27 28 Net pay - total expenses 605 left at end of month 7260 left at end of year B C 2 3 Pay and Expenses Per one month Per one year 4 5 Gross Pay 3000 36000 6 Total est Deductions 7 Insurance (health, dental, vision) 50 500 8 403b Contributions 180 2160 9 Taxes 340 4080 10 Net Pay 2430 29160 11 12 Expenses 13 Rent 550 6600 14 Utility - electric 30 360 15 Utility - gas 30 360 16 Utility - water free with rent free with rent 17 Utility - trash free with rent free with rent 18 Internet 30 360 19 Phone 90 1080 20 Car insurance 170 2040 21 Car payment 205 2460 22 Avg spent on groceries 400 4800 23 Student loan payment 120 1440 24 Addition to personal savings 200 2400 25 26 Total expenses 1825 21900 27 28 Net pay - total expenses 605 left at end of month 7260 left at end of year