12 month recurring income formula

**JCBlake** · 11-06-2014, 08:41 PM

I am having a hard time including a formula that will show a customer of mine the 12 revenue increase due to my services.

Not sure how to compute this in a spreadsheet and am looking for some insight.

A new customer pays $150 per month
It looks like we can bring them about 4.2 new customers a month.
Average term for a customer is 18 months
I understand the lifetime value but am getting hung up on actual revenue for 1 year and how to show this.

Thank you!

JC

**Olly** · 11-07-2014, 05:47 AM

Something like this:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Payment per customer per month:	$150
2	No new customers per month:	4.2
3
4	Month	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18
5	Additional Customers	4.2	8.4	12.6	16.8	21	25.2	29.4	33.6	37.8	42	46.2	50.4	54.6	58.8	63	67.2	71.4	75.6
6	Additional Revenue (Month)	$630	$1,260	$1,890	$2,520	$3,150	$3,780	$4,410	$5,040	$5,670	$6,300	$6,930	$7,560	$8,190	$8,820	$9,450	$10,080	$10,710	$11,340
7	Additional Revenue (To Date)	$630	$1,890	$3,780	$6,300	$9,450	$13,230	$17,640	$22,680	$28,350	$34,650	$41,580	$49,140	$57,330	$66,150	$75,600	$85,680	$96,390	$107,730