{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["General overview","Instructions and Legend","Mini Grid Developer view","Ice Making Facility Owner view","NS Edits"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"General overview","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,1,6,10],[0,0,0,10],[1,0,1,10],[7,1,7,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10]]}
["Ice Making for Fish Preservation as a Productive Use activity"]
["General Guidance"]
[1,"The workbook aims to assist developers of Solar PV based mini-grids (the \"Mini Grid Developer\") and owners of the productive use enterprise such as aquaculture companies, CBOs, entrepreneurs or mini-grid developers (the \"Ice Making Facility owner\") in determining the financial feasibility of ice-making for fish preservation as a productive use activity "]
[2,"The Workbook is split into two 'views'/tabs"]
["2a","The 'Mini Grid Developer view' allows for the calculations associated with upgrading a mini-grid system to accommodate an ice making plant. It computes key financial metrics that can assist the Developer in assessing the impact of integrating an ice-making plant on the mini-grid economics for a specific site. The worksheet has two default scenarios. 'Base Case' is the base case of the mini-grid system without the ice-making plant. 'Upgrade Case Scenario' is the upgrade case that includes the ice-making plant "]
["2b","The 'Ice Making Facility owner view' allows for the calculations associated with installing a new ice making plant or converting an existing ice making plant to be compatible with a mini-grid. It allows the Ice Making Facility owner to perform a detailed financial analysis of an ice-making enterprise through cash flow modeling and computation of key financial metrics. The worksheet has two default scenarios. The 'Conversion Scenario' refers to the case where the Enterprise Owner owns/operates an ice-making plant already and is looking to either convert it from diesel to electric or transport it to the mini-grid site from another location. The 'New Enterprise Scenario' refers to the case where an Ice Making Facility owner intends to build and operate a new ice-making plant at the mini-grid site "]
[4,"Assumptions, Calculations and Outputs are presented on the same tabs "]
[5,"Please read the 'Instructions and Legend' tab before completing the workbook"]
[]
["Mini Grid Developer view tab",null,null,null,"Ice Making Facility Owner view tab "]
["Structure",null,null,null,"Structure"]
["1. LCOE Analysis",null,null,null,"1. Key Investment Metrics"]
["2. Key Investment Metrics",null,null,null,"2. NPV sensitivity analysis"]
["3. Cash Flow Analysis",{"$nulls":4},"2.1 Conversion Scenario "]
["4. Assumptions and Calculations",{"$nulls":4},"2.2 New Enterprise Scenario "]
[null,"4.1 CAPEX",null,null,"3. Cash Flow Analysis"]
[null,"4.2 Operating Expenditure",null,null,null,"3.1 Conversion Scenario "]
[null,"4.3 Energy Production",null,null,null,"3.2 New Enterprise Scenario "]
[{"$nulls":4},"4. Assumptions and calculations"]
[{"$nulls":5},"4.1. Ice Sales"]
[{"$nulls":5},"4.2 Energy Consumption & Ice Production"]
[{"$nulls":6},"4.2.1 Conversion Scenario "]
[{"$nulls":6},"4.2.2 New Enterprise Scenario "]
[{"$nulls":5},"4.3. Operations and Maintenance"]
[{"$nulls":5},"4.4. Depreciation"]
[{"$nulls":5},"4.5 Interest and Principal Loan Repayments"]

{"sheet":"Instructions and Legend","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[8,0,8,14],[14,0,14,14],[16,0,16,14],[23,0,23,14],[0,0,0,14],[2,0,2,14]]}
["Mini Grid Developer View Tab"]
[]
["Instructions"]
[]
[1,"Please refer to the legend below for information on which cells to fill out in the model "]
[{"$f":"A5+1","v":2},"Units of measurement are set to default in the analysis. The formulas are coded based on the assumption that all values are entered in the default units "]
[{"$f":"A6+1","v":3},"Input values in all grey highlighted cells. All other calculations and output values in the worksheet will populate automatically.  If certain categories do not apply, leave the cell blank "]
[]
["Legend"]
["Black Text ",null,null,"This is an output cell. Cell includes formula and should not be edited "]
["Blue Highlighted Text ",null,null,"This is an input cell. Cell is hard coded and can be edited "]
["Base Case Scenario ",null,null,"Mini-Grid system without ice making plant"]
["Upgrade Case Scenario  ",null,null,"Mini-Grid system with ice making plant"]
[]
["Ice Making Facility Owner View Tab"]
[]
["Instructions"]
[]
[1,"Please refer to the legend below for information on which cells to fill out in the model."]
[{"$f":"A19+1","v":2},"Units of measurement are set to default in the analysis. The formulas are coded based on the assumption that all values are entered in the default units "]
[{"$f":"A20+1","v":3},"Input values in all grey highlighted cells. All other calculations and output values in the worksheet will populate automatically.  If certain categories do not apply, leave the cell blank "]
[4,"Please note that both revenues and expenses should be positive (expenses will be deducted as part of built in formulas)"]
[]
["Legend"]
["Black Text ",null,null,"This is an output cell. Cell includes formula and should not be edited "]
["Blue Highlighted Text ",null,null,"This is an input cell. Cell is hard coded and can be edited "]
["Conversion Scenario",null,null,"Existing ice-making plant to be re-located and / or converted to be compatible with mini-grid system"]
["New Enterprise Scenario ",null,null,"New ice-making plant to be installed and integrated to Mini-Grid system"]

{"sheet":"Mini Grid Developer view","index":2,"n_rows":122,"n_cols":13,"rows_kept":122,"cut":false,"hidden":false,"merged":[[47,12,47,21],[63,12,63,21],[97,12,97,21],[98,12,98,21],[19,12,19,21],[11,12,11,21],[13,12,13,21],[21,12,21,21],[8,12,8,21],[7,12,7,21]]}
["Mini Grid Developer View"]
[]
["1. LCOE Analysis",{"$nulls":11},"User Reference"]
[null,"Units ",null,"Base Case",null,null,null,"Upgrade Case "]
["CAPEX ","$",null,{"$f":"D98*D62*1000","v":0},null,null,null,{"$f":"H98*H62*1000","v":0}]
["Present Value of Operating Expense","$",null,{"$f":"NPV(D12,D75:D94)","v":0},null,null,null,{"$f":"NPV(H12,H75:H94)","v":0}]
["Total Energy Production ","kWhs",null,{"$f":"SUM(D103:D122)","v":0},null,null,null,{"$f":"SUM(H103:H122)","v":0}]
["LCOE ","$/kWh",null,{"$f":"(SUM(D5:D6)/D7)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"(SUM(H5:H6)/H7)","v":{"$error":"#DIV/0!"}},{"$nulls":4},"LCOE\" is the levelized cost of energy and is a proxy measure that captures the overall economic impact of the ice-making plant on the mini-grid system. If the LCOE decreases from the Base Case to Upgrade Case Scenario, then the developer should proceed with connecting the ice-making plant to the mini-grid system. A decreasing LCOE is an indication of the positive marginal benefit of adding an ice-making plant to the economics of the mini-grid system"]
["Profit Margin ","%",{"$nulls":10},"Profit margin should be selected based on the following considerations (i) approval of resulting tariff by ERC (ii) desired Equity IRR. Changing this input has direct impact on the equity IRR as the Tariff is used to calculated cash flows available to equity investors. "]
["Tariff ","$/kWh",null,{"$f":"D8*(1+D9)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"H8*(1+H9)","v":{"$error":"#DIV/0!"}}]
[]
["Discount Rate","%",{"$nulls":10},"For calculating the present value of operating expense in the LCOE calculation. Discount Rate can be based on the developer's cost of equity financing"]
[]
["2. Key Investment Metrics"]
[null,"Units ",null,{"$f":"D4","v":"Base Case"},null,null,null,{"$f":"H4","v":"Upgrade Case "}]
["Equity IRR ","%",null,{"$f":"IRR(D24:D44)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IRR(H24:H44)","v":{"$error":"#VALUE!"}}]
["Payback Period ","Years",null,{"$f":"D18+D19","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"H18+H19","v":{"$error":"#DIV/0!"}}]
["Years",null,null,{"$f":"COUNTIF(E24:E44, \"<0\")","v":0},null,null,null,{"$f":"COUNTIF(I24:I44, \"<0\")","v":0}]
["Fraction",null,null,{"$f":"INDEX(F24:F44,COUNTIF(E24:E44,\"<0\")+1)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"INDEX(J24:J44,COUNTIF(I24:I44,\"<0\")+1)","v":{"$error":"#DIV/0!"}}]
["Grant Financing ","%",{"$nulls":10},"Portion of capital structure that is financed by grants or similar incentives intended to subsidize the CAPEX of the mini-grid system "]
[]
["3.  Cash Flow Analysis",{"$nulls":11},"Cash flow projection is developed for the purpose of calculating IRR. Cash flows are calculated as follows: (Tariff x Energy Production) - (Operating Expense) - (CAPEX) "]
["Projected Cash Flows for IRR Calculation ",null,null,{"$f":"D15","v":"Base Case"},"Cumulative CF","Faction calc",null,{"$f":"H15","v":"Upgrade Case "},"Cumulative CF","Faction calc"]
[0,"$",null,{"$f":"-D5*(1-D20)","v":0},{"$f":"SUM($D$24:D24)","v":0},{"$f":"IF(E24<0, \"n/m\", ABS(E24/D25))","v":{"$error":"#DIV/0!"}},null,{"$f":"-H5*(1-H20)","v":0},{"$f":"SUM($G$24:H24)","v":0},{"$f":"IF(I24<0, \"n/m\", ABS(I24/I25))","v":{"$error":"#DIV/0!"}}]
[1,"$",null,{"$f":"(D$10*D103)-D75","v":{"$error":"#DIV/0!"}},{"$f":"SUM($D$24:D25)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E25<0, \"n/m\", ABS(E25/D26))","v":{"$error":"#DIV/0!"}},null,{"$f":"(H$10*H103)-H75","v":{"$error":"#DIV/0!"}},{"$f":"SUM($G$24:H25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[2,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D26)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H26)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[3,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[4,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D28)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H28)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[5,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D29)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H29)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[6,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D30)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H30)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[7,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[8,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D32)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H32)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[9,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[10,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[11,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[12,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[13,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D37)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H37)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[14,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[15,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D39)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H39)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[16,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D40)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H40)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[17,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[18,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D42)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H42)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[19,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D43)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H43)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[20,"$",null,{"$error":"#DIV/0!"},{"$f":"SUM($D$24:D44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"SUM($G$24:H44)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I44<0, \"n/m\", ABS(I44/J45))","v":{"$error":"#DIV/0!"}}]
[]
["5. Assumptions and calculations"]
[]
["5.1  CAPEX",{"$nulls":11},"The default template includes the most commonly used categorizations. The user can add or consolidate categories based on the specific needs."]
[null,"Units ",null,{"$f":"D23","v":"Base Case"},null,null,null,{"$f":"H23","v":"Upgrade Case "}]
["Solar PV Material","$/Wdc "]
["Solar PV Labor","$/Wdc "]
["Energy Storage Material","$/Wdc "]
["Energy Storage Labor","$/Wdc "]
["Generator Material","$/Wdc "]
["Generator Labor","$/Wdc "]
["Distribution Material and Labor","$/Wdc "]
["Design & Engineering","$/Wdc "]
["Surveys and Studies","$/Wdc "]
["Direct Job Costs","$/Wdc "]
["Contingency","$/Wdc "]
["Installer Margin","$/Wdc "]
["Total Construction Cost ","$/Wdc ",null,{"$f":"SUM(D50:D61)","v":0},null,null,null,{"$f":"SUM(H50:H61)","v":0}]
[]
["5.2 Operating Expense ",{"$nulls":11},"The default template includes the most commonly used categorizations. User can add or consolidate categories based on the specific needs."]
[null,"Units ",null,{"$f":"D49","v":"Base Case"},null,null,null,{"$f":"H49","v":"Upgrade Case "}]
["O&M - Solar PV","$/Wdc "]
["O&M - Storage System","$/Wdc "]
["O&M - Diesel Generator","$/Wdc "]
["Diesel Generator - Fuel Cost","$/Wdc "]
["Sales, General & Administrative including Billing (SG&A)","$/Wdc "]
["Insurance","% "]
["OPEX escalation per year","%"]
[]
["Projected  Annual OPEX ",null,null,{"$f":"D65","v":"Base Case"},null,null,null,{"$f":"H65","v":"Upgrade Case "}]
[1,"$",null,{"$f":"SUM((SUM($D$66:$D$70)*$D$98)*1000,($D$71*$D$5))*(1+($D$72))^$A75","v":0},null,null,null,{"$f":"SUM((SUM($H$66:$H$70)*$H$98)*1000,($H$71*$H$5))*(1+($H$72))^$A75","v":0}]
[2,"$",null,0,null,null,null,0]
[3,"$",null,0,null,null,null,0]
[4,"$",null,0,null,null,null,0]
[5,"$",null,0,null,null,null,0]
[6,"$",null,0,null,null,null,0]
[7,"$",null,0,null,null,null,0]
[8,"$",null,0,null,null,null,0]
[9,"$",null,0,null,null,null,0]
[10,"$",null,0,null,null,null,0]
[11,"$",null,0,null,null,null,0]
[12,"$",null,0,null,null,null,0]
[13,"$",null,0,null,null,null,0]
[14,"$",null,0,null,null,null,0]
[15,"$",null,0,null,null,null,0]
[16,"$",null,0,null,null,null,0]
[17,"$",null,0,null,null,null,0]
[18,"$",null,0,null,null,null,0]
[19,"$",null,0,null,null,null,0]
[20,"$",null,0,null,null,null,0]
[]
["5.3 Energy Production "]
["Assumption","Units",null,{"$f":"D74","v":"Base Case"},null,null,null,{"$f":"H74","v":"Upgrade Case "}]
["System Size, Designed","kWdc",{"$nulls":10},"Input should be based on result of developer's internal production modeling. The developer should ensure that the sizing of the system is consistent with the specifications and energy consumption profile of the ice-making plant as shown in the 'Enterprise Owner view' worksheet. "]
["Annual Production (Adjusted for Losses)","kWh",{"$nulls":10},"Input should be based on result of developer's internal production modeling. The developer should ensure that the sizing of the system is consistent with the specifications and energy consumption profile of the ice-making plant as shown in the 'Enterprise Owner view' worksheet. "]
["Annual PV Degradation ","%",{"$nulls":10},"Annual degradation in the production capacity of the solar PV panels"]
[]
["Projected Annual Production ",null,null,{"$f":"D97","v":"Base Case"},null,null,null,{"$f":"H97","v":"Upgrade Case "}]
[1,"kWh",null,{"$f":"D99","v":0},null,null,null,{"$f":"H99","v":0}]
[2,"kWh",null,{"$f":"$D$103*(1-$D$100)^(A104-$A$103)","v":0},null,null,null,{"$f":"$H$103*(1-$H$100)^(A104-$A$103)","v":0}]
[3,"kWh",null,0,null,null,null,0]
[4,"kWh",null,0,null,null,null,0]
[5,"kWh",null,0,null,null,null,0]
[6,"kWh",null,0,null,null,null,0]
[7,"kWh",null,0,null,null,null,0]
[8,"kWh",null,0,null,null,null,0]
[9,"kWh",null,0,null,null,null,0]
[10,"kWh",null,0,null,null,null,0]
[11,"kWh",null,0,null,null,null,0]
[12,"kWh",null,0,null,null,null,0]
[13,"kWh",null,0,null,null,null,0]
[14,"kWh",null,0,null,null,null,0]
[15,"kWh",null,0,null,null,null,0]
[16,"kWh",null,0,null,null,null,0]
[17,"kWh",null,0,null,null,null,0]
[18,"kWh",null,0,null,null,null,0]
[19,"kWh",null,0,null,null,null,0]
[20,"kWh",null,0,null,null,null,0]

{"sheet":"Ice Making Facility Owner view","index":3,"n_rows":265,"n_cols":15,"rows_kept":265,"cut":false,"hidden":false,"merged":[[227,14,227,23],[229,14,229,23],[245,14,245,23],[247,14,247,23],[207,14,207,23],[208,14,208,23],[223,14,223,23],[225,14,225,23],[226,14,226,23],[163,14,163,23],[169,14,169,23],[171,14,171,23],[173,14,173,23],[203,14,203,23],[128,14,128,23],[153,14,153,23],[154,14,154,23],[161,14,161,23],[130,14,130,23],[134,14,134,23],[135,14,135,23],[136,14,136,23],[132,14,132,23],[133,14,133,23],[12,14,12,23],[13,14,13,23],[14,14,14,23],[16,14,16,23],[65,14,65,23],[27,2,27,7],[174,10,174,11],[189,10,189,11],[252,7,252,11],[47,2,47,7],[49,0,59,0],[189,8,189,9],[174,8,174,9],[29,0,43,0],[252,2,252,6],[231,5,231,7],[174,2,174,3],[174,4,174,5],[174,6,174,7],[231,2,231,4],[189,2,189,3],[189,4,189,5],[189,6,189,7]]}
["Ice Making Facility Owner view "]
[]
["1. Key Investment Metrics",{"$nulls":13},"User Reference"]
[null,"Units ","Conversion","New Enterprise"]
["Total Investment","$",{"$f":"C229","v":0},{"$f":"D229","v":0}]
["IRR ","%","N/A",{"$f":"IRR(B125:K125)","v":{"$error":"#VALUE!"}}]
["10 year NPV","$",{"$f":"NPV(C13, B95:K95)","v":{"$error":"#DIV/0!"}},{"$f":"NPV(D13, B125:K125)","v":{"$error":"#DIV/0!"}}]
["Payback period","Years",{"$f":"IF(C9=0,\"<0\",C9+C10)","v":"<0"},{"$f":"D9+D10","v":0}]
["Years",null,{"$f":"COUNTIF(B96:K96, \"<0\")","v":0},{"$f":"COUNTIF(B126:K126, \"<0\")","v":0}]
["Months (expressed as decimal)",null,{"$f":"INDEX(B97:K97,COUNTIF(B96:K96,\"<0\")+1)","v":0},{"$f":"INDEX(B127:K127,COUNTIF(B126:K126,\"<0\")+1)","v":0}]
[]
["Assumptions ","`"]
["Discount rate","%",{"$nulls":12},"Discount rate is an input for the NPV calculation. It should be based on the cost of capital for the Enterprise Owner. The interest rate on debt financing can be used as a proxy for cost of capital. In which case, the discount rate can be set to equal the interest rate in cell C242"]
["Tax rate","%",{"$nulls":12},"Tax rate should be consistent with local regulations "]
["Remaining Useful Life","Years",{"$nulls":12},"Input the remaining years of operation for the Ice Making Plant as at the time of calculation. Note than any Remaining Useful Life of less than 10 years will result in the cessation of all cash flows (apart from those related to Debt) as it is assumed that the Machine is no longer productive (and is not replaced)"]
[]
["2. NPV sensitivity analysis",{"$nulls":13},"Sensitivity analysis is designed to show the impact of Net Present Value (NPV) based on changes to the assumed values for key variables. In this case the key variables are set to be 'Ice Price' and the 'Energy Tariff'. Enterprise Owners should use this analysis to assess the level of risk in case of fluctuations in key variables "]
[]
["Legend"]
[null,"<$0"]
[null,"$0.001k-50k"]
[null,"$50.001k-$100k"]
[null,"$100.001k-150k"]
[null,"$150k+"]
[]
["2.1 Conversion Scenario "]
[]
[null,null,"Ice Price ($USD/kg)"]
[null,{"$f":"C7","v":{"$error":"#DIV/0!"}},0.08,0.1,0.12,0.14000000000000001,0.16,0.18]
["Tariff ($/kWh)",0.3,0,0,0,0,0,0]
[null,0.4,0,0,0,0,0,0]
[null,0.5,0,0,0,0,0,0]
[null,0.6,0,0,0,0,0,0]
[null,0.7,0,0,0,0,0,0]
[null,0.8,0,0,0,0,0,0]
[null,0.9,0,0,0,0,0,0]
[null,1,0,0,0,0,0,0]
[null,1.1000000000000001,0,0,0,0,0,0]
[null,1.2,0,0,0,0,0,0]
[null,1.3,0,0,0,0,0,0]
[null,1.4,0,0,0,0,0,0]
[null,1.5,0,0,0,0,0,0]
[null,1.6,0,0,0,0,0,0]
[null,1.7,0,0,0,0,0,0]
[]
["2.2 New Enterprise Scenario "]
[]
[null,null,"Ice Price ($USD/kg)"]
[null,{"$f":"D7","v":{"$error":"#DIV/0!"}},0.08,0.1,0.12,0.14000000000000001,0.16,0.18]
["Tariff ($/kWh)",0.3,0,0,0,0,0,0]
[null,0.4,0,0,0,0,0,0]
[null,0.5,0,0,0,0,0,0]
[null,0.6,0,0,0,0,0,0]
[null,0.7,0,0,0,0,0,0]
[null,0.8,0,0,0,0,0,0]
[null,0.9,0,0,0,0,0,0]
[null,1,0,0,0,0,0,0]
[null,1.1000000000000001,0,0,0,0,0,0]
[null,1.2,0,0,0,0,0,0]
[null,1.3,0,0,0,0,0,0]
[null,1.4,0,0,0,0,0,0]
[null,1.5,0,0,0,0,0,0]
[null,1.6,0,0,0,0,0,0]
[null,1.7,0,0,0,0,0,0]
[]
["3. Cash Flow Analysis ",{"$nulls":13},"Cash flow projection is developed for the purpose of calculating key investment metrics (IRR, NPV and Payback Period) and sensitivity analysis"]
[]
["3.1 Conversion Scenario ",1,2,3,4,5,6,7,8,9,10,"Total"]
["REVENUE"]
["Ice sales",{"$f":"'Ice Making Facility Owner view'!C140","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C141","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C142","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C143","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C144","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C145","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C146","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C147","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C148","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!C149","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B70:K70)","v":{"$error":"#DIV/0!"}}]
["Total Revenue",{"$f":"B70","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!"},{"$f":"SUM(B71:K71)","v":{"$error":"#DIV/0!"}}]
[]
["OPEX"]
["Energy consumption",{"$f":"'Ice Making Facility Owner view'!L177","v":0},{"$f":"'Ice Making Facility Owner view'!L178","v":0},{"$f":"'Ice Making Facility Owner view'!L179","v":0},{"$f":"'Ice Making Facility Owner view'!L180","v":0},{"$f":"'Ice Making Facility Owner view'!L181","v":0},{"$f":"'Ice Making Facility Owner view'!L182","v":0},{"$f":"'Ice Making Facility Owner view'!L183","v":0},{"$f":"'Ice Making Facility Owner view'!L184","v":0},{"$f":"'Ice Making Facility Owner view'!L185","v":0},{"$f":"'Ice Making Facility Owner view'!L186","v":0},{"$f":"SUM(B74:K74)","v":0}]
["Operations and maintainance",{"$f":"'Ice Making Facility Owner view'!C212","v":0},{"$f":"'Ice Making Facility Owner view'!C213","v":0},{"$f":"'Ice Making Facility Owner view'!C214","v":0},{"$f":"'Ice Making Facility Owner view'!C215","v":0},{"$f":"'Ice Making Facility Owner view'!C216","v":0},{"$f":"'Ice Making Facility Owner view'!C217","v":0},{"$f":"'Ice Making Facility Owner view'!C218","v":0},{"$f":"'Ice Making Facility Owner view'!C219","v":0},{"$f":"'Ice Making Facility Owner view'!C220","v":0},{"$f":"'Ice Making Facility Owner view'!C221","v":0},{"$f":"SUM(B75:K75)","v":0}]
["Total OPEX",{"$f":"SUM(B74:B75)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B76:K76)","v":0}]
[]
["EBITDA",{"$f":"B71-B76","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!"},{"$f":"SUM(B78:K78)","v":{"$error":"#DIV/0!"}}]
["EBITDA %",{"$f":"IFERROR(B78/B71, \"\")","v":""},"","","","","","","","",""]
[]
["Depreciation",{"$f":"'Ice Making Facility Owner view'!D234","v":0},{"$f":"'Ice Making Facility Owner view'!D235","v":0},{"$f":"'Ice Making Facility Owner view'!D236","v":0},{"$f":"'Ice Making Facility Owner view'!D237","v":0},{"$f":"'Ice Making Facility Owner view'!D238","v":0},{"$f":"'Ice Making Facility Owner view'!D239","v":0},{"$f":"'Ice Making Facility Owner view'!D240","v":0},{"$f":"'Ice Making Facility Owner view'!D241","v":0},{"$f":"'Ice Making Facility Owner view'!D242","v":0},{"$f":"'Ice Making Facility Owner view'!D243","v":0},{"$f":"SUM(B81:K81)","v":0}]
["Interest repayments",{"$f":"'Ice Making Facility Owner view'!G255","v":0},{"$f":"'Ice Making Facility Owner view'!G256","v":0},{"$f":"'Ice Making Facility Owner view'!G257","v":0},{"$f":"'Ice Making Facility Owner view'!G258","v":0},{"$f":"'Ice Making Facility Owner view'!G259","v":0},{"$f":"'Ice Making Facility Owner view'!G260","v":0},{"$f":"'Ice Making Facility Owner view'!G261","v":0},{"$f":"'Ice Making Facility Owner view'!G262","v":0},{"$f":"'Ice Making Facility Owner view'!G263","v":0},{"$f":"'Ice Making Facility Owner view'!G264","v":0},{"$f":"SUM(B82:K82)","v":0}]
[]
["EBIT",{"$f":"B78-B81-B82","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!"},{"$f":"SUM(B84:K84)","v":{"$error":"#DIV/0!"}}]
["EBIT %",{"$f":"IFERROR(B84/B71, \"\")","v":""},"","","","","","","","",""]
[]
["Tax",{"$f":"IF(B84<=0,0,(B84*$C$14))","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!"},{"$f":"SUM(B87:K87)","v":{"$error":"#DIV/0!"}}]
["AFTER TAX INCOME",{"$f":"B84-B87","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!"},{"$f":"SUM(B88:K88)","v":{"$error":"#DIV/0!"}}]
["Depreciation (+)",{"$f":"B81","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B89:K89)","v":0}]
[]
["CAPEX - Upfront Deposit ",{"$f":"C248","v":0},{"$nulls":9},{"$f":"SUM(B91:K91)","v":0}]
["Total CAPEX",{"$f":"SUM(B91:B91)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B92:K92)","v":0}]
[]
["Principal loan repayments",{"$f":"'Ice Making Facility Owner view'!F255","v":0},{"$f":"'Ice Making Facility Owner view'!F256","v":0},{"$f":"'Ice Making Facility Owner view'!F257","v":0},{"$f":"'Ice Making Facility Owner view'!F258","v":0},{"$f":"'Ice Making Facility Owner view'!F259","v":0},{"$f":"'Ice Making Facility Owner view'!F260","v":0},{"$f":"'Ice Making Facility Owner view'!F261","v":0},{"$f":"'Ice Making Facility Owner view'!F262","v":0},{"$f":"'Ice Making Facility Owner view'!F263","v":0},{"$f":"'Ice Making Facility Owner view'!F264","v":0},{"$f":"SUM(B94:K94)","v":0}]
["NET CASH FLOW",{"$f":"B88+B89-B92-B94","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!"},{"$f":"SUM(B95:K95)","v":{"$error":"#DIV/0!"}}]
["Cumulative cash flow",{"$f":"SUM(B95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:C95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:D95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:E95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:F95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:G95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:H95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:I95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:J95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$95:K95)","v":{"$error":"#DIV/0!"}}]
["Fraction calculations",null,{"$f":"IF(C96<0,\"n/m\",ABS(B96/C95))","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(IF(D96<0,\"n/m\",ABS(C96/D95)),\"\")","v":""},{"$f":"IFERROR(IF(E96<0,\"n/m\",ABS(D96/E95)),\"\")","v":""},"","","","","",""]
[]
["3.2 New Enterprise Scenario",1,2,3,4,5,6,7,8,9,10,"Total"]
["REVENUE"]
["Ice sales",{"$f":"'Ice Making Facility Owner view'!D140","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D141","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D142","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D143","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D144","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D145","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D146","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D147","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D148","v":{"$error":"#DIV/0!"}},{"$f":"'Ice Making Facility Owner view'!D149","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B101:K101)","v":{"$error":"#DIV/0!"}}]
["Total Revenue",{"$f":"B101","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!"},{"$error":"#DIV/0!"}]
[]
["OPEX"]
["Energy consumption",{"$f":"'Ice Making Facility Owner view'!L192","v":0},{"$f":"'Ice Making Facility Owner view'!L193","v":0},{"$f":"'Ice Making Facility Owner view'!L194","v":0},{"$f":"'Ice Making Facility Owner view'!L195","v":0},{"$f":"'Ice Making Facility Owner view'!L196","v":0},{"$f":"'Ice Making Facility Owner view'!L197","v":0},{"$f":"'Ice Making Facility Owner view'!L198","v":0},{"$f":"'Ice Making Facility Owner view'!L199","v":0},{"$f":"'Ice Making Facility Owner view'!L200","v":0},{"$f":"'Ice Making Facility Owner view'!L201","v":0},{"$f":"SUM(B105:K105)","v":0}]
["Operations and maintainnance",{"$f":"'Ice Making Facility Owner view'!D212","v":0},{"$f":"'Ice Making Facility Owner view'!D213","v":0},{"$f":"'Ice Making Facility Owner view'!D214","v":0},{"$f":"'Ice Making Facility Owner view'!D215","v":0},{"$f":"'Ice Making Facility Owner view'!D216","v":0},{"$f":"'Ice Making Facility Owner view'!D217","v":0},{"$f":"'Ice Making Facility Owner view'!D218","v":0},{"$f":"'Ice Making Facility Owner view'!D219","v":0},{"$f":"'Ice Making Facility Owner view'!D220","v":0},{"$f":"'Ice Making Facility Owner view'!D221","v":0},{"$f":"SUM(B106:K106)","v":0}]
["Total OPEX",{"$f":"SUM(B105:B106)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B107:K107)","v":0}]
[]
["EBITDA",{"$f":"B102-B107","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!"},{"$f":"SUM(B109:K109)","v":{"$error":"#DIV/0!"}}]
["EBITDA %",{"$f":"IFERROR(B109/B102, \"\")","v":""},"","","","","","","","",""]
[]
["Depreciation",{"$f":"'Ice Making Facility Owner view'!G234","v":0},{"$f":"'Ice Making Facility Owner view'!G235","v":0},{"$f":"'Ice Making Facility Owner view'!G236","v":0},{"$f":"'Ice Making Facility Owner view'!G237","v":0},{"$f":"'Ice Making Facility Owner view'!G238","v":0},{"$f":"'Ice Making Facility Owner view'!G239","v":0},{"$f":"'Ice Making Facility Owner view'!G240","v":0},{"$f":"'Ice Making Facility Owner view'!G241","v":0},{"$f":"'Ice Making Facility Owner view'!G242","v":0},{"$f":"'Ice Making Facility Owner view'!G243","v":0},{"$f":"SUM(B112:K112)","v":0}]
["Interest repayments",{"$f":"'Ice Making Facility Owner view'!L255*0.75","v":0},{"$f":"'Ice Making Facility Owner view'!L256","v":0},{"$f":"'Ice Making Facility Owner view'!L257","v":0},{"$f":"'Ice Making Facility Owner view'!L258","v":0},{"$f":"'Ice Making Facility Owner view'!L259","v":0},{"$f":"'Ice Making Facility Owner view'!L260","v":0},{"$f":"'Ice Making Facility Owner view'!L261","v":0},{"$f":"'Ice Making Facility Owner view'!L262","v":0},{"$f":"'Ice Making Facility Owner view'!L263","v":0},{"$f":"'Ice Making Facility Owner view'!L264","v":0},{"$f":"SUM(B113:K113)","v":0}]
["EBIT",{"$f":"B109-B112-B113","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!"},{"$f":"SUM(B114:K114)","v":{"$error":"#DIV/0!"}}]
["EBIT %",{"$f":"IFERROR(B114/B102, \"\")","v":""},"","","","","","","","",""]
[]
["Tax",{"$f":"IF(B114<=0, 0, B114*$D$14)","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!"},{"$f":"SUM(B117:K117)","v":{"$error":"#DIV/0!"}}]
["AFTER TAX INCOME",{"$f":"B114-B117","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!"},{"$f":"SUM(B118:K118)","v":{"$error":"#DIV/0!"}}]
["Depreciation (+)",{"$f":"B112","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B119:K119)","v":0}]
[]
["CAPEX - Upfront Deposit ",{"$f":"D248","v":0},{"$nulls":9},{"$f":"SUM(B121:K121)","v":0}]
["Total CAPEX",{"$f":"B121","v":0},{"$f":"C121","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(B122:K122)","v":0}]
[]
["Principal loan repayments",{"$f":"'Ice Making Facility Owner view'!K255","v":0},{"$f":"'Ice Making Facility Owner view'!K256","v":0},{"$f":"'Ice Making Facility Owner view'!K257","v":0},{"$f":"'Ice Making Facility Owner view'!K258","v":0},{"$f":"'Ice Making Facility Owner view'!K259","v":0},{"$f":"'Ice Making Facility Owner view'!K260","v":0},{"$f":"'Ice Making Facility Owner view'!K261","v":0},{"$f":"'Ice Making Facility Owner view'!K262","v":0},{"$f":"'Ice Making Facility Owner view'!K263","v":0},{"$f":"'Ice Making Facility Owner view'!K264","v":0},{"$f":"SUM(B124:K124)","v":0}]
["NET CASH FLOW",{"$f":"B118+B119-B122-B124","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!"},{"$f":"SUM(B125:K125)","v":{"$error":"#DIV/0!"}}]
["Cumulative cash flow",{"$f":"SUM(B125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:C125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:D125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:E125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:F125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:G125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:H125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:I125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:J125)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($B$125:K125)","v":{"$error":"#DIV/0!"}}]
["Fraction calculations",null,{"$f":"IF(C126<0,\"n/m\",ABS(B126/C125))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D126<0,\"n/m\",ABS(C126/D125))","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!"}]
[]
["4. Assumptions and calculations",{"$nulls":13},"Categories of assumptions and calculations are presented in the same order as the Cash Flow Analysis"]
[]
["4.1. Ice Sales",{"$nulls":13},"Ice sales are the primary source of revenue. 4.1 allows the Enterprise Owner to set the desired price point for the product and also review the projected sales over the useful life of the ice-making plant "]
["Assumptions","Unit","Conversion","New Enterprise"]
["Fixed product cost","$/kg",{"$f":"C5/I187","v":{"$error":"#DIV/0!"}},{"$f":"D5/I202","v":{"$error":"#DIV/0!"}},{"$nulls":10},"Calculated based on the total CAPEX for the ice making plant divided by the total amount of ice produced over its lifetime"]
["Variable product cost","$/kg",{"$f":"L76/I187","v":{"$error":"#DIV/0!"}},{"$f":"L107/I202","v":{"$error":"#DIV/0!"}},{"$nulls":10},"Calculated based on the total OPEX for the ice making plant divided by the total amount of ice produced over its lifetime"]
["Product Unit Cost ","$/kg",{"$f":"C133+C134","v":{"$error":"#DIV/0!"}},{"$f":"D133+D134","v":{"$error":"#DIV/0!"}},{"$nulls":10},"Sum of variable and fixed product cost"]
["Profit Margin ","%",{"$nulls":12},"Profit mark-up to be set by Enterprise Owner. In assessing the appropriate mark-up the Enterprise Owner should take into consideration prevailing market price of ice-sales in community "]
["Product Unit Retail Price","$/kg",{"$f":"C135*(1+C136)","v":{"$error":"#DIV/0!"}},{"$f":"D135*(1+D136)","v":{"$error":"#DIV/0!"}},{"$nulls":10},"This is the desired retail price for the product. The selected retail price should result in a positive NPV. If this is not the case, the Enterprise Owner can (i) adjust the profit margin or (ii) adjust inputs in sections 4.2 and 4.3 "]
[]
["Projected ice sales","Unit","Conversion","New Enterprise"]
[1,"$",{"$f":"$C$137*$I177","v":{"$error":"#DIV/0!"}},{"$f":"I192*$D$137","v":{"$error":"#DIV/0!"}}]
[2,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[5,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[6,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[9,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[10,"$",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total",null,{"$f":"SUM(C140:C149)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D140:D149)","v":{"$error":"#DIV/0!"}}]
[]
["4.2. Energy consumption/Ice Production"]
["Assumptions","Units ","1. Conversion","2. New Enterprise"]
["Ice produced per hour","kg",{"$nulls":12},"Input based on technical specifications of the potential/existing ice making plant"]
["Hours per shift","hrs"]
["Shifts per day","shifts"]
["Operating days per month","days"]
["Ice produced per day","kg ",{"$f":"C154*C155*C156","v":0},{"$f":"D154*D155*D156","v":0}]
["Operating hours per month","hrs",{"$f":"C155*C156*C157","v":0},{"$f":"D155*D156*D157","v":0}]
["Maximum monthly production capacity","kg",{"$f":"C154*C155*C156*C157","v":0},{"$f":"D154*D155*D156*D157","v":0}]
[]
["Power demand per hour of use","kW",{"$nulls":12},"Input based on technical specifications of the potential/existing ice making plant"]
[]
["High Season utilisation","%",{"$nulls":12},"Assumptions from Row 164 to 169 are intended to utilisation of the Ice Making plant based on fish supply seasonality. E.g. Less ice is produed in low season due to less fish being caught. 100% Utilisation means that the Ice Making Plant is producing at its full capacity (as calculated in Row 151) for the period of the particular season"]
["High Season months p.a ","months"]
["Mid Season utilisation","%"]
["Mid Season months p.a.","months"]
["Low Season utilisation","%"]
["Low Season months p.a ","months"]
["Month check",null,{"$f":"IF(SUM(C165,C167, C169)>12, \">12 months\", \"ok\")","v":"ok"},{"$f":"IF(SUM(D165,D167, D169)>12, \">12 months\", \"ok\")","v":"ok"},{"$nulls":10},"The Sum of Rows 165, 167 and 169 should equal 12 (months of the year of operation) or less (if the Ice Making Plant is not utilised for extended periods of the year)"]
[]
["Tariff","$ kWh",{"$nulls":12},"A best estimate of the cost of power. Ideally informed by earlier discussion/calculations with the Developer"]
[]
["4.2.1 Projected energy consumption - Conversion Scenario ",{"$nulls":13},"Key values 4.2.1 are found in Column I (Total Annual Production of Ice) and Column L (Total Financial Value of Energy Consumed)"]
[null,null,"High season production",null,"Mid season production",null,"Low season production",null,"Total annual production",null,"Energy Consumed"]
[null,"Unit","kg","hrs","kgs","hrs","kgs","hrs","kgs","hrs","kWh","$"]
[1,"$",{"$f":"IF(A177>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C165)","v":0},{"$f":"IF(A177>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A177>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A177>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A177>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A177>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},{"$f":"SUM(C177,E177,G177)","v":0},{"$f":"SUM(D177,F177,H177)","v":0},{"$f":"J177*$C$162","v":0},{"$f":"K177*$C$172","v":0}]
[2,"$",{"$f":"IF(A178>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A178>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A178>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A178>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A178>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A178>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[3,"$",{"$f":"IF(A179>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A179>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A179>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A179>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A179>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A179>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[4,"$",{"$f":"IF(A180>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A180>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A180>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A180>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A180>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A180>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[5,"$",{"$f":"IF(A181>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A181>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A181>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A181>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A181>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A181>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[6,"$",{"$f":"IF(A182>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A182>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A182>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A182>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A182>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A182>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[7,"$",{"$f":"IF(A183>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A183>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A183>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A183>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A183>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A183>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[8,"$",{"$f":"IF(A184>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A184>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A184>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A184>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A184>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A184>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[9,"$",{"$f":"IF(A185>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A185>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A185>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A185>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A185>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A185>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
[10,"$",{"$f":"IF(A186>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$164)*$C$165)","v":0},{"$f":"IF(A186>'Ice Making Facility Owner view'!$C$15, 0, $C$165*C$164*$C$159)","v":0},{"$f":"IF(A186>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$166)*$C$167)","v":0},{"$f":"IF(A186>'Ice Making Facility Owner view'!$C$15, 0, $C$167*C$166*$C$159)","v":0},{"$f":"IF(A186>'Ice Making Facility Owner view'!$C$15, 0, ($C$160*$C$168)*$C$169)","v":0},{"$f":"IF(A186>'Ice Making Facility Owner view'!$C$15, 0, C$168*$C$159*$C$169)","v":0},0,0,0,0]
["Total",null,{"$f":"SUM(C177:C186)","v":0},0,0,0,0,0,0,0,0,0]
[]
["4.2.2 Projected energy consumption - New Enterprise Scenario"]
[null,null,"High season production",null,"Mid season production",null,"Low season production",null,"Total annual production",null,"Total energy consumed"]
[null,"Units","kg","hrs","kgs","hrs","kgs","hrs","kgs","hrs","kWh","$"]
[1,"$",{"$f":"IF(A192>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D165)","v":0},{"$f":"IF(A192>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A192>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A192>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A192>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A192>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},{"$f":"SUM(C192,E192,G192)","v":0},{"$f":"SUM(D192,F192,H192)","v":0},{"$f":"J192*$D$162","v":0},{"$f":"K192*$D$172","v":0}]
[2,"$",{"$f":"IF(A193>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A193>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A193>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A193>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A193>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A193>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[3,"$",{"$f":"IF(A194>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A194>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A194>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A194>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A194>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A194>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[4,"$",{"$f":"IF(A195>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A195>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A195>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A195>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A195>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A195>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[5,"$",{"$f":"IF(A196>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A196>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A196>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A196>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A196>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A196>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[6,"$",{"$f":"IF(A197>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A197>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A197>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A197>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A197>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A197>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[7,"$",{"$f":"IF(A198>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A198>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A198>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A198>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A198>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A198>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[8,"$",{"$f":"IF(A199>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A199>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A199>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A199>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A199>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A199>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[9,"$",{"$f":"IF(A200>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A200>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A200>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A200>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A200>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A200>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
[10,"$",{"$f":"IF(A201>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$164)*$D$165)","v":0},{"$f":"IF(A201>'Ice Making Facility Owner view'!$D$15,0,D$164*$D$159*$D$165)","v":0},{"$f":"IF(A201>'Ice Making Facility Owner view'!$D$15,0,($D$160*$D$166)*$D$167)","v":0},{"$f":"IF(A201>'Ice Making Facility Owner view'!$D$15,0,D$166*$D$159*$D$167)","v":0},{"$f":"IF(A201>'Ice Making Facility Owner view'!$D$15,0, ($D$160*$D$168)*$D$169)","v":0},{"$f":"IF(A201>'Ice Making Facility Owner view'!$D$15,0, D$168*$D$159*$D$169)","v":0},0,0,0,0]
["Total",null,{"$f":"SUM(C192:C201)","v":0},0,0,0,0,0,0,0,0,0]
[]
["4.3 Operations and Maintenance (O&M)",{"$nulls":13},"The default template includes the most commonly used categorizations. User can add or consolidate categories based on the specific needs though adjustments. "]
["Assumptions","Unit","Conversion ","New Enterprise "]
["Number of FTE","#",{"$nulls":12},"The number of full time staff estimated to be required to operate the ice making plant at the assumed utilisaion "]
["Annual salary FTE","$",{"$nulls":12},"The total financial salary of each full time staffer"]
["Annual regular service cost","$",{"$nulls":12},"Estimated cost of the annual servicing of the ice making plant. Note that many new machines do come with time-dependent warranties"]
["Biennial major service cost","$",{"$nulls":12},"Estimated cost of the major services of the ice making plant every 2 years. May not apply to some machines, including those with warranties of 2 years or longer"]
[]
["Projected O&M","Unit","Conversion ","New Enterprise "]
[1,"#",{"$f":"IF(A212>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},{"$f":"(D$206*D$207)+D$208+D$209","v":0}]
[2,"$",{"$f":"IF(A213>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},{"$f":"(D$206*D$207)+D$208+D$209","v":0}]
[3,"$",{"$f":"IF(A214>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[4,"$",{"$f":"IF(A215>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[5,"$",{"$f":"IF(A216>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[6,"$",{"$f":"IF(A217>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[7,"$",{"$f":"IF(A218>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[8,"$",{"$f":"IF(A219>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[9,"$",{"$f":"IF(A220>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
[10,"$",{"$f":"IF(A221>'Ice Making Facility Owner view'!$C$15,0,(C$206*C$207)+C$208+C$209)","v":0},0]
["Total",null,{"$f":"SUM(C212:C221)","v":0},{"$f":"SUM(D212:D221)","v":0}]
[]
["4.4 Depreciation",{"$nulls":13},"These values will change according to the Developer Scenario and link directly to CAPEX in the Cash Flow Summary"]
["Assumptions","Units","Conversion ","New Enterprise"]
["Ice Making Plant purchase","$",{"$nulls":12},"Will only apply in a situation in which an enteprise is buying an electric ice making plant"]
["Ice making plant conversion","$",{"$nulls":12},"Will only apply in a situation in which an enteprise is converting an existing diesel-genset ice making plant to be compatible with a Mini Grid"]
["Ice Making Plant Installation","$",{"$nulls":12},"Includes any associated costs with installing the ice making plant (e.g. any associated moving costs for a converted ice making plant; protective housing for the ice making plant)"]
["Total Investment ","$",{"$f":"SUM(C226:C228)","v":0},{"$f":"SUM(D226:D228)","v":0}]
["Remaining useful life","years",{"$f":"'Ice Making Facility Owner view'!C15","v":0},{"$f":"'Ice Making Facility Owner view'!D15","v":0},{"$nulls":10},"These values are linked to Row 15"]
[]
["Projected Depreciation",null,"Conversion",null,null,"New Enterprise"]
[null,"Units","NBV B/F","Dep/n expense","NBV C/F","NBV B/F","Dep/n expense","NBV C/F"]
[1,"$",{"$f":"C229","v":0},{"$f":"IF(A234>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},{"$f":"C234-D234","v":0},{"$f":"D229","v":0},{"$f":"IF(A234>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},{"$f":"F234-G234","v":0}]
[2,"$",{"$f":"E234","v":0},{"$f":"IF(A235>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"H234","v":0},{"$f":"IF(A235>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[3,"$",{"$f":"E235","v":0},{"$f":"IF(A236>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"H235","v":0},{"$f":"IF(A236>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[4,"$",{"$f":"E236","v":0},{"$f":"IF(A237>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"H236","v":0},{"$f":"IF(A237>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[5,"$",{"$f":"E237","v":0},{"$f":"IF(A238>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"H237","v":0},{"$f":"IF(A238>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[6,"$",{"$f":"E238","v":0},{"$f":"IF(A239>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"H238","v":0},{"$f":"IF(A239>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[7,"$",{"$f":"IF(E239<0, 0, E239)","v":0},{"$f":"IF(A240>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"IF(H239<0, 0, H239)","v":0},{"$f":"IF(A240>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[8,"$",{"$f":"IF(E240<0, 0, E240)","v":0},{"$f":"IF(A241>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"IF(H240<0, 0, H240)","v":0},{"$f":"IF(A241>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[9,"$",{"$f":"IF(E241<0, 0, E241)","v":0},{"$f":"IF(A242>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"IF(H241<0, 0, H241)","v":0},{"$f":"IF(A242>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
[10,"$",{"$f":"IF(E242<0, 0, E242)","v":0},{"$f":"IF(A243>'Ice Making Facility Owner view'!$C$15,0,$C$229*(1/$C$230))","v":0},0,{"$f":"IF(H242<0, 0, H242)","v":0},{"$f":"IF(A243>'Ice Making Facility Owner view'!$D$15,0,$D$229*(1/$D$230))","v":0},0]
["Total",null,null,{"$f":"SUM(D234:D243)","v":0},null,null,{"$f":"SUM(G234:G243)","v":0}]
[]
["4.5 Interest and principal loan repayments",{"$nulls":13},"The default template includes the most commonly used categorizations. User can add or consolidate categories based on the specific needs though adjustments. "]
["Assumptions","Units","Conversion ","New Enterprise"]
["Upfront Deposit ","$",{"$nulls":12},"The deposit required by the lender to secure the loan. Usually quoted as a percentage of the total asset value. "]
["Loan principal","$",{"$nulls":12},"The value of the loan before the incurring of any interest charges"]
["Loan term","years",{"$nulls":12},"The duration (in years) in which the loan principal and interest is required to be fully repaid"]
["Interest ","%",{"$nulls":12},"The non-principal loan repyaments. Projections assume interest is charged annually on the remaining value of the loan principal."]
[]
["Projected loan repayments",null,"Conversion",{"$nulls":4},"New Enterprise"]
[null,"Units","Debt B/C","New Debt Issues","Total repayments","Principal","Interest","Debt B/C","New Debt Issues","Total repayments","Principal","Interest",null,null,"Add any new debt taken on over the projected 10 years into corresponding cells in this table"]
[1,"$",{"$f":"C249","v":0},null,{"$f":"-IF(A255>$C$250,0,PMT($C$251,$C$250,$C$249+D255))","v":0},{"$f":"E255-G255","v":0},{"$f":"$C$251*C255","v":0},{"$f":"D249","v":0},null,{"$f":"-IF(A255>$D$250,0,PMT($D$251,$D$250,$D$249))","v":0},{"$f":"J255-L255","v":0},{"$f":"H255*$D$251","v":0}]
[2,"$",{"$f":"IF(A256>$C$250, 0, C255+D255-F255)","v":0},null,{"$f":"-IF(A256>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D256)))","v":0},0,0,{"$f":"IF(A256>$D$250, 0, H255+I255-K255)","v":0},null,0,0,0]
[3,"$",0,null,{"$f":"-IF(A257>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D257)))","v":0},0,0,0,null,0,0,0]
[4,"$",0,null,{"$f":"-IF(A258>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D258)))","v":0},0,0,0,null,0,0,0]
[5,"$",0,null,{"$f":"-IF(A259>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D259)))","v":0},0,0,0,null,0,0,0]
[6,"$",0,null,{"$f":"-IF(A260>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D260)))","v":0},0,0,0,null,0,0,0]
[7,"$",0,null,{"$f":"-IF(A261>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D261)))","v":0},0,0,0,null,0,0,0]
[8,"$",0,null,{"$f":"-IF(A262>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D262)))","v":0},0,0,0,null,0,0,0]
[9,"$",0,null,{"$f":"-IF(A263>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D263)))","v":0},{"$f":"IF(E263=0, 0, ($C$249/$C$250))","v":0},{"$f":"E263-F263","v":0},0,null,0,0,0]
[10,"$",0,null,{"$f":"-IF(A264>$C$250,0,PMT($C$251,$C$250,$C$249+SUM($D$255:D264)))","v":0},{"$f":"IF(E264=0, 0, ($C$249/$C$250))","v":0},{"$f":"E264-F264","v":0},0,null,0,0,0]
["Total",null,null,null,{"$f":"SUM(E255:E264)","v":0},{"$f":"SUM(F255:F264)","v":0},{"$f":"SUM(G255:G264)","v":0},null,null,{"$f":"SUM(J255:J264)","v":0},{"$f":"SUM(K255:K264)","v":0},{"$f":"SUM(L255:L264)","v":0}]

{"sheet":"NS Edits","index":4,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["MODEL REVIEW COMMENTS "]
[]
["JC","Topic","cell ref","Edits","Status "]
[null,"General ",null,"- we need to start putting this model in guide format. Take a look at GACC Spark + DD templates (DD template, Application workbook) for ideas on presentation "]
["Done","Formatting ",null,"- make font, formatting (color scheme) consistent with Developer view tab "]
["Done","Key investment metrics ",null,"- Add payback calculation \n- discount rate should be in blue highlighted text since its a hard coded input "]
["Done","Conversion Scenario ",null,"- include a provision for income taxes in the calculation. The tax rate should be a hard coded input.   \n"]
["Done","Conversion Scenario ",null,"- include a note with the currency of the analysis"]
["Done","Conversion Scenario ",null,"- calculation should have the optionality such that the cash flows match the remaining useful life of the plant (for e.g. the Lakeview plant is <10 years) "]
["Done","Conversion Scenario ","Row 17","- Remove references to actual years and instead label it year 1, year 2 ... "]
["Done","Conversion Scenario ","Rows 25:26","- Depreciation and interest repayments are not \"OPEX\" show them as separate line items. "]
["Done","Conversion Scenario ","Row25, Cell B31, C152","- The sum of depreciation (25,000) does not equal CAPEX in cell B31 (21,000). This is because cell B31 is not linked to cell C152 and so the depreciation calculations doesn't match the CAPEX shown. Link cell B31 to cell CI52 and make sure it is in BLACK TEXT so it's clear its a calculation and not a hard coded input. "]
["Done","Conversion Scenario ",null,"- calculation is missing Principal payments on debt. These should be shown after CAPEX line item i.e. after-taxes"]
["Done","Conversion Scenario ","Row 36","-  remove cumulative cash flows unless this is meant to feed into another calculation"]
["Done","Greenfield Scenario",null,"same comments as above except #6 "]
["Done","Energy consumption ","A94:A103","See comment 7"]
["Done","Ice Sales ","Row 94:103","the calculations should flow in the same order as the P&L. As it stands energy consumption comes before Ice sales followed by OPEX …"]
["Keeping to be consistent","Ice Sales ","Row 114:127 ","Remove these calculations, they can be done directly in rows 19 and 41"]
["Keeping to be consistent","Ice Sales ","Row 136:147","Remove these calculations, they can be done directly in rows 24 and 46"]
["Done","Interest Calculations ",null,"Do an annuity calculation (using PMT function in excel) instead of assuming that the principal is paid in equal installments each year "]