{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Invest. - caf - Bfr","Plan de financement"],"not_rendered":{"defined_names":25},"read":"whole","date_system":"1900"}

{"sheet":"Invest. - caf - Bfr","index":0,"n_rows":109,"n_cols":15,"rows_kept":109,"merged":[[1,1,1,2],[1,3,1,14],[2,3,2,8],[2,10,2,14],[3,1,4,1],[3,2,4,4],[3,5,4,5],[3,7,3,8],[3,10,3,11],[3,13,3,14],[6,1,6,2],[7,1,10,1],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[14,1,20,1],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[23,1,23,2],[24,1,25,1],[29,1,32,1],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[36,1,39,1],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[43,1,46,1],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[50,1,53,1],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[57,1,60,1],[57,2,57,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[63,1,63,2],[64,1,67,1],[64,2,64,4],[65,2,65,4],[66,2,66,4],[67,2,67,4],[71,1,71,5],[72,1,72,5],[73,1,73,5],[74,1,74,5],[78,7,78,8],[78,10,78,11],[78,13,78,14],[79,4,79,5],[79,7,79,8],[79,10,79,11],[79,13,79,14],[80,4,80,5],[80,7,80,8],[80,10,80,11],[80,13,80,14],[81,4,81,5],[82,4,82,5],[84,4,84,5],[84,7,84,8],[84,10,84,11],[84,13,84,14],[85,4,85,5],[85,7,85,8],[85,10,85,11],[85,13,85,14],[87,4,87,5],[87,7,87,8],[87,10,87,11],[87,13,87,14],[88,4,88,5],[88,7,88,8],[88,10,88,11],[88,13,88,14],[90,7,91,8],[92,4,92,5],[92,7,92,8],[93,4,93,5],[93,7,93,8],[95,4,95,5],[97,4,97,5],[97,7,97,8],[98,4,98,5],[98,7,98,8],[98,10,98,14],[100,4,100,5],[100,7,100,8],[100,10,100,14],[101,4,101,5],[101,7,101,8],[101,10,101,14],[103,4,103,5],[103,7,103,8],[104,4,104,5],[104,7,104,8],[104,10,104,14],[106,4,106,5],[106,7,106,8],[106,10,106,14],[107,4,107,5],[107,7,107,8],[107,10,107,14],[108,7,108,10]]}
[]
[null,{"$f":"IF(ISBLANK(entreprise),\" \",entreprise)","v":" "}," ","Programme d'investissements"]
[{"$nulls":3},{"$f":"IF(ISBLANK(AN),\" les exercices doivent être renseignés dans le plan de financement\",\" \")","v":" les exercices doivent être renseignés dans le plan de financement"},{"$nulls":6},"Les montants sont exprimés en € et hors TVA"]
[null,"Nature","Description \nsommaire",null,null,"Apport \nen \nnature ?",null,{"$f":"IF(ISBLANK(AN),\" \",AN)","v":" "},null,null,{"$f":"IF(ISBLANK(AN),\" \",AN+1)","v":" "},null,null,{"$f":"IF(ISBLANK(AN),\" \",AN+2)","v":" "}]
[{"$nulls":7},"Acquisition","Crédit-bail",null,"Acquisition","Crédit-bail",null,"Acquisition","Crédit-bail"]
[]
[null,"I - Investissements immatériels"]
[null,"Frais \nd'établissement","Frais de constitution"]
[null,null,"Frais d'augmentation de capital"]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H8:H11)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I8:I11)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K8:K11)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L8:L11)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N8:N11)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O8:O11)","v":{"v":0,"d":"0 "}}]
[]
[null,"Autres \ninvestissements \nimmatériels","Brevets, marques, dessins et modèles"]
[null,null,"Autres frais de R&D (part immobilisée)"]
[null,null,"Prototypes"]
[null,null,"Droit au bail, fonds de commerce"]
[null,null,"Franchise, licence"]
[null,null,"Logiciels dissociés"]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier",null,"Matériel mobilier","Immobilier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H15:H21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I15:I21)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K15:K21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L15:L21)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N15:N21)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O15:O21)","v":{"v":0,"d":"0 "}}]
[null,"Investissements matériels",{"$nulls":5},{"$f":"SUMIF(F15:F21,\"oui\",H15:H21)","v":{"v":0,"d":"0 "}}]
[null," Terrains \n et bâtiments","Terrains","superficie : "]
[null,null,"Bâtiments","superficie : "]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H24:H26)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I24:I26)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K24:K26)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L24:L26)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N24:N26)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O24:O26)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"SUMIF(F25:F26,\"oui\",H25:H26)","v":{"v":0,"d":"0 "}}]
[null,"Agencements \net aménagements"]
[]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H30:H33)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I30:I33)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K30:K33)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L30:L33)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N30:N33)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O30:O33)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"SUMIF(F30:F33,\"oui\",H30:H33)","v":{"v":0,"d":"0 "}}]
[null,"Matériels  techniques \net outillages"]
[]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H37:H40)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I37:I40)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K37:K40)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L37:L40)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N37:N40)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O37:O40)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"SUMIF(F37:F40,\"oui\",H37:H40)","v":{"v":0,"d":"0 "}}]
[null,"Matériel \nde transport"]
[]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H44:H47)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I44:I47)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K44:K47)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L44:L47)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N44:N47)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O44:O47)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"SUMIF(F44:F47,\"oui\",H44:H47)","v":{"v":0,"d":"0 "}}]
[null,"Equipement \ninformatique"]
[]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H51:H54)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I51:I54)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K51:K54)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L51:L54)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N51:N54)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O51:O54)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"SUMIF(F51:F54,\"oui\",H51:H54)","v":{"v":0,"d":"0 "}}]
[null,"Matériel\nmobilier \nde bureau"]
[]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H58:H61)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I58:I61)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K58:K61)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L58:L61)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N58:N61)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O58:O61)","v":{"v":0,"d":"0 "}}]
[null,"Investissements financiers",{"$nulls":5},{"$f":"SUMIF(F58:F61,\"oui\",H58:H61)","v":{"v":0,"d":"0 "}}]
[null,"Investissements \nfinanciers","Dépôt de garantie"]
[null,null,"Titres de participation"]
[]
[]
[null,"Financier","Immatériel","Matériel-mobilier","Immobilier",null,null,"Financier","Financier","Matériel mobilier","Immobilier","Financier",null,null,"Financier"]
[{"$nulls":5},"Total",null,{"$f":"SUM(H65:H68)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I65:I68)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K65:K68)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L65:L68)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N65:N68)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O65:O68)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"SUMIF(F65:F68,\"oui\",H65:H68)","v":{"v":0,"d":"0 "}}]
[null,"Récapitualtif des investissements",{"$nulls":5},"Acquisition","Crédit-bail",null,"Acquisition","Crédit-bail",null,"Acquisition","Crédit-bail"]
[null," Total des investissements immatériels",{"$nulls":5},{"$f":"H13+H23","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},null,{"$f":"K13+K23","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},null,{"$f":"N13+N23","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
[null," Total des investissements matériels",{"$nulls":5},{"$f":"H28+H35+H42+H49+H56+H63","v":{"v":0,"d":"0 "}},{"$f":"I28+I35+I42+I49+I56+I63","v":{"v":0,"d":"0 "}},null,{"$f":"K28+K35+K42+K49+K56+K63","v":{"v":0,"d":"0 "}},{"$f":"L28+L35+L42+L49+L56+L63","v":{"v":0,"d":"0 "}},null,{"$f":"N28+N35+N42+N49+N56+N63","v":{"v":0,"d":"0 "}},{"$f":"O28+O35+O42+O49+O56+O63","v":{"v":0,"d":"0 "}}]
[null," Total des investissements financiers",{"$nulls":5},{"$f":"H70","v":{"v":0,"d":"0 "}},{"$f":"I70","v":{"v":0,"d":"0 "}},null,{"$f":"K70","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},null,{"$f":"N70","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
[]
[{"$nulls":5},"Total",null,{"$f":"SUM(H72:H75)","v":{"v":0,"d":"0 "}},{"$f":"SUM(I72:I75)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(K72:K75)","v":{"v":0,"d":"0 "}},{"$f":"SUM(L72:L75)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(N72:N75)","v":{"v":0,"d":"0 "}},{"$f":"SUM(O72:O75)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"H24+H29+H36+H43+H50+H57+H64+H71","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},{"$f":"IF(AND(H81=\" \",H82>0),\"renseigner la durée de l'ex.\",\" \")","v":" "},null,null,{"$f":"IF(AND(K81=\" \",K82>0),\"renseigner la durée de l'ex.\",\" \")","v":" "},null,null,{"$f":"IF(AND(N81=\" \",N82>0),\"renseigner la durée de l'ex.\",\" \")","v":" "}]
[{"$nulls":4},"Capacité d'autofinancement",null,null,{"$f":"IF(ISBLANK(AN),\" \",AN)","v":" "},null,null,{"$f":"IF(ISBLANK(AN),\" \",AN+1)","v":" "},null,null,{"$f":"IF(ISBLANK(AN),\" \",AN+2)","v":" "}]
[{"$nulls":4},"Et B.F.R. ou D.F.R.",null,null,{"$f":"IF(ISBLANK(durée_1),\" \",durée_1)","v":" "},null,null,{"$f":"IF(ISBLANK(durée_2),\" \",durée_2)","v":" "},null,null,{"$f":"IF(ISBLANK(durée_3),\" \",durée_3)","v":" "}]
[{"$nulls":4},"Chiffre d'affaires",{"$nulls":3},{"$f":"IF(ISBLANK(H82),\" \",100%)","v":" "},null,null,{"$f":"IF(ISBLANK(K82),\" \",100%)","v":" "},null,null,{"$f":"IF(ISBLANK(N82),\" \",100%)","v":" "}]
[{"$nulls":4},"Capacité d'autofinancement",{"$nulls":3},{"$f":"IF(ISERROR(H83/H82),\" \",H83/H82)","v":" "},null,null,{"$f":"IF(ISERROR(K83/K82),\" \",K83/K82)","v":" "},null,null,{"$f":"IF(ISERROR(N83/N82),\" \",N83/N82)","v":" "}]
[]
[{"$nulls":4},"Besoin en Fonds de Roulement \nen jours de CA HT"]
[{"$nulls":4},"= Besoin en Fonds de Roulement",null,null,{"$f":"IF(ISERROR(H82*H85/(H81*30)),0,H82*H85/(H81*30))","v":{"v":0,"d":"0 €"}},null,null,{"$f":"IF(ISERROR(K82*K85/(K81*30)),0,K82*K85/(K81*30))","v":{"v":0,"d":"0 €"}},null,null,{"$f":"IF(ISERROR(N82*N85/(N81*30)),0,N82*N85/(N81*30))","v":{"v":0,"d":"0 €"}}]
[{"$nulls":4},"Ou"]
[{"$nulls":4},"Dégagement de Fonds de \nRoulement en jours de CA HT"]
[null,"Financier","Immatériel","Matériel-mobilier","= Dégagement de Fonds de R.",null,null,{"$f":"IF(ISERROR(H82*H88/(H81*30)),0,H82*H88/(H81*30))","v":{"v":0,"d":"0 €"}},null,null,{"$f":"IF(ISERROR(K82*K88/(K81*30)),0,K82*K88/(K81*30))","v":{"v":0,"d":"0 €"}},null,null,{"$f":"IF(ISERROR(N82*N88/(N81*30)),0,N82*N88/(N81*30))","v":{"v":0,"d":"0 €"}}]
[]
[{"$nulls":4},"Entreprise existante ?",null,{"$f":"IF(OR(ISBLANK(existant),existant=\"non\"),1,0)","v":1},{"$f":"IF(AND(ISBLANK(H94),H95>0),\"renseigner la durée de l'ex.\",\" \")","v":" "}]
[]
[{"$nulls":4},"Capacité d'autofinancement",null,null,{"$f":"IF(OR(ISBLANK(AN),G91=1),\" \",AN-1)","v":" "}]
[{"$nulls":4},"Et B.F.R. ou D.F.R."]
[{"$nulls":4},"Chiffre d'affaires",{"$nulls":3},{"$f":"IF(ISBLANK(H95),\" \",100%)","v":" "}]
[{"$nulls":4},"Capacité d'autofinancement",{"$nulls":3},{"$f":"IF(ISERROR(H96/H95),\" \",H96/H95)","v":" "}]
[]
[{"$nulls":4},"Besoin en Fonds de Roulement"]
[{"$nulls":4},"= jours de chiffre d'affaires",null,null,{"$f":"IF(ISERROR(H98*(H94*30)/H95),0,H98*(H94*30)/H95)","v":{"v":0,"d":"0 jours de CA HT"}},null,null,{"$f":"IF(AND(bfr_4>0,ISBLANK(H94)),\"Il est indispensable de renseigner la durée de l'exercice\",\" \")","v":" "}]
[{"$nulls":4},"Ou"]
[{"$nulls":4},"Dégagement de F. de Roulement",{"$nulls":5},{"$f":"IF(AND(bfr_4>0,dfr_4>0),\"Attention : BFR ou DFR, mais pas les deux !\",\" \")","v":" "}]
[{"$nulls":4},"= jours de chiffre d'affaires",null,null,{"$f":"IF(ISERROR(H101*(H94*30)/H95),0,H101*(H94*30)/H95)","v":{"v":0,"d":"0 jours de CA HT"}},null,null,{"$f":"IF(AND(dfr_4>0,ISBLANK(H94)),\"Il est indispensable de renseigner la durée de l'exercice\",\" \")","v":" "}]
[]
[{"$nulls":4},"Trésorerie nette positive"]
[{"$nulls":4},"= jours de chiffre d'affaires",null,null,{"$f":"IF(ISERROR(H104*(H94*30)/H95),0,H104*(H94*30)/H95)","v":{"v":0,"d":"0 jours de CA HT"}},null,null,{"$f":"IF(AND(tr0_positive>0,ISBLANK(H94)),\"Il est indispensable de renseigner la durée de l'exercice\",\" \")","v":" "}]
[{"$nulls":4},"Ou"]
[{"$nulls":4},"Trésorerie nette négative (-)",{"$nulls":5},{"$f":"IF(AND(tr0_positive>0,tro_négative<0),\"Attention : tréso nette poitive ou négative, mais pas les deux !\",\" \")","v":" "}]
[{"$nulls":4},"= jours de chiffre d'affaires",null,null,{"$f":"IF(ISERROR(H107*(H94*30)/H95),0,H107*(H94*30)/H95)","v":{"v":0,"d":"0 jours de CA HT"}},null,null,{"$f":"IF(AND(tro_négative<0,ISBLANK(H94)),\"Il est indispensable de renseigner la durée de l'exercice\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(tro_négative>0,\"mettre le signe (-) avant le montant\",\" \")","v":" "}]

{"sheet":"Plan de financement","index":1,"n_rows":40,"n_cols":13,"rows_kept":40,"merged":[[0,1,0,2],[0,9,0,12],[1,1,1,2],[1,5,1,6],[1,8,1,9],[1,11,1,12],[2,1,2,2],[2,5,2,6],[2,8,2,9],[2,11,2,12],[4,1,4,3],[4,5,4,6],[4,8,4,9],[4,11,4,12],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,15,1],[14,2,14,3],[15,2,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[22,1,22,3],[22,5,22,6],[22,8,22,9],[22,11,22,12],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,33,1],[32,2,32,3],[33,2,33,3],[34,1,34,3],[35,1,35,3],[37,1,37,3],[38,1,38,3],[39,1,39,2]]}
[null,{"$f":"IF(ISBLANK(entreprise),\"Ci-dessous : renseigner le nom de l'entreprise\",\" \")","v":"Ci-dessous : renseigner le nom de l'entreprise"},{"$nulls":7},"Les montants sont exprimés en €"]
[null,null," ","  Exercices",{"$nulls":4},{"$f":"IF(ISBLANK($F$2),\" \",F2+1)","v":" "},{"$f":"A2+1","v":1},null,{"$f":"IF(ISBLANK($F$2),\" \",I2+1)","v":" "},{"$f":"D2+1","v":{"$error":"#VALUE!"}}]
[null,"Plan de financement",null,"  Durées"]
[]
[null,"Emplois",{"$nulls":3},"Emplois",null,null,"Emplois",null,null,"Emplois"]
[]
[null,"Investissements hors crédit-bail",{"$nulls":3},{"$f":"SUM(F8:F10)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F7/F21),\" \",F7/F21)","v":" "},null,{"$f":"SUM(I8:I10)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I7/I21),\" \",I7/I21)","v":" "},null,{"$f":"SUM(L8:L10)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L7/L21),\" \",L7/L21)","v":" "}]
[null,"▪ Investissements immatériels",{"$nulls":3},{"$f":"'Invest. - caf - Bfr'!H73","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F8/F7),\" \",F8/F7)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!K73","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I8/I7),\" \",I8/I7)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!N73","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L8/L7),\" \",L8/L7)","v":" "}]
[null,"▪ Investissements matériels",{"$nulls":3},{"$f":"'Invest. - caf - Bfr'!H74","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F9/F7),\" \",F9/F7)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!K74","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I9/I7),\" \",I9/I7)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!N74","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L9/L7),\" \",L9/L7)","v":" "}]
[null,"▪ Investissements financiers",{"$nulls":3},{"$f":"'Invest. - caf - Bfr'!H75","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F10/F7),\" \",F10/F7)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!K75","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I10/I7),\" \",I10/I7)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!N75","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L10/L7),\" \",L10/L7)","v":" "}]
[null,"Investissements en crédit-bail",{"$nulls":3},{"$f":"SUM(F12:F14)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F11/F21),\" \",F11/F21)","v":" "},null,{"$f":"SUM(I12:I14)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I11/I21),\" \",I11/I21)","v":" "},null,{"$f":"SUM(L12:L14)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L11/L21),\" \",L11/L21)","v":" "}]
[null,"▪ Investissements immatériels",{"$nulls":3},{"$f":"'Invest. - caf - Bfr'!I73","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F12/F11),\" \",F12/F11)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!L73","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I12/I11),\" \",I12/I11)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!O73","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L12/L11),\" \",L12/L11)","v":" "}]
[null,"▪ Investissements matériels",{"$nulls":3},{"$f":"'Invest. - caf - Bfr'!I74","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F13/F11),\" \",F13/F11)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!L74","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I13/I11),\" \",I13/I11)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!O74","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L13/L11),\" \",L13/L11)","v":" "}]
[null,"▪ Investissements financiers",{"$nulls":3},{"$f":"'Invest. - caf - Bfr'!I75","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F14/F11),\" \",F14/F11)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!L75","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I14/I11),\" \",I14/I11)","v":" "},null,{"$f":"'Invest. - caf - Bfr'!O75","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L14/L11),\" \",L14/L11)","v":" "}]
[null," Besoin en \n fonds de roulement "," ▪ Constitution si nouvelle entreprise",null,null,{"$f":"IF(ISERROR(IF(existant=\"oui\",0,bfr_1)),0,IF(existant=\"oui\",0,bfr_1))","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F15/F21),\" \",F15/F21)","v":" "}]
[null,null," ▪ Evolution (+ ou -)",null,null,{"$f":"IF(ISERROR(IF(existant=\"oui\",bfr_1-bfr_4,0)),0,IF(existant=\"oui\",bfr_1-bfr_4,0))","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F16/F21),\" \",F16/F21)","v":" "},null,{"$f":"IF(ISERROR(bfr_2-bfr_1),0,bfr_2-bfr_1)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I16/I21),\" \",I16/I21)","v":" "},null,{"$f":"IF(ISERROR(bfr_3-bfr_2),0,bfr_3-bfr_2)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L16/L21),\" \",L16/L21)","v":" "}]
[null,"Capacité d'autofinancement négative",{"$nulls":3},{"$f":"IF(ISERROR(IF(caf_1>0,0,caf_1/-1)),0,IF(caf_1>0,0,caf_1/-1))","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F17/F21),\" \",F17/F21)","v":" "},null,{"$f":"IF(caf_2>0,0,caf_2/-1)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I17/I21),\" \",I17/I21)","v":" "},null,{"$f":"IF(caf_3>0,0,caf_3/-1)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L17/L21),\" \",L17/L21)","v":" "}]
[null,"Distribution de dividendes",{"$nulls":4},{"$f":"IF(ISERROR(F18/F21),\" \",F18/F21)","v":" "},null,null,{"$f":"IF(ISERROR(I18/I21),\" \",I18/I21)","v":" "},null,null,{"$f":"IF(ISERROR(L18/L21),\" \",L18/L21)","v":" "}]
[null,"Remboursement du capital des emprunts",{"$nulls":4},{"$f":"IF(ISERROR(F19/F21),\" \",F19/F21)","v":" "},null,null,{"$f":"IF(ISERROR(I19/I21),\" \",I19/I21)","v":" "},null,null,{"$f":"IF(ISERROR(L19/L21),\" \",L19/L21)","v":" "}]
[null,"Remboursement du capital des comptes courants",{"$nulls":4},{"$f":"IF(ISERROR(F20/F21),\" \",F20/F21)","v":" "},null,null,{"$f":"IF(ISERROR(I20/I21),\" \",I20/I21)","v":" "},null,null,{"$f":"IF(ISERROR(L20/L21),\" \",L20/L21)","v":" "}]
[null,"Total des besoins",{"$nulls":3},{"$f":"IF(ISERROR(F7+F11+F15+F16+F17+F18+F19+F20),0,F7+F11+F15+F16+F17+F18+F19+F20)","v":{"v":0,"d":"0 "}},{"$f":"IF(F21<>0,100%,\" \")","v":" "},null,{"$f":"IF(ISERROR(I7+I11+I16+I17+I18+I19+I20),0,I7+I11+I16+I17+I18+I19+I20)","v":{"v":0,"d":"0 "}},{"$f":"IF(I21<>0,100%,\" \")","v":" "},null,{"$f":"IF(ISERROR(L7+L11+L16+L17+L18+L19+L20),0,L7+L11+L16+L17+L18+L19+L20)","v":{"v":0,"d":"0 "}},{"$f":"IF(L21<>0,100%,\" \")","v":" "}]
[]
[null,"Ressources",{"$nulls":3},"Ressources",null,null,"Ressources",null,null,"Ressources"]
[]
[null,"▪ Apports en nature",{"$nulls":3},{"$f":"nature","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F25/F27),\" \",F25/F27)","v":" "},null,null,{"$f":"IF(ISERROR(I25/I27),\" \",I25/I27)","v":" "},null,null,{"$f":"IF(ISERROR(L25/L27),\" \",L25/L27)","v":" "}]
[null,"▪ Apports en numéraire",{"$nulls":4},{"$f":"IF(ISERROR(F26/F27),\" \",F26/F27)","v":" "},null,null,{"$f":"IF(ISERROR(I26/I27),\" \",I26/I27)","v":" "},null,null,{"$f":"IF(ISERROR(L26/L27),\" \",L26/L27)","v":" "}]
[null,"Capital",{"$nulls":3},{"$f":"SUM(F25:F26)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F27/F36),\" \",F27/F36)","v":" "},null,{"$f":"SUM(I25:I26)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I27/I36),\" \",I27/I36)","v":" "},null,{"$f":"SUM(L25:L26)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L27/L36),\" \",L27/L36)","v":" "}]
[null,"Cession d'actifs immobilisés",{"$nulls":4},{"$f":"IF(ISERROR(F28/F36),\" \",F28/F36)","v":" "},null,null,{"$f":"IF(ISERROR(I28/I36),\" \",I28/I36)","v":" "},null,null,{"$f":"IF(ISERROR(L28/L36),\" \",L28/L36)","v":" "}]
[null,"Subventions d'équipement",{"$nulls":4},{"$f":"IF(ISERROR(F29/F36),\" \",F29/F36)","v":" "},null,null,{"$f":"IF(ISERROR(I29/I36),\" \",I29/I36)","v":" "},null,null,{"$f":"IF(ISERROR(L29/L36),\" \",L29/L36)","v":" "}]
[null,"Comptes courants d'associés",{"$nulls":4},{"$f":"IF(ISERROR(F30/F36),\" \",F30/F36)","v":" "},null,null,{"$f":"IF(ISERROR(I30/I36),\" \",I30/I36)","v":" "},null,null,{"$f":"IF(ISERROR(L30/L36),\" \",L30/L36)","v":" "}]
[null,"Emprunt bancaire à moyen terme et à long terme",{"$nulls":4},{"$f":"IF(ISERROR(F31/F36),\" \",F31/F36)","v":" "},null,null,{"$f":"IF(ISERROR(I31/I36),\" \",I31/I36)","v":" "},null,null,{"$f":"IF(ISERROR(L31/L36),\" \",L31/L36)","v":" "}]
[null,"Crédit-bail",{"$nulls":3},{"$f":"créditbail_1","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F32/F36),\" \",F32/F36)","v":" "},null,{"$f":"créditbail_2","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I32/I36),\" \",I32/I36)","v":" "},null,{"$f":"créditbail_3","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L32/L36),\" \",L32/L36)","v":" "}]
[null," Dégagement de\n fonds de roulement "," ▪ Constitution si nouvelle entreprise",null,null,{"$f":"IF(existant=\"oui\",0,dfr_1)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(IF(ISBLANK(F33),\" \",F33/F36)),\" \",IF(ISBLANK(F33),\" \",F33/F36))","v":" "}]
[null,null," ▪ Evolution (+ ou -)",null,null,{"$f":"IF(existant=\"oui\",dfr_1-dfr_4,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F34/F36),\" \",F34/F36)","v":" "},null,{"$f":"dfr_2-dfr_1","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I34/I36),\" \",I34/I36)","v":" "},null,{"$f":"dfr_3-dfr_2","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L34/L36),\" \",L34/L36)","v":" "}]
[null,"Capacité d'autofinancement",{"$nulls":3},{"$f":"IF(caf_1<0,0,caf_1)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(F35/F36),\" \",F35/F36)","v":" "},null,{"$f":"IF(caf_2<0,0,caf_2)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(I35/I36),\" \",I35/I36)","v":" "},null,{"$f":"IF(caf_3<0,0,caf_3)","v":{"v":0,"d":"0 "}},{"$f":"IF(ISERROR(L35/L36),\" \",L35/L36)","v":" "}]
[null,"Total des ressources",{"$nulls":3},{"$f":"SUM(F27:F35)","v":{"v":0,"d":"0 "}},{"$f":"IF(F36<>0,100%,\" \")","v":" "},null,{"$f":"SUM(I27:I35)","v":{"v":0,"d":"0 "}},{"$f":"IF(I36<>0,100%,\" \")","v":" "},null,{"$f":"SUM(L27:L35)","v":{"v":0,"d":"0 "}},{"$f":"IF(L36<>0,100%,\" \")","v":" "}]
[]
[null,"Solde annuel   (Ressources - Emplois)",{"$nulls":3},{"$f":"F36-F21","v":{"v":0,"d":"0 "}},null,null,{"$f":"I36-I21","v":{"v":0,"d":"0 "}},null,null,{"$f":"L36-L21","v":{"v":0,"d":"0 "}}]
[null,"Solde cumulé",{"$nulls":3},{"$f":"IF(existant=\"oui\",'Plan de financement'!F38+tr0_positive+tro_négative,'Plan de financement'!F38)","v":{"v":0,"d":"0 "}},null,null,{"$f":"F39+I38","v":{"v":0,"d":"0 "}},null,null,{"$f":"I39+L38","v":{"v":0,"d":"0 "}}]
[null,{"$f":"IF(AND(ISBLANK(D39),existant=\"oui\"),\"N'oubliez pas de renseigner le solde de trésorerie\",\" \")","v":" "},null,{"$f":"IF(AND(ISBLANK(D39),existant=\"oui\"),'Invest. - caf - Bfr'!H93,\" \")","v":" "}]