Any ideas on what's wrong with my forecasting?

Copper Contributor

I've noticed that the forecast takes a dip in 2024 instead of rising steadily. Any ideas why? My formula is =FORECAST.LINEAR(R6,B7:Q7,B6:Q6)

 

Year20082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033
Sq Ft LOGS1599015990165901659016590165901659016590165901659016590165901659021660226202294020683.2521210.312521751.8093722388.1726623054.5815223742.6382924441.0947125135.3492825806.8901326432.68245
% Change 0.00%3.75%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%30.56%4.43%1.41%-9.84%2.55%2.55%2.93%2.98%2.98%2.94%2.84%2.67%2.42%
**bleep** % Change 0.00%3.75%3.75%3.75%3.75%3.75%3.75%3.75%3.75%3.75%3.75%3.75%34.31%38.75%40.16%30.32%32.87%35.42%38.35%41.33%44.31%47.25%50.09%52.76%55.19%
1 Reply
Hard to say. The table you posted, where is the top-left cell located on the sheet? And it looks as if the table does not show the actual forecast numbers?