{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Uitleg Keu referentiemodel","Keu referentiemodel","Export van referentiemodel","Resultaten branche","Resultaten grootte effect","Resultaten onroerend goed","Resultaten spreidingsdiagrammen","Resultaten gekozen Branche"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Uitleg Keu referentiemodel","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,1,18,12],[14,1,14,12],[16,1,16,12],[12,1,12,12],[5,1,5,12],[7,1,7,12],[10,1,10,12],[9,1,9,12]]}
[]
["Voor Nederlandse niet-beursgenoteerde ondernemingen"]
["Uitleg  Keu Referentiemodel"]
[]
[]
[null,"Dit rekenmodel is ontwikkeld om de onderzoeksresultaten eenvoudig toepasbaar te maken. Het volledige onderzoek is te downloaden via onderstaande link:"]
[]
[null,"ValuePro Papers: Rendementseis niet-beursgenoteerde ondernemingen - ValuePro"]
[]
[null,"Sla het document op als \"Excel-werkmap met macro's\", start het document opnieuw op en druk op \"Macro's inschakelen\"."]
[null,"Wanneer u aangeeft in welke branche de onderneming actief is, of er sprake is van exploitatiegebonden onroerend goed, en in welke range de ondernemingswaarde zich bevindt, berekent het rekenmodel het te hanteren 95%-betrouwbaarheidsinterval. \n\nHet rekenmodel hanteert de gemiddelde Keu van de geselecteerde branche. Indien deze branche niet significant afwijkt van de totale onderzoeksgroep, wordt de gemiddelde Keu van het deciel toegepast.\n\nVervolgens kan de Keu worden gecorrigeerd voor de aanwezigheid van exploitatiegebonden onroerend goed en/of voor een afwijkende ondernemingswaarde ten opzichte van de gemiddelde ondernemingswaarde binnen de branche. Het laatste is niet van toepassing als de gemiddelde Keu van het deciel wordt gehanteerd. Het toepassen van dergelijke correcties is een subjectieve beoordeling van de waardeerder.\n\nHet is vervolgens aan u als waardeerder om te bepalen of u dit interval hanteert en, zo ja, waar binnen dit interval de onderneming volgens u moet worden gepositioneerd. U kunt dit bepalen aan de hand van de small- en specific firm elementen. Hierbij dient u zich te realiseren dat de weging en percentages van het BDO-model niet toegepast kunnen worden."]
[]
[null,"Gebruik de invulvelden om de vragen te beantwoorden. Alle vragen dienen beantwoord te worden voordat er een resultaat getoond kan worden."]
[]
[null,"Let op: het stapelen van verschillende onderzoeksresultaten leidt tot lagere statistische betrouwbaarheid."]
[]
[null,"Let op: de uitkomsten zijn niet toepasbaar op startups of scale ups."]
[]
[null,"Let op: de ondernemingswaarden in de dataset variëren van € 55.300 tot € 750.000.000. In het 10e deciel is de spreiding van de ondernemingswaarde hoog en lijkt de daling van de Keu te stagneren. Het toepassen van de onderzoeksresultaten op ondernemingen met een waarde buiten de onderzoeksresultaten (of binnen het tiende deciel) gaat gepaard met een lagere statistische betrouwbaarheid."]
[]
[]
[]
[null," "]
[]
[null,null," "]

{"sheet":"Keu referentiemodel","index":1,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[5,0,5,1],[29,0,29,1],[19,0,19,1],[60,0,60,1],[32,3,32,5],[29,3,29,5],[28,3,28,5],[18,0,18,1],[13,0,13,1]]}
[]
["Voor Nederlandse niet-beursgenoteerde ondernemingen"]
["Input Keu Referentiemodel"]
[]
[]
["Voer projectnaam in",null,null,"Output onderzoek"]
[null,null,null,{"$f":"IF(B9=\"Vul in\",\"95% betrouwbaarheidsinterval branche:\",\"95% betrouwbaarheidsinterval branche \" & B9 & \":\")","v":"95% betrouwbaarheidsinterval branche:"}]
["Input rekenmodel",null,null,"Min",{"$f":"_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!D2:D13,\"\")","v":""}]
["In welke branche is de onderneming actief?",{"$f":"INDEX('Resultaten branche'!$A$1:$A$14,'Keu referentiemodel'!C9+1)","v":"Vul in"},13,"Gemiddelde",{"$f":"_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!B2:B13,\"\")","v":""}]
["Is er sprake van exploitatiegebonden onroerend goed?",{"$f":"INDEX('Resultaten onroerend goed'!A1:A4,'Keu referentiemodel'!C10+1)","v":"Vul in"},3,"Max",{"$f":"_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!E2:E13,\"\")","v":""}]
["Wat is ongeveer de ondernemingswaarde? In euro's.",{"$f":"INDEX('Resultaten grootte effect'!E1:E14,'Keu referentiemodel'!C11+2)","v":"Vul in"},11,{"$f":"IF(B11=\"Vul in\",\"95% betrouwbaarheidsinterval grootte:\",\"95% betrouwbaarheidsinterval \" & C13 & \":\")","v":"95% betrouwbaarheidsinterval grootte:"}]
[null,null,{"$f":"IF(OR(B9=\"\",B9=\"Vul in\",B9=\"Anders\"),\"\",_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!I2:I12,\"\"))","v":""},"Min",{"$f":"_xlfn.XLOOKUP(C13,'Resultaten grootte effect'!A3:A12,'Resultaten grootte effect'!G3:G12,\"\")","v":""}]
[{"$f":"IF(B10=\"Vul in\",\"\",IF(B15=\"Nee\",\"\",\"Onroerend goed correctie:\"))","v":""},{"$f":"IF(B15=\"Nee\",\"\", IF(B10=\"Ja\", 'Resultaten onroerend goed'!B2, IF(B10=\"Nee\", 'Resultaten onroerend goed'!B3, \"\")))","v":""},{"$f":"_xlfn.XLOOKUP(B11,'Resultaten grootte effect'!E2:E13,'Resultaten grootte effect'!A2:A13,\"\")","v":0},"Gemiddelde",{"$f":"_xlfn.XLOOKUP(C13,'Resultaten grootte effect'!A3:A12,'Resultaten grootte effect'!F3:F12,\"\")","v":""}]
[{"$f":"IF('Keu referentiemodel'!B15=\"Nee\",\"\",\"Het aandeel exploitatie gebonden onroerend goed in de gehele onderzoeksgroep is 21% en in de branche \"&'Keu referentiemodel'!B9&TEXT(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A13,'Resultaten branche'!N2:N13,\"\"),\" 0%.\"))","v":"Het aandeel exploitatie gebonden onroerend goed in de gehele onderzoeksgroep is 21% en in de branche Vul in"},null,null,"Max",{"$f":"_xlfn.XLOOKUP(C13,'Resultaten grootte effect'!A3:A12,'Resultaten grootte effect'!H3:H12,\"\")","v":""},null,null,null,null,null,null,null," "]
["Wilt u een correctie toepassen vanwege het wel of niet aanwezig zijn van exploitatiegebonden onroerend goed?",{"$f":"INDEX('Resultaten onroerend goed'!A1:A4,'Keu referentiemodel'!C15+1)","v":"Vul in"},3,{"$f":"_xlfn.CONCAT(\"Spreidingsdiagram \",IF(B9=\"Vul in\",\"\",B9))","v":"Spreidingsdiagram "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Aanvullende input t.a.v. omvang"]
[{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",\"De gekozen branche bevindt zich in \" & C12 & \" en\" & \" de onderneming bevind zich in \" & C13 &\".\",\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",\"Bekijk de spreidingsdiagram aan de rechterzijde. Indien de onderneming sterk afwijkt van de overige observaties, pas dan mogelijk een grootte correctie toe.\",\"\"),\"\")","v":""}]
[{"$f":"IF(    _xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\", \"De mediaan van de ondernemingswaarde in de branche \" & 'Keu referentiemodel'!B9 & \" is \" & TEXT(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!H2:H12),\"€ #.###.###\") & \" en het gemiddelde is \" & TEXT(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!G2:G12),\"€ #.###.###\") & \".\",\"\")","v":{"$error":"#N/A"}}]
["Grootte correcte:",{"$f":"IFERROR(IF(B22=\"Nee\",\"\",_xlfn.XLOOKUP('Keu referentiemodel'!C13,'Resultaten grootte effect'!A3:A12,'Resultaten grootte effect'!F3:F12)-_xlfn.XLOOKUP(C12,'Resultaten grootte effect'!A3:A12,'Resultaten grootte effect'!F3:F12)),\"\")","v":""}]
["Wilt u een grootte correctie toepassen omdat de onderneming sterk afwijkt van de \nbranche grootte?",{"$f":"INDEX('Resultaten onroerend goed'!A1:A4,'Keu referentiemodel'!C22+1)","v":"Ja"},1]
[]
["Voorgesteld 95% betrouwbaarheidsinterval"]
["Min",{"$f":"IFERROR(B26-(MAX(E10-E8,E14-E12)/2),\"\")","v":""}]
["Gemiddelde",{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!C2:C13)=\"Nee\",E13+IF(ISNUMBER(B13),B13,0),E9+IF(ISNUMBER(B13),B13,0)+IF(ISNUMBER(B21),B21,0)),\"\")","v":""}]
["Max",{"$f":"IFERROR(B26+(MAX(E10-E8,E14-E12)/2),\"\")","v":""}]
[]
["Keuze voor het vastellen Keu",null,null,{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",IF(COUNTIF('Resultaten spreidingsdiagrammen'!C392:C396,B9)>0,\"Voor de leesbaarheid wordt de volgende observatie(s) van de gekozen branche niet getoond:\", \"\"),\"\"),\"\")","v":""}]
["Indien u het 95% betrouwbaarheidsinterval toepasbaar vindt kunt u aan de hand van de Small firm en Specific firm elementen bepalen waar de onderneming zich bevind in het betrowbaarheidsinterval. ",null,null,{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER('Resultaten spreidingsdiagrammen'!A391:A396 & \" & \" & 'Resultaten spreidingsdiagrammen'!B391:B396,'Resultaten spreidingsdiagrammen'!C391:C396=B9)),\"\"),\"\")","v":""}]
["Let op: u kunt niet de weging en de percentages hanteren uit het BDO-model. "]
[]
["De small firm elementen kunnen beoordeeld worden aan de volgende dimensies:",null,null," "]
["Afhankelijkheid afnemers ","Vul +/- correctie in"]
[]
["Afhankelijkheid leveranciers","Vul +/- correctie in"]
[]
["Afhankelijkheid management","Vul +/- correctie in"]
["De specific firm premium elementen kunnen beoordeeld worden aan de volgende elementen:",null,null,{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Nee\",IF(COUNTIF('Resultaten spreidingsdiagrammen'!C392:C396,B9)>0,\"Voor de leesbaarheid wordt de volgende observatie(s) van de gekozen branche niet getoond:\", \"\"),\"\"),\"\")","v":""}]
["Merknaam en reputatie ","Vul +/- correctie in",null,{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Nee\",_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER('Resultaten spreidingsdiagrammen'!A391:A396 & \" & \" & 'Resultaten spreidingsdiagrammen'!B391:B396,'Resultaten spreidingsdiagrammen'!C391:C396=B9)),\"\"),\"\")","v":""}]
[]
["Spreiding van activiteiten","Vul +/- correctie in"]
[null,null,null,null,"Ja"]
["Toetredingsbarrières tot de markt ","Vul +/- correctie in"]
[]
["Flexibiliteit","Vul +/- correctie in"]
["Overige:"]
["Overige correctie","Vul +/- correctie in"]
[]
["Vastgestelde Keu"]
[{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!C2:C13)=\"Nee\",\"Gemiddelde Keu van \" & C13,\"Gemiddelde Keu van de branche \" & B9), \"Gemiddelde keu van de branche / deciel\")","v":"Gemiddelde keu van de branche / deciel"},{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!C2:C13)=\"Nee\",E13,E9),\"\")","v":""}]
["Toegepaste correctie voor exploitatie gebonden onroerend goed",{"$f":"IF(B15=\"nee\",\"Geen correctie toegepast\",B13)","v":""}]
[{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!C2:C13)=\"Nee\",\"\",\"Toegepaste grootte correctie\"),\"\")","v":""},{"$f":"IFERROR(IF(_xlfn.XLOOKUP(B9,'Resultaten branche'!A2:A13,'Resultaten branche'!C2:C13)=\"Nee\",\"\",IF(B22=\"nee\",\"Geen correctie toegepast\",B21)),\"\")","v":""},null,"Wilt u de uitkomsten van het model exporteren naar PDF?"]
["Voorgestelde Keu op basis van het 95% betrouwbaarheidsinterval",{"$f":"IFERROR(IF(B51=\"\",\"\",SUM(B51:B53)),\"\")","v":""}]
[]
["Small firm correctie",{"$f":"IFERROR(IF(COUNT(B34,B36,B38)<>3,\"Niet alle velden zijn ingevuld\",B34+B36+B38),\"\")","v":"Niet alle velden zijn ingevuld"}]
["Specific firm correctie",{"$f":"IFERROR(IF(COUNT(B40,B42,B44,B46)<>4,\"Niet alle velden zijn ingevuld\",B40+B42+B44+B46),\"\")","v":"Niet alle velden zijn ingevuld"}]
["Overige correctie",{"$f":"IFERROR(IF(COUNT(B48)<>1,\"Niet alle velden zijn ingevuld\",B48),\"\")","v":"Niet alle velden zijn ingevuld"}]
["Vastgestelde Keu",{"$f":"IF(COUNTIF(B54:B58,\"Niet alle velden zijn ingevuld\")>0,\"\",SUM(B54:B58))","v":""}]
[]
[{"$f":"IFERROR(IF(ISNUMBER(B59),IF(OR(B59<B25, B59>B27),\"Let op: door de gehanteerde correcties valt de Keu buiten het 95% betrouwbaarheidsinterval.\",\"\"),\"\"),\"\")","v":""}]
[]
[]
[]
[null,"Ja"]

