Forecasting given target for Year+1 and Year+2

[Brounoh]

Good evening,

I need some help as I cannot find anything relevant on Google or the forum.

Here is my situation:

January 1st 2019, I'll open a new business; I plan on

• signing 5,000 users the 1st month (A2=5,000)
• have accumulated 500,000 users by end of December 2019 (L2=500,000)
• reach 3,000,000 accumulated users by end of December 2020 (X2=3,000,000)

[TABLE="width: 600"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]P[/TD]
[TD="align: center"]Q[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]U[/TD]
[TD="align: center"]V[/TD]
[TD="align: center"]W[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: right"]Jan-19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]Dec-19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]Dec-20[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]5,000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]500,000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3,000,000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]5,000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]500,000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3,000,000[/TD]
[/TR]
</tbody>[/TABLE]

I would like to get a non-linear forecast for B:K , and then for M:W . Some sort of exponential growth that gives me the values for B:K , and then for M:W .

I tried the following:

• filled in B2:K2 with a simple linear forecast =(L2-A2) / counta(A1:L1) added to each month
• in array B3:K3 use =GROWTH(A2:L2,A1:L1)
• then do that again for section L:X

Row 3 is ultimately what I want to use, however I am not satisfied by the result I am getting with GROWTH().

Anyone has a suggestion please?

 

[James006]

Hello,

You could insert a chart and then, in the layout, pick any type of trendline ... in order to get the equation you are looking for ...

The exponential equation I just got is : y = 5E-168 ^e0.0091 x with R² = 0.9262 ...

Hope this will help