Offset Inverse Problem

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
1
2	Assumptions
3
4	Initial Price	25
5	COGS	20
6	Delivery	5							\
7	CAC	Need to Calculate
8	Subscrition value (Month)	12		Montly Inflation	0.25%
9	Average LifeTime (Months)	12		STDEV	12
10	# Products purchased every year	2.5
11	Marketing Expense	Equals the consumer price of the first 2 purchases, exc. subscription
12	# of buyers - first month	500
13	% of buyers getting subscription	50.0%
14	Growth (Monthly)	7.5%
15
16
17	Normal Dist. of LifeTime	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
18		0.021841	0.023493	0.025095	0.026621	0.028044	0.029339	0.030481	0.031449	0.032222	0.032787	0.033130	0.033245	0.033130	0.032787	0.032222	0.031449	0.030481	0.029339	0.028044	0.026621	0.025095	0.023493	0.021841	0.020164	0.018488	0.016833	0.015221	0.013668	0.012188	0.010793	0.009492	0.008290	0.007190	0.006193	0.005297	0.004499	0.003795	0.003179	0.002645	0.002185	0.001793	0.001461	0.001182	0.000950	0.000758	0.000601	0.000473	0.000369	0.000287	0.000221	0.000169	0.000129	0.000097	0.000073	0.000054	0.000040	0.000029	0.000021	0.000016	0.000011
19	Cumulatve	0.021841	0.045333	0.070428	0.097049	0.125093	0.154431	0.184912	0.216361	0.248583	0.281370	0.314500	0.347745	0.380875	0.413662	0.445884	0.477333	0.507814	0.537153	0.565196	0.591817	0.616912	0.640405	0.662245	0.682409	0.700897	0.717730	0.732951	0.746619	0.758806	0.769599	0.779091	0.787381	0.794571	0.800764	0.806060	0.810560	0.814355	0.817534	0.820179	0.822364	0.824157	0.825618	0.826800	0.827749	0.828507	0.829108	0.829580	0.829950	0.830236	0.830457	0.830626	0.830755	0.830852	0.830925	0.830979	0.831019	0.831048	0.831070	0.831085	0.831096
20	Remaining	0.978159	0.954667	0.929572	0.902951	0.874907	0.845569	0.815088	0.783639	0.751417	0.718630	0.685500	0.652255	0.619125	0.586338	0.554116	0.522667	0.492186	0.462847	0.434804	0.408183	0.383088	0.359595	0.337755	0.317591	0.299103	0.282270	0.267049	0.253381	0.241194	0.230401	0.220909	0.212619	0.205429	0.199236	0.193940	0.189440	0.185645	0.182466	0.179821	0.177636	0.175843	0.174382	0.173200	0.172251	0.171493	0.170892	0.170420	0.170050	0.169764	0.169543	0.169374	0.169245	0.169148	0.169075	0.169021	0.168981	0.168952	0.168930	0.168915	0.168904
21
22	Model
23		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
24	# buyers	500	538	578	621	668	718	772	830	892	959	1,031	1,108	1,191	1,280	1,376	1,479	1,590	1,709	1,837	1,975	2,123	2,282	2,453	2,637	2,835	3,048	3,277	3,523	3,787	4,071	4,376	4,704	5,057	5,436	5,844	6,282	6,753	7,259	7,803	8,388	9,017	9,693	10,420	11,202	12,042	12,945	13,916	14,960	16,082	17,288	18,585	19,979	21,477	23,088	24,820	26,682	28,683	30,834	33,147	35,633
25	Subscribers	250	269	289	311	334	359	386	415	446	480	516	554	596	640	688	740	795	855	919	988	1062	1141	1227	1319	1418	1524	1639	1762	1894	2036	2188	2352	2529	2718	2922	3141	3377	3630	3902	4194	4509	4847	5210	5601	6021	6473	6958	7480	8041	8644	9293	9990	10739	11544	12410	13341	14342	15417	16574	17817
26	Cumulative Users ever subscribed	250	519	808	1119	1453	1812	2198	2613	3059	3539	4055	4609	5205	5845	6533	7273	8068	8923	9842	10830	11892	13033	14260	15579	16997	18521	20160	21922	23816	25852	28040	30392	32921	35639	38561	41702	45079	48709	52611	56805	61314	66161	71371	76972	82993	89466	96424	103904	111945	120589	129882	139872	150611	162155	174565	187906	202248	217665	234239	252056
27	Offset		244.5398468	501.3451974	769.9914895	1050.809337	1343.0284	1646.587527	1961.211329	2286.4215	2621.553313	2966.495704	3320.213716	3681.562894	4050.561322	4425.817793	4807.049527	5193.823322	5585.111398	5980.845996	6380.430487	6783.715205	7190.554797	7600.853229	8015.278441	8434.180483	8858.308469	9288.487535	9726.180798	10172.63894	10629.45968	11098.55511	11581.90315	12081.98268	12601.51281	13143.03755	13709.72926	14304.76161	14931.68509	15594.0356	16295.6961	17040.69971	17833.57485	18678.80488	19581.17803	20545.95339	21578.51129	22684.69682	23870.47693	25142.45359	26507.52371	27973.05176	29547.04178	31237.80133	33054.28369	35006.09083	37103.64547	39358.02502	41781.13345	44385.53492	47185.13189
28
29
30	I want to sumproduct and offset vs. the "ramaining" row, except, instead of the width going forward, I want it to go backwards
31	The formula I have in there (d27) is pretty much the formula I need , except it's going forward, when I want it to go backwards
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100