{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","Cap.Goods","BUDGET","Bayes","Staff","Bayes5"],"not_rendered":{"charts":2,"images":84,"macros":1,"external_links":3,"defined_names":60,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":102,"n_cols":23,"rows_kept":102,"cut":false,"hidden":false,"merged":[[28,2,28,4],[23,2,23,4],[0,2,0,4],[22,2,22,4],[10,6,10,7],[11,6,11,7],[20,1,20,2],[6,0,7,1],[13,7,14,8],[3,5,3,6],[4,5,4,6],[4,7,5,11],[21,2,21,3],[10,0,10,1],[12,2,13,3],[22,0,22,1],[55,15,55,16],[44,0,45,0],[29,10,29,11],[30,12,30,13],[46,15,46,17],[29,12,29,13],[29,14,29,15],[30,0,30,2],[29,8,29,9],[29,6,29,7],[46,7,46,9],[44,1,44,4],[42,2,42,3],[54,8,55,8],[95,5,95,6],[80,5,80,6],[65,1,65,2],[48,8,48,9],[47,6,61,6],[60,8,60,9],[61,8,61,9],[49,7,49,9],[56,7,56,9],[59,8,59,9],[53,7,53,9],[64,5,64,6],[51,8,52,8],[90,2,91,2],[87,6,88,6],[57,8,58,8],[31,21,32,21],[30,6,30,7],[30,14,30,15],[30,10,30,11],[30,8,30,9],[27,10,27,11],[14,16,18,16],[21,10,21,11],[25,10,25,11],[23,10,23,11],[15,5,16,7],[14,11,14,12],[19,10,19,11],[10,13,11,15],[0,19,0,21],[6,20,6,21],[2,16,4,16],[5,15,6,17],[1,15,1,17],[18,19,18,20],[19,19,19,20],[7,12,7,15],[9,6,9,7],[20,19,20,20],[22,19,22,20],[13,18,13,20],[21,19,21,20],[14,19,14,20],[15,19,15,20],[16,19,16,20],[17,19,17,20]]}
[0,null,"Alternative Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do you need free browsing the program file?",null,"          Exchange Rates"]
[null,null,null,"EXPECTED FINAL RESULT OF PRE DESIGN ",null,null,null,null,null,null,null,null,null,null,null,"Click down",null,null,null,1,1.96,{"$f":"V3/T3","v":1.2195121951219512}]
[null,null,"            SALES, Loan Life",{"$f":"SUM(D4:D7)","v":13222400},{"$f":"SUM(E4:E7)","v":25915904},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82,null,1]
[null,null,"          Tomatoes (T )",{"$f":"ROUND(Q22,-2)","v":9757700},{"$f":"D4*$U$2","v":19125092},"    BROWSING",null,"    Represented by local outsourcing east electric company Ltd., Bulgaria "]
[null,null,"          Cucumbers (C )",{"$f":"ROUND(Q24,-2)","v":3464700},{"$f":"D5*$U$2","v":6790812},"    OPERATIONS ",null,"TomCuc Greenhouse"]
[null,null,"            By/3th products",{"$f":"H26+J26+L26+N26+P26+T26","v":0},{"$f":"D6*$U$2","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-08-16"}]
[" Click the picture \u0093 to increase it",null,"         Market Products",{"$f":"Q28","v":0},{"$f":"D7*$U$2","v":0},null,"    ←Level 5    →",null,"Zoom↓","Risk assessment and management Go to Bayes Theorem"]
[null,null,"           COSTS, Total",{"$f":"SUM(D9:D10)","v":4994606.4288308043},{"$f":"SUM(E9:E10)","v":9789428.600508377},null,"        ←Level 4   →",null,null,"Sensitivity analysis",null,null,"              ←Zoom 100  PC screen resolution: 1920 x 1080"]
[null,null,"        Variable costs",{"$f":"BUDGET!C23","v":2862858.8359850743},{"$f":"D9*$U$2","v":5611203.3185307458},null,"           ←Level 3",null,null," Resolution 1680 x 1050. For lower PC screen resolution try this → "]
["  T","           C","         Fixed costs",{"$f":"BUDGET!C24","v":2131747.5928457305},{"$f":"D10*$U$2","v":4178225.2819776316},null," ←Level 2",null,"Zoom 143","Cash-flow Pro-forma Budgeting ",null,null,null," 1920 x 1080"]
["    By-products",null,"         Revenues /Costs",{"$f":"ROUND(D3-D8,-3)","v":8228000},{"$f":"ROUND(E3-E8,-3)","v":16126000},null,"        ←Level 1",null,"→","Capital Goods and Services         ",null,null,null,"Select Zoom 100 if Resolution of your display is lesser than 1600 x 900."]
[null,null,"         Marketing / RM",{"$f":"BUDGET!C25","v":86632.976706494374},{"$f":"D12*$U$2","v":169800.63434472895},null,"              ←Level 0",null,"Basic data, invariant for this Project"]
[null,null,"From market Bad,  is selected over underground water resource Increase / Decrease ",null,{"$f":"E5*(1-E15)","v":7849929.4678899078}]
["Efficiency of selling own products",null,null,null,{"$f":"E13*(1+E16)","v":10548342.722477064},null,null,"   Level        Go dowm",null,null,null,null,null,null,null,null,null,null,"  Credit-bank Loan Tranches "]
["Increased sale of final products",null,109,92,{"$f":"(D15-C15)/C15","v":-0.15596330275229359},null,null,null,null,null,null,"Quality Evaluation",null,{"$f":"U38/M16","v":678.92849999999999},"t p.a./ 1 ha","relative yield","Demand increases",null,"1․",500000]
["       Increased the sale price, €",null,3.2,4.3,{"$f":"(D16-C16)/C16","v":0.34374999999999989}," \u0085 Click the image  to reveal the final results",null,null,null,null,null,"Area ",{"$f":"A99","v":4},{"$f":"M16*N17","v":2808},"t p.a. Project",null,null,null,"2․",500000]
[null,null,null,null,{"$f":"E13/E14","v":0.7441860465116279},null,null,null,null,null,"T≈",0.7,{"$f":"M16*L17","v":2.8},{"$f":"U36/M17","v":702},"t p.a./ 1 ha","Max size:",null,null,"3․",1500000]
["          Overall probability of Bad event - lost profits due to the wholesalers distribution.",null,null,null,null,null,null,null,null,null,"C≈",{"$f":"100%-L17","v":0.30000000000000004},{"$f":"M16*L18","v":1.2000000000000002},{"$f":"U37/M18","v":625.09500000000003},"t p.a./ 1 ha",13.2384]
[null,null,null,null,"Revenue increase due to better distribution, TOTAL:","7-Yr Option","FINAL PRODUCTS FOR SALE",null,null,null,"Other≈",{"$f":"100%-L17-L18","v":0},{"$f":"M16*L19","v":0},null,null,null,null,null,"4․",1500000]
[null,"     The  greenhouse complex",null,null,"Loans A + B - D Investment, TOTAL:","Sales  Nr of Yrs:",null,null,null,{"$f":"BUDGET!G41","v":1},"  2,              3,",null,null,{"$f":"BUDGET!M41","v":4},null,{"$f":"BUDGET!O41","v":5},null,null,"5․",1000000]
["Creditor ECA \u0086","    Project Finance",null,null,{"$f":"Bayes!P21/100","v":2.0999999999999998E-2},"Products","t p.a.","Total, €","t p.a.","Total, €",null,null,"t p.a.","Total, €","t p.a.","Total, €","Check",null,"6․",1000000]
["  Export Credit Insurance ",null,"            Financial Modeling",null,{"$f":"E14*(1-E21)","v":10326827.525305046},"Tomatoes  T",{"$f":"U36","v":1965.6},{"$f":"U39","v":1951544.0322},{"$f":"U36","v":1965.6},{"$f":"U39","v":1951544.0322},". . . . . .",null,{"$f":"U36","v":1965.6},{"$f":"U39","v":1951544.0322},{"$f":"U36","v":1965.6},{"$f":"U39","v":1951544.0322},{"$f":"P22*P20","v":9757720.1610000003},null,"SubTOTAL (4.+ 5.+ 6.):",{"$f":"SUM(T19:U21)","v":3500000}]
["                        Marketing",null,"              Business Plan \u0085  East Electric Company",null,null,"Outcome:",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"SUM(T15:U17)+T22","v":6000000}]
[null,null,"           Risk Assessment \u0085   Equivalence Ltd.\u0086",null,null,"Cucumbers C",{"$f":"U37","v":750.11400000000015},{"$f":"U40","v":692930.22624000011},{"$f":"U37","v":750.11400000000015},{"$f":"U40","v":692930.22624000011},". . . . . .",null,{"$f":"U37","v":750.11400000000015},{"$f":"U40","v":692930.22624000011},{"$f":"U37","v":750.11400000000015},{"$f":"U40","v":692930.22624000011},{"$f":"P24*P20","v":3464651.1312000006}]
[null,null,null,"Greenhouse platform construction",null,"Outcome:"]
[null,null,null,"& infrastructure, power connection",null,"By-products",null,null,null,null,". . . . . .",null,null,null,null,null,{"$f":"P26*P20","v":0}]
[null,null,null,"            \u0087   Construction company",null,"2ndstage of project"]
["  Products:",null,null,"      Intellectual products:",null,"Others, fromarket",null,{"$f":"BUDGET!G49+BUDGET!H49","v":0.5},null,{"$f":"BUDGET!I49+BUDGET!J49","v":800},". . . . . .",null,null,{"$f":"BUDGET!N49+BUDGET!O49","v":0},null,{"$f":"BUDGET!P49+BUDGET!Q49","v":0},{"$f":"O28*P20","v":0}]
["                        Cucumbers ←",null,"                ← Risk assessment & management",null,null,"Outcome:"]
["                  Tomatoes  ←",null,null,"← Online cash-flow control system ",null,"Budget, TOTAL",{"$f":"H22+H24+H26+H28","v":2644474.75844},null,{"$f":"J22+J24+J26+J28","v":2645274.25844},null,". . . . . .",null,{"$f":"N22+N24+N26+N28","v":2644474.25844},null,{"$f":"P22+P24+P26+O28","v":2644474.25844},null,{"$f":"Q22+Q24+Q26+Q28","v":13222371.292200001}]
[" By-products of tomatoes & cucumbers  ←",null,null,"← History of sales and costs ",null,"Outcome, TOTAL",{"$f":"H23+H25+H27+H29","v":0},null,{"$f":"J23+J25+J27+J29","v":0},null,{"$f":"L23+L25+L27+L29","v":0},null,{"$f":"N23+N25+N27+N29","v":0},null,{"$f":"P23+P25+P27+P29","v":0}]
["The applied color and image visualizations in all worksheets are designed for faster and easier perception of the figures and formulas, as well as for their long term remembering for project financing success.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¯ Basic unchangeable values for transfer to upper level Ö","Average"]
[null,null,null,null,null,null,null,"Sales    Mo:",1,{"$f":"I33+1","v":2},{"$f":"J33+1","v":3},4,5,6,7,8,9,10,11,12,"Total/Average"]
[null,null,null,null,null,null,null,"SingleT Price,€/kg",{"$f":"C50","v":1.6442999999999999},{"$f":"C51","v":2.6892},{"$f":"C52","v":2.0898000000000003},{"$f":"C53","v":1.5066000000000002},{"$f":"C54","v":1.1421000000000001},{"$f":"C55","v":0.7128000000000001},{"$f":"C56","v":0.59887350000000017},{"$f":"C57","v":0.54270000000000007},{"$f":"C58","v":0.7128000000000001},{"$f":"C59","v":1.4256000000000002},{"$f":"C60","v":1.0935000000000001},{"$f":"C61","v":1.4256000000000002},{"$f":"SUM(I34:T34)/12","v":1.2986561249999999},"/kg"]
[null,null,null,null,null,null,null,"SingleC  Price, €/kg",{"$f":"F50","v":1.3440000000000001},{"$f":"F51","v":1.1927999999999999},{"$f":"F52","v":1.3524},{"$f":"F53","v":1.4531999999999998},{"$f":"F54","v":1.0247999999999999},{"$f":"F55","v":0.66359999999999997},{"$f":"F56","v":0.51239999999999997},{"$f":"F57","v":0.64680000000000004},{"$f":"F58","v":1.2431999999999999},{"$f":"F59","v":0.84},{"$f":"F60","v":1.8480000000000001},{"$f":"F61","v":0.74759999999999993},{"$f":"SUM(I35:T35)/12","v":1.0724},"/kg"]
[null,null,null,null,null,null,null,"This caseT yield,kg",{"$f":"A50*$M$17*10000","v":0},{"$f":"A51*$M$17*10000","v":0},{"$f":"A52*10000*$M$17","v":123199.99999999999},{"$f":"A53*$M$17*10000","v":240799.99999999997},{"$f":"A54*$M$17*10000","v":271599.99999999994},{"$f":"A55*$M$17*10000","v":288400},{"$f":"A56*$M$17*10000","v":305200},{"$f":"A57*$M$17*10000","v":274400},{"$f":"A58*$M$17*10000","v":210000},{"$f":"A59*$M$17*10000","v":131600},{"$f":"A60*$M$17*10000","v":75600},{"$f":"A61*$M$17*10000","v":44799.999999999993},{"$f":"SUM(I36:T36)/1000","v":1965.6},"/ha"]
[null,null,null,null,null,null,null,"This case C yield,kg",{"$f":"D50*M18*10000","v":0},{"$f":"D51*$M$18*10000","v":41932.800000000003},{"$f":"D52*10000*$M$18","v":75501.600000000006},{"$f":"D53*$M$18*10000","v":88861.200000000012},{"$f":"D54*$M$18*10000","v":28922.400000000005},{"$f":"D55*$M$18*10000","v":128466.00000000003},{"$f":"D56*$M$18*10000","v":136677.6},{"$f":"D57*$M$18*10000","v":120356.40000000002},{"$f":"D58*$M$18*10000","v":14527.2},{"$f":"D59*$M$18*10000","v":60268.80000000001},{"$f":"D60*$M$18*10000","v":35802.000000000007},{"$f":"D61*$M$18*10000","v":18798.000000000004},{"$f":"SUM(I37:T37)/1000","v":750.11400000000015},"/ha"]
[null,null,null,null,null,null,null,"This TOTAL YIELD",{"$f":"I36+I37","v":0},41932.800000000003,{"$f":"K36+K37","v":198701.59999999998},{"$f":"L36+L37","v":329661.19999999995},300522.39999999997,{"$f":"N36+N37","v":416866},441877.6,394756.4,224527.2,191868.80000000002,111402,63598,{"$f":"SUM(U36:U37)","v":2715.7139999999999},{"$f":"IF(SUM(I38:T38)/1000=U38,TRUE,FALSE)","v":true}]
[null,null,null,null,null,null,null,"This caseTsales, €\u0081",{"$f":"I36*I34","v":0},0,{"$f":"K36*K34","v":257463.36000000002},362789.27999999997,310194.36,205571.52000000002,{"$f":"O36*O34","v":182776.19220000005},148916.88000000003,149688.00000000003,187608.96000000002,82668.600000000006,63866.879999999997,{"$f":"SUM(I39:T39)","v":1951544.0322},"/ann"]
[null,null,null,null,null,null,null,"This caseC sales, €\u0081",{"$f":"I37*I35","v":0},{"$f":"J37*J35","v":50017.44384},{"$f":"K37*K35","v":102108.36384000001},{"$f":"L37*L35","v":129133.09583999999},{"$f":"M37*M35","v":29639.675520000004},{"$f":"N37*N35","v":85250.037600000011},70033.602239999993,77846.519520000016,18060.215039999999,50625.792000000009,66162.09600000002,14053.384800000002,{"$f":"SUM(I40:T40)","v":692930.22624000011},"/ann"]
[null,null,null,null,null,null,null,"Costs     ↓",null,null,null,null,null,null,null,null,null,null,null,"Sales:",{"$f":"SUM(U39:U40)","v":2644474.25844},"/ann"]
[null,null,null,null,null,null,null,"Pell+Trans.Heating",{"$f":"N66","v":27091.85325},{"$f":"N67","v":24628.996018656715},{"$f":"N68","v":20926.942242537312},{"$f":"N69","v":16008.854473880596},{"$f":"N70","v":7345.1183694029842},{"$f":"N71","v":0},{"$f":"N72","v":0},{"$f":"N73","v":0},{"$f":"N74","v":0},{"$f":"N75","v":12314.474470149255},{"$f":"N76","v":18471.711705223879},{"$f":"N77","v":20934.61601492537},{"$f":"SUM(I42:T42)","v":147722.56654477611},"/ann"]
[null,null,"     For Developer's use only",null,null,null,null,"This Packaging",{"$f":"I36*$G$68+I37*$G$71","v":0},{"$f":"J36*$G$68+J37*$G$71","v":1886.9760000000001},11405.572,{"$f":"L36*$G$68+L37*$G$71","v":19650.753999999997},{"$f":"M36*$G$68+M37*$G$71","v":18955.507999999998},24526.97,25988.491999999998,23252.038,14303.724,11266.096000000001,6525.09,3757.91,{"$f":"SUM(I43:T43)","v":161519.12999999998},"/ann"]
[null,null,null,null,null,null,null,"This Running cost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I44:T44)","v":0},"/ann"]
[" Tom.","                 I N F L O W   D A T A   W O R K I N G   P A N E L ",null,null,null,null,null,"Others fromarket",null,null,null,null,null,null,null,null,null,null,null,null,null,"/ann"]
[null,null,"DATA ENTRY PANEL FOR THE BASE Level 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     I  N  C  R  E  A  S  E  :","Æ  VAT","Æ Own Funds","Prc OwnFunds"]
["↑ Increase","C %+4%","          Potential YIELD and\n","SALES",null,null,null,"COSTS of fertilizer, seeding and substrate",null,null,"Water p.a.","Consumption","Electricity","This","Project","Budgeted values + VAT revivable",null,null,{"$f":"S48+S56","v":5618363.2835820895},{"$f":"M16","v":4},{"$f":"U48+U56","v":5446863.2835820895},{"$f":"V48+V56","v":5494863.2835820895},{"$f":"V47*T57","v":0}]
["price option"," Price",{"$f":"-IF(D49=0,0,(D49+3)/100)","v":-0.19}," Yield C  kg/m2","Price    ↑",{"$f":"-D49/100","v":-0.16},"These data are based on the EU FSS ",13.4,"←Total area as base",null,5,"liter p.m2",6,"Water +","Electricity","Local Costs","     ↓",1,{"$f":"SUM(S49:S55)+S64","v":768363.28358208947},"VAT",{"$f":"SUM(U49:U55)","v":768363.28358208947},{"$f":"SUM(V49:V55)","v":768363.28358208947},{"$f":"SUM(W49:W55)","v":757800}]
[" Yield T  kg/m2","   ↑   € /kg","€ /kg ",16,"€ /kg ",null,null,{"$f":"A99","v":4},"←This project   ↓",null,0.3," € p. liter",0.06,null,"↓","Permits & Construction, F26",null,null,80000,0,{"$f":"S49*(1+$T$49)","v":80000},{"$f":"U49*(1+T$60)","v":80000},{"$f":"V49*(1-$T$57)","v":80000}]
[0,2.0299999999999998,{"$f":"B50*(1+$C$48)","v":1.6442999999999999},0,1.6,{"$f":"E50*(1+$F$48)","v":1.3440000000000001},null,"  ↓       Fertilizers         ↓           .",null,null,0.218,{"$f":"$K$48*$K$49*$T$47*K50*10000","v":13080},{"$f":"K50*$M$48*$M$49*$T$47*10000","v":3139.2},null,null,"Terrain, infrastructure, F27",null,2.5000000000000001E-2,{"$f":"ROUNDUP(R50*S57,-2)","v":107800},"TOTAL",{"$f":"S50*(1+$T$49)","v":107800},{"$f":"U50*(1+T$60)","v":107800},{"$f":"V50*(1-$T$57)","v":107800}]
[0,3.32,{"$f":"B51*(1+$C$48)","v":2.6892},{"$f":"34944/10000","v":3.4944000000000002},1.42,{"$f":"E51*(1+$F$48)","v":1.1927999999999999},null,{"$f":"I84","v":33862.686567164179},-0.05,{"$f":"I52/$H$49","v":8042.3880597014922},0.17499999999999999,{"$f":"$K$48*$K$49*$T$47*K51*10000","v":10499.999999999998},{"$f":"$M$48*$M$49*$T$47*10000*K51","v":2520},null,null,"Others unforeseen exp. F29",null,15000,{"$f":"R51*$T$47","v":60000},null,{"$f":"S51*(1+$T$49)","v":60000},{"$f":"U51*(1+T$49)","v":60000},{"$f":"V51*(1-$T$57)","v":60000}]
[4.4000000000000004,2.58,{"$f":"B52*(1+$C$48)","v":2.0898000000000003},{"$f":"62918/10000","v":6.2918000000000003},1.61,{"$f":"E52*(1+$F$48)","v":1.3524},null,{"$f":"$J$51*M17","v":22518.686567164175},{"$f":"H51*(1+I51)","v":32169.552238805969},"€/ Yr/ ha",0.14099999999999999,{"$f":"$K$48*$K$49*$T$47*K52*10000","v":8459.9999999999982},2030.3999999999999,null,null,"Truck + buss→local transport",null,null,90000,"Local cost",{"$f":"S52*(1+$T$49)","v":90000},90000,{"$f":"V52*(1-$T$57)","v":90000}]
[8.6,1.86,{"$f":"B53*(1+$C$48)","v":1.5066000000000002},{"$f":"74051/10000","v":7.4051},1.73,{"$f":"E53*(1+$F$48)","v":1.4531999999999998},null,{"$f":"J51*M18","v":9650.8656716417918},null,null,6.4000000000000001E-2,{"$f":"$K$48*$K$49*$T$47*10000*K53","v":3840},921.6,null,null,"BizPlan, Fin. modeling, F33",null,{"$f":"IF($T$47>10,400000,IF($T$47<=5,230000,240000))","v":230000},{"$f":"R53","v":230000},"Exp-Imp",{"$f":"S53*(1+$T$49)","v":230000},230000,{"$f":"V63*(1-$T$57)","v":160000}]
[9.6999999999999993,1.41,{"$f":"B54*(1+$C$48)","v":1.1421000000000001},{"$f":"24102/10000","v":2.4102000000000001},1.22,1.0247999999999999,null,"                ↓        Seeding           ↓         ",null,null,0.01,600,144,"6 Mo","SubTOTAL","Risk Assessment, F34",null,{"$f":"IF($T$47>10,60000,IF($T$47<=5,30000,28000))","v":30000},{"$f":"R54","v":30000},59572.800000000003,30000,30000,{"$f":"V53*(1-$T$57)","v":230000}]
[10.3,0.88,0.7128000000000001,{"$f":"107055/10000","v":10.705500000000001},0.79,0.66359999999999997,null,{"$f":"I86","v":82149.253731343284},{"$f":"H55*(1+I51)","v":78041.79104477611},{"$f":"I55/$H$49","v":19510.447761194027},0.01,{"$f":"$K$48*$K$49*$T$47*10000*K55","v":600},144,"1 →",{"$f":"SUM(L50:L55)+SUM(M50:M55)","v":45979.199999999997},"Plants' mater's, seeding, F30",null,{"$f":"J51+J55+J58","v":42640.820895522382},{"$f":"R55*T47","v":170563.28358208953},null,{"$f":"S55*(1+$T$49)","v":170563.28358208953},170563.28358208953,{"$f":"V54*(1-$T$57)","v":30000}]
[10.9,0.73935000000000017,{"$f":"B56*(1+$C$48)","v":0.59887350000000017},{"$f":"113898/10000","v":11.389799999999999},0.61,0.51239999999999997,null,{"$f":"J55*$T$47","v":78041.79104477611},null,"€/ Yr/ ha",0,0,0,null,null," Greenhouse Import ↓",null,"Basic data↓",{"$f":"ROUND(SUM(S57:S62)+S63,-4)","v":4850000},"OwnFunds",{"$f":"SUM(U57:U63)","v":4678500},{"$f":"SUM(V57:V63)","v":4726500},{"$f":"SUM(W58:W62)","v":4556000}]
[9.8000000000000007,0.67,0.54270000000000007,{"$f":"100297/10000","v":10.0297},0.77,0.64680000000000004,null,"Biennially          ↓    Substrate ↓ Biennially",null,null,0,0,0,null,null,"Greenhouse (Cap.Goods F7)",null,{"$f":"ROUND(A100,-3)","v":4310000},{"$f":"R57","v":4310000},0,{"$f":"S57*(1+$T$49)","v":4310000},{"$f":"U57*(1+T$60)","v":4310000},{"$f":"V56*(1-$T$57)","v":4726500}]
[7.5,0.88,{"$f":"B58*(1+$C$48)","v":0.7128000000000001},{"$f":"12106/10000","v":1.2105999999999999},1.48,1.2431999999999999,null,{"$f":"I88","v":63528.358208955222},{"$f":"H58*(1+I51)","v":60351.940298507456},{"$f":"I58/$H$49","v":15087.985074626864},8.9999999999999993E-3,540,129.6,null,null,"Construct+installation Cntr.",null,null,170000,"+",null,{"$f":"U59*(1+T$60)","v":150000},{"$f":"V57*(1-$T$57)","v":4310000}]
[4.7,1.76,{"$f":"B59*(1+$C$48)","v":1.4256000000000002},{"$f":"50224/10000","v":5.0224000000000002},1,0.84,null,{"$f":"J58*$T$47/2","v":30175.970149253728},null,"€/ Yr/ ha",6.2E-2,3720,892.8,null,null,"Truck transport, F",null,null,150000,{"$f":"T60-T57","v":0},{"$f":"S59*(1+$T$57)","v":150000},{"$f":"U60*(1+T$60)","v":10500}]
[2.7,1.35,1.0935000000000001,{"$f":"29835/10000","v":2.9834999999999998},2.2000000000000002,1.8480000000000001,null,"q   Biennially   s","s   Biennially   q",null,0.12,{"$f":"$K$48*$K$49*$T$47*10000*K60","v":7200},1728,"6 Mo","SubTOTAL","1 Yr Supervision","F10→ 2 ",1,{"$f":"A92*R60","v":10500},{"$f":"((100/(100-T57*100)*100-100)/100)","v":0},{"$f":"S60*(1+$T$57)","v":10500},{"$f":"U61*(1+T$60)","v":48000},{"$f":"V58*(1-$T$57)","v":150000}]
[1.6,1.76,1.4256000000000002,{"$f":"15665/10000","v":1.5665},0.89,0.74759999999999993,null,"TOTAL","TOTAL",null,0.191,11460,2750.4,"2 →",{"$f":"SUM(L56:L61)+SUM(M56:M61)","v":28420.799999999999},"Management.&Training, F10",null,"\u0092",{"$f":"A91","v":48000},"Σ over↓",{"$f":"S61*(1+$T$49)","v":48000},{"$f":"U61*(1+T$60)","v":48000},{"$f":"V60*(1-$T$57)","v":48000}]
[{"$f":"SUM(A50:A61)","v":70.2},{"$f":"SUM(B50:B61)/12","v":1.603279166666667},{"$f":"SUM(C50:C61)/12","v":1.2986561249999999},{"$f":"SUM(D50:D61)","v":62.509499999999996},{"$f":"SUM(E50:E61)/12","v":1.2766666666666666},{"$f":"SUM(F50:F61)/12","v":1.0724},null,{"$f":"H52+H53+H56+H59","v":140387.3134328358},{"$f":"H52+H53+H56","v":110211.34328358207},null,{"$f":"SUM(K50:K61)","v":1},{"$f":"SUM(L50:L61)","v":60000},{"$f":"SUM(M50:M61)","v":14399.999999999998},null,"←Change↓",null,null,null,null,null,null,null,{"$f":"V61*(1-$T$57)","v":48000}]
["TOTAL","Average",{"$f":"B63","v":"Average"},"TOTAL","Average",{"$f":"E63","v":"Average"},null,null,null,"Pellets  →","Conventional","HEATING","Consumption",0,"Location↑","Risk Assessment software",null,null,{"$f":"240000*C97","v":160000},null,{"$f":"S63*(1+$T$49)","v":160000},{"$f":"U63*(1+T$60)","v":160000},{"$f":"V59*(1-$T$57)","v":10500}]
[null,"min. Price exWarehouse, LondonÒ",1.2,null,"m",null,null,155,"Tansport →",20,350,{"$f":"K64/J64/1000","v":1.7500000000000002E-2},".+ Transport","This project",null,"Exclusive, F29",{"$f":"IF(N63>0,5.7,0)","v":0},0,{"$f":"Q64*R64","v":0}]
[null,"Ý  Resource:  Nov. 2016",1.35,"Other product","Price in €","                   PACKING",null,"           Pellets  →","kg p.Mo↓","kg p.1ha",{"$f":"H64/1000","v":0.155},"Transp. p.ha","€/Mo/ha","€ p.↓Mo"]
["Spain yiels T + C:","Average price ↓ in Holland",null," Yield ↓  kg/m2","€ /kg ",null,"T",null,575463,{"$f":"I66/$H$48","v":42945},{"$f":"J66*$K$65*(1+$N$63)","v":6656.4750000000004},{"$f":"K66*$L$64","v":116.48831250000002},{"$f":"K66+L66","v":6772.9633125},{"$f":"M66*$T$47","v":27091.85325}]
["Kg","Kg/m2","€ /kg ",null,null,10,0.65,null,523149,{"$f":"I67/$H$48","v":39040.970149253728},{"$f":"J67*$K$65*(1+$N$63)","v":6051.350373134328},{"$f":"K67*$L$64","v":105.89863152985075},{"$f":"K67+L67","v":6157.2490046641788},{"$f":"M67*$T$47","v":24628.996018656715}]
[264768,{"$f":"A68/$C$82","v":4.5361842105263159},1.21,null,null,1,{"$f":"G67/F67","v":6.5000000000000002E-2},null,444513,{"$f":"I68/$H$48","v":33172.611940298506},{"$f":"J68*$K$65*(1+$N$63)","v":5141.7548507462679},{"$f":"K68*$L$64","v":89.980709888059693},{"$f":"K68+L68","v":5231.7355606343281},{"$f":"M68*$T$47","v":20926.942242537312}]
[728112,12.474506578947368,2.83,"Here ↗","Image of new product",null,"C",null,340047,{"$f":"I69/$H$48","v":25376.641791044774},{"$f":"J69*$K$65","v":3933.3794776119398},68.834140858208954,{"$f":"K69+L69","v":4002.213618470149},{"$f":"M69*$T$47","v":16008.854473880596}]
[1125264,19.278782894736842,1.85,null,null,10,0.45,null,156019,{"$f":"I70/$H$48","v":11643.208955223879},{"$f":"J70*$K$65*(1+$N$63/1.5)","v":1804.6973880597013},{"$f":"K70*$L$64","v":31.582204291044775},{"$f":"K70+L70","v":1836.279592350746},{"$f":"M70*$T$47","v":7345.1183694029842},null,null,null,null,null,null,null,"iGo to Level"]
[1191456,20.412828947368421,1.33,null,null,1,{"$f":"G70/F70","v":4.4999999999999998E-2},null,0,0,{"$f":"J71*$K$65*(1+$N$63)","v":0},0,{"$f":"K71+L71","v":0},0]
[1059072,18.144736842105264,1.01,null,null,null,null,null,0,0,{"$f":"J72*$K$65*(1+$N$63)","v":0},0,0,0]
[0,0,0.63,null,null,null,null,null,0,0,{"$f":"J73*$K$65*(1+$N$63)","v":0},0,0,0]
[369152,6.3245614035087723,0.53,null,null,null,null,null,0,0,{"$f":"J74*$K$65*(1+$N$63)","v":0},0,0,0]
[595728,10.206414473684211,0.51,null,null,null,null,null,261574,19520.447761194031,{"$f":"J75*$K$65*(1+$N$63/3)","v":3025.6694029850746},52.949214552238814,3078.6186175373136,12314.474470149255]
[728112,12.474506578947368,0.63,null,null,null,null,null,392361,29280.671641791043,{"$f":"J76*$K$65*(1+$N$63)","v":4538.5041044776117},79.423821828358214,{"$f":"K76+L76","v":4617.9279263059698},18471.711705223879]
[369152,6.3245614035087723,1.01,null,null,null,null,null,444676,33184.776119402981,{"$f":"J77*$K$65*(1+$N$63)","v":5143.6402985074619},90.013705223880592,5233.6540037313425,20934.61601492537]
[132384,2.268092105263158,0.95,null,null,null,null,null,{"$f":"SUM(I66:I77)/10000","v":313.78019999999998},{"$f":"SUM(J66:J77)","v":234164.32835820894},{"$f":"SUM(K66:K77)","v":36295.470895522383},{"$f":"SUM(L66:L77)","v":635.17074067164185},{"$f":"SUM(M66:M77)","v":36930.641636194028},{"$f":"SUM(N66:N77)","v":147722.56654477611}]
[264768,4.5361842105263159,1.26,null,null,null,null,null,null,null,null,null,null,"ha"]
[{"$f":"SUM(A68:A79)","v":6827968},{"$f":"SUM(B68:B79)","v":116.98135964912279},"   ↙        OFFERS        ↘",{"$f":"SUM(D68:D79)","v":0},{"$f":"SUM(E68:E79)/12","v":0}]
["① Spain","Polycarbonate","Production + Nursery","②"," Canada          ③","           Netherland–Poland",null,null,"VEGETABLE MATERIALS for",{"$f":"A99","v":4}]
[{"$f":"13810*2","v":27620},"Product zones 1+3",58368,"Sector 1",{"$f":"158.15*351","v":55510.65},null,null,"Year",1,{"$f":"I82+1","v":2},{"$f":"J82+1","v":3},4,5,6,7,8]
[{"$f":"14330*2","v":28660},"Product zones 2+4",{"$f":"C82/10000","v":5.8368000000000002},"Sector 2",{"$f":"158.15*351","v":55510.65},null,{"$f":"H48","v":13.4},"Fertilizers:",113440,113440,113440,113440,113440,113440,113440,113440]
[2700,"Cenrtral warehouse",null,null,null,null,{"$f":"A99","v":4},"Fertilizers:",{"$f":"I83*$G$84/$G$83","v":33862.686567164179},{"$f":"J83*$G$84/$G$83","v":33862.686567164179},{"$f":"K83*$G$84/$G$83","v":33862.686567164179},33862.686567164179,33862.686567164179,33862.686567164179,33862.686567164179,33862.686567164179]
[{"$f":"SUM(A82:A84)","v":58980},"Ç   TOTAL surface greenhouse+nursery",null,"Service area",{"$f":"ROUND(28.8*42.25,-1)","v":1220},null,null,"Seeding:",275200,275200,275200,275200,275200,275200,275200,275200]
[2246,"Nursery ↑ included",null,"Central coridor",{"$f":"ROUND((3.25*351),-1)","v":1140},null,null,"Seeding:",{"$f":"I85*$G$84/$G$83","v":82149.253731343284},{"$f":"J85*$G$84/$G$83","v":82149.253731343284},{"$f":"K85*$G$84/$G$83","v":82149.253731343284},82149.253731343284,82149.253731343284,82149.253731343284,82149.253731343284,82149.253731343284]
[{"$f":"A85/10000","v":5.8979999999999997},"Ç      Surface    È",null,"Surface È",{"$f":"SUM(E82:E83)/10000","v":11.102130000000001},null,null,"Substrate:",212820,0,212820,0,212820,0,212820,0]
[null,null,null,"p. 1 ha",null,null,"?","Substrate:",{"$f":"I87*$G$84/$G$83","v":63528.358208955222},{"$f":"J87*$G$84/$G$83","v":0},{"$f":"K87*$G$84/$G$83","v":63528.358208955222},{"$f":"L87*$G$84/$G$83","v":0},63528.358208955222,0,63528.358208955222,0]
[{"$f":"A98","v":6462076},"GREENHOUSE","CIF & Auxiliary Facilities ","Construction",{"$f":"1678165","v":1678165},null,null,"TOTAL:",{"$f":"I84+I86+I88","v":179540.29850746266},{"$f":"J84+J86+J88","v":116011.94029850746},{"$f":"K84+K86+K88","v":179540.29850746266},116011.94029850746,179540.29850746266,116011.94029850746,179540.29850746266,{"$f":"P84+P86+P88","v":116011.94029850746}]
[0,"Constr. & commiss."]
[48000,"Supervision p.Yr",{"$f":"A91+A92","v":58500},"Equipment",{"$f":"837750","v":837750}]
[10500,"Training 4 x €2600",null,"Supervision ",159600]
[300000,"Trucking","140 trucks","Shipping+Trucking",{"$f":"189500+A93","v":489500}]
[{"$f":"ROUND((SUM(A89:A93)),-1)","v":6820580},"Price",null,"Price",{"$f":"ROUND((SUM(E89:E93)*T3),-1)","v":2595310}]
[{"$f":"A89/A87","v":1095638.521532723},"←  =  1 ha  =  →"]
["Old surface & Prc",null,"Coef."]
[6,3,{"$f":"2/3","v":0.66666666666666663}]
[6462076,{"$f":"M16/B97","v":1.3333333333333333}]
[{"$f":"A97*C97","v":4},"√"]
[{"$f":"ROUNDUP(A98*C97,-4)","v":4310000},{"$f":"ROUNDUP(A98*C97,-4)","v":4310000}]
[{"$f":"A98/A97","v":1077012.6666666667},"  ←  6 ha  /  1 ha  →"]
[{"$f":"A100/A99","v":1077500},"  ←  4 ha  /  1 ha  →"]

