Assume you are 28 years old with two major financial goals: Sending your newborn child to college 18 years from now. Assume you are planning to cover 5 years of undergraduate studies. Retiring at age 65 maintaining your current lifestyle. Your data includes: Income of $90,000 You save 15% of your income for retirement and your average federal tax rate is 18% (this does not include social security and Medicare taxes). Life Expectancy of 95 Inflation is expected to average 2.75% per year. . . Tuition inflation is expected to average 5.5% per year. 1. Using the long-term portfolio you created in the Week 3 assignment, make sure to note the expected return for that portfolio. w 0.03 2.71% +0.12*9.01% +0.10*2.72% +.05*2.02% +.20*1.61% + .05*19.23% +.10*6.63 % +.05*1.93 % +.10*4.75% = 4.05% 2. Using this portfolio/expected return, how much will you need to save every month from now until your child starts college 18 years from now? a. As part of this, do some research on two programs/schools. Complete the calculations based on two different programs. Include the details on the two programs. a. University Of Florida the cost of this is $11,500 per year this includes room and board, books, and meal plan. b. University Of North Florida cost $12,784 per year and this also includes room and board, books, and meal plan. Next with information how much do you need to save each month to be retired by 65. You will need to figure out your WRR and how much you need by retirement date

Assume you are 28 years old with two major financial goals: - Sending your newborn child to college 18 years from now. Assume you are planning to cover 5 years of undergraduate studies. - Retiring at age 65 maintaining your current lifestyle. Your data includes: - Income of $90,000 - You save 15% of your income for retirement and your average federal tax rate is 18% (this does not include social security and Medicare taxes). - Life Expectancy of 95 - Inflation is expected to average 2.75% per year. - Tuition inflation is expected to average 5.5% per year. 1. Using the long-term portfolio you created in the Week 3 assignment, make sure to note the expected return for that portfolio. 0.032.71%+0.129.01%+0.102.72%+.052.02%+.201.61%+.0519.23%+.106.63%+.051.93%+.104.75%=4.05% 2. Using this portfolio/expected return, how much will you need to save every month from now until your child starts college 18 years from now? a. As part of this, do some research on two programs/schools. Complete the calculations based on two different programs. Include the details on the two programs. a. University Of Florida the cost of this is $11,500 per year this includes room and board, books, and meal plan. b. University Of North Florida cost $12,784 per year and this also includes room and board, books, and meal plan. Next with information how much do you need to save each month to be retired by 65 . You will need to figure out your WRR and how much you need by retirement date