Growth Function

Growth function in Excel

The Growth function in Excel helps estimate or project growth of a business by using array functions and past performance data of a business.
GROWTH calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values.
In our example we have sales data in various months. Each month has a corresponding sales units and number of month values equals to the number of sales values. We now wish to predict the sales in the 17th and 18th months.
Watch the video below to see how this interesting function is implemented.
Note: The formula in the example below must be entered as an array formula. If the formula is not entered as an array formula, the single results are 32618.20377 and 320196.7184.

Watch the video:

Further reading:
MS Excel: GROWTH Function (WS)
Modeling exponential growth

Leave a Reply

Your email address will not be published. Required fields are marked *