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
Instrucciones del ejercicio
- In
B14
, enter a formula to display the first year initial balance that is present inB8
. - In
B15
, add the Fixed Income Holding Year Beginning (columnC
), Stock Holding Year Beginning (columnE
), and Annual Withdrawal (columnF
) in row15
. - 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
