{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Basis","CAPEX","Feed","Revenue","Utility","Chem.","Manpower","Opex","feed grace","Economic Analysis ","Final Result","Sheet2"],"not_rendered":{"charts":16,"images":3,"macros":0,"external_links":2,"defined_names":101,"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":"Basis","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,1,1,4],[19,10,20,10],[31,6,32,6],[25,6,26,6],[19,9,20,9]]}
[]
[null,"Prices (NPC-Historical 5 years+3 years forecast)"]
[null,"Item","Stream","$/T","Remarks"]
[null,1,"Light Crude Oil",589]
[null,2,"Heavy Crude Oil",559]
[null,3,"Gas Condensate",649]
[null,4,"Propane (C3)",560]
[null,5,"Mix Butane (C4)",565]
[null,6,"Gasoline (Octane: 95)",810]
[null,7,"Gasline (Octane: 92)",790]
[null,8,"Kerosene",754]
[null,9,"Jet Fuel",790]
[null,10,"Gasoil",724]
[null,11,"Sulfur (Granule)",125]
[null,12,"Fuel Oil (0.5% Sulfur)",635]
[null,13,"Fuel Oil (3.5% Sulfur)",465]
[null,14,"Ethylene",800]
[null,15,"Propylene (Polymeric)",810]
[null,16,"Polypropylene (copolymer)",1003,null,null,"Main Assumptions"]
[null,17,"Polypropylene (homopolymer)",974,null,null,"Plant Capacity","BPSD","Percent","TPD","KTPY"]
[null,18,"Olefinic Fuel oil ",416,null,null,null,60000,{"$f":"I22+I23","v":1}]
[null,19,"Olefinic Pyrolysis Gasoline",716,null,null,{"$f":"C6","v":"Gas Condensate"},{"$f":"I22*H21","v":60000},1,{"$f":"296814*24/1000","v":7123.5360000000001},{"$f":"J22*330/1000","v":2350.7668799999997}]
[null,20,"polystyrene, EPS",1344,null,null,{"$f":"C5","v":"Heavy Crude Oil"}]
[null,21,"polystyrene, HIPS",1527,null,null,"Total",{"$f":"SUM(H22:H23)","v":60000},{"$f":"SUM(I22:I23)","v":1}]
[null,22,"polystyrene, GPPS",1276]
[null,23,"SBR (non oil Garde 1502)",1699,null,null,"Utilization rate","yr1","yr2","yr3"]
[null,24,"SBR (Oil Extended Garde 1712)",1458,null,null,null,0.8,0.9,1]
[null,25,"PBR",1735]
[null,26,"LLDPE (Butene Garde)",1016,null,null,"Interest on feed grace ","%","year"]
[null,27,"LDPE",1135,null,null,"repeyment period",0.08,8]
[null,28,"HDPE (film)",1076]
[null,29,"HDPE (body)",1044,null,null,"On Stream","days"]
[null,30,"HDPE (Injected)",1021,null,null,null,330]
[null,31,"Benzene",901]
[null,32,"Styrene monomer",1087,null,null,"Tax Rate",0.25]
[null,33,"ParaXylene",1002,null,null,"Salvage ",0.25]
[null,34,"Orthoxylene",1027,null,null,"Discount Rate",0.1]
[null,35,"Mix- Xylense",947,null,null,"Discount of feed fob price",0.05]
[null,36,"Heavy Aromatics (C9+)",769]
[null,37,"C4 Raffinate I",626,null,null,"working capital (number of month)",1]
[null,38,"1,3-Butadiene",1031]
[null,39,"Ethylbenzene",935,null,null,"Interest on Loan for Capex","%","year"]
[null,40,"Isobutylene",1236,null,null,"repeyment period",0.08,5]
[null,41,"Light Naphtha",645,null,null,"Loan Ratio of Capex",0.85]
[null,42,"Heavy Naphtha",668]
[null,43,"MTBE",865,null,null,"Construction Phase"]
[null,44,"Alkylate",868,null,null,1,2,3,4]
[null,45,"EPDM",2521,null,null,7.0000000000000007E-2,0.13,0.35,0.3]
[null,46,"LAB",1451]
[null,46,"Pitch",null,null,null," feed grace interest include",1]
[null,null,null,null,null,null," capex loan interest include",1]
[null,null,null,null,null,null,"Note: Include:1, Exclude:0"]

