{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Intro","Cap.Goods","Budget","Bayes","Invest","X","Y"],"not_rendered":{"charts":2,"images":87,"macros":1,"external_links":3,"defined_names":60,"comments":2,"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":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[20,23,25,23],[2,21,3,22],[37,14,75,35],[37,0,75,13],[0,6,1,9],[2,14,2,15],[2,8,3,10],[0,10,1,19],[16,16,17,18],[16,19,17,22]]}
[null,null,null,null,null,null,"Project: SEA RESORT ",null,null,null,"①st STAGE 8 HOMES with extension ②nd STAGE up to 25 HOMES plus CAFÉ-RESTAURANT"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO-FORMA BUDGET FOR 8 HOMES",null,null,null,null,"OPERATING INSTRUCTIONS",null,"Level 0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USD",null,null,null,"(recommended)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▪ HOMES & CABINS",{"$f":"ROUND(Invest!P43,-3)","v":2226000},null,1,"\u0085  Read the NOTE"]
[null,null,null,null,null,null,null,null,null,"BUSINESS PLAN",2,null,null,null,"▪ CONSTRUCTION",{"$f":"ROUND(Invest!P47,-3)","v":449000},null,{"$f":"R5+1","v":2},"Change",null,"if you so desire  - select on Option Button below"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▪ PICKUP CAR  & COMPUTER",{"$f":"Cap.Goods!F11+Cap.Goods!F18","v":54500},null,{"$f":"R6+1","v":3},"\u0085  Look and note these data of the project"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▪ ARCHITECTURAL DESIGN",{"$f":"Cap.Goods!F16","v":12000},null,{"$f":"R7+1","v":4},"Switch over to other projects here\u0086\u0086   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▪ FIN. MODEL & CONTROL",{"$f":"Cap.Goods!F17","v":24000},null,{"$f":"R8+1","v":5},"To study whichever project run the sequences, on the  right MENU ↓ and "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP. GOODS & SERVISES:",{"$f":"SUM(P5:P9)","v":2765500},null,null,null,null,null,null,null,"Level   MENU ↑  ."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Û   LAND FOR ALL PROJECTS:",{"$f":"Invest!P54","v":1638400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▪ TAX FOR LAND ",{"$f":"Cap.Goods!F31","v":204800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▪ COST OF PERMITS",{"$f":"Cap.Goods!F32","v":24000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADMINISTRATIVE EXPENSES:",{"$f":"SUM(P12:P13)","v":228800},null,"To go from one worksheet to another use dedicated buttons only (recommended)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"ROUND((P10+P11+P14),-3)","v":4633000}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MENU",null,null,"HIERARCHIC STRUCTURE - PORTAL SECTION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 6",null,null,"NOT AVAILABLE"," Û  Risk Management."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Select from MENU and then browse."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 5",null,null,"NOT AVAILABLE"," Û  Risk Assessmsnt - ecserpt of",null,null,"Feedback"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"demo version of financial risk of the project"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 4",null,null," Bayes - Decision Analyses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Posterior Probabilities for Sensitivity Analyses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 3",null,null,"Investment Planning and Financial Modelong"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(extract a part of VBA-software program)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 2",null,null," Budget - Cash Flows, Measuring Profitability."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensitivity Analyses as a transition to upper level."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1",null,null," Cap.Goods and Services. Capital investment"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 0",null,null,"       What the Investor desires to achieve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       and how mush does it cost - the present level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The revenues, depending on the demand, are fixed in Sheet \"Budget\" "]
[]
[null,null,null,null,null,null,null,null,null,"N NOTE. ANY ATTEMPT TO SAFE THE WORKBOOK A NEW NAME IN THE Save As DIALOG BOX OR WITH SOME CHANGES WILL GENERATE "]
[null,null,null,null,null,null,null,null,null,"HAZARDOUS TEMPLATES DUE TO THE FIREWALL SYSTEM WE USUALLY APPLY THAT MAY CAUSE  IRREPARABLE DAMAGES ON YOUR PC SYSTEM "]

{"sheet":"Cap.Goods","index":1,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[28,0,32,0],[4,0,11,0],[13,0,19,0],[22,0,26,0],[4,6,11,6],[22,6,26,6],[13,6,19,6],[25,5,26,5],[13,12,19,12],[1,7,1,9],[2,7,2,9],[28,6,32,6],[5,9,6,9],[8,9,9,9],[22,12,26,12],[4,12,11,12],[28,12,30,12],[14,9,17,9]]}
[null,null,"Level 1",null,null,null,null,"Mariner",{"$f":"Intro!$K$6","v":2}]
[null,null,"CAPITAL GOODS AND SERVIVES",null,null,null,null,"Nr of Mos:",null,null,{"$f":"Budget!$C$14","v":6},{"$f":"Budget!$D$14","v":12}]
[null,null,null,null,null,null,null,"Date:",null,null,{"$f":"Budget!C15","v":"2014-06-30"},{"$f":"Budget!D15","v":"2014-12-31"}]
[null,"A. u","EXPORT VALUE  u",null,"%","USD",null,null,"CASH PAYMENTS u",null,"Advance",null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," \u0082"]
[null,{"$f":"B24","v":24},null,{"$f":"IF(B24<10,\"HOMES & CABINS - U.S. CONTENT:\",\"HOMES, CABINS + RESTAURANT, U.S.:\")","v":"HOMES, CABINS + RESTAURANT, U.S.:"},{"$f":"Invest!M43","v":0.93458659634531527},{"$f":"Invest!L43","v":2124600},null,null,"Homes & Cabins",0.15,{"$f":"F6*J6","v":318690},{"$f":"F6-K6","v":1805910}]
[null,null,null," ↑  ELIGIBLE FOREIGN CONTENT:",{"$f":"Invest!O43","v":6.541340365468476E-2},{"$f":"Invest!N43","v":101400},null,null,null,null,{"$f":"F7*J6","v":15210},{"$f":"F7-K7","v":86190}]
[null,null,null,"SubTOTAL:",{"$f":"SUM(E6:E7)","v":1},{"$f":"SUM(F6:F7)","v":2226000},null,null,"Front payment, subTOTAL:",null,{"$f":"SUM(K6:K7)","v":333900},{"$f":"SUM(L6:L7)","v":1892100}]
[null,null,null,"DODGE PICKUP - U.S. CONTENT:",{"$f":"E11-E10","v":0.9},{"$f":"E9*F11","v":45900},null,null,"Motor car",0.15,{"$f":"F9*J9","v":6885},{"$f":"F9-K9","v":39015}]
[null,null,null," ↑  ELIGIBLE FOREIGN CONTENT:",0.1,{"$f":"E10*F11","v":5100},null,null,null,null,{"$f":"F10*J9","v":765},{"$f":"F10-K10","v":4335}]
[null,null,null,"SubTOTAL:",1,51000,null,null,"Front payment, subTOTAL:",null,{"$f":"SUM(K9:K10)","v":7650},{"$f":"SUM(L9:L10)","v":43350}]
[null,null,null,"TOTAL:",null,{"$f":"F8+F11","v":2277000},null,null,"Loan\"B\", TOTAL:",null,{"$f":"K8+K11","v":341550},{"$f":"L8+L11","v":1935450},null,{"$f":"SUM(K12:L12)","v":2277000}]
[null,"B. u","LOCAL COUNTRY COSTS  u",null,null,"USD",null,null,"Payment Manner",null,"Advance","Settlement"]
["*",null,null,null,null,null,"*"]
[null,"Turnkey construction",null,null,null,{"$f":"Invest!P47","v":449140},null,null,null,0.15,{"$f":"$F$15*J15","v":67371},{"$f":"F15-K15","v":381769}]
[null,"Architectural design of Mariner 2",null,null,null,12000,null,null,null,null,{"$f":"F16*J15","v":1800},{"$f":"F16-K16","v":10200}]
[null,"AAS*, financial model, risk assessment & online  control",null,null,null,{"$f":"Invest!P48","v":24000},null,null,null,null,{"$f":"F17*J15","v":3600},{"$f":"F17-K17","v":20400}]
[null,"Set PC Lenovo  / monitor Dell",null,null,null,3500,null,null,null,null,{"$f":"F18*J15","v":525},{"$f":"F18-K18","v":2975}]
[null,null,null,"Local  costs in the supply contract, TOTAL:",{"$f":"F19/F23","v":0.1766824315529136},{"$f":"SUM(F15:F18)","v":488640},null,null,null,"Advance payment,* TOTAL:",{"$f":"SUM(K15:K18)","v":73296},{"$f":"SUM(L15:L18)","v":415344},null,{"$f":"SUM(K19:L19)","v":488640}]
[null,{"$f":"Invest!C48","v":"Advisory & Assistance Service and Software:"},null,null,null,null,null,"These payments require warranties"]
[null,"A.+B.",null,null,"LOAN \"A\" PURCHASE ORDER(S) u","USD",null,null,null,null,{"$f":"K12+K19","v":414846},{"$f":"L12+L19","v":2350794}]
[]
[null,null,null,"U.S. Supply Contracts, TOTAL:",null,{"$f":"F12+F19","v":2765640},null,null,null,null,"Net contract price financed:",{"$f":"SUM(L12+K19+L19)","v":2424090},null,{"$f":"N12+N19","v":2765640}]
[null,{"$f":"Invest!D47","v":24},"homes",null,null,null,null,null,null,null,"Ex-Im Bank LOAN \"A\", TOTAL:",{"$f":"ROUNDUP(L23,-4)","v":2430000}]
[null,"Accrued interest against political & commercial risks     \u0080",null,null,null,{"$f":"F24-F23","v":-2765640},null,null,"\u0085    \u0085    Reserve","\u0085  Reserve \u0086",null,{"$f":"L24-L23","v":5910}]
[null,"FINANCIAL COST,     annual interest: ",null,null,4.2000000000000003E-2,{"$f":"E26+E27","v":4.2000000000000003E-2}]
[null,"Ex-Im Bank fees: commitment, facility, exposure:",null,null,0]
[null,"Other local costs (outside this Budget) \u0086",null,null,null,"USD",null," u DEPRECIATION ON ASSETS u",null,null,null,"USD"]
[]
[null,"Purchase of land                           sq.m.",null,{"$f":"Invest!F50","v":30000},{"$f":"Invest!G50","v":40},{"$f":"Invest!P54","v":1638400},null,null,{"$f":"I6","v":"Homes & Cabins"},0.15,{"$f":"Invest!P43+Invest!P47","v":2675140},{"$f":"J30*K30","v":401271}]
[null,"Tax, p. sq.m.",null,{"$f":"Invest!O54","v":32000},5,{"$f":"D31*E31*Invest!B45","v":204800},null,null,"Pickup motor car",0.13,{"$f":"F10","v":5100},{"$f":"J31*K31","v":663}]
[null,"Cost of permits",null,"Total:","Mos:",{"$f":"Invest!F48","v":24000},null,null," KEY NOTE:"]
[null,{"$f":"Invest!D74","v":5},"Personnel salaries & benefits",{"$f":"Invest!G74","v":5140},{"$f":"L2-K2","v":6},{"$f":"D33*E33","v":30840},null,null,"1. Gradient fill effect ","XXX","cells are in-put data recipients; contain first-involved figures."]
[null,null,null,null,"Other local country expemses. TOTAL:",{"$f":"SUM(F30:F33)","v":1898040},null,null,"         All the rest represemt computed results."]
[null,null,null,null,null,null,null,null,"2. The note icons         ","provide  interactive  URL-links to business dictionary."]
[null,null,null,null,null,null,null,null,"3. The  magnifier     ","provide  interactive absolute URL-links to external data sources."]
[null,null,null,null,null,null,null,null,"4. The info icons    ","provide references to the Project Executive Summary (memo/bizPlan)."]
[null,null,null,null,null,null,null,null,"     5. The column and >",null," table borders outline specific data-based areas. "]
[null,null,null,null,null,null,null,null,"     6.  Various font and  background colors represent similar resource data."]

{"sheet":"Budget","index":2,"n_rows":107,"n_cols":20,"rows_kept":107,"cut":false,"hidden":false,"merged":[[63,9,63,13],[62,12,62,13],[61,11,62,11],[0,14,1,15],[69,2,70,3],[7,9,7,10],[0,3,0,6],[0,7,0,11],[7,7,7,8],[7,11,7,12],[62,9,62,10],[45,2,46,3],[56,8,61,8],[56,9,56,13],[58,1,58,4],[58,9,58,10],[58,12,58,13],[1,6,1,11]]}
["Part of Level 0 \u0086","Exhibit A.","Cash-flow ","Pro-forma Credit Application",null,null,null,"MARKETABLE PRICE LIST - Part of Level 0",null,null,null,null,null,null,"SEASONAL TIME PRICING"]
["Level 2   Business Plan, Budget","USD",null,null,null,null,"Rent of one-bed room home p. day and p. week  (incl. daily  welcome package)",null,null,null,null,null,1,{"$f":"Invest!B45","v":1.28}]
[{"$f":"Cap.Goods!D23","v":"U.S. Supply Contracts, TOTAL:"},{"$f":"Cap.Goods!F23","v":2765640},null,null,null,null,"01/01-04/30","05/01-05/21","05/22-06/11","06/12-07/02","07/03-08/27","08/28-09/17","09/18-10/15","10/16-12/31","Weeks:","Seasons:"]
["U.S. Content",{"$f":"ROUND((Cap.Goods!F6+Cap.Goods!F9),-1)","v":2170500},null,null,null,"Weeks:",17,3,3,3,8,3,4,11,{"$f":"SUM(I4:L4)","v":17},"\u0085 Active weeks"]
["Eligible Foreign Content",{"$f":"ROUND((Cap.Goods!F7+Cap.Goods!F10),-1)","v":106500},null,null,null,"Homes",40,100,200,240,300,240,80,40,{"$f":"SUM(M4:N4)+SUM(G4:H4)","v":35},"\u0085 Inactive weeks"]
["U.S. Export Value",{"$f":"ROUND((B4+B5),-2)","v":2277000},null,null,null,"Prc p.Night",{"$f":"G$5*$N$2","v":51.2},128,256,307.2,384,307.2,102.4,51.2,{"$f":"O4+O5","v":52},"\u0085 Total weeks"]
["Cash Payment (Loan \"B\")",{"$f":"ROUND(Cap.Goods!K12,-2)","v":341600},null,null,null,"min 1 week",{"$f":"G6*(1-$N$9)","v":50.688000000000002},{"$f":"H6*(1-$N$9)","v":126.72},{"$f":"I6*(1-$N$9)","v":253.44},304.12799999999999,380.15999999999997,304.12799999999999,{"$f":"M6*(1-$N$9)","v":101.376},{"$f":"N6*(1-$N$9)","v":50.688000000000002},"\u0085 Prc with ann. inflation"]
["Net Contract Prc Financed",{"$f":"ROUND((B6-B7),-1)","v":1935400},null,null,null,"per Home","k","05/01-06/30",null,"07/01-08/31",null,"09/01-09/30",null,"Ann. inflation"]
["Local Country Costs",{"$f":"ROUND(Cap.Goods!F19,-1)","v":488640},null,null,null,null,null,null,null,"Rent of two-bed bungalow € p. day +  extra small child bed",null,null,null,{"$f":"O9/100","v":0.01},1]
["Ex-Im Bank Financed Amount",{"$f":"ROUND((B8+B9),-1)","v":2424040},null,null,null,null,"Days:",21,21,27,56,21,28,{"$f":"SUM(H10:M10)","v":174}]
["Other Local Country Expenses",{"$f":"Cap.Goods!F34","v":1898040},null,null,null,"Bungalows",null,60,150,200,220,180,50,6," set-off"]
["TOTAL DEBT:",{"$f":"ROUND((B3+B11),-3)","v":4664000},null,null,null,"Prc p.Night",null,{"$f":"H11*$N$2","v":76.8},{"$f":"I11*$N$2","v":192},{"$f":"J11*N2","v":256},{"$f":"K11*N2","v":281.60000000000002},{"$f":"L11*N2","v":230.4},{"$f":"M11*$N$2","v":64},"extra bed"]
["Level 2",null,null,null,null,"per Room","k",{"$f":"H12*(1-$N$9)","v":76.031999999999996},{"$f":"I12*(1-$N$9)","v":190.07999999999998},253.44,278.78399999999999,228.096,63.36,null,"\u0085 Prc with ann. inflation"]
["End of Month:",0,6,12,18,24,{"$f":"F14+6","v":30},36,42,48,54,60,66,72,78,{"$f":"O14+6","v":84},{"$f":"P14+6","v":90},96]
["Date :","2013-12-31","2014-06-30","2014-12-31","2015-06-30","2015-12-31","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"]
["End of Period:","6 Mo",null,null,1,{"$f":"E16+1","v":2},{"$f":"F16+1","v":3},{"$f":"G16+1","v":4},5,6,7,8,9,10,11,{"$f":"O16+1","v":12},{"$f":"P16+1","v":13},14]
["Capital Investment:",{"$f":"SUM(C17:D17)","v":2765640},{"$f":"SUM(C18:C19)","v":414846},{"$f":"SUM(D18:D19)","v":2350794},{"$f":"IF((B3-B17)=0,TRUE,FALSE)","v":true}]
[" ¡ Ex-Im Bank Loan \"A\" ",{"$f":"SUM(C18:D18)","v":2350794},null,{"$f":"Cap.Goods!L21","v":2350794}]
[" ¡ Comm. Bank Loan \"B\"",{"$f":"ROUND(SUM(C19:D19),-1)","v":414850},{"$f":"Cap.Goods!K21","v":414846}]
["Sales:                                                 Homes:",{"$f":"Invest!D45","v":11},{"$f":"B20*(1-Bayes!P21/100)","v":10.548999999999999},{"$f":"B20*L4*L7+C20*(M4*M7+N4*N7)*7","v":81152.349696000005},{"$f":"(C20*(G4*G7+H4*H7)+(B20+2)*(I4*I7+J4*J7))*7","v":243918.43660799999},{"$f":"((B20+2)*(K4*K7+L4*L7)+C20*(M4*M7+N4*N7))*7","v":430899.549696},{"$f":"E20","v":243918.43660799999},{"$f":"F20","v":430899.549696},{"$f":"G20","v":243918.43660799999},{"$f":"F20","v":430899.549696},{"$f":"I20","v":243918.43660799999},430899.549696,243918.43660799999,430899.549696,243918.43660799999,{"$f":"N20","v":430899.549696},{"$f":"O20","v":243918.43660799999},{"$f":"P20","v":430899.549696},{"$f":"O20","v":243918.43660799999},{"$f":"SUM(D20:P20)","v":4130060.2675199998}]
["OCCUPATION    Bedrooms:",{"$f":"Invest!D46","v":22},{"$f":"B21*(1+Bayes!P21/100)","v":22.901999999999997},{"$f":"B20*L10*L13+C20*M10*M13","v":71404.945919999998},{"$f":"B20*(H10*H13+I10*I13)+C20*J10*J13","v":133657.41311999998},{"$f":"B20*(K10*K13+L10*L13)+C20*M10*M13","v":243135.88991999999},{"$f":"E21","v":133657.41311999998},{"$f":"F21","v":243135.88991999999},{"$f":"G21","v":133657.41311999998},243135.88991999999,133657.41311999998,243135.88991999999,133657.41311999998,243135.88991999999,133657.41311999998,{"$f":"N21","v":243135.88991999999},133657.41311999998,{"$f":"P21","v":243135.88991999999},{"$f":"O21","v":133657.41311999998},{"$f":"SUM(D21:P21)","v":2332164.7641599998}]
["TOTAL:","more",null,{"$f":"SUM(D20:D21)","v":152557.29561600002},{"$f":"SUM(E20:E21)","v":377575.849728},{"$f":"SUM(F20:F21)","v":674035.43961600005},377575.849728,674035.43961600005,377575.849728,674035.43961600005,377575.849728,674035.43961600005,377575.849728,674035.43961600005,377575.849728,674035.43961600005,377575.849728,674035.43961600005,{"$f":"SUM(S20:S21)","v":377575.849728},{"$f":"SUM(D22:P22)","v":6462225.0316800009}]
["Less:                                        Date:",{"$f":"B15","v":"2013-12-31"},{"$f":"C15","v":"2014-06-30"},"2014-12-31",{"$f":"E15","v":"2015-06-30"},{"$f":"F15","v":"2015-12-31"},{"$f":"G15","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",{"$f":"P15","v":"2020-12-31"},{"$f":"Q15","v":"2021-06-30"},"2021-12-31","00:00:00"]
["Costs, TOTAL (1¡ - 8)",null,{"$f":"C25+SUM(C32:C38)","v":3.2000000000000001E-2},42897.05,46686.827549183996,445619.98631884798,47373.707549184001,386447.79647884797,48392.167709184003,336336.79486396798,49443.218594304002,293933.73475241184,50527.903107747843,258088.54623903587,51647.297525621885,227823.8657867194,{"$f":"Q25+SUM(Q32:Q38)","v":45888.412564867904},197596.15221565877,{"$f":"S25+SUM(S32:S38)","v":-10101.487435132094}]
["1) Remuneration of services (fixed costs)",null,null,{"$f":"SUM(D26:D31)","v":1800},{"$f":"SUM(E26:E31)","v":3532.7275491840001},{"$f":"SUM(F26:F31)","v":4122.1063188480002},3232.7275491840001,4122.1063188480002,3232.7275491840001,4122.1063188480002,3232.7275491840001,4122.1063188480002,3232.7275491840001,4122.1063188480002,3232.7275491840001,{"$f":"SUM(P26:P31)","v":4122.1063188480002},{"$f":"SUM(Q26:Q31)","v":3232.7275491840001},4122.1063188480002,{"$f":"SUM(S26:S31)","v":-23767.272450815999}]
["     ▪  Business trips, p.Mo:",150,null,{"$f":"B26*(D14-C14)","v":900},{"$f":"B26*(E14-D14)","v":900},{"$f":"$B$26*(F14-E14)","v":900},900,900,900,900,900,900,900,900,900,{"$f":"$B$26*(P14-O14)","v":900},{"$f":"$B$26*(Q14-P14)","v":900},900,{"$f":"$B$26*(S14-P14)","v":-12600}]
["     ▪  Accounting,p.Mo:",100,null,null,{"$f":"B27*(E14-D14)","v":600},{"$f":"$B$27*(F14-E14)","v":600},600,600,600,600,600,600,600,600,600,{"$f":"$B$27*(P14-O14)","v":600},{"$f":"$B$27*(Q14-P14)","v":600},600,{"$f":"$B$27*(S14-P14)","v":-8400}]
["     ▪  GSM & Internet, p.Mo:",50,null,{"$f":"B28*(D14-C14)","v":300},{"$f":"B28*(E14-D14)","v":300},{"$f":"$B$28*(F14-E14)","v":300},300,300,300,300,300,300,300,300,300,{"$f":"$B$28*(P14-O14)","v":300},{"$f":"$B$28*(Q14-P14)","v":300},300,{"$f":"$B$28*(S14-P14)","v":-4200}]
["     ▪  Fuel consuption bills, p.Mo:",100,null,{"$f":"B29*(D14-C14)","v":600},{"$f":"B29*(E14-D14)","v":600},{"$f":"$B$28*(F14-E14)","v":300},{"$f":"F29","v":300},{"$f":"G29","v":300},{"$f":"H29","v":300},300,300,300,300,300,300,{"$f":"O29","v":300},{"$f":"P29","v":300},300,{"$f":"P29","v":300}]
["     ▪  Washing & disinfectants, etc., p.Mo:"]
["     ▪  Others-security, etc. as % of sales p.a.",3.0000000000000001E-3,null,null,{"$f":"$B$31*E22","v":1132.7275491840001},{"$f":"$B$31*F22","v":2022.1063188480002},{"$f":"$B$31*G22","v":1132.7275491840001},2022.1063188480002,1132.7275491840001,2022.1063188480002,1132.7275491840001,2022.1063188480002,1132.7275491840001,2022.1063188480002,1132.7275491840001,2022.1063188480002,{"$f":"$B$31*Q22","v":1132.7275491840001},2022.1063188480002,1132.7275491840001]
["2) Depreciations",null,null,null,null,{"$f":"Cap.Goods!L30","v":401271},null,{"$f":"(Cap.Goods!K30-Budget!F32)*Cap.Goods!J30","v":341080.35},null,{"$f":"Cap.Goods!J30*(Cap.Goods!K30-Budget!F32-Budget!H32)","v":289918.29749999999},null,{"$f":"Cap.Goods!J30*(Cap.Goods!K30-Budget!F32-Budget!H32-Budget!J32)","v":246430.55287499999},null,{"$f":"Cap.Goods!J30*(Cap.Goods!K30-Budget!F32-Budget!H32-Budget!J32-Budget!L32)","v":209465.96994374998},null,{"$f":"Cap.Goods!J30*(Cap.Goods!K30-Budget!F32-Budget!H32-Budget!J32-Budget!L32-Budget!N32)","v":178046.07445218749},null,{"$f":"Cap.Goods!J30*(Cap.Goods!K30-Budget!F32-Budget!H32-Budget!J32-Budget!L32-Budget!N32-Budget!N32)","v":146626.17896062499}]
["3) Insurance policies,  p.a.:",2.5000000000000001E-3,null,{"$f":"B33*Cap.Goods!F23/2","v":3457.05},{"$f":"B33*Cap.Goods!F23","v":6914.1},null,{"$f":"E33","v":6914.1},null,{"$f":"G33","v":6914.1},null,{"$f":"I33","v":6914.1},null,{"$f":"K33","v":6914.1},null,{"$f":"M33","v":6914.1},null,null,null,{"$f":"O33","v":6914.1}]
["4) Control system operation fee, p.Mo:",500,null,{"$f":"B34*6","v":3000},{"$f":"$B$34*6","v":3000},{"$f":"$B$34*6","v":3000},3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,{"$f":"O34*(1+$C$35)","v":3096}]
["5) Payroll personnel + ann. inflation  set-off ",{"$f":"Invest!G74","v":5140},3.2000000000000001E-2,{"$f":"B35*(D14-C14)","v":30840},{"$f":"$B$35*6","v":30840},{"$f":"B35*(1+$C$35)*6","v":31826.880000000005},{"$f":"F35","v":31826.880000000005},{"$f":"F35*(1+$C$35)","v":32845.340160000007},{"$f":"H35","v":32845.340160000007},{"$f":"H35*(1+$C$35)","v":33896.391045120006},33896.391045120006,34981.075558563847,34981.075558563847,36100.469976437889,36100.469976437889,{"$f":"N35*(1+$C$35)","v":37255.685015683906},{"$f":"O35*(1+$C$35)","v":37255.685015683906},38447.86693618579,{"$f":"O35*(1+$C$35)","v":37255.685015683906}]
["6) Annual tax of land &  properties:",3000,null,{"$f":"B36","v":3000},null,{"$f":"D36","v":3000},null,{"$f":"F36","v":3000},null,{"$f":"H36","v":3000},null,{"$f":"J36","v":3000},null,{"$f":"L36","v":3000},null,{"$f":"N36","v":3000},{"$f":"O36","v":0},3000]
["7) Electricity consumption bill  (var.), p.Mo:",300,null,{"$f":"B37*2","v":600},{"$f":"$B$37*(E14-D14)","v":1800},1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,{"$f":"$B$37*(P14-O14)","v":1800},{"$f":"$B$37*(Q14-P14)","v":1800},1800,{"$f":"$B$37*(S14-P14)","v":-25200}]
["8) Water consumption bill  (var. costs), p.Mo:",100,null,{"$f":"B38*2","v":200},{"$f":"$B$38*(E14-D14)","v":600},600,600,600,600,600,600,600,600,600,600,{"$f":"$B$38*(P14-O14)","v":600},{"$f":"$B$38*(Q14-P14)","v":600},600,{"$f":"$B$38*(S14-P14)","v":-8400}]
["Cash Flows:",null,{"$f":"C22-C24","v":-3.2000000000000001E-2},109660.24561600001,{"$f":"E22-E24","v":330889.02217881603},228415.45329715207,330202.14217881602,287587.64313715207,329183.68201881601,337698.64475203207,328132.63113369601,380101.70486358821,327047.94662025216,415946.89337696414,325928.55220237811,446211.57382928068,{"$f":"Q22-Q24","v":331687.43716313213},476439.28740034124,387677.33716313209]
["Less: Interests, loans \"A\"",null,null,null,{"$f":"-E70","v":-49367},{"$f":"-F70","v":-43418},-37738,-32350,-27276,-22542,-18174,-14199,-10646,-7545,-4929,{"$f":"-P70","v":-2830},{"$f":"-Q70","v":-1284},-328]
["Interests, Loan \"B\" bonds (independent computing)",null,{"$f":"-C76","v":-12445.38},{"$f":"-D76","v":-12445.38},{"$f":"-E76","v":-12445},{"$f":"-F76","v":-10544},-8748,-7072,-5528,-4134,-2903,-1855,-1009,-383,-79511.759999999995]
["EBT",null,null,{"$f":"D39+D40+D41","v":97214.86561600001},{"$f":"E39+E40+E41","v":269077.02217881603},{"$f":"F39+F40","v":184997.45329715207},{"$f":"G39+G40","v":292464.14217881602},255237.64313715207,301907.68201881601,315156.64475203207,309958.63113369601,365902.70486358821,316401.94662025216,408401.89337696414,320999.55220237811,{"$f":"P39+P40","v":443381.57382928068},{"$f":"Q39+Q40","v":330403.43716313213},476111.28740034124,{"$f":"S39+S40","v":387677.33716313209}]
["Less: Income tax",0.25,null,{"$f":"$B$43/2*D42","v":12151.858202000001},{"$f":"$B$43/2*E42","v":33634.627772352003},{"$f":"$B$43/2*F42","v":23124.681662144008},36558.017772352003,31904.705392144009,37738.460252352001,39394.580594004008,38744.828891712001,45737.838107948526,39550.24332753152,51050.236672120518,40124.944025297264,{"$f":"$B$43/2*P42","v":55422.696728660085},{"$f":"$B$43/2*Q42","v":41300.429645391516},59513.910925042655,{"$f":"$B$43/2*S42","v":48459.667145391511}]
["         Advance deposit"]
["EAT",null,null,{"$f":"D42-(D43+D44)","v":85063.007414000007},{"$f":"E42-(E43+E44)","v":235442.39440646401},{"$f":"F42-(F43+F44)","v":161872.77163500804},255906.12440646402,223332.93774500806,264169.221766464,275762.06415802805,271213.802241984,320164.86675563967,276851.70329272066,357351.65670484363,280874.60817708087,{"$f":"P42-(P43+P44)","v":387958.87710062059},{"$f":"Q42-(Q43+Q44)","v":289103.0075177406},416597.3764752986,{"$f":"S42-(S43+S44)","v":339217.67001774057}]
["Add: Total depreciations",null,"TIME ZERO — NEGATIVE PROJECT CASH FLOW",null,null,{"$f":"F32","v":401271},null,{"$f":"H32","v":341080.35},null,{"$f":"J32","v":289918.29749999999},null,{"$f":"L32","v":246430.55287499999},null,{"$f":"N32","v":209465.96994374998},null,{"$f":"P32","v":178046.07445218749},{"$f":"Q32","v":0},146626.17896062499]
["Add: Tax advance deposited drawn back"]
[" ► Operating Cash Flows",null,null,{"$f":"SUM(D45:D47)","v":85063.007414000007},{"$f":"SUM(E45:E47)","v":235442.39440646401},{"$f":"SUM(F45:F47)","v":563143.77163500804},255906.12440646402,564413.28774500801,264169.221766464,565680.36165802809,271213.802241984,566595.41963063972,276851.70329272066,566817.62664859358,280874.60817708087,{"$f":"SUM(P45:P47)","v":566004.95155280805},{"$f":"SUM(Q45:Q47)","v":289103.0075177406},563223.55543592363,{"$f":"SUM(S45:S47)","v":339217.67001774057}]
["Less: Capital investment",null,{"$f":"-C17","v":-414846},{"$f":"-D17","v":-2350794}]
[" ► Project's Net Cash Flows (NCFs)",null,{"$f":"C48+C49","v":-414846},{"$f":"D48+D49","v":-2265730.9925859999},{"$f":"E48+E49","v":235442.39440646401},{"$f":"F48+F49","v":563143.77163500804},255906.12440646402,564413.28774500801,264169.221766464,565680.36165802809,271213.802241984,566595.41963063972,276851.70329272066,566817.62664859358,280874.60817708087,{"$f":"P48+P49","v":566004.95155280805},{"$f":"Q48+Q49","v":289103.0075177406},563223.55543592363,{"$f":"S48+S49","v":339217.67001774057}]
["Less: Principal installments, Loan \"A\"",null,null,null,{"$f":"-E71","v":-146183},{"$f":"-F71","v":-149253},{"$f":"-G71","v":-152387},-155587,-158854,-162190,-165596,-169074,-172624,-176250,-179951,{"$f":"-P71","v":-183730},{"$f":"-Q71","v":-187588},-191527]
["Less: Principal installments, Loan \"B\"",null,null,null,{"$f":"-E77","v":-29798},{"$f":"-F77","v":-30692},-31613,-32561,-33538,-34544,-35580,-36648,-37747,{"$f":"-N77","v":-38880},{"$f":"-O77","v":-341601}]
["Cash",null,{"$f":"C50+C51+C52","v":-414846},{"$f":"D50+D51+D52","v":-2265730.9925859999},{"$f":"E50+E51","v":89259.394406464009},{"$f":"F50+F51","v":413890.77163500804},103519.12440646402,408826.28774500801,105315.221766464,403490.36165802809,105617.802241984,397521.41963063972,104227.70329272066,390567.62664859358,100923.60817708087,{"$f":"P50+P51","v":382274.95155280805},{"$f":"Q50+Q51","v":101515.0075177406},371696.55543592363,{"$f":"S50+S51","v":339217.67001774057}]
["Cumulate NCFs (loan pay-off incl.)",null,{"$f":"C50","v":-414846},{"$f":"C54+D53","v":-2680576.9925859999},{"$f":"D54+E53","v":-2591317.5981795359},{"$f":"E54+F53","v":-2177426.8265445279},{"$f":"F54+G53","v":-2073907.702138064},-1665081.414393056,-1559766.192626592,-1156275.8309685639,-1050658.0287265799,-653136.60909594013,-548908.90580321942,-158341.27915462584,{"$f":"N54+O53","v":-57417.670977544971},{"$f":"O54+P53","v":324857.28057526308},{"$f":"P54+Q53","v":426372.28809300368},798068.8435289273,{"$f":"P54+S53","v":664074.95059300365}]
[null,"Years:",null,null,1,{"$f":"E55+1","v":2},{"$f":"F55+1","v":3},4,5,6,7,8]
["1-Yr period Operating Cash Flows",null,"Up front investment:",null,{"$f":"C50+D50","v":-2680576.9925859999},{"$f":"E50+F50","v":798586.166041472},{"$f":"G50+H50","v":820319.41215147206},{"$f":"I50+J50","v":829849.58342449204},{"$f":"K50+L50","v":837809.22187262378},{"$f":"M50+N50","v":843669.32994131418},{"$f":"O50+P50","v":846879.55972988892},{"$f":"Q50+R50","v":852326.56295366422}]
["Exhibit B",null,null,null,null,null,null,null,null,"Exhibit C",null,null,null,null,"\u0085  Go to Bayes \u0086","\u0086"]
["Discount Cash Flow Model",null,"Section",null,null,null,"Section",null,null,null,null,"Section \"SENSITIVITY ANALYSIS\""]
[null,"MEASURING PROFITABILITY",null,null,null,null,"PAYBACK PERIOD",null,null,"Simulation of A1 activity",null,null,"Simulation of A2 activity"]
["Discount (hurdle) rate :",0.12,"Loan Life Coverage Ratio:",null,null,null,"METHOD",null,null,null,"Occupation",{"$f":"IF((K61+M61)/100<121%,\"\",\"STOP\")","v":""},"Occupation"]
["Net Present Value (NPV for CADS) :",{"$f":"NPV(B60,E56:K56)","v":640437.14986556978},"LLCR=",{"$f":"B61/B68","v":0.27243439870340397},null,"Period:",{"$f":"F73+ROUNDDOWN(E106,0)","v":7},{"$f":"H106","v":6},null,{"$f":"IF(AND(K61<35,M61>45),\" Change the agency now\",\"\")","v":""},55,{"$f":"IF((K61+M61)/100<121%,(K61+M61)/100,\"120%\")","v":1.05},50,{"$f":"IF(AND(K61>44,M61<31),\" Change the agency now\",\"\")","v":""}]
["IRR :",{"$f":"IRR(E56:K56)","v":0.20910658613639832},null,null,null,"Date:",{"$f":"C106","v":"2019-12-31"},"earliness",null,null,null,{"$f":"IF(AND(K61<31,M61<31),\"M\",\"\")","v":""}]
[null,null,null,null,null,null,"Accelerated amortization of loans",null,null,{"$f":"IF(AND(K61<36,M61>58),\" This agency is dud!\",\"\")","v":""},null,null,{"$f":"IF(AND(K61>58,M61<35),\" This agency is dud!\",\"\")","v":""}]
["          .docx format - for more detaIs",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K61<36,M61<31),\"EVENT FOR CRITICAL ANNOUNCEMENT\",\"\")","v":""}]
[{"$f":"A14","v":"End of Month:"},0,6,12,{"$f":"E14","v":18},24,30,36,42,48,54,60,66,72,78,84]
[{"$f":"A15","v":"Date :"},"2013-12-31","2014-06-30","2014-12-31",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E15","v":"2015-06-30"},"2015-12-31","2016-06-30","2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31",{"$f":"O15","v":"2020-06-30"}]
["Number of Periods:",{"$f":"MATCH(50,E67:R67)","v":14},null,null,{"$f":"E16","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14]
["  º»  Ex-Im Bank LOAN \"A\"",{"$f":"B18","v":2350794}]
["6-Mo Balance liabilities",null,{"$f":"C18","v":0},{"$f":"C69+D18","v":2350794},{"$f":"D69-D71","v":2350794},{"$f":"E69-E71","v":2204611},{"$f":"F69-F71","v":2055358},{"$f":"G69-G71","v":1902971},{"$f":"H69-H71","v":1747384},1588530,1426340,1260744,1091670,919046,742796,{"$f":"O69-O71","v":562845},{"$f":"P69-P71","v":379115},{"$f":"Q69-Q71","v":191527}]
["6-Mo Interest payment",{"$f":"Cap.Goods!F26","v":4.2000000000000003E-2},"TIME ZERO -      INVESTMENT PERIOD",null,{"$f":"-ROUND(IPMT($B$70/2,E67,$B$67,E69),0)","v":49367},{"$f":"-ROUND(IPMT($B$70/2,F67,$B$67,F69),0)","v":43418},37738,32350,27276,22542,18174,14199,10646,7545,4929,{"$f":"-ROUND(IPMT($B$70/2,P67,$B$67,P69),0)","v":2830},{"$f":"-ROUND(IPMT($B$70/2,Q67,$B$67,Q69),0)","v":1284},328,{"$f":"ROUND(SUM(E70:P70),-1)","v":271010}]
["6-Mo Principal installments",null,null,null,{"$f":"-ROUND(PPMT($B$70/2,E67,$B$67,$B$68),0)","v":146183},{"$f":"-ROUND(PPMT($B$70/2,F67,$B$67,$B$68),0)","v":149253},152387,155587,158854,162190,165596,169074,172624,176250,179951,183730,187588,191527,{"$f":"ROUND(SUM(E71:R71),-1)","v":2350790}]
["Installments, TOTAL:",null,null,null,{"$f":"SUM(E70:E71)","v":195550},192671,190125,187937,186130,184732,183770,183273,183270,183795,184880,{"$f":"SUM(P70:P71)","v":186560},null,null,{"$f":"ROUND(SUM(E72:P72),-1)","v":2242690}]
[{"$f":"A67","v":"Number of Periods:"},{"$f":"MATCH(50,E73:N73)","v":10},null,null,{"$f":"E67","v":1},2,3,4,5,6,7,8,9,10]
["  º»  Comm. Bank LOAN \"B\"",{"$f":"B7","v":341600},{"$f":"C14","v":6},12,{"$f":"E14","v":18},24,30,36,42,48,54,60,66,72]
["6-Mo Balance liabilities",{"$f":"B19","v":414850},{"$f":"C19","v":414846},{"$f":"C75+D19","v":414846},{"$f":"D75-D77","v":414846},{"$f":"E75-E77","v":385048},{"$f":"F75-F77","v":354356},{"$f":"G75-G77","v":322743},{"$f":"H75-H77","v":290182},256644,222100,186520,149872,112125]
["6-Mo Interest payment",0.06,{"$f":"B76/12*C65*C75","v":12445.38},{"$f":"B76/12*(D65-C65)*D75","v":12445.38},{"$f":"-ROUND(IPMT($B$76/2,E73,$B$73,D75),0)","v":12445},{"$f":"-ROUND(IPMT($B$76/2,F73,$B$73,F75),0)","v":10544},8748,7072,5528,4134,2903,1855,1009,383,{"$f":"SUM(C76:N76)","v":79511.759999999995}]
["6-Mo Principal installments",null,null,null,{"$f":"-ROUND(PPMT($B$76/2,E73,B73,B74),0)","v":29798},{"$f":"-ROUND(PPMT($B$76/2,F73,$B$73,$B$74),0)","v":30692},{"$f":"-ROUND(PPMT($B$76/2,G73,$B$73,$B$74),0)","v":31613},{"$f":"-ROUND(PPMT($B$76/2,H73,$B$73,$B$74),0)","v":32561},{"$f":"-ROUND(PPMT($B$76/2,I73,$B$73,$B$74),0)","v":33538},34544,35580,36648,37747,38880,{"$f":"SUM(E77:N77)","v":341601}]
["Installments, TOTAL:",null,{"$f":"SUM(C76:C77)","v":12445.38},{"$f":"SUM(D76:D77)","v":12445.38},{"$f":"SUM(E76:E77)","v":42243},{"$f":"SUM(F76:F77)","v":41236},{"$f":"SUM(G76:G77)","v":40361},{"$f":"SUM(H76:H77)","v":39633},39066,38678,38483,38503,38756,39263,{"$f":"SUM(C78:N78)","v":421112.76}]
[]
["GRAPHS",null,1,{"$f":"C80+1","v":2},{"$f":"D80+1","v":3},4,5,6,7,8,9,10,11,12,13,{"$f":"O80+1","v":14},{"$f":"P80+1","v":15},16]
["Total balance liabilities,  Loan \"A\"",null,{"$f":"C69","v":0},{"$f":"D69","v":2350794},{"$f":"E69","v":2350794},2204611,2055358,1902971,1747384,1588530,1426340,1260744,1091670,919046,742796,{"$f":"P69","v":562845},{"$f":"Q69","v":379115},191527]
["Total balance liabilities,  Loans \"A\"+\"B\"",null,{"$f":"C69+C75","v":414846},2765640,2765640,2589659,2409714,2225714,2037566,1845174,1648440,1447264,1241542,1031171,742796,562845,{"$f":"Q69+Q75","v":379115},191527]
["Cash",null,{"$f":"C53","v":-414846},{"$f":"D53","v":-2265730.9925859999},89259.394406464009,413890.77163500804,103519.12440646402,408826.28774500801,105315.221766464,403490.36165802809,105617.802241984,397521.41963063972,104227.70329272066,390567.62664859358,100923.60817708087,382274.95155280805,{"$f":"Q53","v":101515.0075177406},371696.55543592363]
["Cash Cumulative",null,{"$f":"C83","v":-414846},{"$f":"C84+D83","v":-2680576.9925859999},{"$f":"D84+E83","v":-2591317.5981795359},{"$f":"E84+F83","v":-2177426.8265445279},-2073907.702138064,-1665081.414393056,-1559766.192626592,-1156275.8309685639,-1050658.0287265799,-653136.60909594013,-548908.90580321942,-158341.27915462584,-57417.670977544971,{"$f":"O84+P83","v":324857.28057526308},{"$f":"P84+Q83","v":426372.28809300368},798068.8435289273]
["Operating cash cumulative",null,{"$f":"D105","v":85063.007414000007},{"$f":"E105","v":320505.401820464},{"$f":"F105","v":883649.1734554721},1139555.297861936,1703968.585606944,1968137.807373408,2533818.1690314361,2805031.9712734199,3371627.3909040596,{"$f":"M105","v":3648479.0941967801},4215296.7208453733,4496171.3290224541,{"$f":"P105","v":5062176.2805752624},{"$f":"Q105","v":5351279.2880930025},{"$f":"R105","v":5914502.8435289264},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Debt Rate",{"$f":"C82/$B$12","v":8.8946397941680966E-2},0.59297598627787307,0.59297598627787307,0.55524421097770149,0.51666252144082336,0.47721140651801031,0.43687092624356777,0.3956204974271012,0.35343910806174955,0.31030531732418526,0.26619682675814749,0.22109155231560892,0.15926157804459692,0.12067860205831904]
[{"$f":"A12","v":"TOTAL DEBT:"},{"$f":"$B$12","v":4664000}]
["Auxiliary raws: Crossing point of cash and debt",null,null,"Nr of 6-Mo periods:",1,{"$f":"E104+1","v":2},{"$f":"F104+1","v":3},4,5,6,7,8,9,10,11,{"$f":"O104+1","v":12},{"$f":"P104+1","v":13},14]
["Payback   >   cumulate OCFs",{"$f":"MATCH(B103,E105:P105)","v":11},null,{"$f":"D48","v":85063.007414000007},{"$f":"D105+E48","v":320505.401820464},{"$f":"E105+F48","v":883649.1734554721},1139555.297861936,1703968.585606944,1968137.807373408,2533818.1690314361,2805031.9712734199,3371627.3909040596,3648479.0941967801,4215296.7208453733,4496171.3290224541,{"$f":"O105+P48","v":5062176.2805752624},{"$f":"P105+Q48","v":5351279.2880930025},5914502.8435289264]
["repayment estimation row",null,{"$f":"CHOOSE(B105,E66,F66,G66,H66,I66,J66,K66,L66,M66,N66,O66,P66)","v":"2019-12-31"},{"$f":"B105*6","v":66},{"$f":"D106/12","v":5.5},{"$f":"ROUNDUP(E106,0)","v":6},{"$f":"F106-E106","v":0.5},{"$f":"G106*12","v":6}]
["auxiliary row",null,null,{"$f":"(C106-D66)/12","v":152.16666666666666},{"$f":"ROUNDDOWN(D107,0)","v":152},{"$f":"D107-E107","v":0.16666666666665719},{"$f":"F107*12","v":1.9999999999998863},{"$f":"IF(G107=12,E107+1,E107)","v":152},{"$f":"IF(G107=12,0,G107)","v":1.9999999999998863}]

{"sheet":"Bayes","index":3,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[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],[9,7,12,15],[28,1,30,15],[28,16,29,16],[30,16,31,16],[31,1,32,15],[34,10,36,15],[13,16,13,17],[48,0,50,0],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,45,15],[45,1,45,2],[45,5,45,6],[40,1,42,15],[15,6,15,8],[15,13,15,14],[17,16,18,16],[20,11,21,11],[23,1,24,15],[25,0,26,15],[26,16,27,16]]}
[null,"DECISION ANALYSES",null,null,null,null,null,null,null,null,null,"Name of Project"]
[null,"POSTERIOR PROBABILITIES OF TWO EVENTS",null,null,null,null,null,null,"Level 4",null,null,"Project: SEA RESORT "]
[]
["Background:","Condition: You are a service provider holiday on the beach of Corfu, where you have one local and one foreign agent, and they do not connect each other in any way."]
["Historical Info: ","Enter new data below \u0088   from ",null,". If the events of interest (your agents) are more then 2 up to 5, get started next spreadsheet \u0086  ",null,null,null,null,null,null,null,"5 events"]
[]
[" Event A1 supplied QUANTITY:","Agent A1 (booking)",{"$f":"IF(Budget!L61>120,Budget!K61*120%/(Budget!K61+Budget!M61),Budget!K61/100)","v":0.55000000000000004}," Percentage Good event (G) supplied to",null,null,null,"The mutually exclusive events for which posterior probabilities are desired."]
[null,null,null,null,null,null,null,null,null,null,null,"My event:"]
[" Event A2 supplied QUANTITY:","Agent A2 (booking)",{"$f":"IF(Budget!L61>120,Budget!M61*120%/(Budget!K61+Budget!M61),Budget!M61/100)","v":0.5}," Percentage Good event (G) supplied to",null,null,"prior bad probability","Two stage development investment project for log homes village on the east coast of Corfu with option for expansion"]
[null,null,null,null,null,null,null," The periodic services, provided byy Agent Ai  raises randomly. Bad trade by A1 ∩ A2 Agents may cause respective.decline in revenue and increase of the default risk of the business. What is the probability the causer to be A1 U A2 Agent? And if the posterior probability one only Agent A2 to be indicated of doind partially bad trade, his raised index reduces next period quantities till his prompt qualification or change."]
[" Event A1 sold QUALITY:","Agent A1  (booking)",0.98," Percentage Good event (G) sold products and paid off"]
[]
[" Event A2 sold QUALITY:","Agent A2  (booking)",0.94," Percentage Good event (G) sold products and paid off"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Budget"]
["Safe Event",null,"QUALITY AGENCY EVENTS",null,"PRIOR PROBABILITY",null,"POSTERIOR",null,null,null,"TABULAR APPROACH"]
["Restore Model","When U pay - cry"," Percentage Good Intervention (G)","Percentage Bad Intervention (B)","QUANTITY % from A1∩A2 Agents",null," PROBABILITIES            that Bad Part of agency is:",null,null,null,"A1U A2 Prior Probabilities","B Conditional Probabilities","Joint  Bad A1,2 ∩B","Posterior Probabilities",null,"Others cry"]
[]
["Clean Model","Agent A1",{"$f":"C7*100","v":55.000000000000007},{"$f":"100%-C11","v":2.0000000000000018E-2},{"$f":"C11*100","v":98},null,"From Agent A1:",null,{"$f":"D18*C7/(D18*C7+D20*C9)","v":0.26829268292682928},null,{"$f":"C18/100","v":0.55000000000000004},{"$f":"D18","v":2.0000000000000018E-2},{"$f":"K18*L18","v":1.1000000000000012E-2},{"$f":"M18/M21","v":0.26829268292682928}]
[]
[null,"Agent A2",{"$f":"C9*100","v":50},{"$f":"100%-C13","v":6.0000000000000053E-2},{"$f":"100-E18","v":2},null,"From Agent A2:",null,{"$f":"(100%-C13)*C9/((100%-C11)*C7+(100%-C13)*C9)","v":0.73170731707317072},null,{"$f":"C20/100","v":0.5},{"$f":"D20","v":6.0000000000000053E-2},{"$f":"K20*L20","v":3.0000000000000027E-2},{"$f":"M20/M21","v":0.73170731707317072}]
["ANALYSIS:","On relative basis the probability of the Bad event, coming from A2, is expected [",null,null,null,{"$f":"N20","v":0.73170731707317072},"] compared [",{"$f":"N18","v":0.26829268292682928},"] from Agent 1.",null,{"$f":"SUM(K18:K20)","v":1.05},"To the new  info given each event",{"$f":"SUM(M18:M20)","v":4.1000000000000036E-2},{"$f":"SUM(N18:N20)","v":1},null,{"$f":"(M21*1+O21*1)*100","v":4.1000000000000032}]
[null,"There is a greater likelihood the Bad event to happen whereat the outcome  [ ",null,null,null,{"$f":"M20","v":3.0000000000000027E-2},"] following [",{"$f":"L20/10","v":6.0000000000000053E-3},"] A2's Bad agency to be a crash.",null,null,null,"Overall<probability of happen Bad event"]
[]
["CLOSING:","In this Chapter is applied Bayes' theorem used extensively in decision analysis of already made Risk Assessment, where the prior probabilities were subjective estimates requiring this specialized audit. The information and posterior probabilities are computed for use of 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 recommendable that to start an investment project the investor (and his team making Inside Risk Expertise) must be convinced, must believe in the good end, and he must act decisively, without any hesitation. Very often, this reflects in 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” expertise. It follows the High Qualified Audit, in this program recognized as Group D)."]
[]
[]
[null,"Sample of comments of our clients in this issue: \". . . default risk assessment is the starting point, most frequently happened to us for argue with the lenders, very often ending with denial of funding, no matter what the reason has been finally stated. Look at the picture below, which is the most popular example of visible delusion.\n\n\n"]
[]
[]
[null,null," We are looking out to the markets, and don’t see a big risk to get unable to pay back out 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 ourselves, see plenty of risks and talk only about that."]
[]
[null,"In decision making for new investments never believe and follow: ① your intuition, based on long-term experience; ② suggestions of high level experts; and ③ chance of occurring."]
[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 final decision."]
[null,"Admission of the Default Risk (d ) assessment is a key factor for positive resolution of a loan application. The system, called OCFCS (for short), that we recommend, is an instrument that serves post factum an in-vestment in development providing current information to the lender, insurer and to the investor. Intention for its implementation is positive influence, but not critical."]
[]
[]
[]
["RECORD:","PROJECT NAME",null,"QUALITY",null,"QUANTITY",null,"The event . . . "]
[null,"(or Investor Name)",null,"AGENT A1","AGENT A2","AGENT A1"]
[null,null,{"$f":"L2","v":"Project: SEA RESORT "},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":"Invest","index":4,"n_rows":74,"n_cols":29,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,23,2,25],[2,20,2,21],[1,20,1,21],[20,2,20,3],[28,13,28,14],[20,13,20,14],[14,13,14,14],[28,11,28,12],[3,17,3,19],[0,2,0,3],[36,2,36,3],[36,4,36,5],[28,2,28,3],[7,2,7,3],[10,2,10,3],[18,2,18,3],[19,2,19,3],[23,4,23,15],[28,4,28,5],[10,7,10,10],[20,7,20,10],[20,4,20,5],[10,11,10,12],[10,13,10,14],[20,11,20,12],[67,3,68,3],[67,4,68,4],[39,4,39,11],[36,11,36,12],[67,5,68,7],[58,6,58,8],[58,9,58,14],[36,13,36,14],[39,13,39,14],[36,7,36,10],[32,13,32,14],[24,13,24,14],[0,13,0,14],[4,13,4,14],[31,4,31,15],[0,11,0,12],[13,4,13,15],[3,4,3,15],[0,7,0,10],[0,4,0,5],[28,7,28,10],[10,4,10,5]]}
[null,"Level 5","Ordered ",null,"CATALOG",null,null,"SELLING Prc CIF, USD",null,null,null,"U.S. CONTENT",null,"FOREIGN  CONTENT",null,"TOTAL",null,"\u0085 This is Mariner",null,null,null,null,"Project",null,null,null,"     RUN NEXT \u0082"]
["Nr",null,"Plans","Nr","Sq Ft","m2","Prc/m2 Avrg",0,"Luxury",1,"Good","USD","%","Single","Total","U.S. Export",null,10.76,null,null,null,null,null,"Save in \u0086"]
[1,"To see customization click the home >","      more",{"$f":"H3+J3","v":3},972,{"$f":"E3/$R$2","v":90.334572490706321},{"$f":"(I3+K3)/2/F3","v":774.89711934156378},1,82000,2,58000,{"$f":"H3*(I3-N3)+J3*(K3-N3)","v":185400},{"$f":"1-O3","v":0.93818334735071485},4200,{"$f":"(N3/I3+N3/K3)/2","v":6.1816652649285111E-2},{"$f":"I3*H3+J3*K3","v":198000},null,1]
[null,null,"Stories:",1,"\u0080 HOST COUNTRY EXPENSES \u0080 ",null,null,null,null,null,null,null,null,null,null,null,null," \u0087  Home numbers"]
[null,null,"Baths:",2,null,null,null,null,"TURNKEY (single)",null,null,null,"Site work","TOTAL HOST COUNTRY",null,"SUB-TOTAL",null,"R Select  number of homes."]
[null,null,"Bedrooms:",2,"Basement","Foundation","Building",null,"Rough el.",null,"Others","Rough plumb.","(suitably)","Single","%","USD",null,"R Go to button to enter the selected number for specific type of home and quality level."]
[null,null,"W15.2 x  D 9.7","m",0,300,2000,null,600,null,null,600,{"$f":"D3*F3*$M$57/F43","v":4630.1553623981927},{"$f":"SUM(F7:M7)","v":8130.1553623981927},{"$f":"N7/K3","v":0.14017509245514126},{"$f":"D3*N7+E7","v":24390.466087194578},null,"R Click the button for Luxury or Good quality.",null,null,null,null,null,null,null,null,null,null,"OPERATING INSTRUCTIONS"]
[null,null,"Customized option: ",null,"Living room to be divided into 2 parts. Rear and part of the kitchen to form a second bedroom with",null,null,null,null,null,null,null,null,"Gross profit:",{"$f":"E58","v":0.6},null,null,0,null,null,null,null,null,null,null,null,null,null,"Select raw with the desired "]
[null,null,null,null,"bath. French windows and a sliding door for direct connection with the porch.",null,null,null,null,null,null,null,null,null,"(Suggested price) For sale:",{"$f":"ROUNDDOWN(Budget!$B$12*Invest!F3/Invest!$F$43*(1+$O$8),-3)","v":248000},null,1,2,1,3,1,3,1,10,1,1,null,"number and types of homes"]
[null,null,"~\u0080  To see customization click home icons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,1,3,1,3,1,10,1,1,2226000]
[2,"To see customization click the home icon >","Ordered ",null,"CATALOG",null,null,"SELLING Prc CIF, USD",null,null,null,"U.S. CONTENT",null,"FOREIGN  CONTENT",null,"TOTAL"]
[null,null,"Plans","Nr","Sq Ft","m2","Prc/m2 Avrg",1,"Luxury",1,"Good","USD","%","USD","%","U.S. Export"]
[null,null,"      more",{"$f":"H13+J13","v":4},1146,{"$f":"E13/$R$2","v":106.50557620817844},{"$f":"(I13+K13)/2/F13","v":774.6073298429319},1,97000,3,68000,{"$f":"H13*(I13-N13)+J13*(K13-N13)","v":284200},{"$f":"1-O13","v":0.94746816252274102},4200,{"$f":"(N13/I13+N13/K13)/2","v":5.2531837477258946E-2},{"$f":"I13*H13+J13*K13","v":301000}]
[null,null,"Stories:",1,"\u0080 HOST COUNTRY EXPENSES \u0080 "]
[null,null,"Baths:",1,null,null,null,null,"TURNKEY (single)",null,null,null,"Site work","TOTAL HOST COUNTRY",null,"SUB-TOTAL"]
[null,null,"Bedrooms:",2,"Basement","Foundation","Building",null,"Rough el.",null,"Others","Rough plumb.","(suitably)","Single","%","USD"]
[null,null,"W12.2  x   D 9.1","m",600,300,2100,null,600,null,null,600,{"$f":"D13*F13*$M$57/$F$43","v":7278.6804462391337},{"$f":"SUM(F17:M17)","v":10878.680446239134},{"$f":"N17/I13","v":0.112151344806589},{"$f":"D13*N17+E17","v":44114.721784956535}]
[null,null,"Garage Bay: ↓",null,"A porch 4 m depth might be developed right-hand site to the door in front of the GREAT MR with a",null,null,null,null,null,null,null,null,null,"Gross profit:"]
[null,null,"Option: to be added",null,"door  entrance  on right, or does a front window option possible, French windows and ",null,null,null,null,null,null,null,null,null,"(Suggested price) For sale:",{"$f":"ROUNDDOWN(Budget!$B$12*Invest!F13/Invest!$F$43*(1+E58),-3)","v":292000}]
[null,null," on the back side",null,"a sliding door for direct connection with the porch in the same depth. Low roofline extended to the right end."]
[3,"Two Bed Mediterranean","Ordered ",null,"CATALOG",null,null,"SELLING Prc CIF, USD",null,null,null,"U.S. CONTENT",null,"FOREIGN  CONTENT",null,"TOTAL"]
[null,null,"Plans","Nr","Sq Ft","m2","Prc/m2 Avrg",0,"Luxury",1,"Good","USD","%","USD","%","U.S. Export"]
[null,null,"      more ",{"$f":"H23+J23","v":4},1507,{"$f":"E23/$R$2","v":140.05576208178439},{"$f":"(I23+K23)/2/F23","v":1035.3019243530191},1,160000,3,130000,{"$f":"H23*(I23-N23)+J23*(K23-N23)","v":530000},{"$f":"1-O23","v":0.96514423076923073},5000,{"$f":"(N23/I23+N23/K23)/2","v":3.4855769230769232E-2},{"$f":"I23*H23+J23*K23","v":550000}]
[null,null,"Stories:",1,"\u0080 HOST COUNTRY EXPENSES \u0080 "]
[null,null,"Baths:",2,null,null,null,null,"TURNKEY (single)",null,null,null,"Site work","TOTAL HOST COUNTRY",null,"SUB-TOTAL"]
[null,null,"Bedrooms:",2,"Basement","Foundation","Building",null,"Rough el.",null,"Others","Rough plumb.","(suitably)","Single","%","USD"]
[null,null,"W12 x D 26.5 ","m",0,500,3800,0,1000,1,null,1000,{"$f":"D23*F23*$M$57/$F$43","v":9571.5283005954407},{"$f":"SUM(F27:M27)","v":15872.528300595441},{"$f":"N27/K23","v":0.12209637154304186},{"$f":"D23*N27+E27","v":63490.113202381763}]
[null,null,"Garage Bays: 2 ",null,null,null,null,null,null,null,null,null,null,null,"(Suggested price) For sale:",{"$f":"ROUNDDOWN(Budget!$B$12*Invest!F23/Invest!$F$43*(1+E58),-3)","v":384000}]
[4,"Contemporary Bungalow","Ordered ",null,"CATALOG",null,null,"SELLING Prc CIF, USD",null,null,null,"U.S. CONTENT",null,"FOREIGN  CONTENT",null,"TOTAL"]
[null,null,"Plans","Nr","Sq Ft","m2","Prc/m2 Avrg",1,"Luxury",2,"Good","USD","%","USD","%","U.S. Export"]
[null,null,"      more",{"$f":"H31+J31","v":11},1336,{"$f":"E31/$R$2","v":124.1635687732342},{"$f":"(I31+K31)/2/F31","v":918.14371257485027},1,129000,10,99000,{"$f":"H31*(I31-N31)+J31*(K31-N31)","v":1075000},{"$f":"1-O31","v":0.9642941038289875},4000,{"$f":"(N31/I31+N31/K31)/2","v":3.5705896171012455E-2},{"$f":"I31*H31+J31*K31","v":1119000}]
[null,null,"Stories:",1,"\u0080 HOST COUNTRY EXPENSES \u0080 "]
[null,null,"Baths:",3,null,null,null,null,"TURNKEY (single)",null,null,null,"Site work","TOTAL HOST COUNTRY",null,"SUB-TOTAL"]
[null,null,"Bedrooms:",2,"Basement","Foundation","Building",null,"Rough el.",null,"Others","Rough plumb.","(suitably)","Single","%","USD"]
[null,null,"W 21 x D 12.2","m",0,400,3000,null,700,null,null,700,{"$f":"D31*F31*$M$57/$F$43","v":23334.966805831224},{"$f":"SUM(F35:M35)","v":28134.966805831224},{"$f":"N35/K31","v":0.2841915838972851},{"$f":"D31*N35+E35","v":309484.63486414345}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Suggested price) For sale:",{"$f":"ROUNDDOWN(Budget!$B$12*Invest!F31/Invest!$F$43*(1+$E$58),-3)","v":341000}]
[5,"Contemporary home for family workers","Ordered ",null,"CATALOG",null,null,"SELLING Prc CIF, USD",null,null,null,"U.S. CONTENT",null,"FOREIGN  CONTENT",null,"TOTAL"]
[null,null,"Plans","Nr","Sq Ft","m2","Prc/m2 Avrg",0,"Luxury",1,"Good","USD","%","USD","%","U.S. Export",null,1,10,2,9,3,10,2,10,1,3]
[null,null,null,{"$f":"H39+J39","v":2},499,{"$f":"E39/$R$2","v":46.375464684014872},null,1,34000,1,24000,{"$f":"H39*(I39-N39)+J39*(K39-N39)","v":50000},{"$f":"1-O39","v":0.85784313725490202},4000,{"$f":"(N39/I39+N39/K39)/2","v":0.14215686274509803},{"$f":"I39*H39+J39*K39","v":58000}]
[null,null,"Stories:",1,"TURNKEY (single)",null,null,null,null,null,null,null,"Site work","TOTAL HOST COUNTRY",null,"SUB-TOTAL"]
[null,null,"Baths:",1,"Basement","Foundation","Building",null,"Rough el.",null,"Others","Rough plumb.","(suitably)","Single","%","USD"]
[null,null,"Bedroom:",1,500,400,1000,null,300,null,null,300,{"$f":"D39*F39*$M$57/$F$43","v":1584.669084936007},{"$f":"SUM(F42:M42)","v":3584.669084936007},{"$f":"N42/I39","v":0.10543144367458844},{"$f":"D39*N42+E42","v":7669.3381698720141}]
[null,null,"W 6.7 x D 9.7","m",null,{"$f":"IF(OR(D3>0,D13>0,D23>0,D31>0,D39>0),($D$3*F3+$D$13*F13+$D$23*F23+$D$31*F31+D39*F39),1)","v":2715.7992565055765},null,null,{"$f":"H3*I3+H13*I13+H23*I23+H31*I31+H39*I39","v":502000},null,{"$f":"J3*K3+J13*K13+J23*K23+J31*K31+J39*K39","v":1724000},{"$f":"L3+L13+L23+L31+L39","v":2124600},{"$f":"1-O43","v":0.93458659634531527},{"$f":"D3*N3+D13*N13+D23*N23+D31*N31+D39*N39","v":101400},{"$f":"(O3+O13+O23+O31+O39)/A37","v":6.541340365468476E-2},{"$f":"P3+P13+P23+P31+P39","v":2226000},null,{"$f":"IF((P43-I43-K43)=0,TRUE,FALSE)","v":true}]
[null,null,"Beds:",-1,"This villa is designed for family permanently serving tourists in the camp"]
[1,1.28,"Homes \u0086",{"$f":"D3+D13+D23","v":11}]
[null,null,"Bungalow bedrooms \u0086",{"$f":"D31*D34","v":22}]
[null,null,"Total Host Country Expenses:",{"$f":"D3+D13+D23+D31+D39","v":24},{"$f":"E7+E17+E27+E35+E42","v":1100},{"$f":"F7*D3+F17*D13+F27*D23+F35*D31+F42*D39","v":9300},{"$f":"G7*D3+G17*D13+G27*D23+G35*D31+G42*D39","v":64600},null,{"$f":"I7*D3+I17*D13+I27*D23+I35*D31+I42*D39","v":16500},null,{"$f":"K7*D3+K17*E13+K27*D23+K35*D31+K42*D39","v":0},{"$f":"L7*D3+L17*D13+L27*D23+L35*D31+L42*D39","v":16500},{"$f":"M7*D3+M17*D13+M27*D23+M35*D31+M42*D39","v":341145.27410854836},null,{"$f":"ROUNDDOWN(SUM(E47:M47),-1)","v":449140},{"$f":"ROUNDDOWN((P7+P17+P27+P35+P42),-1)","v":449140},null,{"$f":"IF(O47-P47=0,TRUE,FALSE)","v":true}]
[null,null,"Advisory & Assistance Service and Software:",null,"Mariner 1",24000,"Mariner 2",null,75000,0,null,"Mariner 3",null,null,null,{"$f":"F48+I48*J48","v":24000}]
[null,null,"State Investment Agency Tax for permits",null,15000,5000,"\u0085 Fee of lawyer for purchase the land. ",null,null,null,null,"Other municipal fees and tax \u0086",null,null,10000,{"$f":"B45*(E49+F49+O49)","v":38400}]
[null,null,"Land, TOTAL:",null,{"$f":"F50/R2","v":2788.1040892193309},{"$f":"ROUNDUP(F43*10,-4)","v":30000},40,null,{"$f":"F50*G50","v":1200000},null,null,null,null,null,"Land, TOTAL:",{"$f":"I50*B45","v":1536000}]
[null,null,"Driveway",null,null,null,null,null,null,null,null,null,5000]
[null,null,"Lighting fixtures",null,"30 high and 35 low units, price for work without lamps",null,null,null,null,null,null,null,2000]
[null,null,"Septic",null,null,null,null,null,null,null,null,null,3000]
[null,"Кладенец, източник, сонда","Well",null,"Pipeline, labor and materials (incl. to the beach)",null,null,null,null,null,null,null,1400,null,32000,1638400,null,"\u0085 Selected strategy for purchase the land "]
[null,null,"Others (transformer substation, etc.)",null,null,null,null,null,null,null,null,null,25000]
[null,"Озеленняване","Landscaping",null,null,null,null,null,null,null,null,null,10000]
[null,null,"Site work , TOTAL:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M51:M56)","v":46400}]
[null,null,"Commercial cost plus profit:",null,0.6]
[null,null,"Land for 1st and 2nd Stages, TOTAL:","(Mariner 1 & 2)",null,32000,{"$f":"F59*G50","v":1280000},null,null,null,null,null,null,null,null,{"$f":"G59*B45","v":1638400}]
[null,"A Unique Layout"]
[5,null,"OPTIONAL"]
[null,null,"Stories: 1",null,1992,{"$f":"E62/$R$2","v":185.13011152416357},null,null,null,null,null,null,null,null,null,null,null,null,null,"For more details:"]
[null,null,"Baths: 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".pdf 1.5 MB"]
[null,null,"Beds: 3"]
[null,null,"Garage : 2"]
[null,null,"W 20 x  D 19",null,"m"]
[]
[" ","PROJECT COMPANY \"MARINER 1, LTD.\"",null,"Nr","Salary","Benefits %@ salaries, TOTAL"]
[null,"PERSONNEL"]
["1) ","CEO & Project Manager (part time)",null,1,1000,0.4,{"$f":"E70*(1+F70)","v":1400}]
["2)","Expert - Investment Advisor & Program Manager",null,1,1500,0,{"$f":"E71*(1+F71)","v":1500}]
["3)","Family - yardmen, cleaners,  courier refreshments",null,2,900,0.4,{"$f":"E72*(1+F72)","v":1260}]
["4)","Beach bar service",null,1,700,0.4,{"$f":"E73*(1+F73)","v":979.99999999999989}]
[null,"For 1 Month:","TOTAL:",{"$f":"SUM(D70:D73)","v":5},null,null,{"$f":"SUM(G70:G73)","v":5140}]

{"sheet":"X","index":5,"n_rows":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Sq Ft","m2","Prs","Prs/m2",null,null,null,null,null,null,"Sq Ft","m2"]
[null,null,null,"Mediterranian Vacation Retreat",null,null,null,null,null,null,null,null,null,null,10.76,1]
[null,null,null,"Stories: 1"]
[null,null,null,"Baths: 1",972,{"$f":"E5/$O$3","v":90.334572490706321}]
[null,null,null,"Beds: 1"]
[null,null,null,null,null,null,null,null,"Eurostandard!"]
[]
[null,null,null,"Two Bed Country"]
[null,null,null,"Stories: 2"]
[null,null,null,"Baths: 2",1072,{"$f":"E11/$O$3","v":99.628252788104092},50000,"True No-Shop™ Log Home Only\nTrue No-Shop™ Log Home Only\nTrue No-Shop™ Log Home Only\n"]
[null,null,null,"1/2 Bath: 1"]
[null,null,null,"Beds: 2"]
[]
[null,null,null,"Contemporary"]
[null,null,null,"Stories: 1"]
[null,null,null,"Baths: 2",1336,{"$f":"E17/$O$3","v":124.1635687732342}]
[null,null,null,"Beds: 3"]
[null,null,null,"W  21; D  12.2"]
[null,null,null,"Contemporary and Relaxed",null,null,"> a porch 4 m depth might be developed righthand site to the door"]
[null,null,null,"Stories: 1",null,null,"before the  GREAT RM with a door  entrance  just on the right to be made "]
[null,null,null,"Baths: 1",1146,{"$f":"E22/$O$3","v":106.50557620817844}]
[null,null,null,"Beds: 2"]
[]
[]
[]
[null,null,null,"Stories: 1",1380,{"$f":"E27/$O$3","v":128.25278810408923}]
[null,null,null,"Baths: 2"]
[]
[]
[]
[null,null,null,"Two Bed Mediterranean"]
[null,null,null,"Stories: 1"]
[null,null,null,"Baths: 3",1892,{"$f":"E34/$O$3","v":175.8364312267658}]
[null,null,null,"Beds: 2"]
[null,null,null,"12 x 26.5 ","m"]
[null,null,null,"Garage Bays: 2 "]
[]
[null,null,null,"Three Bedroom Mediterranean"]
[null,null,null,"Stories: 1"]
[null,null,null,"Baths: 2",1576,{"$f":"E41/$O$3","v":146.46840148698885}]
[null,null,null,"Beds: 3"]
[]
[null,null,null,null,"French Country Hone"]
[null,null,null,"Stories: 1"]
[null,null,null,"Baths: 2",1436,{"$f":"E46/$O$3","v":133.45724907063197}]
[null,null,null,"Beds: 2"]
[null,null,null,"Garage Bays: 2"]
[]
[]
[null,null,null,"Bungalow"]
[null,null,null,"Stories: 2",1657,{"$f":"E52/$O$3","v":153.99628252788105},null,{"$f":"G52/F52","v":0}]
[null,null,null,"Baths: 2"]
[null,null,null,"Beds: 2"]
[]
[null,null,null,"Exciting Outdoor Living",null,null,"Extras: Balcony - Inside, Balcony - Outside, Impressive Entrance, In-Law Suite, "]
[null,null,null,"Stories: 2",null,null,"Porch - Front, Porch - Rear, Porch - Side, Porch - Wraparound, Split Bedrooms."]
[null,null,null,"Baths: 2",1904,{"$f":"E58/$O$3","v":176.95167286245353}]
[null,null,null,"Beds: 2"]
[null,null,null,"12 x 15.5","m"]
[]
[]
[null,null,null,"Stories: 1"]
[null,null,null,"Baths: 3",1992,{"$f":"E64/$O$3","v":185.13011152416357}]
[null,null,null,"Beds: 3"]
[null,null,null,"Garage : 2"]
[]
[]
[null,null,null,"True No-Shop",1949,{"$f":"E69/$O$3","v":181.13382899628255},142340,{"$f":"G69/F69","v":785.82780913288855}]
[null,null,null,"Completely",null,{"$f":"F69","v":181.13382899628255},315400,{"$f":"G70/F70","v":1741.2539763981526}]
[null,null,null,"Bedrooms 3"]
[null,null,null,"Bathroom 2-1/2"]
[]
[null,null,null,"Stories: 2"]
[null,null,null,"Bed: 2",1325,{"$f":"E75/$O$3","v":123.14126394052045}]
[null,null,null,"Baths: 1"]
[null,null,null,"1/2 Baths: 1"]
[null,"MODULAR HOMES:",null,null,null,"Assembled & Ready to Ship"]
[null,"Cabine"]
[]
[]
[null,null,null,null,192,{"$f":"E82/$O$3","v":17.843866171003718},13000,{"$f":"G82/F82","v":728.54166666666663}]
[]
[null,null,null,null,348,{"$f":"E84/$O$3","v":32.342007434944236},22640,{"$f":"G84/F84","v":700.01839080459774}]
[]
[]
[]
[]
[]
[null,null,null,null,1203,{"$f":"E90/$O$3","v":111.80297397769517},60000,{"$f":"G90/F90","v":536.65835411471323}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1548,{"$f":"E98/$O$3","v":143.86617100371748},81400,{"$f":"G98/F98","v":565.80361757105936}]

{"sheet":"Y","index":6,"n_rows":139,"n_cols":26,"rows_kept":139,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,5,0,6],[0,12,0,17],[59,6,59,7]]}
["Serial","CAPITAL INVESTMENT","Ordered ","CATALOG",null,"Prc EXFACTORYy,  Quality",null,"Approved","TRANSPORT",null,"SERVICE","TOTAL","TURNKEY",null,null,null,null,null,"TOTAL","%","Final","TOTAL"]
["Nr","PROJECT","Nr","Sq Ft","m2","Medium","High","Prs/m2","Road US","Shipping","Turnkey","US export","Basement","Foundation","Building","Rough el.","Rough plmb.","Site work","host contry","of US","Prs/m2","USD"]
[1,"Mediterrenian Vacation Retreat",null,10.76,1]
[null,null,2,972,{"$f":"D4/$D$3","v":90.334572490706321},null,null,null,{"$f":"$C$4*I5","v":1200},{"$f":"$C$4*J5","v":16000}]
[null,null,"Stories: 1",null,null,null,null,null,600,8000]
[null,null,"Baths: 2"]
[null,null,"Beds: 1",null,"?"]
[null,null,"W15.2 x  D 9.7","m"]
[]
[]
[null,"Contemporary and Relaxed"]
[2,null,2,1146,{"$f":"D12/$D$3","v":106.50557620817844},null,null,null,null,2400]
[null,null,"Stories: 1",">  a porch 4 m depth might be developed right-hand site to the door before the"]
[null,null,"Baths: 1","    GREAT RM with a door  entrance  just on the right to be made , or"]
[null,null,"Beds: 2",">  does a front window option possible - French windows and a sliding door for "]
[null,null,"W12.2  x   D 9.1","m    direct porch communication? Low roofline over the door extended  over"]
[null,null,"Garage Bay: ↓","        the whole porch in the same depth."]
[null,null,"Option at the ","> Partial change in the interior of the great room"]
[null,"Two Bed Mediterranean","back side added"]
[3,null,1,1892,{"$f":"D20/$D$3","v":175.8364312267658},null,null,null,null,1600,null,null,0]
[null,null,"Stories: 1"]
[null,null,"Baths: 3"]
[null,null,"Beds: 2",null,"g",null,"g",null,"g",null,null,null,"g","g","g","g","g"]
[null,null,"W12 x D 26.5 ","m"]
[null,null,"Garage Bays: 2 "]
[null,null,"True No-Shop™ Log Home Only\nTrue No-Shop™ Log Home Only\nTrue No-Shop™ Log Home Only\n"]
[]
[null,"Contemporary"]
[4,null,2,1336,{"$f":"D29/$D$3","v":124.1635687732342},null,null,null,null,null,null,null,0]
[null,null,"Stories: 1"]
[null,null,"Baths: 2"]
[null,null,"Beds: 3"]
[null,null,"W 21 x D 12.2","m"]
[]
[]
[5,"Contemporary home for family workers"]
[null,null,1,400,"37.2 sq.m."]
[null,null,"Style: Cabin"]
[null,null,"Stories: 1"]
[null,null,"Baths: 1"]
[null,null,"Beds: 1"]
[null,null,"W 6.70' x D 10","m"]
[null,"A Unique Layout"]
[5,null,"OPTIONAL"]
[null,null,"Stories: 1",1992,{"$f":"D45/$D$3","v":185.13011152416357}]
[null,null,"Baths: 3"]
[null,null,"Beds: 3"]
[null,null,"Garage : 2"]
[null,null,"W 20 x  D 19","m"]
[]
[null,"Land, TOTAL:","€ / sq.m.:",6,5000,{"$f":"D51*E51","v":30000}]
[]
[]
[null,"Site work , TOTAL:","Driveway"]
[null,null,"Septic"]
[null,"Кладенец, източник, сонда","Well"]
[null,"Озеленяване","Landscaping"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customized",null,"Plan #:HOMEPW75451"]
[null,"back to Invest","①",null,null,null,"Customized",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"②"]
[null,null,null,null,null,null,"Plan #:HOMEPW02510"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"back to Invest",null,null,"Plan #:HOMEPW02510"]
[null,null,"Original",null,null,"③",null,null,null,"Customized",null,null,null,null,"④",null,null,"Plan #:HOMEPW14106"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⑤"]