{"sheet":"Export van referentiemodel","index":2,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":true,"merged":[[69,0,69,2],[63,0,63,2],[4,0,4,2],[24,0,24,2],[61,0,61,2],[30,0,30,2],[13,0,13,2],[17,0,17,2],[21,0,21,2],[58,0,58,2],[40,0,40,1],[9,0,9,2]]}
[]
["Rendementseis Nederlandse niet-beursgenoteerde ondernemingen"]
["Uitkomst Keu Referentiemodel"]
[]
["Onderstaande overzicht geeft de te hanteren Keu op basis van het onderzoek naar de rendementseis van Nederlandse niet-beursgenoteerde ondernemingen. Dit onderzoek is gepubliceerd door ValuePro Haarlem B.V. in september 2025."]
[]
["Het onderzoek kan via onderstaande link gedownload worden."]
["ValuePro Papers: Rendementseis niet-beursgenoteerde ondernemingen - ValuePro"]
[]
[{"$f":"IF('Keu referentiemodel'!A6=\"Voer projectnaam in\",\"\",\"Keu referentiemodel voor project \" &'Keu referentiemodel'!A6)","v":""}]
[]
["Gekozen uitgangspunten van waardeerder:"]
["Branche waarin de onderneming actief is",null,{"$f":"IF('Keu referentiemodel'!B9=\"Vul in\",\"Veld is niet ingevuld\",'Keu referentiemodel'!B9)","v":"Veld is niet ingevuld"}]
[{"$f":"IF(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",\"De branche \"& 'Keu referentiemodel'!B9 & \" wijkt significant af van de totale onderzoeksgroep.\",\"De branche \"& 'Keu referentiemodel'!B9 & \" wijkt niet significant af van de totale onderzoeksgroep.\")","v":{"$error":"#N/A"}}]
[]
["Is er sprake van exploitatie gebonden onroerend goed?",null,{"$f":"IF('Keu referentiemodel'!B10=\"Vul in\",\"Veld is niet ingevuld\",'Keu referentiemodel'!B10)","v":"Veld is niet ingevuld"}]
["-","Wilt u een correctie toepassen voor het aanwezig zijn van exploitatie gebonden onroerend goed?",{"$f":"IF('Keu referentiemodel'!B15=\"Nee\",'Keu referentiemodel'!B15,'Keu referentiemodel'!B15&\", correctie: \"&TEXT('Keu referentiemodel'!B13,\"#0,00%\"))","v":"Vul in, correctie: "}]
[{"$f":"IF('Keu referentiemodel'!B15=\"Vul in\",\"\",\"Het aandeel exploitatie gebonden onroerend goed in de gehele onderzoeksgroep is 21% en in de branche \"&'Keu referentiemodel'!B9&TEXT(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A13,'Resultaten branche'!N2:N13,\"\"),\" 0%\"))","v":""}]
[]
["Range van de ondernemingswaarde in euro's",null,{"$f":"IF('Keu referentiemodel'!B11=\"Vul in\",\"Veld is niet ingevuld\",'Keu referentiemodel'!B11)","v":"Veld is niet ingevuld"}]
[{"$f":"IF(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",\"-\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",\"Wilt u een grootte correctie toepassen?\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",IF('Keu referentiemodel'!B22=\"Nee\",'Keu referentiemodel'!B22,'Keu referentiemodel'!B22&\", correctie: \"&TEXT('Keu referentiemodel'!B21,\"#0,00%\")),\"\")","v":{"$error":"#N/A"}}]
[{"$f":"IF(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!C2:C12)=\"Ja\",\"De mediaan van de ondernemingswaarde in de branche \"&'Keu referentiemodel'!B9&\" is \"&TEXT(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!H2:H12,\"\"),\"€ #.###.###\")&\" en het gemiddelde is \"&TEXT(_xlfn.XLOOKUP('Keu referentiemodel'!B9,'Resultaten branche'!A2:A12,'Resultaten branche'!G2:G12,\"\"),\"€ #.###.###\")&\".\",\"\")","v":{"$error":"#N/A"}}]
[]
["Uitkomsten  rekenmodel:"]
["Als het 95%-betrouwbaarheidsinterval volgens de waardeerder toepasbaar is, kan het onderstaande interval worden gebruikt."]
["Minimale Keu, op basis van een 95% betrouwbaarheid interval",null,{"$f":"'Keu referentiemodel'!B25","v":""}]
["Gemiddelde Keu",null,{"$f":"'Keu referentiemodel'!B26","v":""}]
["Maximale Keu, op basis van een 95% betrouwbaarheid interval",null,{"$f":"'Keu referentiemodel'!B27","v":""}]
[]
["Keuze voor het vastellen Keu:"]
["De keuze waar in het 95% betrouwbaarheidsinterval de onderneming zich bevind kan bepaald worden aan de hand van de small en specific firm elementen."]
[]
["De small firm elementen:",null,"Gehanteerde correctie:"]
["Afhankelijkheid afnemers ",null,{"$f":"'Keu referentiemodel'!B34","v":"Vul +/- correctie in"}]
["Afhankelijkheid leveranciers",null,{"$f":"'Keu referentiemodel'!B36","v":"Vul +/- correctie in"}]
["Afhankelijkheid management",null,{"$f":"'Keu referentiemodel'!B38","v":"Vul +/- correctie in"}]
[]
[]
[]
[]
["De specific firm premium elementen:",null,"Gehanteerde correctie:"]
["Merknaam en reputatie ",null,{"$f":"'Keu referentiemodel'!B40","v":"Vul +/- correctie in"}]
["Spreiding van activiteiten",null,{"$f":"'Keu referentiemodel'!B42","v":"Vul +/- correctie in"}]
["Toetredingsbarrières tot de markt ",null,{"$f":"'Keu referentiemodel'!B44","v":"Vul +/- correctie in"}]
["Flexibiliteit",null,{"$f":"'Keu referentiemodel'!B46","v":"Vul +/- correctie in"}]
[]
["Overige correctie",null,{"$f":"'Keu referentiemodel'!B48","v":"Vul +/- correctie in"}]
[]
["Vastgestelde Keu"]
[{"$f":"'Keu referentiemodel'!A51","v":"Gemiddelde keu van de branche / deciel"},null,{"$f":"'Keu referentiemodel'!B51","v":""}]
[{"$f":"'Keu referentiemodel'!A52","v":"Toegepaste correctie voor exploitatie gebonden onroerend goed"},null,{"$f":"'Keu referentiemodel'!B52","v":""}]
[{"$f":"'Keu referentiemodel'!A53","v":""},null,{"$f":"'Keu referentiemodel'!B53","v":""}]
[{"$f":"'Keu referentiemodel'!A54","v":"Voorgestelde Keu op basis van het 95% betrouwbaarheidsinterval"},null,{"$f":"'Keu referentiemodel'!B54","v":""}]
[]
["Correctie small firm elementen",null,{"$f":"'Keu referentiemodel'!B56","v":"Niet alle velden zijn ingevuld"}]
["Correctie specific firm elementen",null,{"$f":"SUM(C42:C45)","v":0}]
[{"$f":"'Keu referentiemodel'!A58","v":"Overige correctie"},null,{"$f":"'Keu referentiemodel'!B58","v":"Niet alle velden zijn ingevuld"}]
["Vastgestelde Keu",null,{"$f":"'Keu referentiemodel'!B59","v":""}]
[{"$f":"'Keu referentiemodel'!A61","v":""}]
[]
["Uitgangspunten rekenmodel:"]
["Het rekenmodel hanteert de gemiddelde Keu van de geselecteerde branche. Indien deze branche niet significant afwijkt van de totale onderzoeksgroep, wordt de gemiddelde Keu van het Deciel toegepast.\n\nVervolgens kan de Keu worden gecorrigeerd voor de aanwezigheid van exploitatiegebonden onroerend goed en/of voor een afwijkende ondernemingswaarde ten opzichte van de gemiddelde ondernemingswaarde binnen de branche. Het laatste is niet van toepassing als de gemiddelde Keu van het deciel wordt gehanteerd. Het toepassen van dergelijke correcties is een subjectieve beoordeling van de waardeerder.\n\nHet model gebruikt het grootste 95%-betrouwbaarheidsinterval van de branche of het desbetreffende deciel en baseert hierop de minimale en maximale waarden van het te hanteren interval."]
[]
["De waardeerder kan vervolgens aan de hand van de small en specific firm elementen de Keu vaststellen. Hierbij dient de waardeerder zich te realiseren dat de weging en percentages van het BDO-model niet toegepast kunnen worden."]
[]
["Let op: het stapelen van verschillende groepen leidt tot lagere statistische betrouwbaarheid."]
[]
["Let op: de uitkomsten zijn niet toepasbaar op startup’s of scale up’s."]
[]
["Let op: de ondernemingswaarden in de dataset variëren van € 55.300 tot € 750.000.000. In het 10e deciel is de spreiding van de ondernemingswaarde hoog en lijkt de daling van de Keu te stagneren. Het toepassen van de onderzoeksresultaten op ondernemingen met een waarde buiten de onderzoeksresultaten (of binnen het tiende deciel) gaat gepaard met een lagere statistische betrouwbaarheid."]

{"sheet":"Resultaten branche","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[null,"Gemiddelde Keu","significant verschil totaal","95% interval min","95% interval max","Grootte interval","Gemiddelde ondernemingswaarde","Mediaan ondernemingswaarde","Deciel Gem. OW","Min. ondernemingswaarde","Max. ondernemingswaarde ","Range","Aantal observaties","Aandeel OG in subgroep"]
["Agri & Food",0.14499999999999999,"ja",0.13300000000000001,0.15659999999999999,{"$f":"E2-D2","v":2.3599999999999982E-2},20199050,6286000,"Deciel 9",204260,129300000,{"$f":"TEXT(J2,\"#.##0\") & \" - \" & TEXT(K2,\"#.##0\")","v":"204.260 - 129.300.000"},17,0.35]
["Automotive, Transport & Logistiek",0.1472,"ja",0.1363,0.15809999999999999,{"$f":"E3-D3","v":2.1799999999999986E-2},10083160,7282835,"Deciel 8",609000,48115000,{"$f":"TEXT(J3,\"#.##0\") & \" - \" & TEXT(K3,\"#.##0\")","v":"609.000 - 48.115.000"},25,0.28000000000000003]
["Bouw & Installatietechniek",0.16402,"nee",0.15765999999999999,0.17038600000000001,1.2726000000000015E-2,6867980,2458841,"Deciel 7",442080,83729000,"442.080 - 83.729.000",70,0.24]
["Detailhandel",0.15590709999999999,"nee",0.13855870000000001,0.17325560000000001,3.4696900000000003E-2,5789340,579518.5,"Deciel 7",90000,48767000,"90.000 - 48.767.000",14,0.15]
["Gezondheidszorg & Farmacie",0.15836349999999999,"nee",0.1448094,0.1719176,2.7108199999999999E-2,40116020,3571000,"Deciel 10",215000,750000000,"215.000 - 750.000.000",23,0.09]
["Groothandel",0.15166299999999999,"ja",0.14155010000000001,0.1617759,2.0225799999999988E-2,16204400,3806500,"Deciel 9",233000,180000000,"233.000 - 180.000.000",42,0.26]
["Horeca, Toerisme & Recreatie",0.16731650000000001,"nee",0.14489099999999999,0.1897421,4.4851100000000005E-2,11109500,1124000,"Deciel 8",55400,109900000,"55.400 - 109.900.000",12,0.17]
["Industrie & Productie",0.15088099999999999,"ja",0.1446249,0.1571372,1.2512300000000004E-2,14648120,6896494.5,"Deciel 9",159000,132732000,"159.000 - 132.732.000",74,0.3]
["IT, Online & E-commerce",0.18146780000000001,"ja",0.1723963,0.19053929999999999,1.8142999999999992E-2,5554040,2785644,"Deciel 7",56960,21706000,"56.960 - 21.706.000",47,0.04]
["Media, Reclame & Communicatie",0.16743839999999999,"nee",0.15000540000000001,0.18487129999999999,3.4865899999999977E-2,3263480,1240500,"Deciel 6",527000,10570000,"527.000 - 10.570.000",10,0.1]
["Zakelijke dienstverlening",0.17094899999999999,"ja",0.16376489999999999,0.17813309999999999,1.4368199999999998E-2,4267360,2664411,"Deciel 6",101870,35992000,"101.870 - 35.992.000",53,0.15]
["Anders",0.16044610000000001,"nee",null,null,null,null,null,null,null,null,">35.992.000"]
["Vul in"]
[]
["Totale onderzoeksgroep",0.16089999999999999]

{"sheet":"Resultaten grootte effect","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,6,0,7]]}
["Deciel","Min.","Max.","Gemiddelde",null,"Gemiddelde Keu","95% betrouwbaarheidsinterval"]
["De onderneming valt buiten de onderzoeksresultaten",null,null,null,"< 55.399"]
["Deciel 1",55399,566559.6,343281.69230769231,{"$f":"TEXT(B3,\"#.##0\") & \" - \" & TEXT(C3,\"#.##0\")","v":"55.399 - 566.560"},0.17710000000000001,0.16800000000000001,0.1862]
["Deciel 2",566559.6,934800,747771.4615384615,{"$f":"TEXT(B4,\"#.##0\") & \" - \" & TEXT(C4,\"#.##0\")","v":"566.560 - 934.800"},0.17230000000000001,0.16370000000000001,0.18099999999999999]
["Deciel 3",934800,1501578.1,1265758.923076923,"934.800 - 1.501.578",0.16869999999999999,0.1605,0.1769]
["Deciel 4",1501578.1,2333200,1893401.8421052631,"1.501.578 - 2.333.200",0.16700000000000001,0.15920000000000001,0.17480000000000001]
["Deciel 5",2333200,3195500,2687045.512820513,"2.333.200 - 3.195.500",0.16339999999999999,0.155,0.17180000000000001]
["Deciel 6",3195500,4809600,4030880.2564102565,"3.195.500 - 4.809.600",0.16109999999999999,0.15290000000000001,0.16930000000000001]
["Deciel 7",4809600,7594696.7000000002,5836905.7368421052,"4.809.600 - 7.594.697",0.16209999999999999,0.1542,0.17]
["Deciel 8",7594696.7000000002,11811400,9510183.41025641,"7.594.697 - 11.811.400",0.15840000000000001,0.1472,0.1696]
["Deciel 9",11811400,23677300,16873409.948717948,"11.811.400 - 23.677.300",0.1416,0.13389999999999999,0.14940000000000001]
["Deciel 10",23677300,750000000,72341246.205128208,"23.677.300 - 750.000.000",0.13750000000000001,0.1273,0.1477]
[null,null,null,null,"Vul in"]

{"sheet":"Resultaten onroerend goed","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Exploitatie gebonden onroerend goed aanwezig:","Correctie"]
["Ja",-1.5899999999999997E-2]
["Nee",3.9000000000000146E-3]
["Vul in"]

{"sheet":"Resultaten spreidingsdiagrammen","index":6,"n_rows":396,"n_cols":3,"rows_kept":396,"cut":false,"hidden":true,"merged":[]}
["Ondernemingswaarde ","Keu","In welke branche was de waardering?"]
[55399,0.153,"Horeca, Toerisme & Recreatie"]
[56963,0.17975000000000002,"IT, Online & E-commerce"]
[65460,0.1976,"IT, Online & E-commerce"]
[90000,0.2,"Detailhandel"]
[101870,0.2,"Zakelijke dienstverlening"]
[159000,0.18099999999999999,"Industrie & Productie"]
[204262,0.1686,"Agri & Food"]
[215000,0.17050000000000001,"Gezondheidszorg & Farmacie"]
[220000,0.14099999999999999,"Zakelijke dienstverlening"]
[224000,0.25,"Horeca, Toerisme & Recreatie"]
[233000,0.193,"Groothandel"]
[256100,0.186,"IT, Online & E-commerce"]
[279000,0.2,"Zakelijke dienstverlening"]
[290000,0.18,"Anders"]
[311804,0.2,"IT, Online & E-commerce"]
[312144,0.18,"Detailhandel"]
[328000,0.1767,"Agri & Food"]
[340000,0.13320000000000001,"Detailhandel"]
[350000,0.2,"Detailhandel"]
[370000,0.16789999999999999,"Zakelijke dienstverlening"]
[388741,0.17,"Zakelijke dienstverlening"]
[390759,0.1585,"Horeca, Toerisme & Recreatie"]
[397370,0.15609999999999999,"Agri & Food"]
[407542,0.246,"Industrie & Productie"]
[432500,0.18,"Groothandel"]
[437500,0.15640000000000001,"IT, Online & E-commerce"]
[442075,0.18,"Bouw & Installatietechniek"]
[442495,0.14389999999999997,"Bouw & Installatietechniek"]
[450000,0.14699999999999999,"Detailhandel"]
[456292,0.12,"Detailhandel"]
[467000,0.183,"Bouw & Installatietechniek"]
[471645,0.1404,"Gezondheidszorg & Farmacie"]
[507000,0.1673,"Bouw & Installatietechniek"]
[516000,0.1651,"Bouw & Installatietechniek"]
[523150,0.18,"Bouw & Installatietechniek"]
[527000,0.18,"Media, Reclame & Communicatie"]
[548915,0.15,"Industrie & Productie"]
[555000,0.25,"Bouw & Installatietechniek"]
[565000,0.1759,"Industrie & Productie"]
[567228,0.15049999999999999,"Detailhandel"]
[580000,0.1807,"Media, Reclame & Communicatie"]
[591809,0.14330000000000001,"Detailhandel"]
[595000,0.17499999999999999,"Groothandel"]
[600000,0.15,"Bouw & Installatietechniek"]
[600000,0.2,"Zakelijke dienstverlening"]
[609000,0.15590000000000001,"Automotive, Transport & Logistiek"]
[621000,0.20399999999999999,"Bouw & Installatietechniek"]
[630000,0.17530000000000001,"IT, Online & E-commerce"]
[636638,0.17100000000000001,"Gezondheidszorg & Farmacie"]
[640250,0.186,"Groothandel"]
[647055,0.13550000000000001,"Groothandel"]
[649000,0.25,"IT, Online & E-commerce"]
[679537,0.14199999999999999,"Horeca, Toerisme & Recreatie"]
[692000,0.18585000000000002,"Gezondheidszorg & Farmacie"]
[700000,0.2,"Media, Reclame & Communicatie"]
[715000,0.19189999999999999,"Gezondheidszorg & Farmacie"]
[724372,0.1767,"IT, Online & E-commerce"]
[732000,0.14199999999999999,"Gezondheidszorg & Farmacie"]
[735000,0.16300000000000001,"Bouw & Installatietechniek"]
[758269,0.18,"Horeca, Toerisme & Recreatie"]
[770071,0.16,"Zakelijke dienstverlening"]
[779000,0.17,"Automotive, Transport & Logistiek"]
[790000,0.17399999999999999,"Bouw & Installatietechniek"]
[791000,0.19220000000000001,"Zakelijke dienstverlening"]
[800000,0.18,"Bouw & Installatietechniek"]
[839042,0.16600000000000001,"Zakelijke dienstverlening"]
[840000,0.155,"Bouw & Installatietechniek"]
[845000,0.183,"Horeca, Toerisme & Recreatie"]
[863365,0.17280000000000001,"Bouw & Installatietechniek"]
[870000,0.186,"Zakelijke dienstverlening"]
[886000,0.11749999999999999,"Automotive, Transport & Logistiek"]
[892000,0.21,"Zakelijke dienstverlening"]
[898349,0.18509999999999999,"IT, Online & E-commerce"]
[900000,9.3406039999999982E-2,"Groothandel"]
[915000,0.17,"Industrie & Productie"]
[918000,0.1973,"Zakelijke dienstverlening"]
[929102,0.2,"Media, Reclame & Communicatie"]
[934000,0.15037499999999998,"Zakelijke dienstverlening"]
[936000,0.16689999999999999,"Groothandel"]
[955000,0.191,"Industrie & Productie"]
[958396,0.15,"Industrie & Productie"]
[1006000,0.16800000000000001,"Bouw & Installatietechniek"]
[1013078,0.159,"Zakelijke dienstverlening"]
[1036398,0.15229999999999999,"Bouw & Installatietechniek"]
[1088000,0.19320000000000001,"Bouw & Installatietechniek"]
[1099000,0.15790000000000001,"Bouw & Installatietechniek"]
[1103583,0.1787,"Zakelijke dienstverlening"]
[1123590,0.2417,"Groothandel"]
[1150000,0.1598,"Groothandel"]
[1182000,0.22,"Zakelijke dienstverlening"]
[1193856,0.15049999999999999,"Industrie & Productie"]
[1200000,0.20300000000000001,"IT, Online & E-commerce"]
[1216000,0.16500000000000001,"Media, Reclame & Communicatie"]
[1217436,0.1734,"Bouw & Installatietechniek"]
[1251689,0.16159999999999999,"IT, Online & E-commerce"]
[1261000,0.15,"Bouw & Installatietechniek"]
[1265000,0.17,"Media, Reclame & Communicatie"]
[1275000,0.17319999999999999,"Bouw & Installatietechniek"]
[1300000,0.17499999999999999,"Bouw & Installatietechniek"]
[1300000,0.19,"Industrie & Productie"]
[1329000,0.183,"Industrie & Productie"]
[1341631,0.15640000000000001,"Gezondheidszorg & Farmacie"]
[1347000,0.155,"Bouw & Installatietechniek"]
[1390000,0.15679999999999999,"Groothandel"]
[1400000,0.17399999999999999,"IT, Online & E-commerce"]
[1400000,0.2203,"Zakelijke dienstverlening"]
[1403000,0.17150000000000001,"Horeca, Toerisme & Recreatie"]
[1418000,0.1,"Groothandel"]
[1427638,0.17100000000000001,"Bouw & Installatietechniek"]
[1433000,0.16039999999999999,"Bouw & Installatietechniek"]
[1443000,0.1239,"Groothandel"]
[1446000,0.19429375000000002,"Industrie & Productie"]
[1483103,0.1646,"Zakelijke dienstverlening"]
[1488200,0.13700000000000001,"Industrie & Productie"]
[1491000,0.17499999999999999,"Zakelijke dienstverlening"]
[1493000,0.1482,"Groothandel"]
[1500000,0.13750000000000001,"Industrie & Productie"]
[1515781,0.18129999999999999,"Bouw & Installatietechniek"]
[1526480,0.18099999999999999,"Bouw & Installatietechniek"]
[1535000,0.1661,"IT, Online & E-commerce"]
[1583208,0.17,"Bouw & Installatietechniek"]
[1600000,0.1555,"Industrie & Productie"]
[1601865,0.14499999999999999,"Media, Reclame & Communicatie"]
[1622733,0.17449999999999999,"IT, Online & E-commerce"]
[1650000,0.1797,"Bouw & Installatietechniek"]
[1663000,0.1547,"Industrie & Productie"]
[1686000,0.18379999999999999,"IT, Online & E-commerce"]
[1701889,0.16,"Gezondheidszorg & Farmacie"]
[1716000,0.1225,"Groothandel"]
[1717532,0.12909999999999999,"Industrie & Productie"]
[1728000,0.1547,"Industrie & Productie"]
[1740083,0.15959999999999999,"Agri & Food"]
[1754461,0.16500000000000001,"IT, Online & E-commerce"]
[1801500,0.185,"Zakelijke dienstverlening"]
[1900000,0.21,"IT, Online & E-commerce"]
[1909000,0.186,"Bouw & Installatietechniek"]
[1914000,0.14779999999999999,"Bouw & Installatietechniek"]
[1924977,0.2,"Zakelijke dienstverlening"]
[1935677,0.16,"Industrie & Productie"]
[1985393,0.14499999999999999,"Industrie & Productie"]
[2031000,0.1409,"Bouw & Installatietechniek"]
[2043000,0.16500000000000001,"Groothandel"]
[2051173,0.15310000000000001,"Groothandel"]
[2058000,0.1991,"Industrie & Productie"]
[2072000,0.25,"IT, Online & E-commerce"]
[2105272,0.16389999999999999,"IT, Online & E-commerce"]
[2112948,0.18340000000000001,"Bouw & Installatietechniek"]
[2125640,0.1575,"Zakelijke dienstverlening"]
[2160927,0.16300000000000001,"Industrie & Productie"]
[2200000,0.16769999999999999,"IT, Online & E-commerce"]
[2200000,0.12037999999999997,"Bouw & Installatietechniek"]
[2245221,0.16589999999999999,"Zakelijke dienstverlening"]
[2247000,0.15925,"IT, Online & E-commerce"]
[2258510,0.15,"Industrie & Productie"]
[2326000,0.19139999999999999,"Detailhandel"]
[2335000,0.12839999999999999,"Automotive, Transport & Logistiek"]
[2348000,0.16800000000000001,"Gezondheidszorg & Farmacie"]
[2366000,0.1951,"Zakelijke dienstverlening"]
[2372066,0.1701,"IT, Online & E-commerce"]
[2377000,0.14162849999999999,"Industrie & Productie"]
[2400000,0.16,"Groothandel"]
[2400000,0.1588,"Groothandel"]
[2417682,0.1489,"Bouw & Installatietechniek"]
[2445000,0.16489999999999999,"Horeca, Toerisme & Recreatie"]
[2449000,0.14279200000000003,"Horeca, Toerisme & Recreatie"]
[2460377,0.1694,"Detailhandel"]
[2500000,0.19,"Bouw & Installatietechniek"]
[2500000,0.189,"Zakelijke dienstverlening"]
[2500000,0.16,"Detailhandel"]
[2521000,0.16,"Industrie & Productie"]
[2559744,0.14580000000000001,"Gezondheidszorg & Farmacie"]
[2615000,9.4475000000000003E-2,"Automotive, Transport & Logistiek"]
[2623000,0.17,"Zakelijke dienstverlening"]
[2664411,0.187,"Zakelijke dienstverlening"]
[2682000,0.17691875000000004,"Gezondheidszorg & Farmacie"]
[2694354,0.14000000000000001,"Agri & Food"]
[2700000,0.155,"Zakelijke dienstverlening"]
[2723879,0.19539999999999999,"Zakelijke dienstverlening"]
[2727000,0.183,"IT, Online & E-commerce"]
[2749000,0.13120000000000001,"Detailhandel"]
[2785644,0.13750000000000001,"IT, Online & E-commerce"]
[2830000,0.13539999999999999,"Zakelijke dienstverlening"]
[2834656,0.16489999999999996,"Bouw & Installatietechniek"]
[2919000,0.25,"Bouw & Installatietechniek"]
[2947000,0.1305,"Automotive, Transport & Logistiek"]
[2947681,0.13500000000000001,"Agri & Food"]
[2971000,0.16800000000000001,"Bouw & Installatietechniek"]
[2978000,0.16700000000000001,"Zakelijke dienstverlening"]
[2982000,0.189,"Zakelijke dienstverlening"]
[3000000,0.16600000000000001,"Zakelijke dienstverlening"]
[3000000,0.16800000000000001,"Industrie & Productie"]
[3148281,0.19969999999999999,"Industrie & Productie"]
[3152000,0.1779,"Zakelijke dienstverlening"]
[3170000,0.15809999999999999,"Industrie & Productie"]
[3221000,0.13009999999999999,"Automotive, Transport & Logistiek"]
[3355329,0.11600000000000001,"Zakelijke dienstverlening"]
[3427000,0.13800000000000001,"Groothandel"]
[3500000,0.22600000000000001,"Bouw & Installatietechniek"]
[3500000,0.15,"Zakelijke dienstverlening"]
[3500000,0.14000000000000001,"Zakelijke dienstverlening"]
[3571000,0.18129999999999999,"Gezondheidszorg & Farmacie"]
[3600000,0.16500000000000001,"Bouw & Installatietechniek"]
[3600000,0.16,"IT, Online & E-commerce"]
[3621460,0.1691,"Industrie & Productie"]
[3652000,0.15959999999999999,"Groothandel"]
[3670000,0.15040000000000001,"Industrie & Productie"]
[3744000,0.17699999999999999,"Zakelijke dienstverlening"]
[3757000,0.1371,"Groothandel"]
[3819000,0.121,"Bouw & Installatietechniek"]
[3856000,0.1363,"Groothandel"]
[3884000,0.18858749999999999,"IT, Online & E-commerce"]
[3944000,0.13800000000000001,"Bouw & Installatietechniek"]
[3946121,0.1454,"Bouw & Installatietechniek"]
[3996827,0.16689999999999999,"Groothandel"]
[4019847,0.16470000000000001,"Agri & Food"]
[4043000,0.18,"Bouw & Installatietechniek"]
[4112000,0.1613,"Gezondheidszorg & Farmacie"]
[4143000,0.17,"Gezondheidszorg & Farmacie"]
[4200000,0.15040000000000001,"Industrie & Productie"]
[4298000,0.14499999999999999,"Bouw & Installatietechniek"]
[4307000,0.14849999999999999,"Bouw & Installatietechniek"]
[4380000,0.14097499999999999,"Bouw & Installatietechniek"]
[4394678,0.19900000000000001,"Bouw & Installatietechniek"]
[4438961,0.15970000000000001,"Agri & Food"]
[4500000,0.17499999999999999,"Groothandel"]
[4567000,0.14130000000000001,"Bouw & Installatietechniek"]
[4600000,0.14099999999999999,"Zakelijke dienstverlening"]
[4600000,0.17649999999999999,"IT, Online & E-commerce"]
[4616000,0.23535,"Groothandel"]
[4617024,0.17699999999999999,"Bouw & Installatietechniek"]
[4700000,0.15095,"Automotive, Transport & Logistiek"]
[4710083,0.2089,"IT, Online & E-commerce"]
[4793000,0.16,"Automotive, Transport & Logistiek"]
[4876000,0.2,"IT, Online & E-commerce"]
[4878000,0.13420000000000001,"Zakelijke dienstverlening"]
[4911000,0.2,"Bouw & Installatietechniek"]
[5015000,0.1598,"IT, Online & E-commerce"]
[5060000,0.2,"IT, Online & E-commerce"]
[5168000,0.1676,"Groothandel"]
[5220000,0.13650000000000001,"Zakelijke dienstverlening"]
[5232140,0.19489999999999999,"Bouw & Installatietechniek"]
[5250000,0.13500000000000001,"Industrie & Productie"]
[5319935,0.14347499999999999,"Zakelijke dienstverlening"]
[5336606,0.17080000000000001,"IT, Online & E-commerce"]
[5348000,0.1421,"Industrie & Productie"]
[5400000,0.12096599999999999,"Gezondheidszorg & Farmacie"]
[5450000,0.17499999999999999,"Automotive, Transport & Logistiek"]
[5473432,0.20499999999999999,"Zakelijke dienstverlening"]
[5492768,0.18,"Industrie & Productie"]
[5531000,0.17100000000000001,"Industrie & Productie"]
[5561112,0.1552,"Bouw & Installatietechniek"]
[5603387,0.1522,"Industrie & Productie"]
[5619000,0.125,"IT, Online & E-commerce"]
[5671203,0.1784,"Zakelijke dienstverlening"]
[5700000,0.1585,"Bouw & Installatietechniek"]
[5744000,0.12970625,"Horeca, Toerisme & Recreatie"]
[5772000,0.19800000000000001,"Zakelijke dienstverlening"]
[5931000,0.16600000000000001,"Industrie & Productie"]
[5943000,0.13681250000000003,"Industrie & Productie"]
[6012065,0.17460000000000001,"Zakelijke dienstverlening"]
[6250000,0.14710000000000001,"Automotive, Transport & Logistiek"]
[6286000,0.13600000000000001,"Agri & Food"]
[6375968,0.19750000000000001,"Zakelijke dienstverlening"]
[6736000,0.14499999999999999,"Groothandel"]
[6750000,0.17749999999999999,"Automotive, Transport & Logistiek"]
[6900000,0.151,"Agri & Food"]
[7000000,0.16707750000000002,"Media, Reclame & Communicatie"]
[7006000,0.1883,"IT, Online & E-commerce"]
[7150000,0.15210000000000001,"Bouw & Installatietechniek"]
[7282835,0.121,"Automotive, Transport & Logistiek"]
[7546967,0.16719999999999999,"Zakelijke dienstverlening"]
[7600000,0.2,"IT, Online & E-commerce"]
[7757411,0.15543999999999999,"Automotive, Transport & Logistiek"]
[7842000,0.1361,"Automotive, Transport & Logistiek"]
[7845000,0.1234,"Zakelijke dienstverlening"]
[7849989,0.14000000000000001,"Industrie & Productie"]
[7938000,0.14900000000000002,"Industrie & Productie"]
[8000000,0.12970000000000001,"Automotive, Transport & Logistiek"]
[8245882,0.13800000000000001,"Media, Reclame & Communicatie"]
[8420000,0.12440000000000001,"Horeca, Toerisme & Recreatie"]
[8485000,0.114,"Bouw & Installatietechniek"]
[8500000,0.23499999999999999,"Industrie & Productie"]
[8625000,0.115,"Gezondheidszorg & Farmacie"]
[9005286,0.127,"Automotive, Transport & Logistiek"]
[9069000,0.19500000000000001,"Groothandel"]
[9119500,0.18,"Gezondheidszorg & Farmacie"]
[9407000,0.14299999999999999,"Bouw & Installatietechniek"]
[9472000,0.159,"Automotive, Transport & Logistiek"]
[9500000,0.14499999999999999,"Automotive, Transport & Logistiek"]
[9507000,0.123,"Groothandel"]
[9769121,0.1424,"IT, Online & E-commerce"]
[9775738,0.1832,"IT, Online & E-commerce"]
[9795994,0.15329999999999999,"Bouw & Installatietechniek"]
[9856000,0.14499999999999999,"Industrie & Productie"]
[10000000,0.17,"Groothandel"]
[10047000,0.25,"IT, Online & E-commerce"]
[10055000,0.16919999999999999,"Agri & Food"]
[10056654,0.15740000000000001,"Groothandel"]
[10150000,0.1173,"Industrie & Productie"]
[10300000,0.23035750000000002,"IT, Online & E-commerce"]
[10356000,0.15390000000000001,"Automotive, Transport & Logistiek"]
[10514000,0.13488125000000001,"Industrie & Productie"]
[10538000,0.25,"IT, Online & E-commerce"]
[10570000,0.128606,"Media, Reclame & Communicatie"]
[10580000,0.1603,"Bouw & Installatietechniek"]
[11000000,0.1875,"Automotive, Transport & Logistiek"]
[11070578,0.15409999999999999,"Bouw & Installatietechniek"]
[11350000,0.14329999999999998,"Groothandel"]
[11425000,0.15,"Bouw & Installatietechniek"]
[11500000,0.16500000000000001,"Automotive, Transport & Logistiek"]
[12019000,0.15359999999999999,"Industrie & Productie"]
[12142400,0.1159,"Gezondheidszorg & Farmacie"]
[12542866,0.124,"Industrie & Productie"]
[13031000,0.13370000000000001,"Agri & Food"]
[13102000,9.4299999999999995E-2,"Industrie & Productie"]
[13156000,0.1457,"Industrie & Productie"]
[13283000,0.14185,"Zakelijke dienstverlening"]
[13568822,0.16189999999999999,"Groothandel"]
[14595374,0.124,"Bouw & Installatietechniek"]
[15024000,0.14549999999999999,"Groothandel"]
[15083000,0.10839600000000001,"Zakelijke dienstverlening"]
[15100000,0.14000000000000001,"Industrie & Productie"]
[15200000,0.182,"IT, Online & E-commerce"]
[15500000,0.12,"Industrie & Productie"]
[15577107,0.14000000000000001,"IT, Online & E-commerce"]
[15617000,0.15,"Groothandel"]
[15716000,0.17730000000000001,"IT, Online & E-commerce"]
[15761000,0.17849999999999999,"IT, Online & E-commerce"]
[16172000,0.13469999999999999,"Industrie & Productie"]
[16243000,0.15781875000000001,"Industrie & Productie"]
[16400000,0.10674350000000001,"IT, Online & E-commerce"]
[16482000,0.13750000000000001,"Groothandel"]
[16704004,0.17,"Bouw & Installatietechniek"]
[16800000,0.121,"Industrie & Productie"]
[16837000,0.1457,"Industrie & Productie"]
[17146000,0.14599999999999999,"Bouw & Installatietechniek"]
[17469284,0.15529999999999999,"Agri & Food"]
[17713921,0.1176,"Groothandel"]
[18276000,0.13189999999999999,"Agri & Food"]
[19050000,0.15,"Gezondheidszorg & Farmacie"]
[19090842,0.1,"Detailhandel"]
[19363000,0.13780249999999999,"Bouw & Installatietechniek"]
[20055000,0.14910000000000001,"IT, Online & E-commerce"]
[21706000,0.1852,"IT, Online & E-commerce"]
[23000000,0.13417750000000001,"Industrie & Productie"]
[23100000,0.123,"Bouw & Installatietechniek"]
[23164556,0.21033999999999997,"Automotive, Transport & Logistiek"]
[23594812,0.14299999999999999,"Industrie & Productie"]
[23677000,0.13059999999999999,"Industrie & Productie"]
[23678000,0.1268,"Industrie & Productie"]
[25000000,0.15,"Gezondheidszorg & Farmacie"]
[25000000,0.134825,"Gezondheidszorg & Farmacie"]
[25000000,0.11650000000000001,"Industrie & Productie"]
[25093841,0.13919999999999999,"Industrie & Productie"]
[25405000,0.113348,"Industrie & Productie"]
[26122000,0.1507,"Industrie & Productie"]
[26815000,0.1434,"Industrie & Productie"]
[26966229,0.16500000000000001,"Industrie & Productie"]
[28015000,0.10490700000000001,"Industrie & Productie"]
[28363000,0.12070149999999999,"Groothandel"]
[28735000,0.16839999999999999,"Zakelijke dienstverlening"]
[28902121,0.14099999999999999,"Industrie & Productie"]
[30000000,0.10149999999999999,"Groothandel"]
[33134913,0.18,"Industrie & Productie"]
[33700000,0.11652900000000001,"Industrie & Productie"]
[35992000,0.1658,"Zakelijke dienstverlening"]
[39407737,0.1391,"Industrie & Productie"]
[40000000,9.6499999999999989E-2,"Industrie & Productie"]
[41934000,0.13500000000000001,"Industrie & Productie"]
[42410000,0.1043,"Gezondheidszorg & Farmacie"]
[47749000,0.14879999999999999,"Automotive, Transport & Logistiek"]
[48115000,0.10389375000000002,"Automotive, Transport & Logistiek"]
[48610334,0.15060000000000001,"Bouw & Installatietechniek"]
[48767000,0.15670000000000001,"Detailhandel"]
[51492000,0.1484,"Industrie & Productie"]
[51655000,0.1643,"Industrie & Productie"]
[52100000,9.3092775000000003E-2,"Agri & Food"]
[56676427,0.13,"Industrie & Productie"]
[66500000,0.15,"Bouw & Installatietechniek"]
[73196000,0.1038,"Agri & Food"]
[82113000,9.5000000000000001E-2,"Groothandel"]
[83729000,0.10776124999999999,"Bouw & Installatietechniek"]
[129300000,0.12643099999999999,"Agri & Food"]
[]
[]
[]
[]
[]
[]
["Observaties niet getoond in spreidingsdiagram:"]
["Ondernemingswaarde 750.000.000","Keu 25%","Gezondheidszorg & Farmacie"]
["Ondernemingswaarde 169.000.000","Keu 16,40%","Groothandel"]
["Ondernemingswaarde 180.000.000","Keu 10,70%","Groothandel"]
["Ondernemingswaarde 109.900.000","Keu 20,8%","Horeca, Toerisme & Recreatie"]
["Ondernemingswaarde 132.732.000","Keu 14,10%","Industrie & Productie"]

{"sheet":"Resultaten gekozen Branche","index":7,"n_rows":76,"n_cols":2,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
["OW van gekozen Branche","Keu van gekozen Branche"]
[{"$f":"IFERROR(_xlfn._xlws.FILTER('Resultaten spreidingsdiagrammen'!A2:A384,'Resultaten spreidingsdiagrammen'!C2:C384='Keu referentiemodel'!B9),\"\")","v":""},{"$f":"IFERROR(_xlfn._xlws.FILTER('Resultaten spreidingsdiagrammen'!B2:B384,'Resultaten spreidingsdiagrammen'!C2:C384='Keu referentiemodel'!B9),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"_xlfn.XLOOKUP('Keu referentiemodel'!C13,'Resultaten grootte effect'!A3:A12,'Resultaten grootte effect'!D3:D12,\"\")","v":""},{"$f":"IF('Keu referentiemodel'!$B$11=\"Vul in\",\"\",IF('Keu referentiemodel'!$B$11=\"\",\"\",'Keu referentiemodel'!$E$9))","v":""}]