Formula to predict missing values in a range

[agreaves]

Hi,

I am hoping there is a simple answer to my question.

I have different locations (rows), with known values in specific months, and a value in the first month of my range.

I am wondering if there is an excel formula that would predict the values up until the "known" months and then predict future months.

It is easy to understand by looking at the attachment. Any help is greatly appreciated.

Thanks.