cribragoofalo New Member
Joined: 11 Nov 2007 Posts: 5 Location: Fiji
|
Posted: Wed Jun 18, 2008 12:40 pm Post subject: Forecast Icome |
|
|
If you want to Forecast out your income based on prior year month's income do the following:
Code: | B C D
year period (jan) income year period (feb) income
2001 1 $100.00 2001 1 $150.00
2002 2 $123.00 2002 2 $134.00
2003 3 $99.00 2003 3 $178.00
2004 4 $132.00 2004 4 $160.00
Forcast>> 2005 5 $131.50 2005 5 $174.00
Forcast>> 2006 6 $130.15 2006 6 $176.80
Forcast>> 2007 7 $127.81 2007 7 $172.72
Forcast>> 2008 8 $131.06 2008 8 $168.83
|
The cell formulas are as follows for the forcasted dollar amounts for the specific periods for Jan:
Code: | 5=FORECAST(5,D2:D5,C2:C5)
6=FORECAST(6,D3:D6,C3:C6)
7=FORECAST(7,D4:D7,C4:C7)
8=FORECAST(8,D5:D8,C5:C8) |
The first number 5 is askaing for the income for the 5th data point (2005 in this example), then 6 is asking for the 6th data point (2006) etc.
Think of a "trend" chart and each income value being plotted and we are forcasting the next point. |
|