{"sheet":"Cap.Goods","index":1,"n_rows":45,"n_cols":27,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,1,45,1],[6,18,13,18],[15,18,19,18],[8,21,9,21],[12,21,13,21],[23,1,31,1],[32,1,33,1],[24,10,32,10],[1,0,2,0],[2,4,2,10],[2,11,2,12],[4,15,4,16],[22,15,22,16],[4,13,4,14],[22,13,22,14],[22,3,22,4],[14,22,15,26],[4,1,5,1],[5,11,19,11],[15,12,19,12],[6,10,13,10],[6,12,13,12],[6,1,12,1],[15,21,16,21],[5,19,20,19],[12,22,13,26],[15,10,19,10],[15,1,19,1],[14,6,14,8],[22,22,22,24],[38,2,38,3],[47,10,47,11],[47,12,47,13],[38,10,44,10],[47,16,47,19],[23,11,33,11],[24,18,33,18],[35,18,35,19],[24,12,32,12],[44,23,46,24],[23,19,33,19]]}
[]
[]
[null,null,null," Level ①","Zoom 152        Capital Goods and Services ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"Intro!V2","v":1.2195121951219512}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BUDGET!D13","v":"2019-12-30"}]
[null,"A","Adv.%","CAPITAL INVESTMENT EXPORT \u0086(Loan \"A\") ",null,"TOTAL","1st","2nd","3th","4 + 5 + 6",null,"D","→","OWN FUNDS Loan \"D\"",null,"Loan \"A\" + \"D\"",null,"TOTAL",null,null,"Check"]
[null,null,"1st",null,null,{"$f":"SUM(G6:J6)","v":6000000},{"$f":"Y24","v":500000},{"$f":"Y25","v":500000},{"$f":"Y26","v":1500000},{"$f":"Y31","v":3500000},null,null,null,null,0,"Advance","Balance","Value",null,"→","↓"]
[{"$f":"IF(SUM(G7:J7)=F7,\"Ok\",\"Fal\")","v":"Ok"},null,0.05,null,"Greenhouse set with the operating structure, DDP__",{"$f":"Intro!$S$56","v":4850000},{"$f":"ROUNDUP((C7*F7),-1)","v":242500},350000,1000000,{"$f":"F7-G7-H7-I7","v":3257500},null,null,null,null,null,{"$f":"G7+H7+I7+N7","v":1592500},{"$f":"J7+O7","v":3257500},{"$f":"P7+Q7","v":4850000},null,null,{"$f":"IF(SUM(P8:Q8)=(Intro!S57*D7),\"True\",\"False\")","v":"True"},"Loan \"A\"","Purchase, exported cap. goods and services; delivery DDP*"]
[null,null,null,null,"Foundamentation",null,0,0,0,{"$f":"F8-G8-H8-I8","v":0},null,null,null,{"$f":"C7*F7*$O$6","v":0},{"$f":"(100%-C7)*F7*$O$6","v":0},{"$f":"G8+H8+I8+N8","v":0},{"$f":"J8+O8","v":0},{"$f":"P8+Q8","v":0},null,null,{"$f":"IF(SUM(P9:Q9)=Intro!#REF!,\"True\",\"False\")","v":{"$error":"#REF!"}},"Conditional "]
[null,null,null,null,"Construction and installation",{"$f":"Intro!S58","v":170000},0,0,{"$f":"F9","v":170000},{"$f":"F9-G9-H9-I9","v":0},null,null,null,{"$f":"C9*F9*$O$6","v":0},{"$f":"(100%-C9)*F9*$O$6","v":0},{"$f":"G9+H9+I9+N9","v":170000},{"$f":"J9+O9","v":0},{"$f":"P9+Q9","v":170000},null,null,{"$f":"IF(SUM(P10:Q10)=Intro!S60,\"True\",\"False\")","v":"False"},"Loan \"B\"","Could be up to 30% of original part of the export paid by "]
[{"$f":"IF(SUM(G10:J10)=F10,\"Ok\",\"Fal\")","v":"Ok"},null,null,null,"Truck transport",{"$f":"Intro!S59","v":150000},0,0,140000,{"$f":"F10-G10-H10-I10","v":10000},null,null,null,{"$f":"C10*F10*$O$6","v":0},{"$f":"(100%-C10)*F10*$O$6","v":0},{"$f":"G10+H10+I10+N10","v":140000},{"$f":"J10+O10","v":10000},{"$f":"P10+Q10","v":150000},null,null,null,null,"Loan \"A\" Greenhouse base, assembling, infrastructure and "]
["Ø",null,null,null,"1 Yr Supervision and training",{"$f":"Intro!S60+Intro!S61","v":58500},0,0,0,{"$f":"F11-G11-H11-I11","v":58500},null,null,null,{"$f":"C10*F11*$O$6","v":0},{"$f":"(100%-C10)*F11*$O$6","v":0},{"$f":"G11+H11+I11+N11","v":0},58500,{"$f":"P11+Q11","v":58500},null,null,{"$f":"IF(SUM(#REF!)=Intro!S61,\"True\",\"False\")","v":{"$error":"#REF!"}},null,"other LTAssets - all one-off local country costs (up to 30%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"of original part of export value)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C13*F30*$O$6","v":0},{"$f":"(100%-C13)*F30*$O$6","v":0},null,null,null,null,null,{"$f":"IF(SUM(P13:Q13)=Intro!S67,\"True\",\"False\")","v":"True"},"Loan \"C\"","Permanent purchase of production materials and seasonal trade (conditionally - the start-up working materials)"]
[null,{"$f":"IF(C15<=50%,\"\",\"M\")","v":""},null,null,"SubTOTAL:",{"$f":"SUM(F7:F13)","v":5228500},{"$f":"SUM(G7:G13)","v":242500},{"$f":"SUM(H7:H13)","v":350000},{"$f":"SUM(I7:I13)","v":1310000},{"$f":"SUM(J7:J13)","v":3326000},null,null,null,{"$f":"SUM(N8:N13)","v":0},{"$f":"SUM(O8:O13)","v":0},{"$f":"SUM(P7:P13)","v":1902500},{"$f":"SUM(Q7:Q13)","v":3326000},{"$f":"SUM(R7:R13)","v":5228500},null,null,{"$f":"IF(F14=R14,\"True\",\"False\")","v":"True"}]
[null,{"$f":"IF(C15<=50%,\"C\",\"\")","v":"C"},{"$f":"F20/F21","v":0},null,"ELIGIBLE FOREIGN CONTENT (Loan \"A\")",null,"Advance",null,null,"Balance",null,null,null,null,null,null,null,null,null,null,null,null,"Own funds (Loan \"C\"). Credit percentage down payment, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan \"D\""]
[null,null,null,{"$f":"100%-D7","v":1},"Greenhouse Screening plots and materials",null,null,null,null,null,null,null,null,{"$f":"C17*F17*$O$6","v":0},{"$f":"(100%-C17)*F17*$O$6","v":0},{"$f":"I17+N17","v":0},0,{"$f":"P17+Q17","v":0},null,null,{"$f":"IF(SUM(P17:Q17)=Intro!S57*D17,\"True\",\"False\")","v":"False"},null,"when required (as ECA's practice)"]
[null,null,null,null,"Plants, fertilizers, pesticides, substrate",null,null,null,null,null,null,null,null,{"$f":"C18*F18*$O$6","v":0},{"$f":"(100%-C18)*F18*$O$6","v":0},0,0,{"$f":"P18+Q18","v":0},null,null,null,null,"Involve percentage of own funds, if required, in Cell O6"]
[null,null,null,null,"Shipping",null,null,null,null,null,null,null,null,{"$f":"C19*F19*$O$6","v":0},{"$f":"(100%-C19)*F19*$O$6","v":0},0,0,{"$f":"P19+Q19","v":0},null,null,null,null,"and click","\u0085 \u0085% button left"]
[null,null,null,null,"SubTOTAL:",{"$f":"SUM(F17:F19)","v":0},null,{"$f":"SUM(I17:I19)","v":0},{"$f":"SUM(J17:J19)","v":0},{"$f":"SUM(J17:J19)","v":0},null,null,null,{"$f":"SUM(N17:N19)","v":0},{"$f":"SUM(O17:O19)","v":0},{"$f":"SUM(P17:P19)","v":0},{"$f":"SUM(Q17:Q19)","v":0},{"$f":"SUM(R17:R19)","v":0},null,null,null,"* DDP - Delivered duty paid"]
[null,null,"Export",{"$f":"F21","v":5228500},"Loan \"A\", EXPORT VALUE, TOTAL:",{"$f":"F14+F20","v":5228500},{"$f":"G14+G20","v":242500},350000,{"$f":"I14+I20","v":1310000},{"$f":"J14+J20","v":3326000},null,null,null,{"$f":"N14+N20","v":0},{"$f":"O14+O20","v":0},{"$f":"P14+P20","v":1902500},{"$f":"Q14+Q20","v":3326000},{"$f":"R14+R20","v":5228500},null,null,{"$f":"IF((P21+Q21)=Intro!S56,\"True\",\"False\")","v":"False"}]
[]
[null,"B",null,"LOCAL COUNTRY COSTS \u0086(Loan \"B\")",null,null,null,null,null,null,null,"D","→","OWN FUNDS Loan \"D\"",null,"Loan \"A\" + \"D\"",null,"TOTAL",null,null,null,null,"  Credit-bank Loan Tranches "]
[null,null,"Adv.% 1st tranche",null,null,"Price",{"$f":"G5","v":"1st"},{"$f":"H5","v":"2nd"},"3th","4 + 5 + 6",null,null,null,{"$f":"O24","v":0},{"$f":"O6","v":0},"Advance","Balance","Value",null,"→",null,null,null,"1․",500000]
[null,null,"↓","Capital investment",null,{"$f":"SUM(F26:F30)","v":508800},{"$f":"ROUNDUP(SUM(G26:G30),-1)","v":56940},{"$f":"ROUNDUP(SUM(H26:H30),-3)","v":90000},{"$f":"SUM(I26:I30)","v":190860},{"$f":"SUM(J26:J30)","v":171000},null,null,null,{"$f":"SUM(N26:N30)","v":0},0,{"$f":"SUM(P26:P30)","v":337800},{"$f":"SUM(Q26:Q30)","v":171000},{"$f":"SUM(R26:R30)","v":508800},null,null,{"$f":"IF((P25+Q25)=R25,\"True\",\"False\")","v":"True"},null,null,"2․",500000]
[{"$f":"IF(SUM(G26:J26)=F26,\"Ok\",\"Fal\")","v":"Ok"},null,0.1,"Constructive drawings, permits - electricity, water, etc.",null,{"$f":"Intro!S49","v":80000},{"$f":"C26*F26","v":8000},0,{"$f":"F26-G26","v":72000},0,null,null,null,{"$f":"C26*F26*$O$24","v":0},{"$f":"(100%-C26)*F26*$O$6","v":0},{"$f":"G26+H26+I26+N26","v":80000},{"$f":"J26+O26","v":0},{"$f":"P26+Q26","v":80000},null,null,{"$f":"IF(SUM(P26:Q26)=Intro!S50,\"True\",\"False\")","v":"False"},null,null,"3․",1500000]
[{"$f":"IF(SUM(G27:J27)=F27,\"Ok\",\"Fal\")","v":"Ok"},null,0.12,"Terrain, infrastructure - hedge, water § power supply",null,{"$f":"Intro!S50","v":107800},{"$f":"ROUND(C27*F27,-1)","v":12940},50000,{"$f":"F27-G27-H27","v":44860},0,null,null,null,{"$f":"C27*F27*$O$24","v":0},{"$f":"(100%-C27)*F27*$O$6","v":0},{"$f":"G27+H27+I27+N27","v":107800},0,{"$f":"P27+Q27","v":107800},null,null,{"$f":"IF(SUM(P27:Q27)=Intro!#REF!,\"True\",\"False\")","v":{"$error":"#REF!"}}]
[{"$f":"IF(SUM(G28:J28)=F28,\"Ok\",\"Fa\")","v":"Ok"},null,0,"Other unforeseen expenses - land, video control, etc. ",null,{"$f":"Intro!S51","v":60000},{"$f":"$C$28*$F$28","v":0},40000,20000,0,null,null,null,{"$f":"C28*F28*$O$24","v":0},{"$f":"(100%-C28)*F28*$O$6","v":0},{"$f":"G28+H28+I28+N28","v":60000},0,{"$f":"P28+Q28","v":60000},null,null,{"$f":"IF(SUM(P28:Q28)=Intro!S51,\"OK\",\"False\")","v":"OK"},null,null,"4․",1500000]
["Ø",null,0,"One year - plants, fertilizers, pesticides, substrate",null,{"$f":"ROUNDUP(Intro!S55,-3)","v":171000},0,0,0,{"$f":"ROUNDDOWN(F29,-1)","v":171000},null,null,null,{"$f":"C29*F29*$O$24","v":0},{"$f":"(100%-C29)*F29*$O$6","v":0},{"$f":"G29+H29+I29+N29","v":0},{"$f":"J29+O29","v":171000},{"$f":"P29+Q29","v":171000},null,null,{"$f":"IF(SUM(P29:Q29)=Intro!S52,\"True\",\"False\")","v":"False"},null,null,"5․",1000000]
[{"$f":"IF(SUM(G29:J29)=F29,\"Ok\",\"Fal\")","v":"Ok"},null,0.4,"Bus and truck for staff and products",null,{"$f":"Intro!S52","v":90000},{"$f":"C30*F30","v":36000},0,{"$f":"F30-G30-H30","v":54000},0,null,null,null,{"$f":"C30*F30*$O$24","v":0},{"$f":"(100%-C30)*F30*$O$6","v":0},90000,{"$f":"J30+O30","v":0},{"$f":"P30+Q30","v":90000},null,null,null,null,null,"6․",1000000]
[{"$f":"IF(SUM(G31:J31)=F31,\"Ok\",\"Fal\")","v":"Ok"},null,null,"Financial modeling package and OCFCS",null,{"$f":"SUM(F32:F33)","v":260000},{"$f":"SUM(G32:G33)","v":200000},{"$f":"SUM(H32:H33)","v":60000},{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},null,null,null,{"$f":"SUM(N32:N33)","v":0},{"$f":"SUM(O32:O33)","v":0},{"$f":"SUM(P32:P33)","v":260000},{"$f":"SUM(Q32:Q33)","v":0},{"$f":"SUM(R32:R33)","v":260000},null,null,{"$f":"IF((P31+Q31)=R31,\"True\",\"False\")","v":"True"},null,null,"SubTOTAL (4.+ 5.+ 6.):",{"$f":"SUM(Y28:Y30)","v":3500000}]
[null,null,0.8,"Cash-flows, profitability & sensitivity analysis +",null,{"$f":"Intro!S53","v":230000},{"$f":"ROUND(C32*F32,-4)","v":180000},{"$f":"F32-G32","v":50000},0,0,null,null,null,{"$f":"C32*F32*$O$6","v":0},{"$f":"(100%-C32)*F32*$O$6","v":0},{"$f":"G32+H32+I32+N32","v":230000},{"$f":"J32+O32","v":0},{"$f":"P32+Q32","v":230000},null,null,{"$f":"IF(SUM(P32:Q32)=Intro!S53,\"True\",\"False\")","v":"True"},null,null,"TOTAL:",{"$f":"SUM(Y24:Y26)+Y27+Y31","v":6000000}]
[null,{"$f":"IF(C34<=30%,\"C\",\"N\")","v":"C"},0.7,"Financial risk assessment and management",null,{"$f":"Intro!S54","v":30000},{"$f":"ROUNDDOWN(C33*F33,-4)","v":20000},{"$f":"F33-G33","v":10000},0,0,null,null,null,{"$f":"C33*F33*$O$6","v":0},{"$f":"(100%-C33)*F33*$O$6","v":0},30000,{"$f":"J33+O33","v":0},{"$f":"P33+Q33","v":30000},null,null,{"$f":"IF(SUM(P33:Q33)=Intro!S54,\"True\",\"False\")","v":"True"}]
[null,null,{"$f":"F34/F21","v":0.14704026011284307},null,"LOCAL COUNTRY COSTS (LCC), TOTAL:",{"$f":"F25+F31","v":768800},{"$f":"ROUND(G25+G31,-1)","v":256940},{"$f":"ROUND(H25+H31,-1)","v":150000},{"$f":"I25+I31","v":190860},{"$f":"J25+J31","v":171000},null,null,null,{"$f":"N25+N31","v":0},{"$f":"O25+O31","v":0},{"$f":"P25+P31","v":597800},{"$f":"Q25+Q31","v":171000},{"$f":"R25+R31","v":768800},null,null,{"$f":"IF(SUM(P34:Q34)=R34,\"True\",\"False\")","v":"True"}]
[]
[null,null,null,null," Import + Local Costs:",{"$f":"ROUNDUP(SUM(F21+F34),-4)","v":6000000},{"$f":"ROUNDUP(SUM(G21+G34),-4)","v":500000},{"$f":"H21+H34","v":500000},{"$f":"ROUNDDOWN(SUM(I21+I34),-3)","v":1500000},{"$f":"ROUNDUP(SUM(J21+J34),-4)","v":3500000},null,"D","→",{"$f":"N21+N34","v":0},{"$f":"O21+O34","v":0},{"$f":"ROUNDDOWN(SUM(P21+P34),-3)","v":2500000},{"$f":"ROUNDUP(SUM(J21+J34),-4)","v":3500000},{"$f":"ROUNDUP(SUM(R21+R34),-4)","v":6000000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan \"D\"",{"$f":"N36+O36","v":0},null,"Working Capital →",20000]
[null,null,1E-3,null,"Ann. Interests:",null,null,0.04,{"$f":"H38","v":0.04},null,null,null,null,5.5E-2]
["Ø",null,"INSURANCE",null,"  DEPRECIATION OF ASSETS",null,null,"Price",{"$f":"SUM(I40:I45)","v":798500},null,null,null," KEY NOTES:"]
[null,null,1E-3,{"$f":"C40*H40","v":4850},"    up to; for industry equipment",0.16,null,{"$f":"F7+F17","v":4850000},{"$f":"H40*F40","v":776000},null,null,1,null,"*Gradients "," in      Cells","temporary put an approximate value in it without document background and"]
["Ø",null,null,null,"    Building ",0.04,null,null,null,null,null,null,null,"supported                      "," in      Cells","values with document. Icon      - for URL to data resource.  "]
["Ø",null,null,null,null,null,null,null,null,null,null,2,null,"The icons     or     ride at Internet sources."]
["Ø",null,0.02,{"$f":"C43*H43","v":1800},"    Motor car",0.25,null,{"$f":"F30","v":90000},{"$f":"F43*H43","v":22500},null,null,3,null,"Info icons","     provides link to author's information sources."]
["Ø",null,null,null,"    ",0.25,null,null,null,null,null,4,null,"Various fonts and background colors represent similar group data resources."]
["Ø",null,null,{"$f":"SUM(D40:D44)","v":6650},"    Intangible assets (Fin. modeling)",null,null,null,null,null,null,5,null,"It's recommendable to follow these indications in order to facilitate the structure identification.",null,null,null,null,null,null,null,null,null,"        Go to BUDGET        and   Financial analyzes"]

{"sheet":"BUDGET","index":2,"n_rows":136,"n_cols":22,"rows_kept":136,"cut":false,"hidden":false,"merged":[[75,13,75,14],[75,10,75,11],[74,3,74,5],[70,2,70,4],[72,13,72,14],[72,10,72,11],[70,9,71,9],[70,10,70,14],[71,6,71,8],[71,2,71,4],[72,6,72,8],[70,6,70,8],[93,0,93,1],[75,0,75,1],[74,0,74,1],[73,0,73,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[88,0,88,1],[7,11,7,12],[13,9,15,10],[7,13,7,14],[7,7,7,8],[40,8,41,8],[40,3,41,3],[40,4,41,4],[7,3,7,4],[40,6,41,6],[40,7,41,7],[40,5,41,5],[75,15,75,17],[40,18,41,18],[42,0,42,1],[68,0,69,0],[10,0,11,1],[40,15,41,15],[40,16,41,16],[40,17,41,17],[40,11,41,11],[40,10,41,10],[40,12,41,12],[40,14,41,14],[40,9,41,9],[48,0,48,1],[19,1,20,1],[40,13,41,13]]}
["[ Level①","PRE-DESIGN BACKGROUND.","Sales","Jan","Feb","2016-03-31","2016-04-30","2016-05-31","2015-06-30","2015-07-31","2015-08-31","2015-09-30","2015-10-31","2015-11-30","2015-12-31","i TOTAL p.a.i",{"$f":"($Q$2/Intro!U39+$Q$3/Intro!U40)/2","v":0.57690663145203236},{"$f":"($R$2/Intro!U39+$R$3/Intro!U40)/2","v":0.42309336854796775}]
["   Back","Value of production","IncomeTx Mo",{"$f":"Intro!I39","v":0},{"$f":"Intro!J39","v":0},{"$f":"Intro!K39","v":257463.36000000002},{"$f":"Intro!L39","v":362789.27999999997},{"$f":"Intro!M39","v":310194.36},{"$f":"Intro!N39","v":205571.52000000002},{"$f":"Intro!O39","v":182776.19220000005},{"$f":"Intro!P39","v":148916.88000000003},{"$f":"Intro!Q39","v":149688.00000000003},{"$f":"Intro!R39","v":187608.96000000002},{"$f":"Intro!S39","v":82668.600000000006},{"$f":"Intro!T39","v":63866.879999999997},{"$f":"SUM(D2:O2)","v":1951544.0322},{"$f":"SUM(D2:I2)","v":1136018.52},{"$f":"SUM(J2:O2)","v":815525.5122},null,null,null,{"$f":"Q2+R2","v":1951544.0322}]
["From  Level 0","Business Plan","IncomeCx Mo",{"$f":"Intro!I40","v":0},{"$f":"Intro!J40","v":50017.44384},{"$f":"Intro!K40","v":102108.36384000001},{"$f":"Intro!L40","v":129133.09583999999},{"$f":"Intro!M40","v":29639.675520000004},{"$f":"Intro!N40","v":85250.037600000011},{"$f":"Intro!O40","v":70033.602239999993},{"$f":"Intro!P40","v":77846.519520000016},{"$f":"Intro!Q40","v":18060.215039999999},{"$f":"Intro!R40","v":50625.792000000009},{"$f":"Intro!S40","v":66162.09600000002},{"$f":"Intro!T40","v":14053.384800000002},{"$f":"SUM(D3:O3)","v":692930.22624000011},{"$f":"SUM(D3:I3)","v":396148.61664000002},{"$f":"SUM(J3:O3)","v":296781.60960000008}]
[{"$f":"Intro!U47","v":5446863.2835820895},"\u0086  Lender/Insurer   (Loan \"A\")","Var. Costs",1,{"$f":"D4+1","v":2},{"$f":"E4+1","v":3},4,5,6,7,8,9,10,11,12,null,{"$f":"(Q5/P5+Q6/P6)/2","v":0.56152369835055427},{"$f":"(R5/P5+R6/P6)/2","v":0.43847630164944573}]
[{"$f":"Intro!V48","v":768363.28358208947},"\u0086  Local Country Costs +VAT","Heating",{"$f":"Intro!I42","v":27091.85325},{"$f":"Intro!J42","v":24628.996018656715},{"$f":"Intro!K42","v":20926.942242537312},{"$f":"Intro!L42","v":16008.854473880596},{"$f":"Intro!M42","v":7345.1183694029842},{"$f":"Intro!N42","v":0},{"$f":"Intro!O42","v":0},{"$f":"Intro!P42","v":0},{"$f":"Intro!Q42","v":0},{"$f":"Intro!R42","v":12314.474470149255},{"$f":"Intro!S42","v":18471.711705223879},{"$f":"Intro!T42","v":20934.61601492537},{"$f":"SUM(D5:O5)","v":147722.56654477611},{"$f":"SUM(D5:I5)","v":96001.764354477607},{"$f":"SUM(J5:O5)","v":51720.802190298506}]
[null,null,"Packing",{"$f":"Intro!I43","v":0},{"$f":"Intro!J43","v":1886.9760000000001},{"$f":"Intro!K43","v":11405.572},{"$f":"Intro!L43","v":19650.753999999997},{"$f":"Intro!M43","v":18955.507999999998},{"$f":"Intro!N43","v":24526.97},{"$f":"Intro!O43","v":25988.491999999998},{"$f":"Intro!P43","v":23252.038},{"$f":"Intro!Q43","v":14303.724},{"$f":"Intro!R43","v":11266.096000000001},{"$f":"Intro!S43","v":6525.09},{"$f":"Intro!T43","v":3757.91},{"$f":"SUM(D6:O6)","v":161519.12999999998},{"$f":"SUM(D6:I6)","v":76425.78},{"$f":"SUM(J6:O6)","v":85093.35}]
[null,null,"Running costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D7:O7)","v":0},{"$f":"SUM(D7:I7)","v":0},{"$f":"SUM(J7:O7)","v":0}]
[null,null,"1 Yr Oper. Costs","T  Fertilizers  C ",null,"T+C Seeds","Substrate","1-6  Water+Electricity  7-12",null,"1-6   SubTotal","7-12  SubTotal","ß  1-Yr  biennially  2 Yr à",null,"1-6 Mo     All Costs    7-12 Mo",null,{"$f":"SUM(P5:P7)","v":309241.69654477609},{"$f":"SUM(Q5:Q7)","v":172427.54435447761},{"$f":"SUM(R5:R7)","v":136814.15219029851}]
[null,null,{"$f":"Intro!M16","v":4},{"$f":"Intro!H52","v":22518.686567164175},{"$f":"Intro!H53","v":9650.8656716417918},{"$f":"Intro!H56","v":78041.79104477611},{"$f":"Intro!H59","v":30175.970149253728},{"$f":"Intro!O55","v":45979.199999999997},{"$f":"Intro!O61","v":28420.799999999999},{"$f":"SUM(D9:G9)/2+H9","v":116172.8567164179},{"$f":"SUM(D9:G9)/2+I9","v":98614.456716417902},"←WITH","WITHOUT→",{"$f":"SUM(D9:F9)/2+H9","v":101084.87164179103},{"$f":"SUM(D9:F9)/2+I9","v":83526.471641791039},null,"❶    30 Jun","31 Dec     ❷    "]
[null,null,"Market products",0,0,0,20000,30000,40000,50000,40000,30000,30000,0,0,{"$f":"SUM(D10:O10)","v":240000},{"$f":"SUM(D10:I10)","v":90000},{"$f":"SUM(J10:O10)","v":150000}]
["From [ Level①",null,"Nr of Periods",1,{"$f":"D11+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,{"$f":"Q11+1","v":15},{"$f":"R11+1","v":16}]
[null,null,"Nr of Monts",6,{"$f":"D12+6","v":12},18,24,30,36,42,{"$f":"J12+6","v":48},54,60,66,72,78,84,90,{"$f":"R12+6","v":96}]
[null,"  Repayment periods","Date:","2019-12-30","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30"]
[{"$f":"'Cap.Goods'!O37","v":0},"\u0086  Own Funds Loan \"D\"",null,null,null,null,null,null,null,"Level ②"]
[{"$f":"Intro!T51","v":0},"\u0086  VAT of Loans \"A\"+\"B\"    Return↔",null,{"$f":"Intro!$T$51","v":0},{"$f":"-A15","v":0}]
[{"$f":"'Cap.Goods'!R21","v":5228500}," Export of cap. goods ",{"$f":"SUM(D16:F16)","v":5228500},{"$f":"'Cap.Goods'!P21","v":1902500},{"$f":"'Cap.Goods'!Q21","v":3326000}]
[{"$f":"'Cap.Goods'!R34","v":768800},"Local country costs",{"$f":"SUM(D17:F17)","v":768800},{"$f":"'Cap.Goods'!P34","v":597800},{"$f":"'Cap.Goods'!Q34","v":171000}]
[{"$f":"'Cap.Goods'!R36","v":6000000}," Capital Investment",{"$f":"SUM(D18:F18)","v":5997300},{"$f":"SUM(D15:D17)","v":2500300},{"$f":"SUM(E15:E17)","v":3497000}]
[null,"\u0086  Working Capital  (Loan\"C\")",{"$f":"SUM(F19:Q19)","v":1440000},null,null,{"$f":"Q10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000}]
[" Sales,","Revenue Pro-forma Budget",{"$f":"SUM(F20:Q20)","v":17638643.303794801},{"$f":"D44","v":0},0,{"$f":"F44","v":1501523.7939072},{"$f":"G44","v":1090060.979364},{"$f":"H44","v":1532167.1366400002},1112307.1218000001,1639418.8362048003,{"$f":"K44","v":1190168.6203260003},1761992.207136,1279153.19007,1869243.9067008002,1357014.688596,1915208.9208,{"$f":"Q44","v":1390383.90225},{"$f":"R44","v":1532167.1366400002},{"$f":"S44","v":1412630.0446860001}]
["Less:",null,"Date:",{"$f":"D13","v":"2019-12-30"},"2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30"]
["Costs,","TOTAL (in €)",{"$f":"SUM(D22:S22)","v":10749172.927861337},{"$f":"SUM(D23:D26)","v":9400},{"$f":"SUM(E23:E26)","v":21700},226813.63914787985,{"$f":"SUM(G23:G26)","v":1126346.2076594341},{"$f":"SUM(H23:H26)","v":461986.66105220851},1212037.404301225,479239.37112683535,1229319.3381633519,{"$f":"SUM(L23:L26)","v":466345.33483970852},1216454.9201848563,483656.88701046666,1211296.4905114123,470822.4871877688,1198492.5140896153,480407.35838725581,454854.31419931783]
[null,"Variable costs",{"$f":"SUM(D23:Q23)","v":2862858.8359850743},{"$f":"D55","v":0},{"$f":"E55","v":0},{"$f":"F55","v":174673.63914787985},{"$f":"G55","v":138568.0573968963},{"$f":"H55","v":275758.51078967087},{"$f":"I55","v":222094.52903868732},290846.49586429773,237182.51411331419,275758.51078967087,222094.52903868732,290846.49586429773,237182.51411331419,275758.51078967087,222094.52903868732,{"$f":"R55","v":289723.44846759661},{"$f":"S55","v":236305.56151001528}]
[null,"Fixed costs",{"$f":"SUM(D24:Q24)","v":2131747.5928457305},{"$f":"D59","v":9400},{"$f":"E59","v":21700},52140,{"$f":"G59","v":182614.07513126879},179564.07513126879,184778.8001312688,181728.8001312688,186972.7489187688,183922.7489187688,189196.31601490008,186146.31601490008,191449.90126682911,188399.90126682911,193733.9099196592,184019.83478839041,189384.6775580337]
[null,"Marketing & Risk Mngmt",{"$f":"SUM(D25:S25)","v":86632.976706494374},{"$f":"D65","v":0},0,0,{"$f":"G65","v":6664.075131268798},{"$f":"H65","v":6664.075131268798},6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798,6664.075131268798]
[{"$f":"'Cap.Goods'!I39","v":798500},"Depreciations",null,null,null,null,{"$f":"'Cap.Goods'!$I$40+'Cap.Goods'!I43","v":798500},null,{"$f":"G26","v":798500},null,{"$f":"G26","v":798500},null,{"$f":"G26","v":798500},null,{"$f":"'Cap.Goods'!I40","v":776000},null,{"$f":"O26","v":776000},null,{"$f":"'Cap.Goods'!I43+'Cap.Goods'!I44","v":22500}]
[null,"Cash Flows (EBIT)",null,{"$f":"D20-D22","v":-9400},-21700,1274710.1547593202,-36285.228295434033,1070180.4755877918,-99730.282501224894,1160179.4650779651,{"$f":"K20-K22","v":-39150.717837351607},1295646.8722962914,62698.269885143731,1385587.0196903334,145718.1980845877,{"$f":"P20-P22","v":1444386.4336122312},{"$f":"Q20-Q22","v":191891.38816038473},{"$f":"R20-R22","v":1051759.7782527443},{"$f":"S20-S22","v":957775.73048668227},null,{"$f":"SUM(D27:Q27)","v":7824732.0485200379}]
["Less:","Interests Loans \"A\" + \"B\"",null,{"$f":"D86+D91+D96","v":0},11956,14487,{"$f":"G86+G91+G96","v":118150},{"$f":"H86+H91+H96","v":110679},{"$f":"I86+I91+I96","v":96606},{"$f":"J86+J91+J96","v":83236},70620,58816,47883,37883,28881,20946,{"$f":"Q86+Q91+Q96","v":14149},{"$f":"R86+R91+R96","v":8566},{"$f":"S86+S91+S96","v":4274},null,{"$f":"SUM(D28:Q28)","v":714292}]
[null,"EBT",null,{"$f":"D27-D28","v":-9400},-33656,1260223.1547593202,{"$f":"G27-G28","v":-154435.22829543403},{"$f":"H27-H28","v":959501.47558779176},{"$f":"I27-I28","v":-196336.28250122489},1076943.4650779651,-109770.71783735161,1236830.8722962914,14815.269885143731,1347704.0196903334,116837.1980845877,{"$f":"P27-P28","v":1423440.4336122312},{"$f":"Q27-Q28","v":177742.38816038473},{"$f":"R27-R28","v":1043193.7782527443},{"$f":"S27-S28","v":953501.73048668227},null,{"$f":"SUM(D29:Q29)","v":7110440.0485200398},{"$f":"U29/$Q$12","v":84648.095815714754}]
["Less:","Income tax",0.08,null,null,null,{"$f":"(D29+E29+F29)*C30","v":97373.372380745612},null,{"$f":"(G29+H29)*$C$30-H31","v":15718.613593015813},null,{"$f":"(I29+J29)*$C$30-J31","v":62589.267809631303},null,{"$f":"(K29+L29)*$C$30-L31","v":58870.178451899541},null,{"$f":"(M29+N29)*$C$30-N31","v":79566.453940088395},null,{"$f":"(O29+P29)*$C$30-P31","v":83438.983565701317},null,{"$f":"(Q29+R29)*$C$30-R31","v":55955.40153019967},null,{"$f":"SUM(D26:Q26)","v":4746000}]
[null,"Advance deposit",null,null,null,null,null,{"$f":"G30/2","v":48686.686190372806},null,{"$f":"I30/2","v":7859.3067965079063},null,{"$f":"K30/2","v":31294.633904815651},null,{"$f":"M30/2","v":29435.08922594977},null,{"$f":"O30/2","v":39783.226970044198},null,{"$f":"Q30/2","v":41719.491782850659},null,null,{"$f":"SUM(U29:U30)","v":11856440.04852004}]
[null,"EAT",{"$f":"SUM(D32:Q32)","v":6555824.2356912661},{"$f":"D29-D30-D31","v":-9400},-33656,1260223.1547593202,-251808.60067617963,910814.78939741896,-212054.89609424071,1069084.1582814571,-172359.98564698291,1205536.2383914758,-44054.90856675581,{"$f":"N29-N30-N31","v":1318268.9304643837},37270.744144499302,1383657.206642187,94303.404594683409,1001474.2864698936,897546.32895648258,null,{"$f":"SUM(D32:Q32)","v":6555824.2356912661},{"$f":"U32/$Q$12","v":78045.526615372219}]
["Add:","Total depreciations",null,null,{"$f":"E26","v":0},null,{"$f":"G26","v":798500},{"$f":"H26","v":0},798500,0,798500,0,798500,0,776000,0,776000]
["Add:","Tax advance deposited"]
["►"," Operating Cash Flows",{"$f":"SUM(D35:S35)","v":13200844.851117643},{"$f":"SUM(D32:D34)","v":-9400},-33656,1260223.1547593202,{"$f":"SUM(G32:G34)","v":546691.39932382037},{"$f":"SUM(H32:H34)","v":910814.78939741896},{"$f":"SUM(I32:I34)","v":586445.10390575929},1069084.1582814571,626140.01435301709,{"$f":"SUM(L32:L34)","v":1205536.2383914758},754445.09143324418,1318268.9304643837,813270.7441444993,1383657.206642187,870303.40459468344,{"$f":"SUM(R32:R34)","v":1001474.2864698936},{"$f":"SUM(S32:S34)","v":897546.32895648258}]
["Less:",null,null,{"$f":"-D18","v":-2500300},{"$f":"-E18","v":-3497000},{"$f":"-F18","v":0}]
["►    (NCFs)","Project's Net Cash Flows",{"$f":"SUM(D37:S37)","v":7203544.8511176426},{"$f":"D35+D36","v":-2509700},{"$f":"E35+E36","v":-3530656},1260223.1547593202,{"$f":"G35+G36","v":546691.39932382037},{"$f":"H35+H36","v":910814.78939741896},{"$f":"I35+I36","v":586445.10390575929},1069084.1582814571,626140.01435301709,1205536.2383914758,754445.09143324418,1318268.9304643837,813270.7441444993,{"$f":"P35+P36","v":1383657.206642187},{"$f":"Q35+Q36","v":870303.40459468344},{"$f":"R35+R36","v":1001474.2864698936},{"$f":"S35+S36","v":897546.32895648258}]
["Less: Loans—","Installments (principal + interest)",null,{"$f":"-(D88+D93+D98-D28)","v":0},{"$f":"-(E88+E93+E98-E28)","v":0},{"$f":"-(F88+F93+F98-F28)","v":0},{"$f":"-(G88+G93+G98-G28)","v":-375442},{"$f":"-(H88+H93+H98-H28)","v":-382952},-390611,-398423,-406392,-414520,-422809,-431265,-439891,-448689,-457662,-466816,-476152,null,null,{"$f":"SUM(D38:Q38)","v":-4568656}]
[null,"Cash",null,{"$f":"D37+D38","v":-2509700},-3530656,1260223.1547593202,171249.39932382037,{"$f":"H37+H38","v":527862.78939741896},195834.10390575929,{"$f":"J37+J38","v":670661.15828145714},{"$f":"K37+K38","v":219748.01435301709},{"$f":"L37+L38","v":791016.23839147575},331636.09143324418,887003.93046438368,373379.7441444993,934968.20664218697,412641.40459468344,534658.28646989365,421394.32895648258]
["Cumulative NCFs (loan pay-off incl.)",null,"→",{"$f":"D39","v":-2509700},{"$f":"D40+E39","v":-6040356},{"$f":"E40+F39","v":-4780132.8452406796},{"$f":"F40+G39","v":-4608883.4459168594},{"$f":"G40+H39","v":-4081020.6565194405},{"$f":"H40+I39","v":-3885186.5526136812},-3214525.394332224,-2994777.3799792072,-2203761.1415877314,-1872125.0501544871,-985121.11969010346,{"$f":"N40+O39","v":-611741.37554560415},{"$f":"O40+P39","v":323226.83109658281},{"$f":"P40+Q39","v":735868.23569126625},{"$f":"Q40+R39","v":1270526.5221611599},{"$f":"R40+S39","v":1691920.8511176426}]
[null,"Years :",null,"→",null,-0.02,{"$f":"E41+1","v":1},0,{"$f":"G41+1","v":2},{"$f":"H41+7%","v":7.0000000000000007E-2},{"$f":"I41+1","v":3},{"$f":"J41+8%","v":0.15000000000000002},{"$f":"K41+1","v":4},{"$f":"L41+7%","v":0.22000000000000003},{"$f":"M41+1","v":5},{"$f":"N41+3%","v":0.25},{"$f":"O41+1","v":6},{"$f":"P41+2%","v":0.27},{"$f":"Q41+1","v":7}]
[]
["Income data. Selected year <+>:",null,"Calendar year",{"$f":"D13","v":"2019-12-30"},"2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30"]
[{"$f":"SUM(F44:Q44)","v":17638643.303794801},"      Sales         ",null,null,null,{"$f":"F45","v":1501523.7939072},1090060.979364,1532167.1366400002,1112307.1218000001,1639418.8362048003,1190168.6203260003,1761992.207136,1279153.19007,1869243.9067008002,1357014.688596,1915208.9208,1390383.90225,{"$f":"R45","v":1532167.1366400002},{"$f":"S45","v":1412630.0446860001}]
[null,"● Greenhouse own production",null,null,null,{"$f":"SUM(F46:F47)","v":1501523.7939072},{"$f":"SUM(G46:G47)","v":1090060.979364},1532167.1366400002,1112307.1218000001,1639418.8362048003,1190168.6203260003,1761992.207136,1279153.19007,1869243.9067008002,1357014.688596,1915208.9208,1390383.90225,{"$f":"SUM(R46:R48)","v":1532167.1366400002},{"$f":"SUM(S46:S48)","v":1412630.0446860001}]
[null,"   • Tomatoes",null,null,null,{"$f":"Q2*(1+$F$41)","v":1113298.1495999999},{"$f":"R2*(1+$F$41)","v":799215.00195599999},{"$f":"$Q$2","v":1136018.52},{"$f":"$R$2","v":815525.5122},{"$f":"$Q$2*(1+J41)","v":1215539.8164000001},{"$f":"$R$2*(1+J41)","v":872612.29805400001},{"$f":"$Q$2*(1+L41)","v":1306421.298},{"$f":"$R$2*(1+L41)","v":937854.33902999992},{"$f":"$Q$2*(1+N41)","v":1385942.5944000001},{"$f":"$R$2*(1+N41)","v":994941.12488399993},{"$f":"$Q$2*(1+P41)","v":1420023.15},{"$f":"$R$2*(1+P41)","v":1019406.8902499999},{"$f":"$Q$2","v":1136018.52},{"$f":"$R$2*(1+R41)","v":1035717.4004940001}]
[null,"   • Cucumbers",null,null,null,{"$f":"Q3*(1+$F$41)","v":388225.64430720004},{"$f":"R3*(1+$F$41)","v":290845.97740800009},{"$f":"$Q$3","v":396148.61664000002},{"$f":"$R$3","v":296781.60960000008},{"$f":"$Q$3*(1+J41)","v":423879.01980480005},{"$f":"$R$3*(1+J41)","v":317556.32227200014},{"$f":"$Q$3*(1+L41)","v":455570.90913599997},{"$f":"$R$3*(1+L41)","v":341298.8510400001},{"$f":"$Q$3*(1+N41)","v":483301.3123008},{"$f":"$R$3*(1+N41)","v":362073.56371200009},{"$f":"$Q$3*(1+P41)","v":495185.77080000006},{"$f":"$R$3*(1+P41)","v":370977.0120000001},{"$f":"$Q$3","v":396148.61664000002},{"$f":"$R$3*(1+R41)","v":376912.64419200009}]
[null,"   • By-products"]
["OPERATIONAL AND RISK MANAGEMENT",null,"Option: Funding",null,1000,0.5,0.3,0.2,{"$f":"$E$49*F49","v":500},{"$f":"$E$49*G49","v":300},{"$f":"$E$49*H49","v":200},0]
[null,"Dynamic structure of new loan with",0.06,"Select and","↑ ENTER ↑",null,null,"New debt to add to the Costs→",0,{"$f":"I49*(1+$C$50/2)","v":515},{"$f":"J49*(1+$C$50/2)","v":309},{"$f":"K49*(1+$C$50/2)","v":206}]
[" Sales,","Current accounting reports"]
["Costs,","TOTAL accounting reports"]
["OCFCS","Cash Flow Statements       ‒","Аccounting"]
[null,"Income data (in €), EU Zone   Periods:",{"$f":"C13","v":"Date:"},{"$f":"D13","v":"2019-12-30"},"2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30"]
[null,"      Variable costs ",{"$f":"SUM(D55:S55)","v":3388887.845962686},{"$f":"SUM(D56:D58)","v":0},{"$f":"SUM(E56:E58)","v":0},{"$f":"SUM(F56:F58)-F57","v":174673.63914787985},{"$f":"SUM(G56:G58)-G57","v":138568.0573968963},{"$f":"SUM(H56:H58)","v":275758.51078967087},{"$f":"SUM(I56:I58)","v":222094.52903868732},{"$f":"SUM(J56:J58)","v":290846.49586429773},237182.51411331419,275758.51078967087,222094.52903868732,290846.49586429773,{"$f":"SUM(O56:O58)","v":237182.51411331419},275758.51078967087,222094.52903868732,289723.44846759661,236305.56151001528]
[{"$f":"Q8","v":172427.54435447761},"1st Heating, packing, running costs 2nd",{"$f":"R8","v":136814.15219029851},0,0,{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851},{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851},{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851},{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851},{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851},{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851},{"$f":"$A$56","v":172427.54435447761},{"$f":"$C$56","v":136814.15219029851}]
[null,"Operat. costs ̶ fertilizers, substrate, etc.",null,0,0,{"$f":"H9","v":45979.199999999997},{"$f":"I9","v":28420.799999999999},{"$f":"$N$9","v":101084.87164179103},{"$f":"$O$9","v":83526.471641791039},{"$f":"$J$9","v":116172.8567164179},{"$f":"$K$9","v":98614.456716417902},{"$f":"$N$9","v":101084.87164179103},{"$f":"$O$9","v":83526.471641791039},{"$f":"$J$9","v":116172.8567164179},{"$f":"$K$9","v":98614.456716417902},{"$f":"$N$9","v":101084.87164179103},{"$f":"$O$9","v":83526.471641791039},{"$f":"$J$9","v":116172.8567164179},{"$f":"$K$9","v":98614.456716417902}]
[2000,"p.ann./ha.  Other materials and services ",null,null,null,{"$f":"$A$58/2*$C$9*$Q$4","v":2246.094793402217},{"$f":"$A$58/2*$C$9*$R$4","v":1753.905206597783},{"$f":"$A$58/2*$C$9*$Q$4","v":2246.094793402217},{"$f":"$A$58/2*$C$9*$R$4","v":1753.905206597783},{"$f":"$A$58/2*$C$9*$Q$4","v":2246.094793402217},{"$f":"$A$58/2*$C$9*$R$4","v":1753.905206597783},{"$f":"$A$58/2*$C$9*$Q$4","v":2246.094793402217},{"$f":"$A$58/2*$C$9*$R$4","v":1753.905206597783},{"$f":"$A$58/2*$C$9*$Q$4","v":2246.094793402217},{"$f":"$A$58/2*$C$9*$R$4","v":1753.905206597783},{"$f":"$A$58/2*$C$9*$Q$4","v":2246.094793402217},{"$f":"$A$58/2*$C$9*$R$4","v":1753.905206597783},{"$f":"$A$58*$Q$4","v":1123.0473967011085},{"$f":"$A$58*$R$4","v":876.95260329889152}]
[null,"      Fixed costs",{"$f":"SUM(D59:S59)","v":2505152.1051921546},{"$f":"SUM(D60:D65)","v":9400},{"$f":"SUM(E60:E65)","v":21700},{"$f":"SUM(F60:F65)","v":52140},{"$f":"SUM(G60:G65)","v":182614.07513126879},{"$f":"SUM(H60:H65)","v":179564.07513126879},184778.8001312688,181728.8001312688,186972.7489187688,183922.7489187688,189196.31601490008,186146.31601490008,191449.90126682911,188399.90126682911,193733.9099196592,{"$f":"SUM(R60:R64)","v":184019.83478839041},{"$f":"SUM(S60:S64)","v":189384.6775580337}]
[100,"Office - phones, internet, rent, power",null,100,200,240,{"$f":"$A$60/2","v":50},50,50,50,50,50,50,50,50,50,50,50,50]
[3200,"Cars - fuel and maintenance ",null,0,100,200,{"$f":"$A$61/2","v":1600},{"$f":"$A$61/2","v":1600},1600,1600,1600,1600,1600,1600,1600,1600,1600,1600,1600]
[18200,"Fin. reporting, Online Cash-Flow Control System",null,0,1000,{"$f":"$A$62/2","v":9100},{"$f":"$A$62/2","v":9100},9100,9100,9100,9100,9100,9100,9100,9100,9100,9100,9100,9100]
[2.7E-2,"Payroll, administration, p. ann.",{"$f":"Staff!G33","v":320700},{"$f":"(Staff!F9+Staff!F19+Staff!F22)*3","v":9300},{"$f":"(Staff!F9+Staff!F19+Staff!F22)*6","v":18600},{"$f":"(Staff!F9+Staff!F19+Staff!F20+Staff!F22+Staff!F24+Staff!F25*4)*6","v":40800},{"$f":"$C$63/2","v":160350},{"$f":"$C$63/2","v":160350},{"$f":"G63*(1+$A$63/2)","v":162514.72500000001},162514.72500000001,164708.67378750001,164708.67378750001,166932.24088363128,166932.24088363128,169185.82613556032,169185.82613556032,171469.83478839041,171469.83478839041,173784.6775580337]
[{"$f":"'Cap.Goods'!D45","v":6650},"Insurance of building, products, cars",null,null,{"$f":"'Cap.Goods'!D43","v":1800},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850},{"$f":"'Cap.Goods'!$D$43","v":1800},{"$f":"$A$64-$F$64","v":4850}]
[{"$f":"0.12%*M78","v":2.5199999999999992E-3},"of sales - marketing, exhibitions",{"$f":"Intro!U41","v":2644474.25844},null,null,null,{"$f":"IF(AND($M$76>$A$67,G54>F54),$A$65*$C$65,F65)","v":6664.075131268798},{"$f":"IF(AND($M$76>$A$67,H54>G54),$A$65*$C$65,G65)","v":6664.075131268798},6664.075131268798,{"$f":"IF(AND($M$76>$A$67,J54>I54),$A$65*$C$65,I65)","v":6664.075131268798},6664.075131268798,{"$f":"IF(AND($M$76>$A$67,L54>K54)*$C$65,K65)","v":6664.075131268798},{"$f":"IF(AND($M$76>$A$67,M54>L54),$A$65*$C$65,L65)","v":6664.075131268798},{"$f":"IF(AND($M$76>$A$67,N54>M54),$A$65*$C$65,M65)","v":6664.075131268798},{"$f":"IF(AND($M$76>$A$67,O54>N54),$A$65*$C$65,N65)","v":6664.075131268798},{"$f":"IF(AND($M$76>$A$67,P54>O54),$A$65*$C$65,O65)","v":6664.075131268798},{"$f":"IF(AND($M$76>$A$67,Q54>P54),$A$65*$C$65,P65)","v":6664.075131268798},{"$f":"$A$65*$C$65","v":6664.075131268798},{"$f":"$A$65*$C$65","v":6664.075131268798}]
[]
["2020-06-30","Turnkey - start date of operation\nRestarted for corrections\n"]
["3039-02-02T16:00:00",null,null,null,"Years:",1,{"$f":"F68+1","v":2},3,4,5,6,7,null,null,null,null,null,null,null,"up"]
["Level ❸","PROFITABILITY ANALYSIS",null,"Up front investment:",{"$f":"-C18","v":-5997300},{"$f":"F39+G39","v":1431472.5540831406},{"$f":"H39+I39","v":723696.89330317825},{"$f":"J39+K39","v":890409.17263447423},{"$f":"L39+M39","v":1122652.32982472},{"$f":"N39+O39","v":1260383.674608883},{"$f":"P39+Q39","v":1347609.6112368703},{"$f":"R39+S39","v":956052.61542637623}]
[null,"1-Yr period Operating Cash Flows",null,null,"Debt-Service Coverage Ratio = EBIT/Costs",{"$f":"SUM(G70:M70)/T70","v":1.9410462942172195},{"$f":"(G29+G26)/G88","v":1.4912911145228023},{"$f":"(I29+I26)/I88","v":1.4129792557331535},{"$f":"(J29+J26)/J88","v":2.5568761857998434},{"$f":"(K29+K26)/K88","v":1.6515497629913394},{"$f":"(M29+M26)/M88","v":1.977570136127468},{"$f":"(O29+O26)/O88","v":2.1810189831730153},{"$f":"(Q29+Q26)/Q88","v":2.3160386211729138},null,null,null,null,null,null,{"$f":"MATCH(50,G70:S70)","v":"1900-01-07"}]
["Discounted Cash Flow Models",null,"The Investor can make enough in operating ",null,null,{"$f":"IF(F70>=1.2,\"Good\",\"Bad\")","v":"Good"},"Default Risk Management ",null,null,null,"Operational Risk Management"]
["Section MEASURING PROFITABILITY",null,"profits to pay its current debt service costs. It is subject of fiscal year-end monitoring.",null,null,"DSCR","Section",null,null,null,null,null,"Section \"SENSITIVITY ANALYSIS\""]
[null,null,null,null,null,"Level④","PAYBACK PERIOD",null,null,null,"Simulation of Good Market",null,"Enter A1 share","Simulation of Bad Market"]
["Discount (hurdle) rate :",null,6.5000000000000002E-2,"Loan Life Coverage Ratio",null,null,"Period:",{"$f":"D132","v":6},6.5368162340215914,null,{"$f":"IF(Bayes!C7>Bayes!C9,\"A1\",\"A2\")","v":"A1"},"Salesman",67,{"$f":"IF(Bayes!C7<Bayes!C9,\"A1 \",\"A2\")","v":"A2"},"Salesman"]
["Net Present Value (NPV for CADS) :",null,{"$f":"NPV(C74,E69:L69)","v":50109.209666475697},"Unlike period-on-period measures such as the above DSCR, it provides the Lender with a measure of the number of times the cash flow over the scheduled loan life can repay the outstanding debt balance.",null,null,"Date:","2022-12-31","earliness",null,null,79,{"$f":"M74/100","v":0.67},{"$f":"100-L75","v":21}]
["IRR :",null,{"$f":"IRR(E69:L69)","v":6.7513377266647412E-2},6.5000000000000002E-2,"LLCR =",{"$f":"C75/A87","v":1.0428373295134007E-2},null,"Accelerated amortization of loans",null,null,"  Good sales",null,"2021-06-30","      Bad sales         Select→",null,"distribution of sales."]
[1,"Commercial bank, Own funds (Loan \"D\")",{"$f":"SUM(D77+E77)","v":0},{"$f":"'Cap.Goods'!N36","v":0},{"$f":"'Cap.Goods'!O36","v":0},0,null,"Update £  it now.",null,null,null,null," . Correction factor for Area of critical announcement"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L75>90,N75>60),\" STOP! Calm down. You've just entered a field of dreams!\",Bayes!P21)","v":2.0999999999999996}]
[null,"Loan \"C\" Local market vegetables",null,null,0,{"$f":"Q10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000}]
[null,{"$f":"O16","v":0},{"$f":"C13","v":"Date:"},"2019-12-30","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30"]
[null,"LOANS              Number of Periods",{"$f":"C12","v":"Nr of Monts"},null,null,{"$f":"E12","v":12},18,24,30,36,42,48,54,60,66,72,78,{"$f":"P12","v":78},{"$f":"Q12","v":84}]
[null," Nr. of periods",{"$f":"MATCH(50,E82:S82)","v":15},null,1,{"$f":"E82+1","v":2},{"$f":"F82+1","v":3},{"$f":"G82+1","v":4},5,6,7,8,9,10,11,12,13,14,{"$f":"R82+1","v":15}]
[null," Nr. of principal period repayments",{"$f":"MATCH(50,F83:S83)","v":14},null,null,{"$f":"D11","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
["TOTAL:"," Loan \"A\", Balance liabilities",{"$f":"C16","v":5228500},{"$f":"C85","v":5228500},{"$f":"D85","v":5228500},{"$f":"E85","v":5228500},{"$f":"F85-F87","v":5228500},{"$f":"G85-G87","v":4901186},{"$f":"H85-H87","v":4567325},4226787,3879438,{"$f":"K85-K87","v":3525142},{"$f":"L85-L87","v":3163760},{"$f":"M85-M87","v":2795151},{"$f":"N85-N87","v":2419170},2035669,{"$f":"P85-P87","v":1644498},{"$f":"Q85-Q87","v":1245504},{"$f":"R85-R87","v":838530}]
[{"$f":"SUM(G86:S86)","v":622931},"\u0085  Interest payments",{"$f":"'Cap.Goods'!H38","v":0.04},null,null,null,{"$f":"-ROUND(IPMT($C$86/2,F83,$C$83,F85),0)","v":104570},98024,85628,73846,62724,52312,42661,33827,25866,18838,12805,7835,3995,{"$f":"SUM(G86:R86)","v":"3594-08-02"}]
[{"$f":"SUM(G87:S87)","v":4805084},"\u0085 Principal installments",null,null,null,null,{"$f":"-ROUND(PPMT($C$86/2,F83,$C$83,$C$85),0)","v":327314},333861,340538,347349,354296,361382,368609,375981,383501,391171,398994,406974,415114,{"$f":"SUM(G87:R87)","v":4389970}]
[{"$f":"SUM(A86:A87)","v":5428015},"Installments, TOTAL:",{"$f":"SUM(D88:Q88)","v":4594097},{"$f":"SUM(D86:D87)","v":0},0,0,431884,431885,426166,421195,{"$f":"SUM(K86:K87)","v":417020},{"$f":"SUM(L86:L87)","v":413694},411270,409808,{"$f":"SUM(O86:O87)","v":409367},{"$f":"SUM(P86:P87)","v":410009},{"$f":"SUM(Q86:Q87)","v":411799},{"$f":"SUM(R86:R87)","v":414809},{"$f":"SUM(S86:S87)","v":419109}]
[]
["TOTAL:"," Loan \"B\", Balance liabilities",{"$f":"C17","v":768800},{"$f":"D17","v":597800},{"$f":"D90+E17","v":768800},{"$f":"E90+F17","v":768800},{"$f":"F90-F92","v":768800},{"$f":"G90-G92","v":720672},{"$f":"H90-H92","v":671581},{"$f":"I90-I92","v":621508},{"$f":"J90-J92","v":570434},518338,465200,411000,355716,299326,241808,{"$f":"Q90-Q92","v":183140},{"$f":"R90-R92","v":123298}]
[{"$f":"SUM(D91:S91)","v":104201},"\u0085  Interest payments",{"$f":"'Cap.Goods'!I38","v":0.04},null,{"$f":"-ROUND(IPMT($C$91/2,E82,$C$82,D90),0)","v":11956},{"$f":"-ROUND(IPMT($C$91/2,F82,$C$82,E90),0)","v":14487},{"$f":"-ROUND(IPMT($C$91/2,G82,$C$82,F90),0)","v":13580},{"$f":"-ROUND(IPMT($C$91/2,H82,$C$82,G90),0)","v":12655},{"$f":"-ROUND(IPMT($C$91/2,I82,$C$82,H90),0)","v":10978},{"$f":"-ROUND(IPMT($C$91/2,J82,$C$82,I90),0)","v":9390},7896,6504,5222,4056,3015,{"$f":"-ROUND(IPMT($C$91/2,P82,$C$82,O90),0)","v":2108},{"$f":"-ROUND(IPMT($C$91/2,Q82,$C$82,P90),0)","v":1344},{"$f":"-ROUND(IPMT($C$91/2,R82,$C$82,Q90),0)","v":731},{"$f":"-ROUND(IPMT($C$91/2,S82,$C$82,R90),0)","v":279},{"$f":"SUM(G91:R91)","v":"2112-02-16"}]
[{"$f":"SUM(D92:Q92)","v":585660},"\u0085 Principal installments",{"$f":"ROUND(SUM(D92:S92),-1)","v":706540},null,null,null,{"$f":"-ROUND(PPMT($C$91/2,F83,$C$83,$C$90),0)","v":48128},49091,50073,51074,52096,53138,54200,55284,56390,57518,58668,59842,61038]
[{"$f":"SUM(D93:S93)","v":810741},"Installments, TOTAL:",{"$f":"SUM(D93:Q93)","v":688851},{"$f":"SUM(D91:D92)","v":0},{"$f":"SUM(E91:E92)","v":11956},{"$f":"SUM(F91:F92)","v":14487},{"$f":"SUM(G91:G92)","v":61708},{"$f":"SUM(H91:H92)","v":61746},{"$f":"SUM(I91:I92)","v":61051},{"$f":"SUM(J91:J92)","v":60464},{"$f":"SUM(K91:K92)","v":59992},59642,59422,59340,59405,{"$f":"SUM(P91:P92)","v":59626},{"$f":"SUM(Q91:Q92)","v":60012},{"$f":"SUM(R91:R92)","v":60573},{"$f":"SUM(S91:S92)","v":61317}]
["Diversification following from Risk Assessment"]
["OPERATIONAL TEST }  Balance liabilities",null,{"$f":"C77","v":0},{"$f":"D77","v":0},{"$f":"D95+E77","v":0},{"$f":"E95+F77","v":0},{"$f":"F95-F97","v":0},{"$f":"G95-G97","v":0},{"$f":"H95-H97","v":0},0,0,0,0,0,0,0,0,{"$f":"Q95-Q97","v":0},{"$f":"R95-R97","v":0}]
[{"$f":"ROUND(SUM(D96:Q96),-1)","v":0},"\u0085  Interest payments",{"$f":"'Cap.Goods'!N38","v":5.5E-2},null,{"$f":"-ROUND(IPMT($C$96/2,E82,$C$82,D95),0)","v":0},{"$f":"-ROUND(IPMT($C$96/2,F82,$C$82,E95),0)","v":0},{"$f":"-ROUND(IPMT($C$96/2,G82,$C$82,F95),0)","v":0},{"$f":"-ROUND(IPMT($C$96/2,G83,$C$83,G95),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G96:R96)","v":"00:00:00"}]
[null," Principal deferred payments",{"$f":"C77","v":0},null,null,null,{"$f":"-ROUND(PPMT($C$96/2,F83,$C$83,$C$95),0)","v":0},{"$f":"-ROUND(PPMT($C$96/2,H82,$C$82,$C$95),0)","v":0},{"$f":"-ROUND(PPMT($C$96/2,I82,$C$82,$C$95),0)","v":0},0,0,0,0,0,0,0,{"$f":"-ROUND(PPMT($C$96/2,Q82,$C$82,$C$95),0)","v":0},{"$f":"-ROUND(PPMT($C$96/2,R82,$C$82,$C$95),0)","v":0},{"$f":"-ROUND(PPMT($C$96/2,S82,$C$82,$C$95),0)","v":0}]
[null,"Installments, TOTAL:",null,null,{"$f":"SUM(E96:E97)","v":0},{"$f":"SUM(F96:F97)","v":0},{"$f":"SUM(G96:G97)","v":0},{"$f":"SUM(H96:H97)","v":0},{"$f":"SUM(I96:I97)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R96:R97)","v":0},{"$f":"SUM(S96:S97)","v":0}]
[]
[{"$f":"A86+A91+A96","v":727132},"GRAPHS",null,1,{"$f":"D100+1","v":2},{"$f":"E100+1","v":3},4,5,6,7,8,9,10,11,12,{"$f":"O100+1","v":13},{"$f":"P100+1","v":14},{"$f":"Q100+1","v":15},{"$f":"R100+1","v":16}]
[null,"Total balance liabilities,  Loan \"A\"",null,{"$f":"D85","v":5228500},5228500,{"$f":"F85","v":5228500},5228500,4901186,{"$f":"I85","v":4567325},4226787,3879438,3525142,3163760,2795151,2419170,2035669,1644498,{"$f":"R85","v":1245504},{"$f":"S85","v":838530}]
[null,"OPERATING PERIOD } Total balance liabilities \"A\"","IN OPERATION",{"$f":"D85","v":5228500},{"$f":"E85","v":5228500},{"$f":"F85","v":5228500},{"$f":"G85","v":5228500},{"$f":"H85","v":4901186},{"$f":"I85","v":4567325},4226787,3879438,3525142,3163760,2795151,2419170,2035669,1644498,{"$f":"R85","v":1245504},{"$f":"S85","v":838530}]
[{"$f":"IF(SUM(G86:Q86)=C85,\"True\",\"False\")","v":"False"},"Cash",null,{"$f":"D39","v":-2509700},-3530656,1260223.1547593202,171249.39932382037,527862.78939741896,195834.10390575929,670661.15828145714,219748.01435301709,791016.23839147575,331636.09143324418,887003.93046438368,373379.7441444993,934968.20664218697,412641.40459468344,534658.28646989365,421394.32895648258]
[null,"Cash Cumulative",null,{"$f":"D40","v":-2509700},-6040356,-4780132.8452406796,-4608883.4459168594,-4081020.6565194405,-3885186.5526136812,-3214525.394332224,-2994777.3799792072,-2203761.1415877314,-1872125.0501544871,-985121.11969010346,-611741.37554560415,323226.83109658281,735868.23569126625,1270526.5221611599,1691920.8511176426]
[null,"Operating cash cumulative",null,{"$f":"D35","v":-9400},{"$f":"D35+E35","v":-43056},{"$f":"E35+F35","v":1226567.1547593202},{"$f":"F35+G35","v":1806914.5540831406},{"$f":"H125","v":2674673.3434805595},3261118.4473863188,4330202.6056677755,4956342.6200207928,6161878.8584122686,6916323.9498455124,8234592.8803098965,9047863.6244543958,10431520.831096582,11301824.235691266,12172127.64028595,13042431.044880634]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"up"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Debt Rate",{"$f":"D102/$C$18","v":0.87180898070798529},0.87180898070798529,0.87180898070798529,0.87180898070798529,0.81723208777283107,0.7615635369249496,0.70478165174328444,0.64686408883997804,0.58778817134377137,0.52753072215830454,0.4660682307038167,0.4033765194337452,0.33943091057642605,0.27420639287679455]
[null,null,"Start date"]
[null,"Auxiliary rows: Crossing point of cash and debt",{"$f":"D80","v":"2019-12-30"},1,{"$f":"D124+1","v":2},{"$f":"E124+1","v":3},4,5,6,7,8,9,10,{"$f":"M124+1","v":11},12,13,14,{"$f":"Q124+1","v":15},{"$f":"R124+1","v":16}]
[null,"Payback   >   cumulate OCFs",{"$f":"MATCH(A128,D105:Q105)","v":2},{"$f":"$D$35","v":-9400},{"$f":"D125+$E$35","v":-43056},{"$f":"E125+$F$35","v":1217167.1547593202},{"$f":"F125+$G$35","v":1763858.5540831406},{"$f":"G125+$H$35","v":2674673.3434805595},{"$f":"H125+$I$35","v":3261118.4473863188},{"$f":"I125+$J$35","v":4330202.6056677755},{"$f":"J125+$K$35","v":4956342.6200207928},{"$f":"K125+$L$35","v":6161878.8584122686},{"$f":"L125+$M$35","v":6916323.9498455124},{"$f":"M125+$N$35","v":8234592.8803098965},{"$f":"N125+$O$35","v":9047863.6244543958},{"$f":"O125+$P$35","v":10431520.831096582},{"$f":"P125+$Q$35","v":11301824.235691266},{"$f":"Q125+$Q$35","v":12172127.64028595},{"$f":"R125+$Q$35","v":13042431.044880634}]
[null,"repayment estimatior row",{"$f":"DATE(YEAR(C124)+C125,MONTH(C124)+2,DAY(C124+7))","v":"2022-02-06"},{"$f":"CHOOSE(C125,E80,F80,G80,H80,I80,J80,K80,L80,M80,N80,O80,P80,Q80)","v":"2020-12-31"},{"$f":"C125*6","v":12},{"$f":"E126/12","v":1},{"$f":"ROUNDUP(F126,0)","v":1},{"$f":"G126-F126","v":0},{"$f":"H126*12","v":0}]
[null,"auxiliary row","Payback date",null,{"$f":"(D126-E80)/12","v":15.333333333333334},{"$f":"ROUNDDOWN(E127,0)","v":15},{"$f":"E127-F127","v":0.33333333333333393},{"$f":"G127*12","v":4.0000000000000071},{"$f":"IF(H127=12,F127+1,F127)","v":15},{"$f":"IF(H127=12,0,H127)","v":4.0000000000000071}]
[{"$f":"C86","v":0.04},"Base forecast"]
[{"$f":"D132*365+1+E132*30+4","v":2391.1044870206479},"Yr:",null,1,2,3,4,5,6,7,8]
[{"$f":"A129/(365+1)","v":6.5330723689088739},"AnnNCinF",null,{"$f":"D39+E39","v":-6040356},{"$f":"F39+G39","v":1431472.5540831406},{"$f":"H39+I39","v":723696.89330317825},{"$f":"J39+K39","v":890409.17263447423},{"$f":"L39+M39","v":1122652.32982472},{"$f":"N39+O39","v":1260383.674608883},{"$f":"P39+Q39","v":1347609.6112368703}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},"Comulative",null,{"$f":"D130","v":-6040356},{"$f":"D131+E130","v":-4608883.4459168594},{"$f":"E131+F130","v":-3885186.5526136812},-2994777.3799792072,-1872125.0501544871,-611741.37554560415,735868.23569126613]
[{"$f":"A131+A129","v":{"$error":"#REF!"}},"Period",null,{"$f":"COUNTIF(D131:J131,\"<\"&A128)","v":6},{"$f":"F132*12/10","v":6.5368162340215914},{"$f":"(A128-HLOOKUP(COUNTIF(D131:J131,\"<\"&A128),D129:J131, 3,0))/(HLOOKUP(COUNTIF(D131:J131,\"<\"&A128)+1,D129:J131,2,0))*12","v":5.4473468616846601}]
[null,null,null,null," Ê   "," Indicates the fraction of the year"]
[]
[]
[null,null,null,0.22900000000000001,0.1787,0.14219999999999999,6.5500000000000003E-2,1.9900000000000001E-2,1.9E-3,0,0,1.2E-2,6.4399999999999999E-2,0.08,0.2064,{"$f":"SUM(D136:O136)","v":1}]

{"sheet":"Bayes","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[10,5,12,15],[6,9,6,15],[7,9,7,15],[8,9,8,15],[8,5,8,8],[9,5,9,15],[10,0,10,1],[12,0,12,1],[1,0,2,0],[6,0,6,1],[8,0,8,1],[27,16,28,16],[29,16,30,16],[30,1,31,15],[33,10,35,15],[14,2,14,3],[14,6,14,8],[14,10,14,14],[15,13,15,14],[20,11,21,11],[22,16,23,16],[23,1,24,15],[24,16,25,16],[25,0,26,15],[47,0,49,0],[43,1,43,2],[43,3,43,4],[43,5,43,6],[15,6,15,8],[27,1,29,15],[43,7,44,15],[44,1,44,2],[44,5,44,6],[45,1,45,2],[39,1,41,15]]}
["CHAPTER 1 ","DECISION ANALYSIS",null,null,null,null,null,null,null,null,null,"Name of Project"]
["Level④","POSTERIOR PROBABILITIES OF TWO EVENTS",null,null,null,null,null,null,null,null,null,{"$f":"Intro!H5","v":"TomCuc Greenhouse"}]
[]
["Background:","You are producer and supplier of high quality vegetables to two salesmen on large nets of European wholesale markets. Let A1 and A2 denoted two events of interest—different quantiies for sales."]
["Historical Info: ","Enter new data below. If except these two events of interest there are more probabilities indicated by the Online Cash-Flow Control System, go to the next Sheet\u0086 \"Bayes5\" ."]
[]
[" Event A1: part of QUANTITY for Salesman A1 →",null,{"$f":"BUDGET!M75","v":0.67}," Percentage of prior probability for sale on the market.",null,null,null,null,null,"The mutually exclusive events for which posterior probabilities are desired."]
[null,null,null,null,null,null,null,null,null,"My events of interest:"]
[" Event A2: part of QUANTITY for Salesman A2 →",null,{"$f":"100%-C7","v":0.32999999999999996}," Percentage supplied to A2   I ",null,"→ low quality of commercial service - term → of deferred payment and lower income.",null,null,null,"Which of both market distributors sells our products             on the better prices and pays us faster?"]
[null,null,null,null,null,"In analyzing of conditional prior probability for specific events of interest here are indicated probabilities giving new information for their revision"]
[" Event A1:  QUALITY Good services for Salesman A1 →",null,{"$f":"BUDGET!L75/100","v":0.79}," Percentage Good sаlеs and payments (G)",null,"Based on pre-design marketing the values of prior conditional probabilities of professional ratings of the two salesmen and their markets are shown in the Table. This prior probability will be revised in light of new operational information Income streams when appear problems, what is the probability and what part is due to each Sales-man? The Joint Bad Probabilities are found by multiplying the prior probabilities by the Conditional Probabilities = equal to Overall probability of finding the Bad part of commercial outsourcing, and for further improvement."]
[]
[" Event A2:  QUALITY  Bad services for Salesman A2 →",null,{"$f":"BUDGET!N75/100","v":0.21}," Percentage Bad sаlеs and payment (B)"]
[]
["Safe Event",null,"SALES REVENUE EVENTS",null,"PRIOR PROBABILITY",null,"POSTERIOR",null,null,null,"TABULAR APPROACH"]
["Restore Model","When Yu pay - cry"," Percentage of total  Sаlеs","Percentage Bad QUALITY Sаlеs","QUANTITY % from A1∩A2 Sаlеs",null,"      PROBABILITIES         that Bad part of sales is:",null,null,null,"A1U A2 Prior Probabilities","B Conditional Probabilities","Joint  Bad A1, 2 ∩ B","Posterior Probabilities",null,"Others cry"]
[]
["Clean Model","Salesman A1",{"$f":"C7","v":0.67},{"$f":"1-C11","v":0.20999999999999996},{"$f":"C7","v":0.67},null,"From Salesman A1:",null,{"$f":"D18*E18/(D18*E18+D20*E20)","v":0.67},null,{"$f":"C18","v":0.67},{"$f":"D18","v":0.20999999999999996},{"$f":"K18*L18","v":0.14069999999999999},{"$f":"M18/M21","v":0.67}]
[]
[null,"Salesman A2",{"$f":"C9","v":0.32999999999999996},{"$f":"C13","v":0.21},{"$f":"1-E18","v":0.32999999999999996},null,"From Salesman A2:",null,{"$f":"D20*E20/(D18*E18+D20*E20)","v":0.33},null,{"$f":"C20","v":0.32999999999999996},{"$f":"D20","v":0.21},{"$f":"K20*L20","v":6.9299999999999987E-2},{"$f":"M20/M21","v":0.33}]
["ANALYSIS:","On relative basis: the probability of the Bad event, coming from Salesman А2 [",null,null,null,{"$f":"N20","v":0.33},"] compared [",{"$f":"N18","v":0.67},"] from Good A1.",null,{"$f":"K18+K20","v":1},"To the new  info given each event",{"$f":"SUM(M18:M20)","v":0.20999999999999996},{"$f":"N18+N20","v":1},null,{"$f":"M21*10+O21*1","v":2.0999999999999996}]
[null,"There is a greater likelihood Bad event to be observed because outcome as [ ",null,null,null,{"$f":"M20","v":6.9299999999999987E-2},"] following  [",{"$f":"N20","v":0.33},"] A2 Bad event could be a crash.",null,null,null,"Overall <probability of Bad event="]
[]
["CLOSING:"]
[]
["       Constructed using \"Quantitative Methods for Business\" (Fifth edition); David R. Anderson, University of Cincinnati, Dennis J. Sweeney, University of Cincinnati, Thomas A. Williams, Rochester Institute of Technology; Library of Congress Cataloging-in-Publication Data."]
[]
["COMMENTS:","It is well known and certainly recommendable that to start an investment project, the investor (and his team making inside risk assessment) must be convinced, must believe in the good outcome, and he must act decisively, without any hesitation. Very often, this is reflected in a low assessment of the Default Risk Ratio (d--Factor) that is raising its real impact. In such cases we approach the above probability estimation, often called “what-if” analysis. It follows the High Qualified Audit, in this Risk Assessment program recognized as \"Group D\"."]
[]
[]
[null,"Excerpts from the comments of our clients of this model: \". . . default risk assessment is the starting point which most frequently cause disputes with the lenders, very often ending with denial of funding, no matter what the finally stated reason was.\" Look at the picture below, which is the most popular example of visible illusion.\n\n\n"]
[]
[]
[null,null," We are looking out to the market and don’t see a big risk to become unable to pay back our debt.",null,null,null,null,null,null,null,"Who is right, when the lengths of the lines are equal? . . . \""]
[]
[null,null,"        The lenders are only looking within themselves, see plenty of big risks, and talk only about it."]
[]
[null,"In making a decision for new investments never believe and rely solely on: ① your intuition, based on long-term experience; ② suggestions of high level experts; and ③ good chance."]
[null,"Rely only on risk assessment and computing of prior and posterior probability of specific events of interest. Once you have them, return to the above approaches for the final decision."]
[null,"The assessment of Default Risk (d ) to an acceptable level is a key factor for the positive resolution of a loan application. The system, called OCFCS for short, which we recommend is an instrument that serves post factum an investment throughout the project providing permanent online information to the lender, insurer and to the investor."]
[]
[]
[]
["RECORD:","PROJECT NAME",null,"QUALITY",null,"QUANTITY",null,"The event . . . "]
[null,"(or Investor Name)",null,"AGENT A1","AGENT A2","AGENT A1"]
[null,{"$f":"L2","v":"TomCuc Greenhouse"},null,0.98,0.95,null,0.65,"Agents distribute in their countries these percentages of KEM's products."]
[]
["Keep  these h cells free for longer project name extension"]

{"sheet":"Staff","index":4,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,4,7,5],[16,9,17,9],[0,9,1,9],[0,8,1,8],[15,7,15,8],[5,7,5,8],[6,9,7,9],[7,7,7,8],[17,7,17,8]]}
[null,null,null,"лв./$ exchange rate:",1,1.52,null,null,{"$f":"Intro!A99","v":4},"Area "]
[null,null,null,"USD/EUR exchange rate:",1,1.05]
[null,null,null,"EUR/лв. exchange rate:",1,1.96,null,null,null,null,null,"Supporting Column"]
[]
[null,null,"OCFCS & Trading Consulting Company",null,null,"STAFF - Start Salaries"]
[null,null,null,"PERSONNEL, Position","%","€ p.Мо","p.ann","€ p.Mo",null,0]
[null,null,null,null,"Remuneration",null,null,"₊Bonus"]
[null,null,null,"WORKING ТЕАМ",null,null,null,"(conditional)"]
[null,null,1,"Manager",0.5,1000,{"$f":"E9*F9*$J$16","v":6000},100,{"$f":"E9*(F9+G9)","v":3500},{"$f":"E9*I9*$J$6","v":0}]
[null,null,{"$f":"C9+1","v":2},"Expert risk management",0.5,600,{"$f":"E10*F10*$J$16","v":3600},75,0,{"$f":"I10*$J$6","v":0}]
[null,null,{"$f":"C10+1","v":3},"Expert financial control",0.5,600,3600,50,0,{"$f":"I11*$J$6","v":0}]
[null,null,null,"TOTAL:",1.5,null,{"$f":"SUM(G9:G11)","v":13200},null,null,{"$f":"SUM(J9:J11)","v":0}]
[]
[]
[null,null,"Project Company TomCuC, Ltd.",null,null,"STAFF - Start Salaries"]
[null,null,null,"PERSONNEL, Position","Nr","€ p.Мо","p.ann","€ p.Mo",null,12]
[null,null,null,null,null,"Base salary","Fixed","₊Bonus","TOTAL"]
[null,null,null,"ASMINISTRATION",{"$f":"SUM(E19:E22)","v":6},"salary","salary","(conditional)"]
[null,null,1,"CEO - Manager",1,1500,{"$f":"E19*F19*$J$16","v":18000},300,{"$f":"F19+H19","v":1800},{"$f":"E19*I19*$J$16","v":21600}]
[null,null,{"$f":"C19+1","v":2},"Senior level technicans",2,1000,{"$f":"E20*F20*$J$16","v":24000},200,{"$f":"F20+H20","v":1200},{"$f":"E20*I20*$J$16","v":28800}]
[null,null,{"$f":"C20+1","v":3},"Mid-level tehnicans",2,600,{"$f":"E21*F21*$J$16","v":14400},100,{"$f":"F21+H21","v":700},{"$f":"E21*I21*$J$16","v":16800}]
[null,null,{"$f":"C21+1","v":4},"Accountant",1,600,{"$f":"E22*F22*$J$16","v":7200},50,{"$f":"F22+H22","v":650},{"$f":"E22*I22*$J$16","v":7800}]
[null,null,null,"SERVICE STAFF",{"$f":"SUM(E24:E25)","v":5}]
[null,null,{"$f":"C22+1","v":5},"Truckers",1,700,{"$f":"E24*F24*$J$16","v":8400},50,{"$f":"F24+H24","v":750},{"$f":"E24*I24*$J$16","v":9000}]
[null,null,{"$f":"C24+1","v":6},"Security",4,500,{"$f":"E25*F25*$J$16","v":24000},0,{"$f":"F25+H25","v":500},{"$f":"E25*I25*$J$16","v":24000}]
[null,null,null,"SubTOTAL:",{"$f":"E18+E23","v":11},null,{"$f":"SUM(G19:G25)","v":96000},null,null,{"$f":"SUM(J19:J25)","v":108000}]
[]
[null,null,30,"PRODUCTION STAFF",{"$f":"E29","v":30}]
[null,null,7,"Payroll staff, p Mo",{"$f":"C28","v":30},500,{"$f":"E29*F29*$J$16","v":180000},100,{"$f":"F29+H29","v":600},{"$f":"E29*I29*$J$16","v":216000}]
[null,null,null,"Social Security (averaged)",null,null,{"$f":"G29*I30","v":31499.999999999996},null,{"$f":"I37","v":0.17499999999999999},{"$f":"I30*J29","v":37800}]
[null,null,null,"SubTOTAL:",null,null,{"$f":"G29+G30","v":211500},null,null,{"$f":"SUM(J29:J30)","v":253800}]
[]
[null,null,null,"TomCuC HH, Ltd., TOTAL:",{"$f":"E26+E28","v":41},null,{"$f":"G12+G26+G31","v":320700},null,null,{"$f":"J26+J29","v":324000}]
[]
[]
[]
[null,null,null,"Social Security (averaged)",null,null,null,null,0.17499999999999999,{"$f":"I37*(J12+J26)","v":18900}]
[null,null,null,"TOTAL:",null,null,null,null,null,{"$f":"J12+J33+J37","v":342900}]
[]
[]
[null,null,"*","Consequence of the need of Effective System of Internal Control during the repayment period."]
[null,null,null,"It must have to this position special Assignment of Responsibilities combining virtual treasurer and controller."]
[null,null,null,"He should have Limited Proper Authorization during the loan repayment period only."]

{"sheet":"Bayes5","index":5,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,14,17,17],[11,14,11,17],[12,14,12,17],[13,14,13,17],[14,14,14,17],[15,14,15,17],[16,14,16,17],[10,14,10,17],[1,1,1,8],[6,14,6,17],[7,14,7,17],[8,14,8,17],[9,14,9,17]]}
["CHAPTER 1 ",null,null,null,null,"DECEISION ANALYSES",null,null,null,null,null,null,null,null,null,"Name of Project"]
[null,"POSTERIOR PROBABILITIES OF FIVE EVENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap.Goods'!E3","v":"Zoom 152        Capital Goods and Services "}]
[]
["Background:","Five mutually exclusive events following delivery of goods or services by Suppliers  where one of the events must occur when new information"]
["Clean and Start","from a sample, a special report, a product test, and so on, about it is received. Henceforth, you have to revise or update the prior probability values."]
["Historical Info: ","Good quality event \u0088  ENTER",null,null,null,null,null,"Complete here\u0088  the here Bad parts or services received from each supplier . "]
[null,null,"QUALITY",null,null,null,"QUANTITY",null,"POSTERIOR PROBABILITY",null,"CONDITIONAL",null,"FINAL",null,"NOTES"]
[null,null,"% Good",null,"% Bad",null,"% from",null,"that Bad event is:",null,"Joint  Bad A1,2 ∩B",null,"for Ai"]
[" Event A1 from:","Supplier A1 (Subcontractor)",null,null,{"$f":"1-C9","v":1},null,null,null,{"$f":"100*E9*G9/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G9*E9","v":0},null,{"$f":"K9/$K$19","v":0}]
[]
[" Event A2 from:","Supplier A2 (Subcontractor)",null,null,{"$f":"1-C11","v":1},null,null,null,{"$f":"100*E11*G11/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G11*E11","v":0},null,{"$f":"K11/$K$19","v":0}]
[]
[" Event A3 from:","Supplier A3  (Subcontractor)",null,null,{"$f":"1-C13","v":1},null,null,null,{"$f":"100*E13*G13/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G13*E13","v":0},null,{"$f":"K13/$K$19","v":0}]
[]
[" Event A4 from:","Supplier A4 (Subcontractor)",null,null,{"$f":"1-C15","v":1},null,null,null,{"$f":"100*E15*G15/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G15*E15","v":0},null,{"$f":"K15/$K$19","v":0}]
[]
[" Event A5 from:","Supplier A5  (Subcontractor)",null,null,{"$f":"1-C17","v":1},null,{"$f":"1-SUM(G9:G15)","v":1},null,{"$f":"100*E17*G17/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":100},null,{"$f":"100*G17*E17","v":100},null,{"$f":"K17/$K$19","v":1}]
[]
["See Comments",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K18)","v":100},null,{"$f":"SUM(M9:M18)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Overall<probability of happen Bad event"]