{"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":198,"n_cols":23,"rows_kept":198,"cut":false,"hidden":false,"merged":[[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[98,2,98,3],[77,5,77,6],[99,2,99,3],[16,2,17,2],[16,3,16,4],[16,5,17,5],[63,5,63,6],[58,5,58,6],[16,6,17,6],[64,5,64,6],[68,5,68,6],[16,10,17,10],[16,8,16,9],[48,1,49,1],[48,7,49,7],[50,1,51,1],[50,7,51,7],[16,7,17,7],[138,2,138,3],[107,2,107,3],[139,2,139,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[136,2,136,3],[137,2,137,3],[135,2,135,3]]}
[]
[null,"ETUDE RENTABILITE SOLUTIONS USAGE PRODUCTIF"]
[null,"Pompe solaire_Bananeraie"]
[]
[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 (m3/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,"Pompe de surface (983,2Kg/m3)",380,null,55,5824300,{"$f":"E19*I19","v":330},{"$f":"G19/K19","v":412.5},6,365,0.8]
[]
[]
[]
[]
[]
[null,"Equipements facultatifs"]
[null,"designation","nombre","prix"]
[null,"cloture grillage",1,2493750]
[null,"Genie civil (structures modules)",1,3187500]
[null,"conditionneur d'energie + protection ",1,3252999]
[null,"accessoirs cablages + protection",1,3128125]
[null,"ligne d'aspiration (PeHD)",1,178000]
[null,"ligne de refoulement (PeHD)",1,750000]
[null,"accessoirs pompe",1,2231250]
[]
[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,"Sharp ND-AC275",0.27500000000000002,50000,0.6,"24V",null,"Victron Energy Gel",220,400000,12,10]
[null,"BlueSolar SPM-300-24 Monocristallin",0.3,70000,0.6,"24V",null,"Victron Energy Gel 2",265,null,12,10]
[{"$nulls":7},"Tension nécessaire système",{"$f":"IF(J38<0.5,12,IF(AND(J38>=0.5,J38<2),24,IF(J38>=2,48)))","v":48},{"$f":"F83*INDEX(C:C,MATCH(F60,B:B,0))","v":68.75}]
[]
[null,"Conditionneur","kVa","Prix (FCFA)",null,null,null,"Régulateur",null,"Prix (FCFA)","Tension (V)"]
[null,null,null,3252999,null,null,null,"BlueSolar 150V 35A de Victron Energy",null,220000,"12V/24V/48V"]
[{"$nulls":7},"…"]
[]
[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é'!G72=\"x\",MAX(C46:N46),IF('Table rentabilité'!G73=\"x\",MIN(C46:N46),IF('Table rentabilité'!G74=\"x\",AVERAGE(C46:N46),\"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":"(F77*30)-SUM(K49:L49)","v":50},{"$f":"IF((F77*30)>D49,(F77*30)-D49-L49,0)","v":450},{"$f":"IF((F77*30)>E49,(F77*30)-E49,0)","v":9400},{"$f":"SUM(J49:L49)","v":9900}]
[null,null,"Prix (KWh)",128.85,135.68,147.68,null,null,"Coût (FCFA)",{"$f":"J49*D50","v":6442.5},{"$f":"K49*E50","v":61056},{"$f":"L49*F50","v":1388192},{"$f":"SUM(J50:L50)","v":1455690.5}]
[null,"UP-Moyenne Puissance","Tranche",100,500,"∞",null,"UP-Moyenne Puissance","Energie par Tranche",{"$f":"(F77*30)-SUM(K51:L51)","v":100},{"$f":"IF((F77*30)>D51,(F77*30)-D51-L51,0)","v":400},{"$f":"IF((F77*30)>E51,(F77*30)-E51,0)","v":9400},9900]
[null,null,"Prix (KWh)",129.81,136.53,149.24,null,null,"Coût (FCFA)",{"$f":"J51*D52","v":12981},{"$f":"K51*E52","v":54612},1402856,1470449]
[]
[null,"Choix de dimensionnement du projet"]
[]
[null,"Production min. souhaitée (m3 d'eau/jour)",null,null,null,{"$f":"C19*I19","v":2280},"m3"]
[null,"Temps de fonctionnement (heures)",null,null,null,{"$f":"I19","v":6}]
[]
[null,"Choix de la pompes",null,null,null,"Pompe de surface (983,2Kg/m3)"]
[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 du conditionneur (onduleur)",null,null,null,"Vitron Energy Phoenix"]
[null,"Choix du régulateur"]
[null,"Choix décortiqueuse solaire"]
[null,"Equivalent Réseau",null,null,null,{"$f":"IF(M50<M52,B49,B51)","v":"UP-Petite Puissance"}]
[null,"Raccordement nécessaire (MT, BT) et distance",null,null,null,"MT",500]
[null,"Montant Frais HTA et KG câble",null,null,null,4462549,30]
[]
[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,"Puissance equipement total majoré",null,null,null,{"$f":"E19*1.2","v":66}]
[null,"Energie journalière consommée (KWh)",null,null,null,{"$f":"G19+G20+G22","v":330},"KWh"]
[null,"Puissance crête projet (KW)",null,null,null,{"$f":"(INDEX(H:H,MATCH(F59,B:B,0))/I19)*F89","v":68.75}]
[null,"Capacité totale système stockage (Ampères/heure)",null,null,null,{"$f":"(G19+G20+G21)*1000*(F69)/(F70*I38)","v":9821.4285714285725}]
[]
[null,"Nb de pompes",null,null,null,{"$f":"ROUNDUP(F56/(C19*I19),0)","v":1},"unités"]
[{"$nulls":5},{"$f":"IF(F64<>\"\",1,0)","v":0},"unités"]
[null,"Nb de panneaux solaires",null,null,null,{"$f":"ROUNDUP(F78/INDEX(C:C,MATCH(F60,B:B,0)),0)","v":250},"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(I38/INDEX(K:K,MATCH(F61,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":"F84*F85","v":8},"unités"]
[null,"Durée de vie attendue de la batterie",null,null,null,{"$f":"INDEX(L:L,MATCH(F61,H:H,0))*(130%-F70)","v":6.0000000000000009},"ans"]
[null,"Nb conditionneur",null,null,null,{"$f":"IF(OR(I38=24,I38=12),1,2)","v":2},"unités","=SI(OU(I37=24;I37=12);1;2)"]
[null,"Nb régulateurs",null,null,null,1,"unités"]
[]
[null,"Ratio de fonctionnement ",null,null,null,0.9]
[null,"Employés nécessaires pour fonctionnement",null,null,null,1,"personnes"]
[null,"Extrant annuel attendu en eau",null,null,null,{"$f":"INDEX(C:C,MATCH($F$59,B:B,0))*INDEX(J:J,MATCH($F$59,B:B,0))*F81*F91","v":124830},"m3"]
[null,"Extrant annuel attendu en bananes",null,null,null,{"$f":"315","v":315},"Tonnes"]
[]
[null,"Calcul de charges variables et fixes"]
[]
[null,"CHARGES VARIABLES D'EXPLOITATION "]
[null,"Désignation","Quantité (parcelles)",null,"Prix unitaire","Montant total/an","Montant total/mois",null,"évolution annuelle charges d'exploitation",null,null,0.01]
[null,"engrais (sacs de 50 kg)",{"$f":"35.1*4","v":140.4},null,9500,{"$f":"E100*C100*L100","v":866970},{"$f":"F100/12","v":72247.5},null,"Part charges imputables au business de l'huile (Baobab)*",null,null,0.65]
[null,"salaires",1,null,630000,{"$f":"E101*C101","v":630000},{"$f":"F101/12","v":52500},null,"* La création de Bouye sera gérée par RaS, les charges sont donc réparties "]
[null,"materiels vegetales",null,null,null,{"$f":"E102*C102","v":0},{"$f":"F102/12","v":0},null,"entre les 2 projets selon le poids de chaque transformation dans le revenu généré"]
[null,"Entretien système d'irrigation",null,null,null,{"$f":"E103*C103","v":0},0]
[null,"fumier (tonne)",35,null,65000,{"$f":"E104*C104","v":2275000},189583.33333333334]
[{"$nulls":5},{"$f":"E105*C105*12","v":0},0]
[{"$nulls":5},{"$f":"E106*C106*12","v":0},0,null,"Avantage coût électricité PV vs. Réseau",null,"Sur 1 an",{"$f":"(MIN(M50,M52)*12)-G131","v":14918947.313333333}]
[{"$nulls":5},{"$f":"E107*C107*12","v":0},0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F100:F107)","v":3771970},{"$f":"SUM(G100:G107)","v":314330.83333333337},null,null,null,"Sur 5 ans",{"$f":"(MIN(M50,M52)*12*5)-(G131*5)","v":74594736.566666663}]
[{"$nulls":10},"Sur 9 ans",{"$f":"(MIN(M50,M52)*12*9)-(G131*9)","v":134270525.81999999}]
[null,"INVESTISSEMENTS"]
[null,"Désignation ","Quantité","Prix unitaire TTC","Durée de vie (an)","Montant Total TTC","Amortissement annuel"]
[null,"Pompe solaire (55 KW)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F81,'investissement réel'!C4)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(F:F,MATCH(F59,B:B,0)),'investissement réel'!D4)","v":5824300},10,{"$f":"C112*D112","v":5824300},{"$f":"IFERROR(F112/E112,0)","v":582430}]
[null,"accessoirs pompe",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C33,'investissement réel'!C5)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D33,'investissement réel'!D5)","v":2231250},10,{"$f":"C113*D113","v":2231250},223125]
[null,"Champs solaire (81,9 KWc)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F83,'investissement réel'!C6)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),INDEX(D:D,MATCH(F60,B:B,0)),'investissement réel'!D6)","v":17541678},25,{"$f":"C114*D114","v":17541678},{"$f":"IFERROR(F114/E114,0)","v":701667.12}]
[null,"cloture grillage",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C27,'investissement réel'!C7)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D27,'investissement réel'!D7)","v":2493750},10,{"$f":"C115*D115","v":2493750},{"$f":"IFERROR(F115/E115,0)","v":249375}]
[null,"Genie civil (structures modules)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C28,'investissement réel'!C8)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D28,'investissement réel'!D8)","v":3187500},15,3187500,212500]
[null,"conditionneur d'energie + protection ",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),F88,'investissement réel'!C9)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D41,'investissement réel'!D9)","v":3252999},10,3252999,325299.90000000002]
[null,"accessoirs cablages + protection",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C30,'investissement réel'!C10)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D30,'investissement réel'!D10)","v":3128125},15,3128125,208541.66666666666]
[null,"ligne d'aspiration (PeHD)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C31,'investissement réel'!C11)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D31,'investissement réel'!D11)","v":178000},20,178000,8900]
[null,"ligne de refoulement (PeHD)",{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),C32,'investissement réel'!C12)","v":1},{"$f":"IF($B$5=INDEX($B$6:$B$7,1,1),D32,'investissement réel'!D12)","v":750000},20,750000,37500]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[null," TOTAL (F CFA) ",null,null,null,{"$f":"SUM(F112:F130)","v":38587602},{"$f":"SUM(G112:G130)","v":2549338.6866666665},{"$f":"G131/12","v":212444.89055555555}]
[]
[null,"Calcul des recettes d'exploitation"]
[]
[null,"RECETTES D'EXPLOITATION"]
[null,"Désignation","Quantité (parcelle)",null,"Prix unitaire","Recettes annuelles","Recettes mensuelles",null,null,"évolution annuelle recettes d'exploitation",0.1]
[null,"Cotisations (année 1 - 5 H)",{"$f":"19.5","v":19.5},null,502341.25,{"$f":"C137*E137","v":9795654.375},{"$f":"F137/12","v":816304.53125}]
[null,"Cotisations (année 2 - 9 H)",35.1,null,502341.25,{"$f":"C138*E138","v":17632177.875},{"$f":"F138/12","v":1469348.15625}]
[{"$nulls":5},{"$f":"C139*E139","v":0},0]
[null,"TOTAL (F CFA)",null,null,null,{"$f":"F138","v":17632177.875},{"$f":"G138","v":1469348.15625}]
[]
[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"]
{"$rows_empty":8}
[null,"Créances clients",{"$f":"((D149*F140/365*E149)+(D150*F140/365*E150))","v":0}]
[null,"Crédit fournisseurs",{"$f":"((D146*F108*E146/365)+(D147*F108*E147/365)+(D148*F108*E148/365))*-1","v":0}]
[null,"Impact Stocks consommable",{"$f":"F100*D151/365","v":0}]
[null,"Impact Stocks produits finis",{"$f":"F137*D152/365","v":0}]
[null,"BFR",{"$f":"SUM(C154:C157)","v":0},"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":"F131","v":38587602},null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=1,1,\"-\"))","v":1},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":8691012.925165927},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":2351188.9844671651},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":407143533.83135849},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F163)","v":11042201.909633094},{"$f":"J163/12","v":920183.4924694245}]
[null,"Besoin en fonds de roulement ",null,{"$f":"C158","v":0},null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=2,2,\"-\"))","v":2},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":9299383.829927545},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":1742818.0797055506},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":298937840.41756248},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F164)","v":11042201.909633094},{"$f":"J164/12","v":920183.4924694245}]
[null,"COÛT TOTAL (F CFA) ",null,{"$f":"SUM(D163:D164)","v":38587602},null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=3,3,\"-\"))","v":3},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":9950340.6980224717},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":1091861.2116106227},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":183157748.46480072},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F165)","v":11042201.909633094},920183.4924694245]
[null,"Apport personnel",0,{"$f":"D165*C166","v":0},null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=4,4,\"-\"))","v":4},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":10646864.546884045},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":395337.36274905002},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":59273050.075345635},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F166)","v":11042201.909633094},920183.4924694245]
[null,"Subvention",0,{"$f":"C167*D165","v":0},null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=5,5,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F167)","v":0},0]
[null,"Emprunt",{"$f":"100%-(C167+C166)","v":1},{"$f":"D165*C168","v":38587602},null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=6,6,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F168)","v":0}]
[null,"Taux de l'emprunt",null,7.0000000000000007E-2,null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=7,7,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F169)","v":0}]
[null,"Remboursement de l'emprunt (années)",null,4,null,{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=8,8,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F170)","v":0}]
[{"$nulls":5},{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=9,9,\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F171)","v":0}]
[{"$nulls":5},{"$f":"IF(D170>10,\"nb an insuffisant\",IF(D170>=10,\"Année 10\",\"-\"))","v":"-"},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!D$14:D$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!E$14:E$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!B$14:B$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0},{"$f":"SUMIFS('Remboursement Mensualités'!C$14:C$133,'Remboursement Mensualités'!$F$14:$F$133,'Table rentabilité'!$F172)","v":0}]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G163:G172)","v":38587601.999999985},{"$f":"SUM(H163:H172)","v":5581205.638532389},{"$f":"SUM(I163:I172)","v":948512172.78906727},{"$f":"SUM(J163:J172)","v":44168807.638532378},{"$f":"SUM(K163:K172)","v":3680733.969877698}]
[]
[]
[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  ",null,{"$f":"F138","v":17632177.875},{"$f":"$D$180+(($F138-$F137)*0.25*D179)+($K$136*D180)","v":21354526.537500001},{"$f":"$D$180+(($F138-$F137)*0.25*E179)+($K$136*E180)","v":23685892.278749999},{"$f":"$D$180+(($F138-$F137)*0.25*F179)+($K$136*F180)","v":25878159.727875002},28056517.347787499,{"$f":"H180+($K$136*H180)","v":30862169.08256625},33948385.990822874,37343224.589905158,41077547.048895672,{"$f":"SUM(C180:L180)","v":259838600.47910243}]
[null,"Dépenses ",null,{"$f":"F108","v":3771970},{"$f":"D181+(D181*$L$99)","v":3809689.7},{"$f":"E181+(E181*$L$99)","v":3847786.5970000001},{"$f":"F181+(F181*$L$99)","v":3886264.4629700002},3925127.1075997003,3964378.3786756974,4004022.1624624543,4044062.3840870787,4084503.0079279495,{"$f":"SUM(C181:L181)","v":35337803.800722882}]
[null,"Amortissements ",0,{"$f":"$G$131","v":2549338.6866666665},{"$f":"$G$131","v":2549338.6866666665},2549338.6866666665,2549338.6866666665,2549338.6866666665,2549338.6866666665,2549338.6866666665,2549338.6866666665,2549338.6866666665,22944048.180000003]
[null,"Remboursement emprunt",0,{"$f":"IFERROR(INDEX($J$163:$J$172,MATCH(D179,$F$163:$F$172,0)),0)","v":11042201.909633094},{"$f":"IFERROR(INDEX($J$163:$J$172,MATCH(E179,$F$163:$F$172,0)),0)","v":11042201.909633094},11042201.909633094,11042201.909633094,0,0,0,0,0,44168807.638532378]
[null,"Bénéfice avant impôts ",0,{"$f":"D180-SUM(D181:D183)","v":268667.27870023996},{"$f":"E180-SUM(E181:E183)","v":3953296.2412002385},6246565.0854502358,8400354.6686052382,21582051.553521134,24348452.017223887,27395025.141693752,30749823.519151412,34443705.354301058,157387940.85984719]
[null,"Impôts sur le bénéfice ",0,{"$f":"IF(D184<0,0,0.3*D184)","v":80600.183610071981},{"$f":"IF(E184<0,0,0.3*E184)","v":1185988.8723600714},1873969.5256350706,2520106.4005815713,6474615.4660563404,7304535.6051671663,8218507.5425081253,9224947.0557454228,10333111.606290316,47216382.257954158]
[null,"Bénéfice après impôts ",0,{"$f":"D184-D185","v":188067.09509016798},{"$f":"E184-E185","v":2767307.3688401673},4372595.5598151647,5880248.2680236669,15107436.087464795,17043916.412056722,19176517.599185627,21524876.463405989,24110593.74801074,110171558.60189305]
[null,"Trésorerie",{"$f":"C180-C181","v":0},{"$f":"C187+D186","v":188067.09509016798},{"$f":"D187+E186","v":2955374.4639303354},{"$f":"E187+F186","v":7327970.0237454996},{"$f":"F187+G186","v":13208218.291769166},{"$f":"G187+H186","v":28315654.37923396},45359570.791290686,64536088.390476316,86060964.853882313,110171558.60189305,358123466.89131153]
[null,"Cash Flows",0,{"$f":"D186+D183-($H$173/$D$170)","v":9834967.5950901657},{"$f":"E186+E183-($H$173/$D$170)","v":12414207.868840165},14019496.059815161,15527148.768023666,13712134.677831698,15648615.002423625,17781216.189552531,20129575.053772893,22715292.338377643,141782653.55372757]
[null,"Cash Flows cumulés",{"$f":"-C181","v":0},{"$f":"C189+D188","v":9834967.5950901657},{"$f":"D189+E188","v":22249175.463930331},{"$f":"E189+F188","v":36268671.523745492},51795820.291769162,65507954.969600856,81156569.972024485,98937786.161577016,119067361.21534991,141782653.55372757,626600960.74681497]
[]
[]
[null,"Indicateurs économiques"]
[]
[null,"VAN",{"$f":"NPV(F194,IF(D179<=H194,D188,0),IF(E179<=H194,E188,0),IF(F179<=H194,F188,0),IF(G179<=H194,G188,0),IF(H179<=H194,H188,0),IF(I179<=H194,I188,0),IF(J179<=H194,J188,0),IF(K179<=H194,K188,0),IF(L179<=H194,L188,0))-D163","v":70248678.675545499},"FCFA","Taux d'actualisation",0.05,"Durée VAN (ans)",9,{"$nulls":5},{"$f":"-D163+IF(H194>=D179,(D186+D183-H173/D170)*((1+F194)^-1),0)+IF(H194>=E179,(E186+E183-H173/D170)*((1+F194)^-2),0)+IF(H194>=F179,(F186+F183-H173/D170)*((1+F194)^-3),0)+IF(H194>=G179,(G186+G183-H173/D170)*((1+F194)^-4),0)+IF(H194>=H179,(H186+H183-H173/D170)*((1+F194)^-5),0)+IF(H194>=I179,(I186+I183-H173/D170)*((1+F194)^-6),0)+IF(H194>=J179,(J186+J183-H173/D170)*((1+F194)^-7),0)+IF(H194>=K179,(K186+K183-H173/D170)*((1+F194)^-8),0)+IF(H194>=L179,(L186+L183-H173/D170)*((1+F194)^-9),0)","v":70248678.675545529},"calcul VAN"]
[null,"TRI",{"$f":"IRR(N195:W195)","v":0.32157492450046066},{"$nulls":10},{"$f":"-D163","v":-38587602},{"$f":"IF(D179<=H194,D188,0)","v":9834967.5950901657},{"$f":"IF(E179<=H194,E188,0)","v":12414207.868840165},{"$f":"IF(F179<=H194,F188,0)","v":14019496.059815161},{"$f":"IF(G179<=H194,G188,0)","v":15527148.768023666},{"$f":"IF(H179<=H194,H188,0)","v":13712134.677831698},{"$f":"IF(I179<=H194,I188,0)","v":15648615.002423625},{"$f":"IF(J179<=H194,J188,0)","v":17781216.189552531},{"$f":"IF(K179<=H194,K188,0)","v":20129575.053772893},{"$f":"IF(L179<=H194,L188,0)","v":22715292.338377643}]
[null,"RSI",{"$f":"SUM(O195:W195)/D163","v":3.6743058963272079},{"$f":"\"Pour 1000 CFA investis, on récupère \"&ROUND(N196,0)&\" CFA\"","v":"Pour 1000 CFA investis, on récupère 2674 CFA"},{"$nulls":9},{"$f":"(C196-1)*1000","v":2674.3058963272078}]
[null,"DRCI",{"$f":"N197+(-P197/(O197-P197))","v":{"$error":"#N/A"}},{"$f":"\"Le délai de récupération est de \"&ROUNDDOWN(C197,0)&\" ans et \"&ROUNDDOWN((C197-ROUNDDOWN(C197,0))*12,0)&\" mois\"","v":{"$error":"#N/A"}},{"$nulls":9},{"$f":"IF(AND(L189<0,L179<=H194),L179,IF(AND(K189<0,K179<=H194),K179,IF(AND(J189<0,J179<=H194),J179,IF(AND(I189<0,I179<=H194),I179,IF(AND(H189<0,H179<=H194),H179,IF(AND(G189<0,G179<=H194),G179,IF(AND(F189<0,F179<=H194),F179,IF(AND(E189<0,E179<=H194),E179,IF(AND(D189<0,D179<=H194),D179,IF(AND(C189<0,C179<=H194),C179))))))))))","v":false},{"$f":"INDEX(C189:L189,MATCH(INDEX(C179:L179,MATCH(P197,C189:L189,0))+1,C179:L179,0))","v":{"$error":"#N/A"}},{"$f":"IF(AND(L189<0,L179<=H194),L189,IF(AND(K189<0,K179<=H194),K189,IF(AND(J189<0,J179<=H194),J189,IF(AND(I189<0,I179<=H194),I189,IF(AND(H189<0,H179<=H194),H189,IF(AND(G189<0,G179<=H194),G189,IF(AND(F189<0,F179<=H194),F189,IF(AND(E189<0,E179<=H194),E189,IF(AND(D189<0,D179<=H194),D189,IF(AND(C189<0,C179<=H194),C189))))))))))","v":false}]
[null,"DSCR",{"$f":"(D180-D181)/(D183)","v":1.2552032636632471}]

{"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é'!D169","v":7.0000000000000007E-2}]
["Capital emprunté",{"$f":"'Table rentabilité'!D168","v":38587602}]
["Durée du prêt (en année)",{"$f":"'Table rentabilité'!D170","v":4},{"$f":"B4*12","v":48}]
["Mensualité à régler",{"$f":"-PMT((1+B2)^(1/12)-1,B4*12,B3)","v":920183.4924694245},"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":702003.58061009401},"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":218179.91185933052},"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":920183.4924694245},{"$f":"IF(A14<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":702003.58061009401},{"$f":"IF(A14<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A14,$B$4*12,$B$3),\"\")","v":218179.91185933052},{"$f":"IF(A14<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A14,0),\"\")","v":37885598.419389904},{"$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":920183.4924694245},{"$f":"IF(A15<>\"-\",-PPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":705972.81091734255},{"$f":"IF(A15<>\"-\",-IPMT((1+$B$2)^(1/12)-1,A15,$B$4*12,$B$3),\"\")","v":214210.68155208195},{"$f":"IF(A15<>\"-\",$B$3+CUMPRINC((1+$B$2)^(1/12)-1,$B$4*12,$B$3,1,A15,0),\"\")","v":37179625.608472563},{"$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},920183.49246942461,709964.48382982449,210219.00863960007,36469661.124642737,{"$f":"IF(A16<>\"-\",IF(G15<G16,F15,F15+1),\"\")","v":1},{"$f":"IF(A16=\"-\",\"\",IF(G15<12,G15+1,1))","v":3}]
[4,920183.49246942461,713978.72624129243,206204.76622813215,35755682.398401447,1,4]
[5,920183.49246942438,718015.665762975,202167.82670644944,35037666.732638471,1,5]
[6,920183.4924694245,722075.43072763353,198108.06174179097,34315591.30191084,1,6]
[7,920183.49246942461,726158.15019364096,194025.34227578368,33589433.151717201,1,7]
[8,920183.49246942438,730263.95394908485,189919.53852033953,32859169.197768111,1,8]
[9,920183.49246942438,734392.97251589445,185790.51995352996,32124776.225252219,1,9]
[10,920183.4924694245,738545.33715398808,181638.15531543639,31386230.888098229,1,10]
[11,920183.4924694245,742721.17986544699,177462.31260397748,30643509.708232783,1,11]
[12,920183.4924694245,746920.63339871145,173262.85907071305,29896589.074834071,1,12]
[13,920183.4924694245,751143.83125280053,169039.66121662394,29145445.243581269,2,1]
[14,920183.4924694245,755390.90768155653,164792.58478786793,28390054.335899718,2,2]
[15,920183.4924694245,759661.99769791204,160521.49477151243,27630392.338201802,2,3]
[16,920183.49246942461,763957.23707818286,156226.25539124169,26866435.101123616,2,4]
[17,920183.49246942461,768276.76236638334,151906.73010304122,26098158.338757232,2,5]
[18,920183.49246942461,772620.71087856789,147562.78159085667,25325537.627878666,2,6]
[19,920183.4924694245,776989.22070719569,143194.2717622288,24548548.407171469,2,7]
[20,920183.49246942461,781382.43072552094,138801.06174390361,23767165.976445947,2,8]
[21,920183.49246942438,785800.48059200705,134383.01187741739,22981365.495853946,2,9]
[22,920183.49246942461,790243.51075476734,129939.98171465726,22191121.985099174,2,10]
[23,920183.4924694245,794711.66245602828,125471.83001339623,21396410.322643146,2,11]
[24,920183.49246942461,799205.07773662126,120978.41473280331,20597205.244906522,2,12]
[25,920183.4924694245,803723.89944049658,116459.59302892791,19793481.345466029,3,1]
[26,920183.49246942461,808268.27121926553,111915.22125015904,18985213.07424676,3,2]
[27,920183.49246942438,812838.33753676584,107345.1549326586,18172374.736709997,3,3]
[28,920183.49246942461,817434.24367365567,102749.24879576892,17354940.493036345,3,4]
[29,920183.49246942461,822056.13573203015,98127.35673739441,16532884.357304309,3,5]
[30,920183.4924694245,826704.16064006754,93479.331829356946,15706180.196664248,3,6]
[31,920183.4924694245,831378.46615669935,88805.026312725138,14874801.730507545,3,7]
[32,920183.49246942461,836079.20087630744,84104.291593117174,14038722.529631235,3,8]
[33,920183.4924694245,840806.51423344761,79376.978235976916,13197916.015397787,3,9]
[34,920183.4924694245,845560.55650760094,74622.935961823561,12352355.458890185,3,10]
[35,920183.49246942438,850341.47882795008,69842.013641474259,11502013.980062239,3,11]
[36,920183.49246942438,855149.43317818455,65034.059291239842,10646864.546884049,3,12]
[37,920183.4924694245,859984.57240133127,60198.920068093175,9786879.9744827226,4,1]
[38,920183.4924694245,864847.05020461406,55336.442264810474,8922032.9242781065,4,2]
[39,920183.49246942461,869737.02116433962,50446.471305085004,8052295.9031137638,4,3]
[40,920183.49246942438,874654.64073081128,45528.851738613055,7177641.2623829618,4,4]
[41,920183.4924694245,879600.06523327215,40583.427236152325,6298041.1971496828,4,5]
[42,920183.4924694245,884573.45188487228,35610.040584552233,5413467.7452648096,4,6]
[43,920183.4924694245,889574.95878766826,30608.53368175622,4523892.7864771485,4,7]
[44,920183.4924694245,894604.74493764876,25578.747531775687,3629288.0415394902,4,8]
[45,920183.4924694245,899662.97022978892,20520.522239635608,2729625.0713097006,4,9]
[46,920183.4924694245,904749.79546313302,15433.697006291519,1824875.2758465782,4,10]
[47,920183.4924694245,909865.38234590669,10318.110123517781,915009.89350066334,4,11]
[48,920183.4924694245,915009.89350065752,5173.5989687669353,0,4,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,"Pompe solaires (55 KW)",1,5824300,{"$f":"C4*D4","v":5824300},10,{"$f":"E4/F4","v":582430}]
[null,"accessoirs pompe",1,2231250,2231250,10,223125]
[null,"Champs solaire (81,9 KWc)",1,17541678,17541678,25,701667.12]
[null,"cloture grillage",1,2493750,2493750,10,249375]
[null,"Genie civil (structures modules)",1,3187500,3187500,15,212500]
[null,"conditionneur d'energie + protection ",1,3252999,3252999,10,325299.90000000002]
[null,"accessoirs cablages + protection",1,3128125,{"$f":"C10*D10","v":3128125},15,{"$f":"E10/F10","v":208541.66666666666}]
[null,"ligne d'aspiration (PeHD)",1,178000,{"$f":"C11*D11","v":178000},20,{"$f":"E11/F11","v":8900}]
[null,"ligne de refoulement (PeHD)",1,750000,750000,20,37500]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"C16*D16","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"C21*D21","v":0}]
[{"$nulls":4},0]
[null," TOTAL (F CFA) ",null,null,{"$f":"SUM(E4:E22)","v":38587602},null,{"$f":"SUM(G4:G22)","v":2549338.6866666665}]

{"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)."]