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
Instrucciones del ejercicio
- Copy the formula in
B9
into the cellsB9:G16
to complete the table. - Insert a line graph by clicking on cell
A18
, then highlighingA7: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
