Question

15 years from now, your 2-year old son will be attending Harvard.  You have determined he will need $85,000 per year for tuition and living expenses.  In 15 years, you will give him a lump sum payment for the entire amount he will need, assuming that he will be able to invest the money not yet needed at 4.5% interest.  You have found an investment opportunity that will yield an annual return of 6.5% on your monthly payments.  How much will you have to invest each month to give your son the money he needs for his education (assume his first year at Harvard is Year 0, and his final year is Year 3)? Please use excel formulas and show work! Thanks.

Answer 1