Model logic
Base case first; upside scenarios second.
Financing row
EUR 1m target round
Instrument modelled as SAFE / German-law SAFE-like only once counsel confirms; preferred equity fallback remains visible.
Evidence discipline
No fabricated actuals
Revenue, CAC, churn, gross margin, runway, and cap table stay bracketed until source inputs arrive.
| section | worksheet | driver_or_output | base_case_treatment | open_item_bracket | notes |
|---|---|---|---|---|---|
| setup | 00_Read_Me | model version and caveats | Internal investor-prep framework only | [version/date/owner] | External release blocked until actuals and current cap table are confirmed. |
| setup | 01_Assumptions_Master | scenario selector | Base case excludes grants and subsidies | [base/upside/downside definitions] | Public support only in separate scenario. |
| revenue | 02_Revenue_Membership | membership tiers and pricing | Core Business Model 2.0 revenue engine | [tiers/prices/member count/churn] | Needs final founder inputs. |
| revenue | 03_Revenue_MSB | MSB ticket/sponsor revenue | Base-case operating module | [actuals by event/sponsor pipeline] | Needs historical and forward assumptions. |
| revenue | 04_Revenue_Media_Intelligence | newsletter/briefing/intelligence revenue | Base-case candidate / new module | [products/prices/subscribers/renewal] | Absent from old workbook; supported by current synthesis. |
| revenue | 05_Revenue_Historical_Project | historical packages / project revenue | Bridge only unless confirmed | [actuals and continuation decision] | Do not make growth engine unless founder confirms. |
| scenario | 06_Public_Support_Scenario | grants/subsidies/public support | Scenario-only and excluded from base | [official docs/eligibility/specialist review] | No base-case reliance. |
| cost | 07_Cost_Base | operating cost base | Lean platform + content/community operations | [current payroll/suppliers/platform costs] | Needs current expense bridge. |
| cost | 08_Platform_Build | digital platform/database/member infrastructure | Use-of-funds line | [build scope/budget/timing] | Tie to financing need. |
| forecast | 09_PnL_Forecast | revenue/cost forecast | Base/downside/upside structure | [actuals and assumptions] | Monthly forecast preferred. |
| cash | 10_Cash_Runway | cash runway and funding need | Pre-seed funding bridge | [opening cash/burn/runway target] | Needs current bank/cash position. |
| cap_table | 11_Cap_Table_Pre_Money | founder-owned GmbH pre-CLA | EUR 25k founder 100pct assumption | [current shareholder register] | Internal assumption only. |
| cap_table | 12_CLA_Lakestar | Lakestar CLA conversion bridge | EUR 600k CLA evidence; 3409 conversion shares bridge | [current CLA status/permitted wording] | Documented evidence but external wording gated. |
| financing | 13_Round_Model | EUR 1m round size / valuation / instrument | Target EUR 1000000 pre-seed; SAFE or German-law SAFE-like structure subject to counsel confirmation; preferred equity fallback | [SAFE eligibility / valuation cap or equity terms / minimum ticket] | Connect to term sheet and German counsel precedent review. |
| outputs | 14_Investor_Outputs | key charts and metrics | Deck-ready charts after inputs | [ARR/revenue/gross margin/burn/runway] | No fabricated actuals. |
| checks | 15_Data_Checks | gate and evidence checks | Flag missing/estimated/proof-pending inputs | [source link per assumption] | Use to prevent overclaiming. |