| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Year | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2040 | 2050 | ||||
2 | Added amenities | kitchen v1 | co-working v1, workshop v1, sauna, treehouse | food forest, market garden | biopool, lakes | makerspace, restaurant, coworking v2, rewilding zone, mushroom farm | |||||||||||
3 | Notes | 1400sqm approved co-living development plans | co-living phase 1, land acquisition | co-living phase 2, 7ha orchard | co-living phase 3, co-housing phase 1 | co-housing part 2 | |||||||||||
4 | |||||||||||||||||
5 | Funding streams | Bank loans | €712,500.00 | ||||||||||||||
6 | Bank loans (cum.) | €0.00 | €0.00 | €0.00 | €712,500.00 | €682,812.50 | €654,361.98 | €627,096.90 | €600,967.86 | €575,927.53 | €215,972.82 | €80,989.81 | |||||
7 | Private loans | ||||||||||||||||
8 | Private loans (cum.) | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | |||||||
9 | |||||||||||||||||
10 | Converted equity | 50,000.00 | 60,137.73 | 0.00 | |||||||||||||
11 | |||||||||||||||||
12 | |||||||||||||||||
13 | Member loans | €193,508.96 | €14,494.33 | €40,373.38 | €350,000.00 | €300,000.00 | -€248,376.67 | -€350,000.00 | -€300,000.00 | ||||||||
14 | Member loans (cum.) | €193,508.96 | €208,003.29 | €248,376.67 | €598,376.67 | €898,376.67 | €650,000.00 | €650,000.00 | €300,000.00 | €0.00 | €0.00 | €0.00 | €0.00 | ||||
15 | |||||||||||||||||
16 | |||||||||||||||||
17 | Capital | €243,508.96 | €74,632.06 | €40,373.38 | €350,000.00 | €1,012,500.00 | -€248,376.67 | €0.00 | -€350,000.00 | -€300,000.00 | €0.00 | €0.00 | €0.00 | ||||
18 | Cumulated | €243,508.96 | €318,141.02 | €358,514.40 | €708,514.40 | €1,721,014.40 | €1,472,637.73 | €1,472,637.73 | €1,122,637.73 | €822,637.73 | €822,637.73 | €822,637.73 | €822,637.73 | ||||
19 | |||||||||||||||||
20 | Operating income | Stays | €1,062.00 | €28,943.18 | €27,143.31 | €42,935.47 | €52,827.66 | €433,307.17 | €399,988.30 | €389,545.18 | €379,312.50 | €375,287.92 | €375,287.92 | €375,287.92 | |||
21 | Events | €9,585.00 | €18,733.19 | €4,551.63 | €4,006.00 | ||||||||||||
22 | Donations | €300.00 | €434.74 | €2,110.90 | €270.00 | ||||||||||||
23 | Food | €0.00 | €0.00 | €0.00 | €15,283.59 | €10,000.00 | €100,000.00 | €150,000.00 | €150,000.00 | €180,000.00 | €210,000.00 | €230,000.00 | €280,000.00 | ||||
24 | |||||||||||||||||
25 | |||||||||||||||||
26 | |||||||||||||||||
27 | |||||||||||||||||
28 | |||||||||||||||||
29 | |||||||||||||||||
30 | |||||||||||||||||
31 | |||||||||||||||||
32 | Operating income | €10,947.00 | €48,111.11 | €33,805.84 | €62,495.06 | €62,827.66 | €533,307.17 | €549,988.30 | €539,545.18 | €559,312.50 | €585,287.92 | €605,287.92 | €655,287.92 | ||||
33 | Cumulated | €10,947.00 | €59,058.11 | €92,863.95 | €155,359.01 | €218,186.67 | €751,493.84 | €1,301,482.14 | €1,841,027.32 | €2,400,339.82 | €2,985,627.74 | €3,590,915.66 | €4,246,203.59 | ||||
34 | |||||||||||||||||
35 | Grants & special income | Grants | €10,000.00 | €7,500.00 | €15,000.00 | ||||||||||||
36 | Sale of co-housing units | €0.00 | €0.00 | €60,000.00 | €240,000.00 | €300,000.00 | €0.00 | €0.00 | €0.00 | €0.00 | |||||||
37 | Token pre-sales | €118,058.68 | €27,287.76 | €2,331.50 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | ||||||
38 | Token sales | €0.00 | €0.00 | €93,608.23 | €32,000.00 | €125,000.00 | €250,000.00 | €250,000.00 | €250,000.00 | €250,000.00 | €100,000.00 | €0.00 | |||||
39 | €0.00 | ||||||||||||||||
40 | |||||||||||||||||
41 | |||||||||||||||||
42 | |||||||||||||||||
43 | |||||||||||||||||
44 | |||||||||||||||||
45 | |||||||||||||||||
46 | |||||||||||||||||
47 | Grants, housing sales, token sales | €118,058.68 | €27,287.76 | €105,939.73 | €39,500.00 | €140,000.00 | €310,000.00 | €490,000.00 | €550,000.00 | €250,000.00 | €100,000.00 | €0.00 | €0.00 | ||||
48 | Cumulated | €118,058.68 | €145,346.44 | €251,286.17 | €290,786.17 | €430,786.17 | €740,786.17 | €1,230,786.17 | €1,780,786.17 | €2,030,786.17 | €2,130,786.17 | €2,130,786.17 | €2,130,786.17 | ||||
49 | |||||||||||||||||
50 | Stays breakdown | Silos | €0.00 | €14,195.32 | €53,241.52 | €49,147.55 | €47,864.38 | €46,607.06 | €46,112.55 | €46,112.55 | €46,112.55 | ||||||
51 | Private suite | €0.00 | €0.00 | €212,966.09 | €196,590.20 | €191,457.51 | €186,428.25 | €184,450.22 | €184,450.22 | €184,450.22 | |||||||
52 | Studios | €0.00 | €0.00 | €94,651.59 | €87,373.42 | €85,092.23 | €82,857.00 | €81,977.87 | €81,977.87 | €81,977.87 | |||||||
53 | House Loft | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | |||||||
54 | House Room | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | |||||||
55 | Van parking | €9,907.32 | €9,463.55 | €17,747.17 | €16,382.52 | €15,954.79 | €15,535.69 | €15,370.85 | €15,370.85 | €15,370.85 | |||||||
56 | Small Glamping | €4,885.85 | €4,667.01 | €8,752.13 | €8,079.14 | €7,868.20 | €7,661.52 | €7,580.23 | €7,580.23 | €7,580.23 | |||||||
57 | Glamping Shared (per bed) | €10,993.17 | €10,500.76 | €19,692.28 | €18,178.06 | €17,703.46 | €17,238.42 | €17,055.51 | €17,055.51 | €17,055.51 | |||||||
58 | Glamping Private | €9,771.71 | €9,334.01 | €17,504.25 | €16,158.28 | €15,736.41 | €15,323.04 | €15,160.46 | €15,160.46 | €15,160.46 | |||||||
59 | Camping | €4,885.85 | €4,667.01 | €8,752.13 | €8,079.14 | €7,868.20 | €7,661.52 | €7,580.23 | €7,580.23 | €7,580.23 | |||||||
60 | |||||||||||||||||
61 | |||||||||||||||||
62 | Total | €0.00 | €0.00 | €0.00 | €40,443.91 | €52,827.66 | €433,307.17 | €399,988.30 | €389,545.18 | €379,312.50 | €375,287.92 | €375,287.92 | €375,287.92 | ||||
63 | Cumulated | €0.00 | €0.00 | €0.00 | €40,443.91 | €93,271.57 | €526,578.73 | €926,567.04 | €1,316,112.22 | €1,695,424.72 | €2,070,712.64 | €2,446,000.56 | €2,821,288.48 | ||||
64 | |||||||||||||||||
65 | Assets | Land owned (m2) | 6000 | 6000 | 6000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | |||
66 | Built area (finished) | 0 | 0 | 0 | 400 | 1400 | 1850 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | ||||
67 | Land leased | 50000 | 50000 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
68 | Trees planted (thousands) | 1 | 2 | 3 | 5 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | ||||
69 | Glamping | 5 | 8 | 9 | 9 | 9 | 9 | 9 | 14 | 14 | 14 | 14 | 14 | ||||
70 | Suites | 0 | 0 | 0 | 0 | 0 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | ||||
71 | Studios | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
72 | Camping | 6 | 6 | 6 | 6 | 6 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | ||||
73 | Van parking | 3 | 3 | 3 | 4 | 4 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | ||||
74 | Tiny-houses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
75 | Houses | 0 | 0 | 1 | 1 | 1 | 2 | 6 | 11 | 11 | 11 | 11 | 11 | ||||
76 | Guest capacity | 15 | 24 | 30 | 44 | 44 | 85 | 97 | 127 | 127 | 127 | 127 | 127 | ||||
77 | |||||||||||||||||
78 | Tokenomics & Occupancy | Token supply | 6,486.60 | 7,004.53 | 7,878.23 | 8,206.38 | 9,096.93 | 10,354.86 | 11,090.40 | 11,807.76 | 12,510.67 | 12,787.13 | 12,787.13 | 12,787.13 | |||
79 | Token price | 259.65 € | 275.05 € | 297.26 € | 304.47 € | 321.37 € | 339.89 € | 348.50 € | 355.66 € | 361.72 € | 363.87 € | 363.87 € | 363.87 € | ||||
80 | Tokens from expenses | 701.5986647 | 160.0216981 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
81 | Tokens sales | 0 | 0 | 403.698923 | 107.6506324 | 410.5548141 | 777.9280053 | 735.5326588 | 717.3661452 | 702.9106646 | 276.4588743 | 0 | 0 | ||||
82 | Sweat reserve | 5,600.00 | 5,242.09 | 4,782.09 | 4,561.59 | 4,081.59 | 3,601.59 | 3,601.59 | 3,601.59 | 3,601.59 | 3,601.59 | 3,601.59 | 3,601.59 | ||||
83 | Unused supply | 77.57% | 75.78% | 72.76% | 71.63% | 68.55% | 64.20% | 61.66% | 59.18% | 56.75% | 55.79% | 55.79% | 55.79% | ||||
84 | Guest occupancy | 34.47% | 32.92% | 61.74% | 56.99% | 55.51% | 54.05% | 53.48% | 53.48% | 53.48% | |||||||
85 | Token holders occupancy | 5.11% | 9.44% | 15.04% | 23% | 24% | 26% | 27% | 27% | 27% | |||||||
86 | Total occupancy | ||||||||||||||||
87 | Meals served | 26.4 | 26.4 | 51 | 58.2 | 76.2 | 76.2 | 76.2 | 76.2 | 76.2 | |||||||
88 | Subscriptions | ||||||||||||||||
89 | Wanderer subscriptions | 0 | 0 | 55 | 50 | 60 | 72 | 86 | 103 | 124 | 149 | 179 | 215 | ||||
90 | Pioneer nights | 0 | 0 | 10 | 20 | 24 | 29 | 35 | 42 | 50 | 60 | 72 | 86 | ||||
91 | |||||||||||||||||
92 | Operation costs | Land team | €0.00 | -€2,400.00 | -€28,800.00 | -€43,632.00 | -€44,286.48 | -€44,950.78 | -€45,625.04 | -€52,468.79 | -€60,339.11 | ||||||
93 | Hospitality team | €0.00 | -€7,200.00 | -€57,600.00 | -€72,864.00 | -€73,956.96 | -€75,066.31 | -€76,192.31 | -€87,621.16 | -€100,764.33 | |||||||
94 | Restaurant team | €0.00 | -€10,800.00 | -€60,000.00 | -€60,000.00 | -€65,000.00 | -€65,000.00 | -€65,975.00 | -€75,871.25 | -€87,251.94 | |||||||
95 | Regular operating costs | -€65,658.00 | -€66,642.87 | -€67,642.51 | -€68,657.15 | -€69,687.01 | -€70,732.31 | -€71,793.30 | -€82,562.29 | -€94,946.64 | |||||||
96 | Digital creation team | €0.00 | €0.00 | -€20,000.00 | -€30,000.00 | -€36,000.00 | -€36,000.00 | -€36,540.00 | -€42,021.00 | -€48,324.15 | |||||||
97 | Reported costs (actual) | -365,017.48 | -136,613.04 | -167,325.93 | -63,555.13 | -222,422.44 | |||||||||||
98 | |||||||||||||||||
99 | |||||||||||||||||
100 |