Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Attached Images Attached Images

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #4
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #6
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forecast Value for FY07 (XLS 2003 SP2)

    Hi Hans,

    Thanks.

    Can you give me an example for my scenario?

    Cheers,
    Rich

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #8
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forecast Value for FY07 (XLS 2003 SP2)

    Hi Steve,

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

    :-)

    Cheers,
    Rich

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Forecast Value for FY07 (XLS 2003 SP2)

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

    which gives about 4.25

    Steve

  10. #10
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •