{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Modèles","BP1","BP2","BP3","Titres"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":3,"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":"Modèles","index":0,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,10]]}
[{"$f":"+REPT(\"-\",300)","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GCO F"]
[null,"GCO Belgique seule",null,null,null,null,"GCO Belgique+GCO France (2M€ en 09)"]
["EXPLOITATION en K€",2005,2006,2007,2008,null,2009,{"$f":"G4+1","v":2010},{"$f":"H4+1","v":2011},{"$f":"I4+1","v":2012},{"$f":"J4+1","v":2013},null,null,2009]
["CA",{"$f":"'[1]Data GCO'!D5","v":2180},{"$f":"'[1]Data GCO'!E5","v":4349},{"$f":"'[1]Analytique GCO'!C26","v":5530},{"$f":"'[1]Analytique GCO'!D26","v":5700},0.05,{"$f":"E5*(1+$F$5)+N5","v":7985},{"$f":"G5*(1+$F$5)","v":8384.25},{"$f":"H5*(1+$F$5)","v":8803.4624999999996},{"$f":"I5*(1+$F$5)","v":9243.6356250000008},{"$f":"J5*(1+$F$5)","v":9705.817406250002},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C5","v":2000}]
["Autres produits",null,null,{"$f":"'[1]Analytique GCO'!C27","v":0},{"$f":"'[1]Analytique GCO'!D27","v":0},null,null,null,null,null,null,null,null,{"$f":"'[1]synergies TSF GCO ATD'!C6","v":0}]
["Coût des ventes",null,null,{"$f":"'[1]Analytique GCO'!C28","v":3838.5},{"$f":"'[1]Analytique GCO'!D28","v":3933},null,{"$f":"G5-G9","v":5485.6949999999997},{"$f":"H5-H9","v":5734.8269999999993},{"$f":"I5-I9","v":5995.1579624999995},{"$f":"J5-J9","v":6267.1849537500002},{"$f":"K5-K9","v":6551.4267492187519},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C7","v":1380}]
["MB%",null,null,{"$f":"'[1]Analytique GCO'!C29","v":0.30587703435804703},{"$f":"'[1]Analytique GCO'!D29","v":0.31},3.0000000000000001E-3,{"$f":"E8+$F$8","v":0.313},{"$f":"G8+$F$8","v":0.316},{"$f":"H8+$F$8","v":0.31900000000000001},{"$f":"I8+$F$8","v":0.32200000000000001},{"$f":"J8+$F$8","v":0.32500000000000001},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C8","v":0.31}]
["Marge brute",{"$f":"'[1]Data GCO'!D9","v":673.7},{"$f":"'[1]Data GCO'!E9","v":1328},{"$f":"'[1]Analytique GCO'!C30","v":1691.5},{"$f":"'[1]Analytique GCO'!D30","v":1767},null,{"$f":"G8*G5","v":2499.3049999999998},{"$f":"H8*H5","v":2649.4230000000002},{"$f":"I8*I5","v":2808.3045375000002},{"$f":"J8*J5","v":2976.4506712500001},{"$f":"K8*K5","v":3154.3906570312506},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C9","v":620}]
["Logistique",null,null,{"$f":"'[1]Analytique GCO'!C31","v":327.90700000000004},{"$f":"'[1]Analytique GCO'!D31","v":200},null,{"$f":"E10/E5*G5","v":280.17543859649123},{"$f":"G10/G5*H5","v":294.18421052631578},{"$f":"H10/H5*I5","v":308.89342105263154},{"$f":"I10/I5*J5","v":324.33809210526317},{"$f":"J10/J5*K5","v":340.55499671052638},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C10","v":70.175438596491219}]
["Force de vente",null,null,{"$f":"'[1]Analytique GCO'!C32","v":432.55500000000006},{"$f":"'[1]Analytique GCO'!D32","v":600},"moitié",{"$f":"E11*(1+$F$5/2)+N11","v":815},{"$f":"G11*(1+$F$5/2)","v":835.37499999999989},{"$f":"H11*(1+$F$5/2)","v":856.25937499999986},{"$f":"I11*(1+$F$5/2)","v":877.66585937499974},{"$f":"J11*(1+$F$5/2)","v":899.60750585937467},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C11","v":200}]
["Marketing",null,null,{"$f":"'[1]Analytique GCO'!C33","v":49.666499999999999},{"$f":"'[1]Analytique GCO'!D33","v":40},"prop",{"$f":"E12*(1+$F$5)+N12","v":62},{"$f":"G12*(1+$F$5)","v":65.100000000000009},68.355000000000018,71.772750000000016,75.361387500000021,null,null,{"$f":"'[1]synergies TSF GCO ATD'!C12","v":20}]
["FGx 1 (AACE Siège)",null,null,{"$f":"'[1]Analytique GCO'!C34","v":118.93550000000006},{"$f":"'[1]Analytique GCO'!D34","v":130},"prop",{"$f":"E13*(1+$F$5)+N13","v":236.5},248.32500000000002,260.74125000000004,273.77831250000003,287.46722812500002,null,null,{"$f":"'[1]synergies TSF GCO ATD'!C13","v":100}]
["FGx 2 (salaires siège)",null,null,{"$f":"'[1]Analytique GCO'!C35","v":397.8},{"$f":"'[1]Analytique GCO'!D35","v":330},"moitié",{"$f":"E14*(1+$F$5)+N14","v":496.5},{"$f":"G14*(1+$F$5/2)","v":508.91249999999997},{"$f":"H14*(1+$F$5/2)","v":521.63531249999994},{"$f":"I14*(1+$F$5/2)","v":534.67619531249989},{"$f":"J14*(1+$F$5/2)","v":548.04310019531238},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C14","v":150}]
["Impôts et Taxes",null,null,{"$f":"'[1]Analytique GCO'!C36","v":0},{"$f":"'[1]Analytique GCO'!D36","v":0},null,{"$f":"N15","v":25},{"$f":"G15/G5*H5","v":26.25},{"$f":"H15/H5*I5","v":27.5625},{"$f":"I15/I5*J5","v":28.940625000000001},{"$f":"J15/J5*K5","v":30.387656250000006},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C15","v":25}]
["Autres charges",null,null,{"$f":"'[1]Analytique GCO'!C37","v":0},{"$f":"'[1]Analytique GCO'!D37","v":0},null,null,null,null,null,null,null,null,{"$f":"'[1]synergies TSF GCO ATD'!C16","v":0}]
["Charges d'exploitation",{"$f":"'[1]Data GCO'!D14","v":692.2},{"$f":"'[1]Data GCO'!E14","v":1148.5999999999999},{"$f":"'[1]Analytique GCO'!C38","v":1326.8640000000003},{"$f":"'[1]Analytique GCO'!D38","v":1300},null,{"$f":"SUM(G10:G16)","v":1915.1754385964912},{"$f":"SUM(H10:H16)","v":1978.1467105263155},{"$f":"SUM(I10:I16)","v":2043.4468585526315},{"$f":"SUM(J10:J16)","v":2111.1718342927634},{"$f":"SUM(K10:K16)","v":2181.4218746402134},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C17","v":565.17543859649118}]
["Amortissements",{"$f":"'[1]Data GCO'!D15","v":0},{"$f":"'[1]Data GCO'!E15","v":0},{"$f":"'[1]Analytique GCO'!C39","v":67},{"$f":"'[1]Analytique GCO'!D39","v":70},null,{"$f":"E18+N18","v":81},{"$f":"G18","v":81},{"$f":"H18","v":81},{"$f":"I18","v":81},{"$f":"J18","v":81},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C18","v":11}]
["Provisions",{"$f":"'[1]Data GCO'!D16","v":33.299999999999997},{"$f":"'[1]Data GCO'!E16","v":57.2},{"$f":"'[1]Analytique GCO'!C40","v":0},{"$f":"'[1]Analytique GCO'!D40","v":0},null,{"$f":"E19+N19","v":15},{"$f":"G19*(1+$F$5)","v":15.75},{"$f":"H19*(1+$F$5)","v":16.537500000000001},{"$f":"I19*(1+$F$5)","v":17.364375000000003},{"$f":"J19*(1+$F$5)","v":18.232593750000003},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C19","v":15}]
["EBIT",{"$f":"'[1]Data GCO'!D17","v":-52},{"$f":"'[1]Data GCO'!E17","v":122.2},{"$f":"'[1]Analytique GCO'!C41","v":297.63599999999974},{"$f":"'[1]Analytique GCO'!D41","v":397},null,{"$f":"G9-G17-G18-G19","v":488.12956140350866},{"$f":"H9-H17-H18-H19","v":574.52628947368476},{"$f":"I9-I17-I18-I19","v":667.32017894736862},{"$f":"J9-J17-J18-J19","v":766.91446195723677},{"$f":"K9-K17-K18-K19","v":873.73618864103719},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C20","v":28.824561403508824}]
["Frais Financiers",{"$f":"'[1]Data GCO'!D18","v":-17},{"$f":"'[1]Data GCO'!E18","v":-59.2},{"$f":"'[1]Analytique GCO'!C42","v":-60.8},{"$f":"'[1]Analytique GCO'!D42","v":-70},0.05,{"$f":"-$F$21*(E46+E47+E48)","v":-35},{"$f":"-$F$21*(G46+G47+G48)","v":-50},{"$f":"-$F$21*(H46+H47+H48)","v":-35},{"$f":"-$F$21*(I46+I47+I48)","v":-35},{"$f":"-$F$21*(J46+J47+J48)","v":-35},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C21","v":0}]
["RCAI",{"$f":"'[1]Data GCO'!D19","v":-69},{"$f":"'[1]Data GCO'!E19","v":63},{"$f":"'[1]Analytique GCO'!C43","v":236.83599999999973},{"$f":"'[1]Analytique GCO'!D43","v":327},null,{"$f":"G20+G21","v":453.12956140350866},{"$f":"H20+H21","v":524.52628947368476},{"$f":"I20+I21","v":632.32017894736862},{"$f":"J20+J21","v":731.91446195723677},{"$f":"K20+K21","v":838.73618864103719},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C22","v":28.824561403508824}]
["Exceptionnels",{"$f":"'[1]Data GCO'!D20","v":0},{"$f":"'[1]Data GCO'!E20","v":0},{"$f":"'[1]Analytique GCO'!C44","v":0},{"$f":"'[1]Analytique GCO'!D44","v":0},null,0,0,0,0,0,null,null,{"$f":"'[1]synergies TSF GCO ATD'!C23","v":0}]
["IS",{"$f":"'[1]Data GCO'!D21","v":0},{"$f":"'[1]Data GCO'!E21","v":-19.399999999999999},{"$f":"'[1]Analytique GCO'!C45","v":-84.5},{"$f":"'[1]Analytique GCO'!D45","v":-90},0.33,{"$f":"-(G22+G23)*$F$24","v":-149.53275526315787},{"$f":"-(H22+H23)*$F$24","v":-173.09367552631599},{"$f":"-(I22+I23)*$F$24","v":-208.66565905263167},{"$f":"-(J22+J23)*$F$24","v":-241.53177244588815},{"$f":"-(K22+K23)*$F$24","v":-276.78294225154229},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C24","v":0}]
["Résultat net",{"$f":"'[1]Data GCO'!D22","v":-69},{"$f":"'[1]Data GCO'!E22","v":63},{"$f":"'[1]Analytique GCO'!C46","v":152.33599999999973},{"$f":"'[1]Analytique GCO'!D46","v":237},null,{"$f":"G22+G23+G24","v":303.59680614035079},{"$f":"H22+H23+H24","v":351.43261394736874},{"$f":"I22+I23+I24","v":423.65451989473695},{"$f":"J22+J23+J24","v":490.38268951134864},{"$f":"K22+K23+K24","v":561.95324638949489},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C25","v":28.824561403508824}]
["Marge brute Autofincmt",{"$f":"'[1]Data GCO'!D23","v":-35.700000000000003},{"$f":"+C25+C18","v":63},{"$f":"+D25+D18","v":219.33599999999973},{"$f":"+E25+E18","v":307},null,{"$f":"+G25+G18","v":384.59680614035079},{"$f":"+H25+H18","v":432.43261394736874},{"$f":"+I25+I18","v":504.65451989473695},{"$f":"+J25+J18","v":571.38268951134864},{"$f":"+K25+K18","v":642.95324638949489},null,null,{"$f":"'[1]synergies TSF GCO ATD'!C26","v":39.824561403508824}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["FINANCEMENT",{"$f":"B4","v":2005},{"$f":"C4","v":2006},{"$f":"D4","v":2007},{"$f":"E4","v":2008},null,{"$f":"G4","v":2009},{"$f":"H4","v":2010},{"$f":"I4","v":2011},{"$f":"J4","v":2012},{"$f":"K4","v":2013}]
["MBA",null,{"$f":"C26","v":63},{"$f":"D26","v":219.33599999999973},{"$f":"E26","v":307},null,{"$f":"G26","v":384.59680614035079},{"$f":"H26","v":432.43261394736874},{"$f":"I26","v":504.65451989473695},{"$f":"J26","v":571.38268951134864},{"$f":"K26","v":642.95324638949489}]
["Cap+/-",null,{"$f":"+C44-B44-C25","v":161.69999999999999},{"$f":"+D44-C44-D25","v":0.76400000000029422},{"$f":"+E44-D44-E25","v":-164.8}]
["CCrt+/-"]
["Defi+/-",null,{"$f":"C47-B47","v":1149.3000000000002},{"$f":"D47-C47","v":-376.50000000000011},{"$f":"E47-D47","v":-72.800000000000068},null,150,-150]
["Escpte+/-",null,null,null,null,null,150,-150]
["Socfisc+/-",null,{"$f":"C50-B50","v":89.3},{"$f":"D50-C50","v":107.8},{"$f":"E50-D50","v":0},null,50]
["BFR+/-",null,{"$f":"C74","v":-833.8},{"$f":"D74","v":-114.10000000000002},{"$f":"E74","v":-160.12128219178101},null,{"$f":"G74","v":-445.39488142465689},{"$f":"H74","v":33.80232076712241},{"$f":"I74","v":-77.838825706848866},{"$f":"J74","v":-81.823673670411154},{"$f":"K74","v":-86.012409366061547}]
["Immob+/-",null,{"$f":"-C54-C55","v":-636.9},{"$f":"C55+C54-D18-D55-D54","v":417.9},{"$f":"D55+D54-E18-E55-E54","v":-68},null,{"$f":"-G18","v":-81},{"$f":"-H18","v":-81},{"$f":"-I18","v":-81},{"$f":"-J18","v":-81},{"$f":"-K18","v":-81}]
["Autres+/-",null,{"$f":"C51-C59","v":26.4},{"$f":"+D51-C51+C59-D59","v":-74.599999999999994},{"$f":"+E51-D51+D59-E59","v":-2.7999999999999972}]
["Dispo DP",null,{"$f":"B39","v":0},{"$f":"C39","v":19.000000000000249},{"$f":"D39","v":199.60000000000014},null,{"$f":"E60","v":38},{"$f":"G39","v":246.20192471569385},{"$f":"H39","v":331.436859430185},{"$f":"I39","v":677.25255361807308},{"$f":"J39","v":1085.8115694590106}]
["Dispo FP",null,{"$f":"SUM(C29:C38)","v":19.000000000000249},{"$f":"SUM(D29:D38)","v":199.60000000000014},{"$f":"SUM(E29:E38)","v":38.078717808219039},null,{"$f":"SUM(G29:G38)","v":246.20192471569385},{"$f":"SUM(H29:H38)","v":331.436859430185},{"$f":"SUM(I29:I38)","v":677.25255361807308},{"$f":"SUM(J29:J38)","v":1085.8115694590106},{"$f":"SUM(K29:K38)","v":1561.7524064824438}]
["check",null,{"$f":"C39-C60","v":2.4868995751603507E-13},{"$f":"D39-D60","v":0.40000000000014779},{"$f":"E39-E60","v":7.8717808219039398E-2}]
[{"$f":"+A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BILANS en K€ - Belgique",2005,2006,2007,2008,null,{"$f":"G28","v":2009},{"$f":"H28","v":2010},{"$f":"I28","v":2011},{"$f":"J28","v":2012},{"$f":"K28","v":2013}]
["Capropres",null,224.7,{"$f":"'[1]Data GCO'!F40","v":377.8},450,null,{"$f":"E44+G25","v":753.59680614035074},{"$f":"G44+H25","v":1105.0294200877195},{"$f":"H44+I25","v":1528.6839399824564},{"$f":"I44+J25","v":2019.0666294938051},{"$f":"J44+K25","v":2581.0198758832998}]
["Prov",null,null,{"$f":"'[1]Data GCO'!F41","v":0},0,null,{"$f":"E45","v":0},{"$f":"G45","v":0},0,0,0]
["CCrt",null,null,{"$f":"'[1]Data GCO'!F42","v":0},0,null,{"$f":"E46","v":0},0,0,0,0]
["Defi",null,{"$f":"848.6+72.7+228","v":1149.3000000000002},{"$f":"'[1]Data GCO'!F43","v":772.80000000000007},700,null,{"$f":"E47+G32","v":850},{"$f":"G47+H32","v":700},700,700,700]
["Escpte+/-",null,null,{"$f":"'[1]Data GCO'!F44","v":0},null,null,{"$f":"E48+G33","v":150},0,0,0,0]
["Defour",null,850.2,{"$f":"'[1]Data GCO'!F45","v":929.1},{"$f":"E71","v":953.66090958904101},null,{"$f":"G71","v":1330.1532884383562},{"$f":"H71","v":1503.3102667397256},{"$f":"I71","v":1571.5526406904107},{"$f":"J71","v":1642.860976369315},{"$f":"K71","v":1717.3712640143838}]
["Socfisc",null,89.3,{"$f":"'[1]Data GCO'!F46","v":197.1},{"$f":"D50","v":197.1},null,{"$f":"E50+G34","v":247.1},{"$f":"G50+H34","v":247.1},{"$f":"H50+I34","v":247.1},{"$f":"I50+J34","v":247.1},{"$f":"J50+K34","v":247.1}]
["Autres",null,32.4,{"$f":"'[1]Data GCO'!F47","v":8.8000000000000007},6,null,{"$f":"E51","v":6},{"$f":"G51","v":6},{"$f":"H51","v":6},{"$f":"I51","v":6},{"$f":"J51","v":6}]
["Total",null,{"$f":"SUM(C44:C51)","v":2345.9000000000005},{"$f":"SUM(D44:D51)","v":2285.6000000000004},{"$f":"SUM(E44:E51)","v":2306.7609095890407},null,{"$f":"SUM(G44:G51)","v":3336.8500945787068},{"$f":"SUM(H44:H51)","v":3561.4396868274448},{"$f":"SUM(I44:I51)","v":4053.3365806728675},{"$f":"SUM(J44:J51)","v":4615.0276058631207},{"$f":"SUM(K44:K51)","v":5251.4911398976838}]
[]
["Incorpo",null,2.4,{"$f":"'[1]Data GCO'!F50","v":1.7},0,null,{"$f":"E54","v":0},{"$f":"F54","v":0},{"$f":"G54","v":0},{"$f":"H54","v":0},{"$f":"I54","v":0}]
["Corpo",null,634.5,{"$f":"'[1]Data GCO'!F51","v":150.30000000000001},150,null,{"$f":"E55-G36-G18","v":150},{"$f":"G55-H36-H18","v":150},{"$f":"H55-I36-I18","v":150},{"$f":"I55-J36-J18","v":150},{"$f":"J55-K36-K18","v":150}]
["Fin",null,null,{"$f":"'[1]Data GCO'!F52","v":0},0]
["Stocks",null,462,{"$f":"'[1]Data GCO'!F53","v":608},{"$f":"E69","v":754.27397260273972},null,{"$f":"G69","v":1052.0510958904108},1099.8298356164382,1149.7563215753423,1201.9258815410958,1256.4380066994866]
["Clients",null,1222,{"$f":"'[1]Data GCO'!F54","v":1269},{"$f":"E70","v":1307.4082191780822},null,1831.5183561643832,1923.0942739726027,2019.2489876712327,2120.2114370547947,2226.2220089075345]
["Autres",null,6,{"$f":"'[1]Data GCO'!F55","v":57},{"$f":"D59","v":57},null,{"$f":"E59","v":57},{"$f":"G59","v":57},{"$f":"H59","v":57},{"$f":"I59","v":57},{"$f":"J59","v":57}]
["Cash",null,19,{"$f":"'[1]Data GCO'!F56","v":199.2},38,null,{"$f":"G39","v":246.20192471569385},{"$f":"H39","v":331.436859430185},{"$f":"I39","v":677.25255361807308},{"$f":"J39","v":1085.8115694590106},{"$f":"K39","v":1561.7524064824438}]
["Total",null,{"$f":"SUM(C54:C60)","v":2345.9},{"$f":"SUM(D54:D60)","v":2285.1999999999998},{"$f":"SUM(E54:E60)","v":2306.682191780822},null,{"$f":"SUM(G54:G60)","v":3336.7713767704881},{"$f":"SUM(H54:H60)","v":3561.3609690192261},{"$f":"SUM(I54:I60)","v":4053.2578628646479},{"$f":"SUM(J54:J60)","v":4614.9488880549015},{"$f":"SUM(K54:K60)","v":5251.4124220894646}]
["check",null,{"$f":"C61-C52","v":0},{"$f":"D61-D52","v":-0.4000000000005457},{"$f":"E61-E52","v":-7.8717808218698337E-2},null,{"$f":"G61-G52","v":-7.8717808218698337E-2},{"$f":"H61-H52","v":-7.8717808218698337E-2},{"$f":"I61-I52","v":-7.8717808219607832E-2},{"$f":"J61-J52","v":-7.8717808219153085E-2},{"$f":"K61-K52","v":-7.8717808219153085E-2}]
[{"$f":"+A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BFR",null,{"$f":"C43","v":2006},{"$f":"D43","v":2007},{"$f":"E43","v":2008},null,{"$f":"G43","v":2009},{"$f":"H43","v":2010},{"$f":"I43","v":2011},{"$f":"J43","v":2012},{"$f":"K43","v":2013}]
["jours Stocks",null,{"$f":"C69/(C5-C9)*365","v":55.819265143992055},{"$f":"D69/(D7-D11)*365","v":65.156659899088211},70,null,70,70,70,70,70]
["jours Clients",null,{"$f":"(C70/1.196)/C5*365","v":85.751847001309642},{"$f":"(D70/1.196)/D5*365","v":70.032265478055251},70,null,70,70,70,70,70]
["jours Fourn",null,{"$f":"(C71/1.196)/(C5-C9)*365","v":85.887915029575595},{"$f":"(D71/1.196)/D7*365","v":73.869064656056864},74,null,74,80,80,80,80]
["Stocks",null,{"$f":"C57","v":462},{"$f":"D57","v":608},{"$f":"E66*E7/365","v":754.27397260273972},null,{"$f":"G66/365*G7","v":1052.0510958904108},{"$f":"H66/365*H7","v":1099.8298356164382},{"$f":"I66/365*I7","v":1149.7563215753423},{"$f":"J66/365*J7","v":1201.9258815410958},{"$f":"K66/365*K7","v":1256.4380066994866}]
["Clients",null,{"$f":"C58","v":1222},{"$f":"D58","v":1269},{"$f":"E67*E5*1.196/365","v":1307.4082191780822},null,{"$f":"G67/365*G5*1.196","v":1831.5183561643832},{"$f":"H67/365*H5*1.196","v":1923.0942739726027},{"$f":"I67/365*I5*1.196","v":2019.2489876712327},{"$f":"J67/365*J5*1.196","v":2120.2114370547947},{"$f":"K67/365*K5*1.196","v":2226.2220089075345}]
["Fournisseurs",null,{"$f":"C49","v":850.2},{"$f":"D49","v":929.1},{"$f":"E68*E7/365*1.196","v":953.66090958904101},null,{"$f":"G68/365*G7*1.196","v":1330.1532884383562},{"$f":"H68/365*H7*1.196","v":1503.3102667397256},{"$f":"I68/365*I7*1.196","v":1571.5526406904107},{"$f":"J68/365*J7*1.196","v":1642.860976369315},{"$f":"K68/365*K7*1.196","v":1717.3712640143838}]
["BFR",null,{"$f":"C69+C70-C71","v":833.8},{"$f":"D69+D70-D71","v":947.9},{"$f":"E69+E70-E71","v":1108.021282191781},null,{"$f":"G69+G70-G71","v":1553.4161636164379},{"$f":"H69+H70-H71","v":1519.6138428493155},{"$f":"I69+I70-I71","v":1597.4526685561643},{"$f":"J69+J70-J71","v":1679.2763422265755},{"$f":"K69+K70-K71","v":1765.288751592637}]
["BFR%CA",null,null,{"$f":"D72/D5","v":0.17141048824593128},{"$f":"E72/E5","v":0.19438969863013703},null,{"$f":"G72/G5","v":0.19454178630136981},{"$f":"H72/H5","v":0.18124624657534252},{"$f":"I72/I5","v":0.18145731506849316},{"$f":"J72/J5","v":0.18166838356164383},{"$f":"K72/K5","v":0.1818794520547945}]
["Delta BFR",null,{"$f":"B72-C72","v":-833.8},{"$f":"C72-D72","v":-114.10000000000002},{"$f":"D72-E72","v":-160.12128219178101},null,{"$f":"E72-G72","v":-445.39488142465689},{"$f":"G72-H72","v":33.80232076712241},{"$f":"H72-I72","v":-77.838825706848866},{"$f":"I72-J72","v":-81.823673670411154},{"$f":"J72-K72","v":-86.012409366061547}]
[{"$f":"A3","v":0}]
[null,"CALCUL D'UN FREE CASH FLOW NORMATIF :",null,null,null,null,null,2009,{"$f":"H76+1","v":2010},{"$f":"I76+1","v":2011},{"$f":"J76+1","v":2012},{"$f":"K76+1","v":2013}]
[null,"EBIT",null,null,null,null,null,{"$f":"G20","v":488.12956140350866},{"$f":"H20","v":574.52628947368476},{"$f":"I20","v":667.32017894736862},{"$f":"J20","v":766.91446195723677},{"$f":"K20","v":873.73618864103719}]
[null,"Frais financiers",null,null,null,null,null,0,0,0,0,0]
[null,"RCAI",null,null,null,null,null,{"$f":"H77","v":488.12956140350866},{"$f":"I77","v":574.52628947368476},{"$f":"J77","v":667.32017894736862},{"$f":"K77","v":766.91446195723677},{"$f":"L77","v":873.73618864103719}]
[null,"Impôts",null,null,null,0.33,null,{"$f":"H79*$F$80","v":161.08275526315788},{"$f":"I79*$F$80","v":189.59367552631599},{"$f":"J79*$F$80","v":220.21565905263165},{"$f":"K79*$F$80","v":253.08177244588813},{"$f":"L79*$F$80","v":288.33294225154231}]
[null,"Résultat net",null,null,null,null,null,{"$f":"H79-H80","v":327.04680614035078},{"$f":"I79-I80","v":384.93261394736874},{"$f":"J79-J80","v":447.104519894737},{"$f":"K79-K80","v":513.83268951134869},{"$f":"L79-L80","v":585.40324638949483}]
[null,"Amortissements",null,null,null,null,null,{"$f":"G18","v":81},{"$f":"H18","v":81},{"$f":"I18","v":81},{"$f":"J18","v":81},{"$f":"K18","v":81}]
[null,"Cash Flow normatif",null,null,null,null,null,{"$f":"+H81+H82","v":408.04680614035078},{"$f":"+I81+I82","v":465.93261394736874},{"$f":"+J81+J82","v":528.104519894737},{"$f":"+K81+K82","v":594.83268951134869},{"$f":"+L81+L82","v":666.40324638949483}]
[null,"Delta BFR",null,null,null,0.2,null,{"$f":"-$F$84*(G5-E5)","v":-457},{"$f":"-$F$84*(H5-G5)","v":-79.850000000000009},{"$f":"-$F$84*(I5-H5)","v":-83.84249999999993},{"$f":"-$F$84*(J5-I5)","v":-88.034625000000233},{"$f":"-$F$84*(K5-J5)","v":-92.436356250000244}]
[null,"Delta investissements",null,null,null,null,null,{"$f":"-H82","v":-81},{"$f":"-I82","v":-81},{"$f":"-J82","v":-81},{"$f":"-K82","v":-81},{"$f":"-L82","v":-81}]
[null,"Free cash flow normatif",null,null,null,null,null,{"$f":"H83+H84+H85","v":-129.95319385964922},{"$f":"I83+I84+I85","v":305.08261394736871},{"$f":"J83+J84+J85","v":363.26201989473708},{"$f":"K83+K84+K85","v":425.79806451134846},{"$f":"L83+L84+L85","v":492.96689013949458}]

{"sheet":"BP1","index":1,"n_rows":146,"n_cols":17,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[{"$f":"REPT(\"-\",300)","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan de la Société Lanson gastronomie : ",null,null,null,null,null,null,null,"BP1"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["EXPLOITATION en K€",null,2007,2008,null,2009,{"$f":"F4+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
["CA",null,1185,1280,null,1280,1280,1280,1280,1280]
["Autres produits",null,3,2]
["Coût des ventes",null,{"$f":"495+4","v":499},{"$f":"539-2","v":537},null,{"$f":"+F5-F9","v":537.6},{"$f":"+F7","v":537.6},{"$f":"+G7","v":537.6},{"$f":"+H7","v":537.6},{"$f":"+I7","v":537.6}]
["MB%",null,{"$f":"(C5-C7)/C5","v":0.5789029535864979},{"$f":"(D5-D7)/D5","v":0.58046874999999998},null,0.57999999999999996,{"$f":"+G9/G5","v":0.57999999999999996},{"$f":"+H9/H5","v":0.57999999999999996},{"$f":"+I9/I5","v":0.57999999999999996},{"$f":"+J9/J5","v":0.57999999999999996}]
["Marge brute",null,{"$f":"C5+C6-C7","v":689},{"$f":"D5+D6-D7","v":745},null,{"$f":"+F8*F5","v":742.4},{"$f":"+G5-G7","v":742.4},{"$f":"+H5-H7","v":742.4},{"$f":"+I5-I7","v":742.4},{"$f":"+J5-J7","v":742.4}]
["AACE hors loyers Lanson",null,{"$f":"131-C11","v":122},{"$f":"136-D11","v":127},null,{"$f":"136-F11","v":127},127,127,127,127]
["Loyers Lanson",null,9,9,null,9,{"$f":"F11","v":9},{"$f":"G11","v":9},{"$f":"H11","v":9},{"$f":"I11","v":9}]
["Salaires et charges employés",null,{"$f":"323+144-C13","v":327},{"$f":"373+156-D13","v":389},null,{"$f":"+D12","v":389},{"$f":"+F12","v":389},{"$f":"+G12","v":389},{"$f":"+H12","v":389},{"$f":"+I12","v":389}]
["Salaires et charges Dtion",null,140,140,null,140,140,140,140,140]
["Impôts et Taxes",null,31,26,null,26,{"$f":"+F14/F5*G5","v":26},{"$f":"+G14/G5*H5","v":26},{"$f":"+H14/H5*I5","v":26},{"$f":"+I14/I5*J5","v":26}]
["Autres charges"]
["Charges d'exploitation",null,{"$f":"SUM(C10:C15)","v":629},{"$f":"SUM(D10:D15)","v":691},null,{"$f":"SUM(F10:F15)","v":691},{"$f":"SUM(G10:G15)","v":691},{"$f":"SUM(H10:H15)","v":691},{"$f":"SUM(I10:I15)","v":691},{"$f":"SUM(J10:J15)","v":691}]
["Amortissements",null,47,43,null,43,43,43,43,43]
["Provisions"]
["EBIT",null,{"$f":"C9-C16-C17-C18","v":13},{"$f":"D9-D16-D17-D18","v":11},null,{"$f":"F9-F16-F17-F18","v":8.3999999999999773},{"$f":"G9-G16-G17-G18","v":8.3999999999999773},{"$f":"H9-H16-H17-H18","v":8.3999999999999773},{"$f":"I9-I16-I17-I18","v":8.3999999999999773},{"$f":"J9-J16-J17-J18","v":8.3999999999999773}]
["Résultat financier",7.0000000000000007E-2,-2.5,-2.5,null,{"$f":"-$B$20*D44","v":-2.5900000000000003},{"$f":"-$B$20*F44","v":0},{"$f":"-$B$20*G44","v":0},{"$f":"-$B$20*H44","v":0},{"$f":"-$B$20*I44","v":0}]
["Résultat courant avt impôts",null,{"$f":"C19+C20","v":10.5},{"$f":"D19+D20","v":8.5},null,{"$f":"F19+F20","v":5.8099999999999774},{"$f":"G19+G20","v":8.3999999999999773},{"$f":"H19+H20","v":8.3999999999999773},{"$f":"I19+I20","v":8.3999999999999773},{"$f":"J19+J20","v":8.3999999999999773}]
["Exceptionnels"]
["IS",null,-1.4,-1.2,null,{"$f":"D23/D21*F21","v":-0.82023529411764384},-1,-1,-1,-1]
["Résultat net",null,{"$f":"C21+C22+C23","v":9.1},{"$f":"D21+D22+D23","v":7.3},null,{"$f":"F21+F22+F23","v":4.9897647058823331},{"$f":"G21+G22+G23","v":7.3999999999999773},{"$f":"H21+H22+H23","v":7.3999999999999773},{"$f":"I21+I22+I23","v":7.3999999999999773},{"$f":"J21+J22+J23","v":7.3999999999999773}]
["Marge brute Autofincmt",null,{"$f":"C24+C17","v":56.1},{"$f":"D24+D17","v":50.3},null,{"$f":"F24+F17","v":47.989764705882337},{"$f":"G24+G17","v":50.399999999999977},{"$f":"H24+H17","v":50.399999999999977},{"$f":"I24+I17","v":50.399999999999977},{"$f":"J24+J17","v":50.399999999999977}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["FINANCEMENT en K€",null,{"$f":"C4","v":2007},{"$f":"D4","v":2008},null,{"$f":"F4","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Marge Brute Autofinancement",null,null,{"$f":"D25","v":50.3},null,{"$f":"F25","v":47.989764705882337},{"$f":"G25","v":50.399999999999977},{"$f":"H25","v":50.399999999999977},{"$f":"I25","v":50.399999999999977},{"$f":"J25","v":50.399999999999977}]
["Capital +/-",null,{"$f":"C41","v":105},{"$f":"+D41-C41-D24","v":-0.29999999999999982},null,-40,-15]
["Cptes crts +/-"]
["Dettes financières +/-",null,{"$f":"C44","v":69},{"$f":"D44-C44","v":-32},null,-37]
["Social Fiscal +/-",null,{"$f":"C46","v":57},{"$f":"D46-C46","v":-3}]
["BFR+/-",null,{"$f":"C66","v":-15},{"$f":"D66","v":-1},null,{"$f":"F66","v":-1},{"$f":"G66","v":0},{"$f":"H66","v":0},{"$f":"I66","v":0},{"$f":"J66","v":0}]
["Immobilisations +/-",null,{"$f":"-C50-C51-C52","v":-140},{"$f":"C51+C50-D17-D51-D50","v":-38},null,null,-20,{"$f":"-H17","v":-43},{"$f":"-I17","v":-43},{"$f":"-J17","v":-43}]
["Autres+/-",null,{"$f":"C47-C55","v":-16},{"$f":"+D47-C47+C55-D55","v":-5}]
["Dispo Début Période",null,{"$f":"B37","v":0},{"$f":"C37","v":60},null,{"$f":"D37","v":31},{"$f":"F37","v":0.98976470588233667},{"$f":"G37","v":16.389764705882314},{"$f":"H37","v":23.789764705882291},{"$f":"I37","v":31.189764705882268}]
["Dispo Fin Période",null,{"$f":"SUM(C28:C36)","v":60},{"$f":"SUM(D28:D36)","v":31},null,{"$f":"SUM(F28:F36)","v":0.98976470588233667},{"$f":"SUM(G28:G36)","v":16.389764705882314},{"$f":"SUM(H28:H36)","v":23.789764705882291},{"$f":"SUM(I28:I36)","v":31.189764705882268},{"$f":"SUM(J28:J36)","v":38.589764705882246}]
["contrôle",null,{"$f":"C37-C56","v":0},{"$f":"D37-D56","v":0},null,{"$f":"F37-F56","v":0},{"$f":"G37-G56","v":0},{"$f":"H37-H56","v":0},{"$f":"I37-I56","v":0},{"$f":"J37-J56","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BILANS en K€",null,{"$f":"C27","v":2007},{"$f":"D27","v":2008},null,{"$f":"F27","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capitaux propres",null,105,112,null,{"$f":"D41+F24+F29","v":76.989764705882337},{"$f":"F41+G24+G29","v":69.389764705882314},{"$f":"G41+H24+H29","v":76.789764705882291},{"$f":"H41+I24+I29","v":84.189764705882268},{"$f":"I41+J24+J29","v":91.589764705882246}]
["Provisions"]
["Cptes courants"]
["Dettes financières",null,69,37,null,{"$f":"D44+F31","v":0},{"$f":"F44+G31","v":0},{"$f":"G44+H31","v":0},{"$f":"H44+I31","v":0},{"$f":"I44+J31","v":0}]
["Dettes Fournisseurs"]
["Social Fiscal",null,57,54,null,{"$f":"D46+F32","v":54},{"$f":"F46+G32","v":54},{"$f":"G46+H32","v":54},{"$f":"H46+I32","v":54},{"$f":"I46+J32","v":54}]
["Autres"]
["Total",null,{"$f":"SUM(C41:C47)","v":231},{"$f":"SUM(D41:D47)","v":203},null,{"$f":"SUM(F41:F47)","v":130.98976470588235},{"$f":"SUM(G41:G47)","v":123.38976470588231},{"$f":"SUM(H41:H47)","v":130.78976470588231},{"$f":"SUM(I41:I47)","v":138.18976470588228},{"$f":"SUM(J41:J47)","v":145.58976470588226}]
[]
["Actifs incorporels",null,6,6,null,{"$f":"D50","v":6},{"$f":"F50","v":6},{"$f":"G50","v":6},{"$f":"H50","v":6},{"$f":"I50","v":6}]
["Actifs corporels",null,{"$f":"24+107","v":131},{"$f":"25+101","v":126},null,{"$f":"D51-F34-F17","v":83},{"$f":"F51-G34-G17","v":60},{"$f":"G51-H34-H17","v":60},{"$f":"H51-I34-I17","v":60},{"$f":"I51-J34-J17","v":60}]
["Actifs financiers",null,3,3,null,{"$f":"D52","v":3},{"$f":"F52","v":3},{"$f":"G52","v":3},{"$f":"H52","v":3},{"$f":"I52","v":3}]
["Stocks",null,15,16,null,{"$f":"F61","v":17},17,17,17,17]
["Clients",null,null,null,null,0,0,0,0,0]
["Autres",null,{"$f":"7+1+8","v":16},{"$f":"10+1+10","v":21},null,{"$f":"D55-F35","v":21},{"$f":"F55-G35","v":21},{"$f":"G55-H35","v":21},{"$f":"H55-I35","v":21},{"$f":"I55-J35","v":21}]
["Disponibilités",null,60,31,null,{"$f":"F37","v":0.98976470588233667},{"$f":"G37","v":16.389764705882314},{"$f":"H37","v":23.789764705882291},{"$f":"I37","v":31.189764705882268},{"$f":"J37","v":38.589764705882246}]
["Total",null,{"$f":"SUM(C50:C56)","v":231},{"$f":"SUM(D50:D56)","v":203},null,{"$f":"SUM(F50:F56)","v":130.98976470588235},{"$f":"SUM(G50:G56)","v":123.38976470588231},{"$f":"SUM(H50:H56)","v":130.78976470588231},{"$f":"SUM(I50:I56)","v":138.18976470588228},{"$f":"SUM(J50:J56)","v":145.58976470588226}]
["contrôle",null,{"$f":"+C57-C48","v":0},{"$f":"+D57-D48","v":0},null,{"$f":"+F57-F48","v":0},{"$f":"+G57-G48","v":0},{"$f":"+H57-H48","v":0},{"$f":"+I57-I48","v":0},{"$f":"+J57-J48","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BFR",null,{"$f":"+C40","v":2007},{"$f":"+D40","v":2008},null,{"$f":"+F40","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Stocks",null,{"$f":"+C53","v":15},{"$f":"+D53","v":16},null,17,17,17,17,17]
["Clients",null,{"$f":"+C54","v":0},{"$f":"+D54","v":0},null,0,0,0,0,0]
["Fournisseurs",null,{"$f":"+C45","v":0},{"$f":"+D45","v":0},null,0,0,0,0,0]
["BFR",null,{"$f":"+C61+C62-C63","v":15},{"$f":"+D61+D62-D63","v":16},null,{"$f":"+F61+F62-F63","v":17},{"$f":"+G61+G62-G63","v":17},{"$f":"+H61+H62-H63","v":17},{"$f":"+I61+I62-I63","v":17},{"$f":"+J61+J62-J63","v":17}]
["BFR%CA",null,{"$f":"+C64/C5","v":1.2658227848101266E-2},{"$f":"+D64/D5","v":1.2500000000000001E-2},null,{"$f":"+F64/F5","v":1.328125E-2},{"$f":"+G64/G5","v":1.328125E-2},{"$f":"+H64/H5","v":1.328125E-2},{"$f":"+I64/I5","v":1.328125E-2},{"$f":"+J64/J5","v":1.328125E-2}]
["Delta BFR",null,{"$f":"-C64","v":-15},{"$f":"C64-D64","v":-1},null,{"$f":"D64-F64","v":-1},{"$f":"F64-G64","v":0},{"$f":"G64-H64","v":0},{"$f":"H64-I64","v":0},{"$f":"I64-J64","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan du Foyer Lanson :",null,null,null,null,null,null,null,{"$f":"I2","v":"BP1"},{"$f":"J2","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Foyer Lanson ",null,{"$f":"C60","v":2007},{"$f":"D60","v":2008},null,{"$f":"F60","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Salaires puis Retraites",null,{"$f":"C13/3*2*0.8","v":74.666666666666671},{"$f":"D13/3*2*0.8","v":74.666666666666671},null,{"$f":"F13/3*2*0.8","v":74.666666666666671},{"$f":"G13/3*2*0.8","v":74.666666666666671},25,{"$f":"H72","v":25},25,25,25,25,25,25,25]
["Dividendes",null,null,{"$f":"-D29","v":0.29999999999999982},null,{"$f":"-F29","v":40},15,0,0,0,0,0,0,0,0,0]
["+V mobilières"]
["Revenus valeurs mob",0.04,null,null,null,{"$f":"$B$75*(D105+D106+D108)","v":11.68},{"$f":"$B$75*(F105+F106+F108)","v":14.747200000000001},16.937087999999999,36.814571520000001,27.687154380800003,28.087154380800001,28.487154380800003,28.967154380800004,29.487154380800003,30.047154380800002,30.647154380800004]
["Loyers",null,{"$f":"C11","v":9},{"$f":"D11","v":9},null,{"$f":"F11","v":9},9,0,0,0,0,0,0,0,0,0]
["Charges foncières",null,null,null,null,3,3,0,0,0,0,0,0,0,0,0]
["Charges quotidiennes",null,null,null,null,40,40,40,40,40,40,40,40,40,40,40]
["I/dividendes",null,null,null,null,{"$f":"IF((0.6*F73-4)*$B$81<0,0,(0.6*F73-4)*$B$81)","v":6},1.5,0,0,0,0,0,0,0,0,0]
["I/+V mob"]
["Impôt progressif",0.3,0.14000000000000001,null,null,{"$f":"F72*0.9*$B$81+(F76-F77)*$B$81-11","v":10.96},{"$f":"G72*0.9*$B$81+(G76-G77)*$B$81-11","v":10.96},{"$f":"IF(H72*0.9*$C$81+(H76-H77)*$C$81-2.6<0,0,H72*0.9*$C$81+(H76-H77)*$C$81-2.6)","v":0.55000000000000027},{"$f":"IF(I72*0.9*$C$81+(I76-I77)*$C$81-2.6<0,0,I72*0.9*$C$81+(I76-I77)*$C$81-2.6)","v":0.55000000000000027},0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027]
["Total IRPP",null,null,null,null,{"$f":"+F81+F79+F80","v":16.96},{"$f":"+G81+G79+G80","v":12.46},0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027]
["ISF",null,null,null,null,null,null,null,1,1,1,1,1,1,1,1]
["Dépenses exceptionnelles"]
["Disponible",null,null,null,null,{"$f":"+F72+F73+F74+F75+F76-F77-F78-F82-F83-F84","v":75.386666666666656},{"$f":"+G72+G73+G74+G75+G76-G77-G78-G82-G83-G84","v":57.953866666666677},1.3870880000000025,20.264571520000001,11.137154380800002,11.537154380800001,11.937154380800006,12.417154380800003,12.937154380800006,13.497154380800001,14.097154380800003]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Financement foyer Lanson",null,{"$f":"C71","v":2007},{"$f":"D71","v":2008},null,{"$f":"F71","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["MBA",null,{"$f":"C85","v":0},{"$f":"D85","v":0},null,{"$f":"F85","v":75.386666666666656},57.953866666666677,1.3870880000000025,20.264571520000001,11.137154380800002,11.537154380800001,11.937154380800006,12.417154380800003,12.937154380800006,13.497154380800001,14.097154380800003]
["Immobilier privé +/-",null,null,null,null,null,null,350,-250]
["Immobilier de rapport"]
["Valeurs mobilières +/-"]
["Assurance vie/capitalisation",null,null,null,null,-65,-40,-480,265]
["Participations Lanson Gastro",null,null,null,null,null,null,149]
["Endettement"]
["Capitalisation cachée",null,null,null,null,{"$f":"-F75","v":-11.68},{"$f":"-G75","v":-14.747200000000001},{"$f":"-H75","v":-16.937087999999999},{"$f":"-I75","v":-36.814571520000001},-10,-10,-12,-13,-14,-15,-16]
["Liquidités DP",null,null,null,null,{"$f":"D97","v":5},{"$f":"F97","v":3.7066666666666563},6.9133333333333322,10.363333333333339,8.8133333333333415,9.9504877141333434,11.487642094933344,11.42479647573335,10.841950856533353,9.7791052373333596,8.276259618133361]
["Liquidités FP",null,null,5,null,{"$f":"SUM(F88:F96)","v":3.7066666666666563},6.9133333333333322,10.363333333333339,8.8133333333333415,9.9504877141333434,11.487642094933344,11.42479647573335,10.841950856533353,9.7791052373333596,8.276259618133361,6.3734139989333638]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Bilan foyer Lanson",null,{"$f":"C87","v":2007},{"$f":"D87","v":2008},null,{"$f":"F87","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capitaux propres",null,null,796,null,{"$f":"D100+F85","v":871.38666666666666},{"$f":"F100+G85","v":929.34053333333338},930.72762133333333,950.99219285333334,962.12934723413332,973.66650161493328,985.60365599573333,998.02081037653329,1010.9579647573333,1024.4551191381333,1038.5522735189334]
["Endettement",null,null,0]
[]
["Immobilier privé +/-",null,null,350,null,{"$f":"D103-F89","v":350},{"$f":"F103-G89","v":350},0,250,250,250,250,250,250,250,250]
["Immobilier de rapport",null,null,0,null,{"$f":"D104-F90","v":0},{"$f":"F104-G90","v":0},0,0,0,0,0,0,0,0,0]
["Valeurs mobilières +/-",null,null,40,null,{"$f":"D105-F91","v":40},{"$f":"F105-G91","v":40},40,40,40,40,40,40,40,40,40]
["Assurance vie/capitalisation",null,null,252,null,{"$f":"D106-F92","v":317},{"$f":"F106-G92","v":357},837,572,572,572,572,572,572,572,572]
["Participations",null,null,149,null,{"$f":"D107-F93","v":149},{"$f":"F107-G93","v":149},0,0,0,0,0,0,0,0,0]
["Capitalisation cachée",null,null,null,null,{"$f":"D108-F95","v":11.68},{"$f":"F108-G95","v":26.427199999999999},43.364288000000002,80.178859520000003,90.178859520000003,100.17885952,112.17885952,125.17885952,139.17885952,154.17885952,170.17885952]
["Liquidités",null,null,{"$f":"D97","v":5},null,{"$f":"F97","v":3.7066666666666563},6.9133333333333322,10.363333333333339,8.8133333333333415,9.9504877141333434,11.487642094933344,11.42479647573335,10.841950856533353,9.7791052373333596,8.276259618133361,6.3734139989333638]
["total",null,null,{"$f":"SUM(D103:D109)","v":796},null,{"$f":"SUM(F103:F109)","v":871.38666666666666},929.34053333333327,930.72762133333333,950.99219285333345,962.12934723413343,973.6665016149334,985.60365599573345,998.0208103765334,1010.9579647573335,1024.4551191381333,1038.5522735189334]
["check",null,null,{"$f":"D110-SUM(D100:D101)","v":0},null,{"$f":"F110-SUM(F100:F101)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan de la SCI Lanson :",null,null,null,null,null,null,null,{"$f":"I69","v":"BP1"},{"$f":"J69","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["SCI Lanson ",null,{"$f":"C99","v":2007},{"$f":"D99","v":2008},null,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Revenus locatifs"]
["Charges foncières"]
["Amortissements"]
["Résultat d'exploitation"]
["Frais financiers"]
["Impôt"]
["Résultat net"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Financement SCI Lanson",null,{"$f":"C116","v":2007},{"$f":"D116","v":2008},null,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["MBA"]
["Cap+/-"]
["CCrt+/-"]
["Defi+/-"]
["Immob+/-"]
["Dispo DP"]
["Dispo FP"]
["check"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Bilan SCI Lanson",null,{"$f":"C125","v":2007},{"$f":"D125","v":2008},null,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capropres"]
["CCrt"]
["Defi"]
["Total"]
[]
["Immobilisations"]
["Autres"]
["Cash"]
["Total"]
["check"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]

{"sheet":"BP2","index":2,"n_rows":145,"n_cols":17,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
[{"$f":"REPT(\"-\",300)","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan de la Société Lanson gastronomie : ",null,null,null,null,null,null,null,"BP2","JSC le 05/06/2009"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["EXPLOITATION en K€",null,2007,2008,null,2009,{"$f":"F4+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
["CA",null,1185,1280,null,1380,1380,1380,1380,1380]
["Autres produits",null,3,2]
["Coût des ventes",null,{"$f":"495+4","v":499},{"$f":"539-2","v":537},null,{"$f":"D7","v":537},{"$f":"+F7","v":537},{"$f":"+G7","v":537},{"$f":"+H7","v":537},{"$f":"+I7","v":537}]
["MB%",null,{"$f":"(C5-C7)/C5","v":0.5789029535864979},{"$f":"(D5-D7)/D5","v":0.58046874999999998},null,{"$f":"+F9/F5","v":0.61086956521739133},{"$f":"+G9/G5","v":0.61086956521739133},{"$f":"+H9/H5","v":0.61086956521739133},{"$f":"+I9/I5","v":0.61086956521739133},{"$f":"+J9/J5","v":0.61086956521739133}]
["Marge brute",null,{"$f":"C5+C6-C7","v":689},{"$f":"D5+D6-D7","v":745},null,{"$f":"F5-F7","v":843},{"$f":"+G5-G7","v":843},{"$f":"+H5-H7","v":843},{"$f":"+I5-I7","v":843},{"$f":"+J5-J7","v":843}]
["AACE hors loyers Lanson",null,{"$f":"131-C11","v":122},{"$f":"136-D11","v":127},null,{"$f":"136-F11","v":127},136,136,136,136]
["Loyers Lanson",null,9,9,null,9,35,{"$f":"G11","v":35},{"$f":"H11","v":35},{"$f":"I11","v":35}]
["Salaires et charges employés",null,{"$f":"323+144-C13","v":317},{"$f":"373+156-D13","v":379},null,{"$f":"+D12","v":379},{"$f":"+F12","v":379},{"$f":"+G12","v":379},{"$f":"+H12","v":379},{"$f":"+I12","v":379}]
["Salaires et charges Dtion",null,150,150,null,150,150,150,150,150]
["Impôts et Taxes",null,31,26,null,30,{"$f":"+F14/F5*G5","v":30},{"$f":"+G14/G5*H5","v":30},{"$f":"+H14/H5*I5","v":30},{"$f":"+I14/I5*J5","v":30}]
["Autres charges"]
["Charges d'exploitation",null,{"$f":"SUM(C10:C15)","v":629},{"$f":"SUM(D10:D15)","v":691},null,{"$f":"SUM(F10:F15)","v":695},{"$f":"SUM(G10:G15)","v":730},{"$f":"SUM(H10:H15)","v":730},{"$f":"SUM(I10:I15)","v":730},{"$f":"SUM(J10:J15)","v":730}]
["Amortissements",null,47,43,null,40,40,40,40,40]
["Provisions"]
["EBIT",null,{"$f":"C9-C16-C17-C18","v":13},{"$f":"D9-D16-D17-D18","v":11},null,{"$f":"F9-F16-F17-F18","v":108},{"$f":"G9-G16-G17-G18","v":73},{"$f":"H9-H16-H17-H18","v":73},{"$f":"I9-I16-I17-I18","v":73},{"$f":"J9-J16-J17-J18","v":73}]
["Résultat financier",7.0000000000000007E-2,-2.5,-2.5,null,{"$f":"-$B$20*D44","v":-2.5900000000000003},{"$f":"-$B$20*F44","v":0},{"$f":"-$B$20*G44","v":0},{"$f":"-$B$20*H44","v":0},{"$f":"-$B$20*I44","v":0}]
["Résultat courant avt impôts",null,{"$f":"C19+C20","v":10.5},{"$f":"D19+D20","v":8.5},null,{"$f":"F19+F20","v":105.41},{"$f":"G19+G20","v":73},{"$f":"H19+H20","v":73},{"$f":"I19+I20","v":73},{"$f":"J19+J20","v":73}]
["Exceptionnels"]
["IS",0.33,-1.4,-1.2,null,{"$f":"D23/D21*F21","v":-14.881411764705881},{"$f":"-$B$23*G21","v":-24.09},{"$f":"-$B$23*H21","v":-24.09},{"$f":"-$B$23*I21","v":-24.09},{"$f":"-$B$23*J21","v":-24.09}]
["Résultat net",null,{"$f":"C21+C22+C23","v":9.1},{"$f":"D21+D22+D23","v":7.3},null,{"$f":"F21+F22+F23","v":90.528588235294109},{"$f":"G21+G22+G23","v":48.91},{"$f":"H21+H22+H23","v":48.91},{"$f":"I21+I22+I23","v":48.91},{"$f":"J21+J22+J23","v":48.91}]
["Marge brute Autofincmt",null,{"$f":"C24+C17","v":56.1},{"$f":"D24+D17","v":50.3},null,{"$f":"F24+F17","v":130.52858823529411},{"$f":"G24+G17","v":88.91},{"$f":"H24+H17","v":88.91},{"$f":"I24+I17","v":88.91},{"$f":"J24+J17","v":88.91}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["FINANCEMENT en K€",null,{"$f":"C4","v":2007},{"$f":"D4","v":2008},null,{"$f":"F4","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Marge Brute Autofinancement",null,null,{"$f":"D25","v":50.3},null,{"$f":"F25","v":130.52858823529411},{"$f":"G25","v":88.91},{"$f":"H25","v":88.91},{"$f":"I25","v":88.91},{"$f":"J25","v":88.91}]
["Capital +/-",null,{"$f":"C41","v":105},{"$f":"+D41-C41-D24","v":-0.29999999999999982},null,-80,-52,-53]
["Cptes crts +/-"]
["Dettes financières +/-",null,{"$f":"C44","v":69},{"$f":"D44-C44","v":-32},null,-37]
["Social Fiscal +/-",null,{"$f":"C46","v":57},{"$f":"D46-C46","v":-3}]
["BFR+/-",null,{"$f":"C66","v":-15},{"$f":"D66","v":-1},null,{"$f":"F66","v":-1},{"$f":"G66","v":0},{"$f":"H66","v":0},{"$f":"I66","v":0},{"$f":"J66","v":0}]
["Immobilisations +/-",null,{"$f":"-C50-C51-C52","v":-140},{"$f":"C51+C50-D17-D51-D50","v":-38},null,-40,{"$f":"-G17","v":-40},{"$f":"-H17","v":-40},{"$f":"-I17","v":-40},{"$f":"-J17","v":-40}]
["Autres+/-",null,{"$f":"C47-C55","v":-16},{"$f":"+D47-C47+C55-D55","v":-5}]
["Dispo Début Période",null,{"$f":"B37","v":0},{"$f":"C37","v":60},null,{"$f":"D37","v":31},{"$f":"F37","v":3.5285882352941087},{"$f":"G37","v":0.43858823529410529},{"$f":"H37","v":-3.6514117647058981},{"$f":"I37","v":45.258588235294098}]
["Dispo Fin Période",null,{"$f":"SUM(C28:C36)","v":60},{"$f":"SUM(D28:D36)","v":31},null,{"$f":"SUM(F28:F36)","v":3.5285882352941087},{"$f":"SUM(G28:G36)","v":0.43858823529410529},{"$f":"SUM(H28:H36)","v":-3.6514117647058981},{"$f":"SUM(I28:I36)","v":45.258588235294098},{"$f":"SUM(J28:J36)","v":94.168588235294095}]
["contrôle",null,{"$f":"C37-C56","v":0},{"$f":"D37-D56","v":0},null,{"$f":"F37-F56","v":0},{"$f":"G37-G56","v":0},{"$f":"H37-H56","v":0},{"$f":"I37-I56","v":0},{"$f":"J37-J56","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BILANS en K€",null,{"$f":"C27","v":2007},{"$f":"D27","v":2008},null,{"$f":"F27","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capitaux propres",null,105,112,null,{"$f":"D41+F24+F29","v":122.52858823529411},{"$f":"F41+G24+G29","v":119.43858823529411},{"$f":"G41+H24+H29","v":115.3485882352941},{"$f":"H41+I24+I29","v":164.2585882352941},{"$f":"I41+J24+J29","v":213.1685882352941}]
["Provisions"]
["Cptes courants"]
["Dettes financières",null,69,37,null,{"$f":"D44+F31","v":0},{"$f":"F44+G31","v":0},{"$f":"G44+H31","v":0},{"$f":"H44+I31","v":0},{"$f":"I44+J31","v":0}]
["Dettes Fournisseurs"]
["Social Fiscal",null,57,54,null,{"$f":"D46+F32","v":54},{"$f":"F46+G32","v":54},{"$f":"G46+H32","v":54},{"$f":"H46+I32","v":54},{"$f":"I46+J32","v":54}]
["Autres"]
["Total",null,{"$f":"SUM(C41:C47)","v":231},{"$f":"SUM(D41:D47)","v":203},null,{"$f":"SUM(F41:F47)","v":176.52858823529411},{"$f":"SUM(G41:G47)","v":173.43858823529411},{"$f":"SUM(H41:H47)","v":169.3485882352941},{"$f":"SUM(I41:I47)","v":218.2585882352941},{"$f":"SUM(J41:J47)","v":267.16858823529412}]
[]
["Actifs incorporels",null,6,6,null,{"$f":"D50","v":6},{"$f":"F50","v":6},{"$f":"G50","v":6},{"$f":"H50","v":6},{"$f":"I50","v":6}]
["Actifs corporels",null,{"$f":"24+107","v":131},{"$f":"25+101","v":126},null,{"$f":"D51-F34-F17","v":126},{"$f":"F51-G34-G17","v":126},{"$f":"G51-H34-H17","v":126},{"$f":"H51-I34-I17","v":126},{"$f":"I51-J34-J17","v":126}]
["Actifs financiers",null,3,3,null,{"$f":"D52","v":3},{"$f":"F52","v":3},{"$f":"G52","v":3},{"$f":"H52","v":3},{"$f":"I52","v":3}]
["Stocks",null,15,16,null,{"$f":"F61","v":17},17,17,17,17]
["Clients",null,null,null,null,0,0,0,0,0]
["Autres",null,{"$f":"7+1+8","v":16},{"$f":"10+1+10","v":21},null,{"$f":"D55-F35","v":21},{"$f":"F55-G35","v":21},{"$f":"G55-H35","v":21},{"$f":"H55-I35","v":21},{"$f":"I55-J35","v":21}]
["Disponibilités",null,60,31,null,{"$f":"F37","v":3.5285882352941087},{"$f":"G37","v":0.43858823529410529},{"$f":"H37","v":-3.6514117647058981},{"$f":"I37","v":45.258588235294098},{"$f":"J37","v":94.168588235294095}]
["Total",null,{"$f":"SUM(C50:C56)","v":231},{"$f":"SUM(D50:D56)","v":203},null,{"$f":"SUM(F50:F56)","v":176.52858823529411},{"$f":"SUM(G50:G56)","v":173.43858823529411},{"$f":"SUM(H50:H56)","v":169.3485882352941},{"$f":"SUM(I50:I56)","v":218.2585882352941},{"$f":"SUM(J50:J56)","v":267.16858823529412}]
["contrôle",null,{"$f":"+C57-C48","v":0},{"$f":"+D57-D48","v":0},null,{"$f":"+F57-F48","v":0},{"$f":"+G57-G48","v":0},{"$f":"+H57-H48","v":0},{"$f":"+I57-I48","v":0},{"$f":"+J57-J48","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BFR",null,{"$f":"+C40","v":2007},{"$f":"+D40","v":2008},null,{"$f":"+F40","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Stocks",null,{"$f":"+C53","v":15},{"$f":"+D53","v":16},null,17,17,17,17,17]
["Clients",null,{"$f":"+C54","v":0},{"$f":"+D54","v":0},null,0,0,0,0,0]
["Fournisseurs",null,{"$f":"+C45","v":0},{"$f":"+D45","v":0},null,0,0,0,0,0]
["BFR",null,{"$f":"+C61+C62-C63","v":15},{"$f":"+D61+D62-D63","v":16},null,{"$f":"+F61+F62-F63","v":17},{"$f":"+G61+G62-G63","v":17},{"$f":"+H61+H62-H63","v":17},{"$f":"+I61+I62-I63","v":17},{"$f":"+J61+J62-J63","v":17}]
["BFR%CA",null,{"$f":"+C64/C5","v":1.2658227848101266E-2},{"$f":"+D64/D5","v":1.2500000000000001E-2},null,{"$f":"+F64/F5","v":1.2318840579710146E-2},{"$f":"+G64/G5","v":1.2318840579710146E-2},{"$f":"+H64/H5","v":1.2318840579710146E-2},{"$f":"+I64/I5","v":1.2318840579710146E-2},{"$f":"+J64/J5","v":1.2318840579710146E-2}]
["Delta BFR",null,{"$f":"-C64","v":-15},{"$f":"C64-D64","v":-1},null,{"$f":"D64-F64","v":-1},{"$f":"F64-G64","v":0},{"$f":"G64-H64","v":0},{"$f":"H64-I64","v":0},{"$f":"I64-J64","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan du Foyer Lanson :",null,null,null,null,null,null,null,{"$f":"I2","v":"BP2"},{"$f":"J2","v":"JSC le 05/06/2009"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Foyer Lanson ",null,{"$f":"C60","v":2007},{"$f":"D60","v":2008},null,{"$f":"F60","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Salaires puis Retraites",null,{"$f":"C13/3*2*0.8","v":80},{"$f":"D13/3*2*0.8","v":80},null,{"$f":"F13/3*2*0.8","v":80},{"$f":"G13/3*2*0.8","v":80},25,{"$f":"H72","v":25},25,25,25,25,25,25,25]
["Dividendes",null,null,{"$f":"-D29","v":0.29999999999999982},null,{"$f":"-F29","v":80},52,53,0,0,0,0,0,0,0,0]
["+V mobilières",null,null,null,null,null,null,null,{"$f":"F89-H140","v":15}]
["Revenus valeurs mob",0.04,null,null,null,{"$f":"$B$75*(D105+D106+D108)","v":11.68},{"$f":"$B$75*(F105+F106+F108)","v":30.147199999999998},34.353088,42.92721152,34.6442999808,35.337185980415995,36.043929700024322,36.76480829402481,37.500104459905302,38.250106549103407,39.015108680085476]
["Loyers",null,{"$f":"C11","v":9},{"$f":"D11","v":9},null,{"$f":"F11","v":9}]
["Charges foncières",null,null,null,null,3]
["Charges quotidiennes",null,null,null,null,40,40,40,40,40,40,40,40,40,40,40]
["I/dividendes",null,null,null,null,{"$f":"IF((0.6*F73-4)*$B$81<0,0,(0.6*F73-4)*$B$81)","v":13.2},8.16,8.3399999999999981,0,0,0,0,0,0,0,0]
["I/+V mob",null,null,null,null,null,null,null,-3]
["Impôt progressif",0.3,null,null,null,{"$f":"F72*0.9*$B$81-2*5.3+(F76-F77)*$B$81","v":12.799999999999997},{"$f":"G72*0.9*$B$81-2*5.3+(G76-G77)*$B$81","v":10.999999999999998},{"$f":"IF(H72*0.9*$B$81-2*5.3+(H76-H77)*$B$81<0,0,H72*0.9*$B$81-2*5.3+(H76-H77)*$B$81)","v":0},{"$f":"IF(I72*0.9*$B$81-2*5.3+(I76-I77)*$B$81<0,0,I72*0.9*$B$81-2*5.3+(I76-I77)*$B$81)","v":0},0,0,0,0,0,0,0]
["Total IRPP",null,null,null,null,{"$f":"+F81+F79","v":25.999999999999996},19.159999999999997,8.3399999999999981,0,0,0,0,0,0,0,0]
["ISF",null,null,null,null,null,null,null,1,1,1,1,1,1,1,1]
["Dépenses exceptionnelles"]
["Disponible",null,null,null,null,{"$f":"+F72+F73+F74+F75+F76-F77-F78-F82-F83-F84","v":111.68},102.9872,64.013087999999996,41.92721152,18.6442999808,19.337185980415995,20.043929700024322,20.76480829402481,21.500104459905302,22.250106549103407,23.015108680085476]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Financement foyer Lanson",null,{"$f":"C71","v":2007},{"$f":"D71","v":2008},null,{"$f":"F71","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["MBA",null,{"$f":"C85","v":0},{"$f":"D85","v":0},null,{"$f":"F85","v":111.68},102.9872,64.013087999999996,41.92721152,18.6442999808,19.337185980415995,20.043929700024322,20.76480829402481,21.500104459905302,22.250106549103407,23.015108680085476]
["Immobilier privé +/-",null,null,null,null,350,null,null,-250]
["Immobilier de rapport"]
["Valeurs mobilières +/-",null,null,null,null,-15,null,null,15]
["Assurance vie/capitalisation",null,null,null,null,-435,-75,-180,235]
["Participations Lanson Gastro",null,null,null,null,null,null,149]
["Endettement"]
["Capitalisation cachée",null,null,null,null,{"$f":"-F75","v":-11.68},{"$f":"-G75","v":-30.147199999999998},{"$f":"-H75","v":-34.353088},{"$f":"-I75","v":-42.92721152},{"$f":"-J75/2","v":-17.3221499904},{"$f":"-K75/2","v":-17.668592990207998},-18.021964850012161,-18.382404147012405,-18.750052229952651,-19.125053274551703,-19.507554340042738]
["Liquidités DP",null,null,null,null,{"$f":"D97","v":5},{"$f":"F97","v":5.0000000000000071},2.8400000000000105,1.5000000000000071,0.50000000000002132,1.8221499904000211,3.4907429806080188,5.5127078306201795,7.8951119776325847,10.645164207585236,13.770217482136939]
["Liquidités FP",null,null,5,null,{"$f":"SUM(F88:F96)","v":5.0000000000000071},2.8400000000000105,1.5000000000000071,0.50000000000002132,1.8221499904000211,3.4907429806080188,5.5127078306201795,7.8951119776325847,10.645164207585236,13.770217482136939,17.277771822179677]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Bilan foyer Lanson",null,{"$f":"C87","v":2007},{"$f":"D87","v":2008},null,{"$f":"F87","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capitaux propres",null,null,796,null,{"$f":"D100+F85","v":907.68000000000006},{"$f":"F100+G85","v":1010.6672000000001},1074.680288,1116.6074995199999,1135.2517995008,1154.588985481216,1174.6329151812404,1195.3977234752651,1216.8978279351704,1239.1479344842737,1262.1630431643591]
["Endettement",null,null,0]
[]
["Immobilier privé +/-",null,null,350,null,{"$f":"D103-F89","v":0},{"$f":"F103-G89","v":0},0,250,250,250,250,250,250,250,250]
["Immobilier de rapport",null,null,0,null,{"$f":"D104-F90","v":0},{"$f":"F104-G90","v":0},0,0,0,0,0,0,0,0,0]
["Valeurs mobilières +/-",null,null,40,null,{"$f":"D105-F91","v":55},{"$f":"F105-G91","v":55},55,40,40,40,40,40,40,40,40]
["Assurance vie/capitalisation",null,null,252,null,{"$f":"D106-F92","v":687},{"$f":"F106-G92","v":762},942,707,707,707,707,707,707,707,707]
["Participations",null,null,149,null,{"$f":"D107-F93","v":149},{"$f":"F107-G93","v":149},0,0,0,0,0,0,0,0,0]
["Capitalisation cachée",null,null,null,null,{"$f":"D108-F95","v":11.68},{"$f":"F108-G95","v":41.827199999999998},76.18028799999999,119.10749951999999,136.4296495104,154.09824250060799,172.12020735062015,190.50261149763256,209.2526637275852,228.3777170021369,247.88527134217964]
["Liquidités",null,null,{"$f":"D97","v":5},null,{"$f":"F97","v":5.0000000000000071},2.8400000000000105,1.5000000000000071,0.50000000000002132,1.8221499904000211,3.4907429806080188,5.5127078306201795,7.8951119776325847,10.645164207585236,13.770217482136939,17.277771822179677]
["total",null,null,{"$f":"SUM(D103:D109)","v":796},null,{"$f":"SUM(F103:F109)","v":907.68},1010.6672,1074.680288,1116.6074995199999,1135.2517995008,1154.588985481216,1174.6329151812404,1195.3977234752651,1216.8978279351704,1239.1479344842739,1262.1630431643594]
["check",null,null,{"$f":"D110-SUM(D100:D101)","v":0},null,{"$f":"F110-SUM(F100:F101)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan de la SCI Lanson IS :",null,null,null,null,null,null,null,{"$f":"I69","v":"BP2"},{"$f":"J69","v":"JSC le 05/06/2009"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["SCI Lanson ",null,{"$f":"C99","v":2007},{"$f":"D99","v":2008},null,{"$f":"F99","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Revenus locatifs",null,null,null,null,null,{"$f":"G11","v":35},{"$f":"H11","v":35},35,35,0,0,0,0,0,0]
["Charges foncières",null,null,null,null,null,3,3,3,3,3,3,3,3,3,3]
["Amortissements",null,null,null,null,null,15,15,15,15,15,15,15,15,15,15]
["Résultat d'exploitation",null,null,null,null,null,{"$f":"G117-G118-G119","v":17},17,17,17,-18,-18,-18,-18,-18,-18]
["Frais financiers",0.05,null,null,null,null,{"$f":"$B$121*(F137)","v":17.5},{"$f":"$B$121*(G137)","v":16.75},{"$f":"$B$121*(H137)","v":16},{"$f":"$B$121*(I137)","v":15.25},{"$f":"$B$121*(J137)","v":14.5},13.75,13,12.25,11.5,10.75]
["Impôt"]
["Résultat net",null,null,null,null,null,{"$f":"G120-G121","v":-0.5},{"$f":"H120-H121","v":0.25},{"$f":"I120-I121","v":1},{"$f":"J120-J121","v":1.75},{"$f":"K120-K121","v":-32.5},-31.75,-31,-30.25,-29.5,-28.75]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Financement SCI Lanson",null,{"$f":"C116","v":2007},{"$f":"D116","v":2008},null,{"$f":"F116","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["MBA",null,null,null,null,null,{"$f":"G123+G119","v":14.5},{"$f":"H123+H119","v":15.25},{"$f":"I123+I119","v":16},{"$f":"J123+J119","v":16.75},{"$f":"K123+K119","v":-17.5},-16.75,-16,-15.25,-14.5,-13.75]
["Cap+/-"]
["CCrt+/-"]
["Defi+/-",null,null,null,null,null,-15,-15,-15,-15,-15,-15,-15,-15,-15,-15]
["Immob+/-",null,null,null,null,null,{"$f":"-G89","v":0}]
["Dispo DP",null,null,null,null,null,{"$f":"F142","v":0},{"$f":"G142","v":-0.5},{"$f":"H142","v":-0.25},{"$f":"I142","v":0.75},{"$f":"J142","v":2.5},-30,-61.75,-92.75,-123,-152.5]
["Dispo FP",null,null,null,null,null,{"$f":"SUM(G126:G131)","v":-0.5},-0.25,0.75,2.5,-30,-61.75,-92.75,-123,-152.5,-181.25]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Bilan SCI Lanson",null,{"$f":"C125","v":2007},{"$f":"D125","v":2008},null,{"$f":"F125","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capropres",null,null,null,null,{"$f":"-F91","v":15},{"$f":"F135+G123","v":14.5},{"$f":"G135+H123","v":14.75},{"$f":"H135+I123","v":15.75},{"$f":"I135+J123","v":17.5},{"$f":"J135+K123","v":-15},-46.75,-77.75,-108,-137.5,-166.25]
["CCrt"]
["Defi",null,null,null,null,350,{"$f":"F137+G129","v":335},{"$f":"G137+H129","v":320},{"$f":"H137+I129","v":305},{"$f":"I137+J129","v":290},{"$f":"J137+K129","v":275},260,245,230,215,200]
["Total",null,null,null,null,{"$f":"SUM(F135:F137)","v":365},349.5,334.75,320.75,307.5,260,213.25,167.25,122,77.5,33.75]
[]
["Immobilisations",null,null,null,null,{"$f":"F89+F135","v":365},{"$f":"F140-G119","v":350},{"$f":"G140-H119","v":335},{"$f":"H140-I119","v":320},{"$f":"I140-J119","v":305},{"$f":"J140-K119","v":290},275,260,245,230,215]
["Autres"]
["Cash",null,null,null,null,null,{"$f":"G132","v":-0.5},{"$f":"H132","v":-0.25},{"$f":"I132","v":0.75},{"$f":"J132","v":2.5},{"$f":"K132","v":-30},-61.75,-92.75,-123,-152.5,-181.25]
["Total",null,null,null,null,{"$f":"SUM(F140:F142)","v":365},349.5,334.75,320.75,307.5,260,213.25,167.25,122,77.5,33.75]
["check",null,null,null,null,{"$f":"F143-F138","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]

{"sheet":"BP3","index":3,"n_rows":146,"n_cols":17,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[{"$f":"REPT(\"-\",300)","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan de la Société Lanson gastronomie : ",null,null,null,null,null,null,null,"BP2"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["EXPLOITATION en K€",null,2007,2008,null,2009,{"$f":"F4+1","v":2010},2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
["CA",null,1185,1280,null,1380,1380,1380,1380,1380]
["Autres produits",null,3,2]
["Coût des ventes",null,{"$f":"495+4","v":499},{"$f":"539-2","v":537},null,{"$f":"D7","v":537},{"$f":"+F7","v":537},{"$f":"+G7","v":537},{"$f":"+H7","v":537},{"$f":"+I7","v":537}]
["MB%",null,{"$f":"(C5-C7)/C5","v":0.5789029535864979},{"$f":"(D5-D7)/D5","v":0.58046874999999998},null,{"$f":"+F9/F5","v":0.61086956521739133},{"$f":"+G9/G5","v":0.61086956521739133},{"$f":"+H9/H5","v":0.61086956521739133},{"$f":"+I9/I5","v":0.61086956521739133},{"$f":"+J9/J5","v":0.61086956521739133}]
["Marge brute",null,{"$f":"C5+C6-C7","v":689},{"$f":"D5+D6-D7","v":745},null,{"$f":"F5-F7","v":843},{"$f":"+G5-G7","v":843},{"$f":"+H5-H7","v":843},{"$f":"+I5-I7","v":843},{"$f":"+J5-J7","v":843}]
["AACE hors loyers Lanson",null,{"$f":"131-C11","v":122},{"$f":"136-D11","v":127},null,{"$f":"140-F11","v":140},131,131,131,131]
["Loyers Lanson",null,9,9]
["Salaires et charges employés",null,{"$f":"323+144-C13","v":327},{"$f":"373+156-D13","v":389},null,{"$f":"+D12","v":389},{"$f":"+F12","v":389},{"$f":"+G12","v":389},{"$f":"+H12","v":389},{"$f":"+I12","v":389}]
["Salaires et charges Dtion",null,140,140,null,140,140,140,140,140]
["Impôts et Taxes",null,31,26,null,30,{"$f":"+F14/F5*G5","v":30},{"$f":"+G14/G5*H5","v":30},{"$f":"+H14/H5*I5","v":30},{"$f":"+I14/I5*J5","v":30}]
["Autres charges"]
["Charges d'exploitation",null,{"$f":"SUM(C10:C15)","v":629},{"$f":"SUM(D10:D15)","v":691},null,{"$f":"SUM(F10:F15)","v":699},{"$f":"SUM(G10:G15)","v":690},{"$f":"SUM(H10:H15)","v":690},{"$f":"SUM(I10:I15)","v":690},{"$f":"SUM(J10:J15)","v":690}]
["Amortissements",null,47,43,null,40,60,60,60,60]
["Provisions"]
["EBIT",null,{"$f":"C9-C16-C17-C18","v":13},{"$f":"D9-D16-D17-D18","v":11},null,{"$f":"F9-F16-F17-F18","v":104},{"$f":"G9-G16-G17-G18","v":93},{"$f":"H9-H16-H17-H18","v":93},{"$f":"I9-I16-I17-I18","v":93},{"$f":"J9-J16-J17-J18","v":93}]
["Résultat financier",0.05,-2.5,-2.5,null,{"$f":"-$B$20*D44","v":-1.85},{"$f":"-$B$20*F44","v":0},{"$f":"-$B$20*G44","v":-17.5},{"$f":"-$B$20*H44","v":-16.75},{"$f":"-$B$20*I44","v":-16}]
["Résultat courant avt impôts",null,{"$f":"C19+C20","v":10.5},{"$f":"D19+D20","v":8.5},null,{"$f":"F19+F20","v":102.15},{"$f":"G19+G20","v":93},{"$f":"H19+H20","v":75.5},{"$f":"I19+I20","v":76.25},{"$f":"J19+J20","v":77}]
["Exceptionnels"]
["IS",0.3,-1.4,-1.2,null,{"$f":"-F21*$B$23","v":-30.645},{"$f":"-$B$23*G21","v":-27.9},{"$f":"-$B$23*H21","v":-22.65},{"$f":"-$B$23*I21","v":-22.875},{"$f":"-$B$23*J21","v":-23.099999999999998}]
["Résultat net",null,{"$f":"C21+C22+C23","v":9.1},{"$f":"D21+D22+D23","v":7.3},null,{"$f":"F21+F22+F23","v":71.50500000000001},{"$f":"G21+G22+G23","v":65.099999999999994},{"$f":"H21+H22+H23","v":52.85},{"$f":"I21+I22+I23","v":53.375},{"$f":"J21+J22+J23","v":53.900000000000006}]
["Marge brute Autofincmt",null,{"$f":"C24+C17","v":56.1},{"$f":"D24+D17","v":50.3},null,{"$f":"F24+F17","v":111.50500000000001},{"$f":"G24+G17","v":125.1},{"$f":"H24+H17","v":112.85},{"$f":"I24+I17","v":113.375},{"$f":"J24+J17","v":113.9}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["FINANCEMENT en K€",null,{"$f":"C4","v":2007},{"$f":"D4","v":2008},null,{"$f":"F4","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Marge Brute Autofinancement",null,null,{"$f":"D25","v":50.3},null,{"$f":"F25","v":111.50500000000001},{"$f":"G25","v":125.1},{"$f":"H25","v":112.85},{"$f":"I25","v":113.375},{"$f":"J25","v":113.9}]
["Capital +/-",null,{"$f":"C41","v":105},{"$f":"+D41-C41-D24","v":-0.29999999999999982},null,-60,-70,-50]
["Cptes crts +/-"]
["Dettes financières +/-",null,{"$f":"C44","v":69},{"$f":"D44-C44","v":-32},null,-37,350,-15,-15,-15]
["Social Fiscal +/-",null,{"$f":"C46","v":57},{"$f":"D46-C46","v":-3}]
["BFR+/-",null,{"$f":"C66","v":-15},{"$f":"D66","v":-1},null,{"$f":"F66","v":-1},{"$f":"G66","v":0},{"$f":"H66","v":0},{"$f":"I66","v":0},{"$f":"J66","v":0}]
["Immobilisations +/-",null,{"$f":"-C50-C51-C52","v":-140},{"$f":"C51+C50-D17-D51-D50","v":-38},null,{"$f":"-F17","v":-40},{"$f":"-G17-G31","v":-410},-40,-40,-40]
["Autres+/-",null,{"$f":"C47-C55","v":-16},{"$f":"+D47-C47+C55-D55","v":-5}]
["Dispo Début Période",null,{"$f":"B37","v":0},{"$f":"C37","v":60},null,{"$f":"D37","v":31},{"$f":"F37","v":4.5050000000000097},{"$f":"G37","v":-0.3949999999999676},{"$f":"H37","v":7.4550000000000267},{"$f":"I37","v":65.830000000000027}]
["Dispo Fin Période",null,{"$f":"SUM(C28:C36)","v":60},{"$f":"SUM(D28:D36)","v":31},null,{"$f":"SUM(F28:F36)","v":4.5050000000000097},{"$f":"SUM(G28:G36)","v":-0.3949999999999676},{"$f":"SUM(H28:H36)","v":7.4550000000000267},{"$f":"SUM(I28:I36)","v":65.830000000000027},{"$f":"SUM(J28:J36)","v":124.73000000000003}]
["contrôle",null,{"$f":"C37-C56","v":0},{"$f":"D37-D56","v":0},null,{"$f":"F37-F56","v":0},{"$f":"G37-G56","v":0},{"$f":"H37-H56","v":0},{"$f":"I37-I56","v":0},{"$f":"J37-J56","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BILANS en K€",null,{"$f":"C27","v":2007},{"$f":"D27","v":2008},null,{"$f":"F27","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capitaux propres",null,105,112,null,{"$f":"D41+F24+F29","v":123.505},{"$f":"F41+G24+G29","v":118.60499999999999},{"$f":"G41+H24+H29","v":121.45499999999998},{"$f":"H41+I24+I29","v":174.82999999999998},{"$f":"I41+J24+J29","v":228.73}]
["Provisions"]
["Cptes courants"]
["Dettes financières",null,69,37,null,{"$f":"D44+F31","v":0},{"$f":"F44+G31","v":350},{"$f":"G44+H31","v":335},{"$f":"H44+I31","v":320},{"$f":"I44+J31","v":305}]
["Dettes Fournisseurs"]
["Social Fiscal",null,57,54,null,{"$f":"D46+F32","v":54},{"$f":"F46+G32","v":54},{"$f":"G46+H32","v":54},{"$f":"H46+I32","v":54},{"$f":"I46+J32","v":54}]
["Autres"]
["Total",null,{"$f":"SUM(C41:C47)","v":231},{"$f":"SUM(D41:D47)","v":203},null,{"$f":"SUM(F41:F47)","v":177.505},{"$f":"SUM(G41:G47)","v":522.60500000000002},{"$f":"SUM(H41:H47)","v":510.45499999999998},{"$f":"SUM(I41:I47)","v":548.82999999999993},{"$f":"SUM(J41:J47)","v":587.73}]
[]
["Actifs incorporels",null,6,6,null,{"$f":"D50","v":6},{"$f":"F50","v":6},{"$f":"G50","v":6},{"$f":"H50","v":6},{"$f":"I50","v":6}]
["Actifs corporels",null,{"$f":"24+107","v":131},{"$f":"25+101","v":126},null,{"$f":"D51-F34-F17","v":126},{"$f":"F51-G34-G17","v":476},{"$f":"G51-H34-H17","v":456},{"$f":"H51-I34-I17","v":436},{"$f":"I51-J34-J17","v":416}]
["Actifs financiers",null,3,3,null,{"$f":"D52","v":3},{"$f":"F52","v":3},{"$f":"G52","v":3},{"$f":"H52","v":3},{"$f":"I52","v":3}]
["Stocks",null,15,16,null,{"$f":"F61","v":17},17,17,17,17]
["Clients",null,null,null,null,0,0,0,0,0]
["Autres",null,{"$f":"7+1+8","v":16},{"$f":"10+1+10","v":21},null,{"$f":"D55-F35","v":21},{"$f":"F55-G35","v":21},{"$f":"G55-H35","v":21},{"$f":"H55-I35","v":21},{"$f":"I55-J35","v":21}]
["Disponibilités",null,60,31,null,{"$f":"F37","v":4.5050000000000097},{"$f":"G37","v":-0.3949999999999676},{"$f":"H37","v":7.4550000000000267},{"$f":"I37","v":65.830000000000027},{"$f":"J37","v":124.73000000000003}]
["Total",null,{"$f":"SUM(C50:C56)","v":231},{"$f":"SUM(D50:D56)","v":203},null,{"$f":"SUM(F50:F56)","v":177.505},{"$f":"SUM(G50:G56)","v":522.60500000000002},{"$f":"SUM(H50:H56)","v":510.45500000000004},{"$f":"SUM(I50:I56)","v":548.83000000000004},{"$f":"SUM(J50:J56)","v":587.73}]
["contrôle",null,{"$f":"+C57-C48","v":0},{"$f":"+D57-D48","v":0},null,{"$f":"+F57-F48","v":0},{"$f":"+G57-G48","v":0},{"$f":"+H57-H48","v":0},{"$f":"+I57-I48","v":0},{"$f":"+J57-J48","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BFR",null,{"$f":"+C40","v":2007},{"$f":"+D40","v":2008},null,{"$f":"+F40","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Stocks",null,{"$f":"+C53","v":15},{"$f":"+D53","v":16},null,17,17,17,17,17]
["Clients",null,{"$f":"+C54","v":0},{"$f":"+D54","v":0},null,0,0,0,0,0]
["Fournisseurs",null,{"$f":"+C45","v":0},{"$f":"+D45","v":0},null,0,0,0,0,0]
["BFR",null,{"$f":"+C61+C62-C63","v":15},{"$f":"+D61+D62-D63","v":16},null,{"$f":"+F61+F62-F63","v":17},{"$f":"+G61+G62-G63","v":17},{"$f":"+H61+H62-H63","v":17},{"$f":"+I61+I62-I63","v":17},{"$f":"+J61+J62-J63","v":17}]
["BFR%CA",null,{"$f":"+C64/C5","v":1.2658227848101266E-2},{"$f":"+D64/D5","v":1.2500000000000001E-2},null,{"$f":"+F64/F5","v":1.2318840579710146E-2},{"$f":"+G64/G5","v":1.2318840579710146E-2},{"$f":"+H64/H5","v":1.2318840579710146E-2},{"$f":"+I64/I5","v":1.2318840579710146E-2},{"$f":"+J64/J5","v":1.2318840579710146E-2}]
["Delta BFR",null,{"$f":"-C64","v":-15},{"$f":"C64-D64","v":-1},null,{"$f":"D64-F64","v":-1},{"$f":"F64-G64","v":0},{"$f":"G64-H64","v":0},{"$f":"H64-I64","v":0},{"$f":"I64-J64","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan du Foyer Lanson :",null,null,null,null,null,null,null,{"$f":"I2","v":"BP2"},{"$f":"J2","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Foyer Lanson ",null,{"$f":"C60","v":2007},{"$f":"D60","v":2008},null,{"$f":"F60","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Salaires puis Retraites net",null,{"$f":"C13/3*2*0.8","v":74.666666666666671},{"$f":"D13/3*2*0.8","v":74.666666666666671},null,{"$f":"F13/3*2*0.8","v":74.666666666666671},{"$f":"G13/3*2*0.8","v":74.666666666666671},{"$f":"H13/3*2*0.8","v":74.666666666666671},25,{"$f":"I72","v":25},25,25,25,25,25,25]
["Dividendes",null,null,{"$f":"-D29","v":0.29999999999999982},null,{"$f":"-F29","v":60},70,50,0,0,0,0,0,0,0,0]
["+V mobilières"]
["Revenus valeurs mob",0.04,null,null,null,{"$f":"$B$75*(D105+D106+D108)","v":11.68},{"$f":"$B$75*(F105+F106+F108)","v":15.347200000000001},33.361088000000002,43.495531520000007,34.2353527808,35.035352780799997,35.835352780800001,36.635352780799998,37.435352780800002,38.2353527808,39.035352780799997]
["Loyers",null,{"$f":"C11","v":9},{"$f":"D11","v":9},null,9,{"$f":"G11","v":0},0,0,0,0,0,0,0,0,0]
["Charges foncières",null,null,null,null,3]
["Charges quotidiennes",null,null,null,null,40,40,40,40,40,40,40,40,40,40,40]
["I/dividendes",0.30099999999999999,null,null,null,{"$f":"IF((0.6*F73-4)*$B$81<0,0,(0.6*F73-4)*$B$81)","v":9.6},{"$f":"IF((0.6*G73-4)*$B$79<0,0,(0.6*G73-4)*$B$79)","v":11.437999999999999},7.8259999999999996,0,0,0,0,0,0,0,0]
["I/+V mob",0.19600000000000001,null,null,null,null,null,null,{"$f":"IF((I75+I95)/2<9.2,0,+$B$80*(I75+I95)/2)","v":0},{"$f":"IF((J75+J95)/2<9.2,0,+$B$80*(J75+J95)/2)","v":0},0,0,0,0,0,1.8654645725183998]
["Impôt progressif",0.3,0.14000000000000001,null,null,{"$f":"F72*0.9*$B$81+(F76-F77)*$B$81-11","v":10.96},{"$f":"G72*0.9*$B$81+(G76-G77)*$B$81-11","v":9.16},{"$f":"IF(H72*0.9*$B$81+(H76-H77)*$B$81-11<0,0,H72*0.9*$B$81+(H76-H77)*$B$81-11)","v":9.16},{"$f":"IF(I72*0.9*$C$81+(I76-I77)*$C$81-2.6<0,0,I72*0.9*$C$81+(I76-I77)*$C$81-2.6)","v":0.55000000000000027},{"$f":"IF(J72*0.9*$C$81+(J76-J77)*$C$81-2.6<0,0,J72*0.9*$C$81+(J76-J77)*$C$81-2.6)","v":0.55000000000000027},0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027]
["Total IRPP",null,null,null,null,{"$f":"+F81+F79+F80","v":20.560000000000002},{"$f":"+G81+G79+G80","v":20.597999999999999},16.986000000000001,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,0.55000000000000027,2.4154645725183999]
["ISF",null,null,null,null,null,null,null,1,1,1,1,1,1,1,1]
["Dépenses exceptionnelles"]
["Disponible",null,null,null,null,{"$f":"+F72+F73+F74+F75+F76-F77-F78-F82-F83-F84","v":91.78666666666669},99.415866666666673,101.04175466666668,26.945531520000014,17.685352780799999,18.485352780799996,19.2853527808,20.085352780799997,20.885352780800002,21.685352780799999,20.619888208281598]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Financement foyer Lanson",null,{"$f":"C71","v":2007},{"$f":"D71","v":2008},null,{"$f":"F71","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["MBA",null,{"$f":"C85","v":0},{"$f":"D85","v":0},null,{"$f":"F85","v":91.78666666666669},99.415866666666673,101.04175466666668,26.945531520000014,17.685352780799999,18.485352780799996,19.2853527808,20.085352780799997,20.885352780800002,21.685352780799999,20.619888208281598]
["Immobilier privé +/-",null,null,null,null,null,350,null,-250]
["Immobilier de rapport"]
["Valeurs mobilières +/-"]
["Assurance vie/capitalisation",null,null,null,null,-80,-435,-220,275]
["Participations Lanson Gastro",null,null,null,null,null,null,149]
["Endettement"]
["Capitalisation cachée",null,null,null,null,{"$f":"-F75","v":-11.68},{"$f":"-G75","v":-15.347200000000001},{"$f":"-H75","v":-33.361088000000002},{"$f":"-I75","v":-43.495531520000007},-20,-20,-20,-20,-20,-20,-20]
["Liquidités DP",null,null,null,null,{"$f":"D97","v":5},{"$f":"F97","v":5.1066666666666904},4.1753333333333487,0.85600000000002296,9.3060000000000187,6.9913527808000175,5.4767055616000135,4.7620583424000138,4.8474111232000112,5.7327639040000129,7.4181166848000117]
["Liquidités FP",null,null,5,null,{"$f":"SUM(F88:F96)","v":5.1066666666666904},4.1753333333333487,0.85600000000002296,9.3060000000000187,6.9913527808000175,5.4767055616000135,4.7620583424000138,4.8474111232000112,5.7327639040000129,7.4181166848000117,8.0380048930816095]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Bilan foyer Lanson",null,{"$f":"C87","v":2007},{"$f":"D87","v":2008},null,{"$f":"F87","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capitaux propres",null,null,796,null,{"$f":"D100+F85","v":887.78666666666663},{"$f":"F100+G85","v":987.20253333333335},1088.2442880000001,1115.1898195200001,1132.8751723008002,1151.3605250816001,1170.6458778624001,1190.7312306432,1211.6165834240001,1233.3019362048001,1253.9218244130816]
["Endettement",null,null,0]
[]
["Immobilier privé +/-",null,null,350,null,{"$f":"D103-F89","v":350},{"$f":"F103-G89","v":0},0,250,250,250,250,250,250,250,250]
["Immobilier de rapport",null,null,0,null,{"$f":"D104-F90","v":0},{"$f":"F104-G90","v":0},0,0,0,0,0,0,0,0,0]
["Valeurs mobilières +/-",null,null,40,null,{"$f":"D105-F91","v":40},{"$f":"F105-G91","v":40},40,40,40,40,40,40,40,40,40]
["Assurance vie/capitalisation",null,null,252,null,{"$f":"D106-F92","v":332},{"$f":"F106-G92","v":767},987,712,712,712,712,712,712,712,712]
["Participations",null,null,149,null,{"$f":"D107-F93","v":149},{"$f":"F107-G93","v":149},0,0,0,0,0,0,0,0,0]
["Capitalisation cachée",null,null,null,null,{"$f":"D108-F95","v":11.68},{"$f":"F108-G95","v":27.027200000000001},60.388288000000003,103.88381952,123.88381952,143.88381952,163.88381952,183.88381952,203.88381952,223.88381952,243.88381952]
["Liquidités",null,null,{"$f":"D97","v":5},null,{"$f":"F97","v":5.1066666666666904},4.1753333333333487,0.85600000000002296,9.3060000000000187,6.9913527808000175,5.4767055616000135,4.7620583424000138,4.8474111232000112,5.7327639040000129,7.4181166848000117,8.0380048930816095]
["total",null,null,{"$f":"SUM(D103:D109)","v":796},null,{"$f":"SUM(F103:F109)","v":887.78666666666663},987.20253333333335,1088.2442880000001,1115.1898195200001,1132.8751723008002,1151.3605250816001,1170.6458778624001,1190.7312306432002,1211.6165834240001,1233.3019362048001,1253.9218244130816]
["check",null,null,{"$f":"D110-SUM(D100:D101)","v":0},null,{"$f":"F110-SUM(F100:F101)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Comptes et Business Plan de la SCI Lanson :",null,null,null,null,null,null,null,{"$f":"I69","v":"BP2"},{"$f":"J69","v":0}]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["SCI Lanson ",null,{"$f":"C99","v":2007},{"$f":"D99","v":2008},null,{"$f":"F99","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Revenus locatifs"]
["Charges foncières"]
["Amortissements"]
["Résultat d'exploitation"]
["Frais financiers"]
["Impôt"]
["Résultat net"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Financement SCI Lanson",null,{"$f":"C116","v":2007},{"$f":"D116","v":2008},null,{"$f":"F116","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["MBA"]
["Cap+/-"]
["CCrt+/-"]
["Defi+/-"]
["Immob+/-"]
["Dispo DP"]
["Dispo FP"]
["check"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["Bilan SCI Lanson",null,{"$f":"C125","v":2007},{"$f":"D125","v":2008},null,{"$f":"F125","v":2009},2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Capropres"]
["CCrt"]
["Defi"]
["Total"]
[]
["Immobilisations"]
["Autres"]
["Cash"]
["Total"]
["check"]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]

{"sheet":"Titres","index":4,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"BP1","BP2"]
["Immobilier privé +/-",null,null,{"$f":"'BP1'!I103","v":250},{"$f":"'BP3'!I103","v":250}]
["Immobilier de rapport",null,null,{"$f":"'BP1'!I104","v":0},{"$f":"'BP3'!I104","v":0}]
["Valeurs mobilières +/-",null,null,{"$f":"'BP1'!I105","v":40},{"$f":"'BP3'!I105","v":40}]
["Assurance vie/capitalisation",null,null,{"$f":"'BP1'!I106","v":572},{"$f":"'BP3'!I106","v":712}]
["Participations",null,null,{"$f":"'BP1'!I107","v":0},{"$f":"'BP3'!I107","v":0}]
["Capitalisation cachée",null,null,{"$f":"'BP1'!I108","v":80.178859520000003},{"$f":"'BP3'!I108","v":103.88381952}]
["Liquidités",null,null,{"$f":"'BP1'!I109","v":8.8133333333333415},{"$f":"'BP3'!I109","v":9.3060000000000187}]
["total",null,null,{"$f":"'BP1'!I110","v":950.99219285333345},{"$f":"'BP3'!I110","v":1115.1898195200001}]
[]
[null,null,null,"Projections Economiques, financières et fiscales :"]
[]
[null,null,null,"LANSON GASTRONOMIE"]
[]
[null,null,null,"FOYER LANSON"]
[]
[null,null,null,"Sommaire :"]
[]
[]
[null,null,null,"1 - BP 1 : projection de l'organisation actuelle",null,null,null,null,null,null,"p.2"]
[]
[null,null,null,"2 - BP2 :  mise en place d'une SCI + portefeuille",null,null,null,null,null,null,"p.5"]
[]
[null,null,null,"3 - BP3 : transfert du bien à Lanson Gastronomie",null,null,null,null,null,null,"p.8"]
[]
[]
[]
[]
[]
[null,null,null,"Arkanissim - JSC/ER juin 2009"]