Excel: How to forecast 12 months' figures but force a 10% growth?

R

Ralph

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!
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top