Madi revenue forecast

Month 1 is your actual sheet. Foundation renews monthly, Agency is a single fee, and Agency Plus runs a fixed term.

Foundation · 100

$97 then $20/mo

Agency · 4

$1,297 one-time

Agency Plus · 2

$1,970/mo x 4 months

Month 1

$18,828

Foundation

Entry $Then $/mo

Monthly churn6.0%

Self-serve at this price typically runs 3-7%. Margin-adjusted lifetime value $258

New signups, month over month12.0%

Members upgrading to Agency each month1.5%

About 59 upgrades in month 24

Agency

$M1

$1,297 charged once, in the month the client signs. Non-recurring.

New sales, month over month12.0%

A one-time fee has no churn. Every month starts from zero and depends entirely on new sales.

Agency Plus

$M1

Term (mo)$1,970 per month x 4 = $7,880 per client, then the engagement ends. No renewals.

Completed builds continuing into Plus25.0%

About 21.1 Plus engagements starting in month 24, each worth $4,728 on margin

Direct new sales, month over month5.0%

Cost of delivery

Model and API spend, hosting, fulfilment, and the Team Madison hours on agency work. Not sales, not overhead.

Foundation40.0%

Agency40.0%

Agency Plus40.0%

Blended margin at month 24: 60.0%

Operating costs, per monthTeam, tools, and overhead. Gross profit minus this is net profit — $219,114 in month 24.

Acquisition slowdown per month5.0%

How fast the growth rate itself cools. Set to zero for pure compounding, which no channel sustains for three years.

Collected in month 12

$160,812

$96,487 gross profit

Gross profit, month 24

$219,114

$365,190 in, $146,076 cost

Net profit, month 24

$219,114

$219,114 gross less $0 operating costs; $2,562,645 cumulative

Gross profit through month 24

$2,562,645

on $4,271,076 collected

Contracted share, month 24

61.2%

$223,377 from Foundation subscriptions and Plus terms already sold; $93,809 is one-time Agency fees

Month	Foundation	Agency	Plus	Foundation $	Agency $	Plus $	Collected	Cost	Gross profit	Net profit	Margin
1	100	4	2	$9,700	$5,188	$3,940	$18,828	($7,531)	$11,297	$11,297	60.0%
2	205	6	5	$12,716	$7,639	$10,047	$30,402	($12,161)	$18,241	$18,241	60.0%
3	314	8	9	$15,891	$10,214	$17,281	$43,387	($17,355)	$26,032	$26,032	60.0%
4	429	10	13	$19,232	$12,920	$25,689	$57,840	($23,136)	$34,704	$34,704	60.0%
5	550	12	16	$22,741	$15,761	$31,378	$69,880	($27,952)	$41,928	$41,928	60.0%
6	677	14	18	$26,422	$18,742	$36,172	$81,336	($32,534)	$48,801	$48,801	60.0%
7	809	17	21	$30,276	$21,865	$41,160	$93,300	($37,320)	$55,980	$55,980	60.0%
8	949	19	24	$34,301	$25,131	$46,348	$105,780	($42,312)	$63,468	$63,468	60.0%
9	1,094	22	26	$38,495	$28,541	$51,740	$118,776	($47,510)	$71,266	$71,266	60.0%
10	1,246	25	29	$42,856	$32,093	$57,337	$132,286	($52,914)	$79,372	$79,372	60.0%
11	1,404	28	32	$47,378	$35,785	$63,139	$146,302	($58,521)	$87,781	$87,781	60.0%
12	1,569	31	35	$52,055	$39,613	$69,145	$160,812	($64,325)	$96,487	$96,487	60.0%
13	1,739	34	38	$56,880	$43,573	$75,350	$175,803	($70,321)	$105,482	$105,482	60.0%
14	1,916	37	41	$61,845	$47,659	$81,749	$191,254	($76,501)	$114,752	$114,752	60.0%
15	2,098	40	45	$66,942	$51,866	$88,336	$207,143	($82,857)	$124,286	$124,286	60.0%
16	2,286	43	48	$72,160	$56,186	$95,102	$223,448	($89,379)	$134,069	$134,069	60.0%
17	2,479	47	52	$77,489	$60,611	$102,039	$240,139	($96,056)	$144,084	$144,084	60.0%
18	2,677	50	55	$82,920	$65,134	$109,135	$257,189	($102,876)	$154,313	$154,313	60.0%
19	2,879	54	59	$88,441	$69,745	$116,380	$274,565	($109,826)	$164,739	$164,739	60.0%
20	3,086	57	63	$94,040	$74,436	$123,761	$292,237	($116,895)	$175,342	$175,342	60.0%
21	3,296	61	67	$99,706	$79,197	$131,266	$310,169	($124,068)	$186,102	$186,102	60.0%
22	3,509	65	70	$105,429	$84,019	$138,880	$328,329	($131,332)	$196,997	$196,997	60.0%
23	3,726	69	74	$111,196	$88,893	$146,591	$346,680	($138,672)	$208,008	$208,008	60.0%
24	3,945	72	78	$116,996	$93,809	$154,385	$365,190	($146,076)	$219,114	$219,114	60.0%

This is a cash view: every figure is money collected in that month. Foundation charges $97 at signup and $20 every month after, so it is the only tier with churn. Agency is $1,297 once, in the month the client signs, so it starts from zero each month. Agency Plus bills $1,970 a month for 4 months and then ends, with no renewals. Cost of delivery starts at 40% everywhere, which is almost certainly wrong in both directions. Net profit is gross profit minus the flat monthly operating costs you set above; it is the only figure here that can go negative.