{"sheet":"CAPEX","index":1,"n_rows":115,"n_cols":20,"rows_kept":115,"cut":false,"hidden":false,"merged":[[2,12,2,14],[23,6,24,6],[23,1,23,3],[2,7,2,11]]}
[]
[]
[null,null,null,null,null,null,null,"هزینه های انجام شده ",null,null,null,null,"پیش بینی",null,null,"جمع کل"]
[null,null,null,null,null,null,null,1398,1399,1400,1401,1402,1403,1404,1405]
[null,"EPC Breakdown",null,null,null,null,null,{"$f":"H11/$P$11","v":8.7707995372531919E-2},{"$f":"I11/$P$11","v":6.8174742558063745E-2},{"$f":"J11/$P$11","v":0.29835542338709126},{"$f":"K11/$P$11","v":0.16546788135493493},{"$f":"L11/$P$11","v":0.12788596894782572},{"$f":"M11/$P$11","v":8.0663712328656281E-2},{"$f":"N11/$P$11","v":0.11228236295490188},{"$f":"O11/$P$11","v":5.9461913095994176E-2}]
[null,"Equity Share %",null,null,null,null,null,{"$f":"H10/H11","v":0.33593422418682856},{"$f":"I10/I11","v":0.55787621434503609},0.19578274917447178,0.49192973930578759,0.67816929595227526,0.5963868499085142,0.44567251983242723,0.85775063473546964]
[null,null,"1393/8/12/29","1394/8/12/29","1395/8/12/29","1396/12/29","1397/12/29","1398/12/29","1399/12/29","1400/12/29","1401/12/29","1402/12/29","1403/12/29","1404/12/29","1405/12/29"]
[null,"تسهیلات ارزی(میلیون دلار)",0,0,0,0,0,{"$f":"29196240/10^6","v":29.19624},{"$f":"15109289/10^6","v":15.109289},{"$f":"120277381/10^6","v":120.27738100000001},{"$f":"42141901/10^6","v":42.141900999999997},{"$f":"20631320/10^6","v":20.631319999999999},{"$f":"16000000*1.02/10^6","v":16.32},{"$f":"30000000*1.04/10^6","v":31.2},{"$f":"4000000*1.06/10^6","v":4.24},{"$f":"SUM(H8:O8)","v":279.116131}]
[null,"تزریق ریالی(میلیون ریال) equity",0,0,0,0,0,1889274,4219096,7318800,11505706,18024655,12000000,10000000,10000000,{"$f":"SUM(M9:O9)","v":32000000}]
[null,"equity (میلیون دلار)",null,null,null,null,null,{"$f":"H9/127916","v":14.769645704993902},{"$f":"I9/221300","v":19.065051965657478},{"$f":"J9/249951","v":29.280939064056554},{"$f":"K9/281981","v":40.803125033246921},{"$f":"L9/414600","v":43.474807042932945},{"$f":"M9/507573*1.02","v":24.114757877192051},{"$f":"N9/414600*1.04","v":25.084418716835508},{"$f":"O9/414600*1.06","v":25.566811384466959},{"$f":"SUM(H10:O10)","v":222.15955678938235}]
[null,"TOTAL INVESTMEN",null,null,null,null,null,{"$f":"H8+H10","v":43.965885704993902},{"$f":"I8+I10","v":34.174340965657478},149.55832006405655,82.945026033246918,64.10612704293294,{"$f":"M8+M10","v":40.434757877192055},{"$f":"N8+N10","v":56.284418716835503},{"$f":"O8+O10","v":29.806811384466961},{"$f":"P8+P10","v":501.27568778938235},":Plant total CAPEX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N11/2+O11","v":57.949020742884713},":Plant NHT CAPEX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"یادداشت 1 : نرخ تسهیلات 6 درصد بوده و  شرایط پرداخت تسهیلات 27 قسط طی 7 سال ، سال اول 3 قسط و 6 سال بعدی هر سال 4 قسط، شرو ع اقساط از تاریخ شهریور 1405 می باشد."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"یادداشت 2 : شروع راه اندازی فاز اول ( بدون NHT)، انتهای برج 6 سال 1404 و شروع راه اندازی کل پالایشگاه انتهای سال 1405"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"یادداشت 3 : مبالغ تزریق ریالی می توانند با نرخ سنا در انتهای سال به ارز تبدیل شوند. مبالغ ریالی پیش بینی شده از زاویه زمان کنونی دیده شده است و نرخ تورم سالهای آتی اعمال نشده است"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N11/2","v":28.142209358417752}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N11/2+O11","v":57.949020742884713}]
[]
[null,"Input "]
[null,null,null,null,null,null,null,null,null,1,2,3,5,"part 1 of loan","part 2 of loan","part 3 of loan","part 4 of loan","part 5 of loan","grace period interest ","Total Grace Period interest "]
[null,"FIXED INVESTMENT COST (EPC Cost)",null,null,"MM $",null,"Total Investment for feed garce",null,null,"Construction Phase (loan Distribution)",null,null,null,null,null,null,null,null,"Include : 1"]
[null,"Scenario","CAPEX","Loan","Loan Finacial Cost","working Capital",null,null,"Scenario",{"$f":"Basis!G48","v":7.0000000000000007E-2},{"$f":"Basis!H48","v":0.13},{"$f":"Basis!I48","v":0.35},{"$f":"Basis!#REF!","v":{"$error":"#REF!"}},"Grace Period interest","Grace Period interest","Grace Period interest","Grace Period interest","Grace Period interest","Exclude:0"]
[null,1,5843,{"$f":"C26*Basis!$H$44","v":4966.55},{"$f":"H47*0.83","v":{"$error":"#REF!"}},null,{"$f":"C26+E26+F26","v":{"$error":"#REF!"}},null,1,{"$f":"$D$26*J25","v":347.65850000000006},{"$f":"$D$26*K25","v":645.65150000000006},1738.2925,{"$error":"#REF!"},{"$f":"J26*$B$51/2","v":13.906340000000002},{"$f":"(N26+J26)*$B$51+K26*$B$51/2","v":54.751247200000009},{"$f":"(J26+K26+N26+O26)*$B$51+L26*$B$51/2","v":154.48910697600002},{"$f":"(SUM(J26:L26)+SUM(N26:P26))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J26:L26)+SUM(N26:Q26))*$B$51+M26*$B$51/2","v":{"$error":"#REF!"}},{"$f":"Basis!H51","v":1},{"$f":"SUM(N26:R26)*S26","v":{"$error":"#REF!"}}]
[null,2,null,{"$f":"C27*Basis!$H$44","v":0},{"$f":"H56*0.83","v":{"$error":"#REF!"}},null,null,null,2,{"$f":"$D$27*J25","v":0},{"$f":"$D$27*K25","v":0},0,{"$error":"#REF!"},{"$f":"J27*$B$51/2","v":0},{"$f":"(N27+J27)*$B$51+K27*$B$51/2","v":0},{"$f":"(J27+K27+N27+O27)*$B$51+L27*$B$51/2","v":0},{"$f":"(SUM(J27:L27)+SUM(N27:P27))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J27:L27)+SUM(N27:Q27))*$B$51+M27*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$f":"SUM(N27:R27)*S27","v":{"$error":"#REF!"}}]
[null,3,null,{"$f":"C28*Basis!$H$44","v":0},{"$f":"H65*0.83","v":{"$error":"#REF!"}},null,null,null,3,{"$f":"$D$28*J25","v":0},{"$f":"$D$28*K25","v":0},0,{"$error":"#REF!"},{"$f":"J28*$B$51/2","v":0},{"$f":"(N28+J28)*$B$51+K28*$B$51/2","v":0},{"$f":"(J28+K28+N28+O28)*$B$51+L28*$B$51/2","v":0},{"$f":"(SUM(J28:L28)+SUM(N28:P28))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J28:L28)+SUM(N28:Q28))*$B$51+M28*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$error":"#REF!"}]
[null,4,null,{"$f":"C29*Basis!$H$44","v":0},{"$f":"H74*0.83","v":{"$error":"#REF!"}},null,null,null,4,{"$f":"$D$29*J25","v":0},{"$f":"$D$29*K25","v":0},0,{"$error":"#REF!"},{"$f":"J29*$B$51/2","v":0},{"$f":"(N29+J29)*$B$51+K29*$B$51/2","v":0},{"$f":"(J29+K29+N29+O29)*$B$51+L29*$B$51/2","v":0},{"$f":"(SUM(J29:L29)+SUM(N29:P29))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J29:L29)+SUM(N29:Q29))*$B$51+M29*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$error":"#REF!"}]
[null,5,null,{"$f":"C30*Basis!$H$44","v":0},{"$f":"H83*0.83","v":{"$error":"#REF!"}},null,null,null,5,{"$f":"$D$30*J25","v":0},{"$f":"$D$30*K25","v":0},0,{"$error":"#REF!"},{"$f":"J30*$B$51/2","v":0},{"$f":"(N30+J30)*$B$51+K30*$B$51/2","v":0},{"$f":"(J30+K30+N30+O30)*$B$51+L30*$B$51/2","v":0},{"$f":"(SUM(J30:L30)+SUM(N30:P30))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J30:L30)+SUM(N30:Q30))*$B$51+M30*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$error":"#REF!"}]
[null,6,null,{"$f":"C31*Basis!$H$44","v":0},{"$f":"H92*0.83","v":{"$error":"#REF!"}},null,null,null,6,{"$f":"$D$31*J25","v":0},{"$f":"$D$31*K25","v":0},0,{"$error":"#REF!"},{"$f":"J31*$B$51/2","v":0},{"$f":"(N31+J31)*$B$51+K31*$B$51/2","v":0},{"$f":"(J31+K31+N31+O31)*$B$51+L31*$B$51/2","v":0},{"$f":"(SUM(J31:L31)+SUM(N31:P31))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J31:L31)+SUM(N31:Q31))*$B$51+M31*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$error":"#REF!"}]
[null,7,null,{"$f":"C32*Basis!$H$44","v":0},{"$f":"H102*0.83","v":{"$error":"#REF!"}},null,null,null,7,{"$f":"$D$32*J25","v":0},{"$f":"$D$32*K25","v":0},0,{"$error":"#REF!"},{"$f":"J32*$B$51/2","v":0},{"$f":"(N32+J32)*$B$51+K32*$B$51/2","v":0},{"$f":"(J32+K32+N32+O32)*$B$51+L32*$B$51/2","v":0},{"$f":"(SUM(J32:L32)+SUM(N32:P32))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J32:L32)+SUM(N32:Q32))*$B$51+M32*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$error":"#REF!"}]
[null,9,null,{"$f":"C33*Basis!$H$44","v":0},{"$f":"H111*0.83","v":{"$error":"#REF!"}},null,null,null,9,{"$f":"$D$33*J25","v":0},{"$f":"$D$33*K25","v":0},0,{"$error":"#REF!"},{"$f":"J33*$B$51/2","v":0},{"$f":"(N33+J33)*$B$51+K33*$B$51/2","v":0},{"$f":"(J33+K33+N33+O33)*$B$51+L33*$B$51/2","v":0},{"$f":"(SUM(J33:L33)+SUM(N33:P33))*$B$51+#REF!*$B$51/2","v":{"$error":"#REF!"}},{"$f":"(SUM(J33:L33)+SUM(N33:Q33))*$B$51+M33*$B$51/2","v":{"$error":"#REF!"}},{"$f":"S26","v":1},{"$error":"#REF!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Finacial Cost of Capex Loan"]
[]
["Scanario 1",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$26/$B$50","v":993.31000000000006},{"$f":"$D$26/5","v":993.31000000000006},993.31000000000006,993.31000000000006,993.31000000000006,{"$f":"SUM(C46:G46)","v":4966.55}]
["Financial cost",null,{"$f":"C48-C46","v":{"$error":"#REF!"}},{"$f":"D48-D46","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C47:G47)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"D26+T26","v":{"$error":"#REF!"}},{"$f":"$C$50","v":{"$error":"#REF!"}},{"$f":"$C$50","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C48:G48)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"Basis!I43","v":5},{"$f":"PMT(B51,B50,-B48)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"Basis!H43","v":0.08}]
[]
[]
["Scanario 2",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$27/$B$59","v":0},{"$f":"$D$27/$B$59","v":0},0,0,0,{"$f":"SUM(C55:G55)","v":0}]
["Financial cost",null,{"$f":"C57-C55","v":{"$error":"#REF!"}},{"$f":"D57-D55","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C56:G56)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T27+D27","v":{"$error":"#REF!"}},{"$f":"$C$59","v":{"$error":"#REF!"}},{"$f":"$C$59","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C57:G57)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B60,B59,-B57)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]
[]
[]
["Scanario 3",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$28/$B$68","v":0},{"$f":"$D$28/$B$68","v":0},0,0,0,{"$f":"SUM(C64:G64)","v":0}]
["Financial cost",null,{"$f":"C66-C64","v":{"$error":"#REF!"}},{"$f":"D66-D64","v":{"$error":"#REF!"}},{"$f":"E66-E64","v":{"$error":"#REF!"}},{"$f":"F66-F64","v":{"$error":"#REF!"}},{"$f":"G66-G64","v":{"$error":"#REF!"}},{"$f":"SUM(C65:G65)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T28+D28","v":{"$error":"#REF!"}},{"$f":"$C$68","v":{"$error":"#REF!"}},{"$f":"$C$68","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C66:G66)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B69,B68,-B66)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]
[]
[]
["Scanario 4",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$29/$B$77","v":0},{"$f":"$D$29/$B$77","v":0},0,0,0,{"$f":"SUM(C73:G73)","v":0}]
["Financial cost",null,{"$f":"C75-C73","v":{"$error":"#REF!"}},{"$f":"D75-D73","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C74:G74)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T29+D29","v":{"$error":"#REF!"}},{"$f":"$C$77","v":{"$error":"#REF!"}},{"$f":"$C$77","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C75:G75)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B78,B77,-B75)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]
[]
[]
["Scanario 5",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$30/$B$86","v":0},{"$f":"$D$30/$B$86","v":0},0,0,0,{"$f":"SUM(C82:G82)","v":0}]
["Financial cost",null,{"$f":"C84-C82","v":{"$error":"#REF!"}},{"$f":"D84-D82","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C83:G83)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T30+D30","v":{"$error":"#REF!"}},{"$f":"$C$86","v":{"$error":"#REF!"}},{"$f":"$C$86","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C84:G84)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B87,B86,-B84)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]
[]
[]
["Scanario 6",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$31/$B$95","v":0},{"$f":"$D$31/$B$95","v":0},0,0,0,{"$f":"SUM(C91:G91)","v":0}]
["Financial cost",null,{"$f":"C93-C91","v":{"$error":"#REF!"}},{"$f":"D93-D91","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C92:G92)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T31+D31","v":{"$error":"#REF!"}},{"$f":"$C$95","v":{"$error":"#REF!"}},{"$f":"$C$95","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C93:G93)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B96,B95,-B93)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]
[]
[]
[]
["Scanario 7",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$32/$B$105","v":0},{"$f":"$D$32/$B$105","v":0},0,0,0,{"$f":"SUM(C101:G101)","v":0}]
["Financial cost",null,{"$f":"C103-C101","v":{"$error":"#REF!"}},{"$f":"D103-D101","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C102:G102)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T32+D32","v":{"$error":"#REF!"}},{"$f":"$C$105","v":{"$error":"#REF!"}},{"$f":"$C$105","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C103:G103)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B106,B105,-B103)","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]
[]
[]
["Scanario 9",null,1,2,3,4,5,"Total "]
["Pay Back (Orginal)",null,{"$f":"$D$33/$B$114","v":0},{"$f":"$D$33/$B$114","v":0},0,0,0,{"$f":"SUM(C110:G110)","v":0}]
["Financial cost",null,{"$f":"C112-C110","v":{"$error":"#REF!"}},{"$f":"D112-D110","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C111:G111)","v":{"$error":"#REF!"}}]
["Total Loan ",{"$f":"T33+D33","v":{"$error":"#REF!"}},{"$f":"$C$114","v":{"$error":"#REF!"}},{"$f":"$C$114","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C112:G112)","v":{"$error":"#REF!"}}]
[null,"Annual","PMT (Annual)"]
["Toal Loan \nPay back period",{"$f":"B50","v":5},{"$f":"PMT(B115,B114,-B112)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"H112-D33","v":{"$error":"#REF!"}}]
["Finacial Rate",{"$f":"B51","v":0.08}]

{"sheet":"Feed","index":2,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":false,"merged":[[12,1,12,13],[3,5,3,13],[3,14,3,21],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4]]}
[null,null,null,"firsst 10 yrs"]
[null,null,"Discount on feed",{"$f":"Basis!H38","v":0.05},{"$f":"Basis!I38","v":0},"Of FOB",null,null,null,null,null,null,null,"عدم 10% تخفیف خوراک بعد از 10 سال ",null,{"$f":"P6/(1-$D$2)-P6+P7/(1-$D$2)-P7","v":0},{"$f":"Q6/(1-$D$2)-Q6+Q7/(1-$D$2)-Q7","v":0},{"$f":"R6/(1-$D$2)-R6+R7/(1-$D$2)-R7","v":0},{"$f":"S6/(1-$D$2)-S6+S7/(1-$D$2)-S7","v":0},{"$f":"T6/(1-$D$2)-T6+T7/(1-$D$2)-T7","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"تخفیف 5% خوراک سالهای آتی",{"$f":"(O6+O7)/(1-$D$2)*$E$2","v":0},{"$f":"(P6+P7)/(1-$D$2)*$E$2","v":0},0,0,0,0,0,0]
[null,"items","Description","Max. Production","Unit Price, $/T","Flow rate, KTPY",null,null,null,null,null,null,null,null,"Feed Cost. MM$/Y"]
[null,null,null,null,null,"Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9","Scheme 10","Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9"]
[null,1,{"$f":"Basis!C6","v":"Gas Condensate"},null,{"$f":"Basis!D6*(1-D2)","v":616.54999999999995},{"$f":"Basis!K22","v":2350.7668799999997},null,null,null,null,null,null,null,null,{"$f":"F6*$E$6/1000","v":1449.3653198639997},{"$f":"G6*$E$6/1000","v":0},0,0,0,0,0,0]
[null,2,"Co-feed 0",null,null,{"$f":"Basis!K23","v":0},null,null,null,null,null,null,null,{"$f":"F7","v":0},{"$f":"F7*$E$7/1000","v":0},{"$f":"G7*$E$7/1000","v":0},0,0,0,0,0,0]
[null,3,"Co-feed 1",null,null,null,null,null,null,null,null,null,null,{"$f":"N17*$D$3/1000","v":0},{"$f":"F8*$E$8/1000","v":0},{"$f":"G8*$E$8/1000","v":0},{"$f":"H8*$E$8/1000","v":0},{"$f":"I8*$E$8/1000","v":0},{"$f":"J8*$E$8/1000","v":0},0,0,0]
[null,4,"Co-feed 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F9*E9/1000","v":0}]
[null,5,"Co-feed 3",null,null,null,null,null,null,null,null,null,null,null,0]
[null,6,"Co-feed 4",null,null,null,null,null,null,null,null,null,null,null,0]
[null,7,"Co-feed 5",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O6:O12)","v":1449.3653198639997},{"$f":"SUM(P6:P12)","v":0},0,0,0,{"$f":"SUM(T6:T12)","v":0},{"$f":"SUM(U6:U12)","v":0},{"$f":"SUM(V6:V12)","v":0}]
[]
[null,null,"Flow Rate from MB (MTD)"]
[null,null,null,null,null,"MB-Sch 1","MB-Sch 2","MB-Sch 3","MB-Sch 4","MB-Sch 5","MB-Sch 6","MB-Sch 7","MB-Sch 9","MB-Sch 10"]
[null,null,"1Buttene",null,null,44,53,42,38,53,42,48,52]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Frace Period","Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"year 1",{"$f":"(O6+O7)*Basis!$H$27","v":1159.4922558911999},{"$f":"(P6+P7)*Basis!$H$27","v":0},{"$f":"(Q6+Q7)*Basis!$H$27","v":0},{"$f":"(R6+R7)*Basis!$H$27","v":0},{"$f":"(S6+S7)*Basis!$H$27","v":0},{"$f":"(T6+T7)*Basis!$H$27","v":0},{"$f":"(U6+U7)*Basis!$H$27","v":0},{"$f":"(V6+V7)*Basis!$H$27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"year 2",{"$f":"(O6+O7)*Basis!$I$27","v":1304.4287878775997},{"$f":"(P6+P7)*Basis!$I$27","v":0},{"$f":"(Q6+Q7)*Basis!$I$27","v":0},{"$f":"(R6+R7)*Basis!$I$27","v":0},{"$f":"(S6+S7)*Basis!$I$27","v":0},{"$f":"(T6+T7)*Basis!$I$27","v":0},{"$f":"(U6+U7)*Basis!$I$27","v":0},{"$f":"(V6+V7)*Basis!$I$27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3",{"$f":"(O6+O7)*Basis!$J$27","v":1449.3653198639997},{"$f":"(P6+P7)*Basis!$J$27","v":0},{"$f":"(Q6+Q7)*Basis!$J$27","v":0},{"$f":"(R6+R7)*Basis!$J$27","v":0},{"$f":"(S6+S7)*Basis!$J$27","v":0},{"$f":"(T6+T7)*Basis!$J$27","v":0},{"$f":"(U6+U7)*Basis!$J$27","v":0},{"$f":"(V6+V7)*Basis!$J$27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Investment",{"$f":"CAPEX!G26","v":{"$error":"#REF!"}},{"$f":"CAPEX!G27","v":0},{"$f":"CAPEX!G28","v":0},{"$f":"CAPEX!G29","v":0},{"$f":"CAPEX!G30","v":0},{"$f":"CAPEX!G31","v":0},{"$f":"CAPEX!G32","v":0},{"$f":"CAPEX!G33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fee Gerace period",{"$f":"IF(O25/O22<1,O25/O22,IF(O25/(O22+O23)<1,1+(O25-O22)/O23,IF(O25/(O22+O23+O24)<1,2+(O25-O22-O23)/O24)))","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"year",null,null,{"$f":"CAPEX!G26/(O6+O7)","v":{"$error":"#REF!"}},{"$f":"CAPEX!G27/(P6+P7)","v":{"$error":"#DIV/0!"}},{"$f":"CAPEX!G28/(Q6+Q7)","v":{"$error":"#DIV/0!"}},{"$f":"CAPEX!G29/(R6+R7)","v":{"$error":"#DIV/0!"}},{"$f":"CAPEX!G30/(Feed!S6+S7)","v":{"$error":"#DIV/0!"}},{"$f":"CAPEX!G31/(Feed!T6+T7)","v":{"$error":"#DIV/0!"}},{"$f":"CAPEX!G32/(Feed!U6+U7)","v":{"$error":"#DIV/0!"}},{"$f":"CAPEX!G33/(Feed!V6+V7)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Feed Grace Period months",null,null,{"$f":"12*P46","v":{"$error":"#REF!"}},{"$f":"12*Q46","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"part of 3rd yr",null,null,{"$f":"P46-2","v":{"$error":"#REF!"}},{"$f":"Q46-2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"month of 3rd yr",null,null,{"$f":"P48*12","v":{"$error":"#REF!"}},{"$f":"Q48*12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Revenue","index":3,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,12,2,19],[2,2,3,2],[1,1,1,3],[2,3,3,3],[2,1,3,1],[2,4,2,11]]}
[]
[null,"Revenue"]
[null,"items","Description","Unit Price, $/T","Annual Production (kta)",null,null,null,null,null,null,null,"Sales, MM$/Y"]
[null,null,null,null,"Scheme 1","Scheme 2",null,null,null,null,null,null,"Scheme 1, Base \ncase","Scheme 2\nWithout NHT"]
[null,1,"LPG",{"$f":"Basis!D8","v":565},{"$f":"E19*$D$31/1000","v":81.742320000000007},{"$f":"F19*$D$31/1000","v":81.742320000000007},{"$f":"G19*$D$31/1000","v":0},{"$f":"H19*$D$31/1000","v":0},{"$f":"I19*$D$31/1000","v":0},{"$f":"J19*$D$31/1000","v":0},{"$f":"K19*$D$31/1000","v":0},{"$f":"L19*$D$31/1000","v":0},{"$f":"D5*E5/1000","v":46.184410800000002},{"$f":"D5*F5/1000","v":46.184410800000002}]
[null,2,"Kerosene, Jet A1",{"$f":"Basis!D12","v":790},{"$f":"E20*$D$31/1000","v":0},{"$f":"F20*$D$31/1000","v":0},{"$f":"G20*$D$31/1000","v":0},{"$f":"H20*$D$31/1000","v":0},{"$f":"I20*$D$31/1000","v":0},{"$f":"J20*$D$31/1000","v":0},{"$f":"K20*$D$31/1000","v":0},{"$f":"L20*$D$31/1000","v":0},{"$f":"D6*E6/1000","v":0},{"$f":"D6*F6/1000","v":0}]
[null,3,"Gasoil",{"$f":"Basis!D13","v":724},{"$f":"E21*$D$31/1000","v":763.98696000000007},763.98696000000007,{"$f":"G21*$D$31/1000","v":0},{"$f":"H21*$D$31/1000","v":0},{"$f":"I21*$D$31/1000","v":0},{"$f":"J21*$D$31/1000","v":0},{"$f":"K21*$D$31/1000","v":0},{"$f":"L21*$D$31/1000","v":0},553.12655904000007,553.12655904000007]
[null,4,"Light Naphtha",{"$f":"Basis!D44","v":645},{"$f":"E22*$D$31/1000","v":486.10914000000002},0,{"$f":"G22*$D$31/1000","v":0.10932068490628848},{"$error":"#VALUE!"},0,0,0,0,313.54039530000006,0]
[null,5,"Heavy Naphtha",{"$f":"Basis!D45","v":668},{"$f":"E23*$D$31/1000","v":226.824378},0,{"$f":"G23*$D$31/1000","v":0},0,0,0,0,0,151.51868450399999,0]
[null,6,"Fuel Oil",{"$f":"Basis!D16","v":465},{"$f":"E24*$D$31/1000","v":9.1080000000000005},9.1080000000000005,{"$f":"G24*$D$31/1000","v":0},0,0,0,0,0,4.23522,4.23522]
[null,7,"MEDIUM  NAPHTHA(CCR FEED)",{"$f":"Basis!D45","v":668},{"$f":"E25*$D$31/1000","v":754.45590000000004},0,{"$f":"G25*$D$31/1000","v":0},0,0,0,0,0,503.97654120000004,0]
[null,8,"Sulfur",{"$f":"Basis!D14","v":125},{"$f":"E26*$D$31/1000","v":0},0,{"$f":"G26*$D$31/1000","v":0},0,0,0,0,0,0,0]
[null,null,"Full Range Naphtha",{"$f":"(Basis!D45*67%+D8*33%)-50","v":610.41000000000008},null,1467.3894179999998,null,null,null,null,null,null,null,895.70917464137995]
[null,"Total",null,null,{"$f":"SUM(E5:E13)","v":2322.2266979999999},{"$f":"SUM(F5:F13)","v":2322.2266979999995},{"$f":"SUM(G5:G12)","v":0.10932068490628848},{"$f":"SUM(H5:H12)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I5:I12)","v":0},{"$f":"SUM(J5:J12)","v":0},{"$f":"SUM(K5:K12)","v":0},{"$f":"SUM(L5:L12)","v":0},{"$f":"SUM(M5:M12)","v":1572.5818108440003},{"$f":"SUM(N5:N13)","v":1499.2553644813802}]
[]
[null,null,"Flow Rate (TPD)"]
[null,null,null,null,"MB-Sch 1","MB-Sch 2"]
[null,null,null,"BPSD","TPD","TPD"]
[null,1,"LPG",2764,247.70400000000001,247.70400000000001]
[null,2,"Kerosene, Jet A1",0,0,0]
[null,3,"Gasoil",17577,2315.1120000000001,2315.1120000000001]
[null,4,"Light Naphtha",13944.95,1473.058,0,{"$f":"E22/F27","v":0.3312748027463287},"of full rane Naphtha"]
[null,5,"Heavy Naphtha",5631.058,687.34659999999997,0]
[null,6,"Fuel Oil",197,{"$f":"27.6","v":27.6},{"$f":"27.6","v":27.6}]
[null,7,"MEDIUM  NAPHTHA( CCR FEED)",19429.349999999999,2286.23,0]
[null,8,"Sulfur",null,{"$f":"D26*0.159*755/1000","v":0},0]
[null,null,"Full Range Naphtha",null,0,{"$f":"E22+E23+E25","v":4446.6345999999994}]
[null,null,"TPD",null,{"$f":"SUM(E18:E27)","v":7037.0506000000005},{"$f":"SUM(F18:F27)","v":7037.0505999999996}]
[null,null,"KTA",null,{"$f":"E28*$D$31/1000","v":2322.2266980000004},{"$f":"F28*$D$31/1000","v":2322.2266979999999}]
[]
[null,null,"On stream day",{"$f":"Basis!H33","v":330}]

{"sheet":"Utility","index":4,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,4,3,4],[2,3,3,3],[2,2,3,2],[2,16,2,23],[1,2,1,23],[17,8,17,14],[2,8,2,14],[2,7,3,7],[2,6,3,6],[2,5,3,5]]}
[]
[null,null," Utilities Cost"]
[null,null,"items","Description","Max. Operation","Unit Price","Unit","Consumption\nUnit","Consumption",null,null,null,null,null,null,null,"Cost, MM$/Y"]
[null,null,null,null,null,null,null,null,"Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9","Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9"]
[null,null,1,"Power",null,null,"$/ MWh","MW",126,126,126,126,126,126,126,{"$f":"I5","v":126},{"$f":"$F$5*I5*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"Steam",null,null,"$/ t","t/h",700,700,700,700,700,700,700,{"$f":"I6","v":700},{"$f":"$F$6*I6*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"BFW",null,null,"$/ m3","m3/h",null,null,null,null,null,null,null,null,{"$f":"$F$7*I7*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"DMW",null,null,"$/ m3","m3/h",null,null,null,null,null,null,null,null,{"$f":"$F$8*I8*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"Fire make up water",null,null,"$/ m3","m3/h",null,null,null,null,null,null,null,null,{"$f":"$F$9*I9*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"Potable water",null,{"$f":"100000/800000","v":0.125},"$/ m3","m3/h",15,null,null,null,null,null,null,null,{"$f":"$F$13*I10*24*330/10^6","v":7.4250000000000002E-3},{"$f":"$F$10*J10*24*330/10^6","v":0},0,0,0,0,0,0]
[null,null,1,"Sea Water",null,null,"$/ m3","m3/h",null,null,null,null,null,null,null,null,{"$f":"$F$13*I11*24*330/10^6","v":0},{"$f":"$F$11*J11*24*330/10^6","v":0},0,0,0,0,0,0]
[null,null,1,"NG for H2  feed   2740 Nm3/hr",null,{"$f":"100000/800000","v":0.125},"$/ Nm3","Nm3/h",2740,null,null,null,null,null,null,null,1.3563000000000001,{"$f":"$F$12*J12*24*330/10^6","v":0},0,0,0,0,0,0]
[null,null,1,"NG as fuel",null,{"$f":"50000/800000","v":6.25E-2},"$/ Nm3","Nm3/h",17370,null,null,null,null,null,null,null,{"$f":"$F$13*I13*24*330/10^6","v":8.5981500000000004},0,0,0,0,0,0,0]
[null,null,1,"Plant Air",null,null,"$/ Nm3","Nm3/h",null,null,null,null,null,null,null,null,{"$f":"$F$14*I14*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"Nitrogen",null,null,"$/ Nm3","Nm3/h",null,null,null,null,null,null,null,null,{"$f":"$F$15*I15*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,"Desal Water",null,null,"$/ m3","m3/h",null,null,null,null,null,null,null,null,{"$f":"$F$16*I16*24*330/10^6","v":0},0,0,0,0,0,0,0]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"F17*I17*24*330/10^9","v":0},0,0,0,0,0,0,0]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(Q5:Q17)","v":9.9618750000000009},{"$f":"SUM(R7:R11)+R16+R5","v":0},0,0,0,0,0,0]

{"sheet":"Chem.","index":5,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,7,3,7],[2,8,2,14],[1,2,1,10],[1,11,1,24],[2,17,2,24],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
[]
[null,null,"Chemicals and Catalyst Cost"]
[null,null,"items","Description","Max. Operation","Unit Price","Unit","Consumption\nUnit","Consumption",null,null,null,null,null,null,null,null,"Cost, MM$/Y"]
[null,null,null,null,null,null,null,null,"Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9","Scheme 10","Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9"]
[null,null,1,"Chemicals",null,null,null,null,{"$f":"E5*29.8","v":0},null,null,null,null,null,null,null,null,{"$f":"F5*I5*24*330/10^6","v":0}]
[null,null,2,"Catalyst",null,null,null,null,{"$f":"E6*2500","v":0},null,null,null,null,null,null,null,null,0]
[null,null,3,null,null,null,null,null,{"$f":"E7*13400*22.4/17.05","v":0},null,null,null,null,null,null,null,null,0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F13*I13*24*330/10^9","v":0}]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/100*Feed!O13","v":14.493653198639997},{"$f":"2/100*(Feed!P6+Feed!P7)","v":0},{"$f":"2/100*(Feed!Q6+Feed!Q7)","v":0},{"$f":"2/100*(Feed!R6+Feed!R7)","v":0},{"$f":"2/100*(Feed!S6+Feed!S7)","v":0},{"$f":"2/100*(Feed!T6+Feed!T7)","v":0},{"$f":"2/100*(Feed!U6+Feed!U7)","v":0},{"$f":"2/100*(Feed!V6+Feed!V7)","v":0}]

{"sheet":"Manpower","index":6,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":true,"merged":[[49,2,50,2],[52,1,52,2],[6,7,6,11],[51,1,51,2],[2,1,4,11],[8,1,23,1],[8,2,13,2],[14,2,23,2],[24,1,50,1],[24,2,29,2],[30,2,33,2],[34,2,36,2],[37,2,40,2],[41,2,44,2],[45,2,48,2]]}
[]
[]
[null,"MANPOWER ESTIMATION"]
[]
[]
[]
[null,null,null,null,null,null,null,"Dehloran"]
[null,null,null,"Dep./category","Daily\nTime WorK","Shift\nTime WorK","NGL 3200","Olefin\n Unit","HDPE\n Unit","LLDPE Unit","PP \nUnit","General"]
[null,"Direct Staff","Operation","Plant Manager","x",null,null,null,null,null,null,1]
[null,null,null,"Supervisor","x",null,null,null,null,null,null,1]
[null,null,null,"Shift Supervisor",null,"x",null,4,4,4,4]
[null,null,null,"Board Man",null,"x",null,44,20,20,20]
[null,null,null,"Site Man",null,"x",null,52,24,24,24]
[null,null,null,"Worker",null,"x",null,8,4,4,4]
[null,null,"Maintenance","Electrical","x",null,null,1,1,1,1]
[null,null,null,null,null,"x",null,8,4,4,4]
[null,null,null,"Instrument","x",null,null,1,1,1,1]
[null,null,null,null,null,"x",null,8,4,4,4]
[null,null,null,"Analyser","x",null,null,null,null,null,null,1]
[null,null,null,null,null,"x",null,null,null,null,null,12]
[null,null,null,"Mechanical","x",null,null,1,1,1,1]
[null,null,null,null,null,"x",null,8,4,4,4]
[null,null,null,"Maintenance Services","x",null,null,null,null,null,null,10]
[null,null,null,null,null,"x",null,null,null,null,null,50]
[null,"Indirect Staff","Technical Services","Labratory Dep.","x",null,null,2,2,2,2]
[null,null,null,null,null,"x",null,8,4,4,4]
[null,null,null,"Process Engineering Dep.","x",null,null,null,null,null,null,6]
[null,null,null,"R&D Dep.","x",null,null,null,null,null,null,2]
[null,null,null,"General Engineering Dep.","x",null,null,null,null,null,null,7]
[null,null,null,"Inspection & QC","x",null,null,null,null,null,null,11]
[null,null,"Management\nPlanning","Director Manager","x",null,null,null,null,null,null,1]
[null,null,null,"Complex Manager","x",null,null,null,null,null,null,1]
[null,null,null,"Planning","x",null,null,null,null,null,null,6]
[null,null,null,"IT Dep.","x",null,null,null,null,null,null,3]
[null,null,"Human resources","Human resources","x",null,null,null,null,null,null,5]
[null,null,null,"Human resources Service ","x",null,null,null,null,null,null,5]
[null,null,null,"Trainig Dep.","x",null,null,null,null,null,null,2]
[null,null,"Commercial Dep.","Sales Dep.","x",null,null,null,null,null,null,5]
[null,null,null,"Procurment Dep.","x",null,null,null,null,null,null,8]
[null,null,null,"Inventory Dep.","x",null,null,null,null,null,null,12]
[null,null,null,"Indent Regulator","x",null,null,null,null,null,null,3]
[null,null,"Financial Dep.","Cost Accunting","x",null,null,null,null,null,null,10]
[null,null,null,"Financial Accounting","x",null,null,null,null,null,null,5]
[null,null,null,"Internal Auditing","x",null,null,null,null,null,null,3]
[null,null,null,"Management Accounting","x",null,null,null,null,null,null,4]
[null,null,"HSE Dep.","Fire fighting Dep.","x",null,null,null,null,null,null,3]
[null,null,null,null,null,"x",null,null,null,null,null,36]
[null,null,null,"Safety",null,"x",null,null,null,null,null,12]
[null,null,null,"Environment & Healthy Dep.","x",null,null,null,null,null,null,1]
[null,null,"Security Dep.",null,"x",null,null,null,null,null,null,4]
[null,null,null,null,null,"x",null,null,null,null,null,60]
[null,"Total Persons: ",null,null,null,null,314,{"$f":"SUM(H9:H26)","v":145},{"$f":"SUM(I9:I26)","v":73},{"$f":"SUM(J9:J26)","v":73},{"$f":"SUM(K9:K26)","v":73},{"$f":"SUM(L9:L51)","v":290}]
[null,"Total Labor Cost (MM $/Year)",null,null,null,null,{"$f":"12*G52*60000000/50000/10^6","v":4.5216000000000003},{"$f":"12*H52*60000000/50000/10^6","v":2.0880000000000001},{"$f":"12*I52*60000000/50000/10^6","v":1.0511999999999999},{"$f":"12*J52*60000000/50000/10^6","v":1.0511999999999999},{"$f":"12*K52*60000000/50000/10^6","v":1.0511999999999999},{"$f":"12*L52*40000000/50000/10^6","v":2.7839999999999998}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L53/2","v":1.3919999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L56/6","v":0.23199999999999998}]

{"sheet":"Opex","index":7,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,4,5,6],[6,4,6,6],[7,4,7,6],[15,4,15,6],[16,1,16,6],[1,7,1,14],[10,7,10,14],[11,1,12,1],[11,2,12,2],[11,7,11,14],[8,1,8,6],[2,7,2,14],[2,2,3,2],[2,1,3,1],[2,3,3,3],[2,4,3,6],[13,4,13,6],[14,4,14,6],[4,3,4,6]]}
[]
[null," Fixed Operating Cost"]
[null,"items","Description","Percent of Fixed Cost","Remark",null,null,"Costs, MM$/Y"]
[null,null,null,null,null,null,null,"Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9"]
[null,1,"Labor","Plant organization chart",null,null,null,6,6]
[null,2,"Maintenance Cost",7.0000000000000001E-3,"Of fixed Investment",null,null,{"$f":"$D$6*CAPEX!P11","v":3.5089298145256764},{"$f":"D6*(CAPEX!$P$11-CAPEX!$P$12)","v":3.1032866693254832}]
[null,3,"Insurance",1E-3,"Of fixed Investment",null,null,{"$f":"$D$7*CAPEX!P11","v":0.50127568778938236},{"$f":"D7*(CAPEX!$P$11-CAPEX!$P$12)","v":0.44332666704649765}]
[null,4,"Plant Overhead",6.0000000000000001E-3,"Of fixed Investment",null,null,{"$f":"$D$8*CAPEX!P11","v":3.007654126736294},{"$f":"D8*(CAPEX!$P$11-CAPEX!$P$12)","v":2.6599600022789858}]
[null,"Total Fixed Costs",null,null,null,null,null,{"$f":"SUM(H5:H8)","v":13.017859629051351},{"$f":"SUM(I5:I8)","v":12.206573338650966},0,0,0,0,0,0]
[]
[null," Variable Operating Cost"]
[null,"items","Description",null,"Remark",null,null,"Costs, MM$/Y"]
[null,null,null,null,null,null,null,"Scheme 1","Scheme 2","Scheme 3","Scheme 4","Scheme 5","Scheme 6","Scheme 7","Scheme 9"]
[null,1,"Feed",null,null,null,null,{"$f":"Feed!O13","v":1449.3653198639997},{"$f":"Feed!O13","v":1449.3653198639997}]
[null,2,"Utility",null,null,null,null,{"$f":"Utility!Q18","v":9.9618750000000009},{"$f":"Utility!Q18","v":9.9618750000000009}]
[null,3,"Chemical & catalyst",null,null,null,null,{"$f":"'Chem.'!R14","v":14.493653198639997},{"$f":"'Chem.'!R14","v":14.493653198639997}]
[null,"Total Variable Costs",null,null,null,null,null,{"$f":"SUM(H14:H16)","v":1473.8208480626397},{"$f":"SUM(I14:I16)","v":1473.8208480626397},{"$f":"SUM(J15:J16)","v":0},{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(L15:L16)","v":0},{"$f":"SUM(M15:M16)","v":0},{"$f":"SUM(N15:N16)","v":0},{"$f":"SUM(O15:O16)","v":0}]

{"sheet":"feed grace","index":8,"n_rows":81,"n_cols":18,"rows_kept":81,"cut":false,"hidden":false,"merged":[[78,1,79,1]]}
[]
[null," Feed Loan for the frst Year of Grace Period"]
[null,"Description","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,"Origin Loan",{"$f":"IF(Feed!O26>1,Feed!O22,Feed!O22*Feed!O26)","v":{"$error":"#REF!"}},null,{"$f":"IF(Feed!P26>1,Feed!P22,Feed!P22*Feed!P26)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!Q26>1,Feed!Q22,Feed!O22*Feed!Q26)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!R26>1,Feed!R22,Feed!R22*Feed!R26)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!S26>1,Feed!S22,Feed!S22*Feed!S26)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!T26>1,Feed!T22,Feed!T22*Feed!T26)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!U26>1,Feed!U22,Feed!U22*Feed!U26)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!V26>1,Feed!V22,Feed!V22*Feed!V26)","v":{"$error":"#DIV/0!"}}]
[null,"Garce Period (months)",{"$f":"Feed!O26*12","v":{"$error":"#REF!"}},null,{"$f":"Feed!P26*12","v":{"$error":"#DIV/0!"}},null,{"$f":"Feed!Q26*12","v":{"$error":"#DIV/0!"}},null,{"$f":"Feed!R26*12","v":{"$error":"#DIV/0!"}},null,{"$f":"Feed!S26*12","v":{"$error":"#DIV/0!"}},null,{"$f":"Feed!T26*12","v":{"$error":"#DIV/0!"}},null,{"$f":"Feed!U26*12","v":{"$error":"#DIV/0!"}},null,{"$f":"Feed!V26*12","v":{"$error":"#DIV/0!"}}]
[null,"Interest on Grace Period for the fist year",{"$f":"Basis!H50*(0+Basis!H30)/2","v":0.04},null,{"$f":"C6","v":0.04},null,{"$f":"C6","v":0.04},null,{"$f":"C6","v":0.04},null,{"$f":"C6","v":0.04},null,{"$f":"C6","v":0.04},null,{"$f":"C6","v":0.04},null,{"$f":"C6","v":0.04}]
[null,"Interest on Grace Period for the Second year",{"$f":"Basis!H50*Basis!H30","v":0.08},null,{"$f":"C7","v":0.08},null,{"$f":"C7","v":0.08},null,{"$f":"C7","v":0.08},null,{"$f":"C7","v":0.08},null,{"$f":"C7","v":0.08},null,{"$f":"C7","v":0.08},null,{"$f":"C7","v":0.08}]
[null,"Interest on Grace Period for the 3rd year",{"$f":"Basis!H50*Basis!H30","v":0.08},null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[null,"Interest on Grace Period fist yr",{"$f":"C6*C4","v":{"$error":"#REF!"}},null,{"$f":"E6*E4","v":{"$error":"#DIV/0!"}},null,{"$f":"G6*G4","v":{"$error":"#DIV/0!"}},null,{"$f":"I6*I4","v":{"$error":"#DIV/0!"}},null,{"$f":"K6*K4","v":{"$error":"#DIV/0!"}},null,{"$f":"M6*M4","v":{"$error":"#DIV/0!"}},null,{"$f":"O6*O4","v":{"$error":"#DIV/0!"}},null,{"$f":"Q6*Q4","v":{"$error":"#DIV/0!"}}]
[null,"Interest on Grace Period secnd yr",{"$f":"C4*C7","v":{"$error":"#REF!"}},null,{"$f":"E4*E7","v":{"$error":"#DIV/0!"}},null,{"$f":"G4*G7*(G5-12)/12+G4*G6","v":{"$error":"#DIV/0!"}},null,{"$f":"I4*I7","v":{"$error":"#DIV/0!"}},null,{"$f":"K4*K7","v":{"$error":"#DIV/0!"}},null,{"$f":"M4*M7","v":{"$error":"#DIV/0!"}},null,{"$f":"O4*O7","v":{"$error":"#DIV/0!"}},null,{"$f":"Q4*Q7","v":{"$error":"#DIV/0!"}}]
[null,"Interest on Grace Period 3rd yr",{"$f":"C4*C8*(C5-24)/12","v":{"$error":"#REF!"}},null,{"$f":"E4*E8*(E5-24)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"G4*G8*(G5-24)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"I4*I8*(I5-24)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"K4*K8*(K5-24)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"M4*M8*(M5-24)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"O4*O8*(O5-24)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"Q4*Q8*(Q5-24)/12","v":{"$error":"#DIV/0!"}}]
[null,"Total Loan Origin and Grace period interest",{"$f":"C4+SUM(C9:C11)","v":{"$error":"#REF!"}},null,{"$f":"E4+SUM(E9:E11)","v":{"$error":"#DIV/0!"}},null,{"$f":"G4+G9+G10","v":{"$error":"#DIV/0!"}},null,{"$f":"I4+I9+I10+I11","v":{"$error":"#DIV/0!"}},null,{"$f":"K4+K9+K10+K11","v":{"$error":"#DIV/0!"}},null,{"$f":"M4+M9+M10+M11","v":{"$error":"#DIV/0!"}},null,{"$f":"O4+O9+O10+O11","v":{"$error":"#DIV/0!"}},null,{"$f":"Q4+Q9+Q10+Q11","v":{"$error":"#DIV/0!"}}]
[null," Total Repayment period (months)",{"$f":"Basis!I30*12","v":96},null,{"$f":"C13","v":96},null,{"$f":"C13","v":96},null,{"$f":"C13","v":96},null,{"$f":"C13","v":96},null,{"$f":"C13","v":96},null,{"$f":"C13","v":96},null,{"$f":"E13","v":96}]
[null,"\ninstalment interval",12,null,{"$f":"C14","v":12},null,{"$f":"C14","v":12},null,{"$f":"C14","v":12},null,{"$f":"C14","v":12},null,{"$f":"C14","v":12},null,{"$f":"C14","v":12},null,{"$f":"E14","v":12}]
[null,"PMT (Annual)",{"$f":"PMT(Basis!H30,Basis!I30,-'feed grace'!C12)","v":{"$error":"#REF!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-'feed grace'!E12)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-G12)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-I12)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-K12)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-M12)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-O12)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-Q12)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Loan Pay back","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,"Payment years","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate"]
[null,1,{"$f":"C15-D19","v":{"$error":"#REF!"}},{"$f":"C12*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F19","v":{"$error":"#DIV/0!"}},{"$f":"E12*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J19","v":{"$error":"#DIV/0!"}},{"$f":"I12*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L19","v":{"$error":"#DIV/0!"}},{"$f":"K12*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N19","v":{"$error":"#DIV/0!"}},{"$f":"M12*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P19","v":{"$error":"#DIV/0!"}},{"$f":"O12*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R19","v":{"$error":"#DIV/0!"}},{"$f":"Q12*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"C15-D20","v":{"$error":"#REF!"}},{"$f":"(C12-C19)*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F20","v":{"$error":"#DIV/0!"}},{"$f":"(E12-E19)*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J20","v":{"$error":"#DIV/0!"}},{"$f":"(I12-I19)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L20","v":{"$error":"#DIV/0!"}},{"$f":"(K12-K19)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N20","v":{"$error":"#DIV/0!"}},{"$f":"(M12-M19)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P20","v":{"$error":"#DIV/0!"}},{"$f":"(O12-O19)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R20","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-Q19)*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"C15-D21","v":{"$error":"#REF!"}},{"$f":"(C12-C19-C20)*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F21","v":{"$error":"#DIV/0!"}},{"$f":"(E12-E19-E20)*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J21","v":{"$error":"#DIV/0!"}},{"$f":"(I12-I19-I20)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L21","v":{"$error":"#DIV/0!"}},{"$f":"(K12-K19-K20)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N21","v":{"$error":"#DIV/0!"}},{"$f":"(M12-M19-M20)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P21","v":{"$error":"#DIV/0!"}},{"$f":"(O12-O19-O20)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R21","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-Q19-Q20)*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"C15-D22","v":{"$error":"#REF!"}},{"$f":"(C12-SUM(C19:C21))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F22","v":{"$error":"#DIV/0!"}},{"$f":"(E12-SUM(E19:E21))*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J22","v":{"$error":"#DIV/0!"}},{"$f":"(I12-SUM(I19:I21))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L22","v":{"$error":"#DIV/0!"}},{"$f":"(K12-SUM(K19:K21))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N22","v":{"$error":"#DIV/0!"}},{"$f":"(M12-SUM(M19:M21))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P22","v":{"$error":"#DIV/0!"}},{"$f":"(O12-SUM(O19:O21))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R22","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-SUM(Q19:Q21))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,5,{"$f":"C15-D23","v":{"$error":"#REF!"}},{"$f":"(C12-SUM(C19:C22))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F23","v":{"$error":"#DIV/0!"}},{"$f":"(E12-SUM(E19:E22))*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J23","v":{"$error":"#DIV/0!"}},{"$f":"(I12-SUM(I19:I22))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L23","v":{"$error":"#DIV/0!"}},{"$f":"(K12-SUM(K19:K22))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N23","v":{"$error":"#DIV/0!"}},{"$f":"(M12-SUM(M19:M22))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P23","v":{"$error":"#DIV/0!"}},{"$f":"(O12-SUM(O19:O22))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R23","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-SUM(Q19:Q22))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,6,{"$f":"C15-D24","v":{"$error":"#REF!"}},{"$f":"(C12-SUM(C19:C23))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F24","v":{"$error":"#DIV/0!"}},{"$f":"(E12-SUM(E19:E23))*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J24","v":{"$error":"#DIV/0!"}},{"$f":"(I12-SUM(I19:I23))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L24","v":{"$error":"#DIV/0!"}},{"$f":"(K12-SUM(K19:K23))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N24","v":{"$error":"#DIV/0!"}},{"$f":"(M12-SUM(M19:M23))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P24","v":{"$error":"#DIV/0!"}},{"$f":"(O12-SUM(O19:O23))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R24","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-SUM(Q19:Q23))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,7,{"$f":"C15-D25","v":{"$error":"#REF!"}},{"$f":"(C12-SUM(C19:C24))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F25","v":{"$error":"#DIV/0!"}},{"$f":"(E12-SUM(E19:E24))*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J25","v":{"$error":"#DIV/0!"}},{"$f":"(I12-SUM(I19:I24))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L25","v":{"$error":"#DIV/0!"}},{"$f":"(K12-SUM(K19:K24))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N25","v":{"$error":"#DIV/0!"}},{"$f":"(M12-SUM(M19:M24))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P25","v":{"$error":"#DIV/0!"}},{"$f":"(O12-SUM(O19:O24))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R25","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-SUM(Q19:Q24))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,8,{"$f":"C15-D26","v":{"$error":"#REF!"}},{"$f":"(C12-SUM(C19:C25))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E15-F26","v":{"$error":"#DIV/0!"}},{"$f":"(E12-SUM(E19:E25))*Basis!H30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I15-J26","v":{"$error":"#DIV/0!"}},{"$f":"(I12-SUM(I19:I25))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K15-L26","v":{"$error":"#DIV/0!"}},{"$f":"(K12-SUM(K19:K25))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M15-N26","v":{"$error":"#DIV/0!"}},{"$f":"(M12-SUM(M19:M25))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O15-P26","v":{"$error":"#DIV/0!"}},{"$f":"(O12-SUM(O19:O25))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q15-R26","v":{"$error":"#DIV/0!"}},{"$f":"(Q12-SUM(Q19:Q25))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,"Total ",{"$f":"SUM(C19:C26)","v":{"$error":"#REF!"}},{"$f":"SUM(D19:D26)","v":{"$error":"#REF!"}},{"$f":"SUM(E19:E26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F19:F26)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(I19:I26)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[null," Feed Loan for the scnd Year of Grace Period"]
[null,"Description","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,"Origin Loan",{"$f":"IF(Feed!O26>2,Feed!O23,Feed!O23*(Feed!O26-1))","v":{"$error":"#REF!"}},null,{"$f":"IF(Feed!P26>2,Feed!P23,Feed!P23*(Feed!P26-1))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!Q26>2,Feed!Q23,Feed!Q23*(Feed!Q26-1))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!R26>2,Feed!R23,Feed!R23*(Feed!R26-1))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!S26>2,Feed!S23,Feed!S23*(Feed!S26-1))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!T26>2,Feed!T23,Feed!T23*(Feed!T26-1))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!U26>2,Feed!U23,Feed!U23*(Feed!U26-1))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!V26>2,Feed!V23,Feed!V23*(Feed!V26-1))","v":{"$error":"#DIV/0!"}}]
[null,"Garce Period (months)",{"$f":"C5-12","v":{"$error":"#REF!"}},null,{"$f":"E5-12","v":{"$error":"#DIV/0!"}},null,{"$f":"G5-12","v":{"$error":"#DIV/0!"}},null,{"$f":"I5-12","v":{"$error":"#DIV/0!"}},null,{"$f":"K5-12","v":{"$error":"#DIV/0!"}},null,{"$f":"M5-12","v":{"$error":"#DIV/0!"}},null,{"$f":"O5-12","v":{"$error":"#DIV/0!"}},null,{"$f":"Q5-12","v":{"$error":"#DIV/0!"}}]
[null,"Interest on Grace Period for the2nd year",{"$f":"Basis!H50*4%","v":0.04},null,{"$f":"C35","v":0.04},null,{"$f":"C35","v":0.04},null,{"$f":"C35","v":0.04},null,{"$f":"C35","v":0.04},null,{"$f":"C35","v":0.04},null,{"$f":"C35","v":0.04},null,0.04]
[null,"Interest on Grace Period for the 3rd year",{"$f":"Basis!H50*8%","v":0.08},null,{"$f":"C36","v":0.08},null,{"$f":"C36","v":0.08},null,{"$f":"C36","v":0.08},null,{"$f":"C36","v":0.08},null,{"$f":"C36","v":0.08},null,{"$f":"C36","v":0.08},null,0.08]
[null,"Interest on Grace Period 2nd yr",{"$f":"C35*C33","v":{"$error":"#REF!"}},null,{"$f":"E35*E33","v":{"$error":"#DIV/0!"}},null,{"$f":"G35*G33*G34/12","v":{"$error":"#DIV/0!"}},null,{"$f":"I35*I33","v":{"$error":"#DIV/0!"}},null,{"$f":"K35*K33","v":{"$error":"#DIV/0!"}},null,{"$f":"M35*M33","v":{"$error":"#DIV/0!"}},null,{"$f":"O35*O33","v":{"$error":"#DIV/0!"}},null,{"$f":"Q35*Q33","v":{"$error":"#DIV/0!"}}]
[null,"Interest on Grace Period 3rd yr",{"$f":"C33*C36*(C34-12)/12","v":{"$error":"#REF!"}},null,{"$f":"E33*E36*(E34-12)/12","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"I33*I36*(I34-12)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"K33*K36*(K34-12)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"M33*M36*(M34-12)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"O33*O36*(O34-12)/12","v":{"$error":"#DIV/0!"}},null,{"$f":"Q33*Q36*(Q34-12)/12","v":{"$error":"#DIV/0!"}}]
[null,"Total Loan Origin and Grace period interest",{"$f":"C33+C37+C38","v":{"$error":"#REF!"}},null,{"$f":"E33+E37+E38","v":{"$error":"#DIV/0!"}},null,{"$f":"G33+G37+#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"I33+I37+I38","v":{"$error":"#DIV/0!"}},null,{"$f":"K33+K37+K38","v":{"$error":"#DIV/0!"}},null,{"$f":"M33+M37+M38","v":{"$error":"#DIV/0!"}},null,{"$f":"O33+O37+O38","v":{"$error":"#DIV/0!"}},null,{"$f":"Q33+Q37+Q38","v":{"$error":"#DIV/0!"}}]
[null," Total Repayment period (months)",{"$f":"Basis!I30*12","v":96},null,{"$f":"C40","v":96},null,{"$f":"C40","v":96},null,{"$f":"C40","v":96},null,{"$f":"C40","v":96},null,{"$f":"C40","v":96},null,{"$f":"C40","v":96},null,{"$f":"E40","v":96}]
[null,"\ninstalment interval",12,null,{"$f":"C41","v":12},null,{"$f":"C41","v":12},null,{"$f":"C41","v":12},null,{"$f":"C41","v":12},null,{"$f":"C41","v":12},null,{"$f":"C41","v":12},null,{"$f":"E41","v":12}]
[null,"PMT (Annual)",{"$f":"PMT(Basis!H30,Basis!I30,-C39)","v":{"$error":"#REF!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-E39)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-G39)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-I39)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-K39)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-M39)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-O39)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-Q39)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Loan Pay back","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,"Payment years","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate"]
[null,1,{"$f":"C42-D46","v":{"$error":"#REF!"}},{"$f":"C39*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F46","v":{"$error":"#DIV/0!"}},{"$f":"E39*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H46","v":{"$error":"#DIV/0!"}},{"$f":"G39*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J46","v":{"$error":"#DIV/0!"}},{"$f":"I39*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L46","v":{"$error":"#DIV/0!"}},{"$f":"K39*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N46","v":{"$error":"#DIV/0!"}},{"$f":"M39*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P46","v":{"$error":"#DIV/0!"}},{"$f":"O39*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R46","v":{"$error":"#DIV/0!"}},{"$f":"Q39*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"C42-D47","v":{"$error":"#REF!"}},{"$f":"(C39-C46)*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F47","v":{"$error":"#DIV/0!"}},{"$f":"(E39-E46)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H47","v":{"$error":"#DIV/0!"}},{"$f":"(G39-G46)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J47","v":{"$error":"#DIV/0!"}},{"$f":"(I39-I46)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L47","v":{"$error":"#DIV/0!"}},{"$f":"(K39-K46)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N47","v":{"$error":"#DIV/0!"}},{"$f":"(M39-M46)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P47","v":{"$error":"#DIV/0!"}},{"$f":"(O39-O46)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R47","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-Q46)*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"C42-D48","v":{"$error":"#REF!"}},{"$f":"(C39-C46-C47)*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F48","v":{"$error":"#DIV/0!"}},{"$f":"(E39-E46-E47)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H48","v":{"$error":"#DIV/0!"}},{"$f":"(G39-G46-G47)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J48","v":{"$error":"#DIV/0!"}},{"$f":"(I39-I46-I47)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L48","v":{"$error":"#DIV/0!"}},{"$f":"(K39-K46-K47)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N48","v":{"$error":"#DIV/0!"}},{"$f":"(M39-M46-M47)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P48","v":{"$error":"#DIV/0!"}},{"$f":"(O39-O46-O47)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R48","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-Q46-Q47)*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"C42-D49","v":{"$error":"#REF!"}},{"$f":"(C39-SUM(C46:C48))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F49","v":{"$error":"#DIV/0!"}},{"$f":"(E39-SUM(E46:E48))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H49","v":{"$error":"#DIV/0!"}},{"$f":"(G39-SUM(G46:G48))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J49","v":{"$error":"#DIV/0!"}},{"$f":"(I39-SUM(I46:I48))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L49","v":{"$error":"#DIV/0!"}},{"$f":"(K39-SUM(K46:K48))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N49","v":{"$error":"#DIV/0!"}},{"$f":"(M39-SUM(M46:M48))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P49","v":{"$error":"#DIV/0!"}},{"$f":"(O39-SUM(O46:O48))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R49","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-SUM(Q46:Q48))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,5,{"$f":"C42-D50","v":{"$error":"#REF!"}},{"$f":"(C39-SUM(C46:C49))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F50","v":{"$error":"#DIV/0!"}},{"$f":"(E39-SUM(E46:E49))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H50","v":{"$error":"#DIV/0!"}},{"$f":"(G39-SUM(G46:G49))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J50","v":{"$error":"#DIV/0!"}},{"$f":"(I39-SUM(I46:I49))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L50","v":{"$error":"#DIV/0!"}},{"$f":"(K39-SUM(K46:K49))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N50","v":{"$error":"#DIV/0!"}},{"$f":"(M39-SUM(M46:M49))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P50","v":{"$error":"#DIV/0!"}},{"$f":"(O39-SUM(O46:O49))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R50","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-SUM(Q46:Q49))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,6,{"$f":"C42-D51","v":{"$error":"#REF!"}},{"$f":"(C39-SUM(C46:C50))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F51","v":{"$error":"#DIV/0!"}},{"$f":"(E39-SUM(E46:E50))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H51","v":{"$error":"#DIV/0!"}},{"$f":"(G39-SUM(G46:G50))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J51","v":{"$error":"#DIV/0!"}},{"$f":"(I39-SUM(I46:I50))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L51","v":{"$error":"#DIV/0!"}},{"$f":"(K39-SUM(K46:K50))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N51","v":{"$error":"#DIV/0!"}},{"$f":"(M39-SUM(M46:M50))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P51","v":{"$error":"#DIV/0!"}},{"$f":"(O39-SUM(O46:O50))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R51","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-SUM(Q46:Q50))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,7,{"$f":"C42-D52","v":{"$error":"#REF!"}},{"$f":"(C39-SUM(C46:C51))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F52","v":{"$error":"#DIV/0!"}},{"$f":"(E39-SUM(E46:E51))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H52","v":{"$error":"#DIV/0!"}},{"$f":"(G39-SUM(G46:G51))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J52","v":{"$error":"#DIV/0!"}},{"$f":"(I39-SUM(I46:I51))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L52","v":{"$error":"#DIV/0!"}},{"$f":"(K39-SUM(K46:K51))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N52","v":{"$error":"#DIV/0!"}},{"$f":"(M39-SUM(M46:M51))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P52","v":{"$error":"#DIV/0!"}},{"$f":"(O39-SUM(O46:O51))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R52","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-SUM(Q46:Q51))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,8,{"$f":"C42-D53","v":{"$error":"#REF!"}},{"$f":"(C39-SUM(C46:C52))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E42-F53","v":{"$error":"#DIV/0!"}},{"$f":"(E39-SUM(E46:E52))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G42-H53","v":{"$error":"#DIV/0!"}},{"$f":"(G39-SUM(G46:G52))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"I42-J53","v":{"$error":"#DIV/0!"}},{"$f":"(I39-SUM(I46:I52))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K42-L53","v":{"$error":"#DIV/0!"}},{"$f":"(K39-SUM(K46:K52))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M42-N53","v":{"$error":"#DIV/0!"}},{"$f":"(M39-SUM(M46:M52))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O42-P53","v":{"$error":"#DIV/0!"}},{"$f":"(O39-SUM(O46:O52))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q42-R53","v":{"$error":"#DIV/0!"}},{"$f":"(Q39-SUM(Q46:Q52))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,"Total ",{"$f":"SUM(C46:C53)","v":{"$error":"#REF!"}},{"$f":"SUM(D46:D53)","v":{"$error":"#REF!"}},{"$f":"SUM(E46:E53)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F46:F53)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUM(H46:H53)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUM(J46:J53)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null," Feed Loan for the 3rd Year of Grace Period"]
[null,"Description","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,"Origin Loan",{"$f":"IF(Feed!O26>3,Feed!O23,Feed!O23*(Feed!O26-2))","v":{"$error":"#REF!"}},null,{"$f":"IF(Feed!P26>3,Feed!P23,Feed!P23*(Feed!P26-2))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!Q26>3,Feed!Q23,Feed!Q23*(Feed!Q26-2))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!R26>3,Feed!R23,Feed!R23*(Feed!R26-2))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!S26>3,Feed!S23,Feed!S23*(Feed!S26-2))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!T26>3,Feed!T23,Feed!T23*(Feed!T26-2))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!U26>3,Feed!U23,Feed!U23*(Feed!U26-2))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Feed!V26>3,Feed!V23,Feed!V23*(Feed!V26-2))","v":{"$error":"#DIV/0!"}}]
[null,"Garce Period (months)",{"$f":"C34-12","v":{"$error":"#REF!"}},null,{"$f":"E34-12","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},-12,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"IF(Q34<12,0,Q34-12)","v":{"$error":"#DIV/0!"}}]
[null,"Interest on Grace Period for the 3rd year",{"$f":"Basis!H50*4%","v":0.04},null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04]
[null,"Interest on Grace Period 3rd yr",{"$f":"C58*C60*C59/12","v":{"$error":"#REF!"}},null,{"$f":"E58*E60*E59/12","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"I58*I60*I59/12","v":{"$error":"#DIV/0!"}},null,{"$f":"K58*K60*K59/12","v":{"$error":"#DIV/0!"}},null,{"$f":"M58*M60*M59/12","v":{"$error":"#DIV/0!"}},null,{"$f":"O58*O60*O59/12","v":{"$error":"#DIV/0!"}},null,{"$f":"Q58*Q60*Q59/12","v":{"$error":"#DIV/0!"}}]
[null,"Total Loan Origin and Grace period interest",{"$f":"C58+C61","v":{"$error":"#REF!"}},null,{"$f":"E58+E61","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"I58+I61","v":{"$error":"#DIV/0!"}},null,{"$f":"K58+K61","v":{"$error":"#DIV/0!"}},null,{"$f":"M58+M61","v":{"$error":"#DIV/0!"}},null,{"$f":"O58+O61","v":{"$error":"#DIV/0!"}},null,{"$f":"Q58+Q61","v":{"$error":"#DIV/0!"}}]
[null," Total Repayment period (months)",{"$f":"Basis!I30*12","v":96},null,{"$f":"C63","v":96},null,{"$f":"C63","v":96},null,{"$f":"C63","v":96},null,{"$f":"C63","v":96},null,{"$f":"C63","v":96},null,{"$f":"C63","v":96},null,{"$f":"E63","v":96}]
[null,"\ninstalment interval",12,null,{"$f":"C64","v":12},null,{"$f":"C64","v":12},null,{"$f":"C64","v":12},null,{"$f":"C64","v":12},null,{"$f":"C64","v":12},null,{"$f":"C64","v":12},null,{"$f":"E64","v":12}]
[null,"PMT (Annual)",{"$f":"PMT(Basis!H30,Basis!I30,-C62)","v":{"$error":"#REF!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-E62)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-G62)","v":0},null,{"$f":"PMT(Basis!H30,Basis!I30,-I62)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-K62)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-M62)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-O62)","v":{"$error":"#DIV/0!"}},null,{"$f":"PMT(Basis!H30,Basis!I30,-Q62)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Loan Pay back","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,"Payment years","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate","Pay Back (Orginal)","Finacial Rate"]
[null,1,{"$f":"C65-D69","v":{"$error":"#REF!"}},{"$f":"C62*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F69","v":{"$error":"#DIV/0!"}},{"$f":"E62*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H69","v":0},{"$f":"G62*Basis!H30","v":0},{"$f":"I65-J69","v":{"$error":"#DIV/0!"}},{"$f":"I62*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L69","v":{"$error":"#DIV/0!"}},{"$f":"K62*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N69","v":{"$error":"#DIV/0!"}},{"$f":"M62*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P69","v":{"$error":"#DIV/0!"}},{"$f":"O62*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R69","v":{"$error":"#DIV/0!"}},{"$f":"Q62*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"C65-D70","v":{"$error":"#REF!"}},{"$f":"(C62-C69)*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F70","v":{"$error":"#DIV/0!"}},{"$f":"(E62-E69)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H70","v":0},{"$f":"(G62-G69)*Basis!H30","v":0},{"$f":"I65-J70","v":{"$error":"#DIV/0!"}},{"$f":"(I62-I69)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L70","v":{"$error":"#DIV/0!"}},{"$f":"(K62-K69)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N70","v":{"$error":"#DIV/0!"}},{"$f":"(M62-M69)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P70","v":{"$error":"#DIV/0!"}},{"$f":"(O62-O69)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R70","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-Q69)*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"C65-D71","v":{"$error":"#REF!"}},{"$f":"(C62-C69-C70)*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F71","v":{"$error":"#DIV/0!"}},{"$f":"(E62-E69-E70)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H71","v":0},{"$f":"(G62-G69-G70)*Basis!H30","v":0},{"$f":"I65-J71","v":{"$error":"#DIV/0!"}},{"$f":"(I62-I69-I70)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L71","v":{"$error":"#DIV/0!"}},{"$f":"(K62-K69-K70)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N71","v":{"$error":"#DIV/0!"}},{"$f":"(M62-M69-M70)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P71","v":{"$error":"#DIV/0!"}},{"$f":"(O62-O69-O70)*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R71","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-Q69-Q70)*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"C65-D72","v":{"$error":"#REF!"}},{"$f":"(C62-SUM(C69:C71))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F72","v":{"$error":"#DIV/0!"}},{"$f":"(E62-SUM(E69:E71))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H72","v":0},{"$f":"(G62-SUM(G69:G71))*Basis!H30","v":0},{"$f":"I65-J72","v":{"$error":"#DIV/0!"}},{"$f":"(I62-SUM(I69:I71))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L72","v":{"$error":"#DIV/0!"}},{"$f":"(K62-SUM(K69:K71))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N72","v":{"$error":"#DIV/0!"}},{"$f":"(M62-SUM(M69:M71))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P72","v":{"$error":"#DIV/0!"}},{"$f":"(O62-SUM(O69:O71))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R72","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-SUM(Q69:Q71))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,5,{"$f":"C65-D73","v":{"$error":"#REF!"}},{"$f":"(C62-SUM(C69:C72))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F73","v":{"$error":"#DIV/0!"}},{"$f":"(E62-SUM(E69:E72))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H73","v":0},{"$f":"(G62-SUM(G69:G72))*Basis!H30","v":0},{"$f":"I65-J73","v":{"$error":"#DIV/0!"}},{"$f":"(I62-SUM(I69:I72))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L73","v":{"$error":"#DIV/0!"}},{"$f":"(K62-SUM(K69:K72))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N73","v":{"$error":"#DIV/0!"}},{"$f":"(M62-SUM(M69:M72))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P73","v":{"$error":"#DIV/0!"}},{"$f":"(O62-SUM(O69:O72))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R73","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-SUM(Q69:Q72))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,6,{"$f":"C65-D74","v":{"$error":"#REF!"}},{"$f":"(C62-SUM(C69:C73))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F74","v":{"$error":"#DIV/0!"}},{"$f":"(E62-SUM(E69:E73))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H74","v":0},{"$f":"(G62-SUM(G69:G73))*Basis!H30","v":0},{"$f":"I65-J74","v":{"$error":"#DIV/0!"}},{"$f":"(I62-SUM(I69:I73))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L74","v":{"$error":"#DIV/0!"}},{"$f":"(K62-SUM(K69:K73))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N74","v":{"$error":"#DIV/0!"}},{"$f":"(M62-SUM(M69:M73))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P74","v":{"$error":"#DIV/0!"}},{"$f":"(O62-SUM(O69:O73))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R74","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-SUM(Q69:Q73))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,7,{"$f":"C65-D75","v":{"$error":"#REF!"}},{"$f":"(C62-SUM(C69:C74))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F75","v":{"$error":"#DIV/0!"}},{"$f":"(E62-SUM(E69:E74))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H75","v":0},{"$f":"(G62-SUM(G69:G74))*Basis!H30","v":0},{"$f":"I65-J75","v":{"$error":"#DIV/0!"}},{"$f":"(I62-SUM(I69:I74))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L75","v":{"$error":"#DIV/0!"}},{"$f":"(K62-SUM(K69:K74))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N75","v":{"$error":"#DIV/0!"}},{"$f":"(M62-SUM(M69:M74))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P75","v":{"$error":"#DIV/0!"}},{"$f":"(O62-SUM(O69:O74))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R75","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-SUM(Q69:Q74))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,8,{"$f":"C65-D76","v":{"$error":"#REF!"}},{"$f":"(C62-SUM(C69:C75))*Basis!H30","v":{"$error":"#REF!"}},{"$f":"E65-F76","v":{"$error":"#DIV/0!"}},{"$f":"(E62-SUM(E69:E75))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"G65-H76","v":0},{"$f":"(G62-SUM(G69:G75))*Basis!H30","v":0},{"$f":"I65-J76","v":{"$error":"#DIV/0!"}},{"$f":"(I62-SUM(I69:I75))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"K65-L76","v":{"$error":"#DIV/0!"}},{"$f":"(K62-SUM(K69:K75))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"M65-N76","v":{"$error":"#DIV/0!"}},{"$f":"(M62-SUM(M69:M75))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"O65-P76","v":{"$error":"#DIV/0!"}},{"$f":"(O62-SUM(O69:O75))*Basis!H30","v":{"$error":"#DIV/0!"}},{"$f":"Q65-R76","v":{"$error":"#DIV/0!"}},{"$f":"(Q62-SUM(Q69:Q75))*Basis!H30","v":{"$error":"#DIV/0!"}}]
[null,"Total ",{"$f":"SUM(C69:C76)","v":{"$error":"#REF!"}},{"$f":"SUM(D69:D76)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:E76)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Total repayment ","scheme 1",null,"scheme 2",null,"scheme 3",null,"scheme 4",null,"scheme 5",null,"scheme 6",null,"scheme 7",null,"scheme9"]
[null,null,{"$f":"C42+C15+C65","v":{"$error":"#REF!"}},null,{"$f":"E42+E15+E65","v":{"$error":"#DIV/0!"}},null,{"$f":"G42+G15","v":{"$error":"#DIV/0!"}},null,{"$f":"I42+I15+I65","v":{"$error":"#DIV/0!"}},null,{"$f":"K42+K15+K65","v":{"$error":"#DIV/0!"}},null,{"$f":"M42+M15+M65","v":{"$error":"#DIV/0!"}},null,{"$f":"O42+O15+O65","v":{"$error":"#DIV/0!"}},null,{"$f":"Q42+Q15+Q65","v":{"$error":"#DIV/0!"}}]
[null,"Total payment for 8 years",{"$f":"C80*8","v":{"$error":"#REF!"}},{"$f":"D80*8","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0]

{"sheet":"Economic Analysis ","index":9,"n_rows":21,"n_cols":52,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,3,6,12],[3,26,3,45],[5,3,5,6],[2,17,4,17],[2,2,4,2],[2,3,4,16],[9,3,9,12],[2,1,20,1],[12,3,12,12],[3,18,3,25],[9,47,9,50],[19,2,19,12],[20,2,20,12],[6,47,6,50],[10,3,10,12],[11,3,11,12],[15,3,15,12],[16,3,16,12],[18,3,18,12],[14,3,14,12],[17,3,17,12],[19,18,19,21]]}
[]
[]
[null,"Scenario 1 ","items","Description",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:MM$",1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,null,null,null,null,null,"Salvage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Phase",null,null,null,null,null,null,null,"Operating Phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Basis!H36","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CAPEX!H5","v":8.7707995372531919E-2},{"$f":"CAPEX!I5","v":6.8174742558063745E-2},{"$f":"CAPEX!J5","v":0.29835542338709126},{"$f":"CAPEX!K5","v":0.16546788135493493},{"$f":"CAPEX!L5","v":0.12788596894782572},{"$f":"CAPEX!M5","v":8.0663712328656281E-2},{"$f":"CAPEX!N5","v":0.11228236295490188},{"$f":"CAPEX!O5","v":5.9461913095994176E-2},"Y:1","Y:2","Y:3","Y:4","Y:5","Y:6","Y:7","Y:8","Y:9","Y:10","Y:11","Y:12","Y:13","Y:14","Y:15","Y:16","Y:17","Y:18","Y:19","Y:20"]
[null,null,null,"Utilization Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,0.9,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,1,"Fixed Capital",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CAPEX!P11","v":501.27568778938235},{"$f":"-$R$7*S5","v":-43.965885704993902},{"$f":"-$R$7*T5","v":-34.174340965657478},-149.55832006405655,-82.945026033246918,-64.10612704293294,-40.434757877192055,-56.284418716835503,-29.806811384466961,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount rate:",null,null,null,{"$f":"Basis!H37","v":0.1}]
[null,null,"1-1","Loan",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-SUM(S8:W8)","v":227.35613099999998},{"$f":"S7-S9","v":-29.19624},{"$f":"T7-T9","v":-15.109289},-120.27738099999999,-42.141900999999997,-20.631319999999995,-16.320000000000004,-31.199999999999996,-4.240000000000002]
[null,null,"1-2","Equity",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-SUM(S9:W9)","v":147.39356881088781},{"$f":"S7*CAPEX!H6","v":-14.769645704993902},{"$f":"T7*CAPEX!I6","v":-19.065051965657478},{"$f":"U7*CAPEX!J6","v":-29.280939064056554},{"$f":"V7*CAPEX!K6","v":-40.803125033246921},{"$f":"W7*CAPEX!L6","v":-43.474807042932945},{"$f":"X7*CAPEX!M6","v":-24.114757877192051},{"$f":"Y7*CAPEX!N6","v":-25.084418716835508},{"$f":"Z7*CAPEX!O6","v":-25.566811384466959}]
[null,null,2,"Working Capital",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Opex!H5+Opex!H8+Opex!H16","v":23.501307325376292},null,null,null,null,{"$f":"O10","v":0},null,{"$f":"-R10","v":-23.501307325376292},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax rate:",null,null,null,{"$f":"Basis!H35","v":0.25}]
[null,null,3,"Total Investment Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7+R10","v":524.77699511475862}]
[null,null,4,"Revenue",null,null,null,null,null,null,null,null,null,"base:",{"$f":"Revenue!M14","v":1572.5818108440003},"Without NHT:",{"$f":"Revenue!N14","v":1499.2553644813802},null,null,null,null,null,null,{"$f":"$R$12*X6","v":0},{"$f":"Q12/2*Y6","v":599.70214579255207},{"$f":"Q12*Z6","v":1349.3298280332422},{"$f":"$O$12*AA6","v":1572.5818108440003},{"$f":"$O$12*AB6","v":1572.5818108440003},1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003,1572.5818108440003]
[null,null,5,"OPEX",null,null,null,null,null,null,null,null,null,"Fixed:",{"$f":"Opex!H9","v":13.017859629051351},"Variable:",{"$f":"Opex!H17","v":1473.8208480626397},{"$f":"O13+Q13","v":1486.8387076916911},null,null,null,null,null,null,{"$f":"-(O13+Q13*Y6)/2","v":-596.03726903958159},{"$f":"-(O13+Q13*Z6)","v":-1339.4566228854271},{"$f":"-($O$13+$Q$13*AA6)","v":-1486.8387076916911},{"$f":"-($O$13+$Q$13*AB6)","v":-1486.8387076916911},-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911,-1486.8387076916911]
[null,null,7,"Loan Financial cost",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-SUM(X14:AB14)","v":0}]
[null,null,8,"Gross profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S7+S10","v":-43.965885704993902},-34.174340965657478,-149.55832006405655,-82.945026033246918,-64.10612704293294,{"$f":"X7+X10","v":-40.434757877192055},{"$f":"SUM(Y12:Y13)","v":3.6648767529704855},{"$f":"SUM(Z12:Z13)","v":9.8732051478150424},{"$f":"SUM(AA12:AA14)","v":85.743103152309232},{"$f":"SUM(AB12:AB14)","v":85.743103152309232},85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232,85.743103152309232]
[null,null,9,"Taxable profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y12:Y14)-$V$21","v":-15.132961539131351},{"$f":"SUM(Z12:Z13)-$V$21","v":-8.9246331442867941},{"$f":"SUM(AA7:AA14)-$V$21","v":66.945264860207402},{"$f":"SUM(AB7:AB14)-$V$21","v":66.945264860207402},{"$f":"SUM(AC7:AC14)-$V$21","v":66.945264860207402},{"$f":"SUM(AD7:AD14)-$V$21","v":66.945264860207402},{"$f":"SUM(AE7:AE14)-$V$21","v":66.945264860207402},{"$f":"SUM(AF7:AF14)-$V$21","v":66.945264860207402},{"$f":"SUM(AG7:AG14)-$V$21","v":66.945264860207402},{"$f":"SUM(AH7:AH14)-$V$21","v":66.945264860207402},{"$f":"SUM(AI7:AI14)-$V$21","v":66.945264860207402},{"$f":"SUM(AJ7:AJ14)-$V$21","v":66.945264860207402},{"$f":"SUM(AK7:AK14)-$V$21","v":66.945264860207402},{"$f":"SUM(AL7:AL14)-$V$21","v":66.945264860207402},{"$f":"SUM(AM7:AM14)-$V$21","v":66.945264860207402},{"$f":"SUM(AN7:AN14)-$V$21","v":66.945264860207402},{"$f":"SUM(AO7:AO14)-$V$21","v":66.945264860207402},{"$f":"SUM(AP7:AP14)-$V$21","v":66.945264860207402},{"$f":"SUM(AQ7:AQ14)-$V$21","v":66.945264860207402},{"$f":"SUM(AR7:AR14)-$V$21","v":66.945264860207402},{"$f":"SUM(AS7:AS14)-$V$21","v":66.945264860207402},{"$f":"SUM(AT7:AT14)-$V$21","v":66.945264860207402}]
[null,null,10,"Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-AK16*$AZ$10","v":-16.736316215051851},-16.736316215051851,-16.736316215051851,-16.736316215051851,-16.736316215051851,-16.736316215051851,-16.736316215051851,-16.736316215051851,-16.736316215051851,-16.736316215051851]
[null,null,11,"Net Profit-Non Discounted Cash flow- Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S7+S10","v":-43.965885704993902},{"$f":"T7+T10","v":-34.174340965657478},{"$f":"U7+U10","v":-149.55832006405655},{"$f":"V7+V10","v":-82.945026033246918},-64.10612704293294,-40.434757877192055,{"$f":"Y7+Y10+Y12+Y13","v":-76.120849289241278},{"$f":"Z7+Z10+Z12+Z13","v":-19.93360623665194},{"$f":"SUM(AA7:AA14)+AA17","v":85.743103152309232},{"$f":"SUM(AB7:AB14)+AB17","v":85.743103152309232},{"$f":"SUM(AC7:AC14)+AC17","v":85.743103152309232},{"$f":"SUM(AD7:AD14)+AD17","v":85.743103152309232},{"$f":"SUM(AE7:AE14)+AE17","v":85.743103152309232},{"$f":"SUM(AF7:AF14)+AF17","v":85.743103152309232},{"$f":"SUM(AG7:AG14)+AG17","v":85.743103152309232},{"$f":"SUM(AH7:AH14)+AH17","v":85.743103152309232},{"$f":"SUM(AI7:AI14)+AI17","v":85.743103152309232},{"$f":"SUM(AJ7:AJ14)+AJ17","v":85.743103152309232},{"$f":"SUM(AK7:AK14)+AK17","v":69.006786937257374},{"$f":"SUM(AL7:AL14)+AL17","v":69.006786937257374},{"$f":"SUM(AM7:AM14)+AM17","v":69.006786937257374},{"$f":"SUM(AN7:AN14)+AN17","v":69.006786937257374},{"$f":"SUM(AO7:AO14)+AO17","v":69.006786937257374},{"$f":"SUM(AP7:AP14)+AP17","v":69.006786937257374},{"$f":"SUM(AQ7:AQ14)+AQ17","v":69.006786937257374},{"$f":"SUM(AR7:AR14)+AR17","v":69.006786937257374},{"$f":"SUM(AS7:AS14)+AS17","v":69.006786937257374},{"$f":"SUM(AT7:AT13)+AT17+(AZ4*R7)+R10","v":217.82701620997926}]
[null,null,12,"Net Profit-Non Discounted Cash flow- Equity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S9:S10)","v":-14.769645704993902},{"$f":"SUM(T9:T10)","v":-19.065051965657478},{"$f":"SUM(U9:U10)","v":-29.280939064056554},{"$f":"SUM(V9:V10)","v":-40.803125033246921},{"$f":"SUM(W9:W10)","v":-43.474807042932945},{"$f":"SUM(X7:X14)+X17","v":-80.869515754384111},{"$f":"SUM(Y7:Y14)+Y17","v":-132.40526800607682},{"$f":"SUM(Z7:Z14)+Z17","v":-49.740417621118922},{"$f":"SUM(AA7:AA14)+AA17","v":85.743103152309232},{"$f":"SUM(AB7:AB14)+AB17","v":85.743103152309232},{"$f":"SUM(AC7:AC14)+AC17","v":85.743103152309232},{"$f":"SUM(AD7:AD14)+AD17","v":85.743103152309232},{"$f":"SUM(AE7:AE14)+AE17","v":85.743103152309232},{"$f":"SUM(AF7:AF14)+AF17","v":85.743103152309232},{"$f":"SUM(AG7:AG14)+AG17","v":85.743103152309232},{"$f":"SUM(AH7:AH14)+AH17","v":85.743103152309232},{"$f":"SUM(AI7:AI14)+AI17","v":85.743103152309232},{"$f":"SUM(AJ7:AJ14)+AJ17","v":85.743103152309232},{"$f":"SUM(AK7:AK14)+AK17","v":69.006786937257374},{"$f":"SUM(AL7:AL14)+AL17","v":69.006786937257374},{"$f":"SUM(AM7:AM14)+AM17","v":69.006786937257374},{"$f":"SUM(AN7:AN14)+AN17","v":69.006786937257374},{"$f":"SUM(AO7:AO14)+AO17","v":69.006786937257374},{"$f":"SUM(AP7:AP14)+AP17","v":69.006786937257374},{"$f":"SUM(AQ7:AQ14)+AQ17","v":69.006786937257374},{"$f":"SUM(AR7:AR14)+AR17","v":69.006786937257374},{"$f":"SUM(AS7:AS14)+AS17","v":69.006786937257374},{"$f":"SUM(AT7:AT13)+AT17+(AZ4*R7)+R10","v":217.82701620997926}]
[null,null,"IRR-Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IRR(S18:AT18)","v":9.5622711740442679E-2}]
[null,null,"NPV-Total, MM$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NPV(AZ7,S18:AT18)","v":-15.856382275632207},"ADR :",null,null,{"$f":"SLN((R7),AZ4*(R7),20)","v":18.797838292101837}]

{"sheet":"Final Result","index":10,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Parameter","Unit","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 9"]
["COTC","%",23.4]
["Fule Oil Ratio","%",5.6]
["Capex","MM$",{"$f":"'Economic Analysis '!R7","v":501.27568778938235}]
["working Capital","MM$",{"$f":"'Economic Analysis '!R10","v":23.501307325376292}]
["Revenue","MM$",{"$f":"'Economic Analysis '!R12","v":0}]
["Opex","MM$",{"$f":"'Economic Analysis '!R13","v":1486.8387076916911}]
["IRR","%",{"$f":"'Economic Analysis '!R20","v":9.5622711740442679E-2}]
["NPV@10%","MM$",{"$f":"'Economic Analysis '!R21","v":-15.856382275632207}]

{"sheet":"Sheet2","index":11,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":true,"merged":[[14,2,14,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Loan ","Grace "]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},1,null,1,null,2,null,3,null,4,null,5]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"B17*B16","v":{"$error":"#REF!"}},null,{"$f":"E18*B16","v":{"$error":"#REF!"}},null,{"$f":"G18*B16","v":{"$error":"#REF!"}},null,{"$f":"I18*B16","v":{"$error":"#REF!"}},null,{"$f":"K18*B16","v":{"$error":"#REF!"}},{"$f":"M18*B16/2","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"B17","v":{"$error":"#REF!"}},{"$f":"D17+D18","v":{"$error":"#REF!"}},null,{"$f":"F17+E18","v":{"$error":"#REF!"}},null,{"$f":"H17+G18","v":{"$error":"#REF!"}},null,{"$f":"J17+I18","v":{"$error":"#REF!"}},null,{"$f":"L17+K18","v":{"$error":"#REF!"}},{"$f":"M17+M18","v":{"$error":"#REF!"}}]