| 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 | €26,219.64 | €246,420.90 | €219,739.49 | €210,125.72 | €200,811.66 | €197,178.65 | €197,178.65 | €197,178.65 | |||
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 | €36,219.64 | €346,420.90 | €369,739.49 | €360,125.72 | €380,811.66 | €407,178.65 | €427,178.65 | €477,178.65 | ||||
33 | Cumulated | €10,947.00 | €59,058.11 | €92,863.95 | €155,359.01 | €191,578.65 | €537,999.54 | €907,739.03 | €1,267,864.75 | €1,648,676.42 | €2,055,855.07 | €2,483,033.72 | €2,960,212.38 | ||||
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 | €6,740.10 | €24,572.35 | €21,911.76 | €20,953.10 | €20,024.33 | €19,662.06 | €19,662.06 | €19,662.06 | ||||||
51 | Private suite | €0.00 | €0.00 | €136,376.54 | €121,610.26 | €116,289.72 | €111,135.05 | €109,124.44 | €109,124.44 | €109,124.44 | |||||||
52 | Studios | €0.00 | €0.00 | €49,963.78 | €44,553.91 | €42,604.64 | €40,716.15 | €39,979.52 | €39,979.52 | €39,979.52 | |||||||
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 | €2,689.40 | €2,527.54 | €4,607.32 | €4,108.45 | €3,928.71 | €3,754.56 | €3,686.64 | €3,686.64 | €3,686.64 | |||||||
56 | Small Glamping | €2,917.85 | €2,742.24 | €4,998.68 | €4,457.44 | €4,262.43 | €4,073.49 | €3,999.79 | €3,999.79 | €3,999.79 | |||||||
57 | Glamping Shared (per bed) | €6,366.22 | €5,983.06 | €10,906.21 | €9,725.33 | €9,299.84 | €8,887.61 | €8,726.82 | €8,726.82 | €8,726.82 | |||||||
58 | Glamping Private | €6,100.97 | €5,733.76 | €10,451.78 | €9,320.11 | €8,912.35 | €8,517.30 | €8,363.20 | €8,363.20 | €8,363.20 | |||||||
59 | Camping | €2,652.59 | €2,492.94 | €4,544.25 | €4,052.22 | €3,874.93 | €3,703.17 | €3,636.18 | €3,636.18 | €3,636.18 | |||||||
60 | |||||||||||||||||
61 | |||||||||||||||||
62 | Total | €0.00 | €0.00 | €0.00 | €20,727.04 | €26,219.64 | €246,420.90 | €219,739.49 | €210,125.72 | €200,811.66 | €197,178.65 | €197,178.65 | €197,178.65 | ||||
63 | Cumulated | €0.00 | €0.00 | €0.00 | €20,727.04 | €46,946.68 | €293,367.57 | €513,107.06 | €723,232.79 | €924,044.45 | €1,121,223.10 | €1,318,401.76 | €1,515,580.41 | ||||
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 | 4,742.60 | 5,241.76 | 6,115.46 | 6,465.19 | 7,427.85 | 8,780.80 | 9,572.49 | 10,332.34 | 11,068.49 | 11,355.63 | 11,355.63 | 11,355.63 | |||
79 | Token price | 200.70 € | 217.09 € | 247.61 € | 258.98 € | 286.39 € | 315.78 € | 329.02 € | 339.60 € | 348.26 € | 351.28 € | 351.28 € | 351.28 € | ||||
80 | Tokens from expenses | 701.5986647 | 141.2476747 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
81 | Tokens sales | 0 | 0 | 403.698923 | 129.2377288 | 482.6616293 | 872.947649 | 791.6926888 | 759.841276 | 736.1533529 | 287.141479 | 0 | 0 | ||||
82 | Sweat reserve | 3,856.00 | 3,498.09 | 3,038.09 | 2,817.59 | 2,337.59 | 1,857.59 | 1,857.59 | 1,857.59 | 1,857.59 | 1,857.59 | 1,857.59 | 1,857.59 | ||||
83 | Unused supply | 76.53% | 74.06% | 69.73% | 68.00% | 63.24% | 56.54% | 52.62% | 48.86% | 45.22% | 43.80% | 43.80% | 43.80% | ||||
84 | Guest occupancy | 33.76% | 31.73% | 57.84% | 51.57% | 49.32% | 47.13% | 46.28% | 46.28% | 46.28% | |||||||
85 | Token holders occupancy | 5.76% | 11.03% | 18.25% | 28% | 31% | 33% | 34% | 34% | 34% | |||||||
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 | -53,569.30 | -155,269.82 | |||||||||||
98 | |||||||||||||||||
99 | |||||||||||||||||
100 |