{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","Cap.Goods","BUDGET","Bayes","Staff","Bayes5"],"not_rendered":{"charts":2,"images":63,"macros":1,"external_links":3,"defined_names":59,"comments":3,"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":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,17,1,18],[32,0,32,1],[25,4,25,6],[29,4,29,6],[30,0,30,2],[6,0,6,1],[19,16,19,17],[14,8,14,9],[19,8,19,9],[0,14,1,15],[6,10,6,11],[19,14,19,15],[19,12,19,13],[19,10,19,11],[30,12,30,13],[30,14,30,15],[30,16,30,17],[46,1,46,2],[27,5,27,6],[29,12,29,13],[29,14,29,15],[28,1,28,2],[29,0,29,2],[14,14,14,16],[15,7,16,9],[10,8,10,9],[12,8,12,9],[29,16,29,17],[14,10,14,13],[10,10,10,17],[12,10,12,16],[15,17,15,18],[22,0,22,2],[30,4,30,6],[0,3,1,5],[29,8,29,9],[29,10,29,11],[30,8,30,9],[30,10,30,11]]}
[0,null,null," PRE-DESIGN BACKGROUND"]
[null,null,"   Level"]
[null,null,"            SALES, cap. investment loan life",null,{"$f":"SUM(E4:E7)","v":13553000},null,"  C"]
[null,null,"            Apartments and vilas",null,{"$f":"J22+L22+N22+P22+R22+T22","v":664999.99999999988},null,null,"     Represented by local auxiliary east electric company Ltd., Bulgaria "]
[null,null,"            Hotel accomodations",null,{"$f":"J24+L24+N24+P24+R24+T24","v":4104000}]
[null,null,"            Cruise inter terminal",null,{"$f":"J26+L26+N26+P26+R26+T26","v":0},null,null,null,"UNDER CONSTRUCTION"]
[" Click the picture \u0093 to increase it",null,"            Yacht marina",null,{"$f":"J28+L28+N28+P28+R28","v":8784000},null,null,null,null,null,"   Exchange Rate",null,null,null,null,"stop"]
[]
[null,null,"           COSTS p.ann.",null,{"$f":"BUDGET!G22+BUDGET!H22","v":669033.5},null,null,null,null,null,1,1.96]
[null,null,"           Variable costs",null,{"$f":"BUDGET!G54+BUDGET!H54","v":534853.5}]
[null,null,"           Fixed costs",null,{"$f":"BUDGET!G64+BUDGET!H64","v":87980},null,null,null,"  Cap.Goods",null," Capital Goods and Services & Working Capital  8Import and local country expenses"]
[null,null,"           Marketing and RM",null,null,null,null,2]
[null,"Efficiency of selling real estates",null,"From market Bad,","Greenhouse Good","Increae / Decrease",null,3,"  Budget",null,"Cash-flow Pro-forma Budgeting    8Profitability and sensitivity analysis - pessimistic forecast"]
[null,"     Increased number of estates for sale",null,109,92,{"$f":"(E14-D14)/D14","v":-0.15596330275229359},{"$f":"F5*(1-F14)","v":0}]
[null,"     Increased the sale price, €",null,3.2,4.3,{"$f":"(E15-D15)/D15","v":0.34374999999999989},{"$f":"G14*(1+F15)","v":0},"4Buyes","  Bayes",null," Decision Analysis 8Operational risk management",null,null,null,"• Posterior Probability               • Analyzing Theorem"]
[null,null,null,null,"Revenue increase due to wheat, TOTAL:",{"$f":"G14/G15","v":{"$error":"#DIV/0!"}},null,"\u0085\u0085 Click the image to change it",null,null,null,null,null,null,null,null,null,"Go to Bayes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area :",1," Yield t p.a/0.1 ha ",null,"Price, p.t"]
[null,"Overall probability of Bad event - loss of buyers of own product",null,null,null,{"$f":"Bayes!P21/100","v":1.4349999999999999E-3},{"$f":"G15*(1-F18)","v":0},null,null,null,null,null,null,null,{"$f":"O17-O19","v":0.19999999999999996},"C",70,950]
[null,null,null,null,null,null,null,"5-Yr Option","FINAL RETAIL PRODUCTS  FOR SALE",null,null,null,null,null,0.8,"T",90,1140]
[null,null,null,null,null,null,null,"Nr of Yrs:",{"$f":"BUDGET!H86/2","v":1},null,{"$f":"BUDGET!J86/2","v":2},null,{"$f":"BUDGET!L86/2","v":3},null,{"$f":"BUDGET!N86/2","v":4},null,{"$f":"BUDGET!P86/2","v":5},null,"Check"]
["     The Dutch greenhouse complex",null,"             Project Financing",null,null,null,null,"Prodicts","t p.a.","Total","t p.a.","Total","t p.a.","Total","t p.a.","Total","t p.a.","Total",{"$f":"IF(SUM(E4:E7) = S30,\"True\",\"False\")","v":"True"}]
[" ECA(s) \u0086"," Export Credit Insurance ",null,"            Financial Modeling",null,null,null," C",{"$f":"BUDGET!$P$2","v":70},{"$f":"BUDGET!$P$3","v":132999.99999999997},{"$f":"BUDGET!$P$2","v":70},{"$f":"BUDGET!$P$3","v":132999.99999999997},{"$f":"BUDGET!$P$2","v":70},{"$f":"BUDGET!$P$3","v":132999.99999999997},{"$f":"BUDGET!$P$2","v":70},{"$f":"BUDGET!$P$3","v":132999.99999999997},{"$f":"BUDGET!$P$2","v":70},{"$f":"BUDGET!$P$3","v":132999.99999999997},{"$f":"SUM(J22,L22,N22,P22,R22)","v":664999.99999999988}]
["                Kala Marina \u0086  \u0086 Marketing",null,null,null,"        Business Plan  \u0085  East Electric Company",null,null,"Outcome:"]
[null,null,null,null,"            Risk Assessment \u0085  Еquivalence Ltd.\u0086",null,null," T",{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"BUDGET!$P$5","v":820800},{"$f":"SUM(J24,L24,N24,P24,R24)","v":4104000}]
[null,null,null,null,"               Constructin of facilities",null,null,"Outcome:"]
[null,null,null,null,"          Infrastructure, power connection",null,null,"By-products",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J26,L26,N26,P26,R26)","v":0}]
[null,"  Material products:",null,null,null,null,null,"2ndstage of project"]
[null,"                               Marine ←",null,null,null,"Intelectual products:",null,"Others, fromarket",null,{"$f":"BUDGET!$C$49","v":1756800},null,{"$f":"BUDGET!$C$49","v":1756800},null,{"$f":"BUDGET!$C$49","v":1756800},null,{"$f":"BUDGET!$C$49","v":1756800},null,{"$f":"BUDGET!$C$49","v":1756800},{"$f":"SUM(J28,L28,N28,P28,R28)","v":8784000}]
[null,"             Residential ←",null,null,"              ← Risk assessment & management",null,null,"Outcome:"]
["                                             Lseure ←",null,null,null,"                ← Online cash-flow control system ",null,null,"Budget, TOTAL",{"$f":"J22+J24+J26+J28","v":2710600},null,{"$f":"L22+L24+L26+L28","v":2710600},null,{"$f":"N22+N24+N26+N28","v":2710600},null,{"$f":"P22+P24+P26+P28","v":2710600},null,{"$f":"R22+R24+R26+R28","v":2710600},null,{"$f":"SUM(S22:S29)","v":13553000}]
["                                     Commercial ←",null,null,null,"        ← History of sales and costs ",null,null,"Outcome, TOTAL",{"$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},null,{"$f":"R23+R25+R27+R29","v":0}]
[null,"The applied color and image visualizations in all worksheets are not to impress you, but 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,"*"]

{"sheet":"Cap.Goods","index":1,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,5,59,7],[2,10,2,11],[47,1,48,1],[27,11,27,12],[9,4,9,5],[10,4,10,5],[14,10,24,10],[43,10,44,10],[46,4,46,5],[47,10,48,10],[27,1,42,1],[43,1,44,1],[27,10,42,10],[4,12,4,13],[5,12,5,13],[6,12,6,13],[1,0,2,0],[14,1,24,1],[15,4,15,5],[2,4,2,9],[8,1,12,1],[6,1,7,1],[56,22,57,23],[50,11,56,11],[27,16,44,16],[28,11,44,11],[7,16,24,16],[7,11,24,11],[7,15,24,15],[28,15,44,15],[48,2,48,3],[50,1,56,1],[50,10,56,10],[50,5,50,7],[51,5,51,7],[54,5,54,7],[55,5,55,7],[52,5,52,7],[49,2,49,3],[3,12,3,13],[47,12,47,13],[6,10,12,10],[49,5,49,7],[53,5,53,7]]}
[]
[]
[null,null,null,"Level 1","Valister Greenhouse",null,null,null,null,null,"€1 ≈ ",null,{"$f":"Intro!L9","v":1.96},null,null,null,null,{"$f":"Intro!L9","v":1.96}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BUDGET!D13","v":"2016-12-31"},null,{"$f":"BUDGET!E13","v":"2017-06-30"}]
[null,null,"Area",null,"EXPORT VALUE  \u0086","Total",null,null,"Local country import","€",null,null,"B. OWN FUNDS",null,"Export Prices",null,null,"Check"]
[null,null,"[ha]","Quantity","3 to 18 Mos deferred payments ","Quantity","Single Prc","Total Net Prc","VAT ↓","TOTAL PRICE",null,null,"Loan \"B\" ↓",null,"Settlement"]
[null,null,{"$f":"Intro!O17","v":1},null,"WORKING CAPITAL (Loan \"C\")  Export Credit Insurance Program",null,null,null,0.2,null,null,null,0.15,null,"Loan \"C\""]
["Ø",null,{"$f":"C7-C9","v":0.19999999999999996},5,"Planting material (seeds) for C",{"$f":"C8*D8","v":0.99999999999999978},500,{"$f":"F8*G8","v":499.99999999999989},{"$f":"H8*$I$7","v":99.999999999999986},{"$f":"H8+I8","v":599.99999999999989},null,null,{"$f":"G8*$M$7","v":75},null,{"$f":"J8-N8","v":599.99999999999989}]
["Ø",2,{"$f":"Intro!O19","v":0.8},5,"Planting material (seeds) for T ",{"$f":"B9*C9*D9","v":8},500,{"$f":"F9*G9","v":4000},{"$f":"H9*$I$7","v":800},{"$f":"H9+I9","v":4800},null,null,{"$f":"G9*$M$7","v":75},null,{"$f":"J9-N9","v":4800}]
["Ø",null,null,null," Water-soluble fertilizers, t"]
["Ø",null,null,null,"Mulching components, t"]
["Ø",null,null,null,null,null,"Working capital, SubTOTAL:",{"$f":"SUM(H8:H11)","v":4500},{"$f":"SUM(I8:I11)","v":900},{"$f":"SUM(J8:J11)","v":5400},null,null,{"$f":"SUM(M8:M11)","v":150},null,{"$f":"SUM(O8:O11)","v":5400}]
[null,null,null,null,"Local market products       Working capital, SubTOTAL:",null,null,{"$f":"J13/(I7+100%)","v":250000},{"$f":"H13*$I$7","v":50000},{"$f":"BUDGET!V11","v":300000},null,null,null,{"$f":"SUM(BUDGET!G11:I11)","v":60000},{"$f":"SUM(BUDGET!J11:O11)","v":120000}]
[null,null,null,null,null,null,"Loan \"C\", WORKING CAPITAL, TOTAL:",{"$f":"SUM(H8:H13)","v":259000},{"$f":"SUM(I8:I13)","v":51800},{"$f":"SUM(J12:J13)","v":305400},null,null,null,null,"Loan \"A\""]
[null,"A.",null,"CAPITAL INVESTMENT IMPORT \u0086(Loan \"A\")  Export Project Finance Program "]
[null,null,1,10000,"Greenhouse turn-key complex",null,120,{"$f":"D16*G16","v":1200000},{"$f":"H16*$I$7","v":240000},{"$f":"H16+I16","v":1440000},null,null,{"$f":"H16*$M$7","v":180000},{"$f":"J16*$M$7","v":216000},{"$f":"J16-M16","v":1260000}]
[null,null,null,null,"Laboratory equipment"]
["Ø",null,null,30,"Photovoltaic power panels",null,14000]
[null,null,null,null,"Inventory - scissors for cutting sheets, etc."]
[null,null,null,1,"El. generator - backup power",null,15000,{"$f":"D20*G20","v":15000},{"$f":"H20*$I$7","v":3000},{"$f":"H20+I20","v":18000},null,null,{"$f":"H20*$M$7","v":2250},{"$f":"J20*$M$7","v":2700},{"$f":"J20-M20","v":15750}]
[null,null,null,1,"Reefer trailers, 5MT",null,25000,{"$f":"D21*G21","v":25000},{"$f":"H21*$I$7","v":5000},{"$f":"H21+I21","v":30000},null,null,{"$f":"H21*$M$7","v":3750},{"$f":"J21*$M$7","v":4500},{"$f":"J21-N21","v":25500}]
[null,null,null,1,"Truck",null,35000,{"$f":"D22*G22","v":35000},{"$f":"H22*$I$7","v":7000},{"$f":"H22+I22","v":42000},null,null,{"$f":"H22*$M$7","v":5250},{"$f":"J22*$M$7","v":6300},{"$f":"J22-N22","v":35700}]
[null,null,null,1,"Forklift and trailer",null,12000,{"$f":"D23*G23","v":12000},{"$f":"H23*$I$7","v":2400},14400,null,null,{"$f":"H23*$M$7","v":1800},{"$f":"J23*$M$7","v":2160},{"$f":"J23-N23","v":12240}]
[null,null,null,null,null,null,"Capital investment import, Sub TOTAL:",{"$f":"SUM(H16:H22)","v":1275000},{"$f":"SUM(I16:I23)","v":257400},{"$f":"SUM(J16:J23)","v":1544400},null,null,{"$f":"SUM(M16:M23)","v":193050},{"$f":"SUM(N16:N23)","v":231660},{"$f":"SUM(O16:O23)","v":1349190}]
[null,null,null,null,null,null," Loan \"A\", EXPORT VALUE, TOTAL:",{"$f":"H12+H24","v":1279500},{"$f":"I12+I24","v":258300},{"$f":"J12+J24","v":1549800},null,null,{"$f":"M12+M24","v":193200},{"$f":"N24","v":231660},{"$f":"O12+O24","v":1354590}]
[]
[null,null,null,null,"LOCAL COUNTRY COSTS \u0086(Loan \"A\")",null,null,null,"VAT","€",null,null,null," Up to 30% of Loan \"A\" ↓ .",{"$f":"O6","v":"Settlement"}]
[null,null,null,null,null,null,{"$f":"G6","v":"Single Prc"},"Local Price",0.2,{"$f":"J6","v":"TOTAL PRICE"},null,"Net values",null,"Net + VAT",{"$f":"O4","v":"2017-06-30"}]
[null,null,"Capital investment",null,null,null,null,{"$f":"SUM(H30:H39)","v":314900},{"$f":"SUM(I30:I39)","v":59500},{"$f":"SUM(J30:J39)","v":374400},null,null,{"$f":"SUM(M30:M39)","v":47235},{"$f":"SUM(N30:N39)","v":50760},{"$f":"SUM(O30:O39)","v":287640}]
["Ø",null,1.5,15000,"Land purchase",null,3.5,{"$f":"D30*G30","v":52500},{"$f":"H30*$I$28","v":10500},{"$f":"H30+I30","v":63000},null,null,{"$f":"H30*$M$7","v":7875},{"$f":"J30*$M$7","v":9450},{"$f":"J30-N30","v":53550}]
[null,null,null,"Building(s) existung on the land"]
[null,null,null,"Building(s), repair and reconstruction"]
[null,null,null,"Infrastructure - road, hedge, water § power supply, sanitation",null,null,null,200000,{"$f":"$I$28*H33","v":40000},{"$f":"H33+I33","v":240000},null,null,{"$f":"H33*$M$7","v":30000},{"$f":"J33*$M$7","v":36000},{"$f":"J33-N33","v":204000}]
["Ø",null,1,"Compost facility",null,null,15000,{"$f":"C34*G34","v":15000},{"$f":"$I$28*H34","v":3000},{"$f":"H34+I34","v":18000},null,null,2250,{"$f":"J34*$M$7","v":2700},15300]
["Ø",null,1,"Motor car",null,null,30000,{"$f":"C35*G35","v":30000},{"$f":"$I$28*H35","v":6000},{"$f":"H35+I35","v":36000},null,null,4500]
["Ø",null,2,"Personal computers",null,null,600,{"$f":"C36*G36","v":1200},0,1200,null,null,180,180,1020]
["Ø",null,1,"Video monitoring online on the site ",null,null,1200,{"$f":"C37*G37","v":1200},0,1200,null,null,180,{"$f":"J37*$M$7","v":180},1020]
[null,null,null,"Office equipment - printer, scanner, monitor, software, etc.",null,null,null,3000,0,3000,null,null,450,450,2550]
[null,null,null,"Other - inventory (scissors for cutting sheet, disinfection courts, etc.)",null,null,null,12000,0,12000,null,null,1800,1800,10200]
["Ø",null,"Financial model package and Online Cash-Flow Control System",null,null,null,null,{"$f":"SUM(H41:H42)","v":175000},{"$f":"SUM(I41:I42)","v":0},{"$f":"SUM(J41:J42)","v":175000},null,null,{"$f":"SUM(M41:M42)","v":26250},{"$f":"SUM(N41:N42)","v":26250},{"$f":"SUM(O41:O42)","v":148750}]
["Ø",null,"Cash-flow budgeting, profitability and sensitivity analysis",null,null,null,null,150000,null,{"$f":"H41+I41","v":150000},null,null,{"$f":"H41*$M$7","v":22500},{"$f":"J41*$M$7","v":22500},{"$f":"J41-N41","v":127500}]
["Ø",null,"Financial risk assessment and predesign risk management",null,null,null,null,25000,null,{"$f":"H42+I42","v":25000},null,null,{"$f":"H42*$M$7","v":3750},{"$f":"J42*$M$7","v":3750},{"$f":"J42-N42","v":21250}]
[null,null,null,null,null,null,"LOCAL COUNTRY COSTS, TOTAL:",{"$f":"ROUNDUP(H29+H40,-3)","v":490000},null,{"$f":"J29+J40","v":549400},null,null,"Loan \"B\"","Loan \"B+\"","   Loan \"A+\""]
[null,null,null,null,"Capital investment value,","Loan \"A\"","   TOTAL:",{"$f":"H24+H43","v":1765000},{"$f":"J43/J44","v":0.26239373388098197},{"$f":"J24+J43","v":2093800},null,null,{"$f":"ROUND(M25+M40,-2)","v":219500},{"$f":"ROUND(N25+N40,-2)","v":257900},{"$f":"ROUND(O25+O29+O40,-2)","v":1791000}]
[null,null,null,null,null,null,null,null,"Loan \"A\" ─  85% of cap. goods and services  (foreing export + up to 30% local costs), TOTAL:",{"$f":"O44","v":1791000},null,null," Loan \"C\":",{"$f":"J14","v":305400}]
[]
[null,"C.",null,null,"SUMMARY OF LOANS",null,"Loans:"," \"A\"","\"B\"","\"C\"",null,null,"Loan\" VAT\"","─ option",{"$f":"I48","v":5.5E-2}]
["Ø",null,null,null,null,null,"Ann. Interest:",0.04,5.5E-2,3.5000000000000003E-2,null,null,{"$f":"M4","v":"2016-12-31"},null,{"$f":"O4","v":"2017-06-30"}]
["Ø",null,{"$f":"F49*H44","v":1765},null,"\u0085 Commitment exposure fee:",1E-3,"Inv. value:",{"$f":"J45","v":1791000},{"$f":"N44","v":257900},{"$f":"N45","v":305400},null,null," KEY NOTES:"]
[null,null,"Insurance",null,"Rate","  DEPRECIATION OF ASSETS",null,null,"TOTAL:",{"$f":"SUM(J52:J56)","v":54450},null,null,"   1. Gradient","Cell",", icons    or    and partial border recipient of first input cash or        "]
["Ø",null,8.0000000000000002E-3,{"$f":"C51*I51","v":9600},0.15,"    up to; for industry equipment",null,null,{"$f":"H16","v":1200000},{"$f":"I51*E51","v":180000},null,null,"          - for % or others, with URLs to data resources.  All the rest represent computed results."]
["Ø",null,null,null,0.04,"    Building ",null,null,0,{"$f":"I52*E52","v":0}]
["Ø",null,null,null,0.5,"    Office equipment",null,null,{"$f":"SUM(H36:H38)","v":5400},{"$f":"E53*I53","v":2700},null,null,"   2. The note    or    forward to Internet sorces."]
["Ø",null,0.09,{"$f":"C54*I54","v":2700},0.25,"    Motor car",null,null,{"$f":"H35","v":30000},{"$f":"E54*I54","v":7500},null,null,"3. Magnifier","  icon provides  interactive links to business dictionaries or other resources."]
["Ø",null,0.04,{"$f":"C55*I55","v":2880},0.25,"    Trucks",null,null,{"$f":"SUM(H21:H23)","v":72000},{"$f":"E55*I55","v":18000},null,null,"4. Info icons","     provides link to aoutor's information sources."]
["Ø",null,null,{"$f":"SUM(D51:D55)","v":15180},0.15,"    Intangible assets (VB operat. plan)",null,null,{"$f":"H40","v":175000},{"$f":"H40*E56","v":26250},null,null,"  Various fonts and background colors represent similar group data resources."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       Go to BUDGET"]
[]
[]
["Ø","Indications of first input-data rows",null,null,null,"↑ This fee is supposed to ECA"]
[null,null,"× Go back to Intro"]

{"sheet":"BUDGET","index":2,"n_rows":130,"n_cols":24,"rows_kept":130,"cut":false,"hidden":false,"merged":[[88,20,88,21],[94,20,94,21],[74,19,74,20],[83,19,83,20],[104,19,104,20],[0,0,1,0],[5,6,5,10],[49,0,51,0],[22,0,22,1],[23,0,23,1],[12,0,13,0],[80,12,81,12],[81,10,81,11],[81,0,81,1],[80,0,80,1],[79,0,79,1],[78,0,78,1],[73,0,74,0],[75,0,75,1],[75,10,75,14],[76,0,76,1],[77,0,77,1],[77,10,77,11],[77,13,77,14],[75,9,76,9],[75,5,76,5],[75,6,75,8],[76,6,76,8]]}
["Level","PRE-DESIGN BACKGROUND.","Sales","2015-07-31","2015-08-31","2015-09-30","2015-10-31","2015-11-30","2015-12-31","2016-01-31","2016-02-28","2016-03-31","2016-04-30","2016-05-31",{"$f":"C13","v":"2016-06-30"},"↓ Earn from",0.1,null," Earn p.а./1 ha "]
[null,"Quantity and value of production.","QTY C  p.m., t",{"$f":"0*A46*100","v":0},{"$f":"$P$2*$Q$2/$Q$1/10","v":13.999999999999995},13.999999999999995,13.999999999999995,13.999999999999995,{"$f":"$P$2*$Q$2/$Q$1/10","v":13.999999999999995},{"$f":"0*A46*100","v":0},13.999999999999995,13.999999999999995,13.999999999999995,{"$f":"$P$2*$Q$2/$Q$1/10","v":13.999999999999995},{"$f":"$P$2*$Q$2/$Q$1/10","v":13.999999999999995},{"$f":"Intro!Q18","v":70},{"$f":"A46","v":0.19999999999999996}]
["  ","Business Plan  - Exhibit A","Income C  p.m.",{"$f":"D2*Intro!$R$18","v":0},{"$f":"E2*Intro!$R$18","v":13299.999999999995},{"$f":"F2*Intro!$R$18","v":13299.999999999995},{"$f":"G2*Intro!$R$18","v":13299.999999999995},{"$f":"H2*Intro!$R$18","v":13299.999999999995},{"$f":"I2*Intro!$R$18","v":13299.999999999995},{"$f":"J2*Intro!$R$18","v":0},{"$f":"K2*Intro!$R$18","v":13299.999999999995},{"$f":"L2*Intro!$R$18","v":13299.999999999995},{"$f":"M2*Intro!$R$18","v":13299.999999999995},{"$f":"N2*Intro!$R$18","v":13299.999999999995},{"$f":"O2*Intro!$R$18","v":13299.999999999995},{"$f":"SUM(D3:O3)","v":132999.99999999997},{"$f":"70*0.2*10000","v":140000},{"$f":"IF(P3=Q3,\"True\",\"False\")","v":"False"}]
[{"$f":"'Cap.Goods'!O44","v":1791000},"\u0086    ECA's Support (Loan \"A\")","QTY T p.m., t",0,0,{"$f":"$P$4*$Q$4/$Q$1/10","v":72},72,72,72,72,72,72,{"$f":"$P$4*$Q$4/$Q$1/10","v":72},{"$f":"$P$4*$Q$4/$Q$1/10","v":72},{"$f":"$P$4*$Q$4/$Q$1/10","v":72},{"$f":"Intro!Q19","v":90},{"$f":"A47","v":0.8}]
[{"$f":"'Cap.Goods'!N44","v":257900},"\u0086    Cash Payment (Loan \"B\")","Income T p.m.",{"$f":"D4*Intro!$R$19","v":0},{"$f":"E4*Intro!$R$19","v":0},{"$f":"F4*Intro!$R$19","v":82080},{"$f":"G4*Intro!$R$19","v":82080},{"$f":"H4*Intro!$R$19","v":82080},{"$f":"I4*Intro!$R$19","v":82080},{"$f":"J4*Intro!$R$19","v":82080},{"$f":"K4*Intro!$R$19","v":82080},{"$f":"L4*Intro!$R$19","v":82080},{"$f":"M4*Intro!$R$19","v":82080},{"$f":"N4*Intro!$R$19","v":82080},{"$f":"O4*Intro!$R$19","v":82080},{"$f":"SUM(D5:O5)","v":820800}]
[null,null,"Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P7:P10)","v":5400}]
[null,null,"Plant material C",{"$f":"$P$7/12","v":49.999999999999993},49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,49.999999999999993,{"$f":"$P$7/12","v":49.999999999999993},{"$f":"'Cap.Goods'!J8","v":599.99999999999989}]
[null,null,"Plant material T",{"$f":"$P$8/12","v":400},400,400,400,400,400,400,400,400,400,400,{"$f":"$P$8/12","v":400},{"$f":"'Cap.Goods'!J9","v":4800}]
[null,null,"Mulching components"]
[null,null," Water-soluble fertilizers",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:O10)","v":0}]
[null,"For export:","Market products",20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,null,null,null,{"$f":"SUM(D11:S11)","v":300000}]
[{"$f":"'Cap.Goods'!J44","v":2093800},"Capital Investment with VAT","Start-up date",6,12,18,24,30,{"$f":"H12+6","v":36},42,48,54,60,66,72,{"$f":"O12+6","v":78},{"$f":"P12+6","v":84},{"$f":"Q12+6","v":90},{"$f":"R12+6","v":96}]
[null,"Date :","2016-06-30","2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","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"]
[null,"End of Period:",null,1,{"$f":"D14+1","v":2},{"$f":"E14+1","v":3},{"$f":"F14+1","v":4},5,6,7,8,9,10,{"$f":"M14+1","v":11},{"$f":"N14+1","v":12},{"$f":"O14+1","v":13},{"$f":"P14+1","v":14},15,{"$f":"R14+1","v":16}]
[null,"Investment,  Loan \"A\"",{"$f":"SUM(D15:F15)","v":1765000},null,{"$f":"'Cap.Goods'!H35","v":30000},{"$f":"'Cap.Goods'!H44-E15","v":1735000}]
[null,"Com. Bank, Own Funds, Loan \"B\"",{"$f":"SUM(D16:F16)","v":257900},null,{"$f":"'Cap.Goods'!N44","v":257900}]
[null,"       Capital Investment:",{"$f":"SUM(D17:F17)","v":2022900},{"$f":"D15+D16","v":0},{"$f":"E15+E16","v":287900},{"$f":"F15+F16","v":1735000}]
[null,"                                              VAT:"]
[{"$f":"'Cap.Goods'!N45","v":305400},"\u0086  Working Capital (Loan\"C\")",{"$f":"A19","v":305400},{"$f":"SUM(G11:I11)","v":60000},{"$f":"SUM(J11:O11)","v":120000},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700},{"$f":"SUM($D$11:$I$11)+$P$6/2","v":122700},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700},{"$f":"SUM($D$11:$I$11)+$P$6/2","v":122700},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700},{"$f":"SUM($D$11:$I$11)+$P$6/2","v":122700},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700},{"$f":"SUM($D$11:$I$11)+$P$6/2","v":122700},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700},{"$f":"SUM($D$11:$I$11)+$P$6/2","v":122700},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700},{"$f":"SUM($D$11:$I$11)+$P$6/2","v":122700},{"$f":"SUM($J$11:$O$11)+$P$6/2","v":122700}]
[" Sales,","Revenue Pro-forma Budget",{"$f":"SUM(D20:P20)","v":6459300},{"$f":"D44","v":0},{"$f":"E44","v":146400},{"$f":"F44","v":146400},{"$f":"G44","v":638880},{"$f":"H44","v":541220},{"$f":"I44","v":705380},541220,705380,541220,{"$f":"M44","v":705380},{"$f":"N44","v":541220},705380,{"$f":"P44","v":541220},{"$f":"Q44","v":705380},{"$f":"R44","v":541220},{"$f":"S44","v":705380}]
["Less:","          Date:",{"$f":"C13","v":"2016-06-30"},"2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","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"]
["Costs,","TOTAL (in €)",{"$f":"SUM(D22:P22)","v":3769397.8078695145},{"$f":"SUM(D23:D25)","v":1765},{"$f":"SUM(E23:E26)","v":27629.591836734693},{"$f":"SUM(F23:F26)","v":168033.5918367347},{"$f":"SUM(G23:G26)","v":332385.8},{"$f":"SUM(H23:H26)","v":336647.7},{"$f":"SUM(I23:I26)","v":383221.7},339002.9,382926.76879999996,341433.46639999998,{"$f":"SUM(M23:M26)","v":385408.79980159999},343941.81092480005,380470.25579525123,{"$f":"SUM(P23:P26)","v":346530.42247439362},{"$f":"SUM(Q23:Q26)","v":384017.46959357423},{"$f":"SUM(R23:R26)","v":349201.86959357426},{"$f":"SUM(S23:S26)","v":389474.40302056854}]
["        Variable costs",null,{"$f":"C54","v":553550},{"$f":"D54","v":0},{"$f":"E54","v":0},125124,269135.8,{"$f":"H54","v":265717.7},273021.7,267276.10000000003,274629.96879999997,268884.3688,276289.70220160001,270544.10220160004,278002.54707205121,272256.94707205123,279770.20297835686,274024.60297835688,281594.42387366423]
["        Fixed costs",null,{"$f":"C64","v":87980},{"$f":"D64","v":1765},{"$f":"E64","v":8279.5918367346931},{"$f":"F64","v":23559.591836734693},36400,{"$f":"H64","v":51580},36400,52376.800000000003,37196.800000000003,53199.097600000001,38019.097600000001,54047.708723200005,38867.708723200005,54923.475402342403,40647.266615217362,55827.266615217362,41579.979146904319]
["        % of sales for marketing and RM",null,{"$f":"C70+C71","v":38700},{"$f":"D70+D71","v":0},{"$f":"E70+E71","v":19350},19350,19350,19350,19350,19350,19350,19350,19350,19350,19350,19350,19350,{"$f":"R70+R71","v":19350},{"$f":"S70+S71","v":19350}]
["        Depreciations (in $)",null,{"$f":"'Cap.Goods'!J50","v":54450},null,null,null,{"$f":"'Cap.Goods'!J54","v":7500},null,{"$f":"$C$26","v":54450},null,{"$f":"$C$26-'Cap.Goods'!$J$53","v":51750},null,{"$f":"$C$26-'Cap.Goods'!$J$53","v":51750},null,{"$f":"$C$26-'Cap.Goods'!$J$53-'Cap.Goods'!$J$54","v":44250},null,{"$f":"$C$26-'Cap.Goods'!$J$53-'Cap.Goods'!$J$54","v":44250},null,{"$f":"$C$26-'Cap.Goods'!$J$54","v":46950}]
[null,"Cash Flows:",null,{"$f":"D20-D22","v":-1765},{"$f":"E20-E22","v":118770.40816326531},{"$f":"F20-F22","v":-21633.591836734704},{"$f":"G20-G22","v":306494.2},{"$f":"H20-H22","v":204572.3},{"$f":"I20-I22","v":322158.3},{"$f":"J20-J22","v":202217.09999999998},322453.23120000004,{"$f":"L20-L22","v":199786.53360000002},{"$f":"M20-M22","v":319971.20019840001},197278.18907519995,324909.74420474877,{"$f":"P20-P22","v":194689.57752560638},{"$f":"Q20-Q22","v":321362.53040642577},{"$f":"R20-R22","v":192018.13040642574},{"$f":"S20-S22","v":315905.59697943146}]
["Less:","Interests Loans \"A\"+\"B\"",null,{"$f":"D88+D94","v":0},{"$f":"E88+E94","v":7092.25},{"$f":"F88+F94","v":13989.463125},{"$f":"G88+G94","v":41213},{"$f":"H88+H94","v":37826},31808,{"$f":"J88+J94","v":26266},21249,16750,12768,9305,6365,3958,2096,799,91]
[null,"EBT",null,{"$f":"D27-D28","v":-1765},{"$f":"E27-E28","v":111678.15816326531},{"$f":"F27-F28","v":-35623.054961734706},{"$f":"G27-G28","v":265281.2},{"$f":"H27-H28","v":166746.29999999999},{"$f":"I27-I28","v":290350.3},{"$f":"J27-J28","v":175951.09999999998},{"$f":"K27-K28","v":301204.23120000004},183036.53360000002,{"$f":"M27-M28","v":307203.20019840001},187973.18907519995,318544.74420474877,{"$f":"P27-P28","v":190731.57752560638},{"$f":"Q27-Q28","v":319266.53040642577},{"$f":"R27-R28","v":191219.13040642574},{"$f":"S27-S28","v":315814.59697943146}]
["Less:","Income tax",0.1,null,{"$f":"$C$30*D29","v":-176.5},null,{"$f":"$C$30*(E29+F29)","v":7605.5103201530619},null,{"$f":"$C$30*(G29+H29)","v":43202.75},null,{"$f":"$C$30*(I29+J29)","v":46630.14},null,{"$f":"$C$30*(K29+L29)","v":48424.076480000011},null,{"$f":"$C$30*(M29+N29)","v":49517.63892736},null,{"$f":"$C$30*(O29+P29)","v":50927.632173035519},null,{"$f":"$C$30*(Q29+R29)","v":51048.566081285157}]
[null,"Advance deposit"]
[null,"EAT",{"$f":"SUM(D32:P32)","v":2266108.8632779727},{"$f":"D29-D30-D31","v":-1765},{"$f":"E29-E30-E31","v":111854.65816326531},{"$f":"F29-F30-F31","v":-35623.054961734706},{"$f":"G29-G30-G31","v":257675.68967984695},{"$f":"H29-H30-H31","v":166746.29999999999},{"$f":"I29-I30-I31","v":247147.55},{"$f":"J29-J30-J31","v":175951.09999999998},254574.09120000002,183036.53360000002,{"$f":"M29-M30-M31","v":258779.12371839999},187973.18907519995,269027.10527738876,190731.57752560638,268338.89823339024,191219.13040642574,264766.03089814633]
["Add:","Total depreciations",null,null,{"$f":"E26","v":0},null,{"$f":"G26","v":7500},null,{"$f":"I26","v":54450},null,{"$f":"K26","v":51750},null,{"$f":"M26","v":51750},null,{"$f":"O26","v":44250},null,{"$f":"Q26","v":44250}]
["Add:","Tax advance deposited"]
["►"," Operating Cash Flows",{"$f":"SUM(D35:P35)","v":2475808.8632779727},{"$f":"SUM(D32:D34)","v":-1765},{"$f":"SUM(E32:E34)","v":111854.65816326531},{"$f":"SUM(F32:F34)","v":-35623.054961734706},{"$f":"SUM(G32:G34)","v":265175.68967984698},{"$f":"SUM(H32:H34)","v":166746.29999999999},{"$f":"SUM(I32:I34)","v":301597.55},175951.09999999998,306324.09120000002,183036.53360000002,{"$f":"SUM(M32:M34)","v":310529.12371840002},187973.18907519995,313277.10527738876,{"$f":"SUM(P32:P34)","v":190731.57752560638},{"$f":"SUM(Q32:Q34)","v":312588.89823339024},{"$f":"SUM(R32:R34)","v":191219.13040642574},{"$f":"SUM(S32:S34)","v":264766.03089814633}]
["Less:",null,null,{"$f":"-D17","v":0},-287900,{"$f":"-F17","v":-1735000}]
["►    (NCFs)","Project's Net Cash Flows",{"$f":"SUM(D37:P37)","v":452908.86327797268},{"$f":"SUM(D35:D36)","v":-1765},{"$f":"SUM(E35:E36)","v":-176045.34183673467},{"$f":"SUM(F35:F36)","v":-1770623.0549617347},{"$f":"SUM(G35:G36)","v":265175.68967984698},{"$f":"SUM(H35:H36)","v":166746.29999999999},{"$f":"SUM(I35:I36)","v":301597.55},{"$f":"SUM(J35:J36)","v":175951.09999999998},306324.09120000002,183036.53360000002,310529.12371840002,187973.18907519995,313277.10527738876,{"$f":"SUM(P35:P36)","v":190731.57752560638},{"$f":"SUM(Q35:Q36)","v":312588.89823339024},{"$f":"SUM(R35:R36)","v":191219.13040642574},{"$f":"SUM(S35:S36)","v":264766.03089814633}]
["Less:","Principal Loans (A+B) installments",null,{"$f":"-(D89+D95+D100)","v":0},{"$f":"-(E89+E95+E100)","v":0},{"$f":"-(F89+F95)","v":0},-137001,-139866,-142793,-145782,-148834,-151950,-155134,-158384,-161704,-165095,{"$f":"-(Q89+Q95)","v":-168557},{"$f":"-(R89+R95)","v":-172094},{"$f":"-(S89+S95)","v":-175704},null,null,{"$f":"SUM(D38:P38)","v":-1506543}]
[null,"Cash",null,{"$f":"SUM(D37:D38)","v":-1765},{"$f":"SUM(E37:E38)","v":-176045.34183673467},{"$f":"SUM(F37:F38)","v":-1770623.0549617347},128174.68967984698,{"$f":"SUM(H37:H38)","v":26880.299999999988},{"$f":"SUM(I37:I38)","v":158804.54999999999},30169.099999999977,157490.09120000002,{"$f":"SUM(L37:L38)","v":31086.533600000024},155395.12371840002,29589.189075199945,151573.10527738876,{"$f":"SUM(P37:P38)","v":25636.577525606379},{"$f":"SUM(Q37:Q38)","v":144031.89823339024},{"$f":"SUM(R37:R38)","v":19125.130406425742},{"$f":"SUM(S37:S38)","v":89062.030898146331}]
["Cumulative NCFs (loan pay-off incl.)",null,null,{"$f":"D39","v":-1765},{"$f":"D40+E39","v":-177810.34183673467},{"$f":"E40+F39","v":-1948433.3967984694},{"$f":"F40+G39","v":-1820258.7071186225},{"$f":"G40+H39","v":-1793378.4071186224},{"$f":"H40+I39","v":-1634573.8571186224},{"$f":"I40+J39","v":-1604404.7571186223},{"$f":"J40+K39","v":-1446914.6659186222},-1415828.1323186222,-1260433.0086002222,-1230843.8195250223,{"$f":"N40+O39","v":-1079270.7142476335},{"$f":"O40+P39","v":-1053634.1367220271},{"$f":"P40+Q39","v":-909602.23848863691},{"$f":"Q40+R39","v":-890477.10808221111},{"$f":"R40+S39","v":-801415.07718406478}]
[]
[]
["Planning,ann.","Income data                             Date :","Calendar Year",{"$f":"D13","v":"2016-12-31"},"2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31",{"$f":"S21","v":"2024-06-30"}]
["Planted area","      Sales         Selected year <+>",1246600,{"$f":"D45+D49","v":0},{"$f":"E45+E49","v":146400},{"$f":"F45+F49","v":146400},{"$f":"G45+G49","v":638880},{"$f":"H45+H49","v":541220},{"$f":"I45+I49","v":705380},{"$f":"J45+J49","v":541220},705380,541220,{"$f":"M45+M49","v":705380},541220,{"$f":"O45+O49","v":705380},541220,{"$f":"Q45+Q49","v":705380},{"$f":"R45+R49","v":541220},{"$f":"S45+S49","v":705380}]
[{"$f":"'Cap.Goods'!C16","v":1},"● Greenhouse own production",953800,{"$f":"SUM(D46:D48)","v":0},{"$f":"SUM(E46:E48)","v":0},{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":492480},{"$f":"SUM(H46:H48)","v":394820},{"$f":"SUM(I46:I48)","v":558980},{"$f":"SUM(J46:J48)","v":394820},{"$f":"SUM(K46:K48)","v":558980},{"$f":"SUM(L46:L48)","v":394820},{"$f":"SUM(M46:M48)","v":558980},{"$f":"SUM(N46:N48)","v":394820},{"$f":"SUM(O46:O48)","v":558980},{"$f":"SUM(P46:P48)","v":394820},{"$f":"SUM(Q46:Q48)","v":558980},{"$f":"SUM(R46:R48)","v":394820},{"$f":"SUM(S46:S48)","v":558980}]
[{"$f":"A45-A47","v":0.19999999999999996},"    • Cucumbers",132999.99999999994,0,0,0,0,{"$f":"D3+E3+F3+G3+H3+I3","v":66499.999999999971},{"$f":"J3+K3+L3+M3+N3+O3","v":66499.999999999971},{"$f":"D3+E3+F3+G3+H3+I3","v":66499.999999999971},{"$f":"J3+K3+L3+M3+N3+O3","v":66499.999999999971},{"$f":"D3+E3+F3+G3+H3+I3","v":66499.999999999971},{"$f":"J3+K3+L3+M3+N3+O3","v":66499.999999999971},{"$f":"D3+E3+F3+G3+H3+I3","v":66499.999999999971},{"$f":"J3+K3+L3+M3+N3+O3","v":66499.999999999971},{"$f":"D3+E3+F3+G3+H3+I3","v":66499.999999999971},{"$f":"J3+K3+L3+M3+N3+O3","v":66499.999999999971},{"$f":"D3+E3+F3+G3+H3+I3","v":66499.999999999971},{"$f":"J3+K3+L3+M3+N3+O3","v":66499.999999999971}]
[0.8,"    • Tomatoes",820800,0,0,0,{"$f":"J5+K5+L5+M5+N5+O5","v":492480},{"$f":"D5+E5+F5+G5+H5+I5","v":328320},{"$f":"J5+K5+L5+M5+N5+O5","v":492480},{"$f":"D5+E5+F5+G5+H5+I5","v":328320},{"$f":"J5+K5+L5+M5+N5+O5","v":492480},{"$f":"D5+E5+F5+G5+H5+I5","v":328320},{"$f":"J5+K5+L5+M5+N5+O5","v":492480},{"$f":"D5+E5+F5+G5+H5+I5","v":328320},{"$f":"J5+K5+L5+M5+N5+O5","v":492480},{"$f":"D5+E5+F5+G5+H5+I5","v":328320},{"$f":"J5+K5+L5+M5+N5+O5","v":492480},{"$f":"D5+E5+F5+G5+H5+I5","v":328320},{"$f":"J5+K5+L5+M5+N5+O5","v":492480}]
[null,"    • By-products",0]
[0.22,"○ Vegitables from the market",{"$f":"SUM(D49:P49)","v":1756800},0,{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400},{"$f":"SUM($D$11:$I$11)*(1+$A$49)","v":146400},{"$f":"SUM($J$11:$O$11)*(1+$A$49)","v":146400}]
["Rows right- for monitoring & management ","    ◦ Cucumbers"]
[null,"    ◦ Tomatoes"]
[null,"    ◦ Others"]
[null,"Income data (in €), EU Zone   Date :",{"$f":"C13","v":"2016-06-30"},"2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31",{"$f":"S21","v":"2024-06-30"}]
[null,"      Variable costs ",{"$f":"SUM(C55:C62)","v":553550},{"$f":"SUM(D55:D62)","v":0},{"$f":"SUM(E55:E62)","v":0},125124,269135.8,{"$f":"SUM(H55:H62)","v":265717.7},273021.7,267276.10000000003,274629.96879999997,268884.3688,276289.70220160001,270544.10220160004,278002.54707205121,{"$f":"SUM(P55:P62)","v":272256.94707205123},{"$f":"SUM(Q55:Q62)","v":279770.20297835686},{"$f":"SUM(R55:R62)","v":274024.60297835688},{"$f":"SUM(S55:S62)","v":281594.42387366423}]
["Included ↘","Seedlings, including ↘",{"$f":"P7+P8","v":5400},0,0,0,{"$f":"$C$55/2","v":2700},{"$f":"$C$55/2","v":2700},2700,2700,2700,2700,2700,2700,2700,2700,2700,2700,2700]
[null,"Mulching components and fertilizers",null,0,0,0,{"$f":"$C$56/2","v":0},{"$f":"$C$56/2","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Local market vegitables",{"$f":"V11","v":300000},null,0,{"$f":"SUM($M$11:$O$11)+SUM($D$11:$F$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($M$11:$O$11)+SUM($D$11:$F$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($M$11:$O$11)+SUM($D$11:$F$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($M$11:$O$11)+SUM($D$11:$F$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($M$11:$O$11)+SUM($D$11:$F$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($M$11:$O$11)+SUM($D$11:$F$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000},{"$f":"SUM($J$11:$L$11)+SUM($G$11:$I$11)","v":120000}]
[3.5000000000000003E-2,"Packing, transport, indirect costs",null,{"$f":"$A$58*D44","v":0},0,{"$f":"$A$58*F44","v":5124.0000000000009},22360.800000000003,18942.7,24688.300000000003,18942.7,24688.300000000003,18942.7,24688.300000000003,18942.7,24688.300000000003,18942.7,{"$f":"$A$58*Q44","v":24688.300000000003},{"$f":"$A$58*R44","v":18942.7},{"$f":"$A$58*S44","v":24688.300000000003}]
[null,"Electric power - greenhose ",25000,null,null,{"$f":"D59","v":0},{"$f":"$C$59/2","v":12500},{"$f":"$C$59/2","v":12500},12500,12500,12500,12500,12500,12500,12500,12500,{"$f":"$C$59/2","v":12500},12500,12500]
[245000,"\u0086\u0086 \u0086 Gas for greenhouse heating",{"$f":"A60*A61","v":85750},0,0,0,{"$f":"$C$60/2","v":42875},{"$f":"$C$60/2","v":42875},42875,42875,42875,42875,42875,42875,42875,42875,42875,42875,42875]
[0.35,"Other materials and services",40000,null,null,null,{"$f":"$C61/2","v":20000},{"$f":"$C61/2","v":20000},{"$f":"$C61/2","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[3.2000000000000001E-2,"   Payroll, production staff",{"$f":"ROUND(Staff!H24*2,-2)","v":97400},0,{"$f":"$D$62","v":0},0,{"$f":"$C$62/2","v":48700},{"$f":"$C$62/2","v":48700},{"$f":"$H$62*(1+$A$62)","v":50258.400000000001},{"$f":"$H$62*(1+$A$62)","v":50258.400000000001},{"$f":"$I$62*(1+$A$62)","v":51866.668799999999},{"$f":"$I$62*(1+$A$62)","v":51866.668799999999},{"$f":"$K$62*(1+$A$62)","v":53526.402201600002},{"$f":"$L$62*(1+$A$62)","v":53526.402201600002},{"$f":"$M$62*(1+$A$62)","v":55239.247072051206},{"$f":"$N$62*(1+$A$62)","v":55239.247072051206},{"$f":"$O$62*(1+$A$62)","v":57006.902978356848},{"$f":"$O$62*(1+$A$62)","v":57006.902978356848},{"$f":"$Q$62*(1+$A$62)","v":58831.12387366427}]
[null,"Income Data:                           Date :","Planning, ann.",{"$f":"C13","v":"2016-06-30"},"2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30",{"$f":"Q13","v":"2023-06-30"},{"$f":"R13","v":"2023-12-31"},{"$f":"S21","v":"2024-06-30"}]
[{"$f":"'Cap.Goods'!C49","v":1765},"      Fixed costs              p.a.",{"$f":"SUM(C65:C69)","v":87980},{"$f":"A64+SUM(D65:D69)","v":1765},{"$f":"SUM(E65:E69)","v":8279.5918367346931},23559.591836734693,36400,51580,36400,52376.800000000003,37196.800000000003,53199.097600000001,38019.097600000001,54047.708723200005,38867.708723200005,54923.475402342403,40647.266615217362,55827.266615217362,41579.979146904319]
[0.01,"Office - phones, stationeries, power",4000,null,300,400,{"$f":"$C$65/2","v":2000},{"$f":"$C$65/2","v":2000},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000]
[null,"Cars - fuel and maintenance ",10000,0,1000,{"$f":"E66","v":1000},{"$f":"$C$66/2","v":5000},{"$f":"$C$66/2","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000]
[null,"Online control system and RM fee",9000,0,3000,3000,{"$f":"$C$67/2","v":4500},{"$f":"$C$67/2","v":4500},{"$f":"$C$67/2","v":4500},4500,4500,4500,4500,4500,4500,4500,4500,4500,4500]
[3.2000000000000001E-2,"   Payroll, administrative personnel",{"$f":"ROUND(Staff!H18*2,-2)","v":49800},null,{"$f":"Staff!$H$8","v":3979.591836734694},{"$f":"Staff!$H$8","v":3979.591836734694},{"$f":"$C$68/2","v":24900},{"$f":"$C$68/2","v":24900},{"$f":"$C$68/2","v":24900},{"$f":"$G$68*(1+$A$68)","v":25696.799999999999},{"$f":"$G$68*(1+$A$68)","v":25696.799999999999},{"$f":"$K$68*(1+$A$68)","v":26519.097600000001},{"$f":"$K$68*(1+$A$68)","v":26519.097600000001},{"$f":"$M$68*(1+$A$68)","v":27367.708723200001},{"$f":"$M$68*(1+$A$68)","v":27367.708723200001},{"$f":"$O$68*(1+$A$68)","v":28243.475402342403},{"$f":"$P$68*(1+$A$68)","v":29147.266615217362},{"$f":"$P$68*(1+$A$68)","v":29147.266615217362},{"$f":"$Q$68*(1+$A$68)","v":30079.979146904319}]
[null,"Insurance - building, products, cars",{"$f":"'Cap.Goods'!D56","v":15180},null,null,{"$f":"C69","v":15180},null,{"$f":"C69","v":15180},null,{"$f":"H69","v":15180},null,{"$f":"J69","v":15180},null,{"$f":"L69","v":15180},null,{"$f":"N69","v":15180},null,{"$f":"P69","v":15180}]
[2E-3," of sales  - IT and RA consultant",{"$f":"ROUND(A70*$C$20,-2)","v":12900},null,{"$f":"$C$70/2","v":6450},6450,{"$f":"$C$70/2","v":6450},{"$f":"$C$70/2","v":6450},6450,6450,6450,6450,6450,6450,6450,6450,6450,6450,6450]
[4.0000000000000001E-3,"of sales - marketing, exhibitions",{"$f":"ROUND(A71*$C$20,-2)","v":25800},null,{"$f":"$C$71/2","v":12900},12900,12900,12900,12900,12900,12900,12900,12900,12900,12900,12900,12900,12900,12900]
[]
[]
["Level","PROFITABILITY ANALYSIS","Years:",null,null,1,{"$f":"F74+1","v":2},3,4,5,6,7]
[null,"1-Yr period Operating Cash Flows",null,"Up front investment:",{"$f":"-C17","v":-2022900},{"$f":"G37+H37","v":431921.98967984697},{"$f":"I37+J37","v":477548.64999999997},{"$f":"K37+L37","v":489360.62480000005},{"$f":"M37+N37","v":498502.31279359997},{"$f":"O37+P37","v":504008.68280299514},{"$f":"Q37+R37","v":503808.02863981598},{"$f":"S37","v":264766.03089814633},null,null,null,null,null,null,null,"up"]
["Discount Cash Flow Models",null,null,null,null,"Level","Default Risk Management",null,null,null,"Operational Risk Management"]
["Section MEASURING PROFITABILITY",null,null,null,null,null,"Section",null,null,null,null,null,"Section \"SENSITIVITY ANALYSIS\""]
[null,null,null,null,null,null,null,"PAYBACK PERIOD",null,null,"Simulation of Good Quality",null,"Fodders","Simulation of Bed Quality"]
["Discount (hurdle) rate :",null,7.4999999999999997E-2,"Loan Life Coverage Ratio:",null,null,null,"METHOD",null,null,"Made in U.S.A. \u0080  .",null," from import","From local country \u0080."]
["Net Present Value (NPV for CADS) :",null,{"$f":"NPV(C79,E75:L75)","v":368772.05399736355},"LLCR=",{"$f":"C80/C89","v":0.20893600793051759},null,"Period:",{"$f":"G86+ROUNDDOWN(F129,0)","v":6},{"$f":"I129","v":0},null,null,100,0.65,59]
["IRR :",null,{"$f":"IRR(E75:L75)","v":0.13102276250636602},7.4999999999999997E-2,null,null,"Date:",{"$f":"D129","v":"2021-12-31"},"earliness",null,null,null,"Area of critical announcements"]
[null,null,null,null,null,null,null,"Accelerated amortization of loans"]
["       .pdf Business plan",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N80>102,L80>80),\" STOP! You've just entered a field of dream!\",\"\")","v":""}]
[null,{"$f":"B13","v":"Date :"},"2016-06-30","2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31",null,"up"]
[null,"LOANS               Number of Periods:",{"$f":"C12","v":"Start-up date"},6,12,18,24,30,36,42,48,54,60,66,72,78,null,{"$f":"R12","v":90}]
[6," Number of repayment periods  ",{"$f":"MATCH(50,G86:S86)","v":13},null,null,null,{"$f":"D14","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
["∑6"," Loan \"A\", Balance liabilities",null,{"$f":"D15","v":0},{"$f":"E15+D87-D90","v":30000},{"$f":"F15+E87-E90","v":1735000},{"$f":"G15+F87-F90","v":1735000},{"$f":"H15+G87-G90","v":1580071},{"$f":"I15+H87-H90","v":1425102},1272763,1122615,974166,826931,680423,534155,387636,240366,91838,-58474]
[{"$f":"SUM(D88:P88)","v":178162}," Interest payments",{"$f":"'Cap.Goods'!H48","v":0.04},null,null,null,{"$f":"-ROUND(IPMT($C$88/2,G86,$C$86,F87),0)","v":34700},{"$f":"-ROUND(IPMT($C$88/2,H86,$C$86,G87),0)","v":32336},{"$f":"-ROUND(IPMT($C$88/2,I86,$C$86,H87),0)","v":27253},22560,18309,14493,11111,8163,{"$f":"-ROUND(IPMT($C$88/2,O86,$C$86,N87),0)","v":5652},3585,{"$f":"-ROUND(IPMT($C$88/2,Q86,$C$86,P87),0)","v":1970},{"$f":"-ROUND(IPMT($C$88/2,R86,$C$86,Q87),0)","v":822},{"$f":"-ROUND(IPMT($C$88/2,S86,$C$86,R87),0)","v":159}]
[{"$f":"ROUND(SUM(D89:S89),-1)","v":1765000}," Principal installments",{"$f":"C15","v":1765000},null,null,null,{"$f":"-ROUND(PPMT($C$88/2,G86,$C$86,$C$89),0)","v":120229},{"$f":"-ROUND(PPMT($C$88/2,H86,$C$86,$C$89),0)","v":122633},{"$f":"-ROUND(PPMT($C$88/2,I86,$C$86,$C$89),0)","v":125086},{"$f":"-ROUND(PPMT($C$88/2,J86,$C$86,$C$89),0)","v":127588},130140,132742,135397,138105,{"$f":"-ROUND(PPMT($C$88/2,O86,$C$86,$C$89),0)","v":140867},{"$f":"-ROUND(PPMT($C$88/2,P86,$C$86,$C$89),0)","v":143685},{"$f":"-ROUND(PPMT($C$88/2,Q86,$C$86,$C$89),0)","v":146558},{"$f":"-ROUND(PPMT($C$88/2,R86,$C$86,$C$89),0)","v":149490},{"$f":"-ROUND(PPMT($C$88/2,S86,$C$86,$C$89),0)","v":152479},null,{"$f":"IF(A89=C89,TRUE,FALSE)","v":true}]
[null,"Installments, TOTAL:",null,{"$f":"SUM(D87:D89)","v":0},30000,{"$f":"SUM(F88:F89)","v":0},{"$f":"SUM(G88:G89)","v":154929},{"$f":"SUM(H88:H89)","v":154969},152339,150148,148449,{"$f":"SUM(L88:L89)","v":147235},146508,146268,146519,{"$f":"SUM(P88:P89)","v":147270},{"$f":"SUM(Q88:Q89)","v":148528},{"$f":"SUM(R88:R89)","v":150312},{"$f":"SUM(S88:S89)","v":152638}]
[]
[6," Number of repayment periods  ",{"$f":"MATCH(50,G92:S92)","v":13},null,null,null,{"$f":"D14","v":1},2,3,4,5,6,7,8,9,10,{"$f":"N14","v":11},12,13,null,null,null,null,"Gheck"]
["∑6"," Loan \"B\", Balance liabilities",null,null,{"$f":"E16","v":257900},{"$f":"E18+E93-E96","v":250807.75},{"$f":"F18+F93-F96","v":236818.28687499999},{"$f":"G18+G93-G96","v":213533.28687499999},{"$f":"H18+H93-H96","v":190810.28687499999},168548.28687499999,146648.28687499999,125014.28687499999,103549.28687499999,82155.286874999991,60734.286874999991,39184.286874999991,17401.286874999991,-4723.7131250000093,-27304.713125000009]
[{"$f":"SUM(D94:P94)","v":50427.713125000002}," Interest payments",{"$f":"'Cap.Goods'!I48","v":5.5E-2},null,{"$f":"C94/2*E93","v":7092.25},{"$f":"C94/2*(E93+F93)","v":13989.463125},{"$f":"-ROUND(IPMT($C$94/2,G92,$C$92,G93),0)","v":6513},{"$f":"-ROUND(IPMT($C$94/2,H92,$C$92,H93),0)","v":5490},{"$f":"-ROUND(IPMT($C$94/2,I92,$C$92,I93),0)","v":4555},3706,2940,2257,1657,1142,{"$f":"-ROUND(IPMT($C$94/2,O92,$C$92,O93),0)","v":713},{"$f":"-ROUND(IPMT($C$94/2,P92,$C$92,P93),0)","v":373},{"$f":"-ROUND(IPMT($C$94/2,Q92,$C$92,Q93),0)","v":126},-23,-68]
[{"$f":"ROUND(SUM(D95:S95),-1)","v":257900}," Principal installments",{"$f":"C16","v":257900},null,0,0,{"$f":"-ROUND(PPMT($C$94/2,G92,$C$92,$C$95),0)","v":16772},{"$f":"-ROUND(PPMT($C$94/2,H92,$C$92,$C$95),0)","v":17233},{"$f":"-ROUND(PPMT($C$94/2,I92,$C$92,$C$95),0)","v":17707},{"$f":"-ROUND(PPMT($C$94/2,J92,$C$92,$C$95),0)","v":18194},{"$f":"-ROUND(PPMT($C$94/2,K92,$C$92,$C$95),0)","v":18694},19208,19737,20279,20837,{"$f":"-ROUND(PPMT($C$94/2,P92,$C$92,$C$95),0)","v":21410},{"$f":"-ROUND(PPMT($C$94/2,Q92,$C$92,$C$95),0)","v":21999},22604,{"$f":"-ROUND(PPMT($C$94/2,S92,$C$92,$C$95),0)","v":23225},null,{"$f":"IF(A95=C95,TRUE,FALSE)","v":true}]
[null,"Installments, TOTAL:",null,{"$f":"SUM(D93:D95)","v":0},{"$f":"SUM(E94:E95)","v":7092.25},{"$f":"SUM(F94:F95)","v":13989.463125},{"$f":"SUM(G94:G95)","v":23285},{"$f":"SUM(H94:H95)","v":22723},22262,21900,21634,21465,21394,21421,21550,{"$f":"SUM(P94:P95)","v":21783},{"$f":"SUM(Q94:Q95)","v":22125},{"$f":"SUM(R94:R95)","v":22581},{"$f":"SUM(S94:S95)","v":23157}]
[]
[null," Loan \"C\", Balance liabilities",null,null,{"$f":"$V$11/2","v":150000},{"$f":"$V$11/2","v":150000},{"$f":"$V$11/2","v":150000},{"$f":"$V$11/2","v":150000},150000,150000,150000,150000,150000,150000,{"$f":"$V$11/2","v":150000},{"$f":"$V$11/2","v":150000},150000,150000,150000]
[null," Interest payments",{"$f":"'Cap.Goods'!J48","v":3.5000000000000003E-2},null,{"$f":"C99/2*SUM(J11:O11)","v":2100},{"$f":"C99/2*SUM(D11:I11)","v":2100},{"$f":"C99/2*SUM(J11:O11)","v":2100},{"$f":"C99/2*SUM(D11:I11)","v":2100},{"$f":"C99/2*SUM(J11:O11)","v":2100},{"$f":"C99/2*(SUM(D7:I7)+SUM(D8:I8)+SUM(D9:I9)+SUM(D10:I10)+SUM(D11:I11))","v":2147.25},{"$f":"C99/2*(SUM(J7:O7)+SUM(J8:O8)+SUM(J9:O9)+SUM(J10:O10)+SUM(J11:O11))","v":2147.25},{"$f":"C99/2*(SUM(D7:I7)+SUM(D8:I8)+SUM(D9:I9)+SUM(D10:I10)+SUM(D11:I11))","v":2147.25},{"$f":"C99/2*(SUM(J7:O7)+SUM(J8:O8)+SUM(J9:O9)+SUM(J10:O10)+SUM(J11:O11))","v":2147.25},{"$f":"C99/2*(SUM(D7:I7)+SUM(D8:I8)+SUM(D9:I9)+SUM(D10:I10)+SUM(D11:I11))","v":2147.25},{"$f":"C99/2*(SUM(J7:O7)+SUM(J8:O8)+SUM(J9:O9)+SUM(J10:O10)+SUM(J11:O11))","v":2147.25},{"$f":"C99/2*(SUM(D7:I7)+SUM(D8:I8)+SUM(D9:I9)+SUM(D10:I10)+SUM(D11:I11))","v":2147.25},{"$f":"C99/2*(SUM(J7:O7)+SUM(J8:O8)+SUM(J9:O9)+SUM(J10:O10)+SUM(J11:O11))","v":2147.25},{"$f":"C99/2*(SUM(D7:I7)+SUM(D8:I8)+SUM(D9:I9)+SUM(D10:I10)+SUM(D11:I11))","v":2147.25},{"$f":"C99/2*(SUM(J7:O7)+SUM(J8:O8)+SUM(J9:O9)+SUM(J10:O10)+SUM(J11:O11))","v":2147.25}]
[null," Principal deferred payments",{"$f":"'Cap.Goods'!N45","v":305400},null,null,{"$f":"E98","v":150000},{"$f":"F98","v":150000},{"$f":"G98","v":150000},{"$f":"H98","v":150000},{"$f":"I98","v":150000},150000,150000,150000,150000,150000,{"$f":"O98","v":150000},{"$f":"P98","v":150000},150000,{"$f":"R98","v":150000}]
[null,"Installments, TOTAL:",null,null,{"$f":"SUM(E99:E100)","v":2100},{"$f":"SUM(F99:F100)","v":152100},{"$f":"SUM(G99:G100)","v":152100},152100,152100,152147.25,152147.25,152147.25,152147.25,152147.25,{"$f":"SUM(O99:O100)","v":152147.25},{"$f":"SUM(P99:P100)","v":152147.25}]
[]
[null,"GRAPHS",null,1,{"$f":"D103+1","v":2},{"$f":"E103+1","v":3},4,5,6,7,8,9,10,11,12,{"$f":"O103+1","v":13},{"$f":"P103+1","v":14},15]
[null,"Total balance liabilities,  Loan \"A\"",null,{"$f":"D87","v":0},30000,{"$f":"F87","v":1735000},{"$f":"G87","v":1735000},{"$f":"H87","v":1580071},1425102,1272763,1122615,974166,826931,680423,534155,387636,240366,91838]
[null,"Total balance liabilities \"A\"+\"B\"",null,{"$f":"D87+D93","v":0},{"$f":"E87+E93","v":287900},{"$f":"F87+F93","v":1985807.75},{"$f":"G87+G93","v":1971818.286875},1793604.286875,{"$f":"I87+I93","v":1615912.286875},1441311.286875,1269263.286875,1099180.286875,930480.28687499999,762578.28687499999,{"$f":"O87+O93","v":594889.28687499999},{"$f":"P87+P93","v":426820.28687499999},{"$f":"Q87+Q93","v":257767.28687499999},87114.286874999991,null,"up"]
[null,"Cash",null,{"$f":"D39","v":-1765},-176045.34183673467,{"$f":"F39","v":-1770623.0549617347},{"$f":"G39","v":128174.68967984698},26880.299999999988,158804.54999999999,30169.099999999977,157490.09120000002,31086.533600000024,155395.12371840002,29589.189075199945,151573.10527738876,25636.577525606379,144031.89823339024,19125.130406425742]
[null,"Cash Cumulative",null,{"$f":"D106","v":-1765},{"$f":"D107+E106","v":-177810.34183673467},{"$f":"E107+F106","v":-1948433.3967984694},{"$f":"F107+G106","v":-1820258.7071186225},{"$f":"G107+H106","v":-1793378.4071186224},-1634573.8571186224,-1604404.7571186223,-1446914.6659186222,-1415828.1323186222,-1260433.0086002222,-1230843.8195250223,-1079270.7142476335,{"$f":"O107+P106","v":-1053634.1367220271},{"$f":"P107+Q106","v":-909602.23848863691},-890477.10808221111]
[null,"Operating cash cumulative",null,{"$f":"D128","v":-1765},110089.65816326531,74466.603201530612,339642.29288137762,506388.59288137761,807986.1428813776,983937.24288137758,1290261.3340813776,1473297.8676813776,1783826.9913997776,1971800.1804749775,2285077.2857523663,2475808.8632779727,2788397.7615113631,2979616.8919177889]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Debt Rate",{"$f":"D105/$C$17","v":0},0.14232043106431361,0.98166382421276388,0.97474827568095312,0.88665000092688717,0.79880977155321564,0.71249754652973452,{"$f":"K105/$C$17","v":0.62744737103910231},{"$f":"L105/$C$17","v":0.54336857327351817},0.45997344746403679,0.37697280482228485,0.29407745655988926,0.21099425917000345,0.12742463140787977,4.3064059951060357E-2]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$A$12","v":2093800}]
[null,"Auxiliary raws: Crossing point of cash and debt",null,null,"Nr of 6-Mo periods:",1,{"$f":"F127+1","v":2},{"$f":"G127+1","v":3},4,5,6,7,8,9,10,{"$f":"O127+1","v":11},{"$f":"P127+1","v":12},13]
[null,"Payback   >   cumulate OCFs",{"$f":"MATCH(C126,E128:O128)","v":10},{"$f":"D35","v":-1765},{"$f":"D128+E35","v":110089.65816326531},74466.603201530612,339642.29288137762,506388.59288137761,807986.1428813776,983937.24288137758,1290261.3340813776,1473297.8676813776,1783826.9913997776,1971800.1804749775,2285077.2857523663,2475808.8632779727,2788397.7615113631,2979616.8919177889]
[null,"repayment estimation row",null,{"$f":"CHOOSE(C128,E84,F84,G84,H84,I84,J84,K84,L84,M84,N84,O84,P84)","v":"2021-12-31"},{"$f":"C128*6","v":60},{"$f":"E129/12","v":5},{"$f":"ROUNDUP(F129,0)","v":5},{"$f":"G129-F129","v":0},{"$f":"H129*12","v":0}]
[null,"auxiliary row",null,null,{"$f":"(D129-E84)/12","v":137.08333333333334},{"$f":"ROUNDDOWN(E130,0)","v":137},{"$f":"E130-F130","v":8.3333333333342807E-2},{"$f":"G130*12","v":1.0000000000001137},{"$f":"IF(H130=12,F130+1,F130)","v":137},{"$f":"IF(H130=12,0,H130)","v":1.0000000000001137}]

{"sheet":"Bayes","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,49,0],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,7,44,15],[44,1,44,2],[44,5,44,6],[45,1,45,2],[39,1,41,15],[15,6,15,8],[15,13,15,14],[17,16,18,16],[20,11,21,11],[22,16,23,16],[23,1,24,15],[24,16,25,16],[25,0,26,15],[27,1,29,15],[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],[0,1,0,4],[1,1,1,4],[6,7,6,15],[8,7,8,15],[10,5,12,15],[8,5,8,6],[7,7,7,15]]}
["CHAPTER 1 ","DECISION ANALYSIS",null,null,null,null,null,null,null,null,null,"Name of Project"]
[null,"POSTERIOR PROBABILITIES OF TWO EVENTS",null,null,null,null,null,"Level",null,null,null,{"$f":"'Cap.Goods'!E3","v":"Valister Greenhouse"}]
[]
["Background:","You are ① producer and ② distributor of high quality vegetables of ❶own and ❷other Bulgarian suppliers to a large net of European buyers; they form posterior probabilities of two events.  "]
["Historical Info: ","Enter new data below \u0088  from ",null," If except these two events of interest there are more probabilities indicated by the Online Cash-Flow Control System (OCFCS), go to the next Sheet\u0086",null,null,null,null,null,null,null,null,null,null,null,"5 Events"]
[]
[" Event A1 QUANITTY","Produce-Sale A1 QUANTITY",{"$f":"BUDGET!M80","v":0.65}," Percentage Good yield of own products―high revenue.",null,null,null,"The mutually exclusive events for which posterior probabilities are desired."]
[null,null,null,null,null,null,null,"My events of interest:  QUANTITY SUPPLIED to Sales Dept. for distribution in EU markets"]
[" Event A2 QUANTIITY","Buy-Sale     A2 QUANTITY",{"$f":"100%-C7","v":0.35}," Percentage  of prior Bad probability I",null,"low quality products - bought and exported with lower income.",null,"A1 QUANTITY of Good quality own production of vegetables, sold to EU distributors at high cost.      A2 QUANTITY of Bad quality vegitables from the local market, sold to EU distributors at low cost."]
[null,null,null,null,null,"In analysing of conditional prior probability for specific events of interest we indicated probabilities given new information and revised them here."]
[" Event A1 supplied QUALITY:","Produce-Sale A1 QUANTITY",{"$f":"BUDGET!L80/100","v":1}," Percentage Good vegitables (G) sold.",null,"Based on the huge pre-design marketing research, the quantity and quality (sales) ratings of the two resources for supply of the products are as shown in the below Table SALES REVENUE EVENTS. With this new information we revise or update the conditional, prior probability values as percentage of the total QUANTITY for sale― Good yield from the better source, Supplier A1 and the Bad probability from both A1 ∩ A2 supply sourses. That will certainly cause a limited cash inflow.  What is the posterior probability for the cause to be A1 U A2 supplier?"]
[]
[" Event A2 supplied QUALITY:","Buy-Sale     A2 QUANTITY",{"$f":"BUDGET!N80/100","v":0.59}," Percentage Bad vegitables (B) sold."]
[]
["Safe Event",null,"SALES REVENUE EVENTS",null,"PRIOR PROBABILITY",null,"POSTERIOR",null,null,null,"TABULAR APPROACH"]
["Restore Model","When U pay - cry"," Percentage Good Fodder (G)","Percentage Bad Fodder (B)","QUANTITY % from A1∩A2 Products",null," PROBABILITIES            that Badpart of produc is:",null,null,null,"A1U A2 Prior Probabilities","B Conditional Probabilities","Joint  Bad A1,2 ∩B","Posterior Probabilities",null,"Others cry"]
[]
["Clean Model","Supplier A1",{"$f":"C7*100","v":65},{"$f":"100%-C11","v":0},{"$f":"C11*100","v":100},null,"From Supplier A1:",null,{"$f":"D18*C7/(D18*C7+D20*C9)","v":0},null,{"$f":"C18/100","v":0.65},{"$f":"D18","v":0},{"$f":"K18*L18","v":0},{"$f":"M18/M21","v":0}]
[]
[null,"Supplier A2",{"$f":"C9*100","v":35},{"$f":"100%-C13","v":0.41000000000000003},{"$f":"100-E18","v":0},null,"From Supplier A2:",null,{"$f":"(100%-C13)*C9/((100%-C11)*C7+(100%-C13)*C9)","v":1},null,{"$f":"C20/100","v":0.35},{"$f":"D20","v":0.41000000000000003},{"$f":"K20*L20","v":0.14349999999999999},{"$f":"M20/M21","v":1}]
["ANALYSIS:","On relative basis the probability of the Bad event coming from Supplier 2 [",null,null,null,{"$f":"N20","v":1},"] compared [",{"$f":"N18","v":0},"] from Supplier 1.",null,{"$f":"SUM(K18:K20)","v":1},"To the new  info given each event",{"$f":"SUM(M18:M20)","v":0.14349999999999999},{"$f":"SUM(N18:N20)","v":1},null,{"$f":"M21*1+O21*1","v":0.14349999999999999}]
[null,"There is a greater likelihood the Bad event is observed because outcome  [ ",null,null,null,{"$f":"M20","v":0.14349999999999999},"] following [",{"$f":"L20/10","v":4.1000000000000002E-2},"] A2's Bad supply to be a crash.",null,null,null,"Overall<probability of Bad event"]
[]
["CLOSING:","We applied Bayes' theorem, which is used extensively in decision analysis of the already made risk assessment, where the prior probabilities were subjective estimates requiring this specialized audit. The information and posterior probabilities are computed for a more objective presentation of the level of the risk of an event and its complement."]
[]
["       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 recommended 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,"Sample of comments of our clients of this model: \". . . default risk assessment is the starting point which most frequently cause arguments 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 the 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 risks, and talk only about that."]
[]
[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 ③ 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 the 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, that we recommend is an instrument that serves post factum an investment throughout the project providing current 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":"Valister 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 extention"]

{"sheet":"Staff","index":4,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[19,1,19,2],[20,1,20,2],[43,1,43,2],[44,1,44,2]]}
[null,null,null,"лв./$ exchange rate:",null,1,1.48]
[null,null,null,"USD/EUR exchange rate:",null,1,1.28]
[null,null,null,"EUR/лв. exchange rate:",null,1,1.96,null,null,"Supporting Column"]
[null,null,"En",null,null,"STAFF - Start Salaries"]
[null,null,null,"PERSONNEL, Position","Nr","€/Мо","лв./Mo","$ p.6Mo"]
[]
[null,null,null,"ASMINISTRATION",{"$f":"E31","v":10}]
[null,null,1,"CEO",1,{"$f":"F32","v":663.26530612244903},{"$f":"G32","v":1300},3979.591836734694]
[null,null,2,"Chief Technologist",1,561.22448979591843,1100,3367.3469387755104]
[null,null,3,"Accountant",1,357.14285714285717,700,2142.8571428571431]
[null,null,4,"Technologist",0,331.63265306122452,650,0]
[null,null,5,"Sales Manager",1,306.12244897959187,600,1836.7346938775513]
[null,null,6,"Agronomist",0,306.12244897959187,600,0]
[null,null,8,"Truckers",2,306.12244897959187,600,3673.4693877551026]
[null,null,9,"Security",{"$f":"E39","v":4},{"$f":"F39","v":255.10204081632654},{"$f":"G39","v":500},{"$f":"H39","v":6122.4489795918371}]
[null,null,null,null,null,null,null,{"$f":"SUM(H8:H15)","v":21122.448979591842}]
[null,null,null,"Benefits (averaged)",null,null,{"$f":"G47","v":0.17799999999999999},{"$f":"G17*(1+H16)","v":3759.9739183673478}]
[null,null,null,"SubTOTAL:",null,null,null,{"$f":"SUM(H16:H17)","v":24882.42289795919}]
[null,null,null,"PRODUCTION STAFF",{"$f":"SUM(E20:E21)","v":25},"€/Мо","BN/Mo"]
[null,11,null,"Payroll staff",{"$f":"E44","v":25},{"$f":"F44","v":275.51020408163265},{"$f":"G44","v":540},{"$f":"H44","v":41326.530612244896}]
["Ø",12,null,"Part time job",{"$f":"E45","v":0},null,{"$f":"G45/$G$1","v":0}]
[null,null,null,"TOTAL:",null,{"$f":"E46","v":35},null,{"$f":"H20","v":41326.530612244896}]
[null,null,null,"Benefits (averaged)",null,null,{"$f":"G41","v":0.17799999999999999},{"$f":"G23*(1+H22)","v":7356.3004489795912}]
[null,null,null,"SubTOTAL:",null,null,null,{"$f":"SUM(H22:H23)","v":48682.83106122449}]
[null,null,null,null,null,null,"TOTAL:",{"$f":"H18+H24","v":73565.253959183683}]
[]
[]
[null,null,null,null,null,"STAFF - Start Salaries"]
[null,null,null,"PERSONNEL, Position","Nr","€/Мо","лв./Mo","$ p.6Mo"]
[]
[null,null,null,"ASMINISTRATION",{"$f":"SUM(E32:E39)","v":10}]
[null,null,{"$f":"C8","v":1},"CEO",1,{"$f":"G32/$G$3","v":663.26530612244903},1300,{"$f":"E32*F32*6","v":3979.591836734694}]
[null,null,{"$f":"C9","v":2},"Chief Technologist",1,{"$f":"G33/$G$3","v":561.22448979591843},1100,{"$f":"E33*F33*6","v":3367.3469387755104}]
[null,null,{"$f":"C10","v":3},"Accountant",1,357.14285714285717,700,2142.8571428571431]
[null,null,4,"Technologist",0,331.63265306122452,650,0]
[null,null,5,"Sales Manager",1,306.12244897959187,600,1836.7346938775513]
[null,null,6,"Agronomist",0,306.12244897959187,600,0]
[null,null,8,"Truckers",2,306.12244897959187,600,3673.4693877551026]
[null,null,9,"Security",4,{"$f":"G39/$G$3","v":255.10204081632654},500,{"$f":"E39*F39*6","v":6122.4489795918371}]
[null,null,null,null,null,null,null,{"$f":"SUM(H32:H39)","v":21122.448979591842}]
[null,null,null,"Benefits (averaged)",null,null,0.17799999999999999,{"$f":"G41*(1+H40)","v":3759.9739183673478}]
[null,null,null,"SubTOTAL:",null,null,null,{"$f":"SUM(H40:H41)","v":24882.42289795919}]
[null,null,null,"PRODUCTION STAFF",{"$f":"E19","v":25},"€/мес.","лв./мес."]
[null,null,null,"Payroll staff",25,{"$f":"G44/$G$3","v":275.51020408163265},540,{"$f":"E44*F44*6","v":41326.530612244896}]
["Ø",12,null,"Part time job",0,null,0]
[null,null,null,"TOTAL:",{"$f":"E31+E43","v":35},null,null,{"$f":"H44","v":41326.530612244896}]
[null,null,null,"Benefits (averaged)",null,null,{"$f":"G41","v":0.17799999999999999},{"$f":"G47*(1+H46)","v":7356.3004489795912}]
[null,null,null,"SubTOTAL:",null,null,null,{"$f":"SUM(H46:H47)","v":48682.83106122449}]
[null,null,null,null,null,null,"ОБЩО:",{"$f":"H42+H48","v":73565.253959183683}]
[]
[]
[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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Grace Period"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"G5","v":"лв./Mo"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"G8","v":1300}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L71:L72)","v":1300}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L73*(0.42*0.75+0.07),0)","v":501}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L73:L74)","v":1801}]

{"sheet":"Bayes5","index":5,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,14,10,17],[1,1,1,8],[6,14,6,17],[7,14,7,17],[8,14,8,17],[9,14,9,17],[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]]}
["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":"Valister Greenhouse"}]
[]
["Background:","Five mutually exclusive events following delivery of goods or services by Suppliers  where one of the events must occure when new information"]
["Clean and Start","from a sample, a special report, a poduct 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 eash supplier . "]
[null,null,"QUALITY",null,null,null,"QUANTITY",null,"POSTRIOR 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 Commets",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"]