{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Intro","Cap.Goods","BUDGET","Bayes","Bayes5"],"not_rendered":{"charts":3,"images":73,"macros":1,"external_links":2,"defined_names":60,"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":98,"n_cols":22,"rows_kept":98,"cut":false,"hidden":false,"merged":[[64,15,64,16],[53,11,53,12],[54,17,54,18],[59,11,59,12],[60,11,60,12],[52,11,52,12],[53,15,53,16],[29,7,30,18],[47,15,47,16],[51,15,51,17],[37,8,37,9],[33,8,33,9],[34,8,34,9],[51,11,51,12],[32,8,32,9],[60,15,60,16],[56,8,56,9],[63,7,63,10],[46,3,46,5],[52,0,52,1],[30,21,31,21],[31,12,31,13],[61,11,61,12],[54,15,54,16],[56,11,56,12],[57,11,57,12],[58,11,58,12],[35,8,35,9],[46,10,46,15],[37,12,37,16],[39,12,39,16],[40,12,40,16],[41,12,41,16],[59,15,59,16],[68,1,68,2],[48,6,62,6],[55,0,55,1],[57,0,57,1],[58,0,58,1],[60,0,60,1],[61,0,61,1],[59,0,59,1],[51,0,51,1],[48,0,48,1],[49,0,49,1],[56,0,56,1],[50,0,50,1],[53,0,53,1],[54,0,54,1],[14,19,14,20],[15,9,15,10],[16,9,16,11],[1,6,2,9],[2,10,2,15],[12,0,12,1],[20,1,20,2],[22,0,22,1],[23,0,23,1],[0,15,1,17],[0,19,0,21],[2,16,4,16],[6,20,6,21],[8,8,9,8],[7,12,7,13],[3,6,4,11],[5,6,5,12],[12,19,12,20],[9,6,9,7],[10,6,10,7],[11,6,11,7],[7,0,7,1],[22,2,22,4],[21,2,21,3],[67,7,67,10],[27,0,27,2],[28,0,28,2],[47,10,47,14],[28,12,28,18],[38,8,38,9],[40,8,40,9],[42,8,42,9],[39,8,39,9],[41,8,41,9],[47,8,47,9],[33,12,33,14],[34,12,34,14],[58,15,58,16],[32,12,32,14],[48,10,48,14],[49,11,49,12],[50,11,50,12],[29,0,29,2],[47,0,47,2],[45,0,45,4],[43,0,43,1],[42,0,42,1],[36,8,36,9],[18,9,18,10],[10,13,11,15],[23,2,23,4],[0,2,0,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[13,10,13,12],[14,13,14,15],[17,9,17,10],[5,15,6,16]]}
[0,null,"Presentation of data from 6-month cash flows",null,null,null,null,null,null,null,null,null,null,null,null,"Do you need free browsing the program file?",null,null,null,"          Exchange Rates"]
[null,null,"   Level 0 ß"," Level 3",null,null,"GLOBAL STEEL D.O.O.",null,null,null,null,null,null,null,null,null,null,null,null,1,1.96,{"$f":"V3/T3","v":1.2048192771084338}]
[null,null,"            SALES",null,null,null,null,null,null,null,"   Represented by local outsourcing east electric company Ltd, Bulgaria ",null,null,null,null,null,null,null,null,0.83,null,1]
[null,null,"Homes ",{"$f":"ROUND(Q23,-2)","v":0},{"$f":"D3*$U$2","v":0},null,"Prefabricated Buildings and Halls\nsteel structures "]
[null,null," Halls ",{"$f":"ROUND(Q24,-2)","v":0},{"$f":"D5*$U$2","v":0}]
[null,null,"TOTAL:",{"$f":"ROUND(Q25,-2)","v":0},{"$f":"D6*$U$2","v":0},null,"primarily engaged in the production and installation of steel structures",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-08-18"}]
[null,null,null,null,null,null,"    ←Level 5    →",null,"Zoom↓","Risk assessment and management. Go to Bayes Theorem"]
[" Click the picture \u0093 to increase it",null,"`",{"$f":"SUM(D9:D10)","v":{"$error":"#REF!"}},{"$f":"SUM(E9:E10)","v":{"$error":"#REF!"}},null,"        ←Level 4   →",null,null,"Sensitivity analysis",null,null,"         ←Zoom 100"]
[null,null,"           COSTS, Total",{"$f":"SUM(D10:D11)","v":{"$error":"#REF!"}},{"$f":"SUM(E10:E11)","v":{"$error":"#REF!"}},null,"           ←Level 3 →",null,"Zoom 152","Decision analysis, profitability"]
[null,null,"        Variable costs",{"$error":"#REF!"},{"$f":"D10*$U$2","v":{"$error":"#REF!"}},null,"              ←Level 2",null,null,"Cash-flow Pro-forma Budgeting "]
[null,null,"         Fixed costs",0,{"$f":"D11*$U$2","v":0},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,"         Revenues /Costs",{"$f":"ROUND(D4-D9,-3)","v":{"$error":"#REF!"}},{"$f":"ROUND(E4-E9,-3)","v":{"$error":"#REF!"}},null,"                    ←Level 0",null,"Basic data, invariant for this Project"]
["    By-products",null,"         Marketing / RM",0,{"$f":"D13*$U$2","v":0}]
["This information shows all the time: ① Are the project data correct,",null,null,null,null,null,null,"  Level             Go dowm",null,null,"Decision Analysis",null,null,"Online Cash Flow Control"]
["② Is there good management, ③ the risk assessment and management",null,null,null,null,null,null,null,null,null,null,"    Demand is rising",null,"All time during the loan life"]
["↑This sector presents Level 3 data for comparison with the base information of Level 0",null,null,null,null," \u0085 Click the image  to reveal the final results",null,null,null,"   1 year",null,"Financial modeling  ↗"]
[null,"   Overall probability of a bad event - ",null,null,null,null,null,null,null,"Built-up materials  ",null,null,"p.Yr"]
[null,"   lost profits due to lack of risk assessment.",null,null,null,null,null,null,null,"Homrs",null,{"$f":"M18/M20","v":0.31034482758620691},{"$f":"Q34","v":36360}]
[null,null,null,null,"Revenue increase due to beter distribution, TOTAL:","7-Yr Option",null,null,null,"Halls",null,{"$f":"100%-L18","v":0.68965517241379315},{"$f":"Q35","v":80800}]
[null,"     The  greenhouse complex",null,null,"Loans A + B - D Investment, TOTAL:",null,null,null,null,null,null,null,{"$f":"M18+M19","v":117160},"Feedback from Level 5 to Level 0"]
["Creditor  \u0086","    Project Finance"]
["Export Credit Insurance ",null,"            Financial Modeling",null,null,"      DDP (Delivered Duty Paid)"]
["Marketing",null,"              Business Plan \u0085  East Electric Company",null,null,"The seller is responsible for arranging carriage and delivering the goods at the named place, cleared for import and all applicable taxes and duties paid (e.g. VAT, GST)"]
["                  Insurer",null,"            Risk Assessment \u0085  Brothers Global Ltd.",null,null,"In this country the import clearance procedures are not complex and bureaucratic, but In case there is a problem, the user is obliged to solve it."]
[null,null,null,"  Solar power supplier - Own division"]
[null,null,null,"Infrastructure. Solar power supplier",null,null,null,null,null,null,null,null,"Intro!L35*Intro!R35+Intro!K35*3*R35"]
["  Material products:",null,null,"      Intellectual products:"]
["                   Buildings ← sq. m /",null,null,"← Risk assessment & management"]
["                   Halls  ← sq. m /",null,null,"← Online cash-flow control system ",null,null,null,null,null,null,null,null,"¯ Basic unchangeable values for transfer to upper level 1 Ö"]
[" By-products of buildings & halls  ←",null,null,"← History of sales and costs ",null,null,null,"FINANCIAL STARTUP DATA"]
["        Numbers newly introduced"]
["The attached color and image visualizations in all worksheets are designed for faster and easier perception of figures and formulas, as well as for their long-term memorization when financing the project.",null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,"Production","Price"]
[null,null,null,null,null,"MATERIALS ","2001-UBM-240:","Income  -  Sales:","Built-up area",null,"p.Mo ↓","Jan, Feb, Mar","Apr, May, Jun, Jul, Aug, Sep",null,null,"Oct, Nov, Dec","per Yr","Price","↓ Sales"]
[null,null,null,null,null,"Loan - for 3 Mos:",2500000,"Homes construction",180,null,{"$f":"I34*M32","v":3600},{"$f":"K34*3-K34*3*20%","v":8640},{"$f":"K34*5","v":18000},null,null,{"$f":"K34*3-K34*3*10%","v":9720},{"$f":"L34+M34+P34","v":36360},140,{"$f":"Q34*R34","v":5090400}]
[null,null,null,null,null,"Homes","2000-UBM-120:","Halls construction",400,null,{"$f":"I35*M32","v":8000},{"$f":"K35*3-K35*3*20%","v":19200},{"$f":"K35*5","v":40000},null,null,{"$f":"K35*3-K35*3*10%","v":21600},{"$f":"L35+M35+P35","v":80800},120,{"$f":"Q35*R35","v":9696000}]
[null,null,null,null,null,{"$f":"S39","v":756000},1187500,"Homes - Sales 1st half Yr:",{"$f":"(L34+K34*3)*R34","v":2721600},null,"2nd half Yr:",{"$f":"(K34*3+P34)*R34","v":2872800},null,null,null,"1 Yr TOTAL:",{"$f":"Q34+Q35","v":117160},null,{"$f":"S34+S35","v":14786400}]
[null,null,null,null,null,"Halls","Flat Panel:"," Halls -      Sales 1st half Yr:",{"$f":"(L35+K35*3)*R35","v":5184000},null,"2nd half Yr:",{"$f":"(K35*3+P35)*R35","v":5472000}]
[null,null,null,null,null,{"$f":"S41","v":1200000},687500,"Cost  -  Materials:",{"$f":"I33","v":"Built-up area"},null,"p.Mo ↓",3,null,null,null,null,null,"Price","↓ Buy"]
[null,null,null,null,null,"Import - Export","For polyuretan:","Homes materials 1m2",{"$f":"I34","v":180},null,{"$f":"I39*M32","v":3600},{"$f":"K39*L38","v":10800},null,null,null,null,null,70,{"$f":"L39*R39","v":756000}]
[null,null,null,null,null,"TOTAL:",312500,33.5,{"$f":"H40*I39/1000","v":6.03},null,{"$f":"I40*M32","v":120.60000000000001},{"$f":"K40*L38","v":361.8}]
[null,null,null,null,null,{"$f":"F36+F38","v":1956000},"Fire Protection:","Halls material     1m2",{"$f":"I35","v":400},null,{"$f":"I41*M32","v":8000},{"$f":"K41*L38","v":24000},null,null,null,null,null,50,{"$f":"L41*R41","v":1200000}]
[null,null,null,null,null,"TECHNOLOGY ",437500,46,{"$f":"H42*I41/1000","v":18.399999999999999},null,{"$f":"I42*M32","v":368},{"$f":"K42*L38","v":1104},null,null,null,null,null,"1 Yr TOTAL:",{"$f":"S39+S41","v":1956000}]
["        For Developer's use only ",null,"    ",null,null,"STARTUP",{"$f":"G34+G36+G38+G40+G42","v":5125000},null,{"$f":"H40*K39","v":120600}]
[" For Developer's use only ",null,null,null,null,"SUPPORT","Homes and Halls","     ON THE TOP OF THE SECTIONS",null,null,"←","→",null,null,null,null,null,"     ↗"]
[null,null,null,null,null,{"$f":"G46*F46","v":1274580},"< pictures >","     These characters are on base data and are links to Level 1",null,null,null,null,null,null,null,null,null,"     ↗"]
["Training - disassembly and assembly of machines for transport and operation:",null,null,null,null,0.18,{"$f":"F41+G43","v":7081000},"     Data entered from external sources.",null,null,null,null,null,null,null,null,null,"↗"]
[null,null,null,"MATERIALS and supply SubTOTAL:",null,null,{"$f":"G46*F46","v":1274580},null,null,null,"â Basic unchangeable values for transfer to upper",null,null,null,null,null," Level 1 ↗","    Duty","VAT"]
["INFLOW DATA WORKING PANEL FOR THE BASE",null,null,"Level  0",null,"Loan amount TOTAL:",{"$f":"G46+G47","v":8355580}," Solar Energy","Design data",null,"STAFF - Start Salaries",null,null,null,null," Imp. values + LOCAL COSTS        ",null,2.5000000000000001E-2,0.2]
[null,null,null,null,null,null,null,null,null,null,"Structure and salaries of employees",null,null,null,null," Import Duty: ","Machines",{"$f":"G43*R48","v":128125},{"$f":"G43*S48","v":1025000}]
[null,null,null,null,null,null,null,null,null,null,null,"POSITION",null,null,null,null,"Materials",{"$f":"F41*R48","v":48900},{"$f":"F41*S48","v":391200}]
[null,null,null,null,null,null,null,null,null,null,"Nr.","ADMINISTRATION",null,"      $","$ p.Mo","                        Materials","Sub TOTAL(s)",{"$f":"R49+R50","v":177025},{"$f":"S49+S50","v":1416200}]
[null,null,null,null,null,null,null,null,null,null,1,"CEO",null,3000,{"$f":"K52*N52","v":3000},"Local country customs transport and storage:",null,null,30000]
[null,null,null,null,null,null,null,null,null,null,1,"Technical director  ",null,2000,{"$f":"K53*N53","v":2000},"Local administration Permits & Reconstruction:",null,null,50000]
[null,null,null,null,null,null,null,null,null,null,1,"Secretary",null,1000,{"$f":"K54*N54","v":1000},"Local country costs TOTAL:",null,{"$f":"R51+S54","v":257025},{"$f":"S52+S53","v":80000}]
[null,null,null,null,null,null,null,null,null,null,2,"Bookkeeper",null,2000,4000," Loan application - ",null," Exporter / Developer"]
[null,null,null,null,null,null,null,null,null,null,3,"Other administration",null,700,2100," 1. Data input analysis and legal confirmation by  Exporter"]
[null,null,null,null,null,null,null,null,null,null,null,"SERVICE STAFF",null,null,null,"     and Fin. modeling developer",null,12000]
[null,null,null,null,null,null,null,null,null,null,4,"Designer (architects)",null,1500,6000," 2. Bus Plan, Fin. Modeling",null,120000]
[null,null,null,null,null,null,null,null,null,null,2,"Engineers in production",null,1500,3000," 3. Software usage fee for OCFCS",null,16000]
[null,null,null,null,null,null,null,null,null,null,2,"Technological engineers",null,2000,4000," 4 .Risk Assessment - software ",null,45000]
[null,null,null,null,null,null,null,null,null,null,20,"Production workers",null,800,16000,"Sub TOTAL:",null,{"$f":"R57+R58+R59+R60","v":193000},"Other:","Go to"]
[null,null,null,null,null,null,null,null,null,null,20,"Construction workers",null,1000,20000,"Constructive permits, - electricity, water, etc.",null,null,15000," Level"]
[null,"Solar energy supplier for own use - 2nd stage of this project",null,null,null,null,null,null,null,null,{"$f":"K52+K53+K54+K55+K56+K58+K59+K60+K61+K62","v":56},"TOTAL number of emploees ",null,null,{"$f":"O52+O53+O54+O55+O56+O58+O59+O60+O61+O62","v":61100},"Infrastructure - hedge, water & power supply",null,null,35000,"â"]
[null,null,null,null,null,null,null,"   Financial crises and real estate ",null,null,null,null,null,0.3,null,"Other expenses - land, video control, etc.",null,null,10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①  TOTAL:",null,{"$f":"R54+S51+R61+S62+S63+S64","v":1926225},"Local"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Equipment Imp.   ↓",null,{"$f":"G48","v":8355580},"Country"]
["   The color visualizations used in all worksheets are intended for faster and easier perception of figures and formulas, as well as for their long-term memorization in the financing of the project and its management.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expences"]
[null,null,null,null,null,null,88,"COSTS of system for photovoltaic modules",null,null,null,155,"Generation",0.3,"€/ha"," $",null,null,{"$f":"R65/R66","v":0.23053157291295159}]
["Spain yiels T + C:","Average price ↓ in Holland",null,null,null,null,null,"        Tpansport →","→",20,350,{"$f":"K69/J69/1000","v":1.7500000000000002E-2},".+ Transport","This project",{"$f":"N71/$A$91","v":0}]
["Kg","Kg/m2","€ /kg ",null,null,null,null,"         Panels  →",".↓Mo"," p.Yr",{"$f":"L68/1000","v":0.155},"Transp. p.ha","€/Mo/ha","€ p.↓Mo",0]
[264768,{"$f":"A71/$A$92","v":2},1.21,null,null,null,null,null,557463,{"$f":"I71/$A$91","v":42109.544960116022},{"$f":"J71*$K$70*(1+$N$68)","v":8485.0733094633797},{"$f":"K71*$L$69","v":148.48878291560916},{"$f":"K71+L71","v":8633.5620923789884},{"$f":"M71*$T$48","v":0},0]
[728112,{"$f":"A72/$A$92","v":5.5},2.83,null,null,null,null,null,523149,{"$f":"I72/$A$91","v":39517.539883973892},{"$f":"J72*$K$70*(1+$N$68)","v":7962.7842866207393},139.34872501586295,{"$f":"K72+L72","v":8102.1330116366025},{"$f":"M72*$T$48","v":0},0]
[1125264,8.5,1.85,null,null,null,null,null,444513,{"$f":"I73/$A$91","v":33577.547135605513},{"$f":"J73*$K$70*(1+$N$68)","v":6765.8757478245107},118.40282558692894,6884.2785734114395,0,0]
[1191456,9,1.33,null,null,null,null,null,340047,{"$f":"I74/$A$91","v":25686.412255257434},{"$f":"J74*$K$70","v":3981.3938995649023},69.674393242385804,4051.0682928072883,0,0]
[1059072,8,1.01,null,null,null,null,null,156019,11785.33659656756,{"$f":"J75*$K$70*(1+$N$68/1.5)","v":2192.0726069615662},38.361270621827408,2230.4338775833935,0,0]
[0,{"$f":"A76/$A$92","v":0},0.63,null,null,null,null,null,0,0,{"$f":"J76*$K$70*(1+$N$68)","v":0},0,0,0,0]
[369152,2.7884940778341796,0.53,null,null,null,null,null,0,0,{"$f":"J77*$K$70*(1+$N$68)","v":0},0,0,0,0]
[595728,4.5,0.51,null,null,null,null,null,0,0,{"$f":"J78*$K$70*(1+$N$68)","v":0},0,0,0,{"$error":"#REF!"}]
[728112,5.5,0.63,null,null,null,null,null,0,0,{"$f":"J79*$K$70*(1+$N$68)","v":0},0,0,0,0]
[369152,2.7884940778341796,1.01,null,null,null,null,null,261574,19758.732173072272,{"$f":"J80*$K$70*(1+$N$68/3)","v":3368.8638355088228},58.955117121404406,{"$f":"#REF!+L80","v":{"$error":"#REF!"}},{"$error":"#REF!"},0]
[132384,1,0.95,null,null,null,null,null,392361,29638.09825960841,{"$f":"J81*$K$70*(1+$N$68)","v":5972.0767993110949},104.51134398794417,{"$f":"K81+L81","v":6076.5881432990391},0,{"$f":"SUM(O69:O80)","v":{"$error":"#REF!"}}]
[264768,2,1.26,null,null,null,null,null,392361,29638.09825960841,{"$f":"J82*$K$70*(1+$N$68)","v":5972.0767993110949},104.51134398794417,{"$f":"K82+L82","v":6076.5881432990391},0,null,"Area, ha",2,4,5]
[{"$f":"SUM(A71:A82)","v":6827968},{"$f":"SUM(B71:B82)","v":51.57698815566836},"   ↙        OFFERS        ↘",null,null,null,null,null,444676,{"$f":"SUM(J70:J82)","v":231711.3095238095},{"$f":"SUM(K70:K82)","v":44700.372284566103},{"$f":"SUM(L71:L82)","v":782.25380247990711},{"$f":"SUM(M71:M82)","v":{"$error":"#REF!"}},{"$f":"SUM(N71:N82)","v":{"$error":"#REF!"}},null,"Price:",null,112,40,35,33]
["    USA",null,"USA  ②"]
[{"$f":"364.8*160","v":58368}]
[70080]
[{"$f":"2*9.6*120+1*9.6*170","v":3936}]
[{"$f":"SUM(A85:A87)","v":132384}]
[{"$f":"20*135","v":2700},null,3744]
[{"$f":"10*225.5","v":2255},null,2496]
[{"$f":"A88/10000","v":13.2384},null,{"$f":"51456/10000","v":5.1456}]
[{"$f":"A91*10000","v":132384},null,{"$f":"SUM(C85:C90)","v":6240}]
[2286699,null,478922]
[6800]
[42000,null,null,null,"Rent of a plot for a photovoltaic plant"]
[50000]
[{"$f":"ROUND((SUM(A93:A96)),-1)","v":2385500},null,{"$f":"SUM(A94:A96)+C93","v":577722}]
[{"$f":"A93/A91","v":172732.27882523567},null,{"$f":"C97/C91","v":112274.95335820895}]

{"sheet":"Cap.Goods","index":1,"n_rows":44,"n_cols":23,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,2,0],[2,4,2,9],[4,13,4,14],[13,13,13,14],[4,11,4,12],[13,3,13,4],[6,3,6,4],[5,1,12,1],[7,3,7,4],[11,2,11,4],[8,2,8,3],[44,21,45,22],[46,14,46,17],[2,2,2,3],[13,11,13,12],[34,16,34,17],[34,13,34,14],[41,3,41,5],[43,3,43,5],[37,1,44,1],[46,9,46,10],[30,2,31,2],[15,1,32,1],[42,3,42,5],[37,9,43,9],[40,2,40,4],[38,3,38,4]]}
[]
[]
[null," ↑","Level ①",null,"      Capital Goods and Services "]
[null,"To Level 0",null,null,null,null,null,null,null,null,null,{"$f":"BUDGET!C14","v":"Date:"},null,null,{"$f":"BUDGET!E14","v":"2023-06-30"}]
[null,"A",null,"CAPITAL INVESTMENT EXPORT \u0086/ IMPORT ",null,"Loan \"A\"",null,null,"PROJECT FINANCE",null,"D","OWN FUNDS Loan \"D\"",null,"Loan \"A\" + VAT + \"D\"",null,"TOTAL"]
[null,{"$f":"IF(#REF!<=50%,\"\",\"M\")","v":{"$error":"#REF!"}},null,null,null,null,null,"Advance","Balance",null,null,{"$f":"M6","v":0},0,"Advance","Balance","Value",null,"→"]
[null,null,null,"Building Machines for self-supporting facilities (DDP)\n production of self-supporting facilities\n production of self-supporting facilities, DDP",null,{"$f":"Intro!G43","v":5125000},null,null,{"$f":"(100%-#REF!)*F7-(100%-#REF!)*F7*$M$6","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!*F7*$M$6","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*F7*$M$6","v":{"$error":"#REF!"}},{"$f":"H7+L7","v":{"$error":"#REF!"}},{"$f":"I7+M7","v":{"$error":"#REF!"}},{"$f":"N7+O7","v":{"$error":"#REF!"}}]
[null,null,null,"Construction materials (for 3 Mo)",null,{"$f":"Intro!F41","v":1956000},null,"loan+LCs",{"$f":"(100%-C8)*F8-(100%-C8)*F8*$M$6","v":1956000},null,null,{"$f":"C8*F8*$M$6","v":0},{"$f":"(100%-C8)*F8*$M$6","v":0},{"$f":"H8+L8","v":0},{"$f":"I8+M8","v":1956000},{"$f":"N8+O8","v":1956000}]
[null,null,"Startup support",null,"TOTAL:",{"$f":"Intro!G46","v":7081000}]
[null,null,{"$f":"Intro!F46","v":0.18},"  Job training - disassembly and assembly of machines:",null,{"$f":"Intro!F45","v":1274580}]
[null,null,null,null," TOTAL:",{"$f":"Intro!G48","v":8355580},null,{"$f":"Intro!#REF!","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*F11-(100%-#REF!)*F11*$M$6","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!*F11*$M$6","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*F11*$M$6","v":{"$error":"#REF!"}},{"$f":"H11+L11","v":{"$error":"#REF!"}},{"$f":"I11+M11","v":{"$error":"#REF!"}},{"$f":"N11+O11","v":{"$error":"#REF!"}}]
[null,null,"Next stage of the PROJECT development is SOLAR ENERGY GENERATION",null,null,{"$f":"Intro!H48","v":" Solar Energy"}]
[]
[null,"B",null,"LOCAL COUNTRY COSTS \u0086",null,"Loan \"B\"",null,null,null,null,"D","OWN FUNDS Loan \"D\"",null,"Loan \"A\" + VAT + \"D\"",null,"TOTAL"]
[null,null,"Advance, %",null,null,"    Net Price","Import Duty","Advance","Balance",null,null,{"$f":"M15","v":0},{"$f":"M6","v":0},"Advance","Total","Value",null,"→"]
[null,null,"2.5%  Duty:","Import Duty - Building Machines: ",null,{"$f":"Intro!R51","v":177025}]
["Ø",null,null,"Local country customs transport and storage:",null,{"$f":"Intro!S52","v":30000}]
["Ø",null,null,"Local administration - Permits & Reconstruction:",null,{"$f":"Intro!S53","v":50000},null,{"$f":"C17*F17-C17*F17*$M$6","v":0},{"$f":"(100%-C17)*F17-(100%-C17)*F17*$M$6","v":30000},null,null,{"$f":"C17*F17*$M$15","v":0},{"$f":"(100%-C17)*F17*$M$6","v":0},{"$f":"H18+L18","v":0},{"$f":"I18+M18","v":30000},{"$f":"N18+O18","v":30000}]
[null,null,null,null,"Sub TOTAL:",{"$f":"Intro!R54","v":257025}]
[null,null,"20% VAT:","(Refundable)",null,{"$f":"Intro!S51","v":1416200},null,null,null,null,null,"Financial suport of Exporter for 15% Buyer's own funds"]
[null,null,"Cap. Investment:","Constructive drawings, permits - electricity, water, etc.",null,{"$f":"Intro!S62","v":15000}]
[null,null,null,"Terrain, infrastructure - hedge, water & power supply",null,{"$f":"Intro!S63","v":35000}]
[null,null,null,"Other unforeseen expenses - land, video control, etc.",null,{"$f":"Intro!S64","v":10000}]
[null,null,null,null,"Sub TOTAL:",{"$f":"F21+F22+F23","v":60000}]
[null,null,"Other:"," Loan application"]
[null,null,"Fin. modeling:","1. All data input analysis and legal confirmation",null,{"$f":"Intro!R57","v":12000},null,{"$f":"C18*F18-C18*F18*$M$6","v":0},{"$f":"(100%-C18)*F18-(100%-C18)*F18*$M$6","v":50000},null,null,{"$f":"C18*F18*$M$15","v":0},{"$f":"(100%-C18)*F18*$M$6","v":0},{"$f":"H26+L26","v":0},{"$f":"I26+M26","v":50000},{"$f":"N26+O26","v":50000}]
[null,null,null,"2. Business Plan, Financial modeling",null,{"$f":"Intro!R58","v":120000}]
[null,null,null,"3. Software usage fee for OCFCS and sensitivity analysis",null,{"$f":"Intro!R59","v":16000}]
["Ø",null,null,"4. Financial risk assessment and management",null,{"$f":"Intro!R60","v":45000},null,{"$f":"#REF!*F26-#REF!*F26*$M$6","v":{"$error":"#REF!"}},{"$f":"SUM(I30:I31)","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!*F26*$M$15","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*F26*$M$6","v":{"$error":"#REF!"}},{"$f":"H29+L29","v":{"$error":"#REF!"}},{"$f":"#REF!+M29","v":{"$error":"#REF!"}},{"$f":"SUM(P30:P31)","v":{"$error":"#REF!"}}]
[null,null,"Local costs < 30%",null,"Sub TOTAL:",{"$f":"Intro!R61","v":193000},null,null,{"$f":"(100%-#REF!)*#REF!-(100%-#REF!)*#REF!*$M$6","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"IF(F32<=30%,\"C\",\"N\")","v":"C"},null,"TOTAL:",{"$f":"Intro!R65","v":1926225},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(100%-C32)*F29-(100%-C32)*F29*$M$6","v":45000},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,"Local Country Expences:",{"$f":"Intro!S68","v":0.23053157291295159}]
[null,null,"Local costs should not exceed 30% of the loan amount.",null,null,{"$f":"F19+F20+F24+F30","v":1926225},null,{"$f":"#REF!+H31","v":{"$error":"#REF!"}},{"$f":"#REF!+I29","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!+L31","v":{"$error":"#REF!"}},{"$f":"#REF!+M31","v":{"$error":"#REF!"}},{"$f":"#REF!+N31","v":{"$error":"#REF!"}},{"$f":"#REF!+O31","v":{"$error":"#REF!"}},{"$f":"#REF!+P29","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,{"$f":"Intro!S68","v":0.23053157291295159},null,{"$f":"#REF!+H33","v":{"$error":"#REF!"}},{"$f":"#REF!+I33","v":{"$error":"#REF!"}},null,"D",{"$f":"#REF!+L33","v":{"$error":"#REF!"}},{"$f":"#REF!+M33","v":{"$error":"#REF!"}},"WORKING CAPITAL ↓",null,{"$f":"#REF!+P33","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Loan \"D\"",{"$f":"L35+M35","v":{"$error":"#REF!"}},null,"Optional:",20000]
[null,null,null,"INSURANCE","  DEPRECIATION OF ASSETS",null,null,null,null,null,null,5.5E-2,null,null,null,{"$f":"SUM(P35:P36)","v":{"$error":"#REF!"}}]
["Ø",null,0.16,{"$f":"F7","v":5125000},"Mashines / Annual profit tax reduction:",{"$f":"D38*C38","v":820000}]
[null,null,0.25,"Motor car / Truck(s)"]
[null,null,0.04,"LOAN INTEREST RATE",null,{"$f":"Intro!G46*'Cap.Goods'!C40","v":283240}]
[null,null,"           Cell  →   Data entered from external sources",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    "]
["Ø",null,"           Cell  →  These -  characters are on base data and are links to Level 1","characters are on base data and are links to Level 1"]
["Ø",null,null,"This icons       or       are for Internet sources"]
["Ø",null,"       Various fonts","and background colors represent similar group data resources"]

{"sheet":"BUDGET","index":2,"n_rows":126,"n_cols":21,"rows_kept":126,"cut":false,"hidden":false,"merged":[[67,13,67,14],[67,10,67,11],[66,3,66,5],[62,2,62,4],[8,15,8,16],[8,6,8,7],[8,9,8,10],[8,12,8,13],[8,3,8,5],[10,0,10,2],[38,0,38,1],[63,2,63,4],[64,6,64,8],[62,6,62,8],[63,6,63,8],[64,13,64,14],[84,0,84,1],[67,0,67,1],[66,0,66,1],[65,0,65,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[79,0,79,1],[75,0,75,1],[64,10,64,11],[62,9,63,9],[62,10,62,14],[14,9,16,10],[31,0,31,1],[0,0,0,1],[32,0,32,1],[60,0,61,0],[11,0,12,1],[9,0,9,2],[33,0,33,1],[17,1,17,2],[14,1,14,2],[18,1,18,2],[16,1,16,2],[15,1,15,2],[29,0,29,1],[8,0,8,1]]}
["Business Plan",null,"1yr Sales:","31-Jen","2022-02-28","2022-03-31","2016-04-30","2016-05-31","2015-06-30","2015-07-31","August","2015-09-30","2015-10-31","2015-11-30","2015-12-31","$ TOTAL","6 Mo: Jan - Jun","6 Mo: Jul - Dec"]
["Level 1 ","ß    Homes:","Homes p.Mo",{"$f":"Intro!L34/3*Intro!R34","v":403200},{"$f":"Intro!L34/3*Intro!R34","v":403200},{"$f":"Intro!L34/3*Intro!R34","v":403200},{"$f":"Intro!K34*Intro!R34","v":504000},{"$f":"Intro!K34*Intro!R34","v":504000},{"$f":"Intro!K34*Intro!R34","v":504000},{"$f":"Intro!K34*Intro!R34","v":504000},0,{"$f":"Intro!K34*Intro!R34","v":504000},{"$f":"Intro!P34/3*Intro!R34","v":453600},{"$f":"Intro!P34/3*Intro!R34","v":453600},{"$f":"Intro!P34/3*Intro!R34","v":453600},{"$f":"SUM(D2:O2)","v":5090400},{"$f":"SUM(D2:I2)","v":2721600},{"$f":"SUM(J2:O2)","v":2368800},null,{"$f":"Q2+R2","v":5090400}]
[" ← Back","Halls:","Halls p.Mo",{"$f":"Intro!L35/3*Intro!R35","v":768000},{"$f":"Intro!L35/3*Intro!R35","v":768000},{"$f":"Intro!L35/3*Intro!R35","v":768000},{"$f":"Intro!K35*Intro!R35","v":960000},{"$f":"Intro!K35*Intro!R35","v":960000},{"$f":"Intro!K35*Intro!R35","v":960000},{"$f":"Intro!K35*Intro!R35","v":960000},0,{"$f":"Intro!K35*Intro!R35","v":960000},{"$f":"Intro!K35*Intro!R35","v":960000},{"$f":"Intro!K35*Intro!R35","v":960000},{"$f":"Intro!P35/3*Intro!R35","v":864000},{"$f":"SUM(D3:O3)","v":9888000},{"$f":"SUM(D3:I3)","v":5184000},{"$f":"SUM(J3:O3)","v":4704000}]
[null,"Income  -  Sales:","Total:",{"$f":"D2+D3","v":1171200},{"$f":"E2+E3","v":1171200},{"$f":"F2+F3","v":1171200},{"$f":"G2+G3","v":1464000},{"$f":"H2+H3","v":1464000},{"$f":"I2+I3","v":1464000},{"$f":"I2+J3","v":1464000},0,1464000,{"$f":"M2+M3","v":1413600},1413600,1317600,{"$f":"SUM(D4:O4)","v":14978400},{"$f":"Q2+Q3","v":7905600},{"$f":"R2+R3","v":7072800}]
[null,"BASE DATA:","1yr Costs:","(Materials only)",null,null,null,null,null,null,null,null,null,null,null,null,"6 Mo: Jan - Jun","6 Mo: Jul - Dec"]
[null,"Homes:","Homes p.Mo",{"$f":"Intro!K39*Intro!R39-Intro!K39*Intro!R39*20%","v":201600},{"$f":"Intro!K39*Intro!R39-Intro!K39*Intro!R39*20%","v":201600},{"$f":"Intro!K39*Intro!R39-Intro!K39*Intro!R39*20%","v":201600},{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"Intro!K39*Intro!R39","v":252000},0,{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"Intro!K39*Intro!R39","v":252000},{"$f":"SUM(D6:O6)","v":2620800},{"$f":"SUM(D6:I6)","v":1360800},{"$f":"SUM(J6:O6)","v":1260000}]
[null,"←       Halls:","Halls p.Mo",{"$f":"Intro!K41*Intro!R39-Intro!K41*Intro!R39*20%","v":448000},{"$f":"Intro!K41*Intro!R39-Intro!K41*Intro!R39*20%","v":448000},{"$f":"Intro!K41*Intro!R39-Intro!K41*Intro!R39*20%","v":448000},{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"Intro!K41*Intro!R39","v":560000},0,{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"Intro!K41*Intro!R39","v":560000},{"$f":"SUM(D7:O7)","v":5824000},{"$f":"SUM(D7:I7)","v":3024000},{"$f":"SUM(J7:O7)","v":2800000}]
[null,"Costs  -  Materials:","Total:",{"$f":"D6+D7","v":649600},{"$f":"E6+E7","v":649600},{"$f":"F6+F7","v":649600},812000,812000,812000,812000,0,{"$f":"L6+L7","v":812000},812000,812000,812000,{"$f":"SUM(D8:O8)","v":8444800},{"$f":"SUM(Q6:Q7)","v":4384800},{"$f":"SUM(R6:R7)","v":4060000}]
[" Current Online Cash Flow real data during the loan life",null,null,"Startup period + 1st Quarter",null,null,"1st Yr - 2nd Quarter",null,"TOTAL","1st Yr - 3th Quarter",null,"TOTAL","1st Yr - 4th Quarter",null,"TOTAL","2nd Yr - 1st Quarter",null,"TOTAL"]
["Data are carried by Pro Forma Budgeting below →",null,null,"Sales","Costs","$ TOTAL","Sales","Costs","$ TOTAL","Sales","Costs","$ TOTAL","Sales","Costs","$ TOTAL","Sales","Costs","$ TOTAL"]
["which will be processed by the software during the loan life"]
["From Level 1",null,"Nr of Periods",1,{"$f":"D12+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,{"$f":"Q12+1","v":15}]
[null,null,"Nr of Monts",6,{"$f":"D13+6","v":12},18,24,30,36,42,{"$f":"J13+6","v":48},54,60,66,72,78,84,90]
[null,"  Repayment periods","Date:","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","2027-12-31","2028-06-30","2028-12-31","2029-06-30","2029-12-31"]
[null,"\u0086  Own Funds",null,"Paid on import","Repaid back",null,null,null,null,"Level ②"]
[null,"\u0086  VAT of Loan's Costs -  Return↔",null,{"$f":"Intro!S51","v":1416200},{"$f":"-D16","v":-1416200}]
[null," Import DUTY of cap. goods ",null,{"$f":"Intro!R51","v":177025}]
[null,"Local operations + administration fees",null,{"$f":"Intro!R54","v":257025},null,"Values of the financial model:"]
[null,"Startup capital Investment",null,{"$f":"SUM(D16:D18)","v":1850250},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:Q21)","v":91334400}]
["Database for project development",null,"          Date:",{"$f":"D14","v":"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","2027-12-31","2028-06-30","2028-12-31","2029-06-30","2029-12-31"]
[" Sales,","Revenue Pro-forma Budget",{"$f":"SUM(D21:Q21)","v":92652000},{"$f":"D34","v":1317600},{"$f":"E34","v":7905600},7072800,7905600,7072800,7905600,7072800,7905600,{"$f":"L34","v":7072800},7905600,7072800,7905600,7072800,1464000,{"$f":"R34","v":92652000}]
["Costs,","TOTAL (in $)",{"$f":"SUM(D22:Q22)","v":7630087.7355103781},{"$f":"SUM(D23:D24)","v":96300},{"$f":"SUM(E23:E24)","v":597800},505800,530749.1,582749.1,587765.01285000006,587765.01285000006,596348.64052347501,576348.64052347501,581500.89717054192,581500.89717054192,606722.70928234421,586722.70928234421,612015.0158576559,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"Variable costs",{"$f":"SUM(D23:Q23)","v":1704600},{"$f":"D44","v":23400},140400,68400,68400,140400,140400,140400,140400,140400,140400,140400,140400,140400,140400,{"$error":"#REF!"}]
[null,"Fixed costs",{"$f":"SUM(D24:Q24)","v":5925487.7355103781},{"$f":"D50","v":72900},457400,437400,462349.1,442349.1,447365.01285,447365.01285,455948.64052347501,435948.64052347501,441100.89717054192,441100.89717054192,466322.70928234427,446322.70928234427,471615.0158576559,{"$error":"#REF!"}]
["EBT","Operating Profit (Sales - Costs):",null,{"$f":"D21-D22","v":1221300},{"$f":"E21-E22","v":7307800},{"$f":"F21-F22","v":6567000},7374850.9000000004,6490050.9000000004,7317834.9871500004,6485034.9871500004,7309251.3594765253,6496451.3594765253,7324099.1028294582,6491299.1028294582,7298877.2907176558,6486077.2907176558,851984.9841423441]
[null,"Depreciations",0.16,{"$f":"D25*C26","v":195408},{"$f":"E25*C26","v":1169248},{"$f":"F25*C26","v":1050720},{"$f":"G25*C26","v":1179976.1440000001},{"$f":"H25*C26","v":1038408.1440000001},{"$f":"I25*C26","v":1170853.597944},{"$f":"J25*C26","v":1037605.597944},{"$f":"K25*C26","v":1169480.2175162442},{"$f":"L25*C26","v":1039432.217516244},{"$f":"M25*C26","v":1171855.8564527133},{"$f":"N25*C26","v":1038607.8564527134},{"$f":"O25*C26","v":1167820.366514825},{"$f":"P25*C26","v":1037772.3665148249},{"$f":"Q25*C26","v":136317.59746277507},{"$f":"R21-R22","v":{"$error":"#REF!"}},null,{"$f":"SUM(D26:Q26)","v":13603505.962318338}]
[null,"Cash Flows (EBT)",null,{"$f":"D25-D26","v":1025892},{"$f":"E25-E26","v":6138552},5516280,6194874.7560000001,5451642.7560000001,6146981.3892060006,5447429.3892060006,6139771.1419602809,5457019.1419602809,6152243.2463767454,5452691.2463767445,6131056.9242028305,5448304.9242028305,715667.38667956903]
[null,"Annual Income tax:",0.15,{"$f":"C28*D27","v":153883.79999999999},{"$f":"C28*E27","v":920782.79999999993},{"$f":"C28*F27","v":827442},{"$f":"C28*G27","v":929231.21340000001},{"$f":"C28*H27","v":817746.41339999996},{"$f":"C28*I27","v":922047.20838090009},{"$f":"C28*J27","v":817114.40838090004},{"$f":"C28*K27","v":920965.67129404214},{"$f":"C28*L27","v":818552.8712940421},{"$f":"C28*M27","v":922836.48695651174},{"$f":"C28*N27","v":817903.68695651169},{"$f":"C28*O27","v":919658.53863042453},{"$f":"C28*P27","v":817245.7386304246},{"$f":"C28*Q27","v":107350.10800193535}]
[null,"Project's net cash inflow",{"$f":"SUM(D29:Q29)","v":60705645.356845595},{"$f":"D27-D28","v":872008.2},{"$f":"E27-E28","v":5217769.2},4688838,5265643.5426000003,4633896.3426000001,5224934.1808251003,4630314.9808251001,5218805.470666239,4638466.2706662389,5229406.7594202338,4634787.5594202327,5211398.3855724055,4631059.1855724063,608317.27867763373,{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(D29:Q29)","v":60705645.356845595},{"$f":"T29/$Q$13","v":722686.2542481618}]
["Cumulative NCFs (loan pay-off incl.) ↗",null,null,{"$f":"D29","v":872008.2},{"$f":"D30+E29","v":6089777.4000000004},{"$f":"E30+F29","v":10778615.4},{"$f":"F30+G29","v":16044258.942600001},{"$f":"G30+H29","v":20678155.2852},25903089.466025099,30533404.446850199,35752209.91751644,40390676.188182682,45620082.947602913,50254870.507023148,55466268.892595552,{"$f":"O30+P29","v":60097328.07816796},{"$f":"P30+Q29","v":60705645.356845595},{"$f":"Q30+#REF!","v":{"$error":"#REF!"}}]
[null,null,"Notes:"]
["● Prefabricated Buildings and Halls",null,null,null,"June","Decemner","June","Decemner","June","Decemner","June","Decemner","June","Decemner","June","Decemner"]
["Accounting reports at each 6 Мо:",null,null,"2022-12-31","1st half 23Yr","2nd half 23 Yr","1st half 24 Yr","2nd half 24 Yr","1st half.25 Yr","2nd half.25 Yr","1st half.26 Yr","2nd half.26 Yr","1st half.27 Yr","2nd half.27 Yr","1st half.28 Yr","2nd half.26 Yr",{"$f":"Q14","v":"2029-06-30"},"TOTAL"]
["      Sales:    ",null,null,{"$f":"D35+D36","v":1317600},{"$f":"E35+E36","v":7905600},{"$f":"F35+F36","v":7072800},{"$f":"G35+G36","v":7905600},7072800,7905600,7072800,7905600,{"$f":"L35+L36","v":7072800},7905600,7072800,7905600,7072800,{"$f":"Q35+Q36","v":1464000},{"$f":"SUM(D34:Q34)","v":92652000}]
["Complete","   • Homes: →",null,{"$f":"O2","v":453600},{"$f":"Q2","v":2721600},{"$f":"R2","v":2368800},{"$f":"Q2","v":2721600},{"$f":"R2","v":2368800},{"$f":"Q2","v":2721600},{"$f":"R2","v":2368800},{"$f":"Q2","v":2721600},{"$f":"R2","v":2368800},{"$f":"Q2","v":2721600},{"$f":"R2","v":2368800},{"$f":"Q2","v":2721600},{"$f":"R2","v":2368800},{"$f":"I2","v":504000},{"$f":"SUM(D35:Q35)","v":31500000}]
["current","                Exchange    •  Halles:  →",null,{"$f":"O3","v":864000},{"$f":"Q3","v":5184000},{"$f":"R3","v":4704000},{"$f":"Q3","v":5184000},{"$f":"R3","v":4704000},{"$f":"Q3","v":5184000},{"$f":"R3","v":4704000},{"$f":"Q3","v":5184000},{"$f":"R3","v":4704000},{"$f":"Q3","v":5184000},{"$f":"R3","v":4704000},{"$f":"Q3","v":5184000},{"$f":"R3","v":4704000},{"$f":"I3","v":960000},{"$f":"SUM(D36:Q36)","v":61152000}]
["data",null,null,{"$f":"D34","v":1317600},{"$f":"D37+E34","v":9223200},{"$f":"E37+F34","v":16296000},{"$f":"F37+G34","v":24201600},31274400,39180000,46252800,54158400,61231200,69136800,76209600,84115200,91188000,92652000]
[null,null,"Notes:"]
["OPERATIONAL AND RISK MANAGEMENT",null,null,"↑ ENTER ↑"]
[" Sales,","Current accounting reports",null,null,null,null,null,null,null,null,{"$f":"C21","v":92652000}]
["Costs,","TOTAL accounting reports"]
[0.06,"Cash Flow Statenents       ‒"]
[null,"Income data (in $),  Periods:","Date:",{"$f":"D14","v":"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","2027-12-31","2028-06-30","2028-12-31","2029-06-30","2029-12-31"]
["  For 1 Mo:","      Variable costs ",{"$f":"SUM(D44:Q44)","v":1704600},{"$f":"SUM(D45:D48)","v":23400},{"$f":"SUM(E45:E48)","v":140400},{"$f":"SUM(F45:F48)-F46","v":68400},{"$f":"SUM(G45:G48)-G46","v":68400},{"$f":"SUM(H45:H48)","v":140400},{"$f":"SUM(I45:I48)","v":140400},{"$f":"SUM(J45:J48)","v":140400},140400,{"$f":"SUM(L45:L48)","v":140400},140400,140400,140400,140400,140400,{"$f":"SUM(R45:R48)","v":{"$error":"#REF!"}}]
[3000,"Heating, running costs, telephones",null,{"$f":"A45","v":3000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000},{"$f":"A45*6","v":18000}]
[12000,"Operating expenses  ̶  packing, etc.",null,{"$f":"A46","v":12000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"A46*6","v":72000},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[400,"Other materials and services  ",null,{"$f":"A47","v":400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"A47*6","v":2400},{"$f":"$A$48*#REF!","v":{"$error":"#REF!"}}]
[8000,"Cars - fuel and maintenance   ",null,{"$f":"A48","v":8000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"A48*6","v":48000},{"$f":"P48*(1+#REF!)","v":{"$error":"#REF!"}}]
[null,"Date :",null,{"$f":"C14","v":"Date:"},{"$f":"E43","v":"2023-06-30"},{"$f":"F43","v":"2023-12-31"},{"$f":"G14","v":"2024-06-30"},"2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30","2027-12-31","2028-06-30","2028-12-31","2029-06-30","2029-12-31"]
["  Annually","      Fixed costs",{"$f":"SUM(D50:Q50)","v":5925487.7355103781},{"$f":"SUM(D51:D56)","v":72900},{"$f":"SUM(E51:E56)","v":457400},437400,462349.1,442349.1,447365.01285,447365.01285,455948.64052347501,435948.64052347501,441100.89717054192,441100.89717054192,466322.70928234427,446322.70928234427,471615.0158576559,{"$f":"SUM(R55:R57)","v":{"$error":"#REF!"}}]
[{"$f":"6800*12","v":81600},"Rent of the company field - 0.96 ha",6800,{"$f":"C51","v":6800},{"$f":"C51*6","v":40800},{"$f":"C51*6","v":40800},{"$f":"C51*6","v":40800},{"$f":"C51*6","v":40800},{"$f":"C51*6","v":40800},{"$f":"C51*6","v":40800},{"$f":"C51*6","v":40800},{"$f":"A51/2","v":40800},{"$f":"A51/2","v":40800},{"$f":"A51/2","v":40800},{"$f":"A51/2","v":40800},{"$f":"A51/2","v":40800},{"$f":"A51/2","v":40800}]
[20000,"Marketing, exhibitions  ",null,null,{"$f":"A52","v":20000},null,{"$f":"A52","v":20000},null,null,null,{"$f":"A52","v":20000},null,null,null,{"$f":"A52","v":20000},null,{"$f":"A52","v":20000}]
["  For 1 Mo:",null,"Annual increase"]
[{"$f":"Intro!O63","v":61100},"Payroll administration,              p. Mo",2.7E-2,{"$f":"A54","v":61100},{"$f":"A54*6","v":366600},{"$f":"A54*6","v":366600},{"$f":"F54+F54*2.7%/2","v":371549.1},{"$f":"F54+F54*2.7%/2","v":371549.1},{"$f":"G54+G54*2.7%/2","v":376565.01285},{"$f":"G54+G54*2.7%/2","v":376565.01285},{"$f":"J54+J54*2.7%/2","v":381648.64052347501},{"$f":"J54+J54*2.7%/2","v":381648.64052347501},{"$f":"L54+L54*2.7%/2","v":386800.89717054192},{"$f":"L54+L54*2.7%/2","v":386800.89717054192},{"$f":"N54+N54*2.7%/2","v":392022.70928234427},{"$f":"N54+N54*2.7%/2","v":392022.70928234427},{"$f":"P54+P54*2.7%/2","v":397315.0158576559}]
[3000,"Office - phones, internet,  power",null,{"$f":"A55","v":3000},{"$f":"A55*6","v":18000},{"$f":"A55*6","v":18000},{"$f":"A55*6","v":18000},{"$f":"A55*6","v":18000},{"$f":"A55*6","v":18000},{"$f":"A55*6","v":18000},{"$f":"A55/2","v":1500},{"$f":"A55/2","v":1500},{"$f":"A55/2","v":1500},{"$f":"A55/2","v":1500},{"$f":"A55/2","v":1500},{"$f":"A55/2","v":1500},{"$f":"A55/2","v":1500},{"$f":"$A$55/2","v":1500}]
[2000,"Financial reporting, cash-flow control",null,{"$f":"A56","v":2000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"D56*6","v":12000},{"$f":"$A$56/2","v":1000}]
[null,"      TOTAL Costs:",{"$f":"SUM(D57:Q57)","v":7630087.7355103781},{"$f":"D44+D50","v":96300},{"$f":"E44+E50","v":597800},{"$f":"F44+F50","v":505800},{"$f":"G44+G50","v":530749.1},{"$f":"H44+H50","v":582749.1},587765.01285000006,587765.01285000006,596348.64052347501,576348.64052347501,581500.89717054192,581500.89717054192,606722.70928234421,586722.70928234421,{"$f":"Q44+Q50","v":612015.0158576559},{"$f":"'Cap.Goods'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C44+C50","v":7630087.7355103781},{"$f":"D57","v":96300},{"$f":"D58+E57","v":694100},{"$f":"E58+F57","v":1199900},{"$f":"F58+G57","v":1730649.1},2313398.2000000002,2901163.2128500002,3488928.2257000003,4085276.8662234754,4661625.5067469506,5243126.4039174924,5824627.3010880342,6431350.0103703784,7018072.7196527226,7630087.7355103781]
["2022-12-01","Turnkey - start date of operation\nRestarted for corrections\n","Notes:"]
[null,null,null,null,"Years:",1,{"$f":"F60+1","v":2},3,4,5,6,7,null,null,null,null,"   up"]
["Level ❸","PROFITABILITY ANALYSIS",null,"Up front investment:",0,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$error":"#N/A"},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,"1-Yr period Operating Cash Flows",null,null,"Debt-Service Coverage Ratio = EBIT/Costs",{"$f":"SUM(G62:Q62)/#REF!","v":{"$error":"#REF!"}},{"$f":"(#REF!+#REF!)/G79","v":{"$error":"#REF!"}},null,{"$f":"(#REF!+#REF!)/J79","v":{"$error":"#REF!"}},{"$f":"(#REF!+#REF!)/K79","v":{"$error":"#REF!"}},{"$f":"(#REF!+#REF!)/M79","v":{"$error":"#REF!"}},{"$f":"(#REF!+#REF!)/O79","v":{"$error":"#REF!"}},{"$f":"(#REF!+#REF!)/Q79","v":{"$error":"#REF!"}}]
["Discount Cash Flow Models",null,"The Investor can make enough in operating ",null,null,{"$f":"IF(F62>=1.2,\"Good\",\"Bad\")","v":{"$error":"#REF!"}},"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","Simulation of Bed Market"]
["Discount (hurdle) rate :",null,0.1,"Loan Life Coverage Ratio",null,null,"Period:",{"$f":"D122","v":7},7.8448235023997013,null,{"$f":"IF(Bayes!C7>Bayes!C9,\"A1\",\"A2\")","v":"A1"},"Salesman","A1 share","Salesman",{"$f":"IF(Bayes!C7<Bayes!C9,\"A1 \",\"A2\")","v":"A2"}]
["Net Present Value (NPV for CADS) :",null,{"$f":"NPV(C66,E61:K61)","v":{"$error":"#REF!"}},"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:",{"$f":"A122","v":{"$error":"#REF!"}},"earliness",null,null,80,0.65,20]
["IRR :",null,{"$f":"IRR(E61:K61)","v":{"$error":"#VALUE!"}},0.14000000000000001,"LLCR =",{"$f":"C67/C78","v":{"$error":"#REF!"}},null,"Accelerated amortization of loans",null,null,"  Good sales",null,{"$f":"Intro!P6","v":"2022-08-18"},"                   Bad sales"]
[null,"Commercial bank, Own funds (Loan \"D\")",{"$f":"SUM(D69+E69)","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!L35","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!M35","v":{"$error":"#REF!"}},0,null,"Update £  it now.",null,null,null,null,". Correction factor or Area of critical announcement"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L67>90,N67>60),\" STOP! Calm down. You've just entered a field of dreams!\",Bayes!P21)","v":1.9999999999999996}]
[null,{"$f":"O17","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C14","v":"Date:"},{"$f":"E14","v":"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","2027-12-31","2028-06-30","2028-12-31","2029-06-30","2029-12-31"]
[null,"LOANS              Number of Periods",{"$f":"C13","v":"Nr of Monts"},null,null,{"$f":"E13","v":12},18,24,30,36,42,48,54,60,66,72,78,{"$f":"P13","v":78}]
[null," Nr. of periods",{"$f":"MATCH(50,E73:R73)","v":14},null,{"$f":"D12","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14]
[null," Nr. of principal period repayments",{"$f":"MATCH(50,G74:R74)","v":12},null,null,null,{"$f":"D12","v":1},2,null,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Startup capital Investment",null,{"$f":"D19","v":1850250},{"$f":"C76","v":1850250},{"$f":"D76","v":1850250},{"$f":"E76","v":1850250},{"$f":"F76-F78","v":1850250},{"$f":"G76-G78","v":{"$error":"#REF!"}},{"$f":"H76-H78","v":{"$error":"#REF!"}},{"$f":"I76-I78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"K76-K78","v":{"$error":"#REF!"}},{"$f":"L76-L78","v":{"$error":"#REF!"}},{"$f":"M76-M78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"P76-P78","v":{"$error":"#REF!"}},{"$f":"Q76-Q78","v":{"$error":"#REF!"}}]
[{"$f":"SUM(D77:Q77)","v":{"$error":"#REF!"}},"\u0085  Interest payments",{"$f":"'Cap.Goods'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"-ROUND(IPMT($C$77/2,G74,$C$74,F76),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$77/2,H74,$C$74,G76),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$77/2,I74,$C$74,H76),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(IPMT($C$77/2,R74,$C$74,Q76),0)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G77:R77)","v":{"$error":"#REF!"}}]
[null," Principal installments",{"$f":"ROUND(SUM(D78:Q78),0)","v":{"$error":"#REF!"}},null,null,null,{"$f":"-ROUND(PPMT($C$77/2,G74,$C$74,$C$76),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(PPMT($C$77/2,R74,$C$74,($C$76-$D$78-$F$78)),0)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G78:R78)","v":{"$error":"#REF!"}}]
[null,"Installments, TOTAL:",null,{"$f":"SUM(D77:D78)","v":0},{"$f":"SUM(E77:E78)","v":0},{"$f":"SUM(F77:F78)","v":0},{"$f":"SUM(G77:G78)","v":{"$error":"#REF!"}},{"$f":"SUM(H77:H78)","v":{"$error":"#REF!"}},{"$f":"SUM(I77:I78)","v":{"$error":"#REF!"}},{"$f":"SUM(J77:J78)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(L77:L78)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(O77:O78)","v":{"$error":"#REF!"}},{"$f":"SUM(P77:P78)","v":{"$error":"#REF!"}},{"$f":"SUM(Q77:Q78)","v":{"$error":"#REF!"}},{"$f":"SUM(R77:R78)","v":{"$error":"#REF!"}}]
["Diversification following from Risk Assessment"]
["OPERATIONAL TEST }  Balance liabilities",null,{"$f":"C18","v":0},{"$f":"D18","v":257025},{"$f":"D81+E18","v":257025},{"$f":"E81+#REF!","v":{"$error":"#REF!"}},{"$f":"F81-F83","v":{"$error":"#REF!"}},{"$f":"G81-G83","v":{"$error":"#REF!"}},{"$f":"H81-H83","v":{"$error":"#REF!"}},{"$f":"I81-I83","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Q81-Q83","v":{"$error":"#REF!"}}]
[{"$f":"SUM(D82:Q82)","v":{"$error":"#REF!"}},"\u0085  Interest payments",{"$f":"'Cap.Goods'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"-ROUND(IPMT($C$82/2,E73,$C$73,D81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$82/2,F73,$C$73,E81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$82/2,G73,$C$73,F81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$82/2,H73,$C$73,G81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$82/2,I73,$C$73,H81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$82/2,J73,$C$73,I81),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(IPMT($C$82/2,R73,$C$73,Q81),0)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G82:R82)","v":{"$error":"#REF!"}}]
[null," Principal installments",{"$f":"ROUND(SUM(D83:Q83),-1)","v":{"$error":"#REF!"}},null,null,null,{"$f":"-ROUND(PPMT($C$82/2,G74,$C$74,$C$81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$82/2,H74,$C$74,$C$81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$82/2,I74,$C$74,$C$81),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$82/2,J74,$C$74,$C$81),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(PPMT($C$82/2,R74,$C$74,$C$81),0)","v":{"$error":"#REF!"}}]
[null,"Installments, TOTAL:",null,{"$f":"SUM(D81:D83)","v":257025},{"$f":"SUM(E82:E83)","v":{"$error":"#REF!"}},{"$f":"SUM(F82:F83)","v":{"$error":"#REF!"}},{"$f":"SUM(G82:G83)","v":{"$error":"#REF!"}},{"$f":"SUM(H82:H83)","v":{"$error":"#REF!"}},{"$f":"SUM(I82:I83)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(P82:P83)","v":{"$error":"#REF!"}},{"$f":"SUM(Q82:Q83)","v":{"$error":"#REF!"}},{"$f":"SUM(R82:R83)","v":{"$error":"#REF!"}}]
["Diversification following from Risk Assessment"]
["OPERATIONAL TEST }  Balance liabilities",null,{"$f":"C69","v":{"$error":"#REF!"}},{"$f":"D69","v":{"$error":"#REF!"}},{"$f":"D86+E69","v":{"$error":"#REF!"}},{"$f":"E86+F69","v":{"$error":"#REF!"}},{"$f":"F86-F88","v":{"$error":"#REF!"}},{"$f":"G86-G88","v":{"$error":"#REF!"}},{"$f":"H86-H88","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Q86-Q88","v":{"$error":"#REF!"}}]
[{"$f":"ROUND(SUM(D87:Q87),-1)","v":{"$error":"#REF!"}},"\u0085  Interest payments",{"$f":"'Cap.Goods'!L37","v":5.5E-2},null,{"$f":"-ROUND(IPMT($C$87/2,E73,$C$73,D86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$87/2,F73,$C$73,E86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$87/2,G73,$C$73,F86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$87/2,H74,$C$74,G86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$87/2,I74,$C$74,H86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$87/2,J74,$C$74,I86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$87/2,K74,$C$74,J86),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(IPMT($C$87/2,R74,$C$74,Q86),0)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G87:R87)","v":{"$error":"#REF!"}}]
[null," Principal deferred payments",{"$f":"C69","v":{"$error":"#REF!"}},null,null,null,{"$f":"-ROUND(PPMT($C$87/2,G74,$C$74,$C$86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$87/2,H73,$C$73,$C$86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$87/2,I73,$C$73,$C$86),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(PPMT($C$87/2,Q73,$C$73,$C$86),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$87/2,R73,$C$73,$C$86),0)","v":{"$error":"#REF!"}}]
[null,"Installments, TOTAL:",null,null,{"$f":"SUM(E87:E88)","v":{"$error":"#REF!"}},{"$f":"SUM(F87:F88)","v":{"$error":"#REF!"}},{"$f":"SUM(G87:G88)","v":{"$error":"#REF!"}},{"$f":"SUM(H87:H88)","v":{"$error":"#REF!"}},{"$f":"SUM(I87:I88)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(R87:R88)","v":{"$error":"#REF!"}}]
[]
[{"$f":"A77+A82+A87","v":{"$error":"#REF!"}},"GRAPHS",null,1,{"$f":"D91+1","v":2},{"$f":"E91+1","v":3},{"$f":"F91+1","v":4},{"$f":"G91+1","v":5},6,7,8,9,10,11,12,{"$f":"O91+1","v":13},{"$f":"P91+1","v":14},{"$f":"Q91+1","v":15}]
[null,"Costs",null,{"$f":"D58","v":96300},{"$f":"E58","v":694100},{"$f":"F58","v":1199900},{"$f":"G58","v":1730649.1},2313398.2000000002,2901163.2128500002,3488928.2257000003,4085276.8662234754,4661625.5067469506,5243126.4039174924,5824627.3010880342,6431350.0103703784,7018072.7196527226,7630087.7355103781,{"$f":"R76","v":{"$error":"#REF!"}}]
[null,"OPERATING PERIOD } Total balance liabilities \"A\"","IN OPERATION",{"$f":"D76","v":1850250},{"$f":"E76","v":1850250},{"$f":"F76","v":1850250},{"$f":"G76","v":1850250},{"$f":"H76","v":{"$error":"#REF!"}},{"$f":"I76","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"R76","v":{"$error":"#REF!"}}]
[null,"Cash",null,{"$f":"D34","v":1317600},{"$f":"E34","v":7905600},{"$f":"F34","v":7072800},7905600,7072800,7905600,7072800,7905600,7072800,7905600,7072800,7905600,7072800,1464000,92652000]
[null,"Net Income",null,{"$f":"D30","v":872008.2},{"$f":"F30","v":10778615.4},{"$f":"G30","v":16044258.942600001},{"$f":"H30","v":20678155.2852},{"$f":"I30","v":25903089.466025099},30533404.446850199,35752209.91751644,40390676.188182682,45620082.947602913,50254870.507023148,55466268.892595552,60097328.07816796,60705645.356845595,{"$f":"Q30","v":60705645.356845595},{"$f":"R30","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,"NCFs (loan pay-off incl.) ↗"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Debt Rate",{"$f":"D93/$C$19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Start date"]
[null,"Auxiliary rows: Crossing point of cash and debt",{"$f":"D71","v":"Date:"},1,{"$f":"D114+1","v":2},{"$f":"E114+1","v":3},{"$f":"F114+1","v":4},{"$f":"G114+1","v":5},6,7,8,9,10,{"$f":"M114+1","v":11},{"$f":"N114+1","v":12},{"$f":"O114+1","v":13},{"$f":"P114+1","v":14}]
[null,"Payback   >   cumulate OCFs",{"$f":"MATCH(A118,#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D115+#REF!","v":{"$error":"#REF!"}},{"$f":"E115+#REF!","v":{"$error":"#REF!"}},{"$f":"F115+#REF!","v":{"$error":"#REF!"}},{"$f":"G115+#REF!","v":{"$error":"#REF!"}},{"$f":"H115+#REF!","v":{"$error":"#REF!"}},{"$f":"I115+#REF!","v":{"$error":"#REF!"}},{"$f":"J115+#REF!","v":{"$error":"#REF!"}},{"$f":"K115+#REF!","v":{"$error":"#REF!"}},{"$f":"L115+#REF!","v":{"$error":"#REF!"}},{"$f":"M115+#REF!","v":{"$error":"#REF!"}},{"$f":"N115+#REF!","v":{"$error":"#REF!"}},{"$f":"O115+#REF!","v":{"$error":"#REF!"}},{"$f":"P115+#REF!","v":{"$error":"#REF!"}}]
[null,"repayment estimation row",{"$f":"DATE(YEAR(C114)+C115,MONTH(C114)+2,DAY(C114+7))","v":{"$error":"#VALUE!"}},{"$f":"CHOOSE(C115,E71,F71,G71,H71,I71,J71,K71,L71,M71,N71,O71,P71,Q71)","v":{"$error":"#REF!"}},{"$f":"C115*6","v":{"$error":"#REF!"}},{"$f":"E116/12","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(F116,0)","v":{"$error":"#REF!"}},{"$f":"G116-F116","v":{"$error":"#REF!"}},{"$f":"H116*12","v":{"$error":"#REF!"}}]
[null,"auxiliary row","Payback date",null,{"$f":"(D116-E71)/12","v":{"$error":"#REF!"}},{"$f":"ROUNDDOWN(E117,0)","v":{"$error":"#REF!"}},{"$f":"E117-F117","v":{"$error":"#REF!"}},{"$f":"G117*12","v":{"$error":"#REF!"}},{"$f":"IF(H117=12,F117+1,F117)","v":{"$error":"#REF!"}},{"$f":"IF(H117=12,0,H117)","v":{"$error":"#REF!"}}]
[{"$f":"C77","v":{"$error":"#REF!"}},"Base forecast"]
[{"$f":"D122*365+1+E122*30+4","v":{"$error":"#REF!"}},"Yr:",null,1,2,3,4,5,6,7,8]
[{"$f":"A119/(365+1)","v":{"$error":"#REF!"}},"AnnNCinF",null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"D20","v":"2022-12-31"},"Copulative",null,{"$f":"D120","v":{"$error":"#REF!"}},{"$f":"D121+E120","v":{"$error":"#REF!"}},{"$f":"E121+F120","v":{"$error":"#REF!"}},{"$f":"F121+G120","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"A121+A119","v":{"$error":"#REF!"}},"Period",null,{"$f":"COUNTIF(D121:J121,\"<\"&A118)","v":7},{"$f":"F122*12/10","v":{"$error":"#REF!"}},{"$f":"(A118-HLOOKUP(COUNTIF(D121:J121,\"<\"&A118),D119:J121, 3,0))/(HLOOKUP(COUNTIF(D121:J121,\"<\"&A118)+1,D119:J121,2,0))*12","v":{"$error":"#REF!"}}]
[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(D126:O126)","v":1}]

{"sheet":"Bayes","index":3,"n_rows":48,"n_cols":17,"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!G4","v":"Prefabricated Buildings and Halls\nsteel structures "}]
[]
["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 \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 \"Bayes5\".",null,null,null,null,null,null,null,null,null,null,null,null,"5 Events"]
[]
[" Event A1: part of QUANTITY for Salesman A1 →",null,{"$f":"BUDGET!M67","v":0.65}," 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.35}," 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!L67/100","v":0.8}," 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!N67/100","v":0.2}," 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 product 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.65},{"$f":"1-C11","v":0.19999999999999996},{"$f":"C7","v":0.65},null,"From Salesman A1:",null,{"$f":"D18*E18/(D18*E18+D20*E20)","v":0.65},null,{"$f":"C18","v":0.65},{"$f":"D18","v":0.19999999999999996},{"$f":"K18*L18","v":0.12999999999999998},{"$f":"M18/M21","v":0.65}]
[]
[null,"Salesman A2",{"$f":"C9","v":0.35},{"$f":"C13","v":0.2},{"$f":"1-E18","v":0.35},null,"From Salesman A2:",null,{"$f":"D20*E20/(D18*E18+D20*E20)","v":0.35000000000000003},null,{"$f":"C20","v":0.35},{"$f":"D20","v":0.2},{"$f":"K20*L20","v":6.9999999999999993E-2},{"$f":"M20/M21","v":0.35000000000000003}]
["ANALYSIS:","On relative basis: the probability of the Bad event, coming from Salesman А2 [",null,null,null,{"$f":"N20","v":0.35000000000000003},"] compared [",{"$f":"N18","v":0.65},"] from Good A1.",null,{"$f":"K18+K20","v":1},"To the new  info given each event",{"$f":"SUM(M18:M20)","v":0.19999999999999996},{"$f":"N18+N20","v":1},null,{"$f":"M21*10+O21*1","v":1.9999999999999996}]
[null,"There is a greater likelihood Bad event to be observed because outcome as [ ",null,null,null,{"$f":"M20","v":6.9999999999999993E-2},"] following  [",{"$f":"N20","v":0.35000000000000003},"] A2 Bad event could be a crash.",null,null,null,"Overall <probability of Bad event ="]
[]
["CLOSING:",6]
[]
["       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":"Prefabricated Buildings and Halls\nsteel structures "},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":"Bayes5","index":4,"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":"      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"]