# Thread: Forecast Value for FY07 (XLS 2003 SP2)

1. ## Forecast Value for FY07 (XLS 2003 SP2)

Hello you all,

I can't seem to get this to work, and perhaps the function FORECAST is not the correct function to use in this case?

I have values for FY04, FY05, FY06. I want to forecast, based on those values what I could expect for FY07. In the very simplest scenario the values are 7, 6, 5. for their respective years.

I've set my spreadsheet as below, but can't get anything to work . Any suggestions? I was hoping for a simple solution??

Thanks so much,
Rich

2. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

If we presume a linear extrapolation:
=FORECAST(D1,A2:C2,A1:C1)
will yield 4

Steve

3. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

Use this formula:
<code>
=FORECAST(D1,A2:C2,A1:C1)
</code>
<img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> Were the replies to <post:=647,146>post 647,146</post:>, <post:=644,676>post 644,676</post:>, <post:=643,251>post 643,251</post:>, and <post:=641,811>post 641,811</post:> useful?

4. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

Hi Steve,

Yes, I've tried that, but what if it isn't linear? For example: What if 2004 = 10?

Cheers,
Rich

5. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

You'd have to specify a model - Excel cannot guess that. Excel has FORECAST for linear trends and GROWTH for exponential trends. For other types of extrapolation, you'd have to create a table with intermediate values according to the model.

6. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

Hi Hans,

Thanks.

Can you give me an example for my scenario?

Cheers,
Rich

7. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

What model do you want to use?

Personally, with only 3 points I would not stray too much from linear or exponential...

Steve

8. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

Hi Steve,

Okay, I'll call it.... exponential...

:-)

Cheers,
Rich

9. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

Then you can use:
=GROWTH(A2:C2,A1:C1,D1)

Steve

10. ## Re: Forecast Value for FY07 (XLS 2003 SP2)

Hi everyone,

I wanted thank all of you, your responses have helped us very greatly, and I really appreciate your help.

Cheers,
Rich

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•