开始使用免费开始使用

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

本练习是课程的一部分

Google Sheets 金融建模

查看课程

练习说明

  • 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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习