use excel

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 created | 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% 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