If John needs 1.6 million to retire in 15 years, what lump sum would he need to invest today? What if he retired in 30 years? He expects 6.5 % each year. Please show which functions you used to solve. The answer should be in excel with columns for the different pieces of the equation.