Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How to forecast 12 months' figures but force a 10% growth?
I had a year's worth of transactions figures, totalled for each month. It
only went up to May so I was able to use the forecast function to project ahead to June and July. However I now need to project ahead for a whole 'nother year, but assuming that our transactions will go up by 10% in total. I can't figure out how to project that way. I suppose I know what the total for the year has to be (e.g. 10% more than the previous year), but I don't know how to make Excel produce a projection that will chart a 10% growth over 12 months. Someone did suggest that it would involve multiplying by 1.1 (e.g. 110%) but I'm still lost! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How to forecast 12 months' figures but force a 10% growth?
Ralph,
For compound growth of 10% over twelve months, multiply each previous month's cell by 1.1^(1/12), using a formula like =A1*1.1^(1/12) and then copy down or across for the twelve months. HTH, Bernie MS Excel MVP "Ralph" wrote in message ... I had a year's worth of transactions figures, totalled for each month. It only went up to May so I was able to use the forecast function to project ahead to June and July. However I now need to project ahead for a whole 'nother year, but assuming that our transactions will go up by 10% in total. I can't figure out how to project that way. I suppose I know what the total for the year has to be (e.g. 10% more than the previous year), but I don't know how to make Excel produce a projection that will chart a 10% growth over 12 months. Someone did suggest that it would involve multiplying by 1.1 (e.g. 110%) but I'm still lost! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOw do I merge two separate months of sales figures? | Excel Worksheet Functions | |||
building YTD figures by adding to a previous months total | Excel Discussion (Misc queries) | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
how do I forecast a 15% increase over 7 months? | Excel Discussion (Misc queries) |