{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes","Exercise","Completed Exercise","Annual Exercise","Settings","Advertising"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":49,"comments":0,"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":"Notes","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Compute the construction period"]
[]
[null,null,"Establish the period code"]
[]
[null,null,"Big Trick is to compute the months per year that depends on the construction versus operating period"]
[]
[null,null,"Use Eomonth or Edate functions once the months are defined"]
[]
[null,null,"Compute the start and end date"]
[]
[null,null,"Use the XIRR function to compute the IRR"]
[]
[null,null,"To compute annual flows, use the sumif function where the criteria is the year number"]
[]
[null,null,"PLEASE OPEN THE GENERIC MACROS FILE"]

{"sheet":"Exercise","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,"Project IRR",{"$f":"D40","v":0}]
[]
[null,"Inputs"]
[]
[]
[null,null,"Start of Construction","2015-01-01"]
[null,null,"Start of Operation","2017-01-01"]
[null,null,"EPC Cost",125000]
[null,null,"LD",0]
[null,null,"Annual Cash Flow",40000]
[null,null,"Periods per year Construction",12,"Monthly"]
[null,null,"Periods per year Opearion",{"$f":"VLOOKUP(E12,Settings!$D$4:$E$7,2,FALSE)","v":2},"Semi-Annual"]
[null,null,"Concession Period Yrs",30]
[null,null,"End of Concession",{"$f":"EDATE(Start_of_Construction,Concession_Period_Yrs*12)","v":"2045-01-01"}]
[]
[null,"Date Calculations"]
[]
[null,null,"Operating Counters"]
[null,null,"Construction Switch"]
[null,null,"Months per Period"]
[null,null,"Start Date"]
[null,null,"End Date "]
[null,null,"End Year"]
[null,null,"Year"]
[null,null,"Days in Period"]
[null,null,"Operation Switch"]
[]
[null,"Cash Flow"]
[null,null,"Construction Expenditures"]
[null,null,"Operating Cash Flow"]
[null,null,"Net Cash Flow"]
[]
[null,null,"IRR on Net Cash Flow"]

{"sheet":"Completed Exercise","index":2,"n_rows":33,"n_cols":244,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,"Project IRR",{"$f":"D40","v":0}]
[]
[null,"Inputs"]
[]
[]
[null,null,"Start of Construction","2015-01-01"]
[null,null,"Start of Operation","2017-01-01"]
[null,null,"EPC Cost",125000]
[null,null,"LD",0]
[null,null,"Annual Cash Flow",40000]
[null,null,"Periods per year Construction",12,"Monthly"]
[null,null,"Periods per year Opearion",{"$f":"VLOOKUP(E12,Settings!$D$4:$E$7,2,FALSE)","v":2},"Semi-Annual"]
[null,null,"Concession Period Yrs",30]
[null,null,"End of Concession",{"$f":"EDATE(Start_of_Construction,Concession_Period_Yrs*12)","v":"2045-01-01"}]
[]
[null,"Date Calculations"]
[]
[null,null,"Operating Counters","Per b/4 COD",{"$f":"DAYS360(Start_of_Construction,D7)/30","v":24},null,null,{"$f":"1-E18","v":-23},{"$f":"H18+1","v":-22},{"$f":"I18+1","v":-21},-20,-19,-18,-17,-16,-15,-14,-13,-12,-11,-10,-9,-8,-7,-6,-5,-4,-3,-2,-1,0,1,2,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,41,42,{"$f":"BU18+1","v":43},44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,{"$f":"EG18+1","v":107},108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,{"$f":"GS18+1","v":171},172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213]
[null,null,"Construction Switch",null,null,null,null,{"$f":"H18<1","v":true},{"$f":"I18<1","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"BU18<1","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"EG18<1","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"GS18<1","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Months per Period",null,null,null,null,{"$f":"IF(H19,12/Periods_per_yr_Construction,12/Periods_per_yr_Opearion)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"IF(BT19,12/Periods_per_yr_Construction,12/Periods_per_yr_Opearion)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"IF(EF19,12/Periods_per_yr_Construction,12/Periods_per_yr_Opearion)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"IF(GR19,12/Periods_per_yr_Construction,12/Periods_per_yr_Opearion)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6]
[null,null,"Start Date"]
[null,null,"End Date ",null,null,null,null,{"$f":"G23+1","v":"2015-01-01"},{"$f":"H23+1","v":"2015-02-01"},"2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-07-01","2018-01-01","2018-07-01","2019-01-01","2019-07-01","2020-01-01","2020-07-01","2021-01-01","2021-07-01","2022-01-01","2022-07-01","2023-01-01","2023-07-01","2024-01-01","2024-07-01","2025-01-01","2025-07-01","2026-01-01","2026-07-01","2027-01-01","2027-07-01","2028-01-01","2028-07-01","2029-01-01","2029-07-01","2030-01-01","2030-07-01","2031-01-01","2031-07-01","2032-01-01","2032-07-01","2033-01-01","2033-07-01","2034-01-01","2034-07-01","2035-01-01","2035-07-01","2036-01-01","2036-07-01","2037-01-01",{"$f":"BT23+1","v":"2037-07-01"},"2038-01-01","2038-07-01","2039-01-01","2039-07-01","2040-01-01","2040-07-01","2041-01-01","2041-07-01","2042-01-01","2042-07-01","2043-01-01","2043-07-01","2044-01-01","2044-07-01","2045-01-01","2045-07-01","2046-01-01","2046-07-01","2047-01-01","2047-07-01","2048-01-01","2048-07-01","2049-01-01","2049-07-01","2050-01-01","2050-07-01","2051-01-01","2051-07-01","2052-01-01","2052-07-01","2053-01-01","2053-07-01","2054-01-01","2054-07-01","2055-01-01","2055-07-01","2056-01-01","2056-07-01","2057-01-01","2057-07-01","2058-01-01","2058-07-01","2059-01-01","2059-07-01","2060-01-01","2060-07-01","2061-01-01","2061-07-01","2062-01-01","2062-07-01","2063-01-01","2063-07-01","2064-01-01","2064-07-01","2065-01-01","2065-07-01","2066-01-01","2066-07-01","2067-01-01","2067-07-01","2068-01-01","2068-07-01","2069-01-01",{"$f":"EF23+1","v":"2069-07-01"},"2070-01-01","2070-07-01","2071-01-01","2071-07-01","2072-01-01","2072-07-01","2073-01-01","2073-07-01","2074-01-01","2074-07-01","2075-01-01","2075-07-01","2076-01-01","2076-07-01","2077-01-01","2077-07-01","2078-01-01","2078-07-01","2079-01-01","2079-07-01","2080-01-01","2080-07-01","2081-01-01","2081-07-01","2082-01-01","2082-07-01","2083-01-01","2083-07-01","2084-01-01","2084-07-01","2085-01-01","2085-07-01","2086-01-01","2086-07-01","2087-01-01","2087-07-01","2088-01-01","2088-07-01","2089-01-01","2089-07-01","2090-01-01","2090-07-01","2091-01-01","2091-07-01","2092-01-01","2092-07-01","2093-01-01","2093-07-01","2094-01-01","2094-07-01","2095-01-01","2095-07-01","2096-01-01","2096-07-01","2097-01-01","2097-07-01","2098-01-01","2098-07-01","2099-01-01","2099-07-01","2100-01-01","2100-07-01","2101-01-01",{"$f":"GR23+1","v":"2101-07-01"},"2102-01-01","2102-07-01","2103-01-01","2103-07-01","2104-01-01","2104-07-01","2105-01-01","2105-07-01","2106-01-01","2106-07-01","2107-01-01","2107-07-01","2108-01-01","2108-07-01","2109-01-01","2109-07-01","2110-01-01","2110-07-01","2111-01-01","2111-07-01","2112-01-01","2112-07-01","2113-01-01","2113-07-01","2114-01-01","2114-07-01","2115-01-01","2115-07-01","2116-01-01","2116-07-01","2117-01-01","2117-07-01","2118-01-01","2118-07-01","2119-01-01","2119-07-01","2120-01-01","2120-07-01","2121-01-01","2121-07-01","2122-01-01","2122-07-01","2123-01-01"]
[null,null,"End Year",null,null,null,{"$f":"Start_of_Construction-1","v":"2014-12-31"},{"$f":"EDATE(H22,H20)-1","v":"2015-01-31"},{"$f":"EDATE(I22,I20)-1","v":"2015-02-28"},"2015-03-31","2015-04-30","2015-05-31","2015-06-30","2015-07-31","2015-08-31","2015-09-30","2015-10-31","2015-11-30","2015-12-31","2016-01-31","2016-02-29","2016-03-31","2016-04-30","2016-05-31","2016-06-30","2016-07-31","2016-08-31","2016-09-30","2016-10-31","2016-11-30","2016-12-31","2017-06-30","2017-12-31","2018-06-30","2018-12-31","2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31","2027-06-30","2027-12-31","2028-06-30","2028-12-31","2029-06-30","2029-12-31","2030-06-30","2030-12-31","2031-06-30","2031-12-31","2032-06-30","2032-12-31","2033-06-30","2033-12-31","2034-06-30","2034-12-31","2035-06-30","2035-12-31","2036-06-30","2036-12-31","2037-06-30",{"$f":"EDATE(BU22,BU20)-1","v":"2037-12-31"},"2038-06-30","2038-12-31","2039-06-30","2039-12-31","2040-06-30","2040-12-31","2041-06-30","2041-12-31","2042-06-30","2042-12-31","2043-06-30","2043-12-31","2044-06-30","2044-12-31","2045-06-30","2045-12-31","2046-06-30","2046-12-31","2047-06-30","2047-12-31","2048-06-30","2048-12-31","2049-06-30","2049-12-31","2050-06-30","2050-12-31","2051-06-30","2051-12-31","2052-06-30","2052-12-31","2053-06-30","2053-12-31","2054-06-30","2054-12-31","2055-06-30","2055-12-31","2056-06-30","2056-12-31","2057-06-30","2057-12-31","2058-06-30","2058-12-31","2059-06-30","2059-12-31","2060-06-30","2060-12-31","2061-06-30","2061-12-31","2062-06-30","2062-12-31","2063-06-30","2063-12-31","2064-06-30","2064-12-31","2065-06-30","2065-12-31","2066-06-30","2066-12-31","2067-06-30","2067-12-31","2068-06-30","2068-12-31","2069-06-30",{"$f":"EDATE(EG22,EG20)-1","v":"2069-12-31"},"2070-06-30","2070-12-31","2071-06-30","2071-12-31","2072-06-30","2072-12-31","2073-06-30","2073-12-31","2074-06-30","2074-12-31","2075-06-30","2075-12-31","2076-06-30","2076-12-31","2077-06-30","2077-12-31","2078-06-30","2078-12-31","2079-06-30","2079-12-31","2080-06-30","2080-12-31","2081-06-30","2081-12-31","2082-06-30","2082-12-31","2083-06-30","2083-12-31","2084-06-30","2084-12-31","2085-06-30","2085-12-31","2086-06-30","2086-12-31","2087-06-30","2087-12-31","2088-06-30","2088-12-31","2089-06-30","2089-12-31","2090-06-30","2090-12-31","2091-06-30","2091-12-31","2092-06-30","2092-12-31","2093-06-30","2093-12-31","2094-06-30","2094-12-31","2095-06-30","2095-12-31","2096-06-30","2096-12-31","2097-06-30","2097-12-31","2098-06-30","2098-12-31","2099-06-30","2099-12-31","2100-06-30","2100-12-31","2101-06-30",{"$f":"EDATE(GS22,GS20)-1","v":"2101-12-31"},"2102-06-30","2102-12-31","2103-06-30","2103-12-31","2104-06-30","2104-12-31","2105-06-30","2105-12-31","2106-06-30","2106-12-31","2107-06-30","2107-12-31","2108-06-30","2108-12-31","2109-06-30","2109-12-31","2110-06-30","2110-12-31","2111-06-30","2111-12-31","2112-06-30","2112-12-31","2113-06-30","2113-12-31","2114-06-30","2114-12-31","2115-06-30","2115-12-31","2116-06-30","2116-12-31","2117-06-30","2117-12-31","2118-06-30","2118-12-31","2119-06-30","2119-12-31","2120-06-30","2120-12-31","2121-06-30","2121-12-31","2122-06-30","2122-12-31","2123-06-30"]
[null,null,"Year",null,null,null,null,{"$f":"YEAR(H23)","v":2015},{"$f":"YEAR(I23)","v":2015},2015,2015,2015,2015,2015,2015,2015,2015,2015,2015,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2017,2017,2018,2018,2019,2019,2020,2020,2021,2021,2022,2022,2023,2023,2024,2024,2025,2025,2026,2026,2027,2027,2028,2028,2029,2029,2030,2030,2031,2031,2032,2032,2033,2033,2034,2034,2035,2035,2036,2036,2037,{"$f":"YEAR(BU23)","v":2037},2038,2038,2039,2039,2040,2040,2041,2041,2042,2042,2043,2043,2044,2044,2045,2045,2046,2046,2047,2047,2048,2048,2049,2049,2050,2050,2051,2051,2052,2052,2053,2053,2054,2054,2055,2055,2056,2056,2057,2057,2058,2058,2059,2059,2060,2060,2061,2061,2062,2062,2063,2063,2064,2064,2065,2065,2066,2066,2067,2067,2068,2068,2069,{"$f":"YEAR(EG23)","v":2069},2070,2070,2071,2071,2072,2072,2073,2073,2074,2074,2075,2075,2076,2076,2077,2077,2078,2078,2079,2079,2080,2080,2081,2081,2082,2082,2083,2083,2084,2084,2085,2085,2086,2086,2087,2087,2088,2088,2089,2089,2090,2090,2091,2091,2092,2092,2093,2093,2094,2094,2095,2095,2096,2096,2097,2097,2098,2098,2099,2099,2100,2100,2101,{"$f":"YEAR(GS23)","v":2101},2102,2102,2103,2103,2104,2104,2105,2105,2106,2106,2107,2107,2108,2108,2109,2109,2110,2110,2111,2111,2112,2112,2113,2113,2114,2114,2115,2115,2116,2116,2117,2117,2118,2118,2119,2119,2120,2120,2121,2121,2122,2122,2123]
[null,null,"Days in Period",null,null,null,null,{"$f":"H23-H22+1","v":31},{"$f":"I23-I22+1","v":28},31,30,31,30,31,31,30,31,30,31,31,29,31,30,31,30,31,31,30,31,30,31,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,{"$f":"BU23-BU22+1","v":184},181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,{"$f":"EG23-EG22+1","v":184},181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,181,184,181,{"$f":"GS23-GS22+1","v":184},181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181,184,182,184,181,184,181,184,181]
[null,null,"Operation Switch",null,{"$f":"D7","v":"2017-01-01"},{"$f":"D14","v":"2045-01-01"},{"$f":"COUNTIF(H26:IJ26,TRUE)","v":56},{"$f":"AND(H22>=$E$26,H22<$F$26)","v":false},{"$f":"AND(I22>=$E$26,I22<$F$26)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,{"$f":"AND(BU22>=$E$26,BU22<$F$26)","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"AND(EG22>=$E$26,EG22<$F$26)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"AND(GS22>=$E$26,GS22<$F$26)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Cash Flow"]
[null,null,"Construction Expenditures","Cost",{"$f":"EPC_Cost","v":125000},{"$f":"E18","v":24},null,{"$f":"$E$29/$F$29*H19","v":5208.333333333333},{"$f":"$E$29/$F$29*I19","v":5208.333333333333},5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,5208.333333333333,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,{"$f":"$E$29/$F$29*BU19","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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$E$29/$F$29*EG19","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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$E$29/$F$29*GS19","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,0,0,0]
[null,null,"Operating Cash Flow","Per Cash",{"$f":"Annual_Cash_Flow/Periods_per_yr_Opearion","v":20000},null,null,{"$f":"$E$30*H26","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,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,{"$f":"$E$30*BT26","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,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,0,0,0,0,0,0,0,0,{"$f":"$E$30*EF26","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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$E$30*GR26","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,0,0,0,0]
[null,null,"Net Cash Flow",null,null,null,null,{"$f":"H30-H29","v":-5208.333333333333},-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,-5208.333333333333,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,{"$f":"BT30-BT29","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,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,0,0,0,0,0,0,0,0,{"$f":"EF30-EF29","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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"GR30-GR29","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,0,0,0,0]
[]
[null,null,"IRR on Net Cash Flow",null,null,null,{"$f":"XIRR(H31:IJ31,H23:IJ23)","v":0.26784588694572464}]

{"sheet":"Annual Exercise","index":3,"n_rows":8,"n_cols":39,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,{"$f":"YEAR(Start_of_Construction)","v":2015},{"$f":"E3+1","v":2016},{"$f":"F3+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,{"$f":"AI3+1","v":2046},2047,2048,2049]
[null,null,null,"Construction Exp"]
[null,null,null,"Operating Cash Flow"]
[null,null,null,"Net Cash Flow"]
[]
[null,null,null,"Project IRR"]

{"sheet":"Settings","index":4,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Periods/yr","Days 360"]
[]
[null,null,null,"Monthly",12,{"$f":"12/E4*30","v":30}]
[null,null,null,"Quarterly",4,{"$f":"12/E5*30","v":90}]
[null,null,null,"Semi-Annual",2,{"$f":"12/E6*30","v":180}]
[null,null,null,"Annual",1,{"$f":"12/E7*30","v":360}]

{"sheet":"Advertising","index":5,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"High Quality Modelling, Finance and Energy Courses"]
[]
[null,null,"This page is my advertising and publicity - You can of course delete the page without affecting the model"]
[]
[null,null,"I have taught classes for many years and I believe I have learned from my mistakes and can offer high quality courses"]
[]
[null,null,"Here is my simple concept"]
[null,null,null,"1. Deliver the courses at a reasonable price -- I will do quite well if a lot of people attend and I will survive if course numbers are low"]
[null,null,null,null,"USD 1,000 -2,000 for courses in Europe"]
[null,null,null,null,"USD 750 - 1,500 for courses in Africa and Latin America"]
[null,null,null,"2. Do not cancel the classes as long as one student has signed up (I take the risk of low numbers and not you)"]
[null,null,null,"3. Limit the size of the classes to 25 participants"]
[null,null,null,"4. Lunches are offered by not with a four course elaborate menu -- we assume that you are attending the course to learn and not to have a fancy lunch"]
[]
[null,null,"Download Outlines at",null,null,null,null,null,"www.FinanceEnergyInstitute.com"]
[null,null,"Check for upcomming dates",null,null,null,null,null,"www.FinanceEnergyInstitute.com"]
[]
[null,null,"Customised In-Company Courses"]
[]
[null,null,"I also offer courses tailored for single institutions (or combinations of institutions) "]
[null,null,"Depending on various considerations my rate is USD 1,500 to USD 2,000 per day plus expenses"]
[]
[null,null,"Contact Details"]
[null,null,null,"E-mail",null,null,null,null,"edwardbodmer@gmail.com"]
[null,null,null,"Phone",null,null,null,null,"001-630-886-2754"]
[]
[null,null,null,"Skype",null,null,null,null,"edward.bodmer"]
[null,null,null,"Link to Book"]