{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Synthèse","Rentabilité 1er projet","Rentabilité 2ème projet","Rentabilité 3ème projet"],"not_rendered":{"defined_names":38,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Synthèse","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"merged":[[1,1,1,10],[3,1,3,10],[6,2,6,3],[11,2,11,3],[16,2,16,3]]}
[]
[null,"Synthèse : rentabilité économique des projets d'investissements"]
[]
[null,"Le terme \"rentabilité économique\" concerne la rentabilité avant financement"]
[]
[]
[null,null,"Projet d'investissements",null,null,{"$f":"IF(ISBLANK(projet_1),\" \",projet_1)","v":" "},null,{"$f":"IF(ISBLANK(projet_2),\" \",projet_2)","v":" "},null,{"$f":"IF(ISBLANK(projet_3),\" \",projet_3)","v":" "},null,"Commentaire"]
[]
[null,null,"Coût total de l'investissement",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"IF(a=0,\" \",a)","v":" "},null,{"$f":"IF(a_1=0,\" \",a_1)","v":" "},null,{"$f":"IF(a_2=0,\" \",a_2)","v":" "}]
[null,null,"Durée d'utilisation prévue",null,null,{"$f":"IF(ISBLANK(d),\" \",d)","v":" "},null,{"$f":"IF(ISBLANK(d_1),\" \",d_1)","v":" "},null,{"$f":"IF(ISBLANK(d_2),\" \",d_2)","v":" "}]
[null,null,"Cash-flow prévus",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"cf","v":{"v":0,"d":"0 "}},null,{"$f":"cf_1","v":{"v":0,"d":"0 "}},null,{"$f":"cf_2","v":{"v":0,"d":"0 "}}]
[null,null,"Taux d'actualisation",null,null,{"$f":"tx","v":{"v":0,"d":"0.00%"}},null,{"$f":"tx_1","v":{"v":0,"d":"0.00%"}},null,{"$f":"tx_2","v":{"v":0,"d":"0.00%"}},null,"Commentaire"]
[null,null,"Cash-flow actualisés",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"cfa","v":{"v":0,"d":"0 "}},null,{"$f":"cfa_1","v":{"v":0,"d":"0 "}},null,{"$f":"cfa_2","v":{"v":0,"d":"0 "}},null,"Commentaire"]
[null,null,"Capital investi récupéré au cours de"," ->",null,{"$f":"_r","v":{"v":0,"d":"la 0° année"}},null,{"$f":"r_1","v":{"v":0,"d":"la 0° année"}},null,{"$f":"r_2","v":{"v":0,"d":"la 0° année"}},null,"Commentaire"]
[null,null,"Valeur actuelle nette",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"IF(ISERROR(F13-F9),\" \",F13-F9)","v":" "},null,{"$f":"IF(ISERROR(H13-H9),\" \",H13-H9)","v":" "},null,{"$f":"IF(ISERROR(J13-J9),\" \",J13-J9)","v":" "},null,"Commentaire"]
[null,null,"Annuité équivalente correspondante",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"IF(ISERROR(IF(a=0,\" \",(F15*F12)/(1-(POWER((1+F12),-F10))))),\" \",IF(a=0,\" \",(F15*F12)/(1-(POWER((1+F12),-F10)))))","v":" "},null,{"$f":"IF(ISERROR(IF(a_1=0,\" \",(H15*H12)/(1-(POWER((1+H12),-H10))))),\" \",IF(a_1=0,\" \",(H15*H12)/(1-(POWER((1+H12),-H10)))))","v":" "},null,{"$f":"IF(ISERROR(IF(a_2=0,\" \",(J15*J12)/(1-(POWER((1+J12),-J10))))),\" \",IF(a_2=0,\" \",(J15*J12)/(1-(POWER((1+J12),-J10)))))","v":" "},null,"Commentaire"]
[null,null,"Indice de profitabilité ( > 1 )",null,null,{"$f":"IF(ISERROR(IF(F9=0,\" \",ROUND(F13/a,3))),\" \",IF(F9=0,\" \",ROUND(F13/a,3)))","v":" "},null,{"$f":"IF(ISERROR(IF(H9=0,\" \",ROUND(H13/a_1,3))),\" \",IF(H9=0,\" \",ROUND(H13/a_1,3)))","v":" "},null,{"$f":"IF(ISERROR(IF(J9=0,\" \",ROUND(J13/a_2,3))),\" \",IF(J9=0,\" \",ROUND(J13/a_2,3)))","v":" "},null,"Commentaire"]
[null,null,"Taux de profitabilité","%",null,{"$f":"IF(ISERROR(F15/F9),\" \",F15/F9)","v":" "},null,{"$f":"IF(ISERROR(H15/H9),\" \",H15/H9)","v":" "},null,{"$f":"IF(ISERROR(J15/J9),\" \",J15/J9)","v":" "}]
[null,null,"Taux de rentabilité interne","%",null,{"$f":"tri","v":" "},null,{"$f":"tri_1","v":" "},null,{"$f":"tri_2","v":" "},null,"Commentaire"]

{"sheet":"Rentabilité 1er projet","index":1,"n_rows":34,"n_cols":28,"rows_kept":34,"merged":[[1,2,1,3],[1,5,1,7],[1,9,1,10],[1,12,1,17],[3,2,3,4],[5,2,6,3],[5,4,6,7],[5,8,6,8],[5,9,5,10],[6,9,6,10],[8,4,8,5],[8,7,8,12],[10,1,10,3],[10,7,10,10],[11,1,11,4],[11,7,11,11],[12,1,12,4],[12,7,12,11],[13,1,13,4],[13,7,13,11],[14,1,14,4],[14,7,14,11],[15,1,15,4],[15,7,15,11],[16,1,16,4],[16,7,16,11],[17,1,17,4],[17,7,17,11],[18,1,18,4],[18,7,18,11],[19,1,19,4],[19,7,19,11],[20,1,20,4],[20,7,20,11],[21,1,21,4],[21,10,21,11],[22,1,22,4],[22,7,22,9],[23,1,23,4],[23,7,23,11],[24,1,24,4],[24,7,24,9],[25,1,25,3],[25,7,25,9],[27,1,27,3],[27,7,27,9],[29,1,29,3],[31,1,31,3],[31,4,31,5],[33,1,33,3],[33,4,33,5]]}
[]
[null,"A lire","Taux d'actualisation de base : ",null,null,"Niveau de risque :  ",{"$nulls":3},"Taux effectif retenu :",null,{"$f":"IF(ISBLANK(tb),0,IF(I2=\"nul\",tb+1%,IF(I2=\"faible\",tb+3%,IF(I2=\"moyen\",tb+5%,IF(I2=\"élevé\",tb+10%,0)))))","v":{"v":0,"d":"0.00%"}},{"$f":"IF(AND(tb>0,ISBLANK(I2)),\"Vous devez obligatoirement renseigner le niveau de risque\",\" \")","v":" "}]
[]
[null,{"$f":"IF(AND(ISBLANK(tb),a>0),1,0)","v":0},{"$f":"IF(AND(ISBLANK(tb),a>0),\"renseigner le taux d'actualisation ci-dessus\",\" \")","v":" "},{"$nulls":8},{"$f":"IF(da>d,1,0)","v":0}]
[]
[null," 1er",null,null,"Durée d'utilisation prévue : ",{"$nulls":4}," Amortissement dégressif ? ",null,null,{"$f":"IF(L6=\"Oui\",a,0)","v":{"v":0,"d":"0 "}},{"$f":"M6-M7","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"V6-V7","v":{"v":0,"d":"0 "}},{"$f":"W6-W7","v":{"v":0,"d":"0 "}},{"$f":"X6-X7","v":{"v":0,"d":"0 "}},{"$f":"Y6-Y7","v":{"v":0,"d":"0 "}},{"$f":"Z6-Z7","v":{"v":0,"d":"0 "}}]
[null," projet",{"$nulls":7},{"$f":"IF(ISBLANK(L6),\" \",IF(L6=\"Non\",\" \",\" Durée d'amortissement  :\"))","v":" "},null,null,{"$f":"IF(da=0,0,IF(M6=0,0,IF(L6=\"Oui\",(M6/da)*k,0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(N6=0,0,IF(L6=\"Oui\",MAX(N6/(da-M11),(N6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(O6=0,0,IF(L6=\"Oui\",MAX(O6/(da-N11),(O6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(P6=0,0,IF(L6=\"Oui\",MAX(P6/(da-O11),(P6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(Q6=0,0,IF(L6=\"Oui\",MAX(Q6/(da-P11),(Q6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(R6=0,0,IF(L6=\"Oui\",MAX(R6/(da-Q11),(R6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(S6=0,0,IF(L6=\"Oui\",MAX(S6/(da-R11),(S6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(T6=0,0,IF(L6=\"Oui\",MAX(T6/(da-S11),(T6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(U6=0,0,IF(L6=\"Oui\",MAX(U6/(da-T11),(U6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(V6=0,0,IF(L6=\"Oui\",MAX(V6/(da-U11),(V6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(W6=0,0,IF(L6=\"Oui\",MAX(W6/(da-V11),(W6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(X6=0,0,IF(L6=\"Oui\",MAX(X6/(da-W11),(X6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(Y6=0,0,IF(L6=\"Oui\",MAX(Y6/(da-X11),(Y6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(Z6=0,0,IF(L6=\"Oui\",MAX(Z6/(da-Y11),(Z6/da)*k),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da=0,0,IF(AA6=0,0,IF(L6=\"Oui\",MAX(AA6/(da-Z11),(AA6/da)*k),0)))","v":{"v":0,"d":"0 "}}]
[]
[null,{"$f":"IF(AND(ISBLANK(UM),F12>0),1,\" \")","v":" "},null,null,{"$f":"IF(AND(F12>0,ISBLANK(UM)),\"Unité monétaire ?\",\" \")","v":" "},null,null,{"$f":"IF(AND(L6=\"Oui\",L7>d),\"la durée d'amortissement ne peut pas être > à la durée d'utilisation\",\" \")","v":" "}]
[]
[null,"Dépenses d'investissement ",null,null,"HT","€",null,"Produits - charges    (HT)",{"$nulls":3},{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"v":1,"d":"An 1"},{"v":2,"d":"An 2"},{"v":3,"d":"An 3"},{"v":4,"d":"An 4"},{"v":5,"d":"An 5"},{"v":6,"d":"An 6"},{"v":7,"d":"An 7"},{"v":8,"d":"An 8"},{"v":9,"d":"An 9"},{"v":10,"d":"An 10"},{"v":11,"d":"An 11"},{"v":12,"d":"An 12"},{"v":13,"d":"An 13"},{"v":14,"d":"An 14"},{"v":15,"d":"An 15"},"Total"]
[null," Prix d'achat",{"$nulls":5},"Chiffre d'affaires réalisé ou économie générée",{"$nulls":19},{"$f":"SUM(M12:AA12)","v":{"v":0,"d":"0 "}}]
[null," Frais de transport",{"$nulls":5},"Valeur résiduelle",{"$nulls":19},{"$f":"SUM(M13:AA13)","v":{"v":0,"d":"0 "}}]
[null," Frais d'installation et mise en service",{"$nulls":5},"Total des produits imputables au projet",{"$nulls":4},{"$f":"SUM(M12:M13)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(W12:W13)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null," Réorganisation",{"$nulls":5},"Consommables",{"$nulls":19},{"$f":"SUM(M15:AA15)","v":{"v":0,"d":"0 "}}]
[null," Formation du personnel",{"$nulls":5},"Frais d'entretien - maintenance",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Coût de démontage de l'ancien matériel",{"$nulls":5},"Energie",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Coût de démolition",{"$nulls":5},"Assurance",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Autres frais accessoire",{"$nulls":5},"Personnel",{"$nulls":19},{"v":0,"d":"0 "}]
[{"$nulls":7},"Intérêts",{"$nulls":19},{"v":0,"d":"0 "}]
[{"$nulls":7},"Amortissement économique",{"$nulls":4},{"$f":"IF(M11>d,0,a/d)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(W11>d,0,a/d)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":7},"Amort dérogatoire",null,null,{"$f":"IF(da<3,0,IF(da<5,1.25,IF(da<6.67,1.75,2.25)))","v":{"v":0,"d":"Coefficient : 0.00"}},null,{"$f":"IF(L6=\"Oui\",M7-M21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",N7-N21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",O7-O21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",P7-P21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",Q7-Q21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",R7-R21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",S7-S21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",T7-T21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",U7-U21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",V7-V21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",W7-W21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",X7-X21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",Y7-Y21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",Z7-Z21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",AA7-AA21,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
[null," Subvention reçue (-)",{"$nulls":5},"Impôt sur les bénéfices",null,null,"Taux :",null,{"$f":"ROUND(IF(M14>SUM(M15:M22),(M14-SUM(M15:M22))*$L$23,0),2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"ROUND(IF(W14>SUM(W15:W22),(W14-SUM(W15:W22))*$L$23,0),2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null," Valeur de revente de l'ancien matériel (-)",{"$nulls":5},"Total des charges induites par le projet",{"$nulls":4},{"$f":"SUM(M15:M23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(W15:W23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":7},"Cash-flow prévus",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"-a","v":{"v":0,"d":"0 "}},{"$f":"M14-M24+M21+M22","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"W14-W24+W21+W22","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M25:AA25)","v":{"v":0,"d":"0 "}}]
[null," Coût du 1er projet",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"SUM(F12:F25)","v":{"v":0,"d":"0 "}},null,"Cash-flow actualisés",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"M25/(POWER((1+tx),M11))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"W25/(POWER((1+tx),W11))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M26:AA26)","v":{"v":0,"d":"0 "}}]
[]
[null,"Valeur actualisée des cash-flow",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"AA28","v":{"v":0,"d":"0 "}},null,"Cumul des cash-flow actualisés",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"M26","v":{"v":0,"d":"0 "}},{"$f":"M28+N26","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"V28+W26","v":{"v":0,"d":"0 "}},{"$f":"W28+X26","v":{"v":0,"d":"0 "}},{"$f":"X28+Y26","v":{"v":0,"d":"0 "}},{"$f":"Y28+Z26","v":{"v":0,"d":"0 "}},{"$f":"Z28+AA26","v":{"v":0,"d":"0 "}},{"$f":"IF(AB26=AA28,\"ok\",AB26-AA28)","v":"ok"}]
[]
[null," Valeur actuelle nette",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"F28-F26","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"IF(a=0,\" \",IF(M28=0,0,IF(M28<a,0,M11)))","v":" "},{"$f":"IF(N28<a,0,IF(M30>0,\" \",N11))","v":" "}," "," "," "," "," "," "," "," ",{"$f":"IF(W28<a,0,IF(V30>0,\" \",W11))","v":" "},{"$f":"IF(X28<a,0,IF(W30>0,\" \",X11))","v":" "},{"$f":"IF(Y28<a,0,IF(X30>0,\" \",Y11))","v":" "},{"$f":"IF(Z28<a,0,IF(Y30>0,\" \",Z11))","v":" "},{"$f":"IF(AA28<a,0,IF(Z30>0,\" \",AA11))","v":" "}]
[]
[null," Année de récupération du capital investi",null,null,{"$f":"SUM(M30:AA30)","v":{"v":0,"d":"0 ème année"}}]
[]
[null," Taux de rentabité interne du projet",null,null,{"$f":"IF(a=0,\" \",IRR(L25:AA25))","v":" "}]

{"sheet":"Rentabilité 2ème projet","index":2,"n_rows":34,"n_cols":28,"rows_kept":34,"merged":[[0,1,0,4],[1,2,1,3],[1,5,1,7],[1,9,1,10],[1,12,1,17],[3,2,3,4],[5,2,6,3],[5,4,6,7],[5,8,6,8],[5,9,5,10],[6,9,6,10],[8,1,8,5],[8,7,8,12],[10,1,10,3],[10,7,10,10],[11,1,11,4],[11,7,11,11],[12,1,12,4],[12,7,12,11],[13,1,13,4],[13,7,13,11],[14,1,14,4],[14,7,14,11],[15,1,15,4],[15,7,15,11],[16,1,16,4],[16,7,16,11],[17,1,17,4],[17,7,17,11],[18,1,18,4],[18,7,18,11],[19,1,19,4],[19,7,19,11],[20,1,20,4],[20,7,20,11],[21,1,21,4],[21,10,21,11],[22,1,22,4],[22,7,22,9],[23,1,23,4],[23,7,23,11],[24,1,24,4],[24,7,24,9],[25,1,25,3],[25,7,25,9],[27,1,27,3],[27,7,27,9],[29,1,29,3],[29,7,29,11],[31,1,31,3],[31,4,31,5],[33,1,33,3],[33,4,33,5]]}
[null,{"$f":"IF(ISBLANK(tb),\"Ce taux est à renseigner dans l'onglet du 1er projet\",\" \")","v":"Ce taux est à renseigner dans l'onglet du 1er projet"}]
[null,"A lire","Taux d'actualisation de base : ",null,{"$f":"tb","v":{"v":0,"d":"0.00%"}},"Niveau de risque :  ",{"$nulls":3},"Taux effectif retenu :",null,{"$f":"IF(ISBLANK(tb),0,IF(I2=\"nul\",tb+1%,IF(I2=\"faible\",tb+3%,IF(I2=\"moyen\",tb+5%,IF(I2=\"élevé\",tb+10%,0)))))","v":{"v":0,"d":"0.00%"}},{"$f":"IF(AND(tb>0,ISBLANK(I2)),\"Vous devez obligatoirement renseigner le niveau de risque\",\" \")","v":" "}]
[]
[null,{"$f":"IF(AND(ISBLANK(tb),a_1>0),1,0)","v":0},{"$f":"IF(AND(ISBLANK(tb),a_1>0),\"renseigner le taux d'actualisation ci-dessus\",\" \")","v":" "},{"$nulls":8},{"$f":"IF(da_1>d_1,1,0)","v":0}]
[]
[null," 2ème",null,null,"Durée d'utilisation prévue : ",{"$nulls":4}," Amortissement dégressif ?",null,null,{"$f":"IF(L6=\"Oui\",a_1,0)","v":{"v":0,"d":"0 "}},{"$f":"M6-M7","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"V6-V7","v":{"v":0,"d":"0 "}},{"$f":"W6-W7","v":{"v":0,"d":"0 "}},{"$f":"X6-X7","v":{"v":0,"d":"0 "}},{"$f":"Y6-Y7","v":{"v":0,"d":"0 "}},{"$f":"Z6-Z7","v":{"v":0,"d":"0 "}}]
[null," projet"," ",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\" \",IF(L6=\"Non\",\" \",\" Durée d'amortissement  :\"))","v":" "},null,null,{"$f":"IF(da_1=0,0,IF(M6=0,0,IF(L6=\"Oui\",(M6/da_1)*k_1,0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(N6=0,0,IF(L6=\"Oui\",MAX(N6/(da_1-M11),(N6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(O6=0,0,IF(L6=\"Oui\",MAX(O6/(da_1-N11),(O6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(P6=0,0,IF(L6=\"Oui\",MAX(P6/(da_1-O11),(P6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(Q6=0,0,IF(L6=\"Oui\",MAX(Q6/(da_1-P11),(Q6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(R6=0,0,IF(L6=\"Oui\",MAX(R6/(da_1-Q11),(R6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(S6=0,0,IF(L6=\"Oui\",MAX(S6/(da_1-R11),(S6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(T6=0,0,IF(L6=\"Oui\",MAX(T6/(da_1-S11),(T6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(U6=0,0,IF(L6=\"Oui\",MAX(U6/(da_1-T11),(U6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(V6=0,0,IF(L6=\"Oui\",MAX(V6/(da_1-U11),(V6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(W6=0,0,IF(L6=\"Oui\",MAX(W6/(da_1-V11),(W6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(X6=0,0,IF(L6=\"Oui\",MAX(X6/(da_1-W11),(X6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(Y6=0,0,IF(L6=\"Oui\",MAX(Y6/(da_1-X11),(Y6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(Z6=0,0,IF(L6=\"Oui\",MAX(Z6/(da_1-Y11),(Z6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_1=0,0,IF(AA6=0,0,IF(L6=\"Oui\",MAX(AA6/(da_1-Z11),(AA6/da_1)*k_1),0)))","v":{"v":0,"d":"0 "}}]
[]
[null,{"$f":"IF(AND(ISBLANK(UM),a_1>0),\"renseigner l'unité monétaire retenue dans l'onglet du 1er projet\",\" \")","v":" "},{"$nulls":5},{"$f":"IF(AND(L6=\"Oui\",L7>d_1),\"la durée d'amortissement ne peut pas être > à la durée d'utilisation\",\" \")","v":" "}]
[]
[null,"Dépenses d'investissement ",null,null,"HT",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,"Produits - charges    (HT)",{"$nulls":3},{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"v":1,"d":"An 1"},{"v":2,"d":"An 2"},{"v":3,"d":"An 3"},{"v":4,"d":"An 4"},{"v":5,"d":"An 5"},{"v":6,"d":"An 6"},{"v":7,"d":"An 7"},{"v":8,"d":"An 8"},{"v":9,"d":"An 9"},{"v":10,"d":"An 10"},{"v":11,"d":"An 11"},{"v":12,"d":"An 12"},{"v":13,"d":"An 13"},{"v":14,"d":"An 14"},{"v":15,"d":"An 15"},"Total"]
[null," Prix d'achat",{"$nulls":5},"Chiffre d'affaires réalisé ou économie générée",{"$nulls":19},{"$f":"SUM(M12:AA12)","v":{"v":0,"d":"0 "}}]
[null," Frais de transport",{"$nulls":5},"Valeur résiduelle",{"$nulls":19},{"$f":"SUM(M13:AA13)","v":{"v":0,"d":"0 "}}]
[null," Frais d'installation et mise en service",{"$nulls":5},"Total des produits imputables au projet",{"$nulls":4},{"$f":"SUM(M12:M13)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(W12:W13)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(AB12:AB13)","v":{"v":0,"d":"0 "}}]
[null," Réorganisation",{"$nulls":5},"Consommables",{"$nulls":19},{"$f":"SUM(M15:AA15)","v":{"v":0,"d":"0 "}}]
[null," Formation du personnel",{"$nulls":5},"Frais d'entretien",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Coût de démontage de l'ancien matériel",{"$nulls":5},"Energie",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Coût de démolition",{"$nulls":5},"Assurance",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Autres frais accessoire",{"$nulls":5},"Personnel",{"$nulls":19},{"v":0,"d":"0 "}]
[{"$nulls":7},"Intérêts",{"$nulls":19},{"v":0,"d":"0 "}]
[{"$nulls":7},"Amortissement économique",{"$nulls":4},{"$f":"IF(M11>d_1,0,a_1/d_1)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(W11>d_1,0,a_1/d_1)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":7},"Amort dérogatoire",null,null,{"$f":"IF(da_1<3,0,IF(da_1<5,1.25,IF(da_1<6.67,1.75,2.25)))","v":{"v":0,"d":"Coefficient : 0.00"}},null,{"$f":"IF(L6=\"Oui\",M7-M21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",N7-N21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",O7-O21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",P7-P21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",Q7-Q21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",R7-R21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",S7-S21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",T7-T21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",U7-U21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",V7-V21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",W7-W21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",X7-X21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",Y7-Y21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",Z7-Z21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",AA7-AA21,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
[null," Subvention reçue (-)",{"$nulls":5},"Impôt sur les bénéfices",null,null,"Taux :",null,{"$f":"ROUND(IF(M14>SUM(M15:M22),(M14-SUM(M15:M22))*$L$23,0),2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"ROUND(IF(W14>SUM(W15:W22),(W14-SUM(W15:W22))*$L$23,0),2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null," Valeur de revente de l'ancien matériel (-)",{"$nulls":5},"Total des charges induites par le projet",{"$nulls":4},{"$f":"SUM(M15:M23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(W15:W23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(AB15:AB23)","v":{"v":0,"d":"0 "}}]
[{"$nulls":7},"Cash-flow prévus",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"-a_1","v":{"v":0,"d":"0 "}},{"$f":"M14-M24+M21+M22","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"W14-W24+W21+W22","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M25:AA25)","v":{"v":0,"d":"0 "}}]
[null,"Coût du 2ème projet",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"SUM(F12:F25)","v":{"v":0,"d":"0 "}},null,"Cash-flow actualisés",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"M25/(POWER((1+tx_1),M11))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"W25/(POWER((1+tx_1),W11))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M26:AA26)","v":{"v":0,"d":"0 "}}]
[]
[null,"Valeur actualisée des cash-flow",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"AA28","v":{"v":0,"d":"0 "}},null,"Cumul des cash-flow actualisés",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"M26","v":{"v":0,"d":"0 "}},{"$f":"M28+N26","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"V28+W26","v":{"v":0,"d":"0 "}},{"$f":"W28+X26","v":{"v":0,"d":"0 "}},{"$f":"X28+Y26","v":{"v":0,"d":"0 "}},{"$f":"Y28+Z26","v":{"v":0,"d":"0 "}},{"$f":"Z28+AA26","v":{"v":0,"d":"0 "}},{"$f":"IF(AB26=AA28,\"ok\",AB26-AA28)","v":"ok"}]
[]
[null," Valeur actuelle nette",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"F28-F26","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"IF(a_1=0,\" \",IF(M28=0,0,IF(M28<a_1,0,M11)))","v":" "},{"$f":"IF(N28<a_1,0,IF(M30>0,\" \",N11))","v":" "}," "," "," "," "," "," "," "," ",{"$f":"IF(W28<a_1,0,IF(V30>0,\" \",W11))","v":" "},{"$f":"IF(X28<a_1,0,IF(W30>0,\" \",X11))","v":" "},{"$f":"IF(Y28<a_1,0,IF(X30>0,\" \",Y11))","v":" "},{"$f":"IF(Z28<a_1,0,IF(Y30>0,\" \",Z11))","v":" "},{"$f":"IF(AA28<a_1,0,IF(Z30>0,\" \",AA11))","v":" "}]
[]
[null," Année de récupération du capital investi",null,null,{"$f":"SUM(M30:AA30)","v":{"v":0,"d":"0 ème année"}}]
[]
[null," Taux de rentabité interne du projet",null,null,{"$f":"IF(a_1=0,\" \",IRR(L25:AA25))","v":" "}]

{"sheet":"Rentabilité 3ème projet","index":3,"n_rows":34,"n_cols":28,"rows_kept":34,"merged":[[0,1,0,4],[1,2,1,3],[1,5,1,7],[1,9,1,10],[1,12,1,17],[3,2,3,4],[5,2,6,3],[5,4,6,7],[5,8,6,8],[5,9,5,10],[6,9,6,10],[8,1,8,5],[8,7,8,12],[10,1,10,3],[10,7,10,10],[11,1,11,4],[11,7,11,11],[12,1,12,4],[12,7,12,11],[13,1,13,4],[13,7,13,11],[14,1,14,4],[14,7,14,11],[15,1,15,4],[15,7,15,11],[16,1,16,4],[16,7,16,11],[17,1,17,4],[17,7,17,11],[18,1,18,4],[18,7,18,11],[19,1,19,4],[19,7,19,11],[20,1,20,4],[20,7,20,11],[21,1,21,4],[21,10,21,11],[22,1,22,4],[22,7,22,9],[23,1,23,4],[23,7,23,11],[24,1,24,4],[24,7,24,9],[25,1,25,3],[25,7,25,9],[27,1,27,3],[27,7,27,9],[29,1,29,3],[31,1,31,3],[31,4,31,5],[33,1,33,3],[33,4,33,5]]}
[null,{"$f":"IF(ISBLANK(tb),\"Ce taux est à renseigner dans l'onglet du 1er projet\",\" \")","v":"Ce taux est à renseigner dans l'onglet du 1er projet"}]
[null,"A lire","Taux d'actualisation de base :  ",null,{"$f":"tb","v":{"v":0,"d":"0.00%"}},"Niveau de risque :  ",{"$nulls":3},"Taux effectif retenu :",null,{"$f":"IF(ISBLANK(tb),0,IF(I2=\"nul\",tb+1%,IF(I2=\"faible\",tb+3%,IF(I2=\"moyen\",tb+5%,IF(I2=\"élevé\",tb+10%,0)))))","v":{"v":0,"d":"0.00%"}},{"$f":"IF(AND(tb>0,ISBLANK(I2)),\"Vous devez obligatoirement renseigner le niveau de risque\",\" \")","v":" "}]
[]
[null,{"$f":"IF(AND(ISBLANK(tb),a_2>0),1,0)","v":0},{"$f":"IF(AND(ISBLANK(tb),a_2>0),\"renseigner le taux d'actualisation ci-dessus\",\" \")","v":" "},{"$nulls":8},{"$f":"IF(da_2>d_2,1,0)","v":0}]
[]
[null," 3ème",null,null,"Durée d'utilisation prévue : ",{"$nulls":4}," Amortissement dégressif ?",null,null,{"$f":"IF(L6=\"Oui\",a_2,0)","v":{"v":0,"d":"0 "}},{"$f":"M6-M7","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"V6-V7","v":{"v":0,"d":"0 "}},{"$f":"W6-W7","v":{"v":0,"d":"0 "}},{"$f":"X6-X7","v":{"v":0,"d":"0 "}},{"$f":"Y6-Y7","v":{"v":0,"d":"0 "}},{"$f":"Z6-Z7","v":{"v":0,"d":"0 "}}]
[null," projet",{"$nulls":7},{"$f":"IF(ISBLANK(L6),\" \",IF(L6=\"Non\",\" \",\" Durée d'amortissement  :\"))","v":" "},null,null,{"$f":"IF(da_2=0,0,IF(M6=0,0,IF(L6=\"Oui\",(M6/da_2)*k_2,0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(N6=0,0,IF(L6=\"Oui\",MAX(N6/(da_2-M11),(N6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(O6=0,0,IF(L6=\"Oui\",MAX(O6/(da_2-N11),(O6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(P6=0,0,IF(L6=\"Oui\",MAX(P6/(da_2-O11),(P6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(Q6=0,0,IF(L6=\"Oui\",MAX(Q6/(da_2-P11),(Q6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(R6=0,0,IF(L6=\"Oui\",MAX(R6/(da_2-Q11),(R6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(S6=0,0,IF(L6=\"Oui\",MAX(S6/(da_2-R11),(S6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(T6=0,0,IF(L6=\"Oui\",MAX(T6/(da_2-S11),(T6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(U6=0,0,IF(L6=\"Oui\",MAX(U6/(da_2-T11),(U6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(V6=0,0,IF(L6=\"Oui\",MAX(V6/(da_2-U11),(V6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(W6=0,0,IF(L6=\"Oui\",MAX(W6/(da_2-V11),(W6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(X6=0,0,IF(L6=\"Oui\",MAX(X6/(da_2-W11),(X6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(Y6=0,0,IF(L6=\"Oui\",MAX(Y6/(da_2-X11),(Y6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(Z6=0,0,IF(L6=\"Oui\",MAX(Z6/(da_2-Y11),(Z6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}},{"$f":"IF(da_2=0,0,IF(AA6=0,0,IF(L6=\"Oui\",MAX(AA6/(da_2-Z11),(AA6/da_2)*k_2),0)))","v":{"v":0,"d":"0 "}}]
[]
[null,{"$f":"IF(AND(ISBLANK(UM),a_2>0),\"renseigner l'unité monétaire retenue dans l'onglet du 1er projet\",\" \")","v":" "},{"$nulls":5},{"$f":"IF(AND(L6=\"Oui\",L7>d_2),\"la durée d'amortissement ne peut pas être > à la durée d'utilisation\",\" \")","v":" "}]
[]
[null,"Dépenses d'investissement ",null,null,"HT",{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,"Produits - charges    (HT)",{"$nulls":3},{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"v":1,"d":"An 1"},{"v":2,"d":"An 2"},{"v":3,"d":"An 3"},{"v":4,"d":"An 4"},{"v":5,"d":"An 5"},{"v":6,"d":"An 6"},{"v":7,"d":"An 7"},{"v":8,"d":"An 8"},{"v":9,"d":"An 9"},{"v":10,"d":"An 10"},{"v":11,"d":"An 11"},{"v":12,"d":"An 12"},{"v":13,"d":"An 13"},{"v":14,"d":"An 14"},{"v":15,"d":"An 15"},"Total"]
[null," Prix d'achat",{"$nulls":5},"Chiffre d'affaires réalisé ou économie générée",{"$nulls":19},{"$f":"SUM(M12:AA12)","v":{"v":0,"d":"0 "}}]
[null," Frais de transport",{"$nulls":5},"Valeur résiduelle",{"$nulls":19},{"$f":"SUM(M13:AA13)","v":{"v":0,"d":"0 "}}]
[null," Frais d'installation et mise en service",{"$nulls":5},"Total des produits imputables au projet",{"$nulls":4},{"$f":"SUM(M12:M13)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(W12:W13)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null," Réorganisation",{"$nulls":5},"Consommables",{"$nulls":19},{"$f":"SUM(M15:AA15)","v":{"v":0,"d":"0 "}}]
[null," Formation du personnel",{"$nulls":5},"Frais d'entretien",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Coût de démontage de l'ancien matériel",{"$nulls":5},"Energie",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Coût de démolition",{"$nulls":5},"Assurance",{"$nulls":19},{"v":0,"d":"0 "}]
[null," Autres frais accessoire",{"$nulls":5},"Personnel",{"$nulls":19},{"v":0,"d":"0 "}]
[{"$nulls":7},"Intérêts",{"$nulls":19},{"v":0,"d":"0 "}]
[{"$nulls":7},"Amortissement économique",{"$nulls":4},{"$f":"IF(M11>d_2,0,a_2/d_2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(W11>d_2,0,a_2/d_2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":7},"Amort dérogatoire",null,null,{"$f":"IF(da_2<3,0,IF(da_2<5,1.25,IF(da_2<6.67,1.75,2.25)))","v":{"v":0,"d":"Coefficient : 0.00"}},null,{"$f":"IF(L6=\"Oui\",M7-M21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",N7-N21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",O7-O21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",P7-P21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",Q7-Q21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",R7-R21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",S7-S21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",T7-T21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",U7-U21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(L6=\"Oui\",V7-V21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",W7-W21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",X7-X21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",Y7-Y21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",Z7-Z21,0)","v":{"v":0,"d":"0 "}},{"$f":"IF(Q6=\"Oui\",AA7-AA21,0)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
[null," Subvention reçue (-)",{"$nulls":5},"Impôt sur les bénéfices",null,null,"Taux :",null,{"$f":"ROUND(IF(M14>SUM(M15:M22),(M14-SUM(M15:M22))*$L$23,0),2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"ROUND(IF(W14>SUM(W15:W22),(W14-SUM(W15:W22))*$L$23,0),2)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null," Valeur de revente de l'ancien matériel (-)",{"$nulls":5},"Total des charges induites par le projet",{"$nulls":4},{"$f":"SUM(M15:M23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(W15:W23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":7},"Cash-flow prévus",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"-a_2","v":{"v":0,"d":"0 "}},{"$f":"M14-M24+M21+M22","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"W14-W24+W21+W22","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M25:AA25)","v":{"v":0,"d":"0 "}}]
[null,"Coût du 3ème projet",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"SUM(F11:F25)","v":{"v":0,"d":"0 "}},null,"Cash-flow actualisés",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"M25/(POWER((1+tx_2),M11))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"W25/(POWER((1+tx_2),W11))","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(M26:AA26)","v":{"v":0,"d":"0 "}}]
[]
[null,"Valeur actualisée des cash-flow",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"AA28","v":{"v":0,"d":"0 "}},null,"Cumul des cash-flow actualisés",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},null,{"$f":"M26","v":{"v":0,"d":"0 "}},{"$f":"M28+N26","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"V28+W26","v":{"v":0,"d":"0 "}},{"$f":"W28+X26","v":{"v":0,"d":"0 "}},{"$f":"X28+Y26","v":{"v":0,"d":"0 "}},{"$f":"Y28+Z26","v":{"v":0,"d":"0 "}},{"$f":"Z28+AA26","v":{"v":0,"d":"0 "}},{"$f":"IF(AB26=AA28,\"ok\",AB26-AA28)","v":"ok"}]
[]
[null," Valeur actuelle nette",null,null,{"$f":"IF(ISBLANK(UM),\" \",UM)","v":"€"},{"$f":"F28-F26","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"IF(a_2=0,\" \",IF(M28<a_2,0,M11))","v":" "},{"$f":"IF(N28<a_2,0,IF(M30>0,\" \",N11))","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[]
[null," Année de récupération du capital investi",null,null,{"$f":"SUM(M30:AA30)","v":{"v":0,"d":"0 ème année"}}]
[]
[null," Taux de rentabité interne du projet",null,null,{"$f":"IF(a_2=0,\" \",IRR(L25:AA25))","v":" "}]