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+Hand fill in row14for the reference. - In
J14, use=C+Gand fill in row14for the reference. - In
K14, addI14andJ14. - Copy these cells through row
28to complete your model.
