Optimal Capital Efficiency.xlsx

	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	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB
1
2	Starting ARR	$1,000,000		$109,985,893	0.1	0.2	0.3	0.4	0.5	0.6	0.7	0.8	0.9	1	1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	2	Capital Efficiency
3	Growth Rate	10%		5x	$1,448,729	$7,803,027	$17,073,983	$27,168,195	$35,490,084	$43,043,579	$49,299,164	$54,548,202	$59,272,375	$63,572,276	$67,530,636	$71,215,608	$74,189,243	$76,114,077	$79,185,075	$80,281,159	$81,893,013	$82,780,336	$84,189,971	$84,902,342
4	Gross Margin	75%		6x	$2,555,489	$12,290,824	$25,208,361	$38,388,415	$48,766,460	$57,724,085	$64,988,368	$70,981,796	$76,293,403	$81,065,499	$85,409,982	$89,415,805	$92,625,244	$94,692,858	$97,965,938	$99,126,216	$100,806,735	$101,737,030	$103,198,794	$103,941,972
5	Investment	$5,000,000		7x	$4,078,562	$17,802,928	$34,571,430	$50,769,861	$63,053,696	$73,250,216	$81,382,404	$88,003,502	$93,801,630	$98,958,876	$103,614,164	$107,875,272	$111,270,641	$113,450,139	$116,880,032	$118,089,779	$119,822,610	$120,785,702	$122,286,892	$123,053,434
6	Pre Money Valuation	$25,000,000		8x	$6,052,815	$24,280,624	$44,994,074	$64,089,749	$78,122,997	$89,412,967	$98,295,844	$105,451,180	$111,657,606	$117,134,245	$122,044,638	$126,513,404	$130,058,969	$132,328,413	$135,883,433	$137,132,445	$138,906,446	$139,895,380	$141,427,428	$142,212,290
7	Capital Efficiency	0.5		9x	$8,501,673	$31,656,406	$56,329,920	$78,175,661	$93,808,095	$106,066,047	$115,602,533	$123,216,962	$129,770,284	$135,515,694	$140,639,004	$145,279,851	$148,949,191	$151,292,477	$154,949,614	$156,230,536	$158,037,778	$159,047,594	$160,604,447	$161,404,058
8	Gross Profit Multiple	10x		10x	$11,439,125	$39,860,683	$68,454,423	$92,893,288	$109,985,893	$123,104,345	$133,213,855	$141,226,417	$148,077,762	$154,052,269	$159,355,850	$164,141,545	$167,914,603	$170,319,572	$174,061,606	$175,368,969	$177,203,608	$178,230,647	$179,807,873	$180,619,611
9				11x	$14,871,582	$48,825,551	$81,262,348	$108,137,037	$126,563,596	$140,450,550	$151,065,825	$159,426,578	$166,536,517	$172,708,510	$178,166,620	$183,075,878	$186,937,082	$189,394,338	$193,208,050	$194,537,676	$196,395,284	$197,436,770	$199,031,028	$199,852,912
10				12x	$18,799,488	$58,486,792	$94,664,929	$123,823,048	$143,470,081	$158,046,609	$169,111,134	$177,778,751	$185,115,070	$191,458,987	$197,050,988	$202,066,868	$206,003,893	$208,506,027	$212,381,058	$213,729,684	$215,606,825	$216,660,602	$218,269,308	$219,099,807
11				13x	$23,218,678	$68,784,801	$108,587,200	$139,884,043	$160,649,990	$175,848,123	$187,314,069	$196,254,023	$203,790,097	$210,284,991	$215,994,095	$221,102,900	$225,105,829	$227,646,898	$231,574,976	$232,940,008	$234,833,963	$235,898,323	$237,519,441	$238,357,344
12				14x	$28,121,493	$79,664,906	$122,965,670	$156,265,516	$178,059,641	$193,820,574	$205,647,175	$214,830,362	$222,543,949	$229,172,454	$234,984,826	$240,175,332	$244,236,066	$246,811,232	$250,785,651	$252,164,989	$254,073,570	$255,147,138	$256,779,034	$257,623,369
13				15x	$33,497,678	$91,077,324	$137,746,373	$172,922,895	$195,664,125	$211,936,739	$224,089,010	$233,490,689	$241,363,032	$248,110,596	$254,014,705	$259,277,595	$263,389,441	$265,994,711	$270,009,959	$271,401,885	$273,323,303	$274,404,956	$276,046,297	$276,896,273
14				Gross Profit Multiple
15																																							0	3	6	9	12	15	18	21	24	27	30	33
16
17
18
19		Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Model	Q1 2023	Q2 2023	Q3 2023	Q4 2023	Q1 2024	Q2 2024	Q3 2024	Q4 2024	Q1 2025	Q2 2025	Q3 2025	Q4 2025
20	ARR	$1,100,000	$1,210,000	$1,331,000	$1,464,100	$1,610,510	$1,771,561	$1,948,717	$2,143,589	$2,357,948	$2,593,742	$2,853,117	$3,138,428	$3,452,271	$3,797,498	$4,177,248	$4,594,973	$5,054,470	$5,559,917	$6,115,909	$6,727,500	$7,400,250	$8,140,275	$8,954,302	$9,849,733	$10,834,706	$11,918,177	$13,109,994	$14,420,994	$15,863,093	$17,449,402	$19,194,342	$21,113,777	$23,225,154	$25,547,670	$28,102,437	$30,912,681	ARR	$1,331,000	$1,771,561	$2,357,948	$3,138,428	$4,177,248	$5,559,917	$7,400,250	$9,849,733	$13,109,994	$17,449,402	$23,225,154	$30,912,681
21	Burn	$150,000	$165,000	$181,500	$199,650	$219,615	$241,577	$265,734	$292,308	$321,538	$353,692	$389,061	$427,968	$470,764	$517,841	$569,625	$626,587	$689,246	$758,171	$833,988	$917,386	$1,009,125	$1,110,037	$1,221,041	$1,343,145	$1,477,460	$1,625,206	$1,787,726	$1,966,499	$2,163,149	$2,379,464	$2,617,410	$2,879,151	$3,167,067	$3,483,773	$3,832,150	$4,215,366	Burn	$496,500	$660,842	$879,580	$1,170,721	$1,558,230	$2,074,004	$2,760,499	$3,674,224	$4,890,392	$6,509,112	$8,663,628	$11,531,289
22	Cash Balance	$4,850,000	$4,685,000	$4,503,500	$4,303,850	$4,084,235	$3,842,659	$3,576,924	$3,284,617	$2,963,078	$2,609,386	$2,220,325	$1,792,357	$1,321,593	$803,752	$234,128	$10,886,111	$10,196,865	$9,438,694	$8,604,706	$7,687,320	$6,678,195	$5,568,158	$4,347,116	$3,003,971	$1,526,511	$29,155,011	$27,367,285	$25,400,786	$23,237,637	$20,858,173	$18,240,762	$15,361,611	$12,194,544	$8,710,771	$4,878,621	$663,255	Cash Balance	$4,503,500	$3,842,659	$2,963,078	$1,792,357	$234,128	$9,438,694	$6,678,195	$3,003,971	$27,367,285	$20,858,173	$12,194,544	$663,255
23	Money Raised		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$11,278,570	$0	$0	$0	$0	$0	$0	$0	$0	$0	$29,253,706	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	Money Raised	$0	$0	$0	$0	$0	$11,278,570	$0	$0	$29,253,706	$0	$0	$0
24	Founder Ownership	83%	83%	83%	83%	83%	83%	83%	83%	83%	83%	83%	83%	83%	83%	83%	63%	63%	63%	63%	63%	63%	63%	63%	63%	63%	47%	47%	47%	47%	47%	47%	47%	47%	47%	47%	47%	Founder Ownership	83%	83%	83%	83%	83%	63%	63%	63%	47%	47%	47%	47%
25	Founder Equity Value	$10,916,667	$11,466,667	$12,071,667	$12,737,167	$13,469,217	$14,274,472	$15,160,252	$16,134,611	$17,206,405	$18,385,379	$19,682,250	$21,108,809	$22,678,023	$24,404,158	$26,302,908	$28,472,174	$30,203,157	$32,107,238	$34,201,728	$36,505,666	$39,039,998	$41,827,764	$44,894,305	$48,267,502	$51,978,017	$56,074,864	$59,457,533	$63,178,468	$67,271,498	$71,773,830	$76,726,395	$82,174,217	$88,166,821	$94,758,686	$102,009,737	$109,985,893	Founder Equity Value	$12,071,667	$14,274,472	$17,206,405	$21,108,809	$26,302,908	$32,107,238	$39,039,998	$48,267,502	$59,457,533	$71,773,830	$88,166,821	$109,985,893
26
27						0.2	0.3	0.4	0.5	0.6	0.7	0.8	0.9	1	1.1	1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	2
28					5x	439%	119%	59%	31%	21%	15%	11%	9%	7%	6%	5%	4%	3%	4%	1%	2%	1%	2%	1%
29					6x	381%	105%	52%	27%	18%	13%	9%	7%	6%	5%	5%	4%	2%	3%	1%	2%	1%	1%	1%
30					7x	337%	94%	47%	24%	16%	11%	8%	7%	5%	5%	4%	3%	2%	3%	1%	1%	1%	1%	1%
31					8x	301%	85%	42%	22%	14%	10%	7%	6%	5%	4%	4%	3%	2%	3%	1%	1%	1%	1%	1%
32					9x	272%	78%	39%	20%	13%	9%	7%	5%	4%	4%	3%	3%	2%	2%	1%	1%	1%	1%	0%
33					10x	248%	72%	36%	18%	12%	8%	6%	5%	4%	3%	3%	2%	1%	2%	1%	1%	1%	1%	0%
34					11x	228%	66%	33%	17%	11%	8%	6%	4%	4%	3%	3%	2%	1%	2%	1%	1%	1%	1%	0%
35					12x	211%	62%	31%	16%	10%	7%	5%	4%	3%	3%	3%	2%	1%	2%	1%	1%	0%	1%	0%
36					13x	196%	58%	29%	15%	9%	7%	5%	4%	3%	3%	2%	2%	1%	2%	1%	1%	0%	1%	0%
37					14x	183%	54%	27%	14%	9%	6%	4%	4%	3%	3%	2%	2%	1%	2%	1%	1%	0%	1%	0%
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