You have decided that you are going to fund the undergraduate (4-year) college tuition for your newborn niece.You conducted research into the average cost of annual college tuition and found it to be $20,770/year.Your research also suggests that the cost of tuition increases 8% per year.Assume that your niece will enter college at age 18 and the you can invest at an average annual interest rate of 10%.

How much money do you need to invest today in order to be able to pay for the 4 years of college when your niece turns 18 years old?

Use formulas and show all calculations in an Excel file.