{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Scenario Output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":1,"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":"Scenario Output","index":0,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"No","Name","Linked Varible 1 to Model (e.g. EIRR)","Linked Variable 2 to Model (e.g. PIRR)","Linked Variable 3  e.g. Input",null,null,null,null,"<---------------","Replace these titles and Links in Next Row"]
[null,null,null,null,7.5887069106102004E-2,7.5887069106102004E-2,68.936528179422581]
[]
[null,null,1,"No Financing with Tax",0.10000000596046449,9.9999994039535522E-2,81.429712460993457]
[null,null,2,"No Financing No Taxes",0.10000000596046449,9.9999994039535522E-2,67.364276008212627]
[null,null,3,"Base Financing",0.10000000596046449,8.5023346543312089E-2,60.942444437522795]
[null,null,4,"Lower Interest Rate",9.9999994039535522E-2,7.1974441409111037E-2,55.625427563733325]
[null,null,5,"Sculpting",9.9999994039535522E-2,6.6703101992607136E-2,53.555479142038614]
[null,null,6,"Longer Debt Tenor",9.9999994039535522E-2,4.719191491603851E-2,46.307347210324444]
[null,null,7,"85% Gearing Constraint",0.10000000596046449,5.3811797499656672E-2,48.691742209770283]
[null,null,8,"Development Fee",9.9999994039535522E-2,4.5927795767784121E-2,45.860985777119616]
[null,null,9,"DSRA L/C",0.10000000596046449,4.2783829569816592E-2,44.763457747541338]
[null,null,10,"Lower Equity IRR",6.5000000596046478E-2,2.1877726912498476E-2,37.933259960236313]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Parameters for Scenario Name"]
[]
[null,null,null,"Row with Links",{"$f":"ROW(Q4)","v":4}]
[null,null,null,"Scenario Number Column",{"$f":"COLUMN(C:C)","v":3}]
[null,null,null,"Scenario Name Column",{"$f":"COLUMN(D:D)","v":4}]
[null,null,null,"Base Address",{"$f":"ADDRESS(E104,E105)","v":"$C$4"}]
[null,null,null,"Column Scenario Number",{"$f":"MID(E107,2,1)","v":"C"}]
[null,null,null,"Scenario Sheet Name","Scenario Output"]
[null,null,null,null,{"$f":"MID(CELL(\"filename\"),FIND(\"]\",CELL(\"filename\"),1)+1,250)","v":"Scenario Output"}]
[null,null,null,null,false]
[]
[null,null,null,"Instructions at www.edbodmer.com\t"]
[null,null,null,"Questions: e-mail edwardbodmer@gmail.com"]