{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Disclaimer","Contents","Renewables Platform Valuation","U.S. Renewables Project","Styles"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":89,"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":"Disclaimer","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,2,43,15]]}
[]
[null,"Disclaimer"]
[]
[]
[null,null,"This financial model (“Model”) has been prepared by Infratil Limited (NZ company number 597366, NZX:IFT; ASX:IFT) (“Infratil”). Each person who accesses this Model is referred to in this disclaimer as “Recipient”. By accessing this Model, each Recipient agrees to be bound at all times by the terms of this disclaimer set out below.\n\nThe Model has been prepared in good faith for information purposes only and provided on a non-reliance basis. It is not intended to be and should not be relied upon as advice to investors or potential investors and does not take into account the investment objectives, financial situation or needs of any particular investor. These should be considered, with or without professional advice, before taking any action in respect of an investment in Infratil. \n\nThe information in this Model does not purport to be complete nor does it contain or contemplate all information which an investor or a prospective investor may require or consider necessary in evaluating a decision regarding an investment in Infratil. \n\nThe Model does not constitute any financial, tax, legal, investment or other advice, or any recommendation, offer or invitation to acquire or dispose of Infratil’s securities, and has been prepared without taking into account the objectives, financial situation, and needs of or implications for any Recipient. Recipients must not place undue reliance on the Model or its contents and must conduct their own investigation and analysis of (i) Infratil, (ii) any Infratil portfolio company that is the subject of this Model, including its respective assets and business (“Portfolio Company”), and (iii) the information contained in the Model. \n\nPast performance information provided in the Model may not be a reliable indication of future performance. Furthermore, information about the financial and forecast performance of Infratil and any Portfolio Company may be presented in the Model in a different way from that which appears in the audited or unaudited financial statements from which it is derived. This may (but need not) result from historical financial information being “adjusted” for the purposes of the Model. \n\nThe Model contains certain forward-looking information relating to Infratil and any Portfolio Company, such as quantitative and qualitative forecasts, projections, estimates, statements and opinions concerning the anticipated future performance and financial condition of Infratil and/or any Portfolio Company. None of these forecasts, projections, estimates, statements and opinions are, or will be, guarantees, representations or warranties, express or implied, as to future matters or circumstances.\n \nForward-looking information is inherently uncertain and subject to contingencies outside of Infratil’s or the Portfolio Company’s control, and which may cause the actual results or performance of Infratil or the Portfolio Company to be materially different from any results or performance expressed or implied by such forward-looking statement. Infratil gives no representation, warranty or assurance that actual outcomes or performance will not materially differ from the forward-looking statements expressed or implied.\n \nInformation included in this Model, including any forward-looking information, speaks only as of the date of this Model. Future events or subsequent developments may affect the information in this Model, and, except as required by law, or the rules of any relevant securities exchange or listing authority, Infratil is under no obligation to update, revise, reaffirm or supplement any views or information set out in this Model. To the maximum extent permitted by law, Infratil, the Portfolio Company and their respective affiliates, and each of their respective directors, officers, partners, employees and agents (each a “Relevant Person”) accept no responsibility to inform or notify a Recipient of any matter which may affect any matter referred to in this Model (including, but not limited to, any error or omission which may become apparent after the date of this Model). Without prejudice to the foregoing, if Infratil provides any further information to supplement this Model, whether by way of update or otherwise, to Recipients after the date of this Model, the terms and conditions applying to this Model will apply to such further information.\n\nThis Model shall not be deemed an indication of the state of affairs of Infratil or any Portfolio Company nor shall it constitute an indication that there has been or will be no change in Infratil or any Portfolio Company since the date of this Model or since any other date at which any information contained herein is expressed to be stated.\n\nNo representation, warranty or undertaking, express or implied, of any nature is made in relation to the accuracy, completeness or correctness of the information contained in this Model. To the maximum extent permitted by law, no Relevant Person will be liable (whether in tort (including negligence) or otherwise) to any person in relation to this Model."]

{"sheet":"Contents","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Illustrative Renewables Valuation Model"]
[null,"Cover"]
[]
[null,"Contents",null,null,null,null,"Technical inputs",null,null,null,null,null,null,"Legend"]
[]
[null,null,"Model Name",null,null,null,null,"Days in year",null,365.25,"<Days_yr>",null,null,"Divider 1",null,"Divider 1"]
[null,null,null,"Illustrative Renewables Valuation Model",null,null,null,"Days in week",null,7,"<Days_wk>"]
[null,null,null,null,null,null,null,"Quarters in year",null,4,"<Quarters_yr>",null,null,"Divider 2",null,"Divider 2"]
[null,null,"Contents>>",null,null,null,null,"Months in year",null,12,"<Months_yr>"]
[null,null,null,"Renewables Platform",null,null,null,"Months in quarter",null,3,"<Months_qtr>",null,null,"Divider 3",null,"Divider 3"]
[null,null,null,"US Tax Equity Example",null,null,null,"Hours per day",null,24,"<Hrs_day>"]
[null,null,null,null,null,null,null,"Financial year month",null,3,"<FY_month>",null,null,"User Input",null,"User Input"]
[null,null,null,null,null,null,null,"Thousands",null,1000,"<Thousand>"]
[null,null,null,null,null,null,null,"Millions",null,1000000,"<Million>",null,null,"Table Header",null,"Table Header"]
[null,null,null,null,null,null,null,"Rounding error",null,0.05,"<Rounding_error>"]
[null,null,null,null,null,null,null,"Zero",null,0,"<Zero>",null,null,"Explanatory note",null,"Explanatory Note"]
[null,null,null,null,null,null,null,"One",null,1,"<One>"]
[null,null,null,null,null,null,null,"Two",null,2,"<Two>",null,null,"Calculation",null,"Calculation"]
[null,null,null,null,null,null,null,"Three",null,3,"<Three>"]
[null,null,null,null,null,null,null,"Four",null,4,"<Four>",null,null,"Check OK",null,0]
[null,null,null,null,null,null,null,"Ten",null,10,"<Ten>"]
[null,null,null,null,null,null,null,"Twenty",null,20,"<Twenty>",null,null,"Check Not OK",null,1]
[null,null,null,null,null,null,null,"Quarter",null,0.25,"<Quarter>"]
[null,null,null,null,null,null,null,"Half",null,0.5,"<Half>",null,null,"Modelling Input",null,"Modelling Input"]
[null,null,null,null,null,null,null,"One hundred thousand",null,100000,"<Hundred_k>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not override"]
[null,null,null,null,null,null,"Checks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"End of sheet",null,"END OF SHEET"]
[null,null,null,null,null,null,null,"Model status checks"]
[]
[null,null,null,null,null,null,null,"[spare]",null,null,0]
[null,null,null,null,null,null,null,"[spare]",null,null,0]
[null,null,null,null,null,null,null,"Model status",null,null,{"$f":"SUM(K31:K33)","v":0}]

{"sheet":"Renewables Platform Valuation","index":2,"n_rows":86,"n_cols":27,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Illustrative Renewables Platform Example"]
[]
[null,"Equity value ($m)",null,null,null,null,{"$f":"K78","v":3717.4999999000001},null,null,null,"Period Start ","2026-01-01",{"$f":"L5+1","v":"2027-01-01"},{"$f":"M5+1","v":"2028-01-01"},"2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01"]
[null,null,null,null,null,null,null,null,null,null,"Period End ",{"$f":"EOMONTH('Renewables Platform Valuation'!L4,12 -1)","v":"2026-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!M4,12 -1)","v":"2027-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!N4,12 -1)","v":"2028-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!O4,12 -1)","v":"2029-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!P4,12 -1)","v":"2030-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!Q4,12 -1)","v":"2031-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!R4,12 -1)","v":"2032-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!S4,12 -1)","v":"2033-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!T4,12 -1)","v":"2034-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!U4,12 -1)","v":"2035-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!V4,12 -1)","v":"2036-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!W4,12 -1)","v":"2037-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!X4,12 -1)","v":"2038-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!Y4,12 -1)","v":"2039-12-31"},{"$f":"EOMONTH('Renewables Platform Valuation'!Z4,12 -1)","v":"2040-12-31"}]
[null,null,null,null,null,null,null,null,null,null,"Financial year ",{"$f":"YEAR(L5)","v":2026},{"$f":"YEAR(M5)","v":2027},2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,null,null,null,null,null,null,null,null,null,"Period",1,{"$f":"L7+1","v":2},{"$f":"M7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Valuation Model"]
[]
[null,{"$f":"Header_Number","v":1},"Portfolio"]
[]
[null,null,null,"Assets brought to FNTP p.a.",null,null,"MW","Under construction",2000,null,{"$f":"K14","v":2000},{"$f":"YEARFRAC(L5,M5)*$I14","v":1500},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500]
[null,null,null,"Assets under-construction",null,null,"MW","Future cadence",1500,null,{"$f":"I13","v":2000},{"$f":"K14*0.5+L13","v":2500},{"$f":"L14*0.5+M13","v":2750},2875,2937.5,2968.75,2984.375,2992.1875,2996.09375,2998.046875,2999.0234375,2999.51171875,2999.755859375,2999.8779296875,2999.93896484375]
[]
[null,null,null,"Assets under-construction",null,null,null,"MW:","Build time (m)"]
[null,null,null,null,{"$f":"TRANSPOSE(L5:Z5)","v":"2026-12-31"},null,"MW",{"$f":"TRANSPOSE(K13:Y13)","v":2000},12,null,{"$f":"MAX((1-YEARFRAC(L$5,$E17)),0)*--(L$5>=$E17)*$H17","v":2000},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"2027-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E18)),0)*--(L$5>=$E18)*$H18","v":0},1500,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"2028-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E19)),0)*--(L$5>=$E19)*$H19","v":0},0,1500,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"2029-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E20)),0)*--(L$5>=$E20)*$H20","v":0},0,0,1500,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"2030-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E21)),0)*--(L$5>=$E21)*$H21","v":0},0,0,0,1500,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"2031-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E22)),0)*--(L$5>=$E22)*$H22","v":0},0,0,0,0,1500,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"2032-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E23)),0)*--(L$5>=$E23)*$H23","v":0},0,0,0,0,0,1500,0,0,0,0,0,0,0,0]
[null,null,null,null,"2033-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E24)),0)*--(L$5>=$E24)*$H24","v":0},0,0,0,0,0,0,1500,0,0,0,0,0,0,0]
[null,null,null,null,"2034-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E25)),0)*--(L$5>=$E25)*$H25","v":0},0,0,0,0,0,0,0,1500,0,0,0,0,0,0]
[null,null,null,null,"2035-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E26)),0)*--(L$5>=$E26)*$H26","v":0},0,0,0,0,0,0,0,0,1500,0,0,0,0,0]
[null,null,null,null,"2036-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E27)),0)*--(L$5>=$E27)*$H27","v":0},0,0,0,0,0,0,0,0,0,1500,0,0,0,0]
[null,null,null,null,"2037-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E28)),0)*--(L$5>=$E28)*$H28","v":0},0,0,0,0,0,0,0,0,0,0,1500,0,0,0]
[null,null,null,null,"2038-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E29)),0)*--(L$5>=$E29)*$H29","v":0},0,0,0,0,0,0,0,0,0,0,0,1500,0,0]
[null,null,null,null,"2039-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E30)),0)*--(L$5>=$E30)*$H30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,1500,0]
[null,null,null,null,"2040-12-31",null,"MW",1500,null,null,{"$f":"MAX((1-YEARFRAC(L$5,$E31)),0)*--(L$5>=$E31)*$H31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1500]
[null,null,null,"Assets achieving COD",null,null,"MW",null,null,null,null,{"$f":"-SUMIFS(L17:L31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(K17:K31)","v":2000},{"$f":"-SUMIFS(M17:M31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(L17:L31)","v":1500},{"$f":"-SUMIFS(N17:N31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(M17:M31)","v":1500},{"$f":"-SUMIFS(O17:O31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(N17:N31)","v":1500},{"$f":"-SUMIFS(P17:P31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(O17:O31)","v":1500},{"$f":"-SUMIFS(Q17:Q31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(P17:P31)","v":1500},{"$f":"-SUMIFS(R17:R31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(Q17:Q31)","v":1500},{"$f":"-SUMIFS(S17:S31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(R17:R31)","v":1500},{"$f":"-SUMIFS(T17:T31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(S17:S31)","v":1500},{"$f":"-SUMIFS(U17:U31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(T17:T31)","v":1500},{"$f":"-SUMIFS(V17:V31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(U17:U31)","v":1500},{"$f":"-SUMIFS(W17:W31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(V17:V31)","v":1500},{"$f":"-SUMIFS(X17:X31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(W17:W31)","v":1500},{"$f":"-SUMIFS(Y17:Y31,_xlfn.ANCHORARRAY($E17),\"<\"&#REF!)+SUM(X17:X31)","v":1500}]
[]
[null,null,null,"Assets under construction (time-series)",null,null,"MW",null,null,null,{"$f":"SUM(K17:K31)","v":2000},{"$f":"SUM(L17:L31)","v":1500},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500]
[]
[null,null,null,"Operating assets",null,null,"MW",null,null,null,3500,{"$f":"K36+L32","v":5500},7000,8500,10000,11500,13000,14500,16000,17500,19000,20500,22000,23500,25000]
[null,null,null,"Under-construction assets",null,null,"MW",null,null,null,{"$f":"K34","v":2000},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500]
[null,null,null,"Total OpCo MW",null,null,"MW",null,null,null,{"$f":"SUM(K36:K37)","v":5500},{"$f":"SUM(L36:L37)","v":7000},8500,10000,11500,13000,14500,16000,17500,19000,20500,22000,23500,25000,26500]
[]
[null,{"$f":"Header_Number","v":2},"OpCo"]
[]
[null,null,null,null,null,null,null,"2027 GW","2027 EBITDA","$k/MW EBITDA"]
[null,null,null,"Operating assets",null,null,"$'000",8.5,{"$f":"H43*70","v":595},{"$f":"IFERROR(I43/H43,0)","v":70},{"$f":"K36*$J43","v":245000},385000,490000,595000,700000,805000,910000,1015000,1120000,1225000,1330000,1435000,1540000,1645000,1750000]
[null,null,null,"Under-construction assets",null,null,"$'000",null,null,null,{"$f":"K37*$J43","v":140000},105000,105000,105000,105000,105000,105000,105000,105000,105000,105000,105000,105000,105000,105000]
[null,null,null,"Total OpCo Run-Rate EBITDA",null,null,"$'000",null,null,null,{"$f":"SUM(K43:K44)","v":385000},{"$f":"SUM(L43:L44)","v":490000},595000,700000,805000,910000,1015000,1120000,1225000,1330000,1435000,1540000,1645000,1750000,1855000]
[]
[null,null,null,"Enterprise value",null,null,"$m","EV/EBITDA"]
[null,null,null,"Value of operating assets",null,null,"$m",13,null,null,{"$f":"K43*$H48/10^3","v":3185},5005,6370,7735,9100,10465,11830,13195,14560,15925,17290,18655,20020,21385,22750]
[null,null,null,"Value of under-construction assets",null,null,"$m",13,null,null,{"$f":"K44*$H49/10^3","v":1820},{"$f":"L44*$H49/10^3","v":1365},1365,1365,1365,1365,1365,1365,1365,1365,1365,1365,1365,1365,1365]
[null,null,null,"Total Enterprise value of OpCo",null,null,"$m",null,null,null,{"$f":"SUM(K48:K49)","v":5005},{"$f":"SUM(L48:L49)","v":6370},7735,9100,10465,11830,13195,14560,15925,17290,18655,20020,21385,22750,24115]
[]
[null,null,null,"Debt",null,null,"$m","$k/MW"]
[null,null,null,{"$f":"D43","v":"Operating assets"},null,null,"$m",575,null,null,{"$f":"K36*$H53/10^3","v":2012.5},3162.5,4025,4887.5,5750,6612.5,7475,8337.5,9200,10062.5,10925,11787.5,12650,13512.5,14375]
[null,null,null,{"$f":"D44","v":"Under-construction assets"},null,null,"$m",null,null,null,{"$f":"K37*$H53/10^3","v":1150},862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5]
[null,null,null,"Total debt value of OpCp",null,null,"$m",null,null,null,{"$f":"SUM(K53:K54)","v":3162.5},{"$f":"SUM(L53:L54)","v":4025},4887.5,5750,6612.5,7475,8337.5,9200,10062.5,10925,11787.5,12650,13512.5,14375,15237.5]
[]
[null,null,null,"Equity value",null,null,"$m"]
[null,null,null,{"$f":"D53:D54","v":"Operating assets"},null,null,"$m",null,null,null,{"$f":"K48-K53","v":1172.5},{"$f":"L48-L53","v":1842.5},2345,2847.5,3350,3852.5,4355,4857.5,5360,5862.5,6365,6867.5,7370,7872.5,8375]
[null,null,null,"Under-construction assets",null,null,"$m",null,null,null,{"$f":"K49-K54","v":670},502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5]
[null,null,null,"Equity value of OpCo",null,null,"$m",null,null,null,{"$f":"SUM(K58:K59)","v":1842.5},{"$f":"SUM(L58:L59)","v":2345},2847.5,3350,3852.5,4355,4857.5,5360,5862.5,6365,6867.5,7370,7872.5,8375,8877.5]
[]
[null,{"$f":"Header_Number","v":3},"DevCo"]
[]
[null,null,null,"Cadence - assets being brought to FNTP",null,null,"MW",null,null,null,null,{"$f":"L13","v":1500},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500]
[]
[null,null,null,"DevCo value at FNTP",null,null,"$m","$k/MW net margin","Overheads ($/p.a.)","% growth",null,{"$f":"L64*$H67/1000","v":375},375,375,375,375,375,375,375,375,375,375,375,375,375]
[null,null,null,"Less: Overheads",null,null,"$m",250,0,0,null,{"$f":"-$I67*YEARFRAC(L5,M5)*(1+$J67)^YEARFRAC($L5,M5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"DevCo cash flows",null,null,"$m","Terminal year","TV multiple",null,null,{"$f":"SUM(L66:L67)","v":375},{"$f":"SUM(M66:M67)","v":375},375,375,375,375,375,375,375,375,375,375,375,375]
[null,null,null,"Terminal value",null,null,"$m",5,0,null,null,{"$f":"IF(L$7=$H69,(SUMIFS($L68:$Y68,$L$7:$Y$7,$H69)*$I69),0)","v":0},{"$f":"IF(N$7=$H69+1,(SUMIFS($L68:$Y68,$M$7:$Z$7,$H69+1)*$I69),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total pre-tax DevCo value creation",null,null,"$m",null,null,null,-9.9999999999999995E-8,{"$f":"SUM(L68:L69)*--(M$7<=$H69+1)","v":375},375,375,375,375,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Discount rate "]
[null,null,null,"XNPV / Equity value of DevCo",null,null,"$m",0,{"$f":"IF(H72=0,SUM(K70:Y70),IFERROR(XNPV(H72,K70:Y70,L4:Z4),0))","v":1874.9999998999999}]
[]
[null,null,null,"Total equity value",null,null,"$m"]
[null,null,null,"OpCo (operating assets)",null,null,"$m",null,null,null,{"$f":"K58","v":1172.5},1842.5,2345,2847.5,3350,3852.5,4355,4857.5,5360,5862.5,6365,6867.5,7370,7872.5,8375]
[null,null,null,"OpCo (under-construction assets)",null,null,"$m",null,null,null,{"$f":"K59","v":670},502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5,502.5]
[null,null,null,"DevCo",null,null,"$m",null,null,null,{"$f":"I72","v":1874.9999998999999},{"$f":"K77","v":1874.9999998999999},{"$f":"L77","v":1874.9999998999999},1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999,1874.9999998999999]
[null,null,null,"Total equity value",null,null,"$m",null,null,null,{"$f":"SUM(K75:K77)","v":3717.4999999000001},4219.9999999000001,4722.4999999000001,5224.9999999000001,5727.4999999000001,6229.9999999000001,6732.4999999000001,7234.9999999000001,7737.4999999000001,8239.9999998999992,8742.4999998999992,9244.9999998999992,9747.4999998999992,10249.999999899999,10752.499999899999]
[]
[null,null,null,"Value split"]
[null,null,null,{"$f":"D75:D78","v":"OpCo (operating assets)"},null,null,"%",null,null,null,{"$f":"IFERROR(K75/K$78,0)","v":0.31540013450747545},0.43661137441792919,0.49655902595016532,0.5449760765654541,0.58489742471558093,0.61837881220896274,0.64686223543478438,0.67138908086622517,0.69273021002510793,0.71146844661057618,0.72805261653678077,0.74283396431306481,0.75609130547069603,0.76804878049529812,0.77888863055827851]
[null,null,null,"OpCo (under-construction assets)",null,null,"%",null,null,null,{"$f":"IFERROR(K76/K$78,0)","v":0.18022864828998597},0.11907582938670795,0.10640550556074972,9.6172248805668367E-2,8.7734613707337136E-2,8.0658105940299485E-2,7.4637950242475132E-2,6.9454042848230188E-2,6.4943457189853879E-2,6.0983009709477953E-2,5.7477838147640584E-2,5.4353704705834012E-2,5.155167991845655E-2,4.9024390244380732E-2,4.6733317833496713E-2]
[null,null,null,"DevCo",null,null,"%",null,null,null,{"$f":"IFERROR(K77/K$78,0)","v":0.50437121720253852},0.44431279619536285,0.39703546848908489,0.35885167462887751,0.32736796157708192,0.30096308185073772,0.2784998143227404,0.25915687628554468,0.24232633278503812,0.22754854367994598,0.21446954531557874,0.20281233098110127,0.19235701461084748,0.18292682926032125,0.17437805160822487]
[null,null,null,"Total equity value",null,null,"%",null,null,null,{"$f":"IFERROR(K78/K$78,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[{"$f":"\" \"","v":" "}," "," "," ","END OF SHEET"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]

{"sheet":"U.S. Renewables Project","index":3,"n_rows":123,"n_cols":51,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Illustrative U.S. Renewables Project Example"]
[]
[null,null,null,null,null,null,"NPV (US$k)","IRR (%)"]
[null,null,null,null,"Unlevered",null,{"$f":"K60","v":22703.649838015808},{"$f":"K59","v":9.6376315729254758E-2}]
[null,null,null,null,"Levered",null,{"$f":"K120","v":18504.023247628847},{"$f":"K119","v":0.14610242880707736}]
[null,null,null,null,null,null,null,null,null,null,"Period",1,{"$f":"L7+1","v":2},{"$f":"M7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[]
[{"$f":"\" \"","v":" "},"Project"]
[]
[null,{"$f":"Header_Number","v":1},"P&L"]
[]
[null,null,null,"Generation"]
[null,null,null,"Capacity",null,null,"MW",null,null,null,100,{"$f":"K14","v":100},{"$f":"L14","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"AB14","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"AR14","v":100},100,100,100,100,100,100]
[null,null,null,"Capacity Factor",null,null,"%","Note: Average generation output / maximum generation capacity",null,null,0.3,{"$f":"K15","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,null,"Annual production",null,null,"MWh / year",null,null,null,null,{"$f":"L14*L15*8760","v":262800},262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800,262800]
[null,null,null,"PPA Period",null,null,"Flag",null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Revenue",null,null,null,"Escalation"]
[null,null,null,"Electricity Price",null,null,"$/MWh",2.5000000000000001E-2,null,null,28,{"$f":"$K20*(1+($H20*(1-L$17)))^L$7","v":28},28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,47.028291836334347,48.203999132242707,49.409099110548773,50.644326588312488,51.910434753020297,53.208195621845796,54.538400512391938,55.901860525201734,57.299407038331786,58.731892214290063,60.200189519647331,61.705194257638503,63.247824114079464,64.829019716931441,66.449745209854726,68.110988840101101,69.813763561103613,71.559107650131196,{"$f":"$K20*(1+($H20*(1-AX$17)))^AX$7","v":73.348085341384476},{"$f":"$K20*(1+($H20*(1-AY$17)))^AY$7","v":75.181787474919076}]
[null,null,null,"Renewable Energy Credit ('REC') Price ",null,null,"$/MWh",2.5000000000000001E-2,null,null,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,6.718327405190621,6.8862855903203863,7.0584427300783963,7.2349037983303557,7.4157763932886134,7.6011708031208283,7.7912000731988487,7.9859800750288192,8.1856295769045406,8.3902703163271521,8.6000270742353333,8.8150277510912147,9.0354034448684946,9.2612885309902069,9.4928207442649608,9.7301412628715855,9.9733947944433741,10.222729664304456,10.478297905912068,10.740255353559869]
[]
[null,null,null,"Electricity Revenue",null,null,"US$'000",null,null,null,{"$f":"K16*K20/1000","v":0},{"$f":"L16*L20/1000","v":7358.4},7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,7358.4,12359.035094588668,12668.010971953383,12984.711246252218,13309.329027408521,13642.062253093734,13983.113809421075,14332.691654656603,14691.008946023016,15058.284169673594,15434.741273915428,15820.609805763319,16216.1250509074,16621.528177180084,17037.06638160958,17462.993041149821,17899.567867178572,18347.057063858028,18805.73349045448,19275.876827715842,19757.773748408734]
[null,null,null,"REC Revenue",null,null,"US$'000",null,null,null,{"$f":"K16*K21/1000","v":0},{"$f":"L16*L21/1000","v":1051.2},1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1051.2,1765.5764420840951,1809.7158531361974,1854.9587494646025,1901.3327182012174,1948.8660361562477,1997.5876870601535,2047.5273792366575,2098.7155637175738,2151.1834528105132,2204.9630391307755,2260.0871151090455,2316.5892929867709,2374.5040253114403,2433.8666259442266,2494.7132915928319,2557.0811238826527,2621.0081519797186,2686.533355779211,2753.6966896736917,2822.5391069155335]
[null,null,null,"Total Revenue",null,null,"US$'000",null,null,null,{"$f":"K23+K24","v":0},{"$f":"L23+L24","v":8409.6},8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,8409.6,14124.611536672763,14477.72682508958,14839.66999571682,15210.661745609739,15590.928289249981,15980.701496481228,16380.21903389326,16789.72450974059,17209.467622484106,17639.704313046204,18080.696920872364,18532.714343894171,18996.032202491522,19470.933007553806,19957.706332742651,20456.648991061225,20968.065215837749,21492.266846233691,22029.573517389534,22580.312855324268]
[null,null,null,null,null,null,null,"Cost %"]
[null,null,null,"Operating Costs",null,null,"US$'000",0.25,null,null,{"$f":"K25*$H$23","v":0},{"$f":"L25*$H$27","v":2102.4},{"$f":"L27*(1+$H20)","v":2154.96},{"$f":"M27*(1+$H20)","v":2208.8339999999998},2264.0548499999995,2320.6562212499994,2378.6726267812492,2438.1394424507803,2499.0929285120496,2561.5702517248506,2625.6095080179716,2691.2497457184209,2758.5309893613812,2827.4942640954155,2898.1816206978006,2970.6361612152455,3044.9020652456265,3121.0246168767671,3199.0502322986858,3279.0264881061526,3361.002150308806,3445.0272040665259,3531.1528841681888,3619.4317062723931,3709.9174989292023,3802.6654364024321,3897.7320723124926,3995.1753741203047,4095.0547584733122,4197.4311274351448,4302.3669056210229,4409.9260782615484,4520.1742302180864,4633.1785859735382,4749.008050622876,4867.7332518884477,4989.4265831856583,5114.1622477652991,5242.0163039594308,5373.0667115584165,5507.3933793473761]
[]
[null,null,null,"EBITDA/Operating Cash Flows",null,null,"US$'000",null,null,null,{"$f":"K25-K27","v":0},{"$f":"L25-L27","v":6307.2000000000007},6254.64,6200.7660000000005,6145.5451500000008,6088.943778750001,6030.9273732187512,5971.4605575492205,5910.5070714879512,5848.0297482751503,5783.9904919820292,5718.3502542815795,5651.0690106386191,5582.1057359045844,5511.4183793022003,5438.9638387847554,5364.6979347543738,5288.5753831232332,5210.5497677013145,5130.5735118938483,5048.5978496911939,10679.584332606237,10946.573940921391,11220.238289444427,11500.744246680537,11788.262852847549,12082.969424168736,12385.043659772955,12694.669751267278,13012.03649504896,13337.337407425181,13670.770842610815,14012.540113676085,14362.853616517983,14721.924956930929,15089.973080854204,15467.222407875568,15853.902968072449,16250.250542274262,16656.506805831115,17072.919475976891]
[]
[null,{"$f":"Header_Number","v":2},"Capital Costs & Investment Tax Credits"]
[]
[null,null,null,"Construction cost per watt",null,null,"$/W",null,null,null,1]
[null,null,null,"Installed Cost",null,null,"US$'000","FMV Step-Up",null,null,{"$f":"K33*K14*1000","v":100000}]
[null,null,null,"Fair Market Value ('FMV')",null,null,"US$'000",0.2,null,null,{"$f":"(H35+1)*K34","v":120000}]
[null,null,null,"'Step-Up' in value",null,null,"US$'000","ITC % of FMV",null,null,{"$f":"K35-K34","v":20000}]
[null,null,null,"Investment Tax Credit ('ITC')",null,null,"US$'000",0.3,null,null,{"$f":"K35*$H$37","v":36000}]
[null,null,null,"Depreciable Basis for Tax",null,null,"US$'000",null,null,null,{"$f":"K35-(K37*0.5)","v":102000}]
[]
[null,{"$f":"Header_Number","v":3},"Cash tax profile"]
[]
[null,null,null,"Income (i.e., EBITDA)",null,null,"US$'000",null,null,null,{"$f":"K29","v":0},6307.2000000000007,6254.64,6200.7660000000005,6145.5451500000008,6088.943778750001,6030.9273732187512,5971.4605575492205,5910.5070714879512,5848.0297482751503,5783.9904919820292,5718.3502542815795,5651.0690106386191,5582.1057359045844,5511.4183793022003,5438.9638387847554,5364.6979347543738,5288.5753831232332,5210.5497677013145,5130.5735118938483,5048.5978496911939,10679.584332606237,10946.573940921391,11220.238289444427,11500.744246680537,11788.262852847549,12082.969424168736,12385.043659772955,12694.669751267278,13012.03649504896,13337.337407425181,13670.770842610815,14012.540113676085,14362.853616517983,14721.924956930929,15089.973080854204,15467.222407875568,15853.902968072449,16250.250542274262,16656.506805831115,17072.919475976891]
[null,null,null,"Tax Depreciation",null,null,"US$'000","Note: Applies 5Y Modified Accelerated Cost Recovery System (MACRS)",null,null,0,0.2,0.32,0.192,0.1152,0.1152,5.7599999999999998E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Gain on Sale (i.e., Step-Up)",null,null,"US$'000",null,null,null,{"$f":"K36","v":20000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Depreciation",null,null,"US$'000",null,null,null,0,{"$f":"-$K$38*L43","v":-20400},{"$f":"-$K$38*M43","v":-32640},-19584,-11750.4,-11750.4,-5875.2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Income",null,null,"US$'000","Tax rate %",null,null,{"$f":"K42+K44+K45","v":20000},{"$f":"L42+L44+L45","v":-14092.8},{"$f":"M42+M44+M45","v":-26385.360000000001},-13383.234,-5604.8548499999988,-5661.4562212499986,155.72737321875138,5971.4605575492205,5910.5070714879512,5848.0297482751503,5783.9904919820292,5718.3502542815795,5651.0690106386191,5582.1057359045844,5511.4183793022003,5438.9638387847554,5364.6979347543738,5288.5753831232332,5210.5497677013145,5130.5735118938483,5048.5978496911939,10679.584332606237,10946.573940921391,11220.238289444427,11500.744246680537,11788.262852847549,12082.969424168736,12385.043659772955,12694.669751267278,13012.03649504896,13337.337407425181,13670.770842610815,14012.540113676085,14362.853616517983,14721.924956930929,15089.973080854204,15467.222407875568,15853.902968072449,16250.250542274262,16656.506805831115,17072.919475976891]
[null,null,null,"Cash Tax (Excluding ITC)",null,null,"US$'000",0.21,null,null,{"$f":"-K46*$H$47","v":-4200},{"$f":"-L46*$H$47","v":2959.4879999999998},5540.9255999999996,2810.4791399999999,1177.0195184999998,1188.9058064624996,-32.702748375937787,-1254.0067170853363,-1241.2064850124698,-1228.0862471377816,-1214.6380033162261,-1200.8535533991317,-1186.7244922341099,-1172.2422045399626,-1157.3978596534621,-1142.1824061447985,-1126.5865662984183,-1110.6008304558788,-1094.215451217276,-1077.420437497708,-1060.2055484351506,-2242.7127098473097,-2298.780527593492,-2356.2500407833295,-2415.1562918029126,-2475.5351990979852,-2537.4235790754342,-2600.8591685523206,-2665.8806477661283,-2732.5276639602816,-2800.8408555592878,-2870.8618769482709,-2942.6334238719778,-3016.1992594687763,-3091.6042409554948,-3168.894346979383,-3248.1167056538693,-3329.3196232952141,-3412.5526138775949,-3497.8664292245339,-3585.313089955147]
[null,null,null,"Investment Tax Credit Value",null,null,"US$'000",null,null,null,0,{"$f":"K37","v":36000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cash Tax Benefit/(Detriment)",null,null,"US$'000",null,null,null,{"$f":"K47+K48","v":-4200},{"$f":"L47+L48","v":38959.487999999998},5540.9255999999996,2810.4791399999999,1177.0195184999998,1188.9058064624996,-32.702748375937787,-1254.0067170853363,-1241.2064850124698,-1228.0862471377816,-1214.6380033162261,-1200.8535533991317,-1186.7244922341099,-1172.2422045399626,-1157.3978596534621,-1142.1824061447985,-1126.5865662984183,-1110.6008304558788,-1094.215451217276,-1077.420437497708,-1060.2055484351506,-2242.7127098473097,-2298.780527593492,-2356.2500407833295,-2415.1562918029126,-2475.5351990979852,-2537.4235790754342,-2600.8591685523206,-2665.8806477661283,-2732.5276639602816,-2800.8408555592878,-2870.8618769482709,-2942.6334238719778,-3016.1992594687763,-3091.6042409554948,-3168.894346979383,-3248.1167056538693,-3329.3196232952141,-3412.5526138775949,-3497.8664292245339,-3585.313089955147]
[]
[null,{"$f":"Header_Number","v":4},"Unlevered After-Tax Cash Flows"]
[]
[null,null,null,"Installed Cost",null,null,"US$'000",null,null,null,{"$f":"-K34","v":-100000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D29","v":"EBITDA/Operating Cash Flows"},null,null,"US$'000",null,null,null,{"$f":"K29","v":0},6307.2000000000007,6254.64,6200.7660000000005,6145.5451500000008,6088.943778750001,6030.9273732187512,5971.4605575492205,5910.5070714879512,5848.0297482751503,5783.9904919820292,5718.3502542815795,5651.0690106386191,5582.1057359045844,5511.4183793022003,5438.9638387847554,5364.6979347543738,5288.5753831232332,5210.5497677013145,5130.5735118938483,5048.5978496911939,10679.584332606237,10946.573940921391,11220.238289444427,11500.744246680537,11788.262852847549,12082.969424168736,12385.043659772955,12694.669751267278,13012.03649504896,13337.337407425181,13670.770842610815,14012.540113676085,14362.853616517983,14721.924956930929,15089.973080854204,15467.222407875568,15853.902968072449,16250.250542274262,16656.506805831115,17072.919475976891]
[null,null,null,"Cash Tax (Excluding ITC)",null,null,"US$'000",null,null,null,{"$f":"K47","v":-4200},2959.4879999999998,5540.9255999999996,2810.4791399999999,1177.0195184999998,1188.9058064624996,-32.702748375937787,-1254.0067170853363,-1241.2064850124698,-1228.0862471377816,-1214.6380033162261,-1200.8535533991317,-1186.7244922341099,-1172.2422045399626,-1157.3978596534621,-1142.1824061447985,-1126.5865662984183,-1110.6008304558788,-1094.215451217276,-1077.420437497708,-1060.2055484351506,-2242.7127098473097,-2298.780527593492,-2356.2500407833295,-2415.1562918029126,-2475.5351990979852,-2537.4235790754342,-2600.8591685523206,-2665.8806477661283,-2732.5276639602816,-2800.8408555592878,-2870.8618769482709,-2942.6334238719778,-3016.1992594687763,-3091.6042409554948,-3168.894346979383,-3248.1167056538693,-3329.3196232952141,-3412.5526138775949,-3497.8664292245339,-3585.313089955147]
[null,null,null,"ITC Value",null,null,"US$'000",null,null,null,0,36000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Net After Tax Cash Flows",null,null,"US$'000",null,null,null,{"$f":"SUM(K53:K56)","v":-104200},45266.688000000002,11795.5656,9011.2451400000009,7322.5646685000011,7277.8495852125006,5998.2246248428137,4717.4538404638843,4669.3005864754814,4619.9435011373689,4569.3524886658033,4517.4967008824478,4464.3445184045095,4409.8635313646218,4354.0205196487386,4296.7814326399566,4238.111368455955,4177.9745526673541,4116.3343164840389,4053.1530743961403,3988.3923012560435,8436.8716227589266,8647.7934133278995,8863.9882486610986,9085.5879548776247,9312.7276537495636,9545.545845093302,9784.1844912206343,10028.789103501149,10279.508831088679,10536.496551865894,10799.908965662544,11069.906689804107,11346.654357049207,11630.320715975435,11921.078733874821,12219.105702221699,12524.583344777235,12837.697928396667,13158.640376606581,13487.606386021744]
[]
[null,null,null,"IRR",null,null,"%","Discount rate",null,null,{"$f":"IRR(K57:AY57)","v":9.6376315729254758E-2}]
[null,null,null,"NPV",null,null,"US$'000",7.0000000000000007E-2,null,null,{"$f":"NPV($H$60,K57:AY57)","v":22703.649838015808}]
[null,null,null,"NPV / kW",null,null,"US$/kW",null,null,null,{"$f":"K60/K14","v":227.03649838015809}]
[]
[{"$f":"\" \"","v":" "},"Tax equity partnership"]
[null,null,null,null,"Tax Equity Partnership - provides liquidity on federal tax credit and accelarated depreciation, necessary because tax benefits (losses and credits) exceed project level income years 1-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLIP DATE >"]
[null,{"$f":"Header_Number","v":5},"Class A Member - Tax Equity"]
[]
[null,null,null,"Allocation of Income/Credits %",null,null,"%",null,null,null,0,0.99,0.67,0.67,0.67,0.67,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,null,null,"Allocation of Cash %",null,null,"%",null,null,null,0,0.2,0.2,0.2,0.2,0.2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[]
[null,null,null,"Allocation of Cash Tax/Credits",null,null,"US$'000",null,null,null,{"$f":"K68*K49","v":0},38569.893120000001,3712.4201520000001,1883.0210238,788.6030773949999,796.56689032987481,-1.6351374187968895,-62.700335854266818,-62.060324250623495,-61.404312356889079,-60.731900165811311,-60.042677669956589,-59.336224611705497,-58.612110226998134,-57.869892982673107,-57.109120307239927,-56.329328314920922,-55.530041522793944,-54.710772560863802,-53.8710218748854,-53.010277421757536,-112.13563549236549,-114.9390263796746,-117.81250203916647,-120.75781459014564,-123.77675995489926,-126.87117895377172,-130.04295842761604,-133.29403238830642,-136.62638319801408,-140.04204277796438,-143.54309384741356,-147.13167119359889,-150.80996297343881,-154.58021204777475,-158.44471734896916,-162.40583528269349,-166.46598116476071,-170.62763069387975,-174.89332146122672,-179.26565449775737]
[null,null,null,"Allocation of Pre-Tax Cash Flow",null,null,"US$'000",null,null,null,{"$f":"K69*K54","v":0},1261.4400000000003,1250.9280000000001,1240.1532000000002,1229.1090300000003,1217.7887557500003,301.54636866093756,298.57302787746102,295.52535357439757,292.40148741375754,289.19952459910149,285.91751271407901,282.55345053193099,279.10528679522923,275.57091896511002,271.9481919392378,268.23489673771871,264.42876915616165,260.52748838506574,256.5286755946924,252.4298924845597,533.97921663031184,547.32869704606958,561.01191447222141,575.03721233402689,589.41314264237747,604.14847120843683,619.25218298864775,634.73348756336395,650.60182475244801,666.8668703712591,683.5385421305408,700.62700568380433,718.14268082589922,736.09624784654648,754.49865404271031,773.36112039377849,792.69514840362251,812.51252711371308,832.82534029155579,853.64597379884458]
[null,null,null,"Total After-Tax Value to Tax Equity",null,null,"US$'000","Flip return",null,null,{"$f":"SUM(K71:K72)","v":0},{"$f":"SUM(L71:L72)","v":39831.333120000003},4963.3481520000005,3123.1742238000002,2017.7121073950002,2014.355646079875,299.91123124214067,235.87269202319419,233.46502932377408,230.99717505686846,228.46762443329018,225.87483504412242,223.2172259202255,220.49317656823109,217.70102598243693,214.83907163199788,211.90556842279778,208.89872763336771,205.81671582420194,202.657653719807,199.41961506280217,421.84358113794633,432.38967066639498,443.19941243305493,454.27939774388125,465.6363826874782,477.2772922546651,489.2092245610317,501.43945517505756,513.97544155443393,526.82482759329469,539.99544828312719,553.49533449020544,567.33271785246041,581.51603579877178,596.05393669374121,610.955285111085,626.22916723886181,641.88489641983335,657.93201883032907,674.38031930108718]
[null,null,null,"Resulting Tax Equity Invesment",null,null,"US$'000",7.0000000000000007E-2,null,null,null,{"$f":"NPV(H74,M73:P73)+L73","v":50381.673962120571}]
[]
[null,{"$f":"Header_Number","v":6},"Class B Member - Tax Equity"]
[]
[null,null,null,"Allocation of Income",null,null,"%",null,null,null,{"$f":"1-K68","v":1},1.0000000000000009E-2,0.32999999999999996,0.32999999999999996,0.32999999999999996,0.32999999999999996,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[null,null,null,"Allocation of Credits",null,null,"%",null,null,null,1,0.8,0.8,0.8,0.8,0.8,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[]
[null,null,null,"Allocation of Cash Tax/Credits",null,null,"US$'000",null,null,null,{"$f":"K78*K49","v":-4200},389.59488000000033,1828.5054479999997,927.45811619999984,388.41644110499988,392.33891613262483,-31.067610957140896,-1191.3063812310695,-1179.1461607618462,-1166.6819347808926,-1153.9061031504148,-1140.810875729175,-1127.3882676224043,-1113.6300943129645,-1099.5279666707888,-1085.0732858375586,-1070.2572379834974,-1055.0707889330849,-1039.5046786564121,-1023.5494156228226,-1007.195271013393,-2130.5770743549442,-2183.8415012138175,-2238.4375387441628,-2294.3984772127669,-2351.758439143086,-2410.5524001216622,-2470.8162101247044,-2532.5866153778215,-2595.9012807622676,-2660.7988127813232,-2727.3187831008572,-2795.5017526783786,-2865.3892964953375,-2937.0240289077201,-3010.4496296304137,-3085.7108703711756,-3162.8536421304534,-3241.9249831837151,-3322.9731077633069,-3406.0474354573894]
[null,null,null,"Allocation of Pre-Tax Cash Flow",null,null,"US$'000",null,null,null,{"$f":"K79*K54","v":0},5045.7600000000011,5003.7120000000004,4960.6128000000008,4916.4361200000012,4871.1550230000012,5729.381004557813,5672.8875296717597,5614.9817179135534,5555.6282608613928,5494.7909673829272,5432.4327415675007,5368.5155601066881,5303.000449109355,5235.8474603370896,5167.015646845517,5096.4630380166545,5024.1466139670711,4950.0222793162484,4874.0448362991556,4796.1679572066341,10145.605115975924,10399.245243875321,10659.226374972206,10925.707034346509,11198.849710205172,11478.820952960299,11765.791476784307,12059.936263703914,12361.434670296512,12670.470537053921,12987.232300480273,13311.913107992279,13644.710935692083,13985.828709084382,14335.474426811494,14693.861287481788,15061.207819668825,15437.738015160548,15823.681465539559,16219.273502178045]
[null,null,null,"Total After-Tax Value to Longroad",null,null,"US$'000",null,null,null,{"$f":"K81+K82","v":-4200},{"$f":"L81+L82","v":5435.3548800000017},6832.2174480000003,5888.0709162000003,5304.8525611050009,5263.4939391326261,5698.3133936006725,4481.5811484406904,4435.8355571517077,4388.9463260805005,4340.884864232512,4291.6218658383259,4241.1272924842833,4189.3703547963905,4136.3194936663003,4081.9423610079584,4026.2058000331572,3969.0758250339859,3910.5176006598363,3850.4954206763332,3788.9726861932413,8015.0280416209807,8215.4037426615032,8420.7888362280428,8631.3085571337433,8847.0912710620851,9068.2685528386373,9294.9752666596032,9527.3496483260933,9765.5333895342446,10009.671724272597,10259.913517379417,10516.4113553139,10779.321639196745,11048.804680176661,11325.02479718108,11608.150417110613,11898.354177538371,12195.813031976833,12500.708357776253,12813.226066720656]
[]
[null,null,null,"Combined After-Cash Flow",null,null,"US$'000",null,null,null,{"$f":"K73+K83","v":-4200},45266.688000000002,11795.565600000002,9011.2451400000009,7322.5646685000011,7277.8495852125016,5998.2246248428128,4717.4538404638843,4669.3005864754814,4619.9435011373689,4569.3524886658024,4517.4967008824487,4464.3445184045086,4409.8635313646218,4354.0205196487368,4296.7814326399566,4238.111368455955,4177.9745526673532,4116.334316484038,4053.1530743961403,3988.3923012560435,8436.8716227589266,8647.7934133278977,8863.9882486610986,9085.5879548776247,9312.7276537495636,9545.545845093302,9784.1844912206343,10028.789103501151,10279.508831088679,10536.496551865892,10799.908965662544,11069.906689804106,11346.654357049205,11630.320715975433,11921.078733874821,12219.105702221699,12524.583344777233,12837.697928396667,13158.640376606581,13487.606386021744]
[null,null,null,"CHECK",null,null,"US$'000",null,null,null,{"$f":"K85-K49-K54","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"Header_Number","v":7},"Net After-Tax Cash Flows to Longroad"]
[]
[null,null,null,{"$f":"D53","v":"Installed Cost"},null,null,"US$'000",null,null,null,{"$f":"K53","v":-100000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Tax Equity Investment",null,null,"US$'000",null,null,null,0,{"$f":"L74","v":50381.673962120571},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Class B Cash Flows",null,null,"US$'000",null,null,null,{"$f":"K83","v":-4200},5435.3548800000017,6832.2174480000003,5888.0709162000003,5304.8525611050009,5263.4939391326261,5698.3133936006725,4481.5811484406904,4435.8355571517077,4388.9463260805005,4340.884864232512,4291.6218658383259,4241.1272924842833,4189.3703547963905,4136.3194936663003,4081.9423610079584,4026.2058000331572,3969.0758250339859,3910.5176006598363,3850.4954206763332,3788.9726861932413,8015.0280416209807,8215.4037426615032,8420.7888362280428,8631.3085571337433,8847.0912710620851,9068.2685528386373,9294.9752666596032,9527.3496483260933,9765.5333895342446,10009.671724272597,10259.913517379417,10516.4113553139,10779.321639196745,11048.804680176661,11325.02479718108,11608.150417110613,11898.354177538371,12195.813031976833,12500.708357776253,12813.226066720656]
[null,null,null,"Total Longroad Cash Flows",null,null,"US$'000",null,null,null,{"$f":"SUM(K90:K92)","v":-104200},{"$f":"SUM(L90:L92)","v":55817.02884212057},6832.2174480000003,5888.0709162000003,5304.8525611050009,5263.4939391326261,5698.3133936006725,4481.5811484406904,4435.8355571517077,4388.9463260805005,4340.884864232512,4291.6218658383259,4241.1272924842833,4189.3703547963905,4136.3194936663003,4081.9423610079584,4026.2058000331572,3969.0758250339859,3910.5176006598363,3850.4954206763332,3788.9726861932413,8015.0280416209807,8215.4037426615032,8420.7888362280428,8631.3085571337433,8847.0912710620851,9068.2685528386373,9294.9752666596032,9527.3496483260933,9765.5333895342446,10009.671724272597,10259.913517379417,10516.4113553139,10779.321639196745,11048.804680176661,11325.02479718108,11608.150417110613,11898.354177538371,12195.813031976833,12500.708357776253,12813.226066720656]
[null,null,null,"IRR",null,null,"%","Discount rate",null,null,{"$f":"IRR(K93:AY93)","v":9.4317182617034589E-2}]
[null,null,null,"NPV",null,null,"US$'000",7.0000000000000007E-2,null,null,{"$f":"NPV(H95,K93:AY93)","v":20004.880228209746}]
[null,null,null,"NPV $/kW",null,null,"US$'000",null,null,null,{"$f":"K95/K14","v":200.04880228209745}]
[]
[null,{"$f":"Header_Number","v":8},"Back Leverage"]
[]
[null,null,null,"Cash Flow Available after Tax Equity",null,null,"US$'000",null,null,null,null,{"$f":"L54-L72","v":5045.76},{"$f":"M54-M72","v":5003.7120000000004},4960.6128000000008,4916.4361200000003,4871.1550230000012,5729.3810045578139,5672.8875296717597,5614.9817179135534,5555.6282608613928,5494.7909673829281,5432.4327415675007,5368.5155601066881,5303.000449109355,5235.8474603370905,5167.0156468455179,5096.4630380166554,5024.146613967072,4950.0222793162484,4874.0448362991556,4796.1679572066341,10145.605115975924,10399.245243875321,10659.226374972206,10925.707034346509,11198.849710205172,11478.820952960299,11765.791476784307,12059.936263703914,12361.434670296512,12670.470537053921,12987.232300480275,13311.913107992281,13644.710935692085,13985.828709084382,14335.474426811494,14693.86128748179,15061.207819668827,15437.738015160548,15823.681465539559,16219.273502178046]
[null,null,null,"DSCR @ 1.35x",null,null,"US$'000","Interest %",null,null,null,{"$f":"L100/1.35","v":3737.6},{"$f":"M100/1.35","v":3706.4533333333334},3674.5280000000002,3641.8045333333334,3608.2629800000004,4243.9859293020845,4202.1389108679696,4159.2457169730023,4115.2801932306611,4070.2155313947615,4024.0242530129631,3976.6781926716208,3928.1484808217442,3878.4055261756225,3827.4189976633465,3775.1578059382632,3721.5900844200532,3666.6831698638875,3610.4035824438188,3552.7170053382474,7515.2630488710547,7703.1446250928293,7895.7232407201518,8093.1163217381545,8295.4442297816076,8502.8303355261469,8715.4010939143009,8933.2861212621574,9156.6182742937126,9385.5337311510521,9620.1720744298327,9860.6763762905775,10107.19328569784,10359.873117840283,10618.869945786291,10884.341694430956,11156.450236791723,11435.361492711516,11721.245530029302,12014.276668280034]
[null,null,null,"Discount Factor",null,null,null,0.06,null,null,null,{"$f":"1/(1+$H102)^L$7*L17","v":0.94339622641509424},{"$f":"1/(1+$H102)^M$7*M17","v":0.88999644001423983},0.8396192830323016,0.79209366323802044,0.74725817286605689,0.70496054043967626,0.66505711362233599,0.62741237134182648,0.59189846353002495,0.55839477691511785,0.52678752539162055,0.4969693635770005,0.46883902224245327,0.44230096437967292,0.41726506073554037,0.39364628371277405,0.37136441859695657,0.35034379112920433,0.3305130104992493,0.31180472688608429,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"BOP Balance",null,null,"US$'000",null,null,null,null,{"$f":"SUMPRODUCT(L102:AY102,L101:AY101)","v":44299.62419333087},{"$f":"L107","v":43220.001644930722},{"$f":"M107","v":42106.748410293236},40958.625314910831,39774.338300472147,38552.535618500478,36621.701826308425,34616.86502501896,32534.631209547097,30371.428888889262,28123.499090827856,25786.884783264562,23357.419677588816,20830.716377422399,18202.15383389212,15466.8640662623,12619.718104299774,9655.3111061377076,6567.9466026420823,3351.6198163567883,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interest",null,null,"US$'000",null,null,null,null,{"$f":"$H$102*L104","v":2657.977451599852},2593.2000986958433,2526.4049046175942,2457.5175188946496,2386.4602980283289,2313.1521371100284,2197.3021095785052,2077.0119015011373,1952.0778725728258,1822.2857333333557,1687.4099454496713,1547.2130869958737,1401.4451806553288,1249.8429826453439,1092.1292300335272,928.01184397573797,757.18308625798647,579.31866636826248,394.07679615852493,201.0971889814073,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Principal",null,null,"US$'000",null,null,null,null,{"$f":"MIN(L101-L105,L104)","v":1079.6225484001479},1113.2532346374901,1148.1230953824061,1184.2870144386839,1221.8026819716715,1930.8337921920561,2004.8368012894643,2082.233815471865,2163.2023206578351,2247.9297980614056,2336.6143075632917,2429.4651056757471,2526.7033001664154,2628.5625435302786,2735.2897676298194,{"$f":"MIN(AA101-AA105,AA104)","v":2847.1459619625252},{"$f":"MIN(AB101-AB105,AB104)","v":2964.4069981620669},3087.3645034956253,3216.326786285294,3351.6198163567883,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"EOP Balance",null,null,"US$'000",null,null,null,null,{"$f":"L104-L106","v":43220.001644930722},{"$f":"M104-M106","v":42106.748410293236},{"$f":"N104-N106","v":40958.625314910831},39774.338300472147,38552.535618500478,36621.701826308425,34616.86502501896,32534.631209547097,30371.428888889262,28123.499090827856,25786.884783264562,23357.419677588816,20830.716377422399,18202.15383389212,15466.8640662623,12619.718104299774,9655.3111061377076,6567.9466026420823,3351.6198163567883,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"Header_Number","v":9},"Levered After Tax Cash Flows"]
[]
[null,null,null,"Installed Cost",null,null,"US$'000",null,null,null,{"$f":"K90","v":-100000}]
[null,null,null,"Construction Loan Borrow/(Repay)",null,null,"US$'000",null,null,null,{"$f":"-K111*0.85","v":85000},{"$f":"-K112*(1+H102)","v":-90100}]
[null,null,null,"Tax Equity Investment",null,null,"US$'000",null,null,null,null,{"$f":"L91","v":50381.673962120571}]
[null,null,null,"Term Loan Borrowing",null,null,"US$'000",null,null,null,null,{"$f":"L104","v":44299.62419333087}]
[null,null,null,"Levered PT Cash Flows from Operations",null,null,"US$'000",null,null,null,null,{"$f":"L100-L105-L106","v":1308.1600000000003},1297.2586666666671,1286.0848000000005,1274.6315866666669,1262.8920430000007,1485.3950752557294,1470.7486188037901,1455.7360009405511,1440.3480676307317,1424.5754359881666,1408.4084885545376,1391.8373674350673,1374.8519682876108,1357.441934161468,1339.5966491821714,1321.3052320783922,1302.5565295470187,1283.3391094523604,1263.6412538553363,1243.4509518684386,10145.605115975924,10399.245243875321,10659.226374972206,10925.707034346509,11198.849710205172,11478.820952960299,11765.791476784307,12059.936263703914,12361.434670296512,12670.470537053921,12987.232300480275,13311.913107992281,13644.710935692085,13985.828709084382,14335.474426811494,14693.86128748179,15061.207819668827,15437.738015160548,15823.681465539559,16219.273502178046]
[null,null,null,"Unlevered Cash Taxes to Class B",null,null,"US$'000",null,null,null,{"$f":"K81","v":-4200},389.59488000000033,1828.5054479999997,927.45811619999984,388.41644110499988,392.33891613262483,-31.067610957140896,-1191.3063812310695,-1179.1461607618462,-1166.6819347808926,-1153.9061031504148,-1140.810875729175,-1127.3882676224043,-1113.6300943129645,-1099.5279666707888,-1085.0732858375586,-1070.2572379834974,-1055.0707889330849,-1039.5046786564121,-1023.5494156228226,-1007.195271013393,-2130.5770743549442,-2183.8415012138175,-2238.4375387441628,-2294.3984772127669,-2351.758439143086,-2410.5524001216622,-2470.8162101247044,-2532.5866153778215,-2595.9012807622676,-2660.7988127813232,-2727.3187831008572,-2795.5017526783786,-2865.3892964953375,-2937.0240289077201,-3010.4496296304137,-3085.7108703711756,-3162.8536421304534,-3241.9249831837151,-3322.9731077633069,-3406.0474354573894]
[null,null,null,"Interest Tax Shield",null,null,"US$'000",null,null,null,null,{"$f":"L105*$H47","v":558.17526483596885},{"$f":"M105*$H47","v":544.57202072612711},530.54502996969472,516.07867896787639,501.15666258594905,485.76194879310594,461.43344301148608,436.17249931523884,409.93635324029339,382.68000400000466,354.35608854443097,324.91474826913344,294.30348793761902,262.46702635552219,229.34713830704069,194.88248723490497,159.00844811417716,121.65691993733512,82.756127193290226,42.230409686095534,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"After-Tax Levered Cash Flow to Longroad",null,null,"US$'000",null,null,null,{"$f":"SUM(K111:K117)","v":-19200},6837.2283002874101,3670.3361353927935,2744.087946169695,2179.1267067395429,2156.3876217185748,1940.0894130916945,740.87568058420675,712.76233949394373,683.60248609013252,653.34933683775648,621.95370136979363,589.3638480817965,555.52536191226534,520.38099384620136,483.87050165165351,445.93048132979982,406.49418872811094,365.49135073328341,322.84796542580398,278.48609054114104,{"$f":"SUM(AF111:AF117)","v":8015.0280416209807},8215.4037426615032,8420.7888362280428,8631.3085571337433,8847.0912710620851,9068.2685528386373,9294.9752666596032,9527.3496483260933,9765.5333895342446,10009.671724272597,10259.913517379417,10516.411355313903,10779.321639196747,11048.804680176661,11325.02479718108,11608.150417110613,11898.354177538375,12195.813031976833,12500.708357776253,12813.226066720657]
[null,null,null,"IRR",null,null,"%","Discount rate",null,null,{"$f":"IRR(K118:AY118)","v":0.14610242880707736}]
[null,null,null,"NPV",null,null,"US$'000",0.08,null,null,{"$f":"NPV(H120,K118:AY118)","v":18504.023247628847}]
[null,null,null,"NPV $/kW",null,null,"US$/kW",null,null,null,{"$f":"K120/K14","v":185.04023247628848}]
[]
[{"$f":"\" \"","v":" "}," "," "," ","END OF SHEET"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]

{"sheet":"Styles","index":4,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Styles"]
[]
[null,"Sheet check "]
[null,"Overall check "]
[]
[]
[]
[]
[null,{"$f":"Header_Number","v":1},"Styles"]
[]
[]
[null,null,null,null,null,"Blank",null,null,null,"Intentionally left blank "]
[]
[null,null,null,null,null,"Check (summ.)",null,0,null,"Check summary for rows, columns etc"]
[]
[null,null,null,null,null,"Check (indiv)",null,1,null,"Check for individual cells or periods"]
[]
[null,null,null,null,null,"Flag",null,0]
[]
[null,null,null,null,null,"Heading 1",null,"Heading 1"]
[]
[null,null,null,null,null,"Heading 2",null,"Heading 2"]
[]
[null,null,null,null,null,"Heading 3",null,"Heading 3"]
[]
[null,null,null,null,null,"Input",null,100]
[]
[null,null,null,null,null,"Input (calculated)",null,100]
[]
[null,null,null,null,null,"Macro Copy",null,"Macro_Copy"]
[]
[null,null,null,null,null,"Macro Paste",null,"Macro_Paste"]
[]
[null,null,null,null,null,"Nominal total",null,100,null,"Nominal totals for rows or columns "]
[]
[null,null,null,null,null,"Offsheet ",null,100]
[]
[null,null,null,null,null,"Range name ",null,"Range_name",null,"Name of the named range"]
[]
[null,null,null,null,null,"Reference",null,25,null,"Source reference"]
[]
[null,null,null,null,null,"Selected Scenario",null,100]
[]
[null,null,null,null,null,"Sheet Title",null,"Tab"]
[]
[null,null,null,null,null,"Table Header",null,"lorem ipsum"]
[]
[null,null,null,null,null,"Unique",null,"Unique"]
[]
[null,null,null,null,null,"Unit ",null,"lorem ipsum"]
[]
[null,{"$f":"Header_Number","v":2},"Number Fomats"]
[]
[null,null,null,null,null,"Check",null,1]
[null,null,null,null,null,"Comma [0]",null,1000]
[null,null,null,null,null,"Comma",null,1000,null,"2dp"]
[null,null,null,null,null,"Currency",null,100]
[null,null,null,null,null,"Currency [0]",null,100]
[null,null,null,null,null,"Date",null,"2019-01-01"]
[null,null,null,null,null,"Year",null,2019]
[null,null,null,null,null,"Multiplier / ratio",null,1.1000000000000001]
[null,null,null,null,null,"Index",null,1.0024999999999999]
[null,null,null,null,null,"Percentage",null,1]
[null,null,null,null,null,"Percentage (2dp)",null,1]
[null,null,null,null,null,"Switch (On / Off)",null,1]
[null,null,null,null,null,"Switch (Yes / No)",null,0]