Goldman Sachs Excel Skills | Task 2 Forecasting Assumptions

#excel #virtualinternship #finance
This video goes through my suggested solutions for the Goldman Sachs Excel Skills for Business Task 2.
*Key tips*
Grow at 10% first year, then growth rate decreases by 1% the following years:
Assuming we begin in A1...
(A1) * 1.1 = A2
A2/A1 - 1% = A3
We can drag the formula across in A3 to obtain a growth rate that decreases by 1% with each additional cell
Shortcut to fill a row (on Mac)
Highlight the desired row of cells
Press enter to type in a cell
To fill all the cells selected press control and enter simultaneously.
Music Credit: Where It's Always Warm by Vlad Gluschenko is licensed under a Creative Commons License.
creativecommon....
/ vgl9
Support by RFM - NCM: rb.gy/5vr7w