ComenzarEmpieza gratis

Update yearly values

This example includes a completed retirement model. However, this model is not dynamic - the data includes numbers that were calculated from the input values, but are not formulas that would update automatically.

You will work on updating the numbers included to be formulas so the model can be used for new input data. Be sure to expand the cells in row 13 to see all the text.

Este ejercicio forma parte del curso

Financial Modeling in Google Sheets

Ver curso

Instrucciones del ejercicio

  • In B14, enter a formula to display the first year initial balance that is present in B8.
  • In B15, add the Fixed Income Holding Year Beginning (column C), Stock Holding Year Beginning (column E), and Annual Withdrawal (column F) in row 15.
  • Copy that formula to the rest of the years in column B.

Ejercicio interactivo práctico

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

Empezar ejercicio