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 and that the cost of tuition increases about 8% per year. You ran the numbers and determined that four years of undergraduate will cost $307,398 by the time your niece turns 18 years old. 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? 5 points

Use formulas and show all calculations in an Excel file.