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.
इंटरैक्टिव व्यावहारिक अभ्यास
हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें
अभ्यास शुरू करें