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.

[jbs]

Thanks you so much, a huge help !!
Waiting for task 4 and 5
Love you man

[dristichauhan]

When will the next part will be uploaded ?

[snehakhandale]

Thankyou buddy!! made a lot of sense watching this.

[ooqogns]

Thanks for the video! Looking forward to your task 4 (i.e. cash flow forecast) update:)) I found it a bit tricky because I could not find the information about its cash flow assumptions (e.g. the opening cash and debt)

[prenticezhang]

Thanks mate for doing these videos, it do helps a :)

[rushilshah]

One small suggestion, also explain what you are doing on the screen verbally.

[ananya_unplugged]

Lovely video! when are you going to post task 3?

[HARSHWAYNE-cn]

Can you please make video on citi investment banking Forage

[cjk]

At 1:20 how did you fill in the rest of the row?