iN EXCEL (SHOW FUNCTION)

Jessica and Jim are thinking of saving money for a child born today (age is 0) for its education at a 4-year college. Payments will begin in exactly 18 years and will be made in four installments on the childs 18th, 19th, 20th, and 21st birthdays at the beginning of the 1st, 2nd, 3rd, and 4th years of undergraduate studies. It is estimated that the cost of the childs education will be $80,000 per year. Assume the interest rate to be 5%.

Use the timeline method to solve this

What is the total amount needed to be saved to meet the cost at 18 years? .