I have a daughter just starting 9th grade and I want to save…

I have a daughter just starting 9th grade and I want to save money for her college education. How much money do I need to invest one time in a money market fund today at a 6% interest rate compounded annually to be able to have $20,000 in 5 years when she starts college?

Using excel or what ever method you would like except asking…

Using excel or what ever method you would like except asking some one else, 1.calculate the NPV, IRR, and MIRR for the following Data and answer below.2.Would you invest in this and why?   No TaxesInitial Investment = $245,000Terminal value = $3000Cashflows = $67,000 each year for 10 yearsDiscount rate = 8%Finance rate = 6%