| A | 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Denomination | ||||||||||||||||||||||||||||||
2 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | Jun 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 | May 2024 | Jun 2024 | Jul 2024 | Aug 2024 | Sep 2024 | Oct 2024 | Nov 2024 | Dec 2024 | FY 2024 | Notes / Assumptions | ||||
3 | Prices | ||||||||||||||||||||||||||||||
4 | ETH MoM Growth Rate | % | 0.0% | 32.6% | 1.3% | 13.5% | 3.4% | -0.6% | 3.2% | -4.0% | 2.0% | 1.6% | 46.2% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2.0% | 2% MoM ETH Growth or 25% YoY Growth | |||
5 | ETH Price | USD | $1,196.61 | $1,586.54 | $1,606.63 | $1,824.02 | $1,885.39 | $1,874.69 | $1,934.05 | $1,856.16 | $1,645.64 | $1,671.16 | $2,442.54 | $2,491.39 | $2,541.22 | $2,592.04 | $2,643.88 | $2,696.76 | $2,750.70 | $2,805.71 | $2,861.82 | $2,919.06 | $2,977.44 | $3,036.99 | $3,097.73 | $3,159.69 | $3,222.88 | $3,222.88 | |||
6 | BOTTO Price | USD | $0.04 | $0.16 | $0.34 | $0.25 | $0.19 | $0.17 | $0.17 | $0.14 | $0.14 | $0.14 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | $0.20 | No change in BOTTO value | ||
7 | RARE Price | USD | $0.10 | $0.10 | $0.07 | $0.16 | $0.07 | $0.12 | $0.09 | $0.07 | $0.60 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | $0.06 | No change in RARE value | ||
8 | |||||||||||||||||||||||||||||||
9 | Sales | ||||||||||||||||||||||||||||||
10 | 1/1 Sales | ETH | 19.253 | 25.215 | 9.995 | 30.345 | 29.625 | 15.224 | 12.49925 | 36.347 | 19.938 | 22.268 | 12.512 | 19.798 | 20.560 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 24.094 | 289.130 | 6 month rolling avg (Apr - Sept '23) in FY23 & a slight increase of 10% above average in '24 | ||
11 | Secondary Sales | ETH | 0.000 | 0.000 | 4.000 | 4.080 | 0.000 | 0.760 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 0.982 | 11.784 | 2 to 4 secondary sales - 10% royalties (avg 40 ETH/sale) | ||
12 | Other Sales | ETH | 2.134 | 34.000 | 108.762 | 17.966 | 23.633 | 15.094 | 5.164 | 12.183 | 10.295 | 0.178 | 0.616 | 0.000 | 0.000 | 1.667 | 1.667 | 1.667 | 1.667 | 1.667 | 1.667 | 51.667 | 1.667 | 1.667 | 1.667 | 1.667 | 1.667 | 70.000 | Collab opportunities - 4x / year @ 5 ETH each & 1x big release (akin to Pipes) | ||
13 | |||||||||||||||||||||||||||||||
14 | Total Revenue | USD | 25,590.82 | 93,947.36 | 197,224.93 | 95,562.05 | 100,412.48 | 29,964.11 | 34,161.80 | 90,078.95 | 49,752.63 | 37,511.36 | 32,063.22 | 49,324.20 | 52,248.09 | 69,318.47 | 70,704.84 | 72,118.94 | 73,561.32 | 75,032.54 | 76,533.19 | 224,016.93 | 79,625.13 | 81,217.64 | 82,841.99 | 84,498.83 | 86,188.81 | 1,195,409.64 | |||
15 | |||||||||||||||||||||||||||||||
16 | Rewards | ||||||||||||||||||||||||||||||
17 | Active Rewards | % | 25% | 25% | 25% | 25% | 25% | 25% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | Assumes 50% continues to be paid out as active rewards | ||
18 | Active Rewards | ETH | 5.35 | 15.17 | 33.70 | 12.64 | 14.08 | 7.77 | 8.83 | 24.27 | 15.12 | 11.22 | 6.56 | 9.90 | 10.28 | 13.37 | 13.37 | 13.37 | 13.37 | 13.37 | 13.37 | 38.37 | 13.37 | 13.37 | 13.37 | 13.37 | 13.37 | 185.46 | |||
19 | Retroactive Rewards | % | 25% | 25% | 25% | 25% | 25% | 25% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |||
20 | Retroactive Rewards | ETH | 5.35 | 15.17 | 0.00 | 12.64 | 14.08 | 7.77 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
21 | Total Rewards Value | USD | 12,795.41 | 48,148.91 | 54,142.99 | 46,120.61 | 53,089.57 | 29,130.06 | 17,080.90 | 45,040.12 | 24,877.14 | 18,755.68 | 16,031.61 | 24,662.10 | 26,124.05 | 34,659.24 | 35,352.42 | 36,059.47 | 36,780.66 | 37,516.27 | 38,266.60 | 112,008.46 | 39,812.57 | 40,608.82 | 41,420.99 | 42,249.41 | 43,094.40 | 597,704.82 | |||
22 | |||||||||||||||||||||||||||||||
23 | Operational Costs (DAO) | ||||||||||||||||||||||||||||||
24 | Contributors | USD | 0.00 | 0.00 | 0.00 | 4,200.00 | 4,200.00 | 0.00 | 4,200.00 | 8,400.00 | 2,150.00 | 11,250.00 | 63,900.00 | 57,900.00 | 53,400.00 | 53,400.00 | 53,400.00 | 53,400.00 | 53,400.00 | 53,400.00 | 53,400.00 | 59,400.00 | 59,400.00 | 59,400.00 | 59,400.00 | 59,400.00 | 59,400.00 | 676,800.00 | 1 or 2 new hires in 2H '24 | ||
25 | Contributors | BOTTO | 0.00 | 0.00 | 0.00 | 6,541.51 | 1,500.00 | 8,657.32 | 21,897.75 | 55,886.35 | 7,500.00 | 5,000.00 | 81,000.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 53,500.00 | 642,000.00 | Will compensate most new contributors with BOTTO only (3-4 roles open) | ||
26 | Contributors | ETH | 0.00 | 0.00 | 0.00 | 4.00 | 4.00 | 4.00 | 4.00 | 4.00 | 4.00 | 4.00 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 2.50 | 30.00 | No new contributors will be compensated in ETH | ||
27 | DAO Proposal Costs | USD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | 60,000.00 | Budget for DAO proposal costs - fixed at $5,000/mo (use it or lose it) | ||
28 | DAO Community Initiatives | BOTTO | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 | 600,000.00 | 50,000 BOTTO in monthly initiatives | |||||||||||||
29 | |||||||||||||||||||||||||||||||
30 | Operational Costs | ||||||||||||||||||||||||||||||
31 | Cost Value | USD | 31,096.00 | 25,868.00 | 23,645.00 | 23,859.00 | 25,113.00 | 23,772.00 | 31,343.00 | 21,148.00 | 22,501.00 | 21,895.60 | 6,750.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 8,550.00 | 102,600.00 | Average Cost (Dec '22 - Sep '23) | ||
32 | Software & Hardware | USD | 9,696.20 | 8,660.30 | 6,492.10 | 8,493.70 | 7,349.70 | 5,508.20 | 5,146.70 | 4,937.00 | 4,353.30 | 4,459.60 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 6,750.00 | 81,000.00 | Average Cost (Dec '22 - Sep '23) = $6.75k | ||
33 | Marketing, Events, Travel | USD | 5,030.40 | 370.00 | 0.00 | 1,642.30 | 0.00 | 1,400.00 | 7,200.30 | 543.30 | 0.00 | 0.00 | 0.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 1,800.00 | 21,600.00 | Average Cost (Dec '22 - Sep '23) = $1.75k | ||
34 | General & Administrative | USD | 14,511.60 | 14,655.20 | 8,663.10 | 10,250.80 | 10,536.90 | 10,504.00 | 8,764.50 | 9,210.90 | 8,671.80 | 9,479.70 | 0.00 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 10,081.88 | 120,982.53 | Average Cost (Dec '22 - Sep '23) = $10.5k. Rebate Oct '23 - Oct '24 = 100% Rebate | ||
35 | Professional Services | USD | 1,857.60 | 2,182.80 | 8,490.30 | 5,114.10 | 7,226.70 | 4,959.90 | 10,231.30 | 6,456.60 | 9,475.80 | 7,956.30 | 0.00 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 6,899.31 | 82,791.73 | Average Cost (Dec '22 - Sep '23) = ~$6.5k. Rebate Oct '23 - Oct '24 = 100% Rebate | ||
36 | Rebate | USD | 0.00 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -16,981.19 | -203,774.27 | EY Rebate | ||||||||||||
37 | Translated Cost | BOTTO | 729,808.29 | 158,264.40 | 68,628.73 | 94,287.58 | 133,742.70 | 139,919.25 | 187,100.05 | 146,657.42 | 163,287.37 | 159,588.92 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Not applicable after Sep '23. | ||
38 | |||||||||||||||||||||||||||||||
39 | Total OpEx | USD | 31,096.00 | 25,868.00 | 23,645.00 | 35,355.08 | 36,854.56 | 31,270.76 | 43,279.20 | 36,972.64 | 31,233.56 | 39,830.24 | 76,756.35 | 77,678.48 | 73,303.05 | 73,430.11 | 73,559.71 | 73,691.90 | 73,826.74 | 73,964.28 | 74,104.56 | 80,247.65 | 80,393.61 | 80,542.48 | 80,694.33 | 80,849.21 | 81,007.20 | 936,086.39 | |||
40 | Income | USD | (18,300.59) | 19,930.45 | 119,436.94 | 14,086.36 | 10,468.35 | (30,436.71) | (26,198.30) | 8,066.18 | (6,358.07) | (21,074.56) | (60,724.74) | (53,016.38) | (47,179.00) | (38,770.87) | (38,207.29) | (37,632.44) | (37,046.08) | (36,448.01) | (35,837.97) | 31,760.81 | (40,581.04) | (39,933.66) | (39,273.33) | (38,599.80) | (37,912.80) | (338,381.57) | |||
41 | |||||||||||||||||||||||||||||||
42 | Burn & OTC | ||||||||||||||||||||||||||||||
43 | Burn | BOTTO | 100,242.32 | 193,981.01 | 134,909.13 | 160,042.28 | 257,366.21 | 172,919.65 | 112,889.96 | 290,817.87 | 180,530.77 | 178,188.80 | 51,999.17 | 121,011.29 | 128,184.72 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 178,188.80 | 2,138,265.60 | |||
44 | Burn (Value) | USD | $4,271.17 | $31,705.81 | $46,480.92 | $40,497.90 | $48,325.91 | $29,378.70 | $18,911.33 | $41,935.94 | $24,877.14 | $24,447.50 | $10,597.43 | $24,662.10 | $26,124.05 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $36,314.88 | $435,778.53 | |||
45 | OTC | BOTTO | 3,750,000.00 | ||||||||||||||||||||||||||||
46 | OTC (Value) | USD | $505,125.00 | ||||||||||||||||||||||||||||
47 | |||||||||||||||||||||||||||||||
48 | Treasury Balances | ||||||||||||||||||||||||||||||
49 | BOTTO | 29,673,558.40 | 30,278,576.90 | 30,184,974.22 | 26,870,828.61 | 26,664,011.09 | 26,431,885.43 | 26,285,097.72 | 26,608,004.35 | 26,342,658.61 | 26,169,764.95 | 22,286,765.78 | 22,062,254.49 | 21,830,569.77 | 21,548,880.97 | 21,267,192.17 | 20,985,503.37 | 20,703,814.57 | 20,422,125.77 | 20,140,436.97 | 19,858,748.17 | 19,577,059.37 | 19,295,370.57 | 19,013,681.77 | 18,731,992.97 | 18,450,304.17 | 18,450,304.17 | ||||
50 | %∆ BOTTO | 0.00% | 2.04% | -0.31% | -10.98% | -0.77% | -0.87% | -0.56% | 1.23% | -1.00% | -0.66% | -14.84% | -1.01% | -1.05% | -1.29% | -1.31% | -1.32% | -1.34% | -1.36% | -1.38% | -1.40% | -1.42% | -1.44% | -1.46% | -1.48% | -1.50% | -15.48% | ||||
51 | ETH | 164.09 | 246.18 | 375.37 | 342.54 | 351.55 | 363.23 | 331.54 | 346.90 | 331.44 | 327.53 | 350.99 | 358.39 | 366.17 | 377.04 | 387.91 | 398.78 | 386.08 | 373.08 | 360.56 | 371.44 | 357.81 | 344.66 | 331.99 | 319.77 | 308.01 | 308.01 | ||||
52 | %∆ ETH | 0.00% | 50.02% | 52.48% | -8.75% | 2.63% | 3.32% | -8.72% | 4.63% | -4.46% | -1.18% | 7.16% | 2.11% | 2.17% | 2.97% | 2.88% | 2.80% | -3.19% | -3.36% | -3.36% | 3.02% | -3.67% | -3.67% | -3.68% | -3.68% | -3.68% | -15.88% | ||||
53 | Minimum Monthly USDC Balance | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | |||||||||||||||
54 | USDC | 0 | 0 | 64.2 | 8,656.80 | 6,355.65 | 6,419.85 | 2,219.85 | 19,670.43 | 12,270.25 | 6,870.25 | 441,345.25 | 369,895.25 | 302,945.25 | 235,995.25 | 169,045.25 | 102,095.25 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | 100,000.00 | Maintain a balance of $100K at all times to cover 1.5 month of costs, swapping ETH | |||
55 | %∆ USDC | 0.00% | 0.00% | 0.00% | 13384.11% | -26.58% | 1.01% | -65.42% | 786.12% | -37.62% | -44.01% | 6324.00% | -16.19% | -18.10% | -22.10% | -28.37% | -39.60% | -2.05% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -66.99% | ||||
56 | RARE | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552.00 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | 396,552 | ||||
57 | UNI-V2 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 14,704.92 | 0.00% | ||||
58 | %∆ UNI-V2 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||||
59 | |||||||||||||||||||||||||||||||
60 | Translated Value (ETH & USDC) | USD | $196,357.15 | $390,573.98 | $603,147.12 | $633,454.75 | $669,156.10 | $687,363.50 | $643,443.39 | $663,565.32 | $557,700.07 | $554,224.16 | $1,298,648.70 | $1,262,778.40 | $1,233,457.06 | $1,213,296.42 | $1,194,635.16 | $1,177,514.52 | $1,161,976.82 | $1,146,768.35 | $1,131,865.75 | $1,184,263.88 | $1,165,368.12 | $1,146,741.82 | $1,128,403.32 | $1,110,371.58 | $1,092,666.22 | $1,092,666.22 | |||
61 | Translated Value (Total) | USD | $1,500,380.47 | $5,379,638.22 | $11,030,685.86 | $7,494,607.76 | $5,703,642.77 | $5,224,365.59 | $5,083,055.06 | $4,527,599.39 | $4,425,887.55 | $4,168,877.83 | $5,863,651.93 | $5,782,026.22 | $5,705,487.54 | $5,627,918.73 | $5,551,849.28 | $5,477,320.47 | $5,404,374.59 | $5,331,757.94 | $5,259,447.17 | $5,254,437.11 | $5,178,133.17 | $5,102,098.70 | $5,026,352.02 | $4,950,912.11 | $4,875,798.57 | $4,875,798.57 | |||
62 | |||||||||||||||||||||||||||||||
63 | Projected Gross Burn | USD | (31,096.00) | (25,868.00) | (23,645.00) | (35,355.08) | (36,854.56) | (31,270.76) | (43,279.20) | (36,972.64) | (31,233.56) | (39,830.24) | (76,756.35) | (77,678.48) | (73,303.05) | (73,430.11) | (73,559.71) | (73,691.90) | (73,826.74) | (73,964.28) | (74,104.56) | (80,247.65) | (80,393.61) | (80,542.48) | (80,694.33) | (80,849.21) | (81,007.20) | (936,086.39) | |||
64 | Projected Net Burn | USD | 12,712.36 | 16,479.04 | (6,358.07) | (21,074.56) | (60,724.74) | (53,016.38) | (47,179.00) | (38,770.87) | (38,207.29) | (37,632.44) | (37,046.08) | (36,448.01) | (35,837.97) | (29,920.11) | (40,581.04) | (39,933.66) | (39,273.33) | (38,599.80) | (37,912.80) | (338,381.57) | |||||||||
65 | |||||||||||||||||||||||||||||||
66 | Runway (using Gross Burn) | 15 months | 18 months | 18 months | 14 months | 17 months | 16 months | 17 months | 17 months | 16 months | 16 months | 16 months | 16 months | 15 months | 15 months | 14 months | 14 months | 14 months | 14 months | 13 months | 1.2 years | Recommendation - have at least 18-24 months of runway at any given time | |||||||||
67 | Runway (using Net Burn) | ∞ | ∞ | 88 months | 26 months | 21 months | 24 months | 26 months | 31 months | 31 months | 31 months | 31 months | 31 months | 32 months | 40 months | 29 months | 29 months | 29 months | 29 months | 29 months | 3.2 years | ||||||||||