Calculate monthly revenue target

[MatthewC83]

I'm trying to calculate monthly revenue targets, and am struggling to get the right formula.

I need to track a projected annual increase in revenue from £2 million to £4.3 million, and what the monthly target would be based on a consistent monthly increase. I've tried using compound interest, but that doesn't seem to match what I actually need.

I'm taking a start point of £166,667 per month (based on £2m per annum), so just need the formula that will let me calculate where that should be each month to reach the goal.

Thanks in advance.

[Pete_UK]

I think your start point should be higher - if you want to go from £2m to £4.3m then the average monthly increase will be (4.3 - 2)/12, which gives £191,667. If you put that in A2 and include column N for May (as you are starting in June), then the total for the year using your existing formula will be £4,379,499.41

Hope this helps.

Pete

[JohnTopley]

The compound interest calculation is

=$A$2*(1+$B$2)^(COLUMNS($A:A)-1)

see attached

[josephteh]

Cell B2=((A2+4300000)/A2)^(1/12)-1
Cell C2=A2*(1+$B2)-A2
Cell D2=C2*(1+$B2)