{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Table rentabilité","Remboursement Mensualités","investissement réel","Modèles envisagés (ex.arachide)"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Table rentabilité","index":0,"n_rows":219,"n_cols":23,"rows_kept":219,"cut":false,"hidden":false,"merged":[[62,1,63,1],[62,7,63,7],[64,1,65,1],[64,7,65,7],[23,3,24,3],[23,2,24,2],[23,5,24,5],[23,7,24,7],[23,6,24,6],[23,11,24,11],[23,8,24,8],[16,6,17,6],[23,9,23,10],[81,5,81,6],[16,10,17,10],[69,5,69,6],[16,8,16,9],[156,2,156,3],[16,2,17,2],[16,3,16,4],[16,5,17,5],[16,7,17,7],[79,5,79,6],[74,5,74,6],[119,2,119,3],[83,5,83,6],[91,5,91,6],[23,4,24,4]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"PRESSE A HUILE BAOBAB & MORINGA"]
[]
[null,"Dimmensionnement réel"]
[null,"Dimmensionnement optimisé "]
[null,"Dimmensionnement réel"]
[]
[]
[null,"Cases à vérifier"]
[null,"Cases à compléter"]
[null,"Cases à laisser vides"]
[null,"Cases calculées"]
[]
[null,"Caractéristiques techniques du Projet"]
[]
[null,"Usage Productif","Rendement (kg/heure)","Puissance (kW)",null,"Prix (FCFA)","Energie consommée (KWh/j)","Energie à produire (kWh/j)","Fonctionnement optimal",null,"Coefficient déperdition (k)"]
[null,null,null,"Projet","Nominale",null,null,null,"heures par jour","jours à l'année"]
[null,"Presse KK baobab",{"$f":"IF(F81=\"Oui\",G26*60/H26,G27*60/H27)","v":10},0.5,0.5,1967871,{"$f":"IF(F81=\"Oui\",F26*I19*60/H26,F27*I19*60/H27)+1.2","v":3.42},{"$f":"G19/K19","v":6.2181818181818178},{"$f":"F71*F72","v":3},320,0.55000000000000004]
[null,"Presse KK moringa",{"$f":"G28*60/H28","v":2.6666666666666665},0.2,0.2,1967871,{"$f":"(F28*I20*60/H28)+1.2","v":2.5359999999999996},{"$f":"G20/K20","v":4.6109090909090895},{"$f":"F71*G72","v":3},320,0.55000000000000004]
[null,"Dépulpeuse électrique"]
[null,"Moulin solaire",50,null,2,500000,{"$f":"I22*E22","v":2},{"$f":"I22*E22/K22","v":3.3333333333333335},{"$f":"(C19*I19)/(C22*K22)","v":1},null,0.6]
[]
[null,"Huile","Vitesse rotation","Taille buse","Graine ou poudre","Energie (kWh)","Quantité (Kg)","Temps pressage (Min)","Densité","Teneur",null,"Rendement huile (L/kg)"]
[{"$nulls":9},"Huile","Tourteaux"]
[null,"Baobab",50,"16 ou sans","Poudre",7.3999999999999996E-2,1,6,0.91600000000000004,0.09,{"$f":"100%-J26","v":0.91},{"$f":"I26*J26","v":8.2439999999999999E-2}]
[null,"Baobab",50,"16 ou sans","Graines",0.11,1,10,0.91600000000000004,0.05,{"$f":"100%-J27","v":0.95},{"$f":"I27*J27","v":4.5800000000000007E-2}]
[null,"Moringa",50,16,"Graines",0.33400000000000002,2,45,0.90800000000000003,0.25,{"$f":"100%-J28","v":0.75},{"$f":"I28*J28","v":0.22700000000000001}]
[]
[null,"Equipements facultatifs/facultatifs"]
[null,"designation","nombre","prix"]
[null,"Moulin solaire",1,750000]
[null,"Dépulpeuse",1]
[null,"Séchoir solaire",1,3800000]
[null,"Démarreur ",1,147000]
[null,"parafoudre",1,140000]
[null,"Filtre huile",2,100000]
[null,"local",1,1000000]
[null,"Installation",1,1000000]
[null,"Autre: FRA, codes barres, etc.",1,750000]
[null,"Support modules",18,35000]
[null,"Câbles et accessoires ",1,240000]
[null,"Système alimentation continue ",0,0]
[null,"Système de décantation",0,0]
[null,"Certifications (bio, etc.)",0,0]
[]
[null,"Alimentation Solaire","Puissance (kW)","Prix (FCFA)","Coefficient déperdition","Tension (V)",null,"Batteries","Capacité (Ampères/h)","Prix (FCFA)","Tension (V)","Durée de vie*","* en conditions optimales, annoncées constructeur"]
[null,"module polycristatllin 270 Wc",0.27,74750,0.6,"24V",null,"Victron Energy Gel",220,400000,12,10]
[null,"Sharp ND-AC275",0.27500000000000002,80000,0.6,"24V",null,"Victron ",265,327957,12,10]
[null,"BlueSolar SPM-300-24 Monocristallin",0.375,78500,0.6,"24V",null,"Batteries OPZS 1220 (Ah)",1220,194400,2,7]
[{"$nulls":7},"Tension nécessaire système",{"$f":"IF(J51<0.5,12,IF(AND(J51>=0.5,J51<2),24,IF(J51>=2,48)))","v":48},{"$f":"F98*INDEX(C:C,MATCH(F76,B:B,0))","v":4.95}]
[]
[null,"Onduleur","kVa","Prix (FCFA)",null,null,null,"Régulateur","tension(V)_courant(A)","Prix (FCFA)","Tension (V)"]
[null,"Vitron Energy Phoenix",3,450000,null,null,null,"BlueSolar 150V 35A de Victron Energy","150_35",220000,"12V/24V/48V"]
[null,"Victron quatro 5 kW",5,1426500,null,null,null,"victron","100_50",114700,"12V/24V/48V"]
[null,"Xtender",{"$nulls":5},"victron","150_45",650000,"12V/24V/48V"]
[]
[null,"Irradiation Solaire"]
[null,"Month ","Jan ","Feb ","Mar ","Apr ","May ","Jun ","Jul ","Aug ","Sep ","Oct ","Nov ","Dec ","Year"]
[null,"H(15)*",5.12,5.75,6.37,6.61,6.34,6.05,6.26,5.51,6.03,5.81,5.226,5.03,{"$f":"IF('Table rentabilité'!G87=\"x\",MAX(C60:N60),IF('Table rentabilité'!G88=\"x\",MIN(C60:N60),IF('Table rentabilité'!G89=\"x\",AVERAGE(C60:N60),\"erreur\")))","v":5.8421666666666674}]
[]
[null,"Électricité du réseau",null,"1ère Tranche","2ème Tranche","3ème Tranche",null,null,null,"1ère Tranche","2ème Tranche","3ème Tranche","Total"]
[null,"UP-Petite Puissance","Tranche (KWh)",50,500,"∞",null,"UP-Petite Puissance","Energie par Tranche",{"$f":"(F91*30)-SUM(K63:L63)","v":50},{"$f":"IF((F91*30)>D63,(F91*30)-D63-L63,0)","v":188.67999999999998},{"$f":"IF((F91*30)>E63,(F91*30)-E63,0)","v":0},{"$f":"SUM(J63:L63)","v":238.67999999999998}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J63*D64","v":6442.5},{"$f":"K63*E64","v":25600.1024},{"$f":"L63*F64","v":0},{"$f":"SUM(J64:L64)","v":32042.6024}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F91*30)-SUM(K65:L65)","v":100},{"$f":"IF((F91*30)>D65,(F91*30)-D65-L65,0)","v":138.67999999999998},{"$f":"IF((F91*30)>E65,(F91*30)-E65,0)","v":0},238.67999999999998]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J65*D66","v":12981},{"$f":"K65*E66","v":18933.980399999997},0,31914.980399999997]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"Production min. souhaitée (kg graine/jour)",null,null,null,30]
[null,"Temps de fonctionnement (heures)",null,null,null,6]
[null,"Ratio Baobab/Moringa",null,null,null,0.5,{"$f":"100%-F72","v":0.5}]
[null,"Part des graines dans le poids total du fruit de baobab",null,null,null,0.75]
[]
[null,"Choix de la presse",null,null,null,"Presse KK baobab"]
[null,"Choix de l'alimentation solaire",null,null,null,"Sharp ND-AC275"]
[null,"Choix du système de stokage",null,null,null,"Victron Energy Gel"]
[null,"Choix de l'onduleur",null,null,null,"Vitron Energy Phoenix"]
[null,"Choix du régulateur",null,null,null,"BlueSolar 150V 35A de Victron Energy"]
[null,"Choix décortiqueuse solaire"]
[null,"Choix moulin solaire",null,null,null,"Oui"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M64<M66,B63,B65)","v":"UP-Moyenne Puissance"}]
[]
[null,"Autonomie nécessaires au projet (jours)",null,null,null,1]
[null,"Profondeur décharge batteries",null,null,null,0.7]
[]
[null,"Choix du cas pour dimensionnement solaire",null,null,null,"best case"]
[{"$nulls":5},"worst case"]
[{"$nulls":5},"average","x"]
[]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"G19+G20+G22","v":7.9559999999999995},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,4.95]
[null,"Puissance equipements max",null,null,null,{"$f":"(INDEX(E:E,MATCH(F75,B:B,0)) +E22)*1.2","v":3}]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(G19+G20+G21)*1000*(F84)/(F85*I51)","v":177.26190476190476}]
[]
[null,"Nb de presses",null,null,null,{"$f":"ROUNDUP(F70/(C19*I19),0)","v":1},"unités"]
[null,"Nb décortiqueuses",null,null,null,{"$f":"IF(F80<>\"\",1,0)","v":0},"unités"]
[null,"Nb de panneaux solaires",null,null,null,18,"unités","=ARRONDI.SUP(F77/INDEX(C:C;EQUIV(F61;B:B;0));0)"]
[null,"Nb de batteries en série",null,null,null,{"$f":"ROUNDUP(I51/INDEX(K:K,MATCH(F77,H:H,0)),0)","v":4},"unités","=ARRONDI.SUP(I37/INDEX(K:K;EQUIV(F62;H:H;0));0)"]
[null,"Nb de batteries en dérivation",null,null,null,2,"unités","=ARRONDI.SUP(F78/INDEX(I:I;EQUIV(F62;H:H;0));0)"]
[null,"Nb de batteries total",null,null,null,{"$f":"F99*F100","v":8},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,{"$f":"INDEX(L:L,MATCH(F77,H:H,0))*(130%-F85)","v":6.0000000000000009},"ans"]
[null,"Nb onduleurs",null,null,null,{"$f":"ROUNDUP(F93/INDEX(C:C,MATCH(F78,B:B,0)),0)","v":1},"unités","=SI(OU(I37=24;I37=12);1;2)"]
[null,"Nb régulateurs",null,null,null,{"$f":"IF(OR(I51=24,I51=12),1,2)","v":2},"unités"]
[]
[null,"Ratio de fonctionnement ",null,null,null,0.8]
[null,"Employés nécessaires pour fonctionnement",null,null,null,6,"personnes"]
[null,"Extrant annuel attendu en huile de Baobab",null,null,null,{"$f":"IF(F81=\"Oui\",L26*C19*J19*I19*F106*F96,L27*C19*J19*I19*F106*F96)","v":633.13920000000007},"Litres"]
[null,"Extrant annuel attendu en huile de Moringa",null,null,null,{"$f":"L28*C20*J20*I20*F106*F96","v":464.89599999999996},"Litres"]
[null,"Extrant annuel attendu en tourteaux",null,null,null,{"$f":"(IF(F81=\"Oui\",K26*C19*J19*I19,K27*C19*J19*I19)+(K28*C20*J20*I20))*F106*F96","v":8524.8000000000011},"Kilos"]
[null,"Intrant annuel attendu en fruits de Baobab",null,null,null,{"$f":"C19*J19*I19*F106*F96*(1+(100%-F73))","v":9600},"Kilos"]
[null,"Intrant annuel attendu en graines de Moringa",null,null,null,{"$f":"C20*I20*J20*F106*F96","v":2048},"Kilos"]
[null,"Plantation Moringa","plants",null,null,0,"Plants",2,"Kg en moyenne par arbre"]
[null,null,"production",null,null,{"$f":"F113*H113","v":0},"Kilos"]
[null,null,"disponibilité (année)",null,null,2,"ème année"]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION"]
[null,"Désignation","Quantité",null,"Prix unitaire","Montant total/an","Montant total/an avec plantation",null,"évolution annuelle charges d'exploitation",null,null,0.01]
[null,"Graines de Baobab non décortiquées",{"$f":"F111*F73","v":7200},"Kilos",600,{"$f":"E121*C121*L121","v":2808000},{"$f":"E121*C121*L121","v":2808000},null,"Part charges imputables au business de l'huile (Baobab)*",null,null,0.65]
[null,"Graines de Moringa décortiquées",{"$f":"F112","v":2048},"Kilos",2000,{"$f":"E122*C122","v":4096000},{"$f":"(C122-F114)*E122","v":4096000},null,"* La création de Bouye sera gérée par RaS, les charges sont donc réparties "]
[null,"Transport graines",{"$f":"C121/50","v":144},"sacs",200,{"$f":"E123*C123","v":28800},{"$f":"E123*C123","v":28800},null,"entre les 2 projets selon le poids de chaque transformation dans le revenu généré"]
[null,"Conditionnement",{"$f":"SUM(F108:F109)","v":1098.0352},"litres",5421,{"$f":"E124*C124","v":5952448.8191999998},{"$f":"E124*C124","v":5952448.8191999998}]
[null,"Etiquetage",{"$f":"C124*8","v":8784.2816000000003},"étiquettes",262,{"$f":"E125*C125","v":2301481.7792000002},{"$f":"E125*C125","v":2301481.7792000002}]
[null,"Salaires",{"$f":"F107","v":6},{"$f":"G106","v":0},55000,{"$f":"E126*C126*12","v":3960000},{"$f":"E126*C126*12","v":3960000}]
[null,"Logistique Vente",1,"logistique magasins",50000,{"$f":"E127*C127*12","v":600000},{"$f":"E127*C127*12","v":600000},null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"(MIN(M64,M66)*12)-G152","v":-1205107.3351999999}]
[null,"Autre",0,0,0,{"$f":"E128*C128*12","v":0},{"$f":"E128*C128*12","v":0}]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F121:F128)","v":19746730.5984},{"$f":"SUM(G121:G128)","v":19746730.5984},null,null,null,"Sur 5 ans",{"$f":"(MIN(M64,M66)*12*5)-(G152*5)","v":-6025536.675999999}]
[{"$nulls":10},"Sur 9 ans",{"$f":"(MIN(M64,M66)*12*9)-(G152*9)","v":-10845966.016799999}]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"Presse",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F96,'investissement réel'!C4)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F19,'investissement réel'!D4)","v":1967871},10,{"$f":"C133*D133","v":1967871},{"$f":"IFERROR(F133/E133,0)","v":196787.1}]
[null,"Moulin solaire",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C32,'investissement réel'!C5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D32,'investissement réel'!D5)","v":750000},15,750000,50000]
[null,"Dépulpeuse",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C33,'investissement réel'!C6)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D33,'investissement réel'!D6)","v":0},10,{"$f":"C135*D135","v":0},{"$f":"IFERROR(F135/E135,0)","v":0}]
[null,"Séchoir solaire",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C34,'investissement réel'!C7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D34,'investissement réel'!D7)","v":3800000},15,{"$f":"C136*D136","v":3800000},{"$f":"IFERROR(F136/E136,0)","v":253333.33333333334}]
[null,"Modules PV ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F98,'investissement réel'!C8)","v":18},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F76,B:B,0)),'investissement réel'!D8)","v":250000},20,4500000,225000]
[null,"Batterie ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F101,'investissement réel'!C9)","v":8},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F77,H:H,0)),'investissement réel'!D9)","v":400000},{"$f":"F102","v":6.0000000000000009},3200000,533333.33333333326]
[null,"Régulateur ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F104,'investissement réel'!C10)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(J:J,MATCH(F79,H:H,0)),'investissement réel'!D10)","v":220000},10,220000,22000]
[null,"Onduleur chargeur  ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F103,'investissement réel'!C11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F78,B:B,0)),'investissement réel'!D11)","v":450000},10,450000,45000]
[null,"Support aluminium",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C137,'investissement réel'!C12)","v":18},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D41,'investissement réel'!D12)","v":35000},20,630000,31500]
[null,"Démarreur ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C35,'investissement réel'!C13)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D35,'investissement réel'!D13)","v":147000},15,147000,9800]
[null,"Parafoudre ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C36,'investissement réel'!C14)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D36,'investissement réel'!D14)","v":140000},15,140000,9333.3333333333339]
[null,"Câbles et accessoires ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C42,'investissement réel'!C15)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D42,'investissement réel'!D15)","v":240000},20,240000,12000]
[null,"Système alimentation continue ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C43,'investissement réel'!C16)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D43,'investissement réel'!D16)","v":0},null,0,0]
[null,"Système de décantation",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C44,'investissement réel'!C17)","v":2},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D44,'investissement réel'!D17)","v":0}]
[null,"Filtre Huile",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C37,'investissement réel'!C18)","v":2},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D37,'investissement réel'!D18)","v":100000},1,200000,200000]
[null,"Local",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C38,'investissement réel'!C19)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D38,'investissement réel'!D19)","v":1000000},0,1000000,0]
[null,"Installation",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C39,'investissement réel'!C20)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D39,'investissement réel'!D20)","v":1000000},20,1000000,0]
[null,"Certifications (bio, etc.)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C45,'investissement réel'!C21)","v":0},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D45,'investissement réel'!D21)","v":0},0,0,0]
[null,"Autre: FRA, codes barres, etc.",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C40,'investissement réel'!C22)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D40,'investissement réel'!D22)","v":750000},0,750000,0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F133:F151)","v":18994871},{"$f":"SUM(G133:G151)","v":1588087.0999999999}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité",null,"Prix unitaire","Recettes annuelles","Recettes mensuelles","évolution annuelle recettes d'exploitation",null,null,0.01]
[null,"production huile baobab (L)",{"$f":"F108","v":633.13920000000007},{"$f":"G108","v":"Litres"},37786,{"$f":"C158*E158","v":23923797.811200004},{"$f":"F158/12","v":1993649.8176000004}]
[null,"production huile moringa (L)",464.89599999999996,"Litres",58573,{"$f":"C159*E159","v":27230353.407999996},{"$f":"F159/12","v":2269196.117333333}]
[null,"production tourteau (kg)",{"$f":"F110","v":8524.8000000000011},"Kilos",150,{"$f":"C160*E160","v":1278720.0000000002},106560.00000000001]
[null,"TOTAL (F CFA)",null,null,null,{"$f":"SUM(F158:F160)","v":52432871.2192},{"$f":"SUM(G158:G160)","v":4369405.9349333337}]
[]
[null,"Ressources et Financement des investissements"]
[]
[null,"BFR (Besoin en fonds de roulement)"]
[null,"Type de tiers","Client/fournisseur","Délais de paiement / stocks (jours)","Part des achats/ventes"]
[null,"Producteurs/vendeurs graines","founisseur",0,1]
[null,"transport graine","founisseur",0,1]
[null,"transport huile","founisseur",0,1]
[null,"Acheteurs huile brute (internationaux)","client",60,0.6]
[null,"Acheteurs huile brute (locaux)","client",60,0.4]
[null,"Stocks de consommable (graines)",null,30]
[null,"Stocks de produits finis (huile)",null,30]
[]
[null,"Créances clients",{"$f":"((D170*F161/365*E170)+(D171*F161/365*E171))","v":8619102.1182246581}]
[null,"Crédit fournisseurs",{"$f":"((D167*F129*E167/365)+(D168*F129*E168/365)+(D169*F129*E169/365))*-1","v":0}]
[null,"Impact Stocks consommable",{"$f":"F121*D172/365","v":230794.5205479452}]
[null,"Impact Stocks produits finis",{"$f":"F158*D173/365","v":1966339.5461260276}]
[null,"BFR",{"$f":"SUM(C175:C178)","v":10816236.18489863},"F CFA"]
[]
[]
[null,"SCHÉMA DE FINANCEMENT",null,null,null,"ECHEANCIER DE REMBOURSEMENT"]
[null,"Désignation ","Part","Montant total TTC",null,"Année","Capital","Intérêts","Reste","Annuité","Mensualité"]
[null,"Investissements",null,{"$f":"F152","v":18994871},null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":11249474.409395704},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":2140484.5829592594},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":214330807.26774004},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F184)","v":13389958.992354961},{"$f":"J184/12","v":1115829.9160295802}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C179","v":10816236.18489863},null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":12599411.3385232},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":790547.65383176401},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":70714415.750117108},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F185)","v":13389958.992354961},{"$f":"J185/12","v":1115829.9160295802}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D184:D185)","v":29811107.18489863},null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=3,3,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F186)","v":0},0]
[null,"Apport personnel",0.2,{"$f":"D186*C187","v":5962221.436979726},null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=4,4,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F187)","v":0},0]
[null,"Subvention",0,{"$f":"C188*D186","v":0},null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=5,5,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F188)","v":0},0]
[null,"Emprunt",{"$f":"100%-(C188+C187)","v":0.8},{"$f":"D186*C189","v":23848885.747918904},null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=6,6,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F189)","v":0},0]
[null,"Taux de l'emprunt",null,0.12,null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=7,7,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F190)","v":0},0]
[null,"Remboursement de l'emprunt (années)",null,2,null,{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=8,8,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F191)","v":0},0]
[{"$nulls":5},{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F192)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F192)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F192)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F192)","v":0},0]
[{"$nulls":5},{"$f":"IF(D191>10,\"nb an insuffisant\",IF(D191>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F193)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F193)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F193)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F193)","v":0},0]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G184:G193)","v":23848885.747918904},{"$f":"SUM(H184:H193)","v":2931032.2367910235},{"$f":"SUM(I184:I193)","v":285045223.01785713},{"$f":"SUM(J184:J193)","v":26779917.984709922}]
[]
[]
[null,"Ressources et Financement des investissements"]
[]
[null,"RESULTAT BRUT D'EXPLOITATION (EBE)"]
[null,"Désignation / Durée (années)",0,1,2,3,4,5,6,7,8,9,"Total"]
[null,"Recettes  ",{"$f":"D189+D187","v":29811107.18489863},{"$f":"F161","v":52432871.2192},{"$f":"D201+($K$157*D201)","v":52957199.931391999},{"$f":"E201+($K$157*E201)","v":53486771.93070592},{"$f":"F201+($K$157*F201)","v":54021639.650012977},54561856.04651311,55107474.606978245,55658549.353048027,56215134.846578509,56777286.195044294,{"$f":"SUM(C201:L201)","v":521029890.96437168}]
[null,"Dépenses ",{"$f":"D184","v":18994871},{"$f":"IF($F$115>D$200,$F$129,$G$129)","v":19746730.5984},{"$f":"IF($F$115>E$200,$F$129+(D202*$L$120),IF($F$115=E$200,$G$129+(D202*$L$120),IF($F$115<E$200,D202+(D202*$L$120))))","v":19944197.904384002},{"$f":"IF($F$115>F$200,$F$129+(E202*$L$120),IF($F$115=F$200,$G$129+(E202*$L$120),IF($F$115<F$200,E202+(E202*$L$120))))","v":20143639.883427843},20345076.28226212,20548527.045084741,20754012.31553559,20961552.438690946,21171167.963077854,21382879.642708633,21596708.439135719]
[null,"Amortissements ",0,{"$f":"$G$152","v":1588087.0999999999},{"$f":"$G$152","v":1588087.0999999999},1588087.0999999999,1588087.0999999999,1588087.0999999999,1588087.0999999999,1588087.0999999999,1588087.0999999999,1588087.0999999999,14292783.899999999]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$184:$J$193,MATCH(D200,$F$184:$F$193,0)),0)","v":13389958.992354961},{"$f":"IFERROR(INDEX($J$184:$J$193,MATCH(E200,$F$184:$F$193,0)),0)","v":13389958.992354961},0,0,0,0,0,0,0,26779917.984709922]
[null,"Bénéfice avant impôts ",0,{"$f":"D201-SUM(D202:D204)","v":17708094.528445035},{"$f":"E201-SUM(E202:E204)","v":18034955.934653036},31755044.947278075,32088476.267750856,32425241.901428368,32765375.191442654,33108909.81435708,33455879.783500653,33806319.452335656,{"$f":"SUM(C205:L205)","v":265148297.8211914}]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D205<0,0,0.3*D205)","v":5312428.35853351},{"$f":"IF(E205<0,0,0.3*E205)","v":5410486.7803959111},9526513.4841834214,9626542.8803252559,9727572.5704285093,9829612.5574327949,9932672.9443071242,10036763.935050195,10141895.835700696,{"$f":"SUM(C206:L206)","v":79544489.346357405}]
[null,"Bénéfice après impôts ",0,{"$f":"D205-D206","v":12395666.169911526},{"$f":"E205-E206","v":12624469.154257126},22228531.463094652,22461933.387425601,22697669.330999859,22935762.63400986,23176236.870049953,23419115.84845046,23664423.616634957,185603808.474834]
[null,"Trésorerie",{"$f":"C201-C202","v":10816236.18489863},{"$f":"C208+D207","v":23211902.354810156},35836371.509067282,{"$f":"E208+F207","v":58064902.972161934},80526836.359587535,103224505.6905874,126160268.32459727,149336505.19464722,172755621.04309767,196420044.65973264]
[null,"Cash Flows",0,{"$f":"D207+D204-($H$194/$D$191)","v":24320109.043870974},24548912.028216574,20763015.344699141,20996417.26903009,21232153.212604348,21470246.515614349,21710720.751654442,21953599.730054948,22198907.498239446]
[null,"Cash Flows cumulés",{"$f":"-C202","v":-18994871},{"$f":"C210+D209","v":5325238.0438709743},{"$f":"D210+E209","v":29874150.072087549},{"$f":"E210+F209","v":50637165.416786686},71633582.68581678,92865735.898421124,114335982.41403547,136046703.16568992,158000302.89574486,180199210.39398432]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F215,IF(D200<=H215,D209,0),IF(E200<=H215,E209,0),IF(F200<=H215,F209,0),IF(G200<=H215,G209,0),IF(H200<=H215,H209,0),IF(I200<=H215,I209,0),IF(J200<=H215,J209,0),IF(K200<=H215,K209,0),IF(L200<=H215,L209,0))-D184","v":138898856.42263782},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D184+IF(H215>=D200,(D207+D204-H194/D191)*((1+F215)^-1),0)+IF(H215>=E200,(E207+E204-H194/D191)*((1+F215)^-2),0)+IF(H215>=F200,(F207+F204-H194/D191)*((1+F215)^-3),0)+IF(H215>=G200,(G207+G204-H194/D191)*((1+F215)^-4),0)+IF(H215>=H200,(H207+H204-H194/D191)*((1+F215)^-5),0)+IF(H215>=I200,(I207+I204-H194/D191)*((1+F215)^-6),0)+IF(H215>=J200,(J207+J204-H194/D191)*((1+F215)^-7),0)+IF(H215>=K200,(K207+K204-H194/D191)*((1+F215)^-8),0)+IF(H215>=L200,(L207+L204-H194/D191)*((1+F215)^-9),0)","v":138898856.42263785},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N216:W216)","v":1.2474006369231287},{"$nulls":10},{"$f":"-D184","v":-18994871},{"$f":"IF(D200<=H215,D209,0)","v":24320109.043870974},{"$f":"IF(E200<=H215,E209,0)","v":24548912.028216574},{"$f":"IF(F200<=H215,F209,0)","v":20763015.344699141},{"$f":"IF(G200<=H215,G209,0)","v":20996417.26903009},{"$f":"IF(H200<=H215,H209,0)","v":21232153.212604348},{"$f":"IF(I200<=H215,I209,0)","v":21470246.515614349},{"$f":"IF(J200<=H215,J209,0)","v":21710720.751654442},{"$f":"IF(K200<=H215,K209,0)","v":21953599.730054948},{"$f":"IF(L200<=H215,L209,0)","v":22198907.498239446}]
[null,"RSI",{"$f":"SUM(O216:W216)/D184","v":10.48672988587205},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N217,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 9487 CFA"},{"$nulls":9},{"$f":"(C217-1)*1000","v":9486.7298858720496}]
[null,"DRCI",{"$f":"N218+(-P218/(O218-P218))","v":0.78103560167987762},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C218,0)&\" ans et \"&ROUNDDOWN((C218-ROUNDDOWN(C218,0))*12,0)&\" mois\"","v":"Le délai de récupération est de 0 ans et 9 mois"},{"$nulls":9},{"$f":"IF(AND(L210<0,L200<=H215),L200,IF(AND(K210<0,K200<=H215),K200,IF(AND(J210<0,J200<=H215),J200,IF(AND(I210<0,I200<=H215),I200,IF(AND(H210<0,H200<=H215),H200,IF(AND(G210<0,G200<=H215),G200,IF(AND(F210<0,F200<=H215),F200,IF(AND(E210<0,E200<=H215),E200,IF(AND(D210<0,D200<=H215),D200,IF(AND(C210<0,C200<=H215),C200))))))))))","v":0},{"$f":"INDEX(C210:L210,MATCH(INDEX(C200:L200,MATCH(P218,C210:L210,0))+1,C200:L200,0))","v":5325238.0438709743},{"$f":"IF(AND(L210<0,L200<=H215),L210,IF(AND(K210<0,K200<=H215),K210,IF(AND(J210<0,J200<=H215),J210,IF(AND(I210<0,I200<=H215),I210,IF(AND(H210<0,H200<=H215),H210,IF(AND(G210<0,G200<=H215),G210,IF(AND(F210<0,F200<=H215),F210,IF(AND(E210<0,E200<=H215),E210,IF(AND(D210<0,D200<=H215),D210,IF(AND(C210<0,C200<=H215),C210))))))))))","v":-18994871}]
[null,"DSCR",{"$f":"(D201-D202)/(D204)","v":2.4410934073406985}]

