Excel MOM Growth Rate Formula

[acool]

Hi Everyone,

I am currently trying to create a formula that helps me to calculate the necessary MOM Growth Rate from Month Two Onward (871), which will get me to the necessary expected sales of 13,132 for the year. I believe that MOM Growth Rate from Month 2 Onward is around 3.4% but I have not been to create a formula that gets me to an exact figure. Any help would be greatly appreciated! Thank You!

 

[JGordon11]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Total		MOMGR
2	1743	871	900.63	931.27	962.96	995.72	1029.59	1064.62	1100.84	1138.29	1177.02	1217.06	13132.00		3.402%
3
Sheet1

Cell Formulas
Range	Formula
C2:L2	C2	=B2*(1+$O$2)
M2	M2	=SUM(A2:L2)
O2	O2	=RATE(COLUMNS(B2:L2),-B2,0,13132-A2)

 

[acool]

@JGordon11 How did you know what they MOM Growth Rate was? Is that just an assumption?