{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Overzicht","Activa","Passiva en eigen vermogen"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Overzicht","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
[{"$nulls":4}," "]
[null,null,{"$f":"\"Jaar \" & YEAR(TODAY())-1","v":"Jaar 2018"},{"$f":"\"Jaar \" & YEAR(TODAY())","v":"Jaar 2019"}]
[]
[null,"Balans","Jaar 1","Jaar 2"]
[null,"Totaal activa",{"$f":"Table_CurrentAssets[[#Totals],[Jaar 1]]+Table_FixedAssets[[#Totals],[Jaar 1]]+Table_OtherAssets[[#Totals],[Jaar 1]]","v":{"v":9545,"d":"€ 9,545.00"}},{"$f":"Table_CurrentAssets[[#Totals],[Jaar 2]]+Table_FixedAssets[[#Totals],[Jaar 2]]+Table_OtherAssets[[#Totals],[Jaar 2]]","v":{"v":12735,"d":"€ 12,735.00"}}]
[null,"Totaal passiva en eigen vermogen",{"$f":"Table_CurrentLiabilities[[#Totals],[Jaar 1]]+Table_LongTermLiabilities[[#Totals],[Jaar 1]]+Table_OwnersEquity[[#Totals],[Jaar 1]]","v":{"v":8540,"d":"€ 8,540.00"}},{"$f":"Table_CurrentLiabilities[[#Totals],[Jaar 2]]+Table_LongTermLiabilities[[#Totals],[Jaar 2]]+Table_OwnersEquity[[#Totals],[Jaar 2]]","v":{"v":6227,"d":"€ 6,227.00"}}]
[null,"Saldo",{"$f":"C5-C6","v":{"v":1005,"d":"€ 1,005.00"}},{"$f":"D5-D6","v":{"v":6508,"d":"€ 6,508.00"}}]

{"sheet":"Activa","index":1,"n_rows":21,"n_cols":5,"rows_kept":21}
[{"$nulls":4}," "]
[null,null,{"$f":"Voorgaand_Jaar","v":"Jaar 2018"},{"$f":"Huidige_Jaar","v":"Jaar 2019"}]
[null,"Huidige activa","Jaar 1","Jaar 2"]
[null,"Contanten",{"v":1000,"d":"€ 1,000.00"},{"v":1700,"d":"€ 1,700.00"}]
[null,"Investeringen",{"v":1500,"d":"€ 1,500.00"},{"v":2550,"d":"€ 2,550.00"}]
[null,"Overzichten",{"v":650,"d":"€ 650.00"},{"v":1250,"d":"€ 1,250.00"}]
[null,"Debiteuren",{"v":150,"d":"€ 150.00"},{"v":230,"d":"€ 230.00"}]
[null,"Vooruitbetaalde kosten",{"v":1230,"d":"€ 1,230.00"},{"v":950,"d":"€ 950.00"}]
[null,"Overig",{"v":120,"d":"€ 120.00"},{"v":120,"d":"€ 120.00"}]
[null,"Huidige activa",{"$f":"SUBTOTAL(109,Table_CurrentAssets[Jaar 1])","v":{"v":4650,"d":"€ 4,650.00"}},{"$f":"SUBTOTAL(109,Table_CurrentAssets[Jaar 2])","v":{"v":6800,"d":"€ 6,800.00"}}]
[]
[null,"Vaste activa","Jaar 1","Jaar 2"]
[null,"Onroerend goed en apparatuur",{"v":2500,"d":"€ 2,500.00"},{"v":2500,"d":"€ 2,500.00"}]
[null,"Huurverbeteringen",{"v":450,"d":"€ 450.00"},{"v":350,"d":"€ 350.00"}]
[null,"Vermogens- en andere investeringen",{"v":1250,"d":"€ 1,250.00"},{"v":1600,"d":"€ 1,600.00"}]
[null,"Minus samengevoegde afschrijving",{"v":545,"d":"€ 545.00"},{"v":1295,"d":"€ 1,295.00"}]
[null,"Totaal vaste activa",{"$f":"SUBTOTAL(109,Table_FixedAssets[Jaar 1])","v":{"v":4745,"d":"€ 4,745.00"}},{"$f":"SUBTOTAL(109,Table_FixedAssets[Jaar 2])","v":{"v":5745,"d":"€ 5,745.00"}}]
[]
[null,"Overige activa","Jaar 1","Jaar 2"]
[null,"Goodwill",{"v":150,"d":"€ 150.00"},{"v":190,"d":"€ 190.00"}]
[null,"Totaal overige activa",{"$f":"SUBTOTAL(109,Table_OtherAssets[Jaar 1])","v":{"v":150,"d":"€ 150.00"}},{"$f":"SUBTOTAL(109,Table_OtherAssets[Jaar 2])","v":{"v":190,"d":"€ 190.00"}}]

{"sheet":"Passiva en eigen vermogen","index":2,"n_rows":19,"n_cols":5,"rows_kept":19}
[{"$nulls":4}," "]
[null,null,{"$f":"Voorgaand_Jaar","v":"Jaar 2018"},{"$f":"Huidige_Jaar","v":"Jaar 2019"}]
[null,"Huidige passiva","Jaar 1","Jaar 2"]
[null,"Crediteuren",{"v":180,"d":"€ 180.00"},{"v":252,"d":"€ 252.00"}]
[null,"Opgebouwde salarissen",{"v":250,"d":"€ 250.00"},{"v":370,"d":"€ 370.00"}]
[null,"Opgebouwde compensatie",{"v":240,"d":"€ 240.00"},{"v":190,"d":"€ 190.00"}]
[null,"Verrekenbare belasting ",{"v":120,"d":"€ 120.00"},{"v":130,"d":"€ 130.00"}]
[null,"Inkomsten uit vermogen",{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"}]
[null,"Overig",{"v":250,"d":"€ 250.00"},{"v":235,"d":"€ 235.00"}]
[null,"Huidige passiva",{"$f":"SUBTOTAL(109,Table_CurrentLiabilities[Jaar 1])","v":{"v":1040,"d":"€ 1,040.00"}},{"$f":"SUBTOTAL(109,Table_CurrentLiabilities[Jaar 2])","v":{"v":1177,"d":"€ 1,177.00"}}]
[]
[null,"Langlopende passiva","Jaar 1","Jaar 2"]
[null,"Hypotheekbetalingen",{"v":1500,"d":"€ 1,500.00"},{"v":1900,"d":"€ 1,900.00"}]
[null,"Totaal langlopende passiva",{"$f":"SUBTOTAL(109,Table_LongTermLiabilities[Jaar 1])","v":{"v":1500,"d":"€ 1,500.00"}},{"$f":"SUBTOTAL(109,Table_LongTermLiabilities[Jaar 2])","v":{"v":1900,"d":"€ 1,900.00"}}]
[]
[null,"Eigen vermogen","Jaar 1","Jaar 2"]
[null,"Investeringskapitaal",{"v":5500,"d":"€ 5,500.00"},{"v":2500,"d":"€ 2,500.00"}]
[null,"Opgebouwde ingehouden winsten",{"v":500,"d":"€ 500.00"},{"v":650,"d":"€ 650.00"}]
[null,"Totaal eigen vermogen",{"$f":"SUBTOTAL(109,Table_OwnersEquity[Jaar 1])","v":{"v":6000,"d":"€ 6,000.00"}},{"$f":"SUBTOTAL(109,Table_OwnersEquity[Jaar 2])","v":{"v":3150,"d":"€ 3,150.00"}}]