{"sheet":"Remboursement Mensualités","index":1,"n_rows":133,"n_cols":7,"rows_kept":133,"cut":false,"hidden":true,"merged":[]}
["Remboursement de prêt"]
["Taux annuel",{"$f":"'Table rentabilité'!D190","v":0.12}]
["Capital emprunté",{"$f":"'Table rentabilité'!D189","v":23848885.747918904}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité'!D191","v":2},{"$f":"B4*12","v":24}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":1115829.9160295804},"Formule mensualité","=-VPM((1+B2)^(1/12)-1;B4*12;B3)"]
[]
["Décomposition de la mensualité"]
["Remboursement du principal",{"$f":"-PPMT((1+B2)^(1/12)-1,1,B4*12,B3)","v":889532.77744704916},"Formule principal","=-PRINCPER((1+B2)^(1/12)-1;1;B4*12;B3)"]
["Remboursement des interêts",{"$f":"-IPMT((1+B2)^(1/12)-1,1,B4*12,B3)","v":226297.13858253119},"Formule intérêt","=-INTPER((1+B2)^(1/12)-1;1;B4*12;B3)"]
[]
[]
["Dans les formules ci-dessous Taux de période = TP =  (1+$B$2)^(1/12)-1"]
["Périodes","Mensualité","Capital","Intérêts","Reste (ou résiduel)","Années"]
[{"$f":"IF(B4<>0,1,\"-\")","v":1},{"$f":"IF(A14<>\"-\",C14+D14,\"\")","v":1115829.9160295804},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":889532.77744704916},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":226297.13858253119},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":22959352.970471855},{"$f":"IF(A14<>\"-\",1,\"\")","v":1},{"$f":"IF(A14<>\"-\",1,\"\")","v":1}]
[{"$f":"IF(AND($B$4<>0,A14<$C$4),A14+1,\"-\")","v":2},{"$f":"IF(A15<>\"-\",C15+D15,\"\")","v":1115829.9160295804},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":897973.36978076864},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":217856.54624881165},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":22061379.600691088},{"$f":"IF(A15<>\"-\",IF(G14<G15,F14,F14+1),\"\")","v":1},{"$f":"IF(A15=\"-\",\"\",IF(G14<12,G14+1,1))","v":2}]
[{"$f":"IF(AND($B$4<>0,A15<$C$4),A15+1,\"-\")","v":3},1115829.9160295804,906494.05314738827,209335.86288219216,21154885.547543697,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,1115829.9160295802,915095.58751413459,200734.32851544567,20239789.960029565,1,4]
[5,1115829.9160295804,923778.74005940696,192051.17597017341,19316011.219970156,1,5]
[6,1115829.9160295804,932544.28524120071,183285.63078837964,18383466.934728954,1,6]
[7,1115829.9160295804,941393.00486618327,174436.91116339716,17442073.929862771,1,7]
[8,1115829.9160295804,950325.68815942341,165504.22787015705,16491748.241703348,1,8]
[9,1115829.9160295804,959343.13183478324,156486.78419479713,15532405.109868564,1,9]
[10,1115829.9160295804,968446.14016597788,147383.7758636025,14563958.969702585,1,10]
[11,1115829.9160295804,977635.52505830908,138194.39097127129,13586323.444644278,1,11]
[12,1115829.9160295804,986912.10612107976,128917.80990850065,12599411.338523198,1,12]
[13,1115829.9160295804,996276.71074069594,119553.20528888448,11603134.627782501,2,1]
[14,1115829.9160295804,1005730.1741544618,110099.74187511852,10597404.453628041,2,2]
[15,1115829.9160295804,1015273.3395250756,100556.57650450469,9582131.1141029634,2,3]
[16,1115829.9160295804,1024907.0580158317,90922.858013748599,8557224.0560871307,2,4]
[17,1115829.9160295804,1034632.1888665366,81197.727163043688,7522591.8672205973,2,5]
[18,1115829.9160295804,1044449.5994701457,71380.316559434694,6478142.2677504495,2,6]
[19,1115829.9160295804,1054360.1654501262,61469.750579454289,5423782.1023003273,2,7]
[20,1115829.9160295802,1064364.7707385549,51465.145291025336,4359417.3315617703,2,8]
[21,1115829.9160295802,1074464.307654958,41365.608374622207,3284953.0239068121,2,9]
[22,1115829.9160295804,1084659.6769858962,31170.239043684182,2200293.3469209112,2,10]
[23,1115829.9160295804,1094951.7880653071,20878.127964273281,1105341.5588556081,2,11]
[24,1115829.9160295804,1105341.5588556102,10488.357173970124,0,2,12]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-",{"$f":"IF(A79<>\"-\",C79+D79,\"\")","v":""},{"$f":"IF(A79<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":""},{"$f":"IF(A79<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A79,$B$4*12,$B$3),\"\")","v":""},{"$f":"IF(A79<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A79,0),\"\")","v":""},"",""]
[{"$f":"IF(AND($B$4<>0,A79<$C$4),A79+1,\"-\")","v":"-"},"","","","",{"$f":"IF(A80<>\"-\",IF(G79<G80,F79,F79+1),\"\")","v":""},{"$f":"IF(A80=\"-\",\"\",IF(G79<12,G79+1,1))","v":""}]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]
["-","","","","","",""]

{"sheet":"investissement réel","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Désignation ","Quantité","Prix unitaire TTC","Montant Total TTC","Durée de vie (an)","Amortissement annuel"]
[null,"Presse",1,1967871,{"$f":"C4*D4","v":1967871},10,{"$f":"E4/F4","v":196787.1}]
[null,"Moulin solaire",1,750000,{"$f":"C5*D5","v":750000},15,{"$f":"E5/F5","v":50000}]
[null,"Dépulpeuse",1,0,0,10,0]
[null,"Séchoir solaire",1,3800000,3800000,15,253333.33333333334]
[null,"Modules PV ",18,250000,{"$f":"C8*D8","v":4500000},20,225000]
[null,"Batterie ",8,400000,3200000,6.0000000000000009,533333.33333333326]
[null,"Régulateur ",1,220000,220000,10,22000]
[null,"Onduleur chargeur  ",1,450000,{"$f":"C11*D11","v":450000},10,{"$f":"E11/F11","v":45000}]
[null,"Support aluminium",18,35000,630000,20,31500]
[null,"Démarreur ",1,147000,147000,15,9800]
[null,"Parafoudre ",1,140000,140000,15,9333.3333333333339]
[null,"Câbles et accessoires ",1,240000,240000,20,12000]
[null,"Système alimentation continue ",0,0,{"$f":"C16*D16","v":0},15,0]
[null,"Système de décantation",2,0,0]
[null,"Filtre Huile",2,100000,200000,1,200000]
[null,"Local",1,1000000,1000000,0]
[null,"Installation",1,1000000,1000000,20]
[null,"Certifications (bio, etc.)",0,0,{"$f":"C21*D21","v":0},0]
[null,"Autre: FRA, codes barres, etc.",1,750000,750000,0]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E4:E22)","v":18994871},null,{"$f":"SUM(G4:G22)","v":1588087.0999999999}]

{"sheet":"Modèles envisagés (ex.arachide)","index":3,"n_rows":71,"n_cols":15,"rows_kept":71,"cut":false,"hidden":true,"merged":[[11,12,11,16],[12,12,12,16],[11,4,11,9],[12,4,12,9]]}
[]
[null,"Analyse économique"]
[]
[]
[null,"Contexte",null,"Les producteurs d'arachides sont dépendants du prix de rachat de leurs graines désormais fixé par l'Etat mais qui doit premettre à la filière de rester compétitive notamment face aux autres huiles importées"]
[null,null,null,"Des intermédiaires ont envahis le marché, les opérateurs privés de stockage (OPS) qui achètent souvent à très bas prix les productions d'arachide qui doivent être écoulées (en-dessous du prix de l'Etat)"]
[null,null,null,"La transformation artisanale de l'arachide brute en huile est en plein essor car elle permet de générer un revenu supplémentaire dans les bassins arachidiers"]
[null,null,null,"La transformation de l'arachide en huile au niveau artisanal a souvent été freinée par des problèmes importants: impossibilité de stocker la production d'arachide, développement de maladies (aflatoxine notamment), concurrence élevée des industriels, etc."]
[]
[]
[]
[null,"SWOT",null,"Forces","> Potentiel de développement économique local important: augmentation nette des gains potentiels de revenus liés à la revente d'une huile brute pour la consommation locale. Avec un prix de vente situé entre le prix de l'huile brute à destination des raffineurs et de l'huile raffinée mise sur le marché (entre 800 et 1200 FCFA), le gain de CA par kilo d'arachide se situe entre 70 FCFA et 250 FCFA.\n\n> Qualité de l'huile brute peut être améliorée sensiblement avec les moyens techniques d'une presse solaire. Notamment pour lutter contre l'aflatoxine. L'ajout de filtres peut encore augmenter cette qualité et rapprocher le produit de l'huile raffinée.\n\n> la capacité de traitement de la presse solaire par rapport à la presse manuelle résout un certain nombre de problèmes liés au stockage de la graine",{"$nulls":6},"Faiblesses","> Le projet a des gains marginaux peu élevés. Sa rentabilité passe donc par un fonctionnement intensif et un apport important de matière première qui n'est pas garanti. Par ailleurs, sa durée d'amortissement peut être longue et une toute variation des prix sur le marché de l'arachide peut l'affecter durablement\n\n> Il n'existe pas de projets de référence similaires qui peuvent donner des indications claires sur la durabilité et la rentabilité de la solution"]
[null,null,null,"Opportunités","> Les transformateurs artisanaux d'huile d'arachide sont déjà nombreux et le métier n'est pas nouveau. L'exploitation de l'avantage comparatif de la technologie solaire pourra donc rapidement porter ses fruits\n\n> Il existe une demande locale d'huile d'arachide de meilleure qualité et économiquement attrayante: l'huile d'arachide est adaptée à la cuisine sénégalaise et la diminution des risques sanitaires la rendent à nouveau attrayante.\n\n",{"$nulls":6},"Menaces","> Le marché de l'huile d'arachide est un marché complexe: le challenge est économique plus que technologique. Les acteurs devront être accompagnés pour trouver les fournisseurs d'arachide et être capable de regrouper les productions et trouver les débouchés au niveau de la vente de l'huile brute.\n\n> Le marché est composé d'acteurs multiples et aux intérêts économiques importants. Le risque est élevé pour les bénéficiaires du projet de subir la concurrence aussi bien loyale des industriels et déloyale des OPS"]
[]
[null,"Modèles économiques"]
[]
[]
[null,null,"Modèle 1",{"$nulls":7},"Modèle 2"]
[null,null,"Business de transformation",{"$nulls":7},"Business de transformation"]
[]
[null,null,"Intrant","Graine décortiquée rachetée aux producteurs",{"$nulls":6},"Intrant","Graine non décortiquée rachetée aux producteurs"]
[null,null,"Extrant","Revente d'une l'huile non raffinée aux particuliers",{"$nulls":6},"Extrant","Revente d'une l'huile non raffinée aux particuliers"]
[]
[{"$nulls":5},"Solution 1","Solution 2",{"$nulls":6},"Solution 1","Solution 2"]
[null,null,"Nb presses",null,null,1,2,null,null,null,"Nb presses",null,null,1,2]
[null,null,"Profitabilité",null,null,"3ème année","1ère année",null,null,null,"Profitabilité",null,null,"1ère année","1ère année"]
[null,null,"Intrant arachide min (kg)",null,null,"20,2 T","33,6 T",null,null,null,"Intrant arachide min (kg)",null,null,"10,1 T","13,4 T"]
[null,null,"Fonctionnement presse min (heures/jour)",null,null,12,10,null,null,null,"Fonctionnement presse min (heures/jour)",null,null,6,4]
[null,null,"Prix achat arachide décortiquée maximum",null,null,375,400,null,null,null,"Prix achat arachide décortiquée maximum",null,null,220,220]
[null,null,"Prix vente huile brute minimum",null,null,1000,1000,null,null,null,"Prix vente huile brute minimum",null,null,1000,1000]
[null,null,"Prix de vente tourteaux minimum",null,null,200,200,null,null,null,"Prix de vente tourteaux minimum",null,null,200,200]
[null,null,"Bénéfice min cumulé sur 5 ans",null,null,297672,2395840,null,null,null,"Bénéfice min cumulé sur 5 ans",null,null,1385014,3016369]
[null,null,"Bénéfice min cumulé sur 9 ans",null,null,8653293.6653214898,16706237.692609798,null,null,null,"Bénéfice min cumulé sur 9 ans",null,null,7186440.3045057058,11988417]
[]
[null,null,"Alerte:","Incapacité des petits producteurs à décortiquer",{"$nulls":6},"Alerte:","Nécessité d'acheter aux petits producteurs au prix fixé par l'Etat qui peut évoluer"]
[null,null,null,"peut mener à privilégier la vente aux industriels?",{"$nulls":7},"Prise en compte d'une évolution du prix dans le business model nécessaire"]
[null,null,null,"Complexité business: fournisseurs + clients à trouver; gestion stocks"]
[]
[]
[]
[null,null,"Modèle 3",{"$nulls":7},"Modèle 4"]
[null,null,"Business de service de transformation avec décortiqueuse",{"$nulls":7},"Business mixte production avec décortiqueuse et service"]
[]
[null,null,"Intrant","Aucun (producteur reste propriétaire d'arachide)",{"$nulls":6},"Intrant","Aucun (producteur reste propriétaire d'arachide)"]
[null,null,"Extrant","Service de pressage d'huile",{"$nulls":6},"Extrant","Service de pressage d'huile"]
[]
[{"$nulls":5},"Solution 1","Solution 2",{"$nulls":6},"Solution 1","Solution 2"]
[null,null,"Nb presses",null,null,1,2,null,null,null,"Nb presses",null,null,1,2]
[null,null,"Profitabilité",null,null,"1ère année","1ère année",null,null,null,"Profitabilité",null,null,"1ère année","1ère année"]
[null,null,"Intrant arachide min (kg)",null,null,"13,4 T","23,5 T",null,null,null,"Intrant arachide min (kg)",null," ","13,4 T","16,8 T"]
[null,null,"Fonctionnement presse min (heures/jour)",null,null,11,7,null,null,null,"Fonctionnement presse min (heures/jour)",null,null,8,5]
[{"$nulls":10},"Prix achat arachide décortiquée maximum",null,null,220,220]
[null,null,"Prix prestation min",null,null,200,200,null,null,null,"Prix vente huile brute minimum",null,null,1000,1000]
[null,null,"Bénéfice min cumulé sur 5 ans",null,null,1214862,2265039,null,null,null,"Prix prestation min",null,null,150,150]
[null,null,"Bénéfice min cumulé sur 9 ans",null,null,7632052.6378305135,11477664.586775661,null,null,null,"Bénéfice min cumulé sur 5 ans",null,null,683594,1297217]
[{"$nulls":10},"Bénéfice min cumulé sur 9 ans",null,null,6259903.8182514552,8804899.8788981438]
[]
[null,null,"Alerte:","Grande incertitude sur la durée de fonctionnement de la machine relatif",{"$nulls":6},"Alerte:"]
[null,null,null,"à l'imprévisibilité de l'apport en graines"]
[]
[]
[]
[]
[null,"Préconisations",null,"(1) La décortiqueuse semble clé pour permettre d'obtenir un projet rentable dans la durée, car elle permet d'augmenter la marge sur l'huile vendue"]
[null,null,null,"(2) Choisir 2 pilotes complémentaires:"]
[{"$nulls":4},"a. Un pilote avec un modèle d'exploitation plus \"simple\" de type \"service de transformation\" (modèle 3 ou 4) avec des chances de réussite plus élevées"]
[{"$nulls":4},"b. Un pilote avec un modèle d'exploitation complexe (modèle 1 ou 2) qui sera un pilote plus risqué"]
[null,null,null,"(3) Choisir comme cible des producteurs déjà impliqués dans la transformation de l'arachide en huile afin de simplifier l'approche business et augmenter les chancs de réussite du projet"]
[null,null,null,"(4) Dans le cas d'un pilote complexe avec achat de l'arachide aux producteurs, favoriser un modèle tout intégré avec système de décortication solaire, qui permettra de générer un revenu marginal plus élevé"]
[null,null,null,"(5) La performance du projet étant très dépendante de la productivité de la machine, l'entretien sera primordial pour limiter les pannes et arrêts de production: mettre en place un système d'épargne des amortissements"]
[null,null,null,"pour financer les éventuels travaux. Ce système pourra être géré par un organisme partenaire (commune ou ONG locale)."]