ComenzarEmpieza gratis

Finish and visualize

You should finish your retirement model by copying the formula you just created to the rest of the table for retirement savings. By using the partial and complete absolute references in the previous exercise, you can simply copy and paste them into all the cells.

Last, visualize the difference more years of savings makes on the monthly payment by including a chart.

Este ejercicio forma parte del curso

Financial Modeling in Google Sheets

Ver curso

Instrucciones del ejercicio

  • Copy the formula in B9 into the cells B9:G16 to complete the table.
  • Insert a line graph by clicking on cell A18, then highlighing A7:G16, clicking on insert, and then chart.
  • Be sure to change the chart to a line chart!

Ejercicio interactivo práctico

Pon en práctica la teoría con uno de nuestros ejercicios interactivos

Empezar ejercicio