{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Chart2","Sheet1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart2","index":0,"reason":"not_a_worksheet"}],"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":"Sheet1","index":1,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Assumptions"]
[null,null,"Debt",null,null,null,null,null,null,null,false,"Iteration"]
[null,null,null,"Gearing",0.70038913473480313]
[null,null,null,"Fees & IDCs",0.15]
[]
[null,null,"Capex",null,null,null,null,50,60,70,100,200,50]
[null,null,"EBITDA",null,null,null,null,null,null,null,null,null,null,717.79565000000014,null,"Target Debt",450]
[null,null,"FCF",null,null,null,null,{"$f":"(H8-H7)","v":-50},{"$f":"(I8-I7)","v":-60},-70,-100,-200,-50,717.79565000000014,null,"Computed Debt",{"$f":"G21","v":414.7826283336953}]
[null,null,"Project IRR",null,{"$f":"IRR(H9:N9)","v":0.10000000000000009},null,null,null,null,null,null,null,null,null,null,"Diff",{"$f":"Q8-Q9","v":35.2173716663047}]
[null,null,"Target IRR",null,0.1,{"$f":"NPV(E11,H9:N9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gearing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G21","v":414.7826283336953},0.65,0.75,0.85]
[null,"Sources and Uses",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fees & IDCs",0.1,368.44919786096256,429.72972972972968,492.34972677595619]
[null,null,"Uses",null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,381.71745152354572,447.88732394366195,516.33237822349565]
[null,null,null,"Capex",null,null,{"$f":"(SUM(H16:M16))*1","v":530},{"$f":"H7","v":50},{"$f":"I7","v":60},70,100,200,50,null,null,null,0.2,395.97701149425291,467.64705882352945,542.77108433734941]
[null,null,null,"Fees & IDCs - from paste",{"$f":"E5","v":0.15},null,{"$f":"(SUM(H17:M17))*1","v":62.217394250054298},{"$f":"H40","v":5.8695654952881418},{"$f":"I40","v":7.0434785943457685},8.2173916934033979,11.739130990576284,23.478261981152567,5.8695654952881418]
[null,null,null,"Total",null,null,{"$f":"(SUM(H18:M18))*1","v":592.21739425005433},{"$f":"SUM(H16:H17)","v":55.869565495288143},67.043478594345771,78.2173916934034,111.73913099057629,223.47826198115257,55.869565495288143,null,null,null,null,"Gearing"]
[null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,0.65,0.75,0.85]
[null,null,"Sources",null,null,null," ",null,null,null,null,null,null,null,null,"Fees & IDCs",0.1,368.44919786096256,429.72972972972968,492.34972677595619]
[null,null,null,"Debt",{"$f":"E4","v":0.70038913473480313},null,414.7826283336953,{"$f":"$E$21*H18","v":39.130436635254277},{"$f":"$E$21*I18","v":46.956523962305127},54.782611289355984,78.260873270508554,156.52174654101711,39.130436635254277,null,null,null,0.15,381.71745152354572,447.88732394366195,516.33237822349554]
[null,null,null,"Equity",null,null,{"$f":"(SUM(H22:M22))*1","v":177.434765916359},{"$f":"H18-H21","v":16.739128860033865},{"$f":"I18-I21","v":20.086954632040644},23.434780404047416,33.478257720067731,66.956515440135462,16.739128860033865,null,null,null,0.2,395.97701149425291,467.64705882352939,542.77108433734941]
[null,null,null,"Total",null,null,592.21739425005433,{"$f":"SUM(H21:H22)","v":55.869565495288143},{"$f":"SUM(I21:I22)","v":67.043478594345771},78.2173916934034,111.73913099057629,223.47826198115257,55.869565495288143]
[]
[null,null,null,"Computed fees",{"$f":"E17","v":0.15},null,{"$f":"$E$25*G21","v":62.217394250054291},{"$f":"$E$25*H21","v":5.8695654952881418},7.0434785943457685,8.2173916934033979,11.739130990576284,23.478261981152567,5.8695654952881418]
[]
[null,"Solver"]
[null,null,"Copy Block"]
[null,null,null,"Computed fees",null,null,null,{"$f":"H25","v":5.8695654952881418},{"$f":"I25","v":7.0434785943457685},{"$f":"J25","v":8.2173916934033979},{"$f":"K25","v":11.739130990576284},{"$f":"L25","v":23.478261981152567},{"$f":"M25","v":5.8695654952881418}]
[null,null,null,"[other circular references]"]
[null,null,null,"Total",null,null,null,{"$f":"SUM(H29:H30)","v":5.8695654952881418},{"$f":"SUM(I29:I30)","v":7.0434785943457685},8.2173916934033979,11.739130990576284,23.478261981152567,5.8695654952881418]
[]
[null,null,"Paste Block"]
[null,null,null,"Pasted fees",null,null,null,5.8695654952881418,7.0434785943457685,8.2173916934033979,11.739130990576284,23.478261981152567,5.8695654952881418]
[null,null,null,"[other circular references]"]
[null,null,null,"Total",null,null,null,{"$f":"SUM(H34:H35)","v":5.8695654952881418},{"$f":"SUM(I34:I35)","v":7.0434785943457685},8.2173916934033979,11.739130990576284,23.478261981152567,5.8695654952881418]
[]
[null,null,"Difference",null,null,null,{"$f":"SUM(H38:XFD38)","v":0},{"$f":"H31-H36","v":0},{"$f":"I31-I36","v":0},0,0,0,0]
[]
[null,null,null,"Fees",null,null,null,{"$f":"Fee(Fees,Gearing,H7)","v":5.8695654952881418},{"$f":"Fee(Fees,Gearing,I7)","v":7.0434785943457685},{"$f":"Fee(Fees,Gearing,J7)","v":8.2173916934033979},{"$f":"Fee(Fees,Gearing,K7)","v":11.739130990576284},{"$f":"Fee(Fees,Gearing,L7)","v":23.478261981152567},{"$f":"Fee(Fees,Gearing,M7)","v":5.8695654952881418}]