{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Outil de simulation","Bilan ouverture","Amortissements","Compte de résultats 3 ans","Trésorerie année 1","Trésorerie année 2","Trésorerie année 3","Bilan sur 3 ans"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Outil de simulation","index":0,"n_rows":172,"n_cols":60,"rows_kept":172,"cut":false,"hidden":false,"merged":[[10,1,10,8],[47,2,48,8],[47,1,48,1],[96,1,97,14],[47,9,48,16],[76,9,77,16],[76,2,77,8],[76,1,77,1],[82,2,93,5],[159,32,159,33],[145,29,145,30],[145,32,145,33],[76,19,77,21],[76,17,77,18],[145,41,145,42],[159,35,159,36],[145,44,145,45],[1,1,1,7],[114,1,114,14],[16,1,16,21],[18,19,19,21],[18,17,19,18],[18,7,19,16],[18,2,19,6],[24,2,35,5],[53,2,64,5],[47,19,48,21],[47,17,48,18],[145,35,145,36],[145,38,145,39]]}
[]
[null,"Définir le cycle d'exploitation prévisionnel de la structure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Données complémentaires"]
[null,"Prévisions Année 1","CA"," Marge estimée","Rotation \ndes stocks","Délais de\npaiements (en J)","Stock\n Initial","Rabais",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VB","Montant du rabais","Marge \ncalculée sur CA","Marge brute\nsur VB","Coût des\n ventes","Rotation des \nstocks ( en J)","Achats","Achats Jours TTC","BPS en J","BPS en €","BPS en % du CA","Stock moyen","Stock \nFinal","écart de\n stocks"]
[null,"Librairie",120000,0.33,2.48,70,30000,1.2E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4+AB4","v":121457.4898785425},{"$f":"C4*H4/(100%-H4)","v":1457.48987854251},{"$f":"D4*(100%-H4)","v":0.32604},{"$f":"D4-H4","v":0.318},{"$f":"AA4-(AA4*D4)","v":81376.518218623474},{"$f":"365/E4","v":147.17741935483872},{"$f":"(AE4)+AM4-G4","v":87002.742588481109},{"$f":"AG4*1.055/365","v":251.47368063245906},{"$f":"AF4-F4","v":77.177419354838719},{"$f":"AI4*AH4","v":19408.089706876075},{"$f":"AJ4/C4","v":0.16173408089063396},{"$f":"AE4/E4","v":32813.112184928817},{"$f":"AL4*2-G4","v":35626.224369857635},{"$f":"AM4-G4","v":5626.2243698576349}]
[null,"Papeterie",40000,0.4,2.2999999999999998,30,10325,0]
[null,"Jeux",0,0.42499999999999999,2,30,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Données complémentaires autres produits "]
[null,"Carterie",0,0.5,1,30,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Papeterie"]
[null,"Restauration",0,0.7,24,10,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock \nFinal","Stock\nMoyen","écart de\n stocks","Coût des \n ventes","Rotation des \nstocks (en J)","Achats","Achats\n jours TTC","BPS en J","BPS en €","BPS en % du CA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB9*2-G5","v":10544.565217391308},{"$f":"IF(E5=0,\"\",AD9/E5)","v":10434.782608695654},{"$f":"AA9-G5","v":219.56521739130767},{"$f":"C5-(C5*D5)","v":24000},{"$f":"365/E5","v":158.69565217391306},{"$f":"AD9+AA9-G5","v":24219.565217391311},{"$f":"AF9*1.2/365","v":79.625967837998829},{"$f":"AE9-F5","v":128.69565217391306},{"$f":"AH9*AG9","v":10247.515860890286},{"$f":"AI9/C5","v":0.25618789652225715}]
[]
[null,"Total général",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jeux"]
[null,"CA","Coût des \nventes","Stock \nMoyen","Rotation","Rotation en J","BPS en J","BPS en €","BPS en % du CA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock \nFinal","Stock\nMoyen","écart de\n stocks","Coût des \n ventes","Rotation des \nstocks (en J)","Achats","Achats\n jours TTC","BPS en J","BPS en €","BPS en % du CA"]
[null,{"$f":"C5+C4+C6+C7+C8","v":160000},{"$f":"AD9+AE4+AD13+AD17+AD21","v":105376.51821862347},{"$f":"AB9+AL4+AB13+AB17+AB21","v":43247.894793624473},{"$f":"C13/D13","v":2.436569889042504},{"$f":"365/E13","v":149.80075131086579},{"$f":"H13/(B13/365)","v":67.651850201467013},{"$f":"AI9+AJ4+AI13+AI17+AI21","v":29655.605567766361},{"$f":"H13/B13","v":0.18534753479853974},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB13*2-G6","v":0},{"$f":"AD13/E6","v":0},{"$f":"AA13-G6","v":0},{"$f":"C6-(C6*D6)","v":0},{"$f":"365/E6","v":182.5},{"$f":"AD13+AA13-G6","v":0},{"$f":"AF13*1.2/365","v":0},{"$f":"AE13-F6","v":152.5},{"$f":"AH13*AG13","v":0},{"$f":"AI13/C6","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Carterie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carterie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock \nFinal","Stock\nMoyen","écart de\n stocks","Coût des \n ventes","Rotation des \nstocks (en J)","Achats","Achats\n jours TTC","BPS en J","BPS en €","BPS en % du CA"]
[null,"Tableaux de répartition et projection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB17*2-G7","v":0},{"$f":"AD17/E7","v":0},{"$f":"AA17-G7","v":0},{"$f":"C7-(C7*D7)","v":0},{"$f":"365/E7","v":365},{"$f":"AD17+AA17-G7","v":0},{"$f":"AF17*1.2/365","v":0},{"$f":"AE17-F7","v":335},{"$f":"AH17*AG17","v":0},{"$f":"AI17/C7","v":{"$error":"#DIV/0!"}}]
[]
[null,"Année 1","Librairie",null,null,null,null,"Autres produits 20%",null,null,null,null,null,null,null,null,null,"Restauration / Café",null,"Total",null,null,null,null,null,null,"Restauration / Café"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock \nFinal","Stock\nMoyen","écart de\n stocks","Coût des \n ventes","Rotation des \nstocks (en J)","Achats","Achats\n jours TTC","BPS en J","BPS en €","BPS en % du CA"]
[null,null,"Comptant","% VB","Facturation","%","Total Librairie","%","% sur VB","Papeterie","%","Jeux","%","Carterie","%","Total Autres produits","%","Total restauration","%",null,"%","% VB",null,null,null,null,{"$f":"AB21*2-G8","v":0},{"$f":"AD21/E8","v":0},{"$f":"AA21-G8","v":0},{"$f":"C8-(C8*D8)","v":0},{"$f":"365/E8","v":15.208333333333334},{"$f":"AD21+AA21-G8","v":0},{"$f":"AF21*1.2/365","v":0},{"$f":"AE21-F8","v":5.2083333333333339},{"$f":"AH21*AG21","v":0},{"$f":"AI21/C8","v":{"$error":"#DIV/0!"}}]
[null,"Ventes brutes",{"$f":"G22-E22","v":121457.4898785425},1,{"$f":"E24+E23","v":0},1,{"$f":"G24+G23","v":121457.4898785425},null,1,{"$f":"J24+J23","v":40000},1,{"$f":"L23+L24","v":0},1,{"$f":"N23+N24","v":0},1,{"$f":"J22+L22+N22","v":40000},null,{"$f":"R23+R24","v":0},1,{"$f":"G22+P22+R22","v":161457.48987854249},null,1]
[null,"réduction",{"$f":"G23-E23","v":1457.48987854251},5.3E-3,{"$f":"E24*F23/F24","v":0},0.09,{"$f":"G24*I23/I24","v":1457.48987854251},null,{"$f":"'Outil de simulation'!H4","v":1.2E-2},{"$f":"J24*K23/K24","v":0},{"$f":"H5","v":0},{"$f":"L24*M23/M24","v":0},{"$f":"H6","v":0},{"$f":"N24*O23/O24","v":0},{"$f":"H7","v":0},{"$f":"N23+L23+J23","v":0},{"$f":"P23/P24","v":0},{"$f":"R24*S23/S24","v":0},{"$f":"H8","v":0},{"$f":"G23+P23+R23","v":1457.48987854251},null,{"$f":"T23/T22","v":9.0270812437311942E-3}]
[null,"CA",{"$f":"G24-E24","v":120000},{"$f":"D22-D23","v":0.99470000000000003},0,{"$f":"F22-F23","v":0.91},{"$f":"'Outil de simulation'!C4","v":120000},1,{"$f":"I22-I23","v":0.98799999999999999},{"$f":"C5","v":40000},{"$f":"K22-K23","v":1},{"$f":"C6","v":0},{"$f":"M22-M23","v":1},{"$f":"C7","v":0},{"$f":"O22-O23","v":1},{"$f":"J24+L24+N24","v":40000},null,{"$f":"C8","v":0},{"$f":"S22-S23","v":1},{"$f":"G24+P24+R24","v":160000},1]
[null,null,"Vous pouvez définir ici le montant du CA que vous souhaitez réaliser avec les collectivités. Ne modifiez que la donnée en rouge (facturation librairie). La réduction de 15 % correspond au paiement de la Sofia et de la remise classique collectivités (9 % + 6 %). Pour les autres parties, autres produits (TVA 20 %) et restauration (TVA multiple), vous pouvez avez déjà défini d'éventuels rabais. Toutefois il faut prêter attention au rabais résultant de la facturation qui risquent d'être supérieurs au rabais définis en H4"]
[null,"Stock Initial",null,null,null,null,{"$f":"'Outil de simulation'!G4","v":30000},null,null,{"$f":"G5","v":10325},null,{"$f":"G6","v":0},null,{"$f":"G7","v":0},null,{"$f":"J26+L26+N26","v":10325},null,{"$f":"G8","v":0},null,{"$f":"G26+P26+R26","v":40325}]
[null,"Achats",null,null,null,null,{"$f":"AG4","v":87002.742588481109},null,null,{"$f":"J24-(J24*K32)+J28-J26","v":24219.565217391311},null,{"$f":"L30-L26+L28","v":0},null,{"$f":"N30-N26+N28","v":0},null,{"$f":"J27+L27+N27","v":24219.565217391311},null,{"$f":"R30-R26+R28","v":0},null,{"$f":"G27+P27+R27","v":111222.30780587242}]
[null,"Stock Final",null,null,null,null,{"$f":"'Outil de simulation'!AM4","v":35626.224369857635},null,null,{"$f":"AA9","v":10544.565217391308},null,{"$f":"AA13","v":0},null,{"$f":"AA17","v":0},null,{"$f":"J28+L28+N28","v":10544.565217391308},null,{"$f":"AA21","v":0},null,{"$f":"G28+P28+R28","v":46170.789587248946}]
[]
[null,"Coût des ventes",null,null,null,null,{"$f":"'Outil de simulation'!AE4","v":81376.518218623474},null,null,{"$f":"AD9","v":24000},null,{"$f":"AD13","v":0},null,{"$f":"AD17","v":0},null,{"$f":"J30+L30+N30","v":24000},null,{"$f":"AD21","v":0},null,{"$f":"G30+P30+R30","v":105376.51821862347}]
[null,"Marge brute",null,null,null,null,{"$f":"G22*I31","v":38623.481781376518},{"$f":"G31/G24","v":0.32186234817813764},{"$f":"'Outil de simulation'!AD4","v":0.318},{"$f":"J32-J23","v":16000},0.4,0,0.42499999999999999,0,0.5,{"$f":"N31+L31+J31","v":16000},{"$f":"P31/P24","v":0.4},{"$f":"R32-R23","v":0},{"$f":"R31/R24","v":{"$error":"#DIV/0!"}},{"$f":"T24-T30","v":54623.481781376526},{"$f":"T31/T24","v":0.34139676113360329},{"$f":"T31/T22","v":0.33831494483450358}]
[null,"Marge commerciale",null,null,null,null,{"$f":"G23+G31","v":40080.971659919029},null,{"$f":"'Outil de simulation'!D4","v":0.33},{"$f":"J22*K32","v":16000},{"$f":"D5","v":0.4},{"$f":"L22*M32","v":0},{"$f":"D6","v":0.42499999999999999},{"$f":"N22*O32","v":0},{"$f":"D7","v":0.5},{"$f":"J32+L32+N32","v":16000},{"$f":"P32/P24","v":0.4},{"$f":"R22*S32","v":0},{"$f":"D8","v":0.7},{"$f":"T31+T23","v":56080.971659919036},null,{"$f":"T32/T22","v":0.34734202607823478}]
[]
[null,"Stock Moyen",null,null,null,null,{"$f":"'Outil de simulation'!AL4","v":32813.112184928817},null,null,{"$f":"AB9","v":10434.782608695654},null,{"$f":"AB13","v":0},null,{"$f":"AB17","v":0},null,{"$f":"N34+L34+J34","v":10434.782608695654},null,{"$f":"AB21","v":0},null,{"$f":"G34+P34+R34","v":43247.894793624473}]
[null,"Rotation",null,null,null,null,{"$f":"G30/G34","v":2.4800000000000004},null,null,{"$f":"IF(J34=0,\"\",J30/J34)","v":2.2999999999999998},null,{"$f":"L30/L34","v":{"$error":"#DIV/0!"}},null,{"$f":"N30/N34","v":{"$error":"#DIV/0!"}},null,{"$f":"P30/P34","v":2.2999999999999998},null,{"$f":"R30/R34","v":{"$error":"#DIV/0!"}},null,{"$f":"T30/T34","v":2.436569889042504}]
[null,"Rotation en jours",null,null,null,null,{"$f":"365/G35","v":147.17741935483869},null,null,{"$f":"IF(J35=0,\"\",365/J35)","v":158.69565217391306},null,{"$f":"365/L35","v":{"$error":"#DIV/0!"}},null,{"$f":"365/N35","v":{"$error":"#DIV/0!"}},null,{"$f":"365/P35","v":158.69565217391306},null,{"$f":"365/R35","v":{"$error":"#DIV/0!"}},null,{"$f":"365/T35","v":149.80075131086579}]
[]
[]
[null,"Prévisions Année 2","CA","Rabais","Stock final","Marge commerciale"]
[null,"Librairie",0.15,1.2E-2,0,0.34]
[null,"Facturation ",0]
[null,"Papeterie",0.1,0,0,0.4]
[null,"Jeux",0,0,0,0]
[null,"Carterie",0,0,0,0]
[null,"Restauration/café",0,0,0,0]
[]
[]
[null,"Année 2","Librairie",null,null,null,null,null,null,"Autres produits 20%",null,null,null,null,null,null,null,"Restauration / Café",null,"Total"]
[]
[null,null,"Comptant","% VB","Facturation","%","Total","%","% sur VB","Papeterie","%","Jeux","%","Carterie","%","Total Autres produits","%","Total restauration","%",null,"%","% VB"]
[null,"Ventes brutes",{"$f":"G51-E51","v":139676.11336032388},1,{"$f":"E53+E52","v":0},1,{"$f":"G53+G52","v":139676.11336032388},null,1,{"$f":"J53+J52","v":44000},1,{"$f":"L52+L53","v":0},1,{"$f":"N52+N53","v":0},1,{"$f":"N51+L51+J51","v":44000},null,{"$f":"R52+R53","v":0},1,{"$f":"G51+P51+R51","v":183676.11336032388},null,1]
[null,"réduction",{"$f":"G52-E52","v":1676.1133603238866},{"$f":"C52/C51","v":1.2E-2},{"$f":"E53*F52/F53","v":0},0.09,{"$f":"G53*I52/I53","v":1676.1133603238866},null,{"$f":"D40","v":1.2E-2},{"$f":"J53*K52/K53","v":0},{"$f":"D42","v":0},{"$f":"L53*M52/M53","v":0},{"$f":"D43","v":0},{"$f":"N53*O52/O53","v":0},{"$f":"D44","v":0},{"$f":"N52+L52+J52","v":0},{"$f":"P52/P53","v":0},{"$f":"R53*S52/S53","v":0},{"$f":"D45","v":0},{"$f":"G52+P52+R52","v":1676.1133603238866},null,{"$f":"T52/T51","v":9.1253747134544174E-3}]
[null,"CA",{"$f":"G53-E53","v":138000},null,{"$f":"E24+(E24*C41)","v":0},{"$f":"F51-F52","v":0.91},{"$f":"G24+(G24*C40)","v":138000},1,{"$f":"I51-I52","v":0.98799999999999999},{"$f":"J24+(J24*C42)","v":44000},{"$f":"K51-K52","v":1},{"$f":"L24+(L24*C43)","v":0},{"$f":"M51-M52","v":1},{"$f":"N24+(N24*C43)","v":0},{"$f":"O51-O52","v":1},{"$f":"N53+L53+J53","v":44000},null,{"$f":"R24+(R24*C45)","v":0},{"$f":"S51-S52","v":1},{"$f":"G53+P53+R53","v":182000},1]
[null,null,"Notes libres: marges + 1% en librairie, papet identique, stock identique. JE suis d'avis de garder une marge de manœuvre avec le stock et donc de ne pas partir aveec un stock au maxi."]
[null,"Stock Initial",null,null,null,null,{"$f":"G28","v":35626.224369857635},null,null,{"$f":"J28","v":10544.565217391308},null,{"$f":"L28","v":0},null,{"$f":"N28","v":0},null,{"$f":"N55+L55+J55","v":10544.565217391308},null,{"$f":"R28","v":0},null,{"$f":"G55+P55+R55","v":46170.789587248946}]
[null,"Achats",null,null,null,null,{"$f":"G59+G57-G55","v":92186.234817813762},null,null,{"$f":"J59+J57-J55","v":26400.000000000004},null,{"$f":"L59+L57-L55","v":0},null,{"$f":"N59+N57-N55","v":0},null,{"$f":"P59+P57-P55","v":26400.000000000004},null,{"$f":"R59+R57-R55","v":0},null,{"$f":"G56+P56+R56","v":118586.23481781376}]
[null,"Stock Final",null,null,null,null,{"$f":"G55+E40","v":35626.224369857635},null,null,{"$f":"J55+E42","v":10544.565217391308},null,{"$f":"L55+E43","v":0},null,{"$f":"N55+E44","v":0},null,{"$f":"N57+L57+J57","v":10544.565217391308},null,{"$f":"R55+E45","v":0},null,{"$f":"G57+P57+R57","v":46170.789587248946}]
[]
[null,"Coût des ventes",null,null,null,null,{"$f":"G51-(G51*I61)","v":92186.234817813762},null,null,{"$f":"J51-(J51*K61)","v":26400},null,{"$f":"L51-(L51*M61)","v":0},null,{"$f":"N51-(N51*O61)","v":0},null,{"$f":"N59+L59+J59","v":26400},null,{"$f":"R51-(R51*S61)","v":0},null,{"$f":"G59+P59+R59","v":118586.23481781376}]
[null,"Marge brute",null,null,null,null,{"$f":"G51*I60","v":45813.765182186238},{"$f":"G60/G53","v":0.33198380566801622},{"$f":"I61-I52","v":0.32800000000000001},{"$f":"J61-J52","v":17600},null,{"$f":"L61-L52","v":0},null,{"$f":"N61-N52","v":0},null,{"$f":"P61-P52","v":17600},{"$f":"P60/P53","v":0.4},{"$f":"R61-R52","v":0},null,{"$f":"G60+P60+R60","v":63413.765182186238},{"$f":"T60/T53","v":0.34842728122080352},{"$f":"T60/T51","v":0.34524775171927352}]
[null,"Marge commerciale",null,null,null,null,{"$f":"G51*I61","v":47489.878542510123},null,{"$f":"F40","v":0.34},{"$f":"J53*K61","v":17600},{"$f":"F42","v":0.4},{"$f":"L53*M61","v":0},{"$f":"F43","v":0},{"$f":"N53*O61","v":0},0.52,{"$f":"P53-P59","v":17600},{"$f":"P61/P53","v":0.4},{"$f":"R53*S61","v":0},{"$f":"F45","v":0},{"$f":"G61+P61+R61","v":65089.878542510123},null,{"$f":"T61/T51","v":0.35437312643272795}]
[]
[null,"Stock Moyen",null,null,null,null,{"$f":"(G55+G57)/2","v":35626.224369857635},null,null,{"$f":"(J55+J57)/2","v":10544.565217391308},null,{"$f":"(L55+L57)/2","v":0},null,{"$f":"(N55+N57)/2","v":0},null,{"$f":"N63+L63+J63","v":10544.565217391308},null,{"$f":"(R55+R57)/2","v":0},null,{"$f":"G63+P63+R63","v":46170.789587248946}]
[null,"Rotation",null,null,null,null,{"$f":"G59/G63","v":2.5875948531837687},null,null,{"$f":"J59/J63","v":2.5036594165549935},null,{"$f":"L59/L63","v":{"$error":"#DIV/0!"}},null,{"$f":"N59/N63","v":{"$error":"#DIV/0!"}},null,{"$f":"P59/P63","v":2.5036594165549935},null,{"$f":"R59/R63","v":{"$error":"#DIV/0!"}},null,{"$f":"T59/T63","v":2.568425532201942}]
[null,"Rotation en jours",null,null,null,null,{"$f":"365/G64","v":141.05763100854259},null,null,{"$f":"365/J64","v":145.78660243741771},null,{"$f":"365/L64","v":{"$error":"#DIV/0!"}},null,{"$f":"365/N64","v":{"$error":"#DIV/0!"}},null,{"$f":"365/P64","v":145.78660243741771},null,{"$f":"365/R64","v":{"$error":"#DIV/0!"}},null,{"$f":"365/T64","v":142.11040788365045}]
[]
[]
[null,"Prévision Année 3","CA","Rabais","Stock final","Marge commerciale"]
[null,"Librairie",0.1,1.4E-2,0,0.35]
[null,"Facturation (montant)",0]
[null,"Papeterie",0.1,0,0,0.41]
[null,"Jeux",0,0,0,0]
[null,"Carterie",0,0,0,0]
[null,"Restauration/Café",0,0,0,0]
[]
[]
[null,"Année 3","Librairie",null,null,null,null,null,null,"Autres produits 20%",null,null,null,null,null,null,null,"Restauration / Café",null,"Total"]
[]
[null,null,"Comptant","% VB","Facturation","%","TOTAL","%","% sur VB","Papeterie","%","Jeux","%","Carterie","%","Total Autres produits","%","Total restauration","%",null,"%","% VB"]
[null,"Ventes brutes",{"$f":"G80-E80","v":155825.27859671021},1,{"$f":"E82+E81","v":0},1,{"$f":"G82+G81","v":155825.27859671021},null,1,{"$f":"J82+J81","v":48400},1,{"$f":"L81+L82","v":0},1,{"$f":"N81+N82","v":0},1,{"$f":"N80+L80+J80","v":48400},null,{"$f":"R81+R82","v":0},1,{"$f":"G80+P80+R80","v":204225.27859671021},null,1]
[null,"réduction",{"$f":"G81-E81","v":2181.5539003539434},{"$f":"C81/C80","v":1.4000000000000004E-2},{"$f":"E82*F81/F82","v":0},0.09,{"$f":"G82*I81/I82","v":2181.5539003539434},null,{"$f":"D69","v":1.4E-2},{"$f":"J82*K81/K82","v":0},{"$f":"D71","v":0},{"$f":"L82*M81/M82","v":0},{"$f":"D72","v":0},{"$f":"N82*O81/O82","v":0},{"$f":"D73","v":0},{"$f":"N81+L81+J81","v":0},{"$f":"P81/P82","v":0},{"$f":"R82*S81/S82","v":0},{"$f":"D74","v":0},{"$f":"G81+P81+R81","v":2181.5539003539434},null,{"$f":"T81/T80","v":1.0682095357362314E-2}]
[null,"CA",{"$f":"G82-E82","v":153643.72469635628},null,{"$f":"E53+(E53*C70)","v":0},{"$f":"F80-F81","v":0.91},{"$f":"G51+(G51*C69)","v":153643.72469635628},1,{"$f":"I80-I81","v":0.98599999999999999},{"$f":"J51+(J51*C71)","v":48400},{"$f":"K80-K81","v":1},{"$f":"L53+(L53*C72)","v":0},{"$f":"M80-M81","v":1},{"$f":"N53+(N53*C73)","v":0},{"$f":"O80-O81","v":1},{"$f":"N82+L82+J82","v":48400},null,{"$f":"R53+(R53*C74)","v":0},{"$f":"S80-S81","v":1},{"$f":"G82+P82+R82","v":202043.72469635628},1]
[null,null,"Notes libres: idem . Il faut noter que les remises facturations sont à 9%. LA SOFIA devra être inclus pour les 6% dans les autres charges"]
[null,"Stock Initial",null,null,null,null,{"$f":"G57","v":35626.224369857635},null,null,{"$f":"J57","v":10544.565217391308},null,{"$f":"L57","v":0},null,{"$f":"N57","v":0},null,{"$f":"N84+L84+J84","v":10544.565217391308},null,{"$f":"R57","v":0},null,{"$f":"G84+P84+R84","v":46170.789587248946}]
[null,"Achats",null,null,null,null,{"$f":"G88+G86-G84","v":101286.43108786165},null,null,{"$f":"J88+J86-J84","v":28556.000000000004},null,{"$f":"L88+L86-L84","v":0},null,{"$f":"N88+N86-N84","v":0},null,{"$f":"P88+P86-P84","v":28556.000000000004},null,{"$f":"R88+R86-R84","v":0},null,{"$f":"G85+P85+R85","v":129842.43108786165}]
[null,"Stock Final",null,null,null,null,{"$f":"G84+E69","v":35626.224369857635},null,null,{"$f":"J84+E71","v":10544.565217391308},null,{"$f":"L84+E72","v":0},null,{"$f":"N84+E73","v":0},null,{"$f":"N86+L86+J86","v":10544.565217391308},null,{"$f":"R84+E74","v":0},null,{"$f":"G86+P86+R86","v":46170.789587248946}]
[]
[null,"Coût des ventes",null,null,null,null,{"$f":"G80-(G80*I90)","v":101286.43108786164},null,null,{"$f":"J80-(J80*K90)","v":28556},null,{"$f":"L80-(L80*M90)","v":0},null,{"$f":"N80-(N80*O90)","v":0},null,{"$f":"N88+L88+J88","v":28556},null,{"$f":"R80-(R80*S90)","v":0},null,{"$f":"G88+P88+R88","v":129842.43108786164}]
[null,"Marge brute",null,null,null,null,{"$f":"G80*I89","v":52357.293608494627},{"$f":"G89/G82","v":0.34077079107505065},{"$f":"I90-I81","v":0.33599999999999997},{"$f":"J90-J81","v":19844},null,{"$f":"L90-L81","v":0},null,{"$f":"N90-N81","v":0},null,{"$f":"P90-P81","v":19844},{"$f":"P89/P82","v":0.41},{"$f":"R90-R81","v":0},null,{"$f":"G89+P89+R89","v":72201.293608494627},{"$f":"T89/T82","v":0.35735479395365122},{"$f":"T89/T80","v":0.35353749596822776}]
[null,"Marge commerciale",null,null,null,null,{"$f":"G80*I90","v":54538.847508848572},null,{"$f":"F69","v":0.35},{"$f":"J80*K90","v":19844},{"$f":"F71","v":0.41},{"$f":"L80*M90","v":0},{"$f":"F72","v":0},{"$f":"N80*O90","v":0},{"$f":"F73","v":0},{"$f":"P82-P88","v":19844},{"$f":"P90/P82","v":0.41},{"$f":"R80*S90","v":0},{"$f":"F74","v":0},{"$f":"G90+P90+R90","v":74382.847508848572},null,{"$f":"T90/T80","v":0.36421959132559006}]
[]
[null,"Stock Moyen",null,null,null,null,{"$f":"(G84+G86)/2","v":35626.224369857635},null,null,{"$f":"(J84+J86)/2","v":10544.565217391308},null,{"$f":"(L84+L86)/2","v":0},null,{"$f":"(N84+N86)/2","v":0},null,{"$f":"N92+L92+J92","v":10544.565217391308},null,{"$f":"(R84+R86)/2","v":0},null,{"$f":"G92+P92+R92","v":46170.789587248946}]
[null,"Rotation",null,null,null,null,{"$f":"G88/G92","v":2.8430301801376765},null,null,{"$f":"J88/J92","v":2.7081249355736512},null,{"$f":"L88/L92","v":{"$error":"#DIV/0!"}},null,{"$f":"N88/N92","v":{"$error":"#DIV/0!"}},null,{"$f":"365/P92","v":3.4614988145551993E-2},null,{"$f":"R88/R92","v":{"$error":"#DIV/0!"}},null,{"$f":"T88/T92","v":2.8122202857826024}]
[null,"Rotation en jours",null,null,null,null,{"$f":"365/G93","v":128.38414539177509},null,null,{"$f":"365/J93","v":134.77960163705797},null,{"$f":"365/L93","v":{"$error":"#DIV/0!"}},null,{"$f":"365/N93","v":{"$error":"#DIV/0!"}},null,{"$f":"365/P93","v":10544.565217391308},null,{"$f":"365/R93","v":{"$error":"#DIV/0!"}},null,{"$f":"365/T93","v":129.79068597338758}]
[]
[]
[null,"Saisonnalité de la librairie ou saisonnalité prévisionnelle"]
[]
[null,null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Ventes librairie",7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.06,0.05,0.08,7.0000000000000007E-2,0.05,0.14000000000000001,0.09,0.11,0.16,{"$f":"SUM(C100:N100)","v":1}]
[null,"Achats librairie",7.0000000000000007E-2,7.0000000000000007E-2,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0.08,0.05,0.04,0.09,0.12,0.15,0.13,{"$f":"SUM(C101:N101)","v":1}]
[null,"Ventes facturation",0.1,0.1,0.1,0.1,0.1,0.1,0,0,0.1,0.1,0.1,0.1,{"$f":"SUM(C102:N102)","v":0.99999999999999989}]
[null,"Ventes autres à 20%",7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.06,0.05,0.08,7.0000000000000007E-2,0.05,0.14000000000000001,0.09,0.11,0.16,{"$f":"SUM(C103:N103)","v":1}]
[null,"Achats autres à 20%",0,0,0.3,0,0,0.4,0,0,0.3,0,0,0,{"$f":"SUM(C104:N104)","v":1}]
[null,"Ventes restaurant café",{"$f":"(100/12)%","v":8.3333333333333343E-2},8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,{"$f":"SUM(C105:N105)","v":1.0000000000000002}]
[null,"Achats restaurant café",8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,8.3333333333333343E-2,1.0000000000000002]
[]
[]
[]
[null,"Mois de démarrage ou de reprise"]
[null,"Mois",9]
[]
[]
[]
[null,"Simulation trésorerie"]
[null,null,{"$f":"AB147","v":"Septembre"},{"$f":"AB148","v":"Octobre"},{"$f":"AB149","v":"Novembre"},{"$f":"AB150","v":"Décembre"},{"$f":"AB151","v":"Janvier"},{"$f":"AB152","v":"Février"},{"$f":"AB153","v":"Mars"},{"$f":"AB154","v":"Avril"},{"$f":"AB155","v":"Mai"},{"$f":"AB156","v":"Juin"},{"$f":"AB157","v":"Juillet"},{"$f":"AB158","v":"Août"},"Total"]
[null,"Ventes librairie",{"$f":"LOOKUP(AW149,Vente_librairie)","v":0.14000000000000001},0.09,0.11,0.16,7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.06,0.05,0.08,7.0000000000000007E-2,0.05,{"$f":"SUM(C117:N117)","v":1.0000000000000002}]
[null,"Achats librairie",{"$f":"LOOKUP(AW149,Achat_Librairie)","v":0.09},0.12,0.15,0.13,7.0000000000000007E-2,7.0000000000000007E-2,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0.08,0.05,0.04,{"$f":"SUM(C118:N118)","v":1.0000000000000002}]
[null,"Ventes facturation",{"$f":"LOOKUP(AW149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(AX149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(AY149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(AZ149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BA149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BB149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BC149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BD149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BE149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BF149,AM146:AN158)","v":0.1},{"$f":"LOOKUP(BG149,AM146:AN158)","v":0},{"$f":"LOOKUP(BH149,AM146:AN158)","v":0},{"$f":"SUM(C119:N119)","v":0.99999999999999989}]
[null,"Ventes autres 19.6%",{"$f":"LOOKUP(AW149,AP146:AQ158)","v":0.14000000000000001},{"$f":"LOOKUP(AX149,AP146:AQ158)","v":0.09},{"$f":"LOOKUP(AY149,AP146:AQ158)","v":0.11},{"$f":"LOOKUP(AZ149,AP146:AQ158)","v":0.16},{"$f":"LOOKUP(BA149,AP146:AQ158)","v":7.0000000000000007E-2},{"$f":"LOOKUP(BB149,AP146:AQ158)","v":7.0000000000000007E-2},{"$f":"LOOKUP(BC149,AP146:AQ158)","v":0.05},{"$f":"LOOKUP(BD149,AP146:AQ158)","v":0.06},{"$f":"LOOKUP(BE149,AP146:AQ158)","v":0.05},{"$f":"LOOKUP(BF149,AP146:AQ158)","v":0.08},{"$f":"LOOKUP(BG149,AP146:AQ158)","v":7.0000000000000007E-2},{"$f":"LOOKUP(BH149,AP146:AQ158)","v":0.05},{"$f":"SUM(C120:N120)","v":1.0000000000000002}]
[null,"Achats autres 19.6%",{"$f":"LOOKUP(AW149,Achats_Papeterie)","v":0.3},0,0,0,0,0,0.3,0,0,0.4,0,0,{"$f":"SUM(C121:N121)","v":1}]
[null,"Ventes restaurant café",{"$f":"LOOKUP(AW149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(AX149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(AY149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(AZ149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BA149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BB149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BC149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BD149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BE149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BF149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BG149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BH149,AG160:AH172)","v":8.3333333333333343E-2},{"$f":"SUM(C122:N122)","v":1.0000000000000002}]
[null,"Achats restaurant café",{"$f":"LOOKUP(AW149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(AX149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(AY149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(AZ149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BA149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BB149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BC149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BD149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BE149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BF149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BG149,AJ160:AK172)","v":8.3333333333333343E-2},{"$f":"LOOKUP(BH149,AJ160:AK172)","v":8.3333333333333343E-2},1.0000000000000002]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOIS",null,null,"SAISON",null,null,"Ventes librairie",null,null,"Achats Librairie",null,null,"Ventes facturations",null,null,"Ventes autres",null,null,"Achats Papeterie",null,null,null,1,{"$f":"AW146+1","v":2},3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C111","v":9},{"$f":"LOOKUP(AA147,SAISON)","v":"Septembre"},null,1,"Janvier",null,1,{"$f":"C100","v":7.0000000000000007E-2},null,1,{"$f":"C101","v":7.0000000000000007E-2},null,1,{"$f":"C102","v":0.1},null,1,{"$f":"C103","v":7.0000000000000007E-2},null,1,{"$f":"C104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA147<=11,AA147+1,1)","v":10},{"$f":"LOOKUP(AA148,SAISON)","v":"Octobre"},null,2,"Février",null,{"$f":"AG147+1","v":2},{"$f":"D100","v":7.0000000000000007E-2},null,{"$f":"AJ147+1","v":2},{"$f":"D101","v":7.0000000000000007E-2},null,{"$f":"AM147+1","v":2},{"$f":"D102","v":0.1},null,{"$f":"AP147+1","v":2},{"$f":"D103","v":7.0000000000000007E-2},null,{"$f":"AS147+1","v":2},{"$f":"D104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Novembre",null,3,"Mars",null,{"$f":"AG148+1","v":3},{"$f":"E100","v":0.05},null,3,{"$f":"E101","v":0.06},null,{"$f":"AM148+1","v":3},{"$f":"E102","v":0.1},null,3,{"$f":"E103","v":0.05},null,3,{"$f":"E104","v":0.3},null,null,{"$f":"AA147","v":9},{"$f":"AA148","v":10},{"$f":"AA149","v":11},{"$f":"AA150","v":12},{"$f":"AA151","v":1},{"$f":"AA152","v":2},{"$f":"AA153","v":3},{"$f":"AA154","v":4},{"$f":"AA155","v":5},{"$f":"AA156","v":6},{"$f":"AA157","v":7},{"$f":"AA158","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Décembre",null,4,"Avril",null,4,{"$f":"F100","v":0.06},null,4,{"$f":"F101","v":7.0000000000000007E-2},null,4,{"$f":"F102","v":0.1},null,4,{"$f":"F103","v":0.06},null,4,{"$f":"F104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Janvier",null,5,"Mai",null,5,{"$f":"G100","v":0.05},null,5,{"$f":"G101","v":7.0000000000000007E-2},null,5,{"$f":"G102","v":0.1},null,5,{"$f":"G103","v":0.05},null,5,{"$f":"G104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Février",null,6,"Juin",null,6,{"$f":"H100","v":0.08},null,6,{"$f":"H101","v":0.08},null,6,{"$f":"H102","v":0.1},null,6,{"$f":"H103","v":0.08},null,6,{"$f":"H104","v":0.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Mars",null,7,"Juillet",null,7,{"$f":"I100","v":7.0000000000000007E-2},null,7,{"$f":"I101","v":0.05},null,7,{"$f":"I102","v":0},null,7,{"$f":"I103","v":7.0000000000000007E-2},null,7,{"$f":"I104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Avril",null,8,"Août",null,8,{"$f":"J100","v":0.05},null,8,{"$f":"J101","v":0.04},null,8,{"$f":"J102","v":0},null,8,{"$f":"J103","v":0.05},null,8,{"$f":"J104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Mai",null,9,"Septembre",null,9,{"$f":"K100","v":0.14000000000000001},null,9,{"$f":"K101","v":0.09},null,9,{"$f":"K102","v":0.1},null,9,{"$f":"K103","v":0.14000000000000001},null,9,{"$f":"K104","v":0.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Juin",null,10,"Octobre",null,10,{"$f":"L100","v":0.09},null,10,{"$f":"L101","v":0.12},null,10,{"$f":"L102","v":0.1},null,10,{"$f":"L103","v":0.09},null,10,{"$f":"L104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Juillet",null,11,"Novembre",null,11,{"$f":"M100","v":0.11},null,11,{"$f":"M101","v":0.15},null,11,{"$f":"M102","v":0.1},null,11,{"$f":"M103","v":0.11},null,11,{"$f":"M104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Août",null,12,"Décembre",null,12,{"$f":"N100","v":0.16},null,12,{"$f":"N101","v":0.13},null,12,{"$f":"N102","v":0.1},null,12,{"$f":"N103","v":0.16},null,12,{"$f":"N104","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventes restaurant café",null,null,"Achats restaurant café"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"C105","v":8.3333333333333343E-2},null,1,{"$f":"C106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG161+1","v":2},{"$f":"D105","v":8.3333333333333343E-2},null,{"$f":"AJ161+1","v":2},{"$f":"D106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"E105","v":8.3333333333333343E-2},null,3,{"$f":"E106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"F105","v":8.3333333333333343E-2},null,4,{"$f":"F106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"G105","v":8.3333333333333343E-2},null,5,{"$f":"G106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"H105","v":8.3333333333333343E-2},null,6,{"$f":"H106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"I105","v":8.3333333333333343E-2},null,7,{"$f":"I106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"J105","v":8.3333333333333343E-2},null,8,{"$f":"J106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"K105","v":8.3333333333333343E-2},null,9,{"$f":"K106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"L105","v":8.3333333333333343E-2},null,10,{"$f":"L106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"M105","v":8.3333333333333343E-2},null,11,{"$f":"M106","v":8.3333333333333343E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"N105","v":8.3333333333333343E-2},null,12,{"$f":"N106","v":8.3333333333333343E-2}]

{"sheet":"Bilan ouverture","index":1,"n_rows":225,"n_cols":29,"rows_kept":225,"cut":false,"hidden":false,"merged":[[20,6,20,11],[11,6,11,7],[1,1,1,4],[2,1,2,2],[2,3,2,4],[1,6,1,7],[6,6,6,7]]}
[]
[null,"Bilan d'ouverture",null,null,null,null,"Emprunts banque"]
[null,"Actif",null,"Passif",null,null,"Montant",{"$f":"E8","v":20000}]
[null,"Fonds de commerce",10000,"Capital",3000,null,"Taux",1.7000000000000001E-2]
[null,"Mise en route SARL",1500,"Apport Adelc en capital",0,null,"Durée",7]
[null,"Travaux et mise aux normes",1250,"Comptes courants associés",2000]
[null,"Construction",0,"Comptes courants ADELC",5000,null,"Emprunt Adelc"]
[null,"Aménagement",2000,"Emprunts bancaires",20000,null,"Montant",{"$f":"Q88","v":5000}]
[null,"Mobilier",0,"Emprunts taux 0 % (CNL ou PFIL)",10000,null,"Taux",0]
[null,"informatique",6765,"Subvention d'investissements ",10000,null,"Durée",5]
[null,"Caution financière/bancaire",null,"Total emprunts et apports",{"$f":"SUM(E4:E10)","v":50000}]
[null,"Caution bail",1440,null,null,null,"Emprunt à taux 0 %"]
[null,"Stock Librairie",{"$f":"'Outil de simulation'!G4","v":30000},"Stock lib TC",{"$f":"C13*1.055","v":31649.999999999996},null,"Montant",{"$f":"X88","v":10000}]
[null,"Stock autres produits",{"$f":"'Outil de simulation'!G5+'Outil de simulation'!G6+'Outil de simulation'!G7","v":10325},"Fds de commerce",{"$f":"C4","v":10000},null,"Taux",0]
[null,"Stock restauration café",{"$f":"'Outil de simulation'!G8","v":0},null,null,null,"Durée",5]
[null,"TVA",{"$f":"(C10+C9+C6+C8+C14+C7)*20%+C13*5.5%+C15*10%","v":5718}]
[null,"Total investissements",{"$f":"SUM(C4:C16)","v":68998}]
[null,"Fonds de roulement",{"$f":"E18-C17","v":22652},null,{"$f":"SUM(E4:E10)+SUM(E13:E17)","v":91650},null,"Subvention d'exploitation (CNL, Plan état/Région, Drac)",20000]
[]
[]
[null,null,null,null,null,null,"Décomposition subvention d'investissements"]
[null,null,null,null,null,null,null,"Montant","Durée","Année 1","Année 2","Année 3"]
[null,null,null,null,null,null,"Subvention Investissements",{"$f":"E10","v":10000},5]
[null,null,null,null,null,null,"Reste en passif long terme",null,null,{"$f":"$H$23-J25","v":8000},{"$f":"J24-K25","v":6000},{"$f":"K24-L25","v":4000}]
[null,null,null,null,null,null,"Produits exceptionnels",null,null,{"$f":"$H$23/$I$23","v":2000},{"$f":"$H$23/$I$23","v":2000},{"$f":"$H$23/$I$23","v":2000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"24000*0.6","v":14400}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Intérêts et remboursements du Kl","Intérêts","Capital","Total","K restant",null,"Emprunts ","montant","Intérêts","Durée",null,null,null,null,"Emprunt ADELC","Montant","Intérêts","Durée",null,null,null,"Emprunt  taux 0","Montant","Intérêts","Durée"]
[null,"Année 1",{"$f":"I90","v":318.9212817455151},{"$f":"J90+Y90+R90","v":4713.6133942573288},{"$f":"SUM(C88:D88)","v":5032.5346760028442},{"$f":"L90+Z90+S90","v":30286.386605742671},null,{"$f":"H4","v":1.7000000000000001E-2},{"$f":"H3","v":20000},null,{"$f":"H5","v":7},null,null,null,null,null,{"$f":"E7","v":5000},0,{"$f":"H10","v":5},null,null,null,"CNL ou PFIL",{"$f":"E9","v":10000},0,{"$f":"H15","v":5},null,null,{"$f":"E18-E13-E14","v":50000}]
[null,"Année 2",272.42871055411439,4760.105965448729,5032.5346760028433,25526.280640293942,null,null,"Intérêts","K","Total","K restant",null,null,null,null,"Intérêts","K à rembourser","K restant",null,null,null,null,"Intérêts","K à rembourser","K restant"]
[null,"Année 3",225.13957815006563,5807.3950978527782,6032.5346760028442,19718.885542441163,null,"Année 1",{"$f":"IF(N90=0,0,H118)","v":318.9212817455151},{"$f":"IF(N90=0,0,I118)","v":2713.6133942573292},{"$f":"SUM(I90:J90)","v":3032.5346760028442},{"$f":"C106-J90","v":17286.386605742671},1,{"$f":"IF(M90>$K$88,0,M90)","v":1},null,"Année 1",null,null,{"$f":"Q88","v":5000},null,null,null,"Année 1",0,{"$f":"IF(AB90=0,0,$X$88/$Z$88)","v":2000},{"$f":"X88-Y90","v":8000},1,{"$f":"IF(AA90>$Z$88,0,AA90)","v":1}]
[null,"Année 4",177.04023698174439,5855.4944390210994,6032.5346760028442,13863.391103420065,null,"Année 2",{"$f":"IF(N91=0,0,H130)","v":272.42871055411439},{"$f":"IF(N91=0,0,I130)","v":2760.1059654487294},{"$f":"SUM(I91:J91)","v":3032.5346760028438},{"$f":"L90-J91","v":14526.280640293942},2,2,null,"Année 2",null,null,{"$f":"S90","v":5000},null,null,null,"Année 2",null,2000,{"$f":"Z90-Y90","v":6000},2,2]
[null,"Année 5",128.11680567285259,5904.4178703299913,6032.5346760028442,7958.9732330900733,null,"Année 3",{"$f":"IF(N92=0,0,H141)","v":225.13957815006563},{"$f":"IF(N92=0,0,I141)","v":2807.3950978527782},3032.5346760028438,11718.885542441163,3,3,null,"Année 3",null,{"$f":"IF(U92=0,0,$Q$88/$S$88)","v":1000},{"$f":"S91-R92","v":4000},1,{"$f":"IF(T92>$S$88,0,T92)","v":1},null,"Année 3",null,2000,{"$f":"Z91-Y92","v":4000},3,3]
[null,"Année 6",78.355165016280665,3954.1795109865634,4032.5346760028442,4004.7937221035099,null,"Année 4",{"$f":"IF(N93=0,0,H153)","v":177.04023698174439},{"$f":"IF(N93=0,0,I153)","v":2855.4944390210994},3032.5346760028438,8863.3911034200646,4,4,null,"Année 4",null,1000,3000,2,2,null,"Année 4",null,2000,2000,4,4]
[null,"Année 7",27.740953899331995,4004.7937221035118,4032.5346760028438,0,null,"Année 5",{"$f":"IF(N94=0,0,H165)","v":128.11680567285259},{"$f":"IF(N94=0,0,I165)","v":2904.4178703299908},3032.5346760028433,5958.9732330900733,5,5,null,"Année 5",null,1000,2000,3,3,null,"Année 5",null,2000,0,5,5]
[null,"Année 8",0,0,0,0,null,"Année 6",{"$f":"IF(N95=0,0,H177)","v":78.355165016280665},{"$f":"IF(N95=0,0,I177)","v":2954.1795109865634},3032.5346760028442,3004.7937221035099,6,6,null,"Année 6",null,1000,1000,4,4,null,"Année 6",null,0,0,6,0]
[null,"Année 9",0,0,0,0,null,"Année 7",{"$f":"IF(N96=0,0,H189)","v":27.740953899331995},{"$f":"IF(N96=0,0,I189)","v":3004.7937221035118},3032.5346760028438,0,7,7,null,"Année 7",null,1000,0,5,5,null,"Année 7",null,0,0,7,0]
[null,"Année 10",0,{"$f":"J99","v":0},{"$f":"SUM(C97:D97)","v":0},{"$f":"L99","v":0},null,"Année 8",{"$f":"IF(N97=0,0,H201)","v":0},{"$f":"IF(N97=0,0,I201)","v":0},0,0,8,0,null,"Année 8",null,0,0,6,0,null,"Année 8",null,0,0,8,0]
[null,null,null,null,null,null,null,"Année 9",{"$f":"IF(N98=0,0,H213)","v":0},{"$f":"IF(N98=0,0,I213)","v":0},0,0,9,0,null,"Année 9",null,0,0,7,0,null,"Année 9",null,0,0,9,0]
[null,null,null,null,null,null,null,"Année 10",{"$f":"IF(N99=0,0,H225)","v":0},{"$f":"IF(N99=0,0,I225)","v":0},0,0,10,0]
[]
[]
[]
[null,"Emprunt 5 sur 7 ans",null,"Taux","Taux mensuel"]
[null,"Années",7,1.7000000000000001E-2,{"$f":"D104/12","v":1.4166666666666668E-3},"Mensuel",{"$f":"I104","v":-252.71122300023697},null,{"$f":"PMT(D104/12,C104*12,C106)","v":-252.71122300023697}]
[null,null,null,null,"Intérêts","K","K restant"]
[null,"Départ 1",{"$f":"H3","v":20000},{"$f":"G104*-1","v":252.71122300023697},{"$f":"C106*$E$104","v":28.333333333333336},{"$f":"D106-E106","v":224.37788966690363},{"$f":"C106-F106","v":19775.622110333097}]
[null,2,{"$f":"G106","v":19775.622110333097},{"$f":"D106","v":252.71122300023697},28.015464656305223,224.69575834393174,19550.926351989165]
[null,3,19550.926351989165,252.71122300023697,27.697145665317986,225.01407733491899,19325.912274654245]
[null,4,19325.912274654245,252.71122300023697,27.378375722426849,225.33284727781012,19100.579427376437]
[null,5,19100.579427376437,252.71122300023697,27.059154188783289,225.65206881145369,18874.927358564983]
[null,6,18874.927358564983,252.71122300023697,26.739480424633726,225.97174257560323,18648.95561598938,null,"N-2"]
[null,7,18648.95561598938,252.71122300023697,26.41935378931829,226.29186921091869,18422.66374677846]
[null,8,18422.66374677846,252.71122300023697,26.098773641269489,226.61244935896747,18196.051297419493]
[null,9,18196.051297419493,252.71122300023697,25.777739338010949,226.93348366222602,17969.117813757268]
[null,10,17969.117813757268,252.71122300023697,25.45625023615613,227.25497276408083,17741.862840993188]
[null,11,17741.862840993188,252.71122300023697,25.134305691407018,227.57691730882996,17514.285923684358]
[null,12,17514.285923684358,252.71122300023697,24.811905058552842,227.89931794168413,17286.386605742675,"Intérêts annuels","K remboursé",{"$f":"I118+H118","v":3032.5346760028442}]
[null,{"$f":"B117+1","v":13},17286.386605742675,252.71122300023697,24.489047691468791,228.22217530876819,17058.164430433906,{"$f":"SUM(E106:E117)","v":318.9212817455151},{"$f":"SUM(F106:F117)","v":2713.6133942573292}]
[null,14,17058.164430433906,252.71122300023697,24.165732943114701,228.54549005712227,16829.618940376782]
[null,15,16829.618940376782,252.71122300023697,23.841960165533777,228.86926283470319,16600.74967754208]
[null,16,16600.74967754208,252.71122300023697,23.517728709851283,229.19349429038567,16371.556183251694]
[null,17,16371.556183251694,252.71122300023697,23.193037926273234,229.51818507396374,16142.03799817773]
[null,18,16142.03799817773,252.71122300023697,22.867887164085118,229.84333583615185,15912.194662341577]
[null,19,15912.194662341577,252.71122300023697,22.542275771650569,230.1689472285864,15682.02571511299,null,"N-1"]
[null,20,15682.02571511299,252.71122300023697,22.216203096410069,230.49501990382691,15451.530695209163]
[null,21,15451.530695209163,252.71122300023697,21.88966848487965,230.82155451535732,15220.709140693805]
[null,22,15220.709140693805,252.71122300023697,21.562671282649561,231.1485517175874,14989.560588976217]
[null,23,14989.560588976217,252.71122300023697,21.235210834382976,231.476012165854,14758.084576810363]
[null,24,14758.084576810363,252.71122300023697,20.907286483814683,231.80393651642228,14526.28064029394,null,null,{"$f":"I130+H130","v":3032.5346760028438}]
[null,25,14526.28064029394,252.71122300023697,20.578897573749749,232.13232542648723,14294.148314867452,{"$f":"SUM(E118:E129)","v":272.42871055411439},{"$f":"SUM(F118:F129)","v":2760.1059654487294}]
[null,26,14294.148314867452,252.71122300023697,20.250043446062225,232.46117955417475,14061.687135313277,"en frais bancaires"]
[null,27,14061.687135313277,252.71122300023697,19.920723441693813,232.79049955854316,13828.896635754734,null,"en trésorerie"]
[null,28,13828.896635754734,252.71122300023697,19.59093690065254,233.12028609958443,13595.776349655151]
[null,29,13595.776349655151,252.71122300023697,19.260683162011464,233.4505398382255,13362.325809816924]
[null,30,13362.325809816924,252.71122300023697,18.929961563907312,233.78126143632966,13128.544548380594]
[null,31,13128.544548380594,252.71122300023697,18.598771443539178,234.11245155669781,12894.432096823897]
[null,32,12894.432096823897,252.71122300023697,18.267112137167189,234.4441108630698,12659.987985960828]
[null,33,12659.987985960828,252.71122300023697,{"$f":"C138*$E$104","v":17.934982980111176},{"$f":"D138-E138","v":234.77624002012578},{"$f":"C138-F138","v":12425.211745940702}]
[null,34,{"$f":"G138","v":12425.211745940702},{"$f":"D138","v":252.71122300023697},17.602383306749328,235.10883969348765,12190.102906247213]
[null,35,12190.102906247213,252.71122300023697,17.269312450516885,235.44191054972009,11954.660995697493]
[null,36,11954.660995697493,252.71122300023697,16.935769743904785,235.77545325633218,11718.885542441161,{"$f":"SUM(E130:E141)","v":225.13957815006563},{"$f":"SUM(F130:F141)","v":2807.3950978527782},{"$f":"I141+H141","v":3032.5346760028438}]
[null,37,11718.885542441161,252.71122300023697,16.601754518458314,236.10946848177866,11482.776073959383]
[null,38,11482.776073959383,252.71122300023697,16.267266104775793,236.44395689546118,11246.332117063923]
[null,39,11246.332117063923,252.71122300023697,15.932303832507225,236.77891916772975,11009.553197896194]
[null,40,11009.553197896194,252.71122300023697,15.596867030352941,237.11435596988403,10772.438841926309]
[null,41,10772.438841926309,252.71122300023697,15.260955026062272,237.45026797417469,10534.988573952134]
[null,42,10534.988573952134,252.71122300023697,14.924567146432191,237.78665585380477,10297.20191809833]
[null,43,10297.20191809833,252.71122300023697,14.587702717305968,238.123520282931,10059.0783978154]
[null,44,10059.0783978154,252.71122300023697,14.250361063571818,238.46086193666514,9820.617535878735]
[null,{"$f":"B149+1","v":45},9820.617535878735,252.71122300023697,13.912541509161542,238.79868149107543,9581.8188543876604]
[null,46,9581.8188543876604,252.71122300023697,13.574243377049186,239.13697962318778,9342.681874764472]
[null,47,9342.681874764472,252.71122300023697,13.23546598924967,239.47575701098731,9103.2061177534852]
[null,48,9103.2061177534852,252.71122300023697,12.896208666817438,239.81501433341953,8863.3911034200664,{"$f":"SUM(E142:E153)","v":177.04023698174439},{"$f":"SUM(F142:F153)","v":2855.4944390210994},{"$f":"I153+H153","v":3032.5346760028438}]
[null,49,8863.3911034200664,252.71122300023697,12.556470729845095,240.15475227039187,8623.2363511496751]
[null,50,8623.2363511496751,252.71122300023697,12.216251497462041,240.49497150277492,8382.7413796469009]
[null,51,8382.7413796469009,252.71122300023697,11.875550287833111,240.83567271240386,8141.9057069344972]
[null,52,8141.9057069344972,252.71122300023697,11.534366418157205,241.17685658207978,7900.7288503524178]
[null,53,7900.7288503524178,252.71122300023697,11.192699204665926,241.51852379557104,7659.2103265568467]
[null,54,7659.2103265568467,252.71122300023697,10.850547962622199,241.86067503761478,7417.3496515192319]
[null,55,7417.3496515192319,252.71122300023697,10.507912006318913,242.20331099391805,7175.1463405253135]
[null,56,7175.1463405253135,252.71122300023697,10.164790649077528,242.54643235115944,6932.5999081741538]
[null,57,6932.5999081741538,252.71122300023697,9.8211832032467186,242.89003979699027,6689.7098683771637]
[null,58,6689.7098683771637,252.71122300023697,9.4770889802009819,243.23413402003598,6446.4757343571273]
[null,59,6446.4757343571273,252.71122300023697,9.1325072903392641,243.57871570989769,6202.8970186472297]
[null,60,6202.8970186472297,252.71122300023697,8.7874374430835758,243.92378555715339,5958.9732330900761,{"$f":"SUM(E154:E165)","v":128.11680567285259},{"$f":"SUM(F154:F165)","v":2904.4178703299908},{"$f":"I165+H165","v":3032.5346760028433}]
[null,61,5958.9732330900761,252.71122300023697,8.4418787468776078,244.26934425335935,5714.7038888367169]
[null,62,5714.7038888367169,252.71122300023697,8.0958305091853493,244.61539249105161,5470.0884963456656]
[null,63,5470.0884963456656,252.71122300023697,7.7492920364896936,244.96193096374728,5225.1265653819182]
[null,64,5225.1265653819182,252.71122300023697,7.4022626342910511,245.30896036594592,4979.8176050159727]
[null,65,4979.8176050159727,252.71122300023697,{"$f":"C170*$E$104","v":7.0547416071059619},{"$f":"D170-E170","v":245.656481393131},{"$f":"C170-F170","v":4734.1611236228418}]
[null,66,{"$f":"G170","v":4734.1611236228418},{"$f":"D170","v":252.71122300023697},6.7067282584656933,246.00449474177128,4488.1566288810709]
[null,67,4488.1566288810709,252.71122300023697,6.3582218909148507,246.35300110932212,4241.8036277717492]
[null,68,4241.8036277717492,252.71122300023697,6.0092218060099789,246.70200119422699,3995.1016265775224]
[null,69,3995.1016265775224,252.71122300023697,5.6597273043181575,247.05149569591882,3748.0501308816038]
[null,70,3748.0501308816038,252.71122300023697,5.3097376854156053,247.40148531482137,3500.6486455667823]
[null,71,3500.6486455667823,252.71122300023697,4.9592522478862753,247.7519707523507,3252.8966748144317]
[null,72,3252.8966748144317,252.71122300023697,4.608270289320445,248.10295271091653,3004.7937221035149,{"$f":"SUM(E166:E177)","v":78.355165016280665},{"$f":"SUM(F166:F177)","v":2954.1795109865634},{"$f":"I177+H177","v":3032.5346760028442}]
[null,73,3004.7937221035149,252.71122300023697,4.2567911063133135,248.45443189392367,2756.3392902095911]
[null,74,2756.3392902095911,252.71122300023697,3.9048139944635878,248.80640900577339,2507.5328812038179]
[null,75,2507.5328812038179,252.71122300023697,3.5523382483720756,249.15888475186489,2258.3739964519527]
[null,76,2258.3739964519527,252.71122300023697,3.1993631616402665,249.51185983859671,2008.8621366133561]
[null,{"$f":"B181+1","v":77},2008.8621366133561,252.71122300023697,2.8458880268689213,249.86533497336805,1758.996801639988]
[null,78,1758.996801639988,252.71122300023697,2.49191213565665,250.21931086458031,1508.7774907754076]
[null,79,1508.7774907754076,252.71122300023697,2.1374347785984944,250.57378822163847,1258.2037025537691]
[null,80,1258.2037025537691,252.71122300023697,1.7824552452845064,250.92876775495247,1007.2749347988166]
[null,81,1007.2749347988166,252.71122300023697,1.4269728242983237,251.28425017593864,755.99068462287801]
[null,82,755.99068462287801,252.71122300023697,1.0709868032157439,251.64023619702124,504.35044842585677]
[null,83,504.35044842585677,252.71122300023697,0.71449646860329719,251.99672653163367,252.3537218942231]
[null,84,252.3537218942231,252.71122300023697,0.35750110601681606,252.35372189422014,2.9558577807620168E-12,{"$f":"SUM(E178:E189)","v":27.740953899331995},{"$f":"SUM(F178:F189)","v":3004.7937221035118},{"$f":"I189+H189","v":3032.5346760028438}]
[null,85,2.9558577807620168E-12,252.71122300023697,4.1874651894128574E-15,252.71122300023697,-252.71122300023401]
[null,86,-252.71122300023401,252.71122300023697,-0.35800756591699823,253.06923056615398,-505.78045356638802]
[null,87,-505.78045356638802,252.71122300023697,-0.71652230921904969,253.42774530945601,-759.208198875844]
[null,88,-759.208198875844,252.71122300023697,-1.0755449484074457,253.78676794864441,-1012.9949668244884]
[null,89,-1012.9949668244884,252.71122300023697,-1.4350762030013586,254.14629920323833,-1267.1412660277267]
[null,90,-1267.1412660277267,252.71122300023697,-1.7951167935392796,254.50633979377625,-1521.647605821503]
[null,91,-1521.647605821503,252.71122300023697,-2.1556674415804626,254.86689044181745,-1776.5144962633206]
[null,92,-1776.5144962633206,252.71122300023697,-2.516728869706371,255.22795186994335,-2031.7424481332639]
[null,93,-2031.7424481332639,252.71122300023697,-2.8783018015221242,255.5895248017591,-2287.3319729350228]
[null,94,-2287.3319729350228,252.71122300023697,-3.2403869616579493,255.95160996189492,-2543.2835828969178]
[null,95,-2543.2835828969178,252.71122300023697,-3.6029850757706336,256.31420807600762,-2799.5977909729254]
[null,96,-2799.5977909729254,252.71122300023697,-3.9660968705449777,256.67731987078196,-3056.2751108437074,{"$f":"SUM(E190:E201)","v":-23.740434840866644},{"$f":"SUM(F190:F201)","v":3056.2751108437105}]
[null,97,-3056.2751108437074,252.71122300023697,{"$f":"C202*$E$104","v":-4.3297230736952521},{"$f":"D202-E202","v":257.04094607393222},{"$f":"C202-F202","v":-3313.3160569176398}]
[null,98,{"$f":"G202","v":-3313.3160569176398},{"$f":"D202","v":252.71122300023697},-4.693864413966657,257.40508741420365,-3570.7211443318433]
[null,99,-3570.7211443318433,252.71122300023697,-5.0585216211367783,257.76974462137377,-3828.4908889532171]
[null,100,-3828.4908889532171,252.71122300023697,-5.4236954260170576,258.13491842625405,-4086.6258073794711]
[null,101,-4086.6258073794711,252.71122300023697,-5.7893865604542514,258.5006095606912,-4345.126416940162]
[null,102,-4345.126416940162,252.71122300023697,-6.1555957573318967,258.86681875756886,-4603.9932356977306]
[null,103,-4603.9932356977306,252.71122300023697,-6.5223237505717853,259.23354675080873,-4863.2267824485389]
[null,104,-4863.2267824485389,252.71122300023697,-6.889571275135431,259.60079427537238,-5122.8275767239111]
[null,105,-5122.8275767239111,252.71122300023697,-7.2573390670255415,259.9685620672625,-5382.7961387911737]
[null,106,-5382.7961387911737,252.71122300023697,-7.6256278632874963,260.33685086352449,-5643.1329896546986]
[null,107,-5643.1329896546986,252.71122300023697,-7.9944384020108235,260.70566140224781,-5903.8386510569462]
[null,108,-5903.8386510569462,252.71122300023697,-8.3637714223306752,261.07499442256767,-6164.9136454795134,{"$f":"SUM(E202:E213)","v":-76.10385863296365},{"$f":"SUM(F202:F213)","v":3108.638534635807}]
[null,{"$f":"B213+1","v":109},-6164.9136454795134,252.71122300023697,-8.7336276644293118,261.44485066466626,-6426.3584961441793]
[null,110,-6426.3584961441793,252.71122300023697,-9.1040078695375879,261.81523086977455,-6688.1737270139538]
[null,111,-6688.1737270139538,252.71122300023697,-9.4749127799364352,262.1861357801734,-6950.3598627941274]
[null,112,-6950.3598627941274,252.71122300023697,-9.846343138958348,262.55756613919533,-7212.9174289333223]
[null,113,-7212.9174289333223,252.71122300023697,-10.218299690988873,262.92952269122583,-7475.8469516245477]
[null,114,-7475.8469516245477,252.71122300023697,-10.59078318146811,263.30200618170505,-7739.1489578062528]
[null,115,-7739.1489578062528,252.71122300023697,-10.963794356892192,263.67501735712915,-8002.8239751633819]
[null,116,-8002.8239751633819,252.71122300023697,-11.337333964814793,264.04855696505177,-8266.8725321284328]
[null,117,-8266.8725321284328,252.71122300023697,-11.711402753848613,264.42262575408557,-8531.2951578825177]
[null,118,-8531.2951578825177,252.71122300023697,-12.086001473666901,264.7972244739039,-8796.0923823564208]
[null,119,-8796.0923823564208,252.71122300023697,-12.46113087500493,265.17235387524192,-9061.264736231662]
[null,120,-9061.264736231662,252.71122300023697,-12.836791709661522,265.5480147098985,-9326.8127509415608,{"$f":"SUM(E214:E225)","v":-129.3644294592076},{"$f":"SUM(F214:F225)","v":3161.8991054620515}]

{"sheet":"Amortissements","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Tableau des amortissements"]
[null,"Nature des investissements","Coût \nd'achat HT","Durée\nd'amortissement\nen années","Année 1","Année 2","Année 3"]
[null,"Mise en route SARL",{"$f":"'Bilan ouverture'!C5","v":1500},3,{"$f":"$C$4/$D$4","v":500},{"$f":"$C$4/$D$4","v":500},500]
[null,"Travaux et mise aux normes",{"$f":"'Bilan ouverture'!C6","v":1250},10,{"$f":"$C$5/$D$5","v":125},{"$f":"$C$5/$D$5","v":125},{"$f":"$C$5/$D$5","v":125}]
[null,"Construction",{"$f":"'Bilan ouverture'!C7","v":0},7,{"$f":"$C$6/$D$6","v":0},{"$f":"$C$6/$D$6","v":0},{"$f":"$C$6/$D$6","v":0}]
[null,"Aménagement",{"$f":"'Bilan ouverture'!C8","v":2000},10,{"$f":"$C$7/$D$7","v":200},{"$f":"$C$7/$D$7","v":200},200]
[null,"Mobilier",{"$f":"'Bilan ouverture'!C9","v":0},7,{"$f":"$C$8/$D$8","v":0},{"$f":"$C$8/$D$8","v":0},{"$f":"$C$8/$D$8","v":0}]
[null,"informatique",{"$f":"'Bilan ouverture'!C10","v":6765},3,{"$f":"$C$9/$D$9","v":2255},{"$f":"$C$9/$D$9","v":2255},2255]
[null,null,null,5,{"$f":"$C$10/$D$10","v":0},{"$f":"$C$10/$D$10","v":0},0]
[null,null,null,5,{"$f":"$C$11/$D$11","v":0},{"$f":"$C$11/$D$11","v":0},0]
[null,null,null,5,{"$f":"$C$12/$D$12","v":0},{"$f":"$C$12/$D$12","v":0},0]
[null,null,null,5,{"$f":"$C$13/$D$13","v":0},{"$f":"$C$13/$D$13","v":0},0]
[null,null,null,5,{"$f":"$C$14/$D$14","v":0},{"$f":"$C$14/$D$14","v":0},0]
[null,null,null,5,{"$f":"$C$15/$D$15","v":0},{"$f":"$C$15/$D$15","v":0},0]
[null,null,null,5,{"$f":"$C$16/$D$16","v":0},{"$f":"$C$16/$D$16","v":0},0]
[null,"TOTAL",{"$f":"SUM(C4:C16)","v":11515},null,{"$f":"SUM(E4:E16)","v":3080},{"$f":"SUM(F4:F16)","v":3080},{"$f":"SUM(G4:G16)","v":3080}]

{"sheet":"Compte de résultats 3 ans","index":3,"n_rows":91,"n_cols":19,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,11,2,11],[1,18,2,18],[1,1,2,4],[1,8,2,10],[1,15,2,17]]}
[]
[null,"Première année",null,null,null,null,null,null,"Deuxième Année",null,null,"Évolution %",null,null,null,"Troisième année",null,null,"Évolution %"]
[]
[null,"Ventes brutes",{"$f":"C6+C5","v":161457.48987854252},null,1,null,null,null,"Ventes brutes",{"$f":"J6+J5","v":183676.11336032388},null,{"$f":"(J4-C4)/C4","v":0.13761283851554656},null,null,null,"Ventes brutes",{"$f":"'Outil de simulation'!T80","v":204225.27859671021},null,{"$f":"(Q4-J4)/J4","v":0.11187717804151433}]
[null,"Rabais (9+6% collectivité + 1,2% carte fidélité)",{"$f":"'Outil de simulation'!T23","v":1457.48987854251},null,{"$f":"C5/C4","v":9.0270812437311925E-3},null,null,null,"Rabais (9+6% collectivité + 1,2% carte fidélité)",{"$f":"'Outil de simulation'!T52","v":1676.1133603238866},null,null,null,null,null,"Rabais (9+6% collectivité + 1,2% carte fidélité)",{"$f":"'Outil de simulation'!T81","v":2181.5539003539434}]
[null,"CA prévu",{"$f":"'Outil de simulation'!T24","v":160000},1,null,null,null,null,"CA prévu",{"$f":"'Outil de simulation'!T53","v":182000},1,{"$f":"(J6-C6)/C6","v":0.13750000000000001},null,null,null,"CA prévu",{"$f":"Q4-Q5","v":202043.72469635628},1,{"$f":"(Q6-J6)/J6","v":0.11013035547448505}]
[]
[null,"Achats consommés",{"$f":"'Outil de simulation'!T30","v":105376.51821862347},null,null,null,null,null,"Achats consommés",{"$f":"'Outil de simulation'!T59","v":118586.23481781376},{"$f":"K6-K12","v":1},null,null,null,null,"Achats consommés",{"$f":"Q4-Q12","v":129842.43108786164},{"$f":"R6-R12","v":1},{"$f":"(Q8-J8)/J8","v":9.4919922934908765E-2}]
[null,"Marge Brute",{"$f":"C6-C8","v":54623.481781376526},{"$f":"C9/C6","v":0.34139676113360329},{"$f":"C9/C4","v":0.33831494483450353},null,null,null,"Marge Brute",{"$f":"'Outil de simulation'!T60","v":63413.765182186238},{"$f":"J9/J6","v":0.34842728122080352},{"$f":"(J9-C9)/C9","v":0.16092499258820031},null,null,null,"Marge Brute",{"$f":"'Outil de simulation'!T89","v":72201.293608494627},{"$f":"Q9/Q6","v":0.35735479395365122},{"$f":"(Q9-J9)/J9","v":0.13857446251712113}]
[null,"subvention",{"$f":"'Bilan ouverture'!H18","v":20000}]
[null,"marge totale",{"$f":"C9+C10","v":74623.481781376526}]
[null,"Marge Commerciale",{"$f":"C5+C9","v":56080.971659919036},null,{"$f":"E5+E9","v":0.34734202607823472},null,null,null,"Marge Commerciale",{"$f":"'Outil de simulation'!T61","v":65089.878542510123},null,{"$f":"(J12-C12)/C12","v":0.16064106266243128},null,null,null,"Marge Commerciale",{"$f":"'Outil de simulation'!T90","v":74382.847508848572},null,{"$f":"(Q12-J12)/J12","v":0.14277133671818457}]
[null,"Autres charges extérieures",{"$f":"SUM(C14:C18)","v":3000},{"$f":"C13/$C$6","v":1.8749999999999999E-2},null,null,null,null,"Autres charges",{"$f":"SUM(J14:J18)","v":3060},{"$f":"J13/$J$6","v":1.6813186813186814E-2},{"$f":"(J13-C13)/C13","v":0.02},null,null,null,"Autres charges",{"$f":"SUM(Q14:Q18)","v":3121.2},{"$f":"Q13/$Q$6","v":1.5448141260960868E-2},{"$f":"(Q13-J13)/J13","v":1.9999999999999941E-2}]
[null,"Eau, gaz",2500,null,null,null,null,null,{"$f":"B14","v":"Eau, gaz"},{"$f":"C14+(C14*$G$31)","v":2550},null,null,null,null,null,{"$f":"I14","v":"Eau, gaz"},{"$f":"J14+(J14*$N$31)","v":2601},1.2873451050800724E-2]
[null,"Électricité",0,null,null,null,null,null,{"$f":"B15","v":"Électricité"},{"$f":"C15+(C15*$G$31)","v":0},null,null,null,null,null,{"$f":"I15","v":"Électricité"},{"$f":"J15+(J15*$N$31)","v":0},0]
[null,"Produits entretien",200,null,null,null,null,null,{"$f":"B16","v":"Produits entretien"},{"$f":"C16+(C16*$G$31)","v":204},null,null,null,null,null,{"$f":"I16","v":"Produits entretien"},{"$f":"J16+(J16*$N$31)","v":208.08},1.0298760840640581E-3]
[null,"Fournitures de bureau",300,null,null,null,null,null,{"$f":"B17","v":"Fournitures de bureau"},{"$f":"C17+(C17*$G$31)","v":306},null,null,null,null,null,{"$f":"I17","v":"Fournitures de bureau"},{"$f":"J17+(J17*$N$31)","v":312.12},1.544814126096087E-3]
[null,"Emballages, petit equipement",0,null,null,null,null,null,{"$f":"B18","v":"Emballages, petit equipement"},{"$f":"C18+(C18*$G$31)","v":0},null,null,null,null,null,{"$f":"I18","v":"Emballages, petit equipement"},{"$f":"J18+(J18*$N$31)","v":0},0]
[null,"Charges externes",{"$f":"SUM(C20:C53)","v":23079},{"$f":"C19/$C$6","v":0.14424375},null,null,null,null,"Charges externes",{"$f":"SUM(J20:J53)","v":21684.780000000002},{"$f":"J19/$J$6","v":0.11914714285714287},{"$f":"(J19-C19)/C19","v":-6.0410763031327072E-2},null,null,null,"Charges externes",{"$f":"SUM(Q20:Q53)","v":21949.435600000004},0.10863705682018565,{"$f":"(Q19-J19)/J19","v":1.2204670741414108E-2}]
[null,"Loyer",8640,{"$f":"C20/C6","v":5.3999999999999999E-2},null,null,null,null,{"$f":"B20","v":"Loyer"},{"$f":"C20","v":8640},null,null,null,null,null,{"$f":"I20","v":"Loyer"},{"$f":"J20","v":8640}]
[null,"Charges locatives",1080,null,null,null,null,null,"Charges locatives",{"$f":"C21+(C21*$G$31)","v":1101.5999999999999},null,null,null,null,null,{"$f":"I21","v":"Charges locatives"},{"$f":"J21+(J21*$N$31)","v":1123.6319999999998}]
[null,"Location TPE",480,null,null,null,null,null,"Location TPE",489.6,null,null,null,null,null,"Location TPE",499.392]
[null,"Entretien",1000,null,null,null,null,null,"Entretien",1020,null,null,null,null,null,"Entretien",1040.4000000000001]
[null,"Maintenance",0,null,null,null,null,null,"Maintenance",0,null,null,null,null,null,"Maintenance",0]
[null,"Assurances",325,null,null,null,null,null,"Assurances",331.5,null,null,null,null,null,"Assurances",338.13]
[null,"Documentation, catalogues",400,null,null,null,null,null,"Documentation, catalogues",408,null,null,null,null,null,"Documentation, catalogues",416.16]
[null,"Honoraires comptable",2000,{"$f":"C27/C6","v":1.2500000000000001E-2},null,null,null,null,"Honoraires comptable",2040,null,null,null,null,null,"Honoraires comptable",2085]
[null,"Frais d'actes (cfe, notaire)",400,null,null,null,null,null,"Frais d'actes (cfe, notaire)",{"$f":"C28+(C28*$G$31)","v":408},null,null,null,null,null,"Frais d'actes (cfe, notaire)",{"$f":"J28+(J28*$N$31)","v":416.16}]
[null,"Publicité",500,null,null,null,null,null,"Publicité",{"$f":"C29+(C29*$G$31)","v":510},null,null,null,null,null,"Publicité",{"$f":"J29+(J29*$N$31)","v":520.20000000000005}]
[null,"Transports sur achats 5,5 %",{"$f":"3.5%*'Outil de simulation'!G24","v":4200},{"$f":"C30/C6","v":2.6249999999999999E-2},null,null,"Taux d'augmentation annuel des charges",null,"Transports sur achats 5,5%",3672,{"$f":"J30/J6","v":2.0175824175824177E-2},null,null,"Taux d'augmentation annuel des charges",null,"Transports sur achats 5,5%",3745,{"$f":"Q30/Q6","v":1.8535591766723841E-2}]
[null,"Transports sur achats autres TVA",0,{"$f":"C31/C6","v":0},null,null,0.02,null,"Transports sur achats 20%",0,{"$f":"J31/J6","v":0},null,null,0.02,null,"Transports sur achats 20%",{"$f":"J31+(J31*$N$31)","v":0},{"$f":"Q31/Q6","v":0}]
[null,"Transport sur achats 5,5 %  stock initial",{"$f":"3.5%*'Outil de simulation'!G4","v":1050},{"$f":"C32/C6","v":6.5624999999999998E-3},null,null,null,null,{"$f":"B34","v":"Site internet"},null,null,null,null,null,null,{"$f":"I32","v":"Site internet"},{"$f":"J32+(J32*$N$31)","v":0}]
[null,"Transport sur achats autres TVA  stock initial",0,{"$f":"C33/C6","v":0},null,null,null,null,"Logiciel",{"$f":"C35+(C35*$G$31)","v":1836},null,null,null,null,null,"Logiciel",1872.72]
[null,"Site internet",0,null,null,null,null,null,"Cotisations",0,null,null,null,null,null,"Cotisations",0]
[null,"Logiciel",1800,null,null,null,null,null,"Déplacements",0,null,null,null,null,null,"Déplacements",0]
[null,"Cotisations",0,null,null,null,null,null,"Mission réception",0,null,null,null,null,null,"Mission réception",0]
[null,"Déplacements",0,null,null,null,null,null,"Téléphone et internet",734.4,null,null,null,null,null,"Téléphone et internet",749.08799999999997]
[null,"Mission réception",0,null,null,null,null,null,"Hébergement site Internet",24.48,null,null,null,null,null,"Hébergement site Internet",24.9696]
[null,"Téléphone et internet",720,null,null,null,null,null,"Affranchissements",102,null,null,null,null,null,"Affranchissements",104.04]
[null,"Hébergement site Internet",24,null,null,null,null,null,"Services bancaires",367.2,null,null,null,null,null,"Services bancaires",374.54399999999998]
[null,"Affranchissements",100,null,null,null,null,null,"Commission Chèque Lire",0,null,null,null,null,null,"Commission Chèque Lire",0]
[null,"Services bancaires",360,null,null,null,null,null,"SOFIA 6% facturation",{"$f":"'Outil de simulation'!E51*6%","v":0},null,null,null,null,null,"SOFIA 6% facturation",{"$f":"'Outil de simulation'!E80*6%","v":0}]
[null,"Commission Chèque Lire",0,null,null,null,null,null,"Autres",{"$f":"C45+(C45*$G$31)","v":0},null,null,null,null,null,"Autres",{"$f":"J43+(J43*$N$31)","v":0}]
[null,"SOFIA 6% facturation",{"$f":"'Outil de simulation'!E22*6%","v":0},null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Autres",0,null,null,null,null,null,"Autres",0,null,null,null,null,null,"Autres",0]
[null,"Impôts et taxes",{"$f":"1%*C6","v":1600},{"$f":"C54/C6","v":0.01},null,null,null,null,"Impôts et taxes",{"$f":"C54+(C54*$G$31)","v":1632},{"$f":"J54/J6","v":8.9670329670329674E-3},null,null,null,null,"Impôts et taxes",1664.64]
[null,"Personnel et charges",{"$f":"E81","v":21600},{"$f":"C55/C6","v":0.13500000000000001},null,null,null,null,"Personnel et charges",{"$f":"L81","v":21816},{"$f":"J55/J6","v":0.11986813186813187},{"$f":"(J55-C55)/C55","v":0.01},null,null,null,"Personnel et charges",{"$f":"S81","v":22034.159999999996},{"$f":"Q55/Q6","v":0.10905639377374519},{"$f":"(Q55-J55)/J55","v":9.9999999999998267E-3}]
[null,"Dotation aux amortissements",{"$f":"Amortissements!E17","v":3080},{"$f":"C56/$C$6","v":1.925E-2},null,null,null,null,"Dotation aux amortissements",{"$f":"Amortissements!F17","v":3080},{"$f":"J56/$J$6","v":1.6923076923076923E-2},{"$f":"(J56-C56)/C56","v":0},null,null,null,"Dotation aux amortissements",{"$f":"Amortissements!G17","v":3080},{"$f":"Q56/$Q$6","v":1.5244225004408394E-2},{"$f":"(Q56-J56)/J56","v":0}]
[null,"Financier intérêts des emprunts",{"$f":"'Bilan ouverture'!I90","v":318.9212817455151},{"$f":"C57/$C$6","v":1.9932580109094694E-3},null,null,null,null,"Financier intérêts des emprunts",{"$f":"'Bilan ouverture'!I91","v":272.42871055411439},{"$f":"J57/$J$6","v":1.4968610470006286E-3},{"$f":"(J57-C57)/C57","v":-0.14578071095455994},null,null,null,"Financier intérêts des emprunts",{"$f":"'Bilan ouverture'!I92","v":225.13957815006563},{"$f":"Q57/$J$6","v":1.2370306491761849E-3},{"$f":"(Q57-J57)/J57","v":-0.17358351220715187}]
[null,"Produits Exceptionnels subvention investissements",{"$f":"'Bilan ouverture'!J25","v":2000},null,null,null,null,null,{"$f":"B58","v":"Produits Exceptionnels subvention investissements"},{"$f":"'Bilan ouverture'!K25","v":2000},null,null,null,null,null,{"$f":"I58","v":"Produits Exceptionnels subvention investissements"},{"$f":"'Bilan ouverture'!L25","v":2000}]
[null,"Total charges",{"$f":"C13+C19+C54+C55+C56+C57","v":52677.921281745512},null,null,null,null,null,"Total charges",{"$f":"J13+J19+J54+J55+J56+J57","v":51545.208710554114},null,{"$f":"(J59-C59)/C59","v":-2.150260571470038E-2},null,null,null,"Total charges",{"$f":"Q13+Q19+Q54+Q55+Q56+Q57","v":52074.575178150066},null,{"$f":"(Q59-J59)/J59","v":1.026994517702984E-2}]
[null,"Résultat avant IS",{"$f":"C11-C13-C19-C55-C56-C57-C54+C58","v":23945.56049963101},null,null,null,null,null,"Résultat avant IS ",{"$f":"J9-J13-J19-J55-J56-J57-J54+J58","v":13868.556471632124},null,{"$f":"(J60-C60)/C60","v":-0.42082974120209748},null,null,null,"Résultat avant IS",{"$f":"Q9-Q13-Q19-Q55-Q56-Q57-Q54+Q58","v":22126.718430344565},null,{"$f":"(Q60-J60)/J60","v":0.59545937427621676}]
[null,"IS",null,null,null,null,null,null,"IS",null,null,null,null,null,null,"IS"]
[null,0.15,{"$f":"IF(C60<0,0,C60*B62)","v":3591.8340749446515},null,null,null,null,null,0.15,{"$f":"IF(J60<0,0,J60*I62)","v":2080.2834707448187},null,null,null,null,null,0.15,{"$f":"IF(Q60<0,0,Q60*P62)","v":3319.0077645516844}]
[null,"Résultat net",{"$f":"C60-C62","v":20353.72642468636},{"$f":"C63/$C$6","v":0.12721079015428974},null,null,null,null,"Résultat net",{"$f":"J60-J62","v":11788.273000887306},{"$f":"J63/$J$6","v":6.4770730774106069E-2},{"$f":"(J63-C63)/C63","v":-0.42082974120209748},null,null,null,"Résultat net",{"$f":"Q60-Q62","v":18807.710665792882},{"$f":"Q63/$J$6","v":0.10333906959226859},{"$f":"(Q63-J63)/J63","v":0.59545937427621676}]
[null,"Capacité d'autofinancement simplifiée",{"$f":"C63+C56","v":23433.72642468636},{"$f":"C64/$C$6","v":0.14646079015428976},null,null,null,null,"Capacité d'autofinancement simplifiée",{"$f":"J63+J56","v":14868.273000887306},{"$f":"J64/$J$6","v":8.1693807697182999E-2},{"$f":"(J64-C64)/C64","v":-0.36551819666102014},null,null,null,"Capacité d'autofinancement simplifiée",{"$f":"Q63+Q56","v":21887.710665792882},{"$f":"Q64/$J$6","v":0.1202621465153455},{"$f":"(Q64-J64)/J64","v":0.47210847315533361}]
[]
[]
[null,"PERSONNEL","Salaires mensuels nets","Charges","Salaires annuels",null,null,null,"PERSONNEL","Salaires mensuels nets","Charges","Salaires annuels",null,null,null,"PERSONNEL","Salaires mensuels nets","Charges","Salaires annuels"]
[null,null,null,0.5,12,null,null,null,null,null,0.5,12,null,null,null,null,null,0.5,12]
[null,"Gérant 1",1200,{"$f":"C69*$D$68","v":600},{"$f":"(C69+D69)*E$68","v":21600},null,null,null,{"$f":"B69","v":"Gérant 1"},{"$f":"C69+(C69*$G$81)","v":1212},{"$f":"J69*$K$68","v":606},{"$f":"(J69+K69)*L$68","v":21816},null,null,null,{"$f":"I69","v":"Gérant 1"},{"$f":"J69+(J69*$N$81)","v":1224.1199999999999},{"$f":"Q69*R68","v":612.05999999999995},{"$f":"(Q69+R69)*S$68","v":22034.159999999996}]
[null,"Gérant 2",0,0,{"$f":"(C70+D70)*E$68","v":0},null,null,null,"Gérant 2",{"$f":"C70+(C70*$G$81)","v":0},0,0,null,null,null,"Gérant 2",0,{"$f":"Q70*$R$68","v":0},0]
[null,"Libraire 1",null,0,0,null,null,null,"Libraire 1",{"$f":"C71+(C71*$G$81)","v":0},0,0,null,null,null,"Libraire 1",0,0,0]
[null,"Libraire 2",null,0,0,null,null,null,"Libraire 2",0,0,0,null,null,null,"Libraire 2",0,0,0]
[null,"Libraire 3",null,0,0,null,null,null,"Libraire 3",0,0,0,null,null,null,"Libraire 3",0,0,0]
[null,"Libraire 4",null,0,0,null,null,null,"Libraire 4",0,0,0,null,null,null,"Libraire 4",0,0,0]
[null,"Libraire 5",null,{"$f":"C75*$D$68","v":0},0,null,null,null,"Libraire 5",0,0,0,null,null,null,"Libraire 5",0,0,0]
[null,"Libraire 6",null,0,0,null,null,null,"Libraire 6",0,0,0,null,null,null,"Libraire 6",0,0,0]
[null,"Libraire 7",null,0,0,null,null,null,"Libraire 7",0,0,0,null,null,null,"Libraire 7",0,0,0]
[null,"Libraire 8",null,0,0,null,null,null,"Libraire 8",0,0,0,null,null,null,"Libraire 8",0,0,0]
[null,"Libraire 9",null,0,0,null,null,null,"Libraire 9",0,0,0,null,null,null,"Libraire 9",0,0,0]
[null,"Libraire 10",null,0,0,null,"Taux d'augmentation annuel des salaires",null,"Libraire 10",0,0,0,null,"Taux d'augmentation annuel des salaires",null,"Libraire 10",0,0,0]
[null,"Total",{"$f":"SUM(C69:C80)","v":1200},{"$f":"SUM(D69:D80)","v":600},{"$f":"SUM(E69:E80)","v":21600},null,0.01,null,"Total",{"$f":"SUM(J69:J80)","v":1212},{"$f":"SUM(K69:K80)","v":606},{"$f":"SUM(L69:L80)","v":21816},null,0.01,null,"Total",{"$f":"SUM(Q69:Q80)","v":1224.1199999999999},{"$f":"SUM(R69:R74)","v":612.05999999999995},{"$f":"SUM(S69:S74)","v":22034.159999999996}]
[]
[]
[null,"Données complémentaires","Montants","En jours",null,null,null,null,"Données complémentaires","Montants","En jours",null,null,null,null,"Données complémentaires","Montants","En jours"]
[null,"Valeur du stock moyen",{"$f":"('Outil de simulation'!T26+'Outil de simulation'!T28)/2","v":43247.894793624473},null,null,null,null,null,"Valeur du stock moyen",{"$f":"('Outil de simulation'!T55+'Outil de simulation'!T57)/2","v":46170.789587248946},null,null,null,null,null,"Valeur du stock moyen",{"$f":"('Outil de simulation'!T84+'Outil de simulation'!T86)/2","v":46170.789587248946}]
[null,"Achat par jours TTC",{"$f":"('Outil de simulation'!G27*1.055+'Outil de simulation'!J27*1.2)/365","v":331.09964847045791},null,null,null,null,null,"Achats par jour TTC",{"$f":"('Outil de simulation'!G56*1.055+'Outil de simulation'!J56*1.196)/365","v":352.96130885696851},null,null,null,null,null,"Achats par jour TTC",{"$f":"Q8*1.055/365","v":375.29798574710691}]
[null,"Dette fournisseurs",{"$f":"'Trésorerie année 1'!AA139","v":8260.9104087762862},{"$f":"C87/C86","v":24.949922015738288},null,null,null,null,"Dette fournisseurs",{"$f":"'Trésorerie année 2'!AA119","v":8753.0829959514158},{"$f":"J87/J86","v":24.798987243948748},null,null,null,null,"Dette fournisseurs",{"$f":"'Trésorerie année 3'!AA114","v":9617.1466317924624},{"$f":"Q87/Q86","v":25.625361704640056}]
[]
[null,"Rotation",{"$f":"C8/C85","v":2.436569889042504},{"$f":"360/C89","v":147.74868622441556},null,null,null,null,"Rotation",{"$f":"J8/J85","v":2.568425532201942},{"$f":"365/J89","v":142.11040788365045},null,null,null,null,"Rotation",{"$f":"Q8/Q85","v":2.8122202857826024},{"$f":"365/Q89","v":129.79068597338758}]
[null,"Besoin par le stock en J",{"$f":"D89-D87","v":122.79876420867728},null,null,null,null,null,"Besoin par le stock en J",{"$f":"K89-D87","v":117.16048586791217},null,null,null,null,null,"Besoin par le stock en J",{"$f":"R89-R87","v":104.16532426874753}]
[null,"Besoin par le stock en €",{"$f":"C90*C86","v":40658.627662099694},null,null,null,null,null,"Besoin par le stock en €",{"$f":"J90*J86","v":41353.118438256643},null,null,null,null,null,"Besoin par le stock en €",{"$f":"Q90*Q86","v":39093.036382755177}]

{"sheet":"Trésorerie année 1","index":4,"n_rows":149,"n_cols":28,"rows_kept":149,"cut":false,"hidden":false,"merged":[[130,21,130,22],[145,3,148,14],[81,3,92,15],[23,2,23,15],[20,1,20,14],[40,1,43,1],[81,1,81,2],[130,18,130,20],[59,3,68,15]]}
[]
[null,"Formation du résultat en fonction de la saisonnalité","%",{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"Saisonnalité des ventes",null,{"$f":"'Outil de simulation'!C117","v":0.14000000000000001},{"$f":"'Outil de simulation'!D117","v":0.09},{"$f":"'Outil de simulation'!E117","v":0.11},{"$f":"'Outil de simulation'!F117","v":0.16},{"$f":"'Outil de simulation'!G117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I117","v":0.05},{"$f":"'Outil de simulation'!J117","v":0.06},{"$f":"'Outil de simulation'!K117","v":0.05},{"$f":"'Outil de simulation'!L117","v":0.08},{"$f":"'Outil de simulation'!M117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N117","v":0.05},{"$f":"SUM(D3:O3)","v":1.0000000000000002}]
[]
[null,"Ventes brutes",null,{"$f":"$P$5*D3","v":22604.048582995954},{"$f":"$P$5*E3","v":14531.174089068825},17760.323886639679,25833.198380566802,11302.024291497977,11302.024291497977,8072.8744939271264,9687.4493927125513,8072.8744939271264,12916.599190283401,11302.024291497977,8072.8744939271264,{"$f":"'Compte de résultats 3 ans'!C4","v":161457.48987854252}]
[null,"CA global",null,{"$f":"$P$6*D3","v":22400.000000000004},{"$f":"$P$6*E3","v":14400},17600,25600,11200.000000000002,11200.000000000002,8000,9600,8000,12800,11200.000000000002,8000,{"$f":"'Compte de résultats 3 ans'!C6","v":160000}]
[null,"Marge commerciale",{"$f":"'Outil de simulation'!V32","v":0.34734202607823478},{"$f":"D5*$C$7","v":7851.3360323886664},5047.2874493927138,6168.9068825910954,8972.955465587047,3925.6680161943332,3925.6680161943332,2804.0485829959525,3364.8582995951429,2804.0485829959525,4486.4777327935235,3925.6680161943332,2804.0485829959525,56080.971659919043]
[null,"Marge brute",{"$f":"'Compte de résultats 3 ans'!D9","v":0.34139676113360329},{"$f":"$P$8*D3","v":7647.2874493927147},{"$f":"$P$8*E3","v":4916.1133603238868},6008.5829959514176,8739.7570850202446,3823.6437246963574,3823.6437246963574,2731.1740890688266,3277.4089068825915,2731.1740890688266,4369.8785425101223,3823.6437246963574,2731.1740890688266,{"$f":"P6*C8","v":54623.481781376526}]
[null,"Subvention exploitation (CNL, plan état/région, DRAC)",null,{"$f":"'Bilan ouverture'!H18","v":20000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":20000}]
[null,"Produit exceptionnel sub investissement",null,{"$f":"$P$10/12","v":166.66666666666666},{"$f":"$P$10/12","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,{"$f":"'Bilan ouverture'!J25","v":2000}]
[null,"Fournitures \nconsommables",null,{"$f":"$P$11*D3","v":420.00000000000006},{"$f":"$P$11*E3","v":270},330,480,210.00000000000003,210.00000000000003,150,180,150,240,210.00000000000003,150,{"$f":"'Compte de résultats 3 ans'!C13","v":3000}]
[null,"Loyer",null,{"$f":"$P$12/12","v":720},720,720,720,720,720,720,720,720,720,720,720,{"$f":"'Compte de résultats 3 ans'!C20","v":8640}]
[null,"Charges externes",null,{"$f":"$P$13/12","v":1203.25},1203.25,1203.25,1203.25,1203.25,1203.25,1203.25,1203.25,1203.25,1203.25,1203.25,1203.25,{"$f":"'Compte de résultats 3 ans'!C19-'Compte de résultats 3 ans'!C20","v":14439}]
[null,"Personnel (salaires et charges)",null,{"$f":"$P$14/12","v":1800},1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,{"$f":"'Compte de résultats 3 ans'!C55","v":21600}]
[null,"Amortissements",null,{"$f":"$P$15/12","v":256.66666666666669},256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,{"$f":"'Compte de résultats 3 ans'!C56","v":3080}]
[null,"Impôts",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P16","v":1600},null,{"$f":"'Compte de résultats 3 ans'!C54","v":1600}]
[null,"Financier",null,{"$f":"$P$17/12","v":26.576773478792926},26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,26.576773478792926,{"$f":"'Bilan ouverture'!I90","v":318.9212817455151}]
[null,"autres"]
[null,"Résultat net avant IS",null,{"$f":"D8-SUM(D11:D17)+D9","v":23220.794009247256},{"$f":"E8-SUM(E11:E17)","v":639.61992017842658},{"$f":"F8-SUM(F11:F17)","v":1672.0895558059574},4253.2636448747844,-392.84971544910286,-392.84971544910286,-1425.3193510766337,-909.08453326286872,-1425.3193510766337,123.38510236466209,-1992.8497154491029,-1425.3193510766337,{"$f":"P8-SUM(P11:P17)+P9+P10","v":23945.560499631014}]
[null,"Résultat net avant IS cumulé",null,null,{"$f":"D19+E19","v":23860.413929425682},{"$f":"E20+F19","v":25532.503485231638},{"$f":"F20+G19","v":29785.767130106422},29392.91741465732,29000.067699208219,27574.748348131587,26665.66381486872,25240.344463792087,25363.729566156748,23370.879850707646,21945.560499631014]
[null,"Capacité d'autofinancement (CAF)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P15+P19-AA146","v":23433.726424686363}]
[]
[null,"Répartition des ventes en fonction de la saisonnalité",null,{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"Librairie"]
[null,"Répartition du CA comptant",null,{"$f":"$P$25*D26","v":16800},{"$f":"$P$25*E26","v":10800},{"$f":"$P$25*F26","v":13200},19200,8400,8400,6000,7200,6000,9600,8400,6000,{"$f":"'Outil de simulation'!C24","v":120000}]
[null,"Saisonnalité Librairie comptant",null,{"$f":"'Outil de simulation'!C117","v":0.14000000000000001},{"$f":"'Outil de simulation'!D117","v":0.09},{"$f":"'Outil de simulation'!E117","v":0.11},{"$f":"'Outil de simulation'!F117","v":0.16},{"$f":"'Outil de simulation'!G117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I117","v":0.05},{"$f":"'Outil de simulation'!J117","v":0.06},{"$f":"'Outil de simulation'!K117","v":0.05},{"$f":"'Outil de simulation'!L117","v":0.08},{"$f":"'Outil de simulation'!M117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N117","v":0.05},{"$f":"SUM(D26:O26)","v":1.0000000000000002}]
[null,"Répartition du CA livre à terme",null,{"$f":"$P$27*D28","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!E24","v":0}]
[null,"Saisonnalité facturation librairie à terme",null,{"$f":"'Outil de simulation'!C119","v":0.1},{"$f":"'Outil de simulation'!D119","v":0.1},{"$f":"'Outil de simulation'!E119","v":0.1},{"$f":"'Outil de simulation'!F119","v":0.1},{"$f":"'Outil de simulation'!G119","v":0.1},{"$f":"'Outil de simulation'!H119","v":0.1},{"$f":"'Outil de simulation'!I119","v":0.1},{"$f":"'Outil de simulation'!J119","v":0.1},{"$f":"'Outil de simulation'!K119","v":0.1},{"$f":"'Outil de simulation'!L119","v":0.1},{"$f":"'Outil de simulation'!M119","v":0},{"$f":"'Outil de simulation'!N119","v":0},{"$f":"SUM(D28:O28)","v":0.99999999999999989}]
[null,"Total librairie (TVA 5,5 %)",null,{"$f":"D25+D27","v":16800},{"$f":"E25+E27","v":10800},13200,19200,8400,8400,6000,7200,6000,9600,8400,6000,{"$f":"P25+P27","v":120000}]
[null,"Autres produits"]
[null,"Répartition du CA des ventes autres produits (TVA 20 %)",null,{"$f":"$P$31*D32","v":5600.0000000000009},3600,4400,6400,2800.0000000000005,2800.0000000000005,2000,2400,2000,3200,2800.0000000000005,2000,{"$f":"'Outil de simulation'!P24","v":40000}]
[null,"Saisonnalité des ventes autres produits",null,{"$f":"'Outil de simulation'!C120","v":0.14000000000000001},{"$f":"'Outil de simulation'!D120","v":0.09},{"$f":"'Outil de simulation'!E120","v":0.11},{"$f":"'Outil de simulation'!F120","v":0.16},{"$f":"'Outil de simulation'!G120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I120","v":0.05},{"$f":"'Outil de simulation'!J120","v":0.06},{"$f":"'Outil de simulation'!K120","v":0.05},{"$f":"'Outil de simulation'!L120","v":0.08},{"$f":"'Outil de simulation'!M120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N120","v":0.05},{"$f":"SUM(D32:O32)","v":1.0000000000000002}]
[null,"Total CA autres produits (TVA 20 %)",null,{"$f":"D31","v":5600.0000000000009},3600,4400,6400,2800.0000000000005,2800.0000000000005,2000,2400,2000,3200,2800.0000000000005,2000,40000]
[null,"Restaurant/Café"]
[null,"Répartition des ventes restaurant café (TVA 10 %)",null,{"$f":"$P$35*D36","v":0},{"$f":"$P$35*E36","v":0},{"$f":"$P$35*F36","v":0},{"$f":"$P$35*G36","v":0},0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R24","v":0}]
[null,"Saisonnalité des ventes restaurant café",null,{"$f":"'Outil de simulation'!C122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!D122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!E122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!F122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!G122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!H122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!I122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!J122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!K122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!L122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!M122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!N122","v":8.3333333333333343E-2},{"$f":"SUM(D36:O36)","v":1.0000000000000002}]
[null,"Total Restaurant café (TVA 10 % majoritaire)",null,{"$f":"D35","v":0},{"$f":"E35","v":0},{"$f":"F35","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D37:O37)","v":0}]
[]
[null,"Total CA",null,{"$f":"D29+D33+D37","v":22400},{"$f":"E29+E33+E37","v":14400},17600,25600,11200,11200,8000,9600,8000,12800,11200,8000,{"$f":"P29+P33+P37","v":160000}]
[]
[null,"Répartition des achats en fonction de la saisonnalité","Saisons",{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,null,"Librairie",{"$f":"'Outil de simulation'!C118","v":0.09},{"$f":"'Outil de simulation'!D118","v":0.12},{"$f":"'Outil de simulation'!E118","v":0.15},{"$f":"'Outil de simulation'!F118","v":0.13},{"$f":"'Outil de simulation'!G118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I118","v":0.06},{"$f":"'Outil de simulation'!J118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!K118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!L118","v":0.08},{"$f":"'Outil de simulation'!M118","v":0.05},{"$f":"'Outil de simulation'!N118","v":0.04},{"$f":"SUM(D42:O42)","v":1.0000000000000002}]
[null,null,"Autres produits",{"$f":"'Outil de simulation'!C121","v":0.3},{"$f":"'Outil de simulation'!D121","v":0},{"$f":"'Outil de simulation'!E121","v":0},{"$f":"'Outil de simulation'!F121","v":0},{"$f":"'Outil de simulation'!G121","v":0},{"$f":"'Outil de simulation'!H121","v":0},{"$f":"'Outil de simulation'!I121","v":0.3},{"$f":"'Outil de simulation'!J121","v":0},{"$f":"'Outil de simulation'!K121","v":0},{"$f":"'Outil de simulation'!L121","v":0.4},{"$f":"'Outil de simulation'!M121","v":0},{"$f":"'Outil de simulation'!N121","v":0},{"$f":"SUM(D43:O43)","v":1}]
[null,null,"Restauration café",{"$f":"'Outil de simulation'!C123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!D123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!E123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!F123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!G123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!H123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!I123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!J123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!K123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!L123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!M123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!N123","v":8.3333333333333343E-2},{"$f":"SUM(D44:O44)","v":1.0000000000000002}]
[null,"Coût des ventes"]
[null,"Librairie",null,{"$f":"$P$46*D42","v":7323.8866396761123},{"$f":"$P$46*E42","v":9765.182186234817},12206.477732793521,10578.947368421052,5696.356275303644,5696.356275303644,4882.5910931174085,5696.356275303644,5696.356275303644,6510.1214574898777,4068.8259109311739,3255.0607287449388,{"$f":"'Outil de simulation'!G30","v":81376.518218623474}]
[null,"Autres produits",null,{"$f":"$P$47*D43","v":7200},0,0,0,0,0,7200,0,0,9600,0,0,{"$f":"'Outil de simulation'!P30","v":24000}]
[null,"Restauration café",null,{"$f":"$P$48*D44","v":0},{"$f":"$P$48*E44","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R30","v":0}]
[null,"Augmentation stock"]
[null,"Augmentation stock librairie",null,{"$f":"$P$50*D42","v":506.36019328718714},{"$f":"$P$50*E42","v":675.14692438291615},843.93365547864516,731.40916808149257,393.83570589003449,393.83570589003449,337.57346219145808,393.83570589003449,393.83570589003449,450.09794958861079,281.31121849288178,{"$f":"$P$50*O42","v":225.04897479430539},{"$f":"('Outil de simulation'!G28-'Outil de simulation'!G26)","v":5626.2243698576349}]
[null,"Augmentation stock autres produits",null,{"$f":"$P$51*D43","v":65.869565217392292},{"$f":"$P$51*E43","v":0},0,0,0,0,65.869565217392292,0,0,87.826086956523071,0,0,{"$f":"'Outil de simulation'!P28-'Outil de simulation'!P26","v":219.56521739130767}]
[null,"Augmentation stock restauration café",null,{"$f":"$P$52*D44","v":0},{"$f":"$P$52*E44","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"('Outil de simulation'!R28-'Outil de simulation'!R26)","v":0}]
[null,"Total des achats"]
[null,"Total achats librairie",null,{"$f":"D46+D50","v":7830.2468329632993},{"$f":"E46+E50","v":10440.329110617733},13050.411388272167,11310.356536502544,6090.1919811936787,6090.1919811936787,5220.1645553088665,6090.1919811936787,6090.1919811936787,6960.2194070784881,{"$f":"N46+N50","v":4350.1371294240553},{"$f":"O46+O50","v":3480.109703539244},87002.742588481109]
[null,"Total achats autres produits",null,{"$f":"D47+D51","v":7265.8695652173919},{"$f":"E47+E51","v":0},0,0,0,0,7265.8695652173919,0,0,9687.8260869565238,0,{"$f":"O47+O51","v":0},{"$f":"P47+P51","v":24219.565217391308}]
[null,"Total achats restauration café",null,{"$f":"D48+D52","v":0},{"$f":"E48+E52","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P48+P52","v":0}]
[]
[null,"Total achats",null,{"$f":"SUM(D54:D57)","v":15096.116398180691},{"$f":"SUM(E54:E57)","v":10440.329110617733},{"$f":"SUM(F54:F57)","v":13050.411388272167},11310.356536502544,6090.1919811936787,6090.1919811936787,12486.034120526259,6090.1919811936787,6090.1919811936787,16648.04549403501,4350.1371294240553,3480.109703539244,{"$f":"SUM(P54:P57)","v":111222.30780587242}]
[]
[null,"Trésorerie entrante","Démarrage","Notes - Ci-dessus dans le tableau \"Répartition des achats en fonction de la saisonnalité\", l'augmentation de stock ne peut pas être automatisée. Elle est notée ici pour l'exemple mais c'est à vous de la positionner. La somme des augmentation, quelque soit la nature des produits doit être égale à P49, P50 ou P51.   Attention, ci-dessous, nous avons pris le parti de compter les facturation dans le mois de l'émission des factures. C'est un peu osé mais avec un peu de vigilance, ça passe !            La TVA à récupérer (le redu) est positionnée à 6 mois. "]
[null,"Apports et emprunts initiaux","Apports"]
[null,"Emprunt banque",{"$f":"'Bilan ouverture'!E8","v":20000}]
[null,"Capital et comptes courants Adelc",{"$f":"('Bilan ouverture'!E7+'Bilan ouverture'!E5)","v":5000}]
[null,"Emprunt taux 0 %",{"$f":"'Bilan ouverture'!E9","v":10000}]
[null,"Subventions d'investissements",{"$f":"'Bilan ouverture'!E10","v":10000}]
[null,"Capitaux propres",{"$f":"'Bilan ouverture'!E4","v":3000}]
[null,"Compte courant",{"$f":"'Bilan ouverture'!E6","v":2000}]
[null,"Total des apports et emprunts divers",{"$f":"SUM(C62:C67)","v":50000}]
[]
[null,"Répartition du CA",null,{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"CA TTC librairie",null,{"$f":"D29*1.055","v":17724},11394,13926,20256,8862,8862,6330,7596,6330,10128,8862,6330,{"$f":"SUM(D71:O71)","v":126600}]
[null,"CA TTC autres produits",null,{"$f":"D33*1.2","v":6720.0000000000009},4320,5280,7680,3360.0000000000005,3360.0000000000005,2400,2880,2400,3840,3360.0000000000005,2400,{"$f":"SUM(D72:O72)","v":48000}]
[null,"CA TTC restauration café",null,{"$f":"D37*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D73:O73)","v":0}]
[null,"Total CA TTC",null,{"$f":"SUM(D71:D73)","v":24444},{"$f":"SUM(E71:E73)","v":15714},19206,27936,12222,12222,8730,10476,8730,13968,12222,8730,174600]
[]
[null,"Subvention exploitation (CNL, plan état/région/DRAC)",null,{"$f":"'Bilan ouverture'!H18","v":20000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D76:O76)","v":20000}]
[]
[null,"Récupération TVA",null,null,null,null,null,null,{"$f":"I130*-1","v":3565.6110719088952},null,null,null,null,{"$f":"N130*-1","v":2579.6656818945075},null,{"$f":"SUM(D78:O78)","v":6145.2767538034022}]
[]
[null,"Total des entrées d'argent dans la strcuture",null,{"$f":"C65+D74+D78+D76","v":54444},{"$f":"E74+E78","v":15714},{"$f":"F74+F78","v":19206},27936,12222,15787.611071908896,8730,10476,8730,13968,14801.665681894508,8730,{"$f":"P74+P78+P76","v":200745.27675380339}]
[]
[null,"Trésorerie sortante",null,"Notes - Le paiement du stock n'est pas automatique. Il dépend des conditions particulières d'un stock de reprise (crédit-vendeur, paiement en intégralité dès le premier mois, à 3 mois, etc.) ou des conditions propres à un stock d'implantation. C'est donc à vous de l'échelonner ci-dessous dans les cases rouges. Attention, les cases C89, C90 et C91 doivent être égales aux cases P89, P90 et P91."]
[null,"Financement implantation","Démarrage"]
[null,"Fonds de commerce ",{"$f":"'Bilan ouverture'!C4","v":10000}]
[null,{"$f":"'Bilan ouverture'!$B$5","v":"Mise en route SARL"},{"$f":"'Bilan ouverture'!$C$5","v":1500}]
[null,{"$f":"'Bilan ouverture'!$B$6","v":"Travaux et mise aux normes"},{"$f":"'Bilan ouverture'!C6*1.2","v":1500}]
[null,{"$f":"'Bilan ouverture'!$B$7","v":"Construction"},{"$f":"'Bilan ouverture'!C7*1.2","v":0}]
[null,{"$f":"'Bilan ouverture'!$B$8","v":"Aménagement"},{"$f":"'Bilan ouverture'!C8*1.2","v":2400}]
[null,{"$f":"'Bilan ouverture'!$B$9","v":"Mobilier"},{"$f":"'Bilan ouverture'!$C$9*1.2","v":0}]
[null,{"$f":"'Bilan ouverture'!$B$10","v":"informatique"},{"$f":"'Bilan ouverture'!C10*1.2","v":8118}]
[null,{"$f":"'Bilan ouverture'!B11","v":"Caution financière/bancaire"},{"$f":"'Bilan ouverture'!C11","v":0}]
[null,{"$f":"'Bilan ouverture'!B12","v":"Caution bail"},{"$f":"'Bilan ouverture'!C12","v":1440}]
[null,"Total financement implantation",{"$f":"SUM(C84:C92)","v":24958}]
[null,null,null,{"$f":"D41","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[null,"Stock Librairie TTC à payer",{"$f":"'Bilan ouverture'!C13*1.055","v":31649.999999999996},{"$f":"$C$95/6","v":5274.9999999999991},{"$f":"$C$95/6","v":5274.9999999999991},5274.9999999999991,5274.9999999999991,5274.9999999999991,5274.9999999999991,null,null,null,null,null,null,{"$f":"SUM(D95:O95)","v":31649.999999999996}]
[null,"Stock autres produits TTC à payer",{"$f":"'Bilan ouverture'!C14*1.2","v":12390},{"$f":"$C$96/3","v":4130},{"$f":"$C$96/3","v":4130},4130,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D96:O96)","v":12390}]
[null,"Stock restauration café TTC à payer",{"$f":"'Bilan ouverture'!C15*1.1","v":0},{"$f":"C97","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D97:O97)","v":0}]
[]
[null,"Achats librairie TTC ",null,null,null,{"$f":"D46*1.055","v":7726.7004048582976},10302.267206477731,12877.834008097163,11160.789473684208,6009.6558704453437,6009.6558704453437,5151.1336032388654,6009.6558704453437,6009.6558704453437,6868.1781376518202,{"$f":"SUM(D99:O99)","v":78125.526315789451}]
[null,"Achats autres produits TTC",null,null,{"$f":"D47*1.2","v":8640},0,0,0,0,0,8640,0,0,11520,0,{"$f":"SUM(D100:O100)","v":28800}]
[null,"Achats restauration café TTC",null,{"$f":"D48*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D101:O101)","v":0}]
[]
[null,"Augmentation stock librairie TTC","échéancé",null,null,{"$f":"D50*1.055","v":534.21000391798236},712.28000522397645,890.35000652997064,771.63667232597459,415.49666971398636,415.49666971398636,356.14000261198822,415.49666971398636,415.49666971398636,474.85333681598433,{"$f":"SUM(D103:O103)","v":5401.4567062818214}]
[null,"Augmentation stock autres produits TTC","échéancé",null,{"$f":"D51*1.2","v":79.043478260870742},0,0,0,0,0,79.043478260870742,0,0,105.39130434782768,0,{"$f":"SUM(D104:O104)","v":263.47826086956917}]
[null,"Augmentation stock restauration café TTC",null,{"$f":"D52*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D105:O105)","v":0}]
[]
[null,"Fournitures \nconsommables TTC",null,{"$f":"D11*1.2","v":504.00000000000006},324,396,576,252.00000000000003,252.00000000000003,180,216,180,288,252.00000000000003,180,{"$f":"SUM(D107:O107)","v":3600}]
[null,"Loyer TTC",null,{"$f":"D12*1.2","v":864},864,864,864,864,864,864,864,864,864,864,864,10368]
[null,"Services\nextérieurs TTC",null,{"$f":"D13*1.2","v":1443.8999999999999},1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,1443.8999999999999,17326.8]
[null,"Personnel",null,{"$f":"D14","v":1800},1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,21600]
[null,"Financier TTC",null,{"$f":"D17*1.2","v":31.892128174551509},31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,31.892128174551509,382.70553809461808]
[null,"Impôts",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16","v":1600},null,1600]
[null,"Remboursement emprunts taux 0 %",null,{"$f":"$P$113/12","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,{"$f":"'Bilan ouverture'!Y90","v":2000}]
[null,"Remboursement\nemprunts",null,{"$f":"$P$114/12","v":226.13444952144411},226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,226.13444952144411,{"$f":"'Bilan ouverture'!J90","v":2713.6133942573292}]
[null,"IS",{"$f":"'Compte de résultats 3 ans'!B62","v":0.15},null,null,null,{"$f":"IF($AA$146<0,0,$AA$146/4)","v":897.958518736163},null,null,{"$f":"IF($AA$146<0,0,$AA$146/4)","v":897.958518736163},null,null,{"$f":"IF($AA$146<0,0,$AA$146/4)","v":897.958518736163},null,null,{"$f":"SUM(D115:O115)","v":2693.8755562084889}]
[]
[null,"Total sorties",{"$f":"C93","v":24958},{"$f":"SUM(D95:D116)","v":14441.593244362661},{"$f":"SUM(E95:E115)","v":22980.636722623534},22594.503653138941,{"$f":"SUM(G95:G115)","v":22296.09897480053},23827.777258989794,21992.019390372843,12035.704303258153,19892.789262782862,10219.866850213515,12143.704303258153,24435.137088869818,12055.624718830464,218915.45577150123]
[]
[null,"Tableau de répartition de la TVA","Démarrage",{"$f":"D23","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[]
[null,"TVA à payer",null,{"$f":"(D29*5.5%)+(D33*20%)+(D37*10%)","v":2044.0000000000002},1314,1606,2336,1022.0000000000001,1022.0000000000001,730,876,730,1168,1022.0000000000001,730,{"$f":"SUM(D121:O121)","v":14600}]
[]
[null,"TVA à récupérer"]
[null,"Sur stocks",{"$f":"(C95-(C95/1.055))+(C96-(C96/1.2))+(C97-(C97/1.1))","v":3714.9999999999964}]
[null,"Sur achats de marchandses et augmentation du stock",null,{"$f":"D54*5.5%+D55*20%+D56*10%","v":1883.8374888564599},574.21810108397528,717.77262635496913,622.06960950763994,334.96055896565235,334.96055896565235,1740.2829635854662,334.96055896565235,334.96055896565235,2320.3772847806217,239.25754211832304,191.40603369465842,{"$f":"SUM(D125:O125)","v":9629.0638858447219}]
[null,"Sur investissements et frais généraux",{"$f":"(C87+C88+C89+C90+C86)-(C87+C88+C89+C90+C86)/1.2","v":2003},{"$f":"((D107+D109+D111+D108)-(D107+D109+D111+D108)/1.2)","v":473.96535469575838},{"$f":"((E107+E109+E111+E108)-(E107+E109+E111+E108)/1.2)","v":443.96535469575838},455.96535469575838,485.96535469575838,431.96535469575838,431.96535469575838,419.96535469575838,425.96535469575838,419.96535469575838,437.96535469575838,431.96535469575838,419.96535469575838,{"$f":"SUM(C126:O126)","v":7282.5842563490969}]
[null,"Total TVA à récupérer",{"$f":"SUM(C124:C126)","v":5717.9999999999964},{"$f":"SUM(D125:D126)","v":2357.8028435522183},{"$f":"SUM(E125:E126)","v":1018.1834557797337},1173.7379810507275,1108.0349642033984,766.92591366141073,766.92591366141073,2160.2483182812248,760.92591366141073,754.92591366141073,2758.3426394763801,671.22289681408142,611.37138839041677,{"$f":"SUM(C127:O127)","v":20626.648142193819}]
[]
[null,"Solde TVA",{"$f":"C120-C127","v":-5717.9999999999964},{"$f":"D121-D127","v":-313.80284355221806},{"$f":"E121-E127","v":295.81654422026634},432.26201894927249,1227.9650357966016,255.07408633858938,255.07408633858938,-1430.2483182812248,115.07408633858927,-24.925913661410732,-1590.3426394763801,350.77710318591869,118.62861160958323]
[null,"Cumul",null,{"$f":"C129+D129","v":-6031.8028435522147},{"$f":"D130+E129","v":-5735.9862993319484},{"$f":"E130+F129","v":-5303.7242803826757},{"$f":"F130+G129","v":-4075.7592445860741},{"$f":"G130+H129","v":-3820.6851582474847},{"$f":"H130+I129","v":-3565.6110719088952},null,{"$f":"J129+K129","v":-1315.1742319426355},{"$f":"K130+L129","v":-1340.1001456040462},{"$f":"L130+M129","v":-2930.4427850804263},{"$f":"M130+N129","v":-2579.6656818945075},{"$f":"O129","v":118.62861160958323},{"$f":"P121-P127","v":-6026.6481421938188}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bilan année 1","Actif",null,null,"Passif"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brut","Amortissements","Net",null,"Net"]
[null,"Suivi mensuel de la trésorerie","Solde investissements",{"$f":"D94","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août",null,null,"Fonds de commerce",{"$f":"'Bilan ouverture'!C4","v":10000},null,{"$f":"S133","v":10000},"Capital",{"$f":"'Bilan ouverture'!E4+'Bilan ouverture'!E5","v":3000}]
[null,"Solde de trésorie",{"$f":"C68-C117-C65","v":15042},{"$f":"D80-D117","v":40002.406755637341},{"$f":"E80-E117","v":-7266.6367226235343},-3388.5036531389414,5639.9010251994696,-11605.777258989794,-6204.4083184639476,-3305.7043032581532,-9416.7892627828624,-1489.8668502135151,1824.2956967418468,-9633.4714069753099,-3325.6247188304642,null,null,"Frais d'établissement ",{"$f":"'Bilan ouverture'!C5","v":1500},{"$f":"Amortissements!E4","v":500},{"$f":"S134-T134","v":1000},"Report à nouveau",null,null,null,"Dettes\n fournisseurs à reporter au bilan","N+1"]
[null,"Cumul de la trésorerie",null,{"$f":"C134+D134","v":55044.406755637341},{"$f":"D135+E134","v":47777.770033013803},44389.266379874862,50029.167405074331,38423.390146084537,32218.981827620592,28913.277524362438,19496.488261579576,18006.621411366061,19830.917108107908,10197.445701132598,6871.8209823021334,null,null,"Travaux et mises aux normes",{"$f":"'Bilan ouverture'!C6","v":1250},{"$f":"Amortissements!E5","v":125},{"$f":"S135-T135","v":1125},"Résultat net",{"$f":"P19-AA146","v":20353.726424686363},null,null,"Dettes achats librairie",{"$f":"(P46*1.055)-P99","v":7726.700404858304}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction",{"$f":"'Bilan ouverture'!C7","v":0},{"$f":"Amortissements!E6","v":0},0,"Subventions d'investissements",{"$f":"'Bilan ouverture'!J24","v":8000},null,null,"Dettes augmentation stock librairie",{"$f":"(P50*1.055)-P103","v":534.21000391798316}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aménagement",{"$f":"'Bilan ouverture'!C8","v":2000},{"$f":"Amortissements!E7","v":200},1800,"Emprunts bancaires",{"$f":"'Bilan ouverture'!$L$90","v":17286.386605742671},null,null,"Dettes autres produits",{"$f":"(P47*1.2)-P100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobilier",{"$f":"'Bilan ouverture'!C9","v":0},{"$f":"Amortissements!E8","v":0},0,"Emprunts taux 0 %",{"$f":"'Bilan ouverture'!Z90","v":8000},null,null,"Dettes augmentation stock autres produits",{"$f":"(P51*1.2)-P104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Informatique",{"$f":"'Bilan ouverture'!C10","v":6765},{"$f":"Amortissements!E9","v":2255},4510,"Comptes courants associés",{"$f":"'Bilan ouverture'!E6","v":2000},null,null,"Total Dettes fou",{"$f":"SUM(AA135:AA138)","v":8260.9104087762862}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caution financière",{"$f":"'Bilan ouverture'!C11","v":0},null,{"$f":"S140","v":0},"Comptes courant Adelc",{"$f":"'Bilan ouverture'!$S$90","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caution bail",{"$f":"'Bilan ouverture'!C12","v":1440},null,1440,null,null,null,null,"Échelonnement des dettes","1er mois N+1","2ème mois N+1"]
[null,"Suivi et évolution du stock",{"$f":"C119","v":"Démarrage"},"Septembre","Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août",null,null,"Stock librairie",{"$f":"'Outil de simulation'!G28","v":35626.224369857635},null,35626.224369857635,"Fournisseurs",{"$f":"AA139","v":8260.9104087762862},null,null,"Dettes librairie",{"$f":"N46*1.055","v":4292.611336032388},{"$f":"O46*1.055","v":3434.0890688259101}]
[null,"ventes",null,{"$f":"D5-(D5*$C$7)","v":14752.712550607288},9483.8866396761114,11591.417004048584,16860.242914979754,7376.356275303644,7376.356275303644,5268.8259109311739,6322.5910931174085,5268.8259109311739,8430.1214574898768,7376.356275303644,5268.8259109311739,null,null,"Stock autres produits",{"$f":"'Outil de simulation'!P28","v":10544.565217391308},null,10544.565217391308,null,null,null,null,"Dettes achats stocks",{"$f":"N50*1.055","v":296.78333550999025},{"$f":"O50*1.055","v":237.42666840799217}]
[null,"Achats",null,{"$f":"D58","v":15096.116398180691},10440.329110617733,13050.411388272167,11310.356536502544,6090.1919811936787,6090.1919811936787,12486.034120526259,6090.1919811936787,6090.1919811936787,16648.04549403501,4350.1371294240553,3480.109703539244,null,null,"Stock restauration café",{"$f":"'Outil de simulation'!R28","v":0},null,0,"TVA  à payer",{"$f":"IF(O130>0,O130,0)","v":118.62861160958323},null,null,"Dettes autres produits",{"$f":"O47*1.2","v":0}]
[null,"Évolution du stock",{"$f":"(C95/1.055)+(C96/1.2)+(C97/1.1)","v":40325},{"$f":"C145-D143+D144","v":40668.403847573405},{"$f":"D145-E143+E144","v":41624.846318515025},{"$f":"E145-F143+F144","v":43083.840702738606},37533.954324261395,36247.790030151431,34961.62573604146,42178.83394563655,41946.434833712818,42767.800903975323,50985.724940520457,47959.505794640863,46170.789587248932,null,null,"TVA à récupérer",{"$f":"IF(O130<0,O130*-1,0)","v":0},null,{"$f":"S145","v":0},"IS solde",{"$f":"AA147","v":897.958518736163},null,null,"Dettes achats stocks autres produits",{"$f":"O51*1.2","v":0}]
[null,"Coût des ventes",{"$f":"'Outil de simulation'!T30","v":105376.51821862347},"Notes - La rotation calculée ici à partir de la saisonnalité du stock est bien plus précise que la rotation calculée à partir du stock moyen. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Disponibilités",{"$f":"IF(O135>0,O135,\"\")","v":6871.8209823021334},null,6871.8209823021334,"Découvert",{"$f":"IF(O135<0,O135*-1,\"\")","v":""},null,null,"Calcul de l'IS",{"$f":"IF(P19<0,0,P19*C115)","v":3591.834074944652}]
[null,"Stock Moyen",{"$f":"SUM(C145:O145)/13","v":42034.9654588474},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(S133:S146)","v":75997.610569551078},{"$f":"SUM(T133:T145)","v":3080},{"$f":"SUM(U133:U146)","v":72917.610569551078},null,{"$f":"SUM(W133:W146)","v":72917.610569551078},null,null,"Dettes IS au bilan",{"$f":"M115","v":897.958518736163}]
[null,"Rotation",{"$f":"C146/C147","v":2.5068777164046443}]
[null,"Rotation en J",{"$f":"365/C148","v":145.59944332804625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Écart",null,null,null,"Écart",{"$f":"W147-U147","v":0}]

{"sheet":"Trésorerie année 2","index":5,"n_rows":125,"n_cols":27,"rows_kept":125,"cut":false,"hidden":false,"merged":[[106,21,106,22],[106,18,106,20],[19,1,19,14],[39,1,42,1]]}
[]
[null,"Formation du résultat en fonction de la saisonnalité","%",{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"Saisonnalité des ventes",null,{"$f":"'Outil de simulation'!C117","v":0.14000000000000001},{"$f":"'Outil de simulation'!D117","v":0.09},{"$f":"'Outil de simulation'!E117","v":0.11},{"$f":"'Outil de simulation'!F117","v":0.16},{"$f":"'Outil de simulation'!G117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I117","v":0.05},{"$f":"'Outil de simulation'!J117","v":0.06},{"$f":"'Outil de simulation'!K117","v":0.05},{"$f":"'Outil de simulation'!L117","v":0.08},{"$f":"'Outil de simulation'!M117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N117","v":0.05},{"$f":"SUM(D3:O3)","v":1.0000000000000002}]
[]
[null,"Ventes brutes",null,{"$f":"$P$5*D3","v":25714.655870445345},16530.850202429148,20204.372469635626,29388.178137651823,12857.327935222673,12857.327935222673,9183.8056680161953,11020.566801619432,9183.8056680161953,14694.089068825911,12857.327935222673,9183.8056680161953,{"$f":"'Outil de simulation'!T51","v":183676.11336032388}]
[null,"CA global",null,{"$f":"$P$6*D3","v":25480.000000000004},16380,20020,29120,12740.000000000002,12740.000000000002,9100,10920,9100,14560,12740.000000000002,9100,{"$f":"'Outil de simulation'!T53","v":182000}]
[null,"Marge commerciale",{"$f":"'Outil de simulation'!V61","v":0.35437312643272795},{"$f":"D5*$C$7","v":9112.5829959514176},5858.0890688259105,7159.8866396761132,10414.380566801621,4556.2914979757088,4556.2914979757088,3254.4939271255066,3905.3927125506075,3254.4939271255066,5207.1902834008106,4556.2914979757088,3254.4939271255066,{"$f":"'Outil de simulation'!T61","v":65089.878542510123}]
[null,"Marge brute",null,{"$f":"$P$8*D3","v":8877.9271255060739},{"$f":"$P$8*E3","v":5707.2388663967613},6975.5141700404865,10146.202429149798,{"$f":"$P$8*H3","v":4438.963562753037},4438.963562753037,3170.6882591093122,3804.8259109311743,3170.6882591093122,5073.1012145748991,4438.963562753037,3170.6882591093122,{"$f":"'Outil de simulation'!T60","v":63413.765182186238}]
[null,"Produits exceptionnels sub investissements",null,{"$f":"$P$9/12","v":166.66666666666666},{"$f":"$P$9/12","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,{"$f":"'Bilan ouverture'!K25","v":2000}]
[null,"Fournitures \nconsommables",null,{"$f":"$P$10*D3","v":428.40000000000003},{"$f":"$P$10*E3","v":275.39999999999998},336.6,489.6,214.20000000000002,214.20000000000002,153,183.6,153,244.8,214.20000000000002,153,{"$f":"'Compte de résultats 3 ans'!J13","v":3060}]
[null,"Loyer",null,{"$f":"$P$11/12","v":720},720,720,720,720,720,720,720,720,720,720,720,{"$f":"'Compte de résultats 3 ans'!J20","v":8640}]
[null,"Charges externes",null,{"$f":"$P$12/12","v":1087.0650000000003},1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,1087.0650000000003,{"$f":"'Compte de résultats 3 ans'!J19-'Compte de résultats 3 ans'!J20","v":13044.780000000002}]
[null,"Personnel (salaires et charges)",null,{"$f":"$P$13/12","v":1818},1818,1818,1818,1818,1818,1818,1818,1818,1818,1818,1818,{"$f":"'Compte de résultats 3 ans'!J55","v":21816}]
[null,"Amortissements",null,{"$f":"$P$14/12","v":256.66666666666669},256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,{"$f":"'Compte de résultats 3 ans'!J56","v":3080}]
[null,"Impôts",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P15","v":1632},null,{"$f":"'Compte de résultats 3 ans'!J54","v":1632}]
[null,"Financier",null,{"$f":"$P$16/12","v":22.702392546176199},22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,22.702392546176199,{"$f":"'Compte de résultats 3 ans'!J57","v":272.42871055411439}]
[]
[null,"Résultat net avant IS",null,{"$f":"D8+D9-SUM(D10:D16)","v":4711.7597329598966},{"$f":"E8+E9-SUM(E10:E16)","v":1694.0714738505849},{"$f":"F8+F9-SUM(F10:F16)","v":2901.1467774943103},5918.8350366036211,486.99617020686128,486.99617020686128,-720.07913343686459,-116.54148161500234,-720.07913343686459,1090.5338220287231,-1145.0038297931396,{"$f":"O8-SUM(O10:O16)","v":-886.74580010353111},{"$f":"P8-SUM(P10:P16)+P9","v":13868.556471632124}]
[null,"Résultat net avant IS cumulés",null,null,{"$f":"D18+E18","v":6405.8312068104815},{"$f":"E19+F18","v":9306.9779843047909},15225.813020908412,15712.809191115273,16199.805361322135,15479.72622788527,15363.184746270268,14643.105612833404,15733.639434862127,14588.635605068986,13701.889804965456]
[null,"CAF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P14+P18-Z122","v":14868.273000887306}]
[]
[null,"Répartition des ventes en fonction de la saisonnalité",null,{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"Librairie"]
[null,"Répartition du CA comptant",null,{"$f":"$P$24*D25","v":19320.000000000004},12420,15180,22080,9660.0000000000018,9660.0000000000018,6900,8280,6900,11040,9660.0000000000018,6900,{"$f":"'Outil de simulation'!C53","v":138000}]
[null,"Saisonnalité Librairie comptant",null,{"$f":"'Outil de simulation'!C117","v":0.14000000000000001},{"$f":"'Outil de simulation'!D117","v":0.09},{"$f":"'Outil de simulation'!E117","v":0.11},{"$f":"'Outil de simulation'!F117","v":0.16},{"$f":"'Outil de simulation'!G117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I117","v":0.05},{"$f":"'Outil de simulation'!J117","v":0.06},{"$f":"'Outil de simulation'!K117","v":0.05},{"$f":"'Outil de simulation'!L117","v":0.08},{"$f":"'Outil de simulation'!M117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N117","v":0.05},{"$f":"SUM(D25:O25)","v":1.0000000000000002}]
[null,"Répartition du CA livre à terme",null,{"$f":"$P$26*D27","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!E53","v":0}]
[null,"Saisonnalité facturation librairie à terme",null,{"$f":"'Outil de simulation'!C119","v":0.1},{"$f":"'Outil de simulation'!D119","v":0.1},{"$f":"'Outil de simulation'!E119","v":0.1},{"$f":"'Outil de simulation'!F119","v":0.1},{"$f":"'Outil de simulation'!G119","v":0.1},{"$f":"'Outil de simulation'!H119","v":0.1},{"$f":"'Outil de simulation'!I119","v":0.1},{"$f":"'Outil de simulation'!J119","v":0.1},{"$f":"'Outil de simulation'!K119","v":0.1},{"$f":"'Outil de simulation'!L119","v":0.1},{"$f":"'Outil de simulation'!M119","v":0},{"$f":"'Outil de simulation'!N119","v":0},{"$f":"SUM(D27:O27)","v":0.99999999999999989}]
[null,"Total librairie (TVA 5,5 %)",null,{"$f":"D24+D26","v":19320.000000000004},{"$f":"E24+E26","v":12420},15180,22080,9660.0000000000018,9660.0000000000018,6900,8280,6900,11040,9660.0000000000018,{"$f":"O24+O26","v":6900},{"$f":"P24+P26","v":138000}]
[null,"Autres produits"]
[null,"Répartition du CA des ventes autres produits (TVA 20 %)",null,{"$f":"$P$30*D31","v":6160.0000000000009},3960,4840,7040,3080.0000000000005,3080.0000000000005,2200,2640,2200,3520,3080.0000000000005,2200,{"$f":"'Outil de simulation'!P53","v":44000}]
[null,"Saisonnalité des ventes autres produits",null,{"$f":"'Outil de simulation'!C120","v":0.14000000000000001},{"$f":"'Outil de simulation'!D120","v":0.09},{"$f":"'Outil de simulation'!E120","v":0.11},{"$f":"'Outil de simulation'!F120","v":0.16},{"$f":"'Outil de simulation'!G120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I120","v":0.05},{"$f":"'Outil de simulation'!J120","v":0.06},{"$f":"'Outil de simulation'!K120","v":0.05},{"$f":"'Outil de simulation'!L120","v":0.08},{"$f":"'Outil de simulation'!M120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N120","v":0.05}]
[null,"Total CA autres produits (TVA 20 %)",null,{"$f":"D30","v":6160.0000000000009},{"$f":"E30","v":3960},4840,7040,3080.0000000000005,3080.0000000000005,2200,2640,2200,3520,3080.0000000000005,2200,{"$f":"P30","v":44000}]
[null,"Restaurant/Café"]
[null,"Répartition des ventes restaurant café (TVA 10 %)",null,{"$f":"$P$34*D35","v":0},{"$f":"$P$34*E35","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R53","v":0}]
[null,"Saisonnalité des ventes restaurant café",null,{"$f":"'Outil de simulation'!C122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!D122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!E122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!F122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!G122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!H122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!I122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!J122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!K122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!L122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!M122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!N122","v":8.3333333333333343E-2},{"$f":"SUM(D35:O35)","v":1.0000000000000002}]
[null,"Total Restaurant café (TVA 10 % majoritaire)",null,{"$f":"D34","v":0},{"$f":"E34","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D36:O36)","v":0}]
[]
[null,"Total CA",null,{"$f":"D28+D32+D36","v":25480.000000000004},{"$f":"E28+E32+E36","v":16380},20020,29120,12740.000000000002,12740.000000000002,9100,10920,9100,14560,12740.000000000002,9100,{"$f":"P28+P32+P36","v":182000}]
[]
[null,"Répartition des achats en fonction de la saisonnalité","Saisons",{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,null,"Librairie",{"$f":"'Outil de simulation'!C118","v":0.09},{"$f":"'Outil de simulation'!D118","v":0.12},{"$f":"'Outil de simulation'!E118","v":0.15},{"$f":"'Outil de simulation'!F118","v":0.13},{"$f":"'Outil de simulation'!G118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I118","v":0.06},{"$f":"'Outil de simulation'!J118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!K118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!L118","v":0.08},{"$f":"'Outil de simulation'!M118","v":0.05},{"$f":"'Outil de simulation'!N118","v":0.04},{"$f":"SUM(D41:O41)","v":1.0000000000000002}]
[null,null,"Autres produits",{"$f":"'Outil de simulation'!C121","v":0.3},{"$f":"'Outil de simulation'!D121","v":0},{"$f":"'Outil de simulation'!E121","v":0},{"$f":"'Outil de simulation'!F121","v":0},{"$f":"'Outil de simulation'!G121","v":0},{"$f":"'Outil de simulation'!H121","v":0},{"$f":"'Outil de simulation'!I121","v":0.3},{"$f":"'Outil de simulation'!J121","v":0},{"$f":"'Outil de simulation'!K121","v":0},{"$f":"'Outil de simulation'!L121","v":0.4},{"$f":"'Outil de simulation'!M121","v":0},{"$f":"'Outil de simulation'!N121","v":0},{"$f":"SUM(D42:O42)","v":1}]
[null,null,"Restauration café",{"$f":"'Outil de simulation'!C123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!D123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!E123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!F123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!G123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!H123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!I123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!J123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!K123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!L123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!M123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!N123","v":8.3333333333333343E-2},{"$f":"SUM(D43:O43)","v":1.0000000000000002}]
[null,"Coût des ventes"]
[null,"Librairie",null,{"$f":"$P$45*D41","v":8296.7611336032387},11062.34817813765,13827.935222672064,11984.21052631579,6453.0364372469639,6453.0364372469639,5531.1740890688252,6453.0364372469639,6453.0364372469639,7374.8987854251009,4609.3117408906883,3687.4493927125504,{"$f":"'Outil de simulation'!G59","v":92186.234817813762}]
[null,"Autres produits",null,{"$f":"$P$46*D42","v":7920},0,0,{"$f":"$P$46*G42","v":0},0,0,7920,0,0,10560,0,0,{"$f":"'Outil de simulation'!P59","v":26400}]
[null,"Restauration café",null,{"$f":"$P$47*D43","v":0},{"$f":"$P$47*E43","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R59","v":0}]
[null,"Augmentation stock"]
[null,"Augmentation stock librairie",null,{"$f":"$P$49/12","v":0},{"$f":"$P$49/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!G57-'Outil de simulation'!G55","v":0}]
[null,"Augmentation stock autres produits",null,{"$f":"$P$50/12","v":0},{"$f":"$P$50/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!P57-'Outil de simulation'!P55","v":0}]
[null,"Augmentation stock restauration café",null,{"$f":"$P$51/12","v":0},{"$f":"$P$51/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R57-'Outil de simulation'!R55","v":0}]
[null,"Total des achats"]
[null,"Total achats librairie",null,{"$f":"D45+D49","v":8296.7611336032387},11062.34817813765,13827.935222672064,11984.21052631579,6453.0364372469639,6453.0364372469639,5531.1740890688252,6453.0364372469639,6453.0364372469639,7374.8987854251009,4609.3117408906883,3687.4493927125504,92186.234817813762]
[null,"Total achats autres produits",null,{"$f":"D46+D50","v":7920},0,0,0,0,0,7920,0,0,10560,0,0,26400]
[null,"Total achats restauration café",null,{"$f":"D47+D51","v":0},{"$f":"E47+E51","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P47+P51","v":0}]
[]
[null,"Total achats",null,{"$f":"SUM(D53:D55)","v":16216.761133603239},{"$f":"SUM(E53:E55)","v":11062.34817813765},13827.935222672064,11984.21052631579,6453.0364372469639,6453.0364372469639,13451.174089068825,6453.0364372469639,6453.0364372469639,17934.898785425103,4609.3117408906883,3687.4493927125504,{"$f":"SUM(P53:P55)","v":118586.23481781376}]
[]
[null,"Trésorerie entrante",null,{"$f":"D40","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[null,"Répartition du CA"]
[null,"CA TTC librairie",null,{"$f":"D28*1.055","v":20382.600000000002},{"$f":"E28*1.055","v":13103.099999999999},16014.9,23294.399999999998,10191.300000000001,10191.300000000001,7279.5,8735.4,7279.5,11647.199999999999,10191.300000000001,7279.5,{"$f":"SUM(D61:O61)","v":145590}]
[null,"CA TTC autres produits",null,{"$f":"D32*1.2","v":7392.0000000000009},4752,5808,8448,3696.0000000000005,3696.0000000000005,2640,3168,2640,4224,3696.0000000000005,2640,52800]
[null,"CA TTC restauration café",null,{"$f":"D36*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total CA TTC",null,{"$f":"D61+D62+D63","v":27774.600000000002},{"$f":"E61+E62+E63","v":17855.099999999999},21822.9,31742.399999999998,13887.300000000001,13887.300000000001,9919.5,11903.4,9919.5,15871.199999999999,13887.300000000001,9919.5,198390]
[]
[null,"TVA à récupérer N-1",null,{"$f":"'Trésorerie année 1'!U145","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D66:O66)","v":0}]
[]
[null,"Récupération TVA",null,{"$f":"IF(D112>0,D112,0)","v":78.726729247829553},{"$f":"IF(E112>0,E112,0)","v":0},0,0,0,0,1465.2680534080209,0,0,1621.3329117076157,0,0,3165.3276943634664]
[]
[null,"Total des entrées d'argent dans la strcuture",null,{"$f":"D64+D66+D68","v":27853.32672924783},{"$f":"E64+E68","v":17855.099999999999},21822.9,31742.399999999998,13887.300000000001,13887.300000000001,11384.768053408021,11903.4,9919.5,17492.532911707614,13887.300000000001,9919.5,{"$f":"P64+P68+P66","v":201555.32769436346}]
[]
[null,"Trésorerie sortante",null,{"$f":"D59","v":"Septembre"},{"$f":"E59","v":"Octobre"},"Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[null,"Stock Librairie TTC à payer",{"$f":"'Trésorerie année 1'!C95-'Trésorerie année 1'!P95","v":0},{"$f":"C73/12","v":0},{"$f":"D73/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D73:O73)","v":0}]
[null,"Stock autres produits TTC à payer",{"$f":"'Trésorerie année 1'!C96-'Trésorerie année 1'!P96","v":0},{"$f":"C74/12","v":0},{"$f":"D74/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D74:O74)","v":0}]
[null,"Stock restauration café TTC à payer",{"$f":"'Trésorerie année 1'!C97-'Trésorerie année 1'!P97","v":0},{"$f":"C75/12","v":0},{"$f":"D75/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D75:O75)","v":0}]
[]
[null,"Achats librairie TTC (en bleu report de la dette N-1)",null,{"$f":"'Trésorerie année 1'!AA142","v":4292.611336032388},{"$f":"'Trésorerie année 1'!AB142","v":3434.0890688259101},{"$f":"D45*1.055","v":8753.0829959514158},11670.77732793522,14588.471659919027,12643.342105263158,6807.9534412955463,6807.9534412955463,5835.3886639676102,6807.9534412955463,6807.9534412955463,7780.5182186234806,{"$f":"SUM(D77:O77)","v":96230.095141700367}]
[null,"Achats autres produits TTC (en bleu report de la dette N-1)",null,{"$f":"'Trésorerie année 1'!AA144","v":0},{"$f":"D46*1.2","v":9504},0,0,0,0,0,9504,0,0,12672,0,31680]
[null,"Achats restauration café TTC",null,{"$f":"D47*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Augmentation stock librairie TTC","échéancé",{"$f":"'Trésorerie année 1'!AA143","v":296.78333550999025},{"$f":"'Trésorerie année 1'!AB143","v":237.42666840799217},{"$f":"D49*1.055","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D81:O81)","v":534.21000391798248}]
[null,"Augmentation stock autres produits TTC","échéancé",{"$f":"'Trésorerie année 1'!AA145","v":0},{"$f":"D50*1.2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D82:O82)","v":0}]
[null,"Augmentation stock restauration café TTC",null,{"$f":"D51*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D83:O83)","v":0}]
[]
[null,"Fournitures \nconsommables TTC",null,{"$f":"D10*1.2","v":514.08000000000004},330.47999999999996,403.92,587.52,257.04000000000002,257.04000000000002,183.6,220.32,183.6,293.76,257.04000000000002,183.6,{"$f":"SUM(D85:O85)","v":3671.9999999999995}]
[null,"Loyer TTC",null,{"$f":"D11*1.2","v":864},864,864,864,864,864,864,864,864,864,864,864,{"$f":"SUM(D86:O86)","v":10368}]
[null,"Services\nextérieurs TTC",null,{"$f":"D12*1.2","v":1304.4780000000003},1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,1304.4780000000003,{"$f":"SUM(D87:O87)","v":15653.736000000006}]
[null,"Personnel",null,{"$f":"D13","v":1818},1818,1818,1818,1818,1818,1818,1818,1818,1818,1818,1818,{"$f":"SUM(D88:O88)","v":21816}]
[null,"Financier TTC",null,{"$f":"D16*1.2","v":27.242871055411438},27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,27.242871055411438,{"$f":"SUM(D89:O89)","v":326.91445266493724}]
[null,"Impôts",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P90","v":1632},null,{"$f":"P15","v":1632}]
[null,"Remboursement emprunts taux 0 %",null,{"$f":"$P$91/12","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,{"$f":"'Bilan ouverture'!Y91","v":2000}]
[null,"Remboursement\nemprunts",null,{"$f":"$P$92/12","v":230.00883045406079},230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,230.00883045406079,{"$f":"'Bilan ouverture'!J91","v":2760.1059654487294}]
[null,"IS",{"$f":"'Compte de résultats 3 ans'!I62","v":0.15},{"$f":"'Trésorerie année 1'!W145","v":897.958518736163},null,null,{"$f":"$Z$122/4","v":520.07086768620468},null,null,null,{"$f":"$Z$122/4","v":520.07086768620468},null,null,null,{"$f":"$Z$122/4","v":520.07086768620468},{"$f":"SUM(D93:O93)","v":2458.1711217947768}]
[null,"Solde TVA redue",null,{"$f":"IF(D112<0,D112*-1,0)","v":0},{"$f":"IF(E112<0,E112*-1,0)","v":445.63737169319415},{"$f":"IF(F112<0,F112*-1,0)","v":609.09008424380136},1499.3949425433966,383.58951744218189,383.58951744218189,0,225.8095174421818,68.029517442181714,0,484.99437574177705,220.13680489157446,{"$f":"SUM(D94:O94)","v":4320.2716488824717}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D95:O95)","v":0}]
[null,"Total sorties",null,{"$f":"SUM(D73:D95)","v":10411.829558454679},{"$f":"SUM(E73:E95)","v":18362.029477103239},{"$f":"SUM(F73:F95)","v":14176.489448371358},18688.159506340966,19639.497545537353,17694.367990881485,11401.949809471686,21688.550194600077,10497.41454958593,{"$f":"SUM(M73:M95)","v":11512.109809471685},26264.384185213468,{"$f":"SUM(O73:O95)","v":13114.722259377399},{"$f":"SUM(D96:O96)","v":193451.50433440931}]
[]
[]
[null,"Suivi mensuel de trésorerie","Solde N-1",{"$f":"D72","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août"]
[null,"Solde de trésorerie",{"$f":"'Trésorerie année 1'!S146","v":6871.8209823021334},{"$f":"D70-D96","v":17441.497170793151},{"$f":"E70-E96","v":-506.92947710324006},7646.4105516286436,13054.240493659032,-5752.1975455373522,-3807.0679908814836,-17.181756063664579,-9785.1501946000772,-577.91454958593022,5980.423102235929,-12377.084185213467,-3195.2222593773986]
[null,"Cumum de la trésorerie",null,{"$f":"C100+D100","v":24313.318153095286},{"$f":"D101+E100","v":23806.388675992046},{"$f":"E101+F100","v":31452.79922762069},{"$f":"F101+G100","v":44507.039721279725},{"$f":"G101+H100","v":38754.842175742371},34947.774184860886,34930.592428797223,25145.442234197144,24567.527684611214,30547.950786847141,18170.866601633672,{"$f":"N101+O100","v":14975.644342256273}]
[]
[]
[null,"Tableau de répartition de la TVA",null,{"$f":"D22","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[null,"TVA à payer",null,{"$f":"(D28*5.5%)+(D32*20%)+(D36*10%)+C106","v":2413.2286116095838},{"$f":"(E28*5.5%)+(E32*20%)+(E36*10%)","v":1475.1},1802.9,2622.4,1147.3000000000002,1147.3000000000002,819.5,983.4,819.5,1311.2,1147.3000000000002,819.5,{"$f":"SUM(D105:O105)","v":16508.628611609583}]
[null,"Solde N-1",{"$f":"IF('Trésorerie année 1'!W144>0,'Trésorerie année 1'!W144,0)","v":118.62861160958323}]
[null,"TVA à récupérer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bilan année 2","Actif",null,null,"Passif"]
[null,"Solde N-1",{"$f":"IF('Trésorerie année 1'!S145>0,'Trésorerie année 1'!S145,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brut","Amortissements","Net",null,"Net"]
[null,"Sur achats de marchandses et augmentation du stock",null,{"$f":"D53*5.5%+D54*20%+D55*10%","v":2040.321862348178},{"$f":"E53*5.5%+E54*20%+E55*10%","v":608.42914979757074},760.53643724696349,659.13157894736844,354.91700404858301,354.91700404858301,1888.2145748987855,354.91700404858301,354.91700404858301,2517.6194331983806,253.51214574898785,202.80971659919027,{"$f":"SUM(D109:O109)","v":10350.242914979757},null,"Fonds de commerce",{"$f":"'Bilan ouverture'!C4","v":10000},null,{"$f":"S109","v":10000},"Capital",{"$f":"'Trésorerie année 1'!W133","v":3000}]
[null,"Sur frais généraux",null,{"$f":"((D85+D87+D89+D86)-(D85+D87+D89+D86)/1.2)","v":451.63347850923537},{"$f":"((E85+E87+E89+E86)-(E85+E87+E89+E86)/1.2)","v":421.03347850923501},433.27347850923525,463.87347850923516,408.79347850923523,408.79347850923523,396.55347850923522,402.67347850923511,396.55347850923522,414.91347850923512,408.79347850923523,396.55347850923522,{"$f":"SUM(C110:O110)","v":5003.441742110821},null,"Frais d'établissement SARL",{"$f":"'Trésorerie année 1'!S134","v":1500},{"$f":"Amortissements!E4+Amortissements!F4","v":1000},{"$f":"S110-T110","v":500},"Report à nouveau",{"$f":"'Trésorerie année 1'!W135","v":20353.726424686363}]
[null,"Total TVA à récupérer",null,{"$f":"SUM(D107:D110)","v":2491.9553408574134},{"$f":"SUM(E106:E110)","v":1029.4626283068058},1193.8099157561987,1123.0050574566035,763.7104825578183,763.7104825578183,2284.7680534080209,757.59048255781818,751.47048255781829,2932.5329117076158,662.30562425822313,599.36319510842554,{"$f":"SUM(C111:O111)","v":15353.684657090578},null,"Travaux et mises aux normes",{"$f":"'Trésorerie année 1'!S135","v":1250},{"$f":"Amortissements!E5+Amortissements!F5","v":250},1000,"Résultat net",{"$f":"P18-Z122","v":11788.273000887306}]
[null,"Solde TVA",{"$f":"C108","v":0},{"$f":"D111-D105","v":78.726729247829553},{"$f":"E111-E105","v":-445.63737169319415},{"$f":"F111-F105","v":-609.09008424380136},-1499.3949425433966,-383.58951744218189,-383.58951744218189,1465.2680534080209,-225.8095174421818,-68.029517442181714,1621.3329117076157,-484.99437574177705,-220.13680489157446,{"$f":"P105-P111-C112","v":1154.9439545190053},null,"Construction",{"$f":"'Trésorerie année 1'!S136","v":0},{"$f":"Amortissements!E6+Amortissements!F6","v":0},0,"Subventions d'investissements",{"$f":"'Bilan ouverture'!K24","v":6000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aménagement",{"$f":"'Trésorerie année 1'!S137","v":2000},{"$f":"Amortissements!E7+Amortissements!F7","v":400},1600,"Emprunts bancaires",{"$f":"'Bilan ouverture'!L91","v":14526.280640293942}]
[null,"Cumul",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobilier",{"$f":"'Trésorerie année 1'!S138","v":0},{"$f":"Amortissements!E8+Amortissements!F8","v":0},0,"Emprunts taux 0 %",{"$f":"'Bilan ouverture'!Z91","v":6000},null,"Dettes\n fournisseurs à reporter au bilan","N+1","2ème mois N+1"]
[null,"Suivi et évolution du stock",null,{"$f":"D104","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août",null,null,"Informatique",{"$f":"'Trésorerie année 1'!S139","v":6765},{"$f":"Amortissements!E9+Amortissements!F9","v":4510},2255,"Comptes courants associés",{"$f":"'Bilan ouverture'!E6","v":2000},null,"Dettes achats librairie",{"$f":"N45*1.055","v":4862.8238866396759},{"$f":"O45*1.055","v":3890.2591093117403}]
[null,"ventes",null,{"$f":"D5-(D5*$C$7)","v":16602.072874493926},10672.761133603239,13044.485829959513,18973.797570850202,8301.036437246963,8301.036437246963,5929.3117408906892,7115.1740890688252,5929.3117408906892,9486.8987854251009,8301.036437246963,5929.3117408906892,null,null,"Caution financière",{"$f":"'Bilan ouverture'!C11","v":0},null,{"$f":"S116","v":0},"Comptes courant Adelc",{"$f":"'Bilan ouverture'!S91","v":5000},null,"Dettes augmentation stock librairie",{"$f":"N49*1.055","v":0},{"$f":"O49*1.055","v":0}]
[null,"Achats",null,{"$f":"D57","v":16216.761133603239},11062.34817813765,13827.935222672064,11984.21052631579,6453.0364372469639,6453.0364372469639,13451.174089068825,6453.0364372469639,6453.0364372469639,17934.898785425103,4609.3117408906883,3687.4493927125504,null,null,"Caution bail",{"$f":"'Bilan ouverture'!C12","v":1440},null,{"$f":"S117","v":1440},null,null,null,"Dettes autres produits",{"$f":"O46*1.2","v":0}]
[null,"Évolution du stock",{"$f":"'Trésorerie année 1'!O145","v":46170.789587248932},{"$f":"C118-D116+D117","v":45785.477846358248},{"$f":"D118-E116+E117","v":46175.064890892652},46958.514283605204,{"$f":"F118-G116+G117","v":39968.927239070792},{"$f":"G118-H116+H117","v":38120.927239070792},36272.927239070792,43794.789587248924,43132.651935427064,43656.376631783336,52104.376631783336,48412.651935427064,46170.789587248924,null,null,"Stock librairie",{"$f":"'Outil de simulation'!G57","v":35626.224369857635},null,{"$f":"S118","v":35626.224369857635},"Fournisseurs",{"$f":"AA119","v":8753.0829959514158},null,"Dettes augmentation stock autres produits",{"$f":"O50*1.2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock autres produits",{"$f":"'Outil de simulation'!P57","v":10544.565217391308},null,{"$f":"S119","v":10544.565217391308},null,null,null,"Total Dettes fou",null,{"$f":"Z115+AA115+AA117+AA116+Z116+Z117+Z118","v":8753.0829959514158}]
[null,"Cycle de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock restauration café",{"$f":"'Outil de simulation'!R57","v":0},null,{"$f":"S120","v":0},"TVA diverses"]
[null,"Stock Moyen",{"$f":"SUM(C118:O118)/13","v":44363.404971864307},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TVA diverses",null,null,null,"IS solde",{"$f":"Z123","v":520.07086768620468},null,"IS à reporter au bilan","1er mois N+1"]
[null,"Coût des ventes",{"$f":"'Outil de simulation'!T59","v":118586.23481781376},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disponibilités",{"$f":"IF(O101>0,O101,\"\")","v":14975.644342256273},null,{"$f":"S122","v":14975.644342256273},"Découvert",{"$f":"IF(O101<0,O101*-1,\"\")","v":""},null,"Calcul de l'IS",{"$f":"'Compte de résultats 3 ans'!J62","v":2080.2834707448187}]
[null,"Rotation",{"$f":"C122/C121","v":2.6730643171555988},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(S109:S122)","v":84101.43392950522},{"$f":"SUM(T109:T122)","v":6160},{"$f":"SUM(U109:U122)","v":77941.43392950522},"Total",{"$f":"SUM(W109:W122)","v":77941.43392950522},null,"Dettes IS au bilan",{"$f":"Z122/4","v":520.07086768620468}]
[null,"Rotation en J",{"$f":"365/C123","v":136.54740653169006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Écart",null,null,null,"Écart",{"$f":"W123-U123","v":0}]

{"sheet":"Trésorerie année 3","index":6,"n_rows":120,"n_cols":27,"rows_kept":120,"cut":false,"hidden":false,"merged":[[115,1,115,2],[101,18,101,20],[101,21,101,22],[19,1,19,14],[39,1,42,1]]}
[]
[null,"Formation du résultat en fonction de la saisonnalité",null,{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"Saisonnalité des ventes",null,{"$f":"'Outil de simulation'!C117","v":0.14000000000000001},{"$f":"'Outil de simulation'!D117","v":0.09},{"$f":"'Outil de simulation'!E117","v":0.11},{"$f":"'Outil de simulation'!F117","v":0.16},{"$f":"'Outil de simulation'!G117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I117","v":0.05},{"$f":"'Outil de simulation'!J117","v":0.06},{"$f":"'Outil de simulation'!K117","v":0.05},{"$f":"'Outil de simulation'!L117","v":0.08},{"$f":"'Outil de simulation'!M117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N117","v":0.05},{"$f":"SUM(D3:O3)","v":1.0000000000000002}]
[]
[null,"Ventes brutes",{"$f":"'Outil de simulation'!U89","v":0.35735479395365122},{"$f":"$P$5*D3","v":28591.539003539434},18380.275073703917,22464.780645638122,32676.044575473636,14295.769501769717,14295.769501769717,10211.263929835512,12253.516715802612,10211.263929835512,16338.022287736818,14295.769501769717,10211.263929835512,{"$f":"'Outil de simulation'!T80","v":204225.27859671021}]
[null,"CA global",null,{"$f":"$P$6*D3","v":28286.12145748988},18183.935222672066,22224.809716599189,32326.995951417004,14143.06072874494,14143.06072874494,10102.186234817815,12122.623481781377,10102.186234817815,16163.497975708502,14143.06072874494,10102.186234817815,{"$f":"'Outil de simulation'!T82","v":202043.72469635628}]
[null,"Marge commerciale",{"$f":"'Outil de simulation'!V90","v":0.36421959132559006},{"$f":"D5*$C$7","v":10413.598651238801},6694.4562757963704,8182.1132259733422,11901.255601415771,5206.7993256194004,5206.7993256194004,3719.1423754424286,4462.9708505309136,3719.1423754424286,5950.6278007078854,5206.7993256194004,3719.1423754424286,{"$f":"'Outil de simulation'!T90","v":74382.847508848572}]
[null,"Marge brute",{"$f":"'Outil de simulation'!U89","v":0.35735479395365122},{"$f":"$P$8*D3","v":10108.181105189249},6498.1164247645165,7942.1422969344094,11552.206977359141,5054.0905525946246,5054.0905525946246,3610.0646804247317,4332.0776165096777,3610.0646804247317,5776.1034886795705,5054.0905525946246,3610.0646804247317,{"$f":"'Outil de simulation'!T89","v":72201.293608494627}]
[null,"Produits exceptionnels sub investissements",null,{"$f":"$P$9/12","v":166.66666666666666},{"$f":"$P$9/12","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,2000]
[null,"Fournitures \nconsommables",null,{"$f":"$P$10*D3","v":436.96800000000002},280.90799999999996,343.33199999999999,499.392,218.48400000000001,218.48400000000001,156.06,187.27199999999999,156.06,249.696,218.48400000000001,156.06,{"$f":"'Compte de résultats 3 ans'!Q13","v":3121.2}]
[null,"Loyer",null,{"$f":"$P$11/12","v":720},720,720,720,720,720,720,720,720,720,720,720,{"$f":"'Compte de résultats 3 ans'!Q20","v":8640}]
[null,"Charges externes",null,{"$f":"$P$12/12","v":1109.1196333333337},1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,1109.1196333333337,{"$f":"'Compte de résultats 3 ans'!Q19-'Compte de résultats 3 ans'!Q20","v":13309.435600000004}]
[null,"Personnel (salaires et charges)",null,{"$f":"$P$13/12","v":1836.1799999999996},1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,{"$f":"'Compte de résultats 3 ans'!Q55","v":22034.159999999996}]
[null,"Amortissements",null,{"$f":"$P$14/12","v":256.66666666666669},256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,256.66666666666669,{"$f":"'Compte de résultats 3 ans'!Q56","v":3080}]
[null,"Impôts",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P15","v":1664.64},null,{"$f":"'Compte de résultats 3 ans'!Q54","v":1664.64}]
[null,"Financier",null,{"$f":"$P$16/12","v":18.76163151250547},18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,18.76163151250547,{"$f":"'Compte de résultats 3 ans'!Q57","v":225.13957815006563}]
[]
[null,"Résultat net avant IS",null,{"$f":"D8+D9-SUM(D10:D16)","v":5897.1518403434102},{"$f":"E8+E9-SUM(E10:E16)","v":2443.147159918678},3824.7490320885709,7278.7537125133022,1061.545287748786,1061.545287748786,-320.05658442110735,370.74435166383955,-320.05658442110735,1752.3462238337324,-603.09471225121433,-320.05658442110735,{"$f":"P8+P9-SUM(P10:P17)","v":22126.718430344561}]
[null,"Résultat net avant IS cumulés",null,null,{"$f":"D18+E18","v":8340.2990002620882},{"$f":"E19+F18","v":12165.04803235066},19443.801744863962,20505.34703261275,21566.892320361534,21246.835735940425,21617.580087604263,21297.523503183154,23049.869727016885,22446.77501476567,22126.718430344561]
[null,"CAF",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P14+P18-Z117","v":21887.710665792878}]
[]
[null,"Répartition des ventes en fonction de la saisonnalité",null,{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,"Librairie"]
[null,"Répartition du CA comptant",null,{"$f":"$P$24*D25","v":21510.12145748988},13827.935222672064,16900.809716599189,24582.995951417004,10755.06072874494,10755.06072874494,7682.1862348178147,9218.6234817813765,7682.1862348178147,12291.497975708502,10755.06072874494,7682.1862348178147,{"$f":"'Outil de simulation'!C82","v":153643.72469635628}]
[null,"Saisonnalité Librairie comptant",null,{"$f":"'Outil de simulation'!C117","v":0.14000000000000001},{"$f":"'Outil de simulation'!D117","v":0.09},{"$f":"'Outil de simulation'!E117","v":0.11},{"$f":"'Outil de simulation'!F117","v":0.16},{"$f":"'Outil de simulation'!G117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I117","v":0.05},{"$f":"'Outil de simulation'!J117","v":0.06},{"$f":"'Outil de simulation'!K117","v":0.05},{"$f":"'Outil de simulation'!L117","v":0.08},{"$f":"'Outil de simulation'!M117","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N117","v":0.05}]
[null,"Répartition du CA livre à terme",null,{"$f":"$P$26*D27","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!E82","v":0}]
[null,"Saisonnalité facturation librairie à terme",null,{"$f":"'Outil de simulation'!C119","v":0.1},{"$f":"'Outil de simulation'!D119","v":0.1},{"$f":"'Outil de simulation'!E119","v":0.1},{"$f":"'Outil de simulation'!F119","v":0.1},{"$f":"'Outil de simulation'!G119","v":0.1},{"$f":"'Outil de simulation'!H119","v":0.1},{"$f":"'Outil de simulation'!I119","v":0.1},{"$f":"'Outil de simulation'!J119","v":0.1},{"$f":"'Outil de simulation'!K119","v":0.1},{"$f":"'Outil de simulation'!L119","v":0.1},{"$f":"'Outil de simulation'!M119","v":0},{"$f":"'Outil de simulation'!N119","v":0}]
[null,"Total librairie (TVA 5,5 %)",null,{"$f":"D24+D26","v":21510.12145748988},13827.935222672064,16900.809716599189,24582.995951417004,10755.06072874494,10755.06072874494,7682.1862348178147,9218.6234817813765,7682.1862348178147,12291.497975708502,10755.06072874494,7682.1862348178147,153643.72469635628]
[null,"Autres produits"]
[null,"Répartition du CA des ventes autres produits (TVA 20 %)",null,{"$f":"$P$30*D31","v":6776.0000000000009},4356,5324,7744,3388.0000000000005,3388.0000000000005,2420,2904,2420,3872,3388.0000000000005,2420,{"$f":"'Outil de simulation'!P82","v":48400}]
[null,"Saisonnalité des ventes autres produits",null,{"$f":"'Outil de simulation'!C120","v":0.14000000000000001},{"$f":"'Outil de simulation'!D120","v":0.09},{"$f":"'Outil de simulation'!E120","v":0.11},{"$f":"'Outil de simulation'!F120","v":0.16},{"$f":"'Outil de simulation'!G120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I120","v":0.05},{"$f":"'Outil de simulation'!J120","v":0.06},{"$f":"'Outil de simulation'!K120","v":0.05},{"$f":"'Outil de simulation'!L120","v":0.08},{"$f":"'Outil de simulation'!M120","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!N120","v":0.05}]
[null,"Total CA autres produits (TVA 20 %)",null,{"$f":"D30","v":6776.0000000000009},{"$f":"E30","v":4356},5324,7744,3388.0000000000005,3388.0000000000005,2420,2904,2420,3872,3388.0000000000005,2420,48400]
[null,"Restaurant/Café"]
[null,"Répartition des ventes restaurant café (TVA 10 %)",null,{"$f":"$P$34*D35","v":0},{"$f":"$P$34*E35","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R82","v":0}]
[null,"Saisonnalité des ventes restaurant café",null,{"$f":"'Outil de simulation'!C122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!D122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!E122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!F122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!G122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!H122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!I122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!J122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!K122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!L122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!M122","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!N122","v":8.3333333333333343E-2},{"$f":"SUM(D35:O35)","v":1.0000000000000002}]
[null,"Total Restaurant café (TVA 10 % majoritaire)",null,{"$f":"D34","v":0},{"$f":"E34","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P34","v":0}]
[]
[null,"Total CA",null,{"$f":"D28+D32+D36","v":28286.12145748988},{"$f":"E28+E32+E36","v":18183.935222672066},22224.809716599189,32326.995951417004,14143.06072874494,14143.06072874494,10102.186234817815,12122.623481781377,10102.186234817815,16163.497975708502,14143.06072874494,10102.186234817815,{"$f":"P28+P32+P36","v":202043.72469635628}]
[]
[null,"Répartition des achats en fonction de la saisonnalité","Saisons",{"$f":"'Outil de simulation'!C116","v":"Septembre"},{"$f":"'Outil de simulation'!D116","v":"Octobre"},{"$f":"'Outil de simulation'!E116","v":"Novembre"},{"$f":"'Outil de simulation'!F116","v":"Décembre"},{"$f":"'Outil de simulation'!G116","v":"Janvier"},{"$f":"'Outil de simulation'!H116","v":"Février"},{"$f":"'Outil de simulation'!I116","v":"Mars"},{"$f":"'Outil de simulation'!J116","v":"Avril"},{"$f":"'Outil de simulation'!K116","v":"Mai"},{"$f":"'Outil de simulation'!L116","v":"Juin"},{"$f":"'Outil de simulation'!M116","v":"Juillet"},{"$f":"'Outil de simulation'!N116","v":"Août"},"Total"]
[null,null,"Librairie",{"$f":"'Outil de simulation'!C118","v":0.09},{"$f":"'Outil de simulation'!D118","v":0.12},{"$f":"'Outil de simulation'!E118","v":0.15},{"$f":"'Outil de simulation'!F118","v":0.13},{"$f":"'Outil de simulation'!G118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!H118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!I118","v":0.06},{"$f":"'Outil de simulation'!J118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!K118","v":7.0000000000000007E-2},{"$f":"'Outil de simulation'!L118","v":0.08},{"$f":"'Outil de simulation'!M118","v":0.05},{"$f":"'Outil de simulation'!N118","v":0.04},{"$f":"SUM(D41:O41)","v":1.0000000000000002}]
[null,null,"Autres produits",{"$f":"'Outil de simulation'!C121","v":0.3},{"$f":"'Outil de simulation'!D121","v":0},{"$f":"'Outil de simulation'!E121","v":0},{"$f":"'Outil de simulation'!F121","v":0},{"$f":"'Outil de simulation'!G121","v":0},{"$f":"'Outil de simulation'!H121","v":0},{"$f":"'Outil de simulation'!I121","v":0.3},{"$f":"'Outil de simulation'!J121","v":0},{"$f":"'Outil de simulation'!K121","v":0},{"$f":"'Outil de simulation'!L121","v":0.4},{"$f":"'Outil de simulation'!M121","v":0},{"$f":"'Outil de simulation'!N121","v":0},{"$f":"SUM(D42:O42)","v":1}]
[null,null,"Restauration café",{"$f":"'Outil de simulation'!C123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!D123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!E123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!F123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!G123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!H123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!I123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!J123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!K123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!L123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!M123","v":8.3333333333333343E-2},{"$f":"'Outil de simulation'!N123","v":8.3333333333333343E-2},{"$f":"SUM(D43:O43)","v":1.0000000000000002}]
[null,"Coût des ventes"]
[null,"Librairie",null,{"$f":"$P$45*D41","v":9115.7787979075474},12154.371730543397,15192.964663179246,13167.236041422013,7090.0501761503156,7090.0501761503156,6077.1858652716983,7090.0501761503156,7090.0501761503156,8102.914487028931,5064.3215543930819,4051.4572435144655,{"$f":"'Outil de simulation'!G88","v":101286.43108786164}]
[null,"Autres produits",null,{"$f":"$P$46*D42","v":8566.7999999999993},0,0,0,0,0,8566.7999999999993,0,0,11422.400000000001,0,0,{"$f":"'Outil de simulation'!P88","v":28556}]
[null,"Restauration café",null,{"$f":"D43*$P$47","v":0},{"$f":"E43*$P$47","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R88","v":0}]
[null,"Augmentation stock"]
[null,"Augmentation stock librairie",null,{"$f":"$P$49/12","v":0},{"$f":"$P$49/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!G86-'Outil de simulation'!G84","v":0}]
[null,"Augmentation stock autres produits",null,{"$f":"$P$50/12","v":0},{"$f":"$P$50/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!P86-'Outil de simulation'!P84","v":0}]
[null,"Augmentation stock restauration café",null,{"$f":"$P$51/12","v":0},{"$f":"$P$51/12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"'Outil de simulation'!R86-'Outil de simulation'!R84","v":0}]
[null,"Total des achats"]
[null,"Total achats librairie",null,{"$f":"D45+D49","v":9115.7787979075474},12154.371730543397,15192.964663179246,13167.236041422013,7090.0501761503156,7090.0501761503156,6077.1858652716983,7090.0501761503156,7090.0501761503156,8102.914487028931,5064.3215543930819,4051.4572435144655,101286.43108786164]
[null,"Total achats autres produits",null,{"$f":"D46+D50","v":8566.7999999999993},0,0,0,0,0,8566.7999999999993,0,0,11422.400000000001,0,0,28556]
[null,"Total achats restauration café",null,{"$f":"D47+D51","v":0},{"$f":"E47+E51","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total achats",null,{"$f":"SUM(D53:D55)","v":17682.578797907547},12154.371730543397,15192.964663179246,13167.236041422013,7090.0501761503156,7090.0501761503156,14643.985865271698,7090.0501761503156,7090.0501761503156,19525.314487028932,5064.3215543930819,4051.4572435144655,129842.43108786164]
[]
[null,"Trésorerie entrante",null,{"$f":"D40","v":"Septembre"},{"$f":"E40","v":"Octobre"},"Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[null,"Répartition du CA"]
[null,"CA TTC librairie",null,{"$f":"D28*1.055","v":22693.178137651823},14588.471659919027,17830.354251012144,25935.060728744938,11346.589068825911,11346.589068825911,8104.7064777327942,9725.6477732793519,8104.7064777327942,12967.530364372469,11346.589068825911,8104.7064777327942,{"$f":"SUM(D61:O61)","v":162094.12955465587}]
[null,"CA TTC autres produits",null,{"$f":"D32*1.2","v":8131.2000000000007},5227.2,6388.8,9292.7999999999993,4065.6000000000004,4065.6000000000004,2904,3484.7999999999997,2904,4646.3999999999996,4065.6000000000004,2904,{"$f":"SUM(D62:O62)","v":58080}]
[null,"CA TTC restauration café",null,{"$f":"D36*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D63:O63)","v":0}]
[null,"Total CA TTC",null,{"$f":"D61+D62+D63","v":30824.378137651824},{"$f":"E61+E62+E63","v":19815.671659919026},24219.154251012144,35227.860728744941,15412.189068825912,15412.189068825912,11008.706477732794,13210.447773279351,11008.706477732794,17613.930364372471,15412.189068825912,11008.706477732794,{"$f":"P61+P62+P63","v":220174.12955465587}]
[]
[null,"Récupération TVA",null,{"$f":"IF(D108<0,D108*-1,0)","v":133.44100669213913},{"$f":"IF(E108<0,E108*-1,0)","v":0},0,0,0,0,1541.8732326441313,0,{"$f":"IF(L108<0,L108*-1,0)","v":0},1699.2233610917915,0,0,{"$f":"SUM(D66:O66)","v":3374.537600428062}]
[]
[null,"Total des entrées d'argent dans la strcuture",null,{"$f":"D64+D66","v":30957.819144343965},{"$f":"E64+E66","v":19815.671659919026},24219.154251012144,35227.860728744941,15412.189068825912,15412.189068825912,12550.579710376926,13210.447773279351,11008.706477732794,19313.153725464261,15412.189068825912,11008.706477732794,223548.66715508394]
[]
[null,"Trésorerie sortante",null,{"$f":"D59","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
[]
[null,"Achats librairie TTC (en bleu report de la dette N-1)",null,{"$f":"'Trésorerie année 2'!Z115","v":4862.8238866396759},{"$f":"'Trésorerie année 2'!AA115","v":3890.2591093117403},{"$f":"D45*1.055","v":9617.1466317924624},12822.862175723283,16028.577719654104,13891.434023700223,7480.0029358385827,7480.0029358385827,6411.4310878616416,7480.0029358385827,7480.0029358385827,8548.5747838155221,{"$f":"SUM(C72:O72)","v":105993.12116185298}]
[null,"Achats autres produits TTC (en bleu report de la dette N-1)",null,{"$f":"'Trésorerie année 2'!Z117","v":0},{"$f":"D54*1.2","v":10280.159999999998},0,0,0,0,0,10280.159999999998,0,0,13706.880000000001,0,{"$f":"SUM(C73:O73)","v":34267.199999999997}]
[null,"Achats restauration café TTC",null,{"$f":"D55*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C74:O74)","v":0}]
[]
[null,"Augmentation stock librairie TTC","échéancé",{"$f":"'Trésorerie année 2'!Z116","v":0},{"$f":"'Trésorerie année 2'!AA116","v":0},{"$f":"D49*1.055","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C76:O76)","v":0}]
[null,"Augmentation stock autres produits TTC","échéancé",{"$f":"'Trésorerie année 2'!Z118","v":0},{"$f":"D50*1.2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C77:O77)","v":0}]
[null,"Augmentation stock restauration café TTC",null,{"$f":"D51*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C78:O78)","v":0}]
[]
[null,"Fournitures \nconsommables TTC",null,{"$f":"D10*1.2","v":524.36159999999995},337.08959999999996,411.9984,599.2704,262.18079999999998,262.18079999999998,187.27199999999999,224.72639999999998,187.27199999999999,299.6352,262.18079999999998,187.27199999999999,3745.4399999999996]
[null,"Loyer TTC",null,{"$f":"D11*1.2","v":864},864,864,864,864,864,864,864,864,864,864,864,10368]
[null,"Services\nextérieurs TTC",null,{"$f":"D12*1.2","v":1330.9435600000004},1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,1330.9435600000004,15971.322720000004]
[null,"Personnel",null,{"$f":"D13","v":1836.1799999999996},1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,1836.1799999999996,22034.159999999996]
[null,"Financier TTC",null,{"$f":"D16*1.2","v":22.513957815006563},22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,22.513957815006563,{"$f":"SUM(D84:O84)","v":270.16749378007876}]
[null,"Impôts",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P85","v":1664.64},null,{"$f":"P15","v":1664.64}]
[null,"Remboursements emprunts ADELC",null,{"$f":"$P$86/12","v":83.333333333333329},83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,83.333333333333329,{"$f":"'Bilan ouverture'!R92","v":1000}]
[null,"Remboursement emprunts taux 0 %",null,{"$f":"$P$87/12","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,{"$f":"'Bilan ouverture'!Y92","v":2000}]
[null,"Remboursement \nemprunts",null,{"$f":"$P$88/12","v":233.94959148773151},233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,233.94959148773151,{"$f":"'Bilan ouverture'!J92","v":2807.3950978527782}]
[null,"IS",{"$f":"'Compte de résultats 3 ans'!P62","v":0.15},{"$f":"'Trésorerie année 2'!Z123","v":520.07086768620468},null,null,{"$f":"$Z$117/4","v":829.75194113792111},null,null,{"$f":"$Z$117/4","v":829.75194113792111},null,null,{"$f":"$Z$117/4","v":829.75194113792111},null,null,{"$f":"SUM(D89:O89)","v":3009.3266910999682}]
[null,"Solde TVA redue",null,{"$f":"IF(D108>0,D108,0)","v":0},537.48813909790897,720.48882496892952,1707.2121420805568,465.90252742353687,465.90252742353687,0,290.84087884054065,115.77923025754455,0,577.31760162018475,282.90184155251632,{"$f":"SUM(D90:O90)","v":5163.833713265255}]
[]
[null,"Total sorties",null,{"$f":"SUM(D71:D90)","v":10444.84346362862},{"$f":"SUM(E71:E90)","v":19582.583957712388},15287.220966064131,20496.683768244497,21294.248156380378,19157.104460426497,{"$f":"SUM(J71:J90)","v":13034.613986279242},22813.317323981857,11252.069427421926,13146.977186279242,28228.608446761504,13556.335734670778,{"$f":"SUM(D92:O92)","v":208294.60687785107}]
[]
[null,"Suivi mensuel de trésorerie","Solde N-1",{"$f":"D70","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août"]
[null,"Solde de trésorerie",{"$f":"'Trésorerie année 2'!O101","v":14975.644342256273},{"$f":"D68-D92","v":20512.975680715346},233.08770220663791,8931.9332849480124,14731.176960500445,-5882.0590875544658,-3744.9153916005853,-484.03427590231695,-9602.8695507025059,-243.36294968913171,6166.1765391850186,-12816.419377935592,-2547.6292569379839]
[null,"Cumum de la trésorerie",null,{"$f":"C95+D95","v":35488.62002297162},{"$f":"D96+E95","v":35721.707725178261},44653.641010126274,59384.817970626718,53502.758883072253,49757.843491471664,49273.809215569345,39670.939664866841,39427.576715177711,45593.753254362731,32777.333876427139,{"$f":"N96+O95","v":30229.704619489155}]
[]
[]
[null,"Tableau de répartition de la TVA",null,{"$f":"D94","v":"Septembre"},{"$f":"E94","v":"Octobre"},"Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août",{"$f":"P70","v":"Total"}]
[null,"TVA à payer",null,{"$f":"(D28*5.5%)+(D32*20%)+(D36*10%)","v":2538.2566801619437},{"$f":"(E28*5.5%)+(E32*20%)+(E36*10%)","v":1631.7364372469635},1994.3445344129555,2900.8647773279354,1269.1283400809718,1269.1283400809718,906.5202429149798,1087.8242914979758,906.5202429149798,1450.4323886639677,1269.1283400809718,906.5202429149798,{"$f":"SUM(D100:O100)","v":18130.404858299597}]
[null,"Solde N-1",null,{"$f":"'Trésorerie année 2'!W120","v":0}]
[null,"TVA à récupérer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bilan année 3","Actif",null,null,"Passif"]
[null,"Solde N-1",null,{"$f":"'Trésorerie année 2'!U121","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brut","Amortissements","Net",null,"Net"]
[null,"Sur achats de marchandses et augmentation du stock",null,{"$f":"D53*5.5%+D54*20%+D55*10%","v":2214.7278338849151},{"$f":"E53*5.5%+E54*20%+E55*10%","v":668.49044517988682},835.61305647485847,724.1979822782107,389.95275968826735,389.95275968826735,2047.6052225899434,389.95275968826735,389.95275968826735,2730.1402967865915,278.53768549161953,222.83014839329562,{"$f":"SUM(D104:O104)","v":11281.953709832391},null,"Fonds de commerce",{"$f":"'Trésorerie année 2'!S109","v":10000},null,{"$f":"S104","v":10000},"Capital",{"$f":"'Trésorerie année 2'!W109","v":3000}]
[null,"Sur frais généraux",null,{"$f":"((D80+D82+D84+D81)-(D80+D82+D84+D81)/1.2)","v":456.96985296916773},{"$f":"((E80+E82+E84+E81)-(E80+E82+E84+E81)/1.2)","v":425.75785296916774},438.24265296916747,469.45465296916791,413.27305296916757,413.27305296916757,400.78825296916784,407.0306529691677,400.78825296916784,419.51545296916765,413.27305296916757,400.78825296916784,{"$f":"SUM(C105:O105)","v":5059.1550356300113},null,"Frais d'établissement SARL",{"$f":"'Trésorerie année 2'!S110","v":1500},{"$f":"Amortissements!F4+Amortissements!G4+Amortissements!E4","v":1500},{"$f":"S105-T105","v":0},"Report à nouveau",{"$f":"'Trésorerie année 2'!W110+'Trésorerie année 2'!W111","v":32141.999425573667}]
[null,"Total TVA à récupérer",null,{"$f":"SUM(D103:D105)","v":2671.6976868540828},{"$f":"SUM(E103:E105)","v":1094.2482981490546},1273.8557094440259,1193.6526352473786,803.22581265743497,803.22581265743497,2448.3934755591113,796.98341265743511,790.74101265743525,3149.6557497557592,691.81073846078709,623.61840136246349,16341.108745462403,null,"Travaux et mises aux normes",{"$f":"'Trésorerie année 2'!S111","v":1250},{"$f":"Amortissements!E5+Amortissements!F5+Amortissements!G5","v":375},875,"Résultat net",{"$f":"P18-Z117","v":18807.710665792878}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction",{"$f":"'Trésorerie année 2'!S112","v":0},{"$f":"Amortissements!E6+Amortissements!F6+Amortissements!G6","v":0},0,"Subventions d'investissements",{"$f":"'Bilan ouverture'!L24","v":4000}]
[null,"Solde TVA",null,{"$f":"(D100+D101)-D106","v":-133.44100669213913},{"$f":"(E100+E101)-E106","v":537.48813909790897},720.48882496892952,1707.2121420805568,465.90252742353687,465.90252742353687,-1541.8732326441313,290.84087884054065,115.77923025754455,-1699.2233610917915,577.31760162018475,{"$f":"(O100+O101)-O106","v":282.90184155251632},{"$f":"(P100+P101)-P106","v":1789.2961128371935},null,"Aménagement",{"$f":"'Trésorerie année 2'!S113","v":2000},{"$f":"Amortissements!E7+Amortissements!F7+Amortissements!G7","v":600},1400,"Emprunts bancaires",{"$f":"'Bilan ouverture'!L92","v":11718.885542441163}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobilier",{"$f":"'Trésorerie année 2'!S114","v":0},{"$f":"Amortissements!E8+Amortissements!F8+Amortissements!G8","v":0},0,"Emprunts taux 0 %",{"$f":"'Bilan ouverture'!Z92","v":4000},null,"Dettes\n fournisseurs à reporter au bilan","N+1","2ème mois N+1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Informatique",{"$f":"'Trésorerie année 2'!S115","v":6765},{"$f":"Amortissements!E9+Amortissements!F9+Amortissements!G9","v":6765},0,"Comptes courants associés",{"$f":"'Bilan ouverture'!E6","v":2000},null,"Dettes achats librairie",{"$f":"N45*1.055","v":5342.8592398847013},{"$f":"O45*1.055","v":4274.287391907761}]
[null,"Suivi et évolution du stock",null,{"$f":"D99","v":"Septembre"},"Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août",null,null,"Caution financière",null,null,null,"Comptes courant Adelc",{"$f":"'Bilan ouverture'!S92","v":4000},null,"Dettes augmentation stock librairie",{"$f":"N49*1.055","v":0},{"$f":"O49*1.055","v":0}]
[null,"ventes",null,{"$f":"D5-(D5*$C$7)","v":18177.940352300633},11685.818797907546,14282.66741966478,20774.788974057865,9088.9701761503165,9088.9701761503165,6492.121554393083,7790.5458652716989,6492.121554393083,10387.394487028932,9088.9701761503165,6492.121554393083,null,null,"Caution bail",{"$f":"'Bilan ouverture'!C12","v":1440},null,{"$f":"S112","v":1440},null,null,null,"Dettes autres produits",{"$f":"O46*1.2","v":0}]
[null,"Achats",null,{"$f":"D57","v":17682.578797907547},12154.371730543397,15192.964663179246,13167.236041422013,7090.0501761503156,7090.0501761503156,14643.985865271698,7090.0501761503156,7090.0501761503156,19525.314487028932,5064.3215543930819,4051.4572435144655,null,null,"Stock librairie",{"$f":"'Outil de simulation'!G86","v":35626.224369857635},null,{"$f":"S113","v":35626.224369857635},"Fournisseurs",{"$f":"AA114","v":9617.1466317924624},null,"Dettes augmentation stock autres produits",{"$f":"O50*1.2","v":0}]
[null,"Évolution du stock",{"$f":"'Trésorerie année 2'!O118","v":46170.789587248924},{"$f":"C114-D112+D113","v":45675.428032855838},46143.98096549169,47054.278209006152,39446.7252763703,37447.805276370302,35448.885276370303,43600.749587248923,42900.253898127543,43498.18251988478,52636.102519884778,48611.45389812754,46170.789587248924,null,null,"Stock autres produits",{"$f":"'Outil de simulation'!P86","v":10544.565217391308},null,{"$f":"S114","v":10544.565217391308},null,null,null,"Total Dettes fou",null,{"$f":"Z110+Z111+Z112+AA110+AA111+AA112+Z113","v":9617.1466317924624}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock restauration café",{"$f":"'Outil de simulation'!R86","v":0},null,{"$f":"S115-T115","v":0},"TVA diverses"]
[null,"Cycle de financement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TVA diverses",null,null,null,"IS solde",{"$f":"Z118","v":829.75194113792111},null,"IS à reporter au bilan","1er mois N+1"]
[null,"Stock Moyen",{"$f":"SUM(C114:O114)/13","v":44215.801894941222},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disponibilités",{"$f":"U117","v":30229.704619489155},null,{"$f":"IF(O96>0,O96,\"\")","v":30229.704619489155},"Découvert",null,null,"Calcul de l'IS",{"$f":"'Compte de résultats 3 ans'!Q62","v":3319.0077645516844}]
[null,"Coût des ventes",{"$f":"'Outil de simulation'!T88","v":129842.43108786164},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(S104:S117)","v":99355.494206738105},{"$f":"SUM(T104:T117)","v":9240},{"$f":"SUM(U104:U117)","v":90115.494206738105},"Total",{"$f":"SUM(W104:W117)","v":90115.494206738091},null,"Dettes IS au bilan",{"$f":"Z117/4","v":829.75194113792111}]
[null,"Rotation",{"$f":"C118/C117","v":2.9365617160211914}]
[null,"Rotation en J",{"$f":"365/C119","v":124.29502094529316},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Écart",null,null,null,"Écart",{"$f":"W118-U118","v":0}]

{"sheet":"Bilan sur 3 ans","index":7,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,1,4],[1,5,1,6],[22,2,22,4],[22,5,22,6],[42,2,42,4],[42,5,42,6]]}
[]
[null,"Bilan année 1","Actif",null,null,"Passif"]
[null,null,"Brut","Amortissements","Net",null,"Net"]
[null,"Fonds de commerce",{"$f":"'Trésorerie année 1'!S133","v":10000},null,{"$f":"C4","v":10000},"Capital",{"$f":"'Trésorerie année 1'!W133","v":3000}]
[null,"Frais d'établissement SARL",{"$f":"'Trésorerie année 1'!S134","v":1500},{"$f":"'Trésorerie année 1'!T134","v":500},{"$f":"C5-D5","v":1000},"Report à nouveau",{"$f":"'Trésorerie année 1'!W134","v":0}]
[null,"Travaux et mises aux normes",{"$f":"'Trésorerie année 1'!S135","v":1250},{"$f":"'Trésorerie année 1'!T135","v":125},1125,"Résultat net",{"$f":"'Trésorerie année 1'!W135","v":20353.726424686363}]
[null,"Construction",{"$f":"'Trésorerie année 1'!S136","v":0},{"$f":"'Trésorerie année 1'!T136","v":0},0,"Subventions d'investissements",{"$f":"'Trésorerie année 1'!W136","v":8000}]
[null,"Aménagement",{"$f":"'Trésorerie année 1'!S137","v":2000},{"$f":"'Trésorerie année 1'!T137","v":200},1800,"Emprunts bancaires",{"$f":"'Trésorerie année 1'!W137","v":17286.386605742671}]
[null,"Mobilier",{"$f":"'Trésorerie année 1'!S138","v":0},{"$f":"'Trésorerie année 1'!T138","v":0},0,"Emprunts taux 0 %",{"$f":"'Trésorerie année 1'!W138","v":8000}]
[null,"Informatique",{"$f":"'Trésorerie année 1'!S139","v":6765},{"$f":"'Trésorerie année 1'!T139","v":2255},4510,"Comptes courants associés",{"$f":"'Trésorerie année 1'!W139","v":2000}]
[null,"Caution financière",{"$f":"'Trésorerie année 1'!S140","v":0},null,{"$f":"C11","v":0},"Comptes courant Adelc",{"$f":"'Trésorerie année 1'!W140","v":5000}]
[null,"Caution bail",{"$f":"'Trésorerie année 1'!S141","v":1440},null,1440]
[null,"Stock librairie",{"$f":"'Trésorerie année 1'!S142","v":35626.224369857635},null,35626.224369857635,"Fournisseurs",{"$f":"'Trésorerie année 1'!W142","v":8260.9104087762862}]
[null,"Stock autres produits",{"$f":"'Trésorerie année 1'!S143","v":10544.565217391308},null,10544.565217391308]
[null,"Stock restauration café",{"$f":"'Trésorerie année 1'!S144","v":0},null,0,"TVA à payer",{"$f":"'Trésorerie année 1'!W144","v":118.62861160958323}]
[null,"TVA diverses",{"$f":"'Trésorerie année 1'!S145","v":0},null,{"$f":"C16","v":0},"IS solde",{"$f":"'Trésorerie année 1'!W145","v":897.958518736163}]
[null,"Disponibilités",{"$f":"'Trésorerie année 1'!S146","v":6871.8209823021334},null,6871.8209823021334,"Découvert",{"$f":"'Trésorerie année 1'!W146","v":""}]
[null,"TOTAL",{"$f":"SUM(C4:C17)","v":75997.610569551078},{"$f":"SUM(D4:D16)","v":3080},{"$f":"SUM(E4:E17)","v":72917.610569551078},null,{"$f":"SUM(G4:G17)","v":72917.610569551078}]
[]
[null,"Écart",{"$f":"C17+G20","v":6871.8209823021334},null,null,"Écart",{"$f":"G18-E18","v":0}]
[]
[]
[null,"Bilan année 2","Actif",null,null,"Passif"]
[null,null,"Brut","Amortissements","Net",null,"Net"]
[null,"Fonds de commerce",{"$f":"'Trésorerie année 2'!S109","v":10000},null,{"$f":"C25","v":10000},"Capital",{"$f":"'Trésorerie année 2'!W109","v":3000}]
[null,"Frais d'établissement SARL",{"$f":"'Trésorerie année 2'!S110","v":1500},{"$f":"'Trésorerie année 2'!T110","v":1000},{"$f":"C26-D26","v":500},"Report à nouveau",{"$f":"'Trésorerie année 2'!W110","v":20353.726424686363}]
[null,"Travaux et mises aux normes",{"$f":"'Trésorerie année 2'!S111","v":1250},{"$f":"'Trésorerie année 2'!T111","v":250},1000,"Résultat net",{"$f":"'Trésorerie année 2'!W111","v":11788.273000887306}]
[null,"Construction",{"$f":"'Trésorerie année 2'!S112","v":0},{"$f":"'Trésorerie année 2'!T112","v":0},0,"Subventions d'investissements",{"$f":"'Trésorerie année 2'!W112","v":6000}]
[null,"Aménagement",{"$f":"'Trésorerie année 2'!S113","v":2000},{"$f":"'Trésorerie année 2'!T113","v":400},1600,"Emprunts bancaires",{"$f":"'Trésorerie année 2'!W113","v":14526.280640293942}]
[null,"Mobilier",{"$f":"'Trésorerie année 2'!S114","v":0},{"$f":"'Trésorerie année 2'!T114","v":0},0,"Emprunts taux 0 %",{"$f":"'Trésorerie année 2'!W114","v":6000}]
[null,"Informatique",{"$f":"'Trésorerie année 2'!S115","v":6765},{"$f":"'Trésorerie année 2'!T115","v":4510},2255,"Comptes courants associés",{"$f":"'Trésorerie année 2'!W115","v":2000}]
[null,"Caution financière",{"$f":"'Trésorerie année 2'!S116","v":0},null,{"$f":"C32","v":0},"Comptes courant Adelc",{"$f":"'Trésorerie année 2'!W116","v":5000}]
[null,"Caution bail",{"$f":"'Trésorerie année 2'!S117","v":1440},null,{"$f":"C33","v":1440}]
[null,"Stock librairie",{"$f":"'Trésorerie année 2'!S118","v":35626.224369857635},null,{"$f":"C34","v":35626.224369857635},"Fournisseurs",{"$f":"'Trésorerie année 2'!W118","v":8753.0829959514158}]
[null,"Stock autres produits",{"$f":"'Trésorerie année 2'!S119","v":10544.565217391308},null,{"$f":"C35","v":10544.565217391308}]
[null,"Stock restauration café",{"$f":"'Trésorerie année 2'!S120","v":0},null,{"$f":"C36","v":0},"TVA diverses",{"$f":"'Trésorerie année 2'!W120","v":0}]
[null,"TVA diverses",{"$f":"'Trésorerie année 2'!S121","v":0},null,null,"IS solde",{"$f":"'Trésorerie année 2'!W121","v":520.07086768620468}]
[null,"Disponibilités",{"$f":"'Trésorerie année 2'!S122","v":14975.644342256273},null,{"$f":"C38","v":14975.644342256273},"Découvert",{"$f":"'Trésorerie année 2'!W122","v":""}]
[null,"Total",{"$f":"SUM(C25:C38)","v":84101.43392950522},{"$f":"SUM(D25:D38)","v":6160},{"$f":"SUM(E25:E38)","v":77941.43392950522},"Total",{"$f":"SUM(G25:G38)","v":77941.43392950522}]
[]
[null,"Écart",{"$f":"C38+G41","v":14975.644342256273},null,null,"Écart",{"$f":"G39-E39","v":0}]
[]
[null,"Bilan année 3","Actif",null,null,"Passif"]
[null,null,"Brut","Amortissements","Net",null,"Net"]
[null,"Fonds de commerce",{"$f":"'Trésorerie année 3'!S104","v":10000},null,{"$f":"C45","v":10000},"Capital",{"$f":"'Trésorerie année 3'!W104","v":3000}]
[null,"Frais d'établissement SARL",{"$f":"'Trésorerie année 3'!S105","v":1500},{"$f":"'Trésorerie année 3'!T105","v":1500},{"$f":"C46-D46","v":0},"Report à nouveau",{"$f":"'Trésorerie année 3'!W105","v":32141.999425573667}]
[null,"Travaux et mises aux normes",{"$f":"'Trésorerie année 3'!S106","v":1250},{"$f":"'Trésorerie année 3'!T106","v":375},875,"Résultat net",{"$f":"'Trésorerie année 3'!W106","v":18807.710665792878}]
[null,"Construction",{"$f":"'Trésorerie année 3'!S107","v":0},{"$f":"'Trésorerie année 3'!T107","v":0},0,"Subventions d'investissements",{"$f":"'Trésorerie année 3'!W107","v":4000}]
[null,"Aménagement",{"$f":"'Trésorerie année 3'!S108","v":2000},{"$f":"'Trésorerie année 3'!T108","v":600},1400,"Emprunts bancaires",{"$f":"'Trésorerie année 3'!W108","v":11718.885542441163}]
[null,"Mobilier",{"$f":"'Trésorerie année 3'!S109","v":0},{"$f":"'Trésorerie année 3'!T109","v":0},0,"Emprunts taux 0 %",{"$f":"'Trésorerie année 3'!W109","v":4000}]
[null,"Informatique",{"$f":"'Trésorerie année 3'!S110","v":6765},{"$f":"'Trésorerie année 3'!T110","v":6765},0,"Comptes courants associés",{"$f":"'Trésorerie année 3'!W110","v":2000}]
[null,"Caution financière",{"$f":"'Trésorerie année 3'!S111","v":0},null,null,"Comptes courant Adelc",{"$f":"'Trésorerie année 3'!W111","v":4000}]
[null,"Caution bail",{"$f":"'Trésorerie année 3'!S112","v":1440},null,{"$f":"C53","v":1440}]
[null,"Stock librairie",{"$f":"'Trésorerie année 3'!S113","v":35626.224369857635},null,{"$f":"C54","v":35626.224369857635},"Fournisseurs",{"$f":"'Trésorerie année 3'!W113","v":9617.1466317924624}]
[null,"Stock autres produits",{"$f":"'Trésorerie année 3'!S114","v":10544.565217391308},null,{"$f":"C55","v":10544.565217391308},"Sociales"]
[null,"Stock restauration café",{"$f":"'Trésorerie année 3'!S115","v":0},null,{"$f":"C56-D56","v":0},"TVA diverses",{"$f":"G5","v":0}]
[null,"TVA diverses",{"$f":"'Trésorerie année 3'!S116","v":0},null,null,"IS solde",{"$f":"'Trésorerie année 3'!W116","v":829.75194113792111}]
[null,"Disponibilités",{"$f":"'Trésorerie année 3'!S117","v":30229.704619489155},null,{"$f":"C58","v":30229.704619489155},"Découvert",{"$f":"'Trésorerie année 3'!W117","v":0}]
[null,"Total",{"$f":"SUM(C45:C58)","v":99355.494206738105},{"$f":"SUM(D45:D58)","v":9240},{"$f":"SUM(E45:E58)","v":90115.494206738105},"Total",{"$f":"SUM(G45:G58)","v":90115.494206738091}]
[]
[null,"Écart",{"$f":"C58+G61","v":30229.704619489155},null,null,"Écart",{"$f":"G59-E59","v":0}]