Uitwisselprofiel Zorgkantoren Inkoopondersteuning en beleidsontwikkeling
23.2 - Kapitaal, Net-debt / EBITDA
Concepten
Relaties
Eigenschappen
SPARQL query
Code gekopieerd
...Kopieer naar klembord
1# Indicator: Zorgkantoren 23.2.0 2# Parameters: $(peildatum) 3# Ontologie: 4 5PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 6PREFIX onz-fin: <http://purl.org/ozo/onz-fin#> 7PREFIX onz-g: <http://purl.org/ozo/onz-g#> 8PREFIX time: <http://www.w3.org/2006/time#> 9 10SELECT 11 ("Net-debt / EBITDA" as ?kental) 12 (IF(?ebitda != 0, ?vreemd_vermogen / ?ebitda,'ongedefineerd') AS ?waarde) 13WHERE{ 14 { 15 SELECT 16 (SUM(?bedrag_F_sum) + SUM(?bedrag_G_sum) AS ?vreemd_vermogen) 17 (SUM(?bedrag_P_sum) - SUM(?bedrag_Q_sum) + SUM(?bedrag_Q6_sum) AS ?ebitda) 18 { 19 ?grootboek_post 20 a onz-fin:Grootboekpost ; 21 onz-g:partOf ?rubriek ; 22 onz-g:hasDate ?datum ; 23 onz-g:isAbout [ 24 a onz-g:FinancialEntity ; 25 onz-g:hasQuality / onz-g:hasQualityValue / onz-g:hasDataValue ?geld_bedrag 26 ] . 27 28 # Teller: Vreemd vermogen op peildatum 31-dec van het voorgaande jaar of 30-jun van het lopende jaar. 29 # Noemer: EBITDA over de meetperiode 1-jan t/m 31-dec van het voorgaande jaar of 1-jan t/m 30-jun van het lopende jaar. 30 # Net-debt / EBITDA = ("F Langlopende schulden (nog voor meer dan een jaar)" + "G Kortlopende schulden (ten hoogste 1 jaar)") / EBITDA [zie Indicator 19.6] 31 32 BIND($(peildatum) AS ?peildatum) 33 #BIND("2024-06-30"^^xsd:date AS ?peildatum) 34 BIND(?peildatum AS ?eind_periode) 35 BIND (xsd:date(CONCAT(STR(YEAR(?peildatum)), '-01-01')) AS ?start_periode) 36 37 FILTER(?datum <= ?eind_periode) # eind periode = peildatum 38 39 # "F Langlopende schulden (nog voor meer dan een jaar)" 40 BIND(IF(?rubriek in ( 41 onz-fin:071100, onz-fin:071200, onz-fin:071210, onz-fin:071220, onz-fin:072100, onz-fin:072200, onz-fin:072300, 42 onz-fin:072900, onz-fin:073100, onz-fin:073200), ?geld_bedrag, 0) 43 AS ?bedrag_F_sum) 44 45 # "G Kortlopende schulden (ten hoogste 1 jaar)" 46 BIND(IF(?rubriek in ( 47 onz-fin:141010, onz-fin:141020, onz-fin:141110, onz-fin:141120, onz-fin:151100, onz-fin:151200, onz-fin:151300, 48 onz-fin:151400, onz-fin:152100, onz-fin:152210, onz-fin:152220, onz-fin:152310, onz-fin:152320, onz-fin:152410, 49 onz-fin:152420, onz-fin:152610, onz-fin:152620, onz-fin:152710, onz-fin:152720, onz-fin:152900, onz-fin:153100, 50 onz-fin:153200, onz-fin:153300, onz-fin:154100, onz-fin:154200, onz-fin:155000, onz-fin:158100, onz-fin:158200, 51 onz-fin:158310, onz-fin:158320, onz-fin:158330), ?geld_bedrag, 0) 52 AS ?bedrag_G_sum) 53 54 55 # EBITDA = "P Som der bedrijfsopbrengsten" - "Q Som der bedrijfslasten" + "Q.VI Afschrijvingen op immateriële vaste activa en materiële vaste activa" 56 BIND(IF(?rubriek IN ( 57 # P.I Netto omzet 58 onz-fin:811000, 59 60 # P.II, P.II leeg 61 # P.IV Overige bedrijfsopbrengsten 62 onz-fin:821000, onz-fin:822000, onz-fin:825000, onz-fin:826000, onz-fin:827000, onz-fin:828000, onz-fin:829000, 63 onz-fin:831000, onz-fin:832000, onz-fin:833000, onz-fin:835000, 64 onz-fin:891000, onz-fin:919000, onz-fin:920000, onz-fin:930000 65 ) && ?datum >= ?start_periode, ?geld_bedrag, 0) AS ?bedrag_P_sum) 66 67 BIND(IF(?rubriek IN ( 68 # Q.VI Afschrijvingen op immateriële vaste activa en materiële vaste activa 69 onz-fin:480012, onz-fin:480022, onz-fin:480032, onz-fin:480112, onz-fin:480122, onz-fin:480132, onz-fin:480532, onz-fin:480632, 70 onz-fin:480932, 71 onz-fin:481212, onz-fin:481222, onz-fin:481232, onz-fin:481242, onz-fin:481252, 72 onz-fin:482112, onz-fin:482122, onz-fin:482132, onz-fin:482142, onz-fin:482152, onz-fin:482212, onz-fin:482222, onz-fin:482232, 73 onz-fin:482242, onz-fin:482252, onz-fin:482312, onz-fin:482322, onz-fin:482332, onz-fin:482342, onz-fin:482352, onz-fin:482412, 74 onz-fin:482422, onz-fin:482432, onz-fin:482442, onz-fin:482452, 75 onz-fin:483112, onz-fin:483122, onz-fin:483132, onz-fin:483142, onz-fin:483152, 76 onz-fin:484112, onz-fin:484122, onz-fin:484132, onz-fin:484222, onz-fin:484232, onz-fin:484322, onz-fin:484332 77 78 ) && ?datum >= ?start_periode, ?geld_bedrag, 0) AS ?bedrag_Q6_sum) 79 80 BIND(IF(?rubriek IN ( # "Q Som der bedrijfslasten" 81 # Q.I leeg 82 # Q.II 83 onz-fin:417000, 84 onz-fin:418000, onz-fin:418100, onz-fin:418200, 85 86 # Q.III 87 onz-fin:411000, onz-fin:411100, onz-fin:411200, onz-fin:411300, onz-fin:411400, onz-fin:411500, onz-fin:411600, onz-fin:411700, 88 onz-fin:412000, onz-fin:412100, onz-fin:412200, onz-fin:412300, onz-fin:412400, onz-fin:412500, 89 onz-fin:413000, onz-fin:413100, onz-fin:413200, onz-fin:413300, onz-fin:413400, onz-fin:413500, onz-fin:413600, onz-fin:413610, 90 onz-fin:413620, onz-fin:413700, onz-fin:414000, onz-fin:414100, onz-fin:414101, onz-fin:414102, onz-fin:414103, onz-fin:414104, 91 onz-fin:414110, onz-fin:414111, onz-fin:414112, onz-fin:414113, onz-fin:414114, onz-fin:414200, onz-fin:414202, onz-fin:414203, 92 onz-fin:414204, onz-fin:414300, onz-fin:414500, onz-fin:414503, onz-fin:414504, onz-fin:414700, onz-fin:414800, 93 onz-fin:415000, onz-fin:416000, 94 onz-fin:419000, onz-fin:419100, onz-fin:419101, onz-fin:419200, onz-fin:419500, 95 96 # Q.IV 97 onz-fin:420000, onz-fin:420100, onz-fin:422100, onz-fin:422300, onz-fin:422400, onz-fin:422410, onz-fin:422500, onz-fin:422900, 98 99 # Q.V 100 onz-fin:422600, 101 102 # Q.VI 103 onz-fin:480012, onz-fin:480022, onz-fin:480032, onz-fin:480112, onz-fin:480122, onz-fin:480132, onz-fin:480532, onz-fin:480632, 104 onz-fin:480932, 105 onz-fin:481212, onz-fin:481222, onz-fin:481232, onz-fin:481242, onz-fin:481252, 106 onz-fin:482112, onz-fin:482122, onz-fin:482132, onz-fin:482142, onz-fin:482152, onz-fin:482212, onz-fin:482222, onz-fin:482232, 107 onz-fin:482242, onz-fin:482252, onz-fin:482312, onz-fin:482322, onz-fin:482332, onz-fin:482342, onz-fin:482352, onz-fin:482412, 108 onz-fin:482422, onz-fin:482432, onz-fin:482442, onz-fin:482452, 109 onz-fin:483112, onz-fin:483122, onz-fin:483132, onz-fin:483142, onz-fin:483152, 110 onz-fin:484112, onz-fin:484122, onz-fin:484132, onz-fin:484222, onz-fin:484232, onz-fin:484322, onz-fin:484332, 111 112 # Q.VII, Q.VIII leeg 113 # Q.IX 114 onz-fin:423100, onz-fin:423110, onz-fin:423120, onz-fin:423140, onz-fin:423190, onz-fin:423200, onz-fin:423210, onz-fin:423220, 115 onz-fin:423300, onz-fin:423400, onz-fin:423410, onz-fin:423420, onz-fin:423500, onz-fin:423510, onz-fin:423520, onz-fin:423600, 116 onz-fin:423700, onz-fin:423900, onz-fin:423910, onz-fin:423920, 117 onz-fin:431000, onz-fin:431100, onz-fin:431200, onz-fin:431300, onz-fin:432000, onz-fin:433000, 118 onz-fin:441000, onz-fin:441100, onz-fin:441200, onz-fin:441300, onz-fin:441400, onz-fin:441900, onz-fin:442000, onz-fin:442100, 119 onz-fin:442200, onz-fin:443000, onz-fin:443100, onz-fin:443200, onz-fin:443300, onz-fin:444000, onz-fin:444100, onz-fin:445000, 120 onz-fin:445100, onz-fin:445200, onz-fin:449000, 121 onz-fin:451000, onz-fin:451100, onz-fin:451200, onz-fin:451300, onz-fin:451400, onz-fin:451500, onz-fin:451600, onz-fin:452000, 122 onz-fin:452100, onz-fin:452200, onz-fin:452900, onz-fin:453000, onz-fin:453100, onz-fin:453200, onz-fin:453300, onz-fin:453900, 123 onz-fin:453910, onz-fin:453920, onz-fin:453930, onz-fin:453990, onz-fin:454000, onz-fin:454100, onz-fin:454200, onz-fin:454210, 124 onz-fin:454220, onz-fin:454290, onz-fin:455000, onz-fin:455100, onz-fin:459000, onz-fin:459100, onz-fin:459300, onz-fin:459900, 125 onz-fin:461000, onz-fin:461100, onz-fin:461200, onz-fin:462000, onz-fin:462100, onz-fin:462200, onz-fin:462300, onz-fin:462400, 126 onz-fin:462500, onz-fin:462600, onz-fin:462700, onz-fin:462800, onz-fin:462900, onz-fin:463000, onz-fin:463100, onz-fin:463200, 127 onz-fin:463900, onz-fin:464000, onz-fin:464100, onz-fin:464200, onz-fin:464300, onz-fin:464900, onz-fin:465000, onz-fin:465100, 128 onz-fin:465200, onz-fin:465300, onz-fin:465400, onz-fin:465900, onz-fin:466000, onz-fin:467100, onz-fin:467110, onz-fin:467120, 129 onz-fin:467200, onz-fin:468000, 130 onz-fin:471100, onz-fin:471200, onz-fin:471300, onz-fin:471400, onz-fin:472000, onz-fin:473000, onz-fin:473100, onz-fin:473200, 131 onz-fin:473300, onz-fin:473400, onz-fin:473500, onz-fin:473600, onz-fin:473900, 132 onz-fin:486115, onz-fin:486125, onz-fin:486135, onz-fin:486215, onz-fin:486225, onz-fin:486235, onz-fin:486315, onz-fin:486325, 133 onz-fin:486335, onz-fin:486415, onz-fin:486425, onz-fin:486435, onz-fin:486515, onz-fin:486525, onz-fin:486535, onz-fin:486615, 134 onz-fin:486625, onz-fin:486635, onz-fin:486725, onz-fin:486735, onz-fin:486825, onz-fin:486835, 135 onz-fin:489150, onz-fin:489211, onz-fin:489212, onz-fin:489221, onz-fin:489222, onz-fin:489230, 136 onz-fin:905000, 137 onz-fin:911000, onz-fin:912000, onz-fin:913000, onz-fin:914000, onz-fin:915000, 138 onz-fin:921000, onz-fin:931000 139 ) && ?datum >= ?start_periode, ?geld_bedrag, 0) AS ?bedrag_Q_sum) 140 } 141 } 142} 143
Heb je feedback?
Loopt u tegen een issue of vraag aan bij het KIK-V product? Neem dan contact met ons op!