When a young company is forecasting its potential growth, the revenue projections rarely follow a straight line. Most companies expect that as they begin to grow and become better known, they will begin to make new sales at a geometrically increasing rate. When running the numbers for such growth in an Excel spreadsheet, it is possible to model the independent variables of time and the rate of increase year over year so that the dependent variable of revenue follows an exponential curve.
Open a new Excel worksheet. Create headings of "Year" and "Revenue" for the first two columns.
Fill the first 10 cells of the "Year" column with the numbers 1 through 10.
Click on the cell B2. Enter an equation in the format of the exponential growth forumla: y = ae^(bx). This is expressed in Excel by the formula:
In this formula, "a" is the initial baseline value of the variable you are measuring and "b" is your rate of exponential growth.
Hit "Enter" when your formula is complete and Excel will calculate the result for the first year. Click and drag the bottom right handle of the cell A2 all the way down to A11 and Excel will calculate the results for the remaining nine cells. You now have a forecast of exponential growth.
- Photo Credit Jupiterimages/Goodshoot/Getty Images
How to Forecast Sales with Excel
Forecasting is more of a science than an art with advent of computer programs that have the ability to accurately predict future...
How Do I Use Excel's GROWTH Function?
Excel's Growth Function helps when you need to predict future values. Learn how to use this powerful function to calculate retirement savings...
How to Solve Problems With the Department of Finance
A department of finance is a city or state revenue department that collects taxes and administers funds for city and state governments....
A Tutorial on Exponential Forecasting and Smoothing in Excel
Exponential smoothing is a financial technique that uses moving averages to remove peaks and valleys from a set of financial data.