Results 1 to 2 of 2

Math Help - forecast of savings balance

  1. #1
    Newbie
    Joined
    Jul 2009
    Posts
    2

    forecast of savings balance

    Hi,

    I have a spreadsheet showing the balance of my savings account. See the graph of my balance as the blue line, the "projected" average progress as the yellow line and the goal line as the path I'd have to keep up with to reach my target amount by my target date.

    My question is how can I better calculate my projected or forecast line so that it's more of an average rather than being so dependent on my monthly cycle of pay & expenditure.

    Edit: I should add that the forecast in the graph is simply the straight line connecting the start point and the latest balance.

    Also the height at which the lines hit the right hand edge shows me the final balance on my target date. So even if the forecast was calculated differently, it would still be helpful to see how high the forecast will be on the target date.

    Thanks.
    Attached Thumbnails Attached Thumbnails forecast of savings balance-forecast-graph.jpg  
    Last edited by 7times9; July 20th 2009 at 11:35 AM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Jul 2009
    Posts
    2
    No suggestions? Maybe I'm doing it the best way already?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Adaptive Expectations Forecast
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: October 17th 2010, 11:30 AM
  2. Hypothesis test for forecast
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: June 2nd 2010, 05:13 PM
  3. Sales forecast help (percentages)
    Posted in the Statistics Forum
    Replies: 1
    Last Post: February 24th 2010, 11:53 AM
  4. best forecast
    Posted in the Statistics Forum
    Replies: 1
    Last Post: January 24th 2010, 09:59 PM
  5. forecast and fine
    Posted in the Statistics Forum
    Replies: 0
    Last Post: January 24th 2010, 01:47 PM

Search Tags


/mathhelpforum @mathhelpforum