{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Toelichting","Cockpit","MJOP (2020-2049)","Prognose kasstromen","Parameters"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Toelichting","index":0,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[11,1,13,14]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Rekenmodel"]
[]
[null,"Project",null,"Voorbeeldmodel business case wooncoöperaties"]
[]
[null,"Dit rekenmodel is bedoeld ter onderbouwing van de business case van wooncoöperaties en ter ondersteuning van het financieringstraject met banken. De berekeningen zijn gebaseerd op best practices binnen het financieringslandschap en zijn gelieerd aan een door Finance Ideas uitgevoerd onderzoek voor het Ministerie van BZK. Het model biedt voornamelijk handvatten en inzichten voor wooncoöperaties die nog aan het begin van hun financieringstraject staan."]
[]
[]
[]
[]
[]
[null,"Tabblad",null,null,"Type tabblad",null,null,"Toelichting"]
[]
[null,"Cockpit",null,null,"Invoerblad",null,null,"Op dit tabblad worden alle uitgangspunten omtrent de investering en financiering opgenomen"]
[null,"MJOP (2020-2049)",null,null,"Invoerblad",null,null,"In plaats van een normbedrag voor onderhoud kan hier een volledige MJOP worden ingevuld"]
[null,"Prognose kasstromen",null,null,"Rekenblad",null,null,"Op dit tabblad worden de kasstromen in de business case geprognosticeerd"]
[null,"Parameters",null,null,"Hulpblad",null,null,"Op dit tabblad zijn de gehanteerde economische parameters opgenomen"]
[]
[]
[]
[null,"Blauwe gegevens",null,null,"Door u aan te passen input"]
[]
[null,"Zwarte gegevens",null,null,"Niet aan te passen parameters of formules"]
[]
[]
[null,"Hoe dient het rekenmodel geactiveerd te worden?"]
[]
[null,"Stap 1:","Schakel macro's in. Dit kan in Excel via tab 'bestand' en daarna \"Opties voor Excel\" en vervolgens het \"Vertrouwenscentrum\""]
[]
[null,"Stap 2:","Open het rekenmodel opnieuw als stap 1 nog niet was ingeschakeld"]
[]
[null,"Stap 3:","Vul alle blauwe cellen in met de voor u relevante data"]
[]
[]
[null,"Mocht de werking van het model niet het gewenste resultaat opleveren dan kunt u uiteraard contact opnemen met Finance Ideas: "]
[]
[]
[null,"T: +31 (0)30 232 0480"]
[]
[null,"Finance Ideas B.V."]
[null,"Weg der Verenigde Naties 1"]
[null,"3527 KT Utrecht"]
[null,"www.finance-ideas.nl"]

{"sheet":"Cockpit","index":1,"n_rows":85,"n_cols":31,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(\"Business case t.b.v. financieringsaanvraag - \",B4,)","v":"Business case t.b.v. financieringsaanvraag - Wooncoöperatie X"},null,{"$f":"CONCATENATE(\"Uitgangspunten \",B6)","v":"Uitgangspunten 2020"}]
["Uitgangspunten"]
["Algemeen"]
["Wooncoöperatie","Wooncoöperatie X"]
[]
["Beginjaar prognose",2020]
["Eindjaar prognose",{"$f":"B6+29","v":2049}]
[]
["Portefeuille","Sociale huur","Middenhuur"]
["Aantal verhuurde woningen  ",0,0,null,{"$f":"IF(B10+B11>50,\"Let op, meer dan 50 sociale huurwoningen. Er dient verhuurderheffing te worden betaald\",\"\")","v":""}]
["Aantal onverhuurde woningen",0,0]
["Totaal aantal woningen",{"$f":"SUM(B10:B11)","v":0},{"$f":"SUM(C10:C11)","v":0}]
[]
["WOZ-waarde per woning (prijspeil 1-1-2018)",0,0]
["Marktwaarde per woning (prijspeil 31-12-2019)",0,0]
["Renovatiebedrag per woning",0,0]
["Marktwaarde per woning na renovatie",0,0]
[]
["Opbrengsten wooncoöperatie"]
["Huuropbrengsten per woning per maand (prijspeil 31-12-2019)",0,0]
["Opbrengsten uit servicekosten per woning per maand (prijspeil 31-12-2019)",0,0]
["Huurverhoging bovenop inflatie",0,0]
["Huurderving",0,0]
[]
["Lasten wooncoöperatie"]
["Onderhoud per woning per jaar (prijspeil 31-12-2019)",0,0,"Let op! De MJOP kan ook op detailniveau worden ingevuld op het tabblad MJOP (2020-2049). Het onderhoud per woning wordt dan overschreven."]
["Beheerlasten per woning per jaar (prijspeil 31-12-2019)",0,0]
["Verzekeringskosten per woning per jaar (prijspeil 31-12-2019)",0,0]
["Belasting per woning per jaar (prijspeil 31-12-2019)",0,0]
["Erfpachtcanon per woning per jaar (prijspeil 31-12-2019)",0,0]
[]
["Investering"]
["Aankoop van woningen"]
["Aanschafprijs per woning",0,0]
["Overdrachtsbelasting per woning",0,0]
["Bijkomende kosten bij aankoop per woning",0,0]
["Totale investering (aankoop)",{"$f":"SUM(B34:B36)*B12","v":0},{"$f":"SUM(C34:C36)*C12","v":0}]
[]
["Nieuwbouw van woningen"]
["Stichtingskosten per woning",0,0]
["Bijkomende kosten bij nieuwbouw per woning",0,0]
["Totale investering (nieuwbouw)",{"$f":"SUM(B40:B41*B12)","v":0},{"$f":"SUM(C40:C41*C12)","v":0}]
[]
["Renovatie van woningen"]
["Renovatiebedrag (totaal)",0,0]
["Jaar van uitvoeren renovatie",{"$f":"B6","v":2020},{"$f":"B46+1","v":2021},{"$f":"C46+1","v":2022}]
[null,0.5,0.3,0.2]
["Totale investering (renovatie)",{"$f":"B45","v":0},{"$f":"C45","v":0}]
[]
["Financiering"]
["Totale financieringsbehoefte",{"$f":"B37+B48+B42+C42+C37+C48","v":0}]
[]
["Bancaire LTV-eis",0.75]
["Bancaire LLD-eis",0.06]
["Verstrekt door bank",{"$f":"MIN(IF(B53*(B17*B12+C17*C12)>B63,B63,B53*(B17*B12+C17*C12)),IFERROR(('Prognose kasstromen'!E7-SUM('Prognose kasstromen'!E10:E13))/B54,0))","v":0}]
["Type lening","Annuïtair"]
["Rentepercentage eerste 10 jaar",0.02]
["Rentepercentage ná herfinanciering",0.03]
["Looptijd (in jaren)",30]
[null,"Werkelijke LTV","Werkelijke LLD"]
[null,{"$f":"B55/(B17*B12+C17*C12)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(('Prognose kasstromen'!E7-SUM('Prognose kasstromen'!E10:E14))/B55,0)","v":0}]
[]
["Totale financieringsbehoefte",{"$f":"B37+B42+B48+C37+C42+C48","v":0}]
["Bancaire lening",{"$f":"B55","v":0}]
["Nog aan te trekken financiering",{"$f":"B63-B64","v":0}]
[]
["Overige vormen van financiering",{"$f":"B6","v":2020},{"$f":"B67+1","v":2021},{"$f":"C67+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
["Eigen inleg deelnemers",0]
["Aflossing",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rentelasten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Ontvangen subsidies",0]
["Aflossing",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rentelasten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Crowdfunding",0]
["Aflossing",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0]
["Rentelasten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Overig",0]
["Aflossing",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rentelasten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Nog niet gefinancierd",{"$f":"MAX(B65-B68-B72-B76-B80,0)","v":0}]

{"sheet":"MJOP (2020-2049)","index":2,"n_rows":30,"n_cols":34,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Meerjaren Onderhoudsprognose (MJOP) - Nominale bedragen"]
[null,null,null,null,{"$f":"Cockpit!B6","v":2020},{"$f":"E2+1","v":2021},{"$f":"F2+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
["Planmatig onderhoud",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Mutatieonderhoud",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Klachtenonderhoud",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 4",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 5",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 6",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 7",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 8",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 9",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 10",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 11",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 12",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 13",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 14",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 15",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 16",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 17",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 18",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 19",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 20",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 21",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 22",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 23",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 24",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 25",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Onderhoud 26",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Totale onderhoudsuitgaven",null,null,null,{"$f":"SUM(E3:E28)","v":0},{"$f":"SUM(F3:F28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Prognose kasstromen","index":3,"n_rows":44,"n_cols":34,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Kasstroomoverzicht"]
[null,null,null,null,{"$f":"Cockpit!B6","v":2020},{"$f":"E2+1","v":2021},{"$f":"F2+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,{"$f":"Z2+1","v":2042},2043,2044,2045,2046,2047,{"$f":"AF2+1","v":2048},2049]
[]
["Opbrengsten"]
["Huuropbrengsten",null,null,null,{"$f":"(1-Cockpit!B23)*(((Cockpit!B10*Cockpit!B20*12)*(1+Parameters!C4))+((Cockpit!C10*Cockpit!C20*12*(1+Parameters!C4))))","v":0},{"$f":"E5*(1+Parameters!D4)","v":0},{"$f":"F5*(1+Parameters!E4)","v":0},{"$f":"G5*(1+Parameters!F4)","v":0},{"$f":"H5*(1+Parameters!G4)","v":0},{"$f":"I5*(1+Parameters!H4)","v":0},{"$f":"J5*(1+Parameters!I4)","v":0},{"$f":"K5*(1+Parameters!J4)","v":0},{"$f":"L5*(1+Parameters!K4)","v":0},{"$f":"M5*(1+Parameters!L4)","v":0},{"$f":"N5*(1+Parameters!M4)","v":0},{"$f":"O5*(1+Parameters!N4)","v":0},{"$f":"P5*(1+Parameters!O4)","v":0},{"$f":"Q5*(1+Parameters!P4)","v":0},{"$f":"R5*(1+Parameters!Q4)","v":0},{"$f":"S5*(1+Parameters!R4)","v":0},{"$f":"T5*(1+Parameters!S4)","v":0},{"$f":"U5*(1+Parameters!T4)","v":0},{"$f":"V5*(1+Parameters!U4)","v":0},{"$f":"W5*(1+Parameters!V4)","v":0},{"$f":"X5*(1+Parameters!W4)","v":0},{"$f":"Y5*(1+Parameters!X4)","v":0},{"$f":"Z5*(1+Parameters!Y4)","v":0},{"$f":"AA5*(1+Parameters!Z4)","v":0},{"$f":"AB5*(1+Parameters!AA4)","v":0},{"$f":"AC5*(1+Parameters!AB4)","v":0},{"$f":"AD5*(1+Parameters!AC4)","v":0},{"$f":"AE5*(1+Parameters!AD4)","v":0},{"$f":"AF5*(1+Parameters!AE4)","v":0},{"$f":"AG5*(1+Parameters!AF4)","v":0}]
["Opbrengsten uit servicekosten",null,null,null,{"$f":"(1-Cockpit!B23)*((Cockpit!B10*Cockpit!B21*12)*(1+Parameters!C4)+(Cockpit!C10*Cockpit!C21*12)*(1+Parameters!C4))","v":0},{"$f":"E6*(1+Parameters!E3)","v":0},{"$f":"F6*(1+Parameters!F3)","v":0},{"$f":"G6*(1+Parameters!G3)","v":0},{"$f":"H6*(1+Parameters!H3)","v":0},{"$f":"I6*(1+Parameters!I3)","v":0},{"$f":"J6*(1+Parameters!J3)","v":0},{"$f":"K6*(1+Parameters!K3)","v":0},{"$f":"L6*(1+Parameters!L3)","v":0},{"$f":"M6*(1+Parameters!M3)","v":0},{"$f":"N6*(1+Parameters!N3)","v":0},{"$f":"O6*(1+Parameters!O3)","v":0},{"$f":"P6*(1+Parameters!P3)","v":0},{"$f":"Q6*(1+Parameters!Q3)","v":0},{"$f":"R6*(1+Parameters!R3)","v":0},{"$f":"S6*(1+Parameters!S3)","v":0},{"$f":"T6*(1+Parameters!T3)","v":0},{"$f":"U6*(1+Parameters!U3)","v":0},{"$f":"V6*(1+Parameters!V3)","v":0},{"$f":"W6*(1+Parameters!W3)","v":0},{"$f":"X6*(1+Parameters!X3)","v":0},{"$f":"Y6*(1+Parameters!Y3)","v":0},{"$f":"Z6*(1+Parameters!Z3)","v":0},{"$f":"AA6*(1+Parameters!AA3)","v":0},{"$f":"AB6*(1+Parameters!AB3)","v":0},{"$f":"AC6*(1+Parameters!AC3)","v":0},{"$f":"AD6*(1+Parameters!AD3)","v":0},{"$f":"AE6*(1+Parameters!AE3)","v":0},{"$f":"AF6*(1+Parameters!AF3)","v":0},{"$f":"AG6*(1+Parameters!AG3)","v":0}]
["Totaal opbrengsten",null,null,null,{"$f":"SUM(E5:E6)","v":0},{"$f":"SUM(F5:F6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Lasten"]
["Onderhoudslasten",null,null,null,{"$f":"IF(SUM('MJOP (2020-2049)'!E30:AH30)=0,(Cockpit!B12)*Cockpit!B26*(1+Parameters!D6)+(Cockpit!C12)*Cockpit!C26*(1+Parameters!D6),'MJOP (2020-2049)'!E30*(1+Parameters!D6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!E30:AH30)=0,E10*(1+Parameters!E6),'MJOP (2020-2049)'!F30*(1+Parameters!E6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!F30:AI30)=0,F10*(1+Parameters!F6),'MJOP (2020-2049)'!G30*(1+Parameters!F6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!G30:AJ30)=0,G10*(1+Parameters!G6),'MJOP (2020-2049)'!H30*(1+Parameters!G6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!H30:AK30)=0,H10*(1+Parameters!H6),'MJOP (2020-2049)'!I30*(1+Parameters!H6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!I30:AL30)=0,I10*(1+Parameters!I6),'MJOP (2020-2049)'!J30*(1+Parameters!I6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!J30:AM30)=0,J10*(1+Parameters!J6),'MJOP (2020-2049)'!K30*(1+Parameters!J6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!K30:AN30)=0,K10*(1+Parameters!K6),'MJOP (2020-2049)'!L30*(1+Parameters!K6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!L30:AO30)=0,L10*(1+Parameters!L6),'MJOP (2020-2049)'!M30*(1+Parameters!L6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!M30:AP30)=0,M10*(1+Parameters!M6),'MJOP (2020-2049)'!N30*(1+Parameters!M6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!N30:AQ30)=0,N10*(1+Parameters!N6),'MJOP (2020-2049)'!O30*(1+Parameters!N6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!O30:AR30)=0,O10*(1+Parameters!O6),'MJOP (2020-2049)'!P30*(1+Parameters!O6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!P30:AS30)=0,P10*(1+Parameters!P6),'MJOP (2020-2049)'!Q30*(1+Parameters!P6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!Q30:AT30)=0,Q10*(1+Parameters!Q6),'MJOP (2020-2049)'!R30*(1+Parameters!Q6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!R30:AU30)=0,R10*(1+Parameters!R6),'MJOP (2020-2049)'!S30*(1+Parameters!R6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!S30:AV30)=0,S10*(1+Parameters!S6),'MJOP (2020-2049)'!T30*(1+Parameters!S6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!T30:AW30)=0,T10*(1+Parameters!T6),'MJOP (2020-2049)'!U30*(1+Parameters!T6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!U30:AX30)=0,U10*(1+Parameters!U6),'MJOP (2020-2049)'!V30*(1+Parameters!U6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!V30:AY30)=0,V10*(1+Parameters!V6),'MJOP (2020-2049)'!W30*(1+Parameters!V6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!W30:AZ30)=0,W10*(1+Parameters!W6),'MJOP (2020-2049)'!X30*(1+Parameters!W6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!X30:BA30)=0,X10*(1+Parameters!X6),'MJOP (2020-2049)'!Y30*(1+Parameters!X6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!Y30:BB30)=0,Y10*(1+Parameters!Y6),'MJOP (2020-2049)'!Z30*(1+Parameters!Y6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!Z30:BC30)=0,Z10*(1+Parameters!Z6),'MJOP (2020-2049)'!AA30*(1+Parameters!Z6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AA30:BD30)=0,AA10*(1+Parameters!AA6),'MJOP (2020-2049)'!AB30*(1+Parameters!AA6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AB30:BE30)=0,AB10*(1+Parameters!AB6),'MJOP (2020-2049)'!AC30*(1+Parameters!AB6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AC30:BF30)=0,AC10*(1+Parameters!AC6),'MJOP (2020-2049)'!AD30*(1+Parameters!AC6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AD30:BG30)=0,AD10*(1+Parameters!AD6),'MJOP (2020-2049)'!AE30*(1+Parameters!AD6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AE30:BH30)=0,AE10*(1+Parameters!AE6),'MJOP (2020-2049)'!AF30*(1+Parameters!AE6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AF30:BI30)=0,AF10*(1+Parameters!AF6),'MJOP (2020-2049)'!AG30*(1+Parameters!AF6))","v":0},{"$f":"IF(SUM('MJOP (2020-2049)'!AG30:BJ30)=0,AG10*(1+Parameters!AG6),'MJOP (2020-2049)'!AH30*(1+Parameters!AG6))","v":0}]
["Beheerlasten",null,null,null,{"$f":"((Cockpit!B12)*Cockpit!B27+(Cockpit!C12)*Cockpit!C27)*(1+Parameters!D5)","v":0},{"$f":"E11*(1+Parameters!E5)","v":0},{"$f":"F11*(1+Parameters!F5)","v":0},{"$f":"G11*(1+Parameters!G5)","v":0},{"$f":"H11*(1+Parameters!H5)","v":0},{"$f":"I11*(1+Parameters!I5)","v":0},{"$f":"J11*(1+Parameters!J5)","v":0},{"$f":"K11*(1+Parameters!K5)","v":0},{"$f":"L11*(1+Parameters!L5)","v":0},{"$f":"M11*(1+Parameters!M5)","v":0},{"$f":"N11*(1+Parameters!N5)","v":0},{"$f":"O11*(1+Parameters!O5)","v":0},{"$f":"P11*(1+Parameters!P5)","v":0},{"$f":"Q11*(1+Parameters!Q5)","v":0},{"$f":"R11*(1+Parameters!R5)","v":0},{"$f":"S11*(1+Parameters!S5)","v":0},{"$f":"T11*(1+Parameters!T5)","v":0},{"$f":"U11*(1+Parameters!U5)","v":0},{"$f":"V11*(1+Parameters!V5)","v":0},{"$f":"W11*(1+Parameters!W5)","v":0},{"$f":"X11*(1+Parameters!X5)","v":0},{"$f":"Y11*(1+Parameters!Y5)","v":0},{"$f":"Z11*(1+Parameters!Z5)","v":0},{"$f":"AA11*(1+Parameters!AA5)","v":0},{"$f":"AB11*(1+Parameters!AB5)","v":0},{"$f":"AC11*(1+Parameters!AC5)","v":0},{"$f":"AD11*(1+Parameters!AD5)","v":0},{"$f":"AE11*(1+Parameters!AE5)","v":0},{"$f":"AF11*(1+Parameters!AF5)","v":0},{"$f":"AG11*(1+Parameters!AG5)","v":0}]
["Verhuurderheffing",null,null,null,{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!D8*Cockpit!$B$12,0)*Parameters!D13+(Cockpit!B45*Cockpit!B47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!D8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!E8*Cockpit!$B$12,0)*Parameters!E13+(Cockpit!B45*Cockpit!B47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!D8+(Cockpit!B45*Cockpit!C47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!E8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!F8*Cockpit!$B$12,0)*Parameters!F13+(Cockpit!B45*Cockpit!B47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!D8+(Cockpit!B45*Cockpit!C47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!E8+(Cockpit!B45*Cockpit!D47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!F8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!G8*Cockpit!$B$12,0)*Parameters!G13+(Cockpit!C45*Cockpit!C47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!E8+(Cockpit!C45*Cockpit!D47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!F8+(Cockpit!C45*Cockpit!E47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!G8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!H8*Cockpit!$B$12,0)*Parameters!H13+(Cockpit!D45*Cockpit!D47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!F8+(Cockpit!D45*Cockpit!E47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!G8+(Cockpit!D45*Cockpit!F47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!H8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!I8*Cockpit!$B$12,0)*Parameters!I13+(Cockpit!E45*Cockpit!E47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!G8+(Cockpit!E45*Cockpit!F47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!H8+(Cockpit!E45*Cockpit!G47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!I8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!J8*Cockpit!$B$12,0)*Parameters!J13+(Cockpit!F45*Cockpit!F47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!H8+(Cockpit!F45*Cockpit!G47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!I8+(Cockpit!F45*Cockpit!H47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!J8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!K8*Cockpit!$B$12,0)*Parameters!K13+(Cockpit!G45*Cockpit!G47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!I8+(Cockpit!G45*Cockpit!H47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!J8+(Cockpit!G45*Cockpit!I47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!K8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!L8*Cockpit!$B$12,0)*Parameters!L13+(Cockpit!H45*Cockpit!H47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!J8+(Cockpit!H45*Cockpit!I47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!K8+(Cockpit!H45*Cockpit!J47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!L8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!M8*Cockpit!$B$12,0)*Parameters!M13+(Cockpit!I45*Cockpit!I47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!K8+(Cockpit!I45*Cockpit!J47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!L8+(Cockpit!I45*Cockpit!K47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!M8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!N8*Cockpit!$B$12,0)*Parameters!N13+(Cockpit!J45*Cockpit!J47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!L8+(Cockpit!J45*Cockpit!K47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!M8+(Cockpit!J45*Cockpit!L47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!N8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!O8*Cockpit!$B$12,0)*Parameters!O13+(Cockpit!K45*Cockpit!K47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!M8+(Cockpit!K45*Cockpit!L47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!N8+(Cockpit!K45*Cockpit!M47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!O8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!P8*Cockpit!$B$12,0)*Parameters!P13+(Cockpit!L45*Cockpit!L47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!N8+(Cockpit!L45*Cockpit!M47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!O8+(Cockpit!L45*Cockpit!N47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!P8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!Q8*Cockpit!$B$12,0)*Parameters!Q13+(Cockpit!M45*Cockpit!M47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!O8+(Cockpit!M45*Cockpit!N47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!P8+(Cockpit!M45*Cockpit!O47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Q8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!R8*Cockpit!$B$12,0)*Parameters!R13+(Cockpit!N45*Cockpit!N47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!P8+(Cockpit!N45*Cockpit!O47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Q8+(Cockpit!N45*Cockpit!P47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!R8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!S8*Cockpit!$B$12,0)*Parameters!S13+(Cockpit!O45*Cockpit!O47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Q8+(Cockpit!O45*Cockpit!P47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!R8+(Cockpit!O45*Cockpit!Q47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!S8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!T8*Cockpit!$B$12,0)*Parameters!T13+(Cockpit!P45*Cockpit!P47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!R8+(Cockpit!P45*Cockpit!Q47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!S8+(Cockpit!P45*Cockpit!R47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!T8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!U8*Cockpit!$B$12,0)*Parameters!U13+(Cockpit!Q45*Cockpit!Q47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!S8+(Cockpit!Q45*Cockpit!R47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!T8+(Cockpit!Q45*Cockpit!S47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!U8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!V8*Cockpit!$B$12,0)*Parameters!V13+(Cockpit!R45*Cockpit!R47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!T8+(Cockpit!R45*Cockpit!S47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!U8+(Cockpit!R45*Cockpit!T47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!V8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!W8*Cockpit!$B$12,0)*Parameters!W13+(Cockpit!S45*Cockpit!S47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!U8+(Cockpit!S45*Cockpit!T47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!V8+(Cockpit!S45*Cockpit!U47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!W8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!X8*Cockpit!$B$12,0)*Parameters!X13+(Cockpit!T45*Cockpit!T47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!V8+(Cockpit!T45*Cockpit!U47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!W8+(Cockpit!T45*Cockpit!V47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!X8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!Y8*Cockpit!$B$12,0)*Parameters!Y13+(Cockpit!U45*Cockpit!U47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!W8+(Cockpit!U45*Cockpit!V47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!X8+(Cockpit!U45*Cockpit!W47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Y8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!Z8*Cockpit!$B$12,0)*Parameters!Z13+(Cockpit!V45*Cockpit!V47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!X8+(Cockpit!V45*Cockpit!W47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Y8+(Cockpit!V45*Cockpit!X47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Z8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AA8*Cockpit!$B$12,0)*Parameters!AA13+(Cockpit!W45*Cockpit!W47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Y8+(Cockpit!W45*Cockpit!X47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Z8+(Cockpit!W45*Cockpit!Y47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AA8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AB8*Cockpit!$B$12,0)*Parameters!AB13+(Cockpit!X45*Cockpit!X47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!Z8+(Cockpit!X45*Cockpit!Y47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AA8+(Cockpit!X45*Cockpit!Z47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AB8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AC8*Cockpit!$B$12,0)*Parameters!AC13+(Cockpit!Y45*Cockpit!Y47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AA8+(Cockpit!Y45*Cockpit!Z47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AB8+(Cockpit!Y45*Cockpit!AA47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AC8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AD8*Cockpit!$B$12,0)*Parameters!AD13+(Cockpit!Z45*Cockpit!Z47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AB8+(Cockpit!Z45*Cockpit!AA47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AC8+(Cockpit!Z45*Cockpit!AB47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AD8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AE8*Cockpit!$B$12,0)*Parameters!AE13+(Cockpit!AA45*Cockpit!AA47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AC8+(Cockpit!AA45*Cockpit!AB47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AD8+(Cockpit!AA45*Cockpit!AC47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AE8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AF8*Cockpit!$B$12,0)*Parameters!AF13+(Cockpit!AB45*Cockpit!AB47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AD8+(Cockpit!AB45*Cockpit!AC47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AE8+(Cockpit!AB45*Cockpit!AD47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AF8","v":{"$error":"#DIV/0!"}},{"$f":"IF(Cockpit!$B$12>50,Cockpit!$B$14*Parameters!AG8*Cockpit!$B$12,0)*Parameters!AG13+(Cockpit!AC45*Cockpit!AC47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AE8+(Cockpit!AC45*Cockpit!AD47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AF8+(Cockpit!AC45*Cockpit!AE47*((SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$17:$C$17)-SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15))/SUMPRODUCT(Cockpit!$B$12:$C$12,Cockpit!$B$15:$C$15)))*Parameters!AG8","v":{"$error":"#DIV/0!"}}]
["Belastingen en verzekeringen",null,null,null,{"$f":"((Cockpit!B12)*(Cockpit!B28+Cockpit!B29)+(Cockpit!C12)*(Cockpit!B28+Cockpit!B29))*(1+Parameters!D3)","v":0},{"$f":"E13*(1+Parameters!E3)","v":0},{"$f":"F13*(1+Parameters!F3)","v":0},{"$f":"G13*(1+Parameters!G3)","v":0},{"$f":"H13*(1+Parameters!H3)","v":0},{"$f":"I13*(1+Parameters!I3)","v":0},{"$f":"J13*(1+Parameters!J3)","v":0},{"$f":"K13*(1+Parameters!K3)","v":0},{"$f":"L13*(1+Parameters!L3)","v":0},{"$f":"M13*(1+Parameters!M3)","v":0},{"$f":"N13*(1+Parameters!N3)","v":0},{"$f":"O13*(1+Parameters!O3)","v":0},{"$f":"P13*(1+Parameters!P3)","v":0},{"$f":"Q13*(1+Parameters!Q3)","v":0},{"$f":"R13*(1+Parameters!R3)","v":0},{"$f":"S13*(1+Parameters!S3)","v":0},{"$f":"T13*(1+Parameters!T3)","v":0},{"$f":"U13*(1+Parameters!U3)","v":0},{"$f":"V13*(1+Parameters!V3)","v":0},{"$f":"W13*(1+Parameters!W3)","v":0},{"$f":"X13*(1+Parameters!X3)","v":0},{"$f":"Y13*(1+Parameters!Y3)","v":0},{"$f":"Z13*(1+Parameters!Z3)","v":0},{"$f":"AA13*(1+Parameters!AA3)","v":0},{"$f":"AB13*(1+Parameters!AB3)","v":0},{"$f":"AC13*(1+Parameters!AC3)","v":0},{"$f":"AD13*(1+Parameters!AD3)","v":0},{"$f":"AE13*(1+Parameters!AE3)","v":0},{"$f":"AF13*(1+Parameters!AF3)","v":0},{"$f":"AG13*(1+Parameters!AG3)","v":0}]
["Erfpachtcanon",null,null,null,{"$f":"((Cockpit!B12)*Cockpit!B30+(Cockpit!C12)*Cockpit!C30)*(1+Parameters!D3)","v":0},{"$f":"E14*(1+Parameters!E3)","v":0},{"$f":"F14*(1+Parameters!F3)","v":0},{"$f":"G14*(1+Parameters!G3)","v":0},{"$f":"H14*(1+Parameters!H3)","v":0},{"$f":"I14*(1+Parameters!I3)","v":0},{"$f":"J14*(1+Parameters!J3)","v":0},{"$f":"K14*(1+Parameters!K3)","v":0},{"$f":"L14*(1+Parameters!L3)","v":0},{"$f":"M14*(1+Parameters!M3)","v":0},{"$f":"N14*(1+Parameters!N3)","v":0},{"$f":"O14*(1+Parameters!O3)","v":0},{"$f":"P14*(1+Parameters!P3)","v":0},{"$f":"Q14*(1+Parameters!Q3)","v":0},{"$f":"R14*(1+Parameters!R3)","v":0},{"$f":"S14*(1+Parameters!S3)","v":0},{"$f":"T14*(1+Parameters!T3)","v":0},{"$f":"U14*(1+Parameters!U3)","v":0},{"$f":"V14*(1+Parameters!V3)","v":0},{"$f":"W14*(1+Parameters!W3)","v":0},{"$f":"X14*(1+Parameters!X3)","v":0},{"$f":"Y14*(1+Parameters!Y3)","v":0},{"$f":"Z14*(1+Parameters!Z3)","v":0},{"$f":"AA14*(1+Parameters!AA3)","v":0},{"$f":"AB14*(1+Parameters!AB3)","v":0},{"$f":"AC14*(1+Parameters!AC3)","v":0},{"$f":"AD14*(1+Parameters!AD3)","v":0},{"$f":"AE14*(1+Parameters!AE3)","v":0},{"$f":"AF14*(1+Parameters!AF3)","v":0},{"$f":"AG14*(1+Parameters!AG3)","v":0}]
["Rentelasten"]
["Rentelasten - Bancaire lening",null,null,null,{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-E25)*Cockpit!$B$57,(Cockpit!$B$55-E25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-F25)*Cockpit!$B$57,(Cockpit!$B$55-F25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-G25)*Cockpit!$B$57,(Cockpit!$B$55-G25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-H25)*Cockpit!$B$57,(Cockpit!$B$55-H25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-I25)*Cockpit!$B$57,(Cockpit!$B$55-I25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-J25)*Cockpit!$B$57,(Cockpit!$B$55-J25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-K25)*Cockpit!$B$57,(Cockpit!$B$55-K25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-L25)*Cockpit!$B$57,(Cockpit!$B$55-L25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-M25)*Cockpit!$B$57,(Cockpit!$B$55-M25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-N25)*Cockpit!$B$57,(Cockpit!$B$55-N25)*Cockpit!$B$57)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-O25)*Cockpit!$B$58,(Cockpit!$B$55-O25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-P25)*Cockpit!$B$58,(Cockpit!$B$55-P25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-Q25)*Cockpit!$B$58,(Cockpit!$B$55-Q25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-R25)*Cockpit!$B$58,(Cockpit!$B$55-R25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-S25)*Cockpit!$B$58,(Cockpit!$B$55-S25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-T25)*Cockpit!$B$58,(Cockpit!$B$55-T25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-U25)*Cockpit!$B$58,(Cockpit!$B$55-U25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-V25)*Cockpit!$B$58,(Cockpit!$B$55-V25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-W25)*Cockpit!$B$58,(Cockpit!$B$55-W25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-X25)*Cockpit!$B$58,(Cockpit!$B$55-X25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-Y25)*Cockpit!$B$58,(Cockpit!$B$55-Y25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-Z25)*Cockpit!$B$58,(Cockpit!$B$55-Z25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AA25)*Cockpit!$B$58,(Cockpit!$B$55-AA25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AB25)*Cockpit!$B$58,(Cockpit!$B$55-AB25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AC25)*Cockpit!$B$58,(Cockpit!$B$55-AC25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AD25)*Cockpit!$B$58,(Cockpit!$B$55-AD25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AE25)*Cockpit!$B$58,(Cockpit!$B$55-AE25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AF25)*Cockpit!$B$58,(Cockpit!$B$55-AF25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AG25)*Cockpit!$B$58,(Cockpit!$B$55-AG25)*Cockpit!$B$58)","v":0},{"$f":"IF(Cockpit!$B$56=\"Annuïteit\",(Cockpit!$B$55-AH25)*Cockpit!$B$58,(Cockpit!$B$55-AH25)*Cockpit!$B$58)","v":0}]
[{"$f":"CONCATENATE(\"Rentelasten - \",Cockpit!A68)","v":"Rentelasten - Eigen inleg deelnemers"},null,null,null,{"$f":"Cockpit!B70","v":0},{"$f":"Cockpit!C70","v":0},{"$f":"Cockpit!D70","v":0},{"$f":"Cockpit!E70","v":0},{"$f":"Cockpit!F70","v":0},{"$f":"Cockpit!G70","v":0},{"$f":"Cockpit!H70","v":0},{"$f":"Cockpit!I70","v":0},{"$f":"Cockpit!J70","v":0},{"$f":"Cockpit!K70","v":0},{"$f":"Cockpit!L70","v":0},{"$f":"Cockpit!M70","v":0},{"$f":"Cockpit!N70","v":0},{"$f":"Cockpit!O70","v":0},{"$f":"Cockpit!P70","v":0},{"$f":"Cockpit!Q70","v":0},{"$f":"Cockpit!R70","v":0},{"$f":"Cockpit!S70","v":0},{"$f":"Cockpit!T70","v":0},{"$f":"Cockpit!U70","v":0},{"$f":"Cockpit!V70","v":0},{"$f":"Cockpit!W70","v":0},{"$f":"Cockpit!X70","v":0},{"$f":"Cockpit!Y70","v":0},{"$f":"Cockpit!Z70","v":0},{"$f":"Cockpit!AA70","v":0},{"$f":"Cockpit!AB70","v":0},{"$f":"Cockpit!AC70","v":0},{"$f":"Cockpit!AD70","v":0},{"$f":"Cockpit!AE70","v":0}]
[{"$f":"CONCATENATE(\"Rentelasten - \",Cockpit!A72)","v":"Rentelasten - Ontvangen subsidies"},null,null,null,{"$f":"Cockpit!B74","v":0},{"$f":"Cockpit!C74","v":0},{"$f":"Cockpit!D74","v":0},{"$f":"Cockpit!E74","v":0},{"$f":"Cockpit!F74","v":0},{"$f":"Cockpit!G74","v":0},{"$f":"Cockpit!H74","v":0},{"$f":"Cockpit!I74","v":0},{"$f":"Cockpit!J74","v":0},{"$f":"Cockpit!K74","v":0},{"$f":"Cockpit!L74","v":0},{"$f":"Cockpit!M74","v":0},{"$f":"Cockpit!N74","v":0},{"$f":"Cockpit!O74","v":0},{"$f":"Cockpit!P74","v":0},{"$f":"Cockpit!Q74","v":0},{"$f":"Cockpit!R74","v":0},{"$f":"Cockpit!S74","v":0},{"$f":"Cockpit!T74","v":0},{"$f":"Cockpit!U74","v":0},{"$f":"Cockpit!V74","v":0},{"$f":"Cockpit!W74","v":0},{"$f":"Cockpit!X74","v":0},{"$f":"Cockpit!Y74","v":0},{"$f":"Cockpit!Z74","v":0},{"$f":"Cockpit!AA74","v":0},{"$f":"Cockpit!AB74","v":0},{"$f":"Cockpit!AC74","v":0},{"$f":"Cockpit!AD74","v":0},{"$f":"Cockpit!AE74","v":0}]
[{"$f":"CONCATENATE(\"Rentelasten - \",Cockpit!A76)","v":"Rentelasten - Crowdfunding"},null,null,null,{"$f":"Cockpit!B78","v":0},{"$f":"Cockpit!C78","v":0},{"$f":"Cockpit!D78","v":0},{"$f":"Cockpit!E78","v":0},{"$f":"Cockpit!F78","v":0},{"$f":"Cockpit!G78","v":0},{"$f":"Cockpit!H78","v":0},{"$f":"Cockpit!I78","v":0},{"$f":"Cockpit!J78","v":0},{"$f":"Cockpit!K78","v":0},{"$f":"Cockpit!L78","v":0},{"$f":"Cockpit!M78","v":0},{"$f":"Cockpit!N78","v":0},{"$f":"Cockpit!O78","v":0},{"$f":"Cockpit!P78","v":0},{"$f":"Cockpit!Q78","v":0},{"$f":"Cockpit!R78","v":0},{"$f":"Cockpit!S78","v":0},{"$f":"Cockpit!T78","v":0},{"$f":"Cockpit!U78","v":0},{"$f":"Cockpit!V78","v":0},{"$f":"Cockpit!W78","v":0},{"$f":"Cockpit!X78","v":0},{"$f":"Cockpit!Y78","v":0},{"$f":"Cockpit!Z78","v":0},{"$f":"Cockpit!AA78","v":0},{"$f":"Cockpit!AB78","v":0},{"$f":"Cockpit!AC78","v":0},{"$f":"Cockpit!AD78","v":0},{"$f":"Cockpit!AE78","v":0}]
[{"$f":"CONCATENATE(\"Rentelasten - \",Cockpit!A80)","v":"Rentelasten - Overig"},null,null,null,{"$f":"Cockpit!B82","v":0},{"$f":"Cockpit!C82","v":0},{"$f":"Cockpit!D82","v":0},{"$f":"Cockpit!E82","v":0},{"$f":"Cockpit!F82","v":0},{"$f":"Cockpit!G82","v":0},{"$f":"Cockpit!H82","v":0},{"$f":"Cockpit!I82","v":0},{"$f":"Cockpit!J82","v":0},{"$f":"Cockpit!K82","v":0},{"$f":"Cockpit!L82","v":0},{"$f":"Cockpit!M82","v":0},{"$f":"Cockpit!N82","v":0},{"$f":"Cockpit!O82","v":0},{"$f":"Cockpit!P82","v":0},{"$f":"Cockpit!Q82","v":0},{"$f":"Cockpit!R82","v":0},{"$f":"Cockpit!S82","v":0},{"$f":"Cockpit!T82","v":0},{"$f":"Cockpit!U82","v":0},{"$f":"Cockpit!V82","v":0},{"$f":"Cockpit!W82","v":0},{"$f":"Cockpit!X82","v":0},{"$f":"Cockpit!Y82","v":0},{"$f":"Cockpit!Z82","v":0},{"$f":"Cockpit!AA82","v":0},{"$f":"Cockpit!AB82","v":0},{"$f":"Cockpit!AC82","v":0},{"$f":"Cockpit!AD82","v":0},{"$f":"Cockpit!AE82","v":0}]
["Aflossingen"]
["Aflossing - Bancaire lening",null,null,null,{"$f":"E23+E24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Annuïtair",null,null,null,{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(E2-$E$2)))*(Cockpit!$B$55+E25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(F2-$E$2)))*(Cockpit!$B$55-F25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(G2-$E$2)))*(Cockpit!$B$55-G25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(H2-$E$2)))*(Cockpit!$B$55-H25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(I2-$E$2)))*(Cockpit!$B$55-I25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(J2-$E$2)))*(Cockpit!$B$55-J25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(K2-$E$2)))*(Cockpit!$B$55-K25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(L2-$E$2)))*(Cockpit!$B$55-L25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(M2-$E$2)))*(Cockpit!$B$55-M25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$57/(1-(1+Cockpit!$B$57)^(Cockpit!$B$59-(N2-$E$2)))*(Cockpit!$B$55-N25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(O2-$E$2)))*(Cockpit!$B$55-O25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(P2-$E$2)))*(Cockpit!$B$55-P25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(Q2-$E$2)))*(Cockpit!$B$55-Q25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(R2-$E$2)))*(Cockpit!$B$55-R25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(S2-$E$2)))*(Cockpit!$B$55-S25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(T2-$E$2)))*(Cockpit!$B$55-T25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(U2-$E$2)))*(Cockpit!$B$55-U25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(V2-$E$2)))*(Cockpit!$B$55-V25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(W2-$E$2)))*(Cockpit!$B$55-W25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(X2-$E$2)))*(Cockpit!$B$55-X25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(Y2-$E$2)))*(Cockpit!$B$55-Y25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(Z2-$E$2)))*(Cockpit!$B$55-Z25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AA2-$E$2)))*(Cockpit!$B$55-AA25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AB2-$E$2)))*(Cockpit!$B$55-AB25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AC2-$E$2)))*(Cockpit!$B$55-AC25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AD2-$E$2)))*(Cockpit!$B$55-AD25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AE2-$E$2)))*(Cockpit!$B$55-AE25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AF2-$E$2)))*(Cockpit!$B$55-AF25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AG2-$E$2)))*(Cockpit!$B$55-AG25),0),0)","v":0},{"$f":"IFERROR(-IF(Cockpit!$B$56=\"Annuïtair\",Cockpit!$B$58/(1-(1+Cockpit!$B$58)^(Cockpit!$B$59-(AH2-$E$2)))*(Cockpit!$B$55-AH25),0),0)","v":0}]
["Lineair",null,null,null,{"$f":"IFERROR(IF(E25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(F25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(G25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(H25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(I25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(J25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(K25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(L25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(M25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(N25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(O25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(P25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(Q25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(R25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(S25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(T25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(U25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(V25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(W25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(X25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(Y25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(Z25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AA25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AB25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AC25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AD25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AE25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AF25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AG25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0},{"$f":"IFERROR(IF(AH25>=Cockpit!$B$55,0,IF(Cockpit!$B$56=\"Lineair\",Cockpit!$B$55/Cockpit!$B$59,0)),0)","v":0}]
["Cumulatieve aflossing begin jaar",null,null,null,{"$f":"D25+D23+D24","v":0},{"$f":"E25+E23+E24","v":0},{"$f":"F25+F23+F24","v":0},{"$f":"G25+G23+G24","v":0},{"$f":"H25+H23+H24","v":0},{"$f":"I25+I23+I24","v":0},{"$f":"J25+J23+J24","v":0},{"$f":"K25+K23+K24","v":0},{"$f":"L25+L23+L24","v":0},{"$f":"M25+M23+M24","v":0},{"$f":"N25+N23+N24","v":0},{"$f":"O25+O23+O24","v":0},{"$f":"P25+P23+P24","v":0},{"$f":"Q25+Q23+Q24","v":0},{"$f":"R25+R23+R24","v":0},{"$f":"S25+S23+S24","v":0},{"$f":"T25+T23+T24","v":0},{"$f":"U25+U23+U24","v":0},{"$f":"V25+V23+V24","v":0},{"$f":"W25+W23+W24","v":0},{"$f":"X25+X23+X24","v":0},{"$f":"Y25+Y23+Y24","v":0},{"$f":"Z25+Z23+Z24","v":0},{"$f":"AA25+AA23+AA24","v":0},{"$f":"AB25+AB23+AB24","v":0},{"$f":"AC25+AC23+AC24","v":0},{"$f":"AD25+AD23+AD24","v":0},{"$f":"AE25+AE23+AE24","v":0},{"$f":"AF25+AF23+AF24","v":0},{"$f":"AG25+AG23+AG24","v":0}]
[{"$f":"CONCATENATE(\"Aflossing - \",Cockpit!A68)","v":"Aflossing - Eigen inleg deelnemers"},null,null,null,{"$f":"Cockpit!B69","v":0},{"$f":"Cockpit!C69","v":0},{"$f":"Cockpit!D69","v":0},{"$f":"Cockpit!E69","v":0},{"$f":"Cockpit!F69","v":0},{"$f":"Cockpit!G69","v":0},{"$f":"Cockpit!H69","v":0},{"$f":"Cockpit!I69","v":0},{"$f":"Cockpit!J69","v":0},{"$f":"Cockpit!K69","v":0},{"$f":"Cockpit!L69","v":0},{"$f":"Cockpit!M69","v":0},{"$f":"Cockpit!N69","v":0},{"$f":"Cockpit!O69","v":0},{"$f":"Cockpit!P69","v":0},{"$f":"Cockpit!Q69","v":0},{"$f":"Cockpit!R69","v":0},{"$f":"Cockpit!S69","v":0},{"$f":"Cockpit!T69","v":0},{"$f":"Cockpit!U69","v":0},{"$f":"Cockpit!V69","v":0},{"$f":"Cockpit!W69","v":0},{"$f":"Cockpit!X69","v":0},{"$f":"Cockpit!Y69","v":0},{"$f":"Cockpit!Z69","v":0},{"$f":"Cockpit!AA69","v":0},{"$f":"Cockpit!AB69","v":0},{"$f":"Cockpit!AC69","v":0},{"$f":"Cockpit!AD69","v":0},{"$f":"Cockpit!AE69","v":0}]
[{"$f":"CONCATENATE(\"Aflossing - \",Cockpit!A72)","v":"Aflossing - Ontvangen subsidies"},null,null,null,{"$f":"Cockpit!B73","v":0},{"$f":"Cockpit!C73","v":0},{"$f":"Cockpit!D73","v":0},{"$f":"Cockpit!E73","v":0},{"$f":"Cockpit!F73","v":0},{"$f":"Cockpit!G73","v":0},{"$f":"Cockpit!H73","v":0},{"$f":"Cockpit!I73","v":0},{"$f":"Cockpit!J73","v":0},{"$f":"Cockpit!K73","v":0},{"$f":"Cockpit!L73","v":0},{"$f":"Cockpit!M73","v":0},{"$f":"Cockpit!N73","v":0},{"$f":"Cockpit!O73","v":0},{"$f":"Cockpit!P73","v":0},{"$f":"Cockpit!Q73","v":0},{"$f":"Cockpit!R73","v":0},{"$f":"Cockpit!S73","v":0},{"$f":"Cockpit!T73","v":0},{"$f":"Cockpit!U73","v":0},{"$f":"Cockpit!V73","v":0},{"$f":"Cockpit!W73","v":0},{"$f":"Cockpit!X73","v":0},{"$f":"Cockpit!Y73","v":0},{"$f":"Cockpit!Z73","v":0},{"$f":"Cockpit!AA73","v":0},{"$f":"Cockpit!AB73","v":0},{"$f":"Cockpit!AC73","v":0},{"$f":"Cockpit!AD73","v":0},{"$f":"Cockpit!AE73","v":0}]
[{"$f":"CONCATENATE(\"Aflossing - \",Cockpit!A76)","v":"Aflossing - Crowdfunding"},null,null,null,{"$f":"Cockpit!B77","v":0},{"$f":"Cockpit!C77","v":0},{"$f":"Cockpit!D77","v":0},{"$f":"Cockpit!E77","v":0},{"$f":"Cockpit!F77","v":0},{"$f":"Cockpit!G77","v":0},{"$f":"Cockpit!H77","v":0},{"$f":"Cockpit!I77","v":0},{"$f":"Cockpit!J77","v":0},{"$f":"Cockpit!K77","v":0},{"$f":"Cockpit!L77","v":0},{"$f":"Cockpit!M77","v":0},{"$f":"Cockpit!N77","v":0},{"$f":"Cockpit!O77","v":0},{"$f":"Cockpit!P77","v":0},{"$f":"Cockpit!Q77","v":0},{"$f":"Cockpit!R77","v":0},{"$f":"Cockpit!S77","v":0},{"$f":"Cockpit!T77","v":0},{"$f":"Cockpit!U77","v":0},{"$f":"Cockpit!V77","v":0},{"$f":"Cockpit!W77","v":0},{"$f":"Cockpit!X77","v":0},{"$f":"Cockpit!Y77","v":0},{"$f":"Cockpit!Z77","v":0},{"$f":"Cockpit!AA77","v":0},{"$f":"Cockpit!AB77","v":0},{"$f":"Cockpit!AC77","v":0},{"$f":"Cockpit!AD77","v":0},{"$f":"Cockpit!AE77","v":0}]
[{"$f":"CONCATENATE(\"Aflossing - \",Cockpit!A80)","v":"Aflossing - Overig"},null,null,null,{"$f":"Cockpit!B81","v":0},{"$f":"Cockpit!C81","v":0},{"$f":"Cockpit!D81","v":0},{"$f":"Cockpit!E81","v":0},{"$f":"Cockpit!F81","v":0},{"$f":"Cockpit!G81","v":0},{"$f":"Cockpit!H81","v":0},{"$f":"Cockpit!I81","v":0},{"$f":"Cockpit!J81","v":0},{"$f":"Cockpit!K81","v":0},{"$f":"Cockpit!L81","v":0},{"$f":"Cockpit!M81","v":0},{"$f":"Cockpit!N81","v":0},{"$f":"Cockpit!O81","v":0},{"$f":"Cockpit!P81","v":0},{"$f":"Cockpit!Q81","v":0},{"$f":"Cockpit!R81","v":0},{"$f":"Cockpit!S81","v":0},{"$f":"Cockpit!T81","v":0},{"$f":"Cockpit!U81","v":0},{"$f":"Cockpit!V81","v":0},{"$f":"Cockpit!W81","v":0},{"$f":"Cockpit!X81","v":0},{"$f":"Cockpit!Y81","v":0},{"$f":"Cockpit!Z81","v":0},{"$f":"Cockpit!AA81","v":0},{"$f":"Cockpit!AB81","v":0},{"$f":"Cockpit!AC81","v":0},{"$f":"Cockpit!AD81","v":0},{"$f":"Cockpit!AE81","v":0}]
["Totaal lasten",null,null,null,{"$f":"SUM(E10:E14,E16:E20,E22,E26:E29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F10:F14,F16:F20,F22,F26:F29)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Netto kasstroom",null,null,null,{"$f":"E7-E30","v":{"$error":"#DIV/0!"}},{"$f":"F7-F30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Liquide middelen primo",null,null,null,{"$f":"Cockpit!B55+Cockpit!B68+Cockpit!B72+Cockpit!B76-Cockpit!B63","v":0},{"$f":"E35","v":{"$error":"#DIV/0!"}},{"$f":"F35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Liquide middelen ultimo",null,null,null,{"$f":"E34+E32","v":{"$error":"#DIV/0!"}},{"$f":"F34+F32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Schuldpositie ultimo",null,null,null,{"$f":"SUM(E38:E42)","v":0},{"$f":"SUM(F38:F42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Schuldpositie - Bancaire lening",null,null,null,{"$f":"MAX(Cockpit!B64-E22,0)","v":0},{"$f":"MAX(E38-F22,0)","v":0},{"$f":"MAX(F38-G22,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"CONCATENATE(\"Schuldpositie - \",Cockpit!A68)","v":"Schuldpositie - Eigen inleg deelnemers"},null,null,null,{"$f":"MAX(Cockpit!B68-E26,0)","v":0},{"$f":"MAX(E39-F26,0)","v":0},{"$f":"MAX(F39-G26,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"CONCATENATE(\"Schuldpositie - \",Cockpit!A72)","v":"Schuldpositie - Ontvangen subsidies"},null,null,null,{"$f":"MAX(Cockpit!B72-E27,0)","v":0},{"$f":"MAX(E40-F27,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"CONCATENATE(\"Schuldpositie - \",Cockpit!A76)","v":"Schuldpositie - Crowdfunding"},null,null,null,{"$f":"MAX(Cockpit!B76-E28,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"CONCATENATE(\"Schuldpositie - \",Cockpit!A80)","v":"Schuldpositie - Overig"},null,null,null,{"$f":"MAX(Cockpit!B80-E29,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Marktwaarde woningen",null,null,null,{"$f":"Cockpit!B17*Cockpit!B12+Cockpit!C17*Cockpit!C12","v":0},{"$f":"E44*(1+Parameters!E7)","v":0},{"$f":"F44*(1+Parameters!F7)","v":0},{"$f":"G44*(1+Parameters!G7)","v":0},{"$f":"H44*(1+Parameters!H7)","v":0},{"$f":"I44*(1+Parameters!I7)","v":0},{"$f":"J44*(1+Parameters!J7)","v":0},{"$f":"K44*(1+Parameters!K7)","v":0},{"$f":"L44*(1+Parameters!L7)","v":0},{"$f":"M44*(1+Parameters!M7)","v":0},{"$f":"N44*(1+Parameters!N7)","v":0},{"$f":"O44*(1+Parameters!O7)","v":0},{"$f":"P44*(1+Parameters!P7)","v":0},{"$f":"Q44*(1+Parameters!Q7)","v":0},{"$f":"R44*(1+Parameters!R7)","v":0},{"$f":"S44*(1+Parameters!S7)","v":0},{"$f":"T44*(1+Parameters!T7)","v":0},{"$f":"U44*(1+Parameters!U7)","v":0},{"$f":"V44*(1+Parameters!V7)","v":0},{"$f":"W44*(1+Parameters!W7)","v":0},{"$f":"X44*(1+Parameters!X7)","v":0},{"$f":"Y44*(1+Parameters!Y7)","v":0},{"$f":"Z44*(1+Parameters!Z7)","v":0},{"$f":"AA44*(1+Parameters!AA7)","v":0},{"$f":"AB44*(1+Parameters!AB7)","v":0},{"$f":"AC44*(1+Parameters!AC7)","v":0},{"$f":"AD44*(1+Parameters!AD7)","v":0},{"$f":"AE44*(1+Parameters!AE7)","v":0},{"$f":"AF44*(1+Parameters!AF7)","v":0},{"$f":"AG44*(1+Parameters!AG7)","v":0}]

{"sheet":"Parameters","index":4,"n_rows":13,"n_cols":34,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Hulpblad - Parameters"]
["Reeksen (2019)",null,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
["Prijsinflatie",null,2.5999999999999999E-2,1.0999999999999999E-2,1.2999999999999999E-2,0.01,0.01,1.4999999999999999E-2,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["Huurverhoging incl. inflatie",null,{"$f":"C3+Cockpit!$B$22","v":2.5999999999999999E-2},{"$f":"D3+Cockpit!$B$22","v":1.0999999999999999E-2},{"$f":"E3+Cockpit!$B$22","v":1.2999999999999999E-2},{"$f":"F3+Cockpit!$B$22","v":0.01},{"$f":"G3+Cockpit!$B$22","v":0.01},{"$f":"H3+Cockpit!$B$22","v":1.4999999999999999E-2},{"$f":"I3+Cockpit!$B$22","v":0.02},{"$f":"J3+Cockpit!$B$22","v":0.02},{"$f":"K3+Cockpit!$B$22","v":0.02},{"$f":"L3+Cockpit!$B$22","v":0.02},{"$f":"M3+Cockpit!$B$22","v":0.02},{"$f":"N3+Cockpit!$B$22","v":0.02},{"$f":"O3+Cockpit!$B$22","v":0.02},{"$f":"P3+Cockpit!$B$22","v":0.02},{"$f":"Q3+Cockpit!$B$22","v":0.02},{"$f":"R3+Cockpit!$B$22","v":0.02},{"$f":"S3+Cockpit!$B$22","v":0.02},{"$f":"T3+Cockpit!$B$22","v":0.02},{"$f":"U3+Cockpit!$B$22","v":0.02},{"$f":"V3+Cockpit!$B$22","v":0.02},{"$f":"W3+Cockpit!$B$22","v":0.02},{"$f":"X3+Cockpit!$B$22","v":0.02},{"$f":"Y3+Cockpit!$B$22","v":0.02},{"$f":"Z3+Cockpit!$B$22","v":0.02},{"$f":"AA3+Cockpit!$B$22","v":0.02},{"$f":"AB3+Cockpit!$B$22","v":0.02},{"$f":"AC3+Cockpit!$B$22","v":0.02},{"$f":"AD3+Cockpit!$B$22","v":0.02},{"$f":"AE3+Cockpit!$B$22","v":0.02},{"$f":"AF3+Cockpit!$B$22","v":0.02},{"$f":"AG3+Cockpit!$B$22","v":0.02},{"$f":"AH3+Cockpit!$B$22","v":0.02}]
["Loonstijging",null,2.5000000000000001E-2,2.3E-2,1.4E-2,1.9E-2,1.9E-2,1.9E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Onderhoudsindex",null,3.5000000000000003E-2,0.03,0.03,2.5000000000000001E-2,0.02,0.02,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Marktindex (o.b.v. DNB)",null,7.2000000000000008E-2,4.5999999999999999E-2,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["Verhuurderheffing",null,5.6100000000000004E-3,5.62E-3,5.62E-3,5.6299999999999996E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3,5.3699999999999998E-3]
["Reeksen - cumulatief",null,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
["Prijsinflatie - cumulatief",null,null,1,{"$f":"D10*(1+E3)","v":1.0129999999999999},1.0231299999999999,1.0333612999999999,1.0488617194999998,1.0698389538899999,1.0912357329678,1.1130604476271559,1.1353216565796991,1.1580280897112931,1.181188651505519,1.2048124245356293,1.2289086730263419,1.2534868464868687,1.2785565834166062,1.3041277150849384,1.3302102693866371,1.3568144747743698,1.3839507642698572,1.4116297795552544,1.4398623751463595,1.4686596226492867,1.4980328151022726,1.5279934714043182,1.5585533408324046,1.5897244076490527,1.6215188958020337,1.6539492737180743,1.6870282591924359,1.7207688243762846,1.7551842008638103]
["Looninflatie - cumulatief",null,null,1,{"$f":"D11*(1+E5)","v":1.014},1.033266,1.0528980539999999,1.0729031170259997,1.0997256949516496,1.1272188373254408,1.1553993082585767,1.1842842909650411,1.213891398239167,1.2442386831951462,1.2753446502750247,1.3072282665319002,1.3399089731951976,1.3734066975250774,1.4077418649632043,1.4429354115872843,1.4790087968769663,1.5159840167988903,1.5538836172188624,1.5927307076493338,1.6325489753405671,1.6733626997240811,1.7151967672171831,1.7580766863976125,1.8020286035575526,1.8470793186464913,1.8932563016126533,1.9405877091529695,1.9891024018817935,2.0388299619288381]
["Onderhoudsindex - cumulatief",null,null,1,{"$f":"D12*(1+E6)","v":1.03},1.05575,1.076865,1.0984023000000001,1.1258623575,1.1540089164374998,1.1828591393484371,1.212430617832148,1.2427413832779517,1.2738099178599003,1.3056551658063977,1.3382965449515576,1.3717539585753464,1.40604780753973,1.4411990027282231,1.4772289777964285,1.5141597022413391,1.5520136947973724,1.5908140371673065,1.630584388096489,1.6713489977989011,1.7131327227438735,1.7559610408124702,1.7998600668327818,1.8448565685036011,1.890977982716191,1.9382524322840955,1.9867087430911976,2.0363764616684774,2.0872858732101891]
["Marktindex (o.b.v. DNB) - cumulatief",null,null,1,{"$f":"D13*(1+E7)","v":1.02},1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548]