ComenzarEmpieza gratis

Calculate total year-end

To finalize your model, you should edit the year-end totals to include formulas for those columns.

Remember that year-end stock is: = Stock Holding Beginning + Stock Return

Fixed income holding is: = Fixed Income Beginning + Income After Tax

Total year-end balance is: = Year-End Stock + Year-End Fixed Income

Este ejercicio forma parte del curso

Financial Modeling in Google Sheets

Ver curso

Instrucciones del ejercicio

  • In I14, use =E+H and fill in row 14 for the reference.
  • In J14, use =C+G and fill in row 14 for the reference.
  • In K14, add I14 and J14.
  • Copy these cells through row 28 to complete your model.

Ejercicio interactivo práctico

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

Empezar ejercicio