This model includes a calculator to: predict future values along a linear trend based on existing values; predicts exponential growth using existing growth history.
This is a very simple yet powerful tool to predict your future sales or expenses. Just input historical data in cells formatted in blue font and the rest of the information is automatically calculated for you. The forecast is conveniently presented in graphs.
i. Forecast (linear regression)
– calculates future sales by using linear regression, a linear trend using historical sales.
ii. Forecast (exponential growth)
- calculates future exponential growth by using existing data.