{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover","OrganEcs History","1-Title","2-Contents","3-Background","4-Instructions","5-Facility Inputs","6-Waste Inputs","7-Economic Inputs","8-Default Values","9-Outputs","10-Compost W.O. FA","11-Compost With FA","12-Tool Assumptions","13-Sources","25-Misc"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":4,"defined_names":259,"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":"Cover","index":0,"n_rows":370,"n_cols":3,"rows_kept":370,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,3.1]

{"sheet":"OrganEcs History","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["OrganEcs Anaerobic Digestion Tool History"]

{"sheet":"1-Title","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Title"]
[]
[null,"Title","OrganEcs – Cost Estimating Tool for Managing Source-Separated Organic Waste"]
[null,"Version","3.1 (Compost Edition)"]
[null,"Acknowledgements","OrganEcs, was developed by the U.S. Environmental Protection Agency under the auspices of the Global Methane Initiative and in support of the Climate and Clean Air Coalition. Tom Frankiewicz (EPA’s International Biogas Team Lead) managed the tool’s development with technical support from Abt Associates.\n\nThe U.S. EPA recommends users cite OrganEcs with the following citation when citing the tool in published work: \nU.S. EPA. 2021. OrganEcs-Compost V3.1. "]
[null,"Disclaimer","The tool is meant to provide planning-level assistance, outputs should be verified through a detailed feasibility study (or through the solicitation of bids from qualified proposers) before project development commences."]

{"sheet":"2-Contents","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contents"]
[]
[null,1,null,"Title"]
[null,{"$f":"B4+1","v":2},null,"Contents"]
[null,{"$f":"B5+1","v":3},null,"Background"]
[null,4,null,"Instructions"]
[null,5,null,"Facility Inputs"]
[null,6,null,"Waste Inputs"]
[null,7,null,"Economic Inputs"]
[null,8,null,"Default Values"]
[null,9,null,"Outputs"]
[null,10,null,"Composting Without Forced Aeration-Low"]
[null,11,null,"Composting Without Forced Aeration-High"]
[null,12,null,"Tool Assumptions"]
[null,13,null,"Sources"]

{"sheet":"3-Background","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Background"]
[]
[null,"Introduction ",null,"The Global Methane Initiative works with cities worldwide to improve solid waste management and reduce emissions of short-lived climate pollutants. OrganEcs, was developed by the U.S. Environmental Protection Agency under the auspices of the Global Methane Initiative and in support of the Climate and Clean Air Coalition. Organic waste management projects (i.e., composting, and anaerobic digestion) represent a key opportunity for achieving these objectives. Planning and development of such projects require a detailed understanding of the costs involved in construction and operation of organic waste management facilities.\n\nOrganEcs is a tool for estimating the costs associated with organic waste management projects. It provides planning-level assistance to local governments, waste professionals, policymakers, facility operators, and project developers to help them make financial decisions about their potential organic projects. Specifically, the tool assists users in determining the expected IRR (internal rate of return), given user inputs for a composting project. \n\nModel outputs should be viewed as preliminary results that can be used for planning purposes. These estimates should be verified through detailed feasibility studies prior to project development, or through the solicitation of bids from qualified firms. "]

{"sheet":"4-Instructions","index":5,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,1,14,3],[15,1,15,3],[8,2,8,3],[9,2,9,3],[1,1,1,3],[12,1,12,3],[13,1,13,3],[10,1,10,3],[11,1,11,3],[3,1,3,3],[4,1,4,3],[6,2,6,3],[7,2,7,3],[5,1,5,3]]}
[]
[null,"Instructions"]
[]
[null,"Model Organization"]
[null,"This tool has 13 sheets, which are color coded as follows: \n  •  BLUE tabs: User inputs.\n  •  YELLOW tab: Default values.\n  •  BLACK tab: Results or Outputs.\n  •  GRAY tabs: Organic waste treatment technologies\n  •  GREEN tabs: Assumptions and additional resources. "]
[null,"Operating the Tool"]
[null,"Version Control","•  Download the latest version of OrganEcs\n•  Save the file with the city name before entering any data\n"]
[null,"Cell Colors","•  Input cells are BLUE and will change to a lighter shade when you enter data. \n•  Default cells are YELLOW and will change to brown if they are altered.\n•  Some cells have an automatic validity check. If you enter an incorrect value or make an invalid selection, the cell will turn RED, and an error message will appear. Please correct the error before continuing."]
[null,"Data Entry","•  Enter all required user inputs into the blue cells in the input tabs (“5-Facility Inputs,” “6-Waste Inputs,” and “7-Economic Inputs”). Please fill in all blue tabs in order to receive accurate outputs.\n•  Review the default values on tab \"8-Default Values\" and alter if desired.\n•  Additional instructions and source references can be found at the top of each tab and in the notes attached to the relevant input cells. "]
[null,"Outputs Tab","•  Provide inputs on the type of waste for which the gate fee is to be calculated, and whether yard waste and purchased bulking agent are to be included in the waste diversion estimates.\n"]
[null,"Help"]
[null,"If you need assistance while using the model, please send any questions to BiogasToolkit@epa.gov."]
[null,"Tool Limitations"]
[null,"Facility performance (e.g., electricity and compost production, water demand, wastewater generation, equipment lifespan, operating days/year) is based on published data for typical facilities and will vary based on a number of factors, including, but not limited to, operating and maintenance (O&M) practices, feedstock characteristics, selected technology, and climate.\n\n"]
[null,"Tool Assumptions"]
[null,"Tool assumptions and default values can be found throughout the tool in hovering messages and on the \"8-Default Values\" tab. The user may elect to overwrite default values with actual data from local processing facilities or a select technology vendor. \n\nSome of the default values in the \"8-Default Values\" tab are calculations based on user inputs in tabs 5-7. "]

{"sheet":"5-Facility Inputs","index":6,"n_rows":202,"n_cols":6,"rows_kept":202,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,3],[7,1,7,4],[30,1,30,2],[10,1,10,4]]}
[]
[null,"Facility Inputs - Design Parameters for New Facility"]
[]
[null,"Instructions: ","- Enter design parameters into the blue cells, or select values from the drop-down menus, for facility(ies) the user is interested in developing and/or comparing.\n- User may alter given default values if desired. \n- Input cells will change to light blue once user has entered desired parameters; default cells will change to dark brown if value is altered. "]
[]
[]
[null,"Technology Selection"]
[null,"Please choose \"Yes\" in the dropdown list for the technologies you are interested in developing/ comparing. If you are not interested in the technology, please choose \"No.\""]
[null,"Composting Without Forced Aeration","CHOOSE ONE"]
[null,"Composting With Forced Aeration","CHOOSE ONE"]
[null,{"$f":"IF(AND(C9<>\"Yes\",C10<>\"Yes\"),\"ERROR - Please choose 'Yes' for at least one technology.\", \"\")","v":"ERROR - Please choose 'Yes' for at least one technology."}]
[]
[null,"Facility Operations",null,null,null,"Units"]
[null,"Investment Year"]
[null,"Construction Period",null,null,null,"Years"]
[null,"Operations Start Year",null,null,{"$f":"E14+E15","v":0}]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(E15>3,\"ERROR- Shorten construction period to 3 or fewer years.\",IF(E15<1,\"ERROR - Model requires a minimum 1-year construction period.\",\"OK\"))","v":"ERROR - Model requires a minimum 1-year construction period."}]
[null,"Maintenance Begins",null,null,{"$f":"E16+1","v":1},"Year"]
[null,"Facility Lifespan",null,null,20,"Years"]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(DepreciationAllInfrastructure>FacilityLifespan,\"ERROR- Depreciation Period Greater than Facility Lifespan\",\"OK\")","v":"OK"}]
[null,"Average Round-trip Distance from Waste Generators to Landfill",null,null,null,"km"]
[null,"Average Round-trip Distance from Waste Generators to Organics Management Facility",null,null,null,"km"]
[null,"Round-trip Distance from Organics Management Facility to Landfill",null,null,null,"km"]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(OR(DistanceGeneratorsToLandfill=0,DistanceGeneratorsToOrganicsFacility=0,DistanceOrganicsFacilityToLandfill=0), \"ERROR - Please enter a non-zero value for all distances (cells E21-E23).\", \"OK\")","v":"ERROR - Please enter a non-zero value for all distances (cells E21-E23)."}]
[]
[null,"Facility Design - Composting Technologies",null,"Composting Without Forced Aeration\n(e.g., mattress/bed, windrow)","Composting With Forced Aeration\n(e.g., in-vessel [container, tunnel, tower, drum], aerated static pile)","Units"]
[null,"Peak Throughput Operating Year (to determine design capacity)",null,3,3,"Operating Year (1-20)"]
[null,"Percentage of Compost Facility Intends to Sell - Year 1",null,0.3,0.3,"%"]
[null,"Percentage of Compost Facility Intends to Sell - Year 2",null,0.5,0.5,"%"]
[null,"Percentage of Compost Facility Intends to Sell - Year 3",null,0.7,0.7,"%"]
[null,"Percentage of Equipment Subject to VAT (Value-Added Tax; same as Goods and Services Tax)",null,null,null,"%"]
[null,"Ancillary Costs",null,null,null,"$"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Macro Reset"]
[null,null,null,3,3]
[null,null,null,0.3,0.3]
[null,null,null,0.5,0.5]
[null,null,null,0.7,0.7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CHOOSE ONE"]
[null,"Compost"]
[null,"Digestate"]
[]
[null,"CHOOSE ONE"]
[null,"Digestate (No Dewatering)"]
[null,"Liquid Digestate + Dewatered Digestate"]
[null,"Dewatered Digestate (Liquid Recycled/Discharged to Sewer)"]
[null,"Compost (Liquid Recycled/Discharged to Sewer)"]
[null,"Liquid Digestate + Compost"]
[]
[null,"CHOOSE ONE"]
[null,"Not Applicable"]
[null,"Composting W/O Forced Aeration"]
[null,"Composting With Forced Aeration - Aerated Static Pile"]
[null,"Composting With Forced Aeration - In-vessel"]
[null,"CHOOSE ONE"]
[null,"Yes"]
[null,"No"]
[]
[null,"CHOOSE ONE"]
[null,"No Yard Waste Under Management"]
[null,"Compost Yard Waste"]
[null,"Give Away Yard Waste"]
[null,"Sell Mulch"]
[]
[]
[null,"CHOOSE ONE"]
[null,"No Yard Waste Under Management"]
[null,"Digest"]
[null,"Compost"]
[]
[]
[null,"CHOOSE ONE"]
[null,"Aerated Static Pile"]
[null,"In-vessel"]

{"sheet":"6-Waste Inputs","index":7,"n_rows":76,"n_cols":12,"rows_kept":76,"cut":false,"hidden":false,"merged":[[38,2,38,3],[3,3,8,7],[3,2,8,2],[33,2,33,3],[34,2,34,3],[17,4,17,11],[15,2,15,11],[16,2,16,11]]}
[]
[null,null,"Waste Inputs - Feedstock Characteristics"]
[]
[null,null,"Instructions: ","- User should enter tonnes/year of available feedstock in the first table (\"ALL SCENARIOS\") and the projected growth rate of waste in the  \"Total Incoming Feedstock\" table, regardless of which technology user intends to pursue. Feedstock characteristics will vary by location and season.  \n- Input cells will change to light blue once user has entered local data. \n- User may choose to use default feedstock characteristics or enter data from laboratory analysis into the yellow-green cells. \n- Default cells will change to dark brown if value is altered. \n- Based on feedstock blending calculations, user should modify the amount of purchased bulking agent required to meet the target values in red, which are unique to each type of technology. If target values are not met, cell will be highlighted in red."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Purchased Bulking Agent for Compost  (e.g., Woo+H14d Chips) "]
[]
[null,null,"Please fill out cells E20 to J20 (\"Yard Waste\" through \"Corrugated Cardboard\") regardless of which project technology you intend to pursue."]
[null,null,"Note: Tool requires a minimum waste throughput of 2,000 TPY. Composting without forced aeration requires either 100% yard waste or a mix of yard waste, food waste, manure, and sludge that is at least 60% yard waste; cardboard and mixed paper will not be incorporated, as there are better uses for these wastes."]
[null,null,"ALL SCENARIOS",null,"Feedstock Availability & Compost Bulking Agent"]
[null,null,"Feedstock",null,"Yard Waste","Food Waste","Manure","Sewage Sludge","Mixed Paper","Corrugated\nCardboard","Purchased Bulking Agent for Compost (e.g., Wood Chips) ","Feedstock Availability (Excl. Purchased Bulking Agent)"]
[null,null,"Tonnes Per Year",null,null,null,null,null,null,null,null,{"$f":"SUM(YardWasteTonnes:CardboardTonnes)","v":0}]
[null,null,"Carbon (% dry weight)",null,{"$f":"E22*E23","v":0.21959999999999999},0.83519999999999994,0.38159999999999999,0.48060000000000003,0.38125000000000003,0.56300000000000006,0.495]
[null,null,"Nitrogen (% dry weight)",null,7.1999999999999998E-3,3.5999999999999997E-2,2.4E-2,4.4499999999999998E-2,2.5000000000000001E-3,1E-3,3.5999999999999999E-3]
[null,null,"C:N Ratio (parts carbon to 1 part nitrogen)",null,30.5,23.2,15.9,10.8,152.5,563,137.5]
[null,null,"Moisture %",null,0.53610000000000002,0.67,0.8,0.78,0.25,0.17,0.46949999999999997]
[null,null,"Volatile Solids ",null,0.90600000000000003,0.95299999999999996,0.82640000000000002,0.8,0.91500000000000004,0.89,0.90600000000000003]
[null,null,"Tonnes Carbon",null,{"$f":"E21*E20","v":0},0,0,0,0,0,{"$f":"K21*K20","v":0}]
[null,null,"Tonnes Nitrogen",null,{"$f":"E20*E22","v":0},0,0,0,0,0,0]
[null,null,"Tonnes of Moisture",null,{"$f":"E24*E20","v":0},0,0,0,0,0,0]
[null,null,"Tonnes of Volatile Solids",null,{"$f":"E20*E25","v":0},0,0,0,0,0,0]
[]
[null,null,"C:N RATIO",null,{"$f":"SUM(E26:K26)/SUM(E27:K27)","v":{"$error":"#DIV/0!"}},"Target = 25-35%"]
[null,null,"PERCENT MOISTURE",null,{"$f":"SUM(E28:K28)/SUM(E20:K20)","v":{"$error":"#DIV/0!"}},"Target = 50-65%"]
[null,null,"PERCENT VOLATILE SOLIDS",null,{"$f":"SUM(E29:K29)/SUM(E20:K20)","v":{"$error":"#DIV/0!"}}]
[null,null,"Add. H20 Required: Composting With Forced Aeration (m3/year)",null,{"$f":"IF((0.6*SUM(E20:K20))-(SUM(E28:K28))<0,0,(0.6*SUM(E20:K20))-(SUM(E28:K28)))","v":0}]
[null,null,"Add. H20 Required: Composting W/O Forced Aeration (m3/year)",null,{"$f":"IF((0.6*SUM(E20:E20))-(SUM(E28:E28))<0,0,(0.6*SUM(E20:E20))-(SUM(E28:E28)))","v":0}]
[]
[]
[null,null," Total Incoming Feedstock"]
[null,null,"Feedstock Availability (Excl. Purchased Bulking Agent)",null,{"$f":"SUM(YardWasteTonnes:CardboardTonnes)","v":0},"TPY"]
[null,null,"Growth Rate of Waste",null,0,"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Nitrogen (% dry weight)",null,7.1999999999999998E-3,3.5999999999999997E-2,2.4E-2,4.4499999999999998E-2,2.5000000000000001E-3,1E-3,3.5999999999999999E-3]
[null,null,"C:N Ratio (parts carbon to 1 part nitrogen)",null,30.5,23.2,15.9,10.8,152.5,563,137.5]
[null,null,"Moisture %",null,0.53610000000000002,0.67,0.8,0.78,0.25,0.17,0.46949999999999997]
[null,null,"Volatile Solids ",null,0.90600000000000003,0.95299999999999996,0.82640000000000002,0.8,0.91500000000000004,0.89,0.90600000000000003]
[]
[null,null,"Composting W/O Forced Aeration",null,2000]
[null,null,"Composting With Forced Aeration",null,2000]

{"sheet":"7-Economic Inputs","index":8,"n_rows":481,"n_cols":12,"rows_kept":481,"cut":false,"hidden":false,"merged":[[3,2,5,6],[3,1,5,1],[47,7,47,9],[8,1,8,4],[8,7,8,10]]}
[]
[null,"Economic Inputs - Costs, Revenues, & Financial Parameters"]
[]
[null,"Instructions: "]
[]
[]
[]
[]
[null,"PROJECT COSTS",null,null,null,"Units",null,"PROJECT REVENUES",null,null,null,"Units"]
[null,"ENTER ALL COSTS IN US DOLLARS",null,null,null,null,null,"ENTER ALL COSTS IN US DOLLARS"]
[null,"Labor ($ in Current Year)",null,null,null,null,null,"Facility Operations ($ in Current Year)"]
[null,"Manager/Engineer - Labor Cost per Person",null,null,null,"$/person/year",null,"Gate Fee (Tipping Fee) to be Charged - Yard Wastes",null,null,null,"$/tonne"]
[null,"Operator - Labor Cost per Person",null,null,null,"$/person/year",null,"Gate Fee (Tipping Fee) to be Charged - Food Wastes",null,null,null,"$/tonne"]
[null,"Total Number of Managers/Engineers",null,null,null,"Full-time Employees",null,"Gate Fee (Tipping Fee) to be Charged - Manure/Sludge",null,null,null,"$/tonne"]
[null,"Total Number of Operators",null,null,null,"Full-time Employees",null,"Gate Fee (Tipping Fee) to be Charged - Paper/Cardboard",null,null,null,"$/tonne"]
[null,"Facility Operations ($ in Current Year)",null,null,null,null,null,"Gate Fee- All Wastes ",null,null,null,"$/tonne"]
[null,null,null,null,null,null,null,"Avoided Landfill Disposal Fee",null,null,null,"$/tonne"]
[null,"Process Water Purchase Price",null,null,null,"$/m3",null,"Residual Disposal Fee",null,null,null,"$/tonne"]
[null,"Wastewater Treatment Cost",null,null,null,"$/m3",null,"Transportation Fee",null,null,null,"$/tonne/km"]
[null,"Purchased Bulking Agent Cost (e.g., Wood Chips)",null,null,null,"$/tonne"]
[null,null,null,null,null,null,null,"Sellable End Products ($ in Current Year)"]
[null,"Energy Purchases ($ in Current Year)",null,null,null,null,null,"Market Price for Compost",null,null,null,"$/tonne"]
[null,"Electricty Retail Price",null,null,null,"$/kWh",null,"Inflation and Taxes"]
[null,"Diesel Retail Price",null,null,null,"$/liter",null,"Inflation Rate - General ",null,null,null,"%"]
[null,null,null,null,null,null,null,"Inflation Rate - Disposal Fee, Gate Fee",null,null,null,"%"]
[null,"Land ($ in Current Year)",null,null,null,null,null,"Inflation Rate - Electricity and Fuel",null,null,null,"%"]
[null,"Purchase or Lease Land",null,null,"CHOOSE ONE",null,null,"Inflation Rate -  Compost, Digestate, Bulking Agent",null,null,null,"%"]
[null,"Land - Purchase Price",null,null,null,"$/ha",null,"Tax Paid on Gross Profits",null,null,null,"%"]
[null,"Land - Lease Price",null,null,null,"$/ha/year",null,"VAT (Value-Added Tax; same as Goods and Services tax)",null,null,null,"%"]
[null,"Soil Product Land Application Cost",null,null,null,"$/tonne"]
[null,"Soil Product Transport Cost",null,null,null,"$/tonne",null,"Financing"]
[null,"Estimated Capital and Equipment Costs",null,null,null,null,null,"Grant Funding",null,null,null,"$"]
[null,"Infrastructure & Site Development Cost",null,null,null,"$",null,"Depreciation Life - Composting Equipment",null,null,7,"Years"]
[null,"Equipment Costs",null,null,null,"$",null,"Depreciation Life - Composting Infrastructure ",null,null,20,"Years"]
[null,"Salvage Value of Equipment at End of Useful-Life",null,null,null,"$"]
[null,null,null,null,null,null,null,"Equity Payback",null,null,null,"Years"]
[]
[null,null,null,null,null,null,null,"Percent Debt (% of project financed through debt)",null,null,null,"%"]
[null,null,null,null,null,null,null,"Percent Equity (% of project financed through equity)",null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(K38+K39=100%,\"OK\",\"ERROR-Debt + Equity Must Equal 100%\")","v":"ERROR-Debt + Equity Must Equal 100%"}]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(K39>0,\"OK\",\"ERROR-Equity Must be a Minimum of 0.1% for Model to Return Values\")","v":"ERROR-Equity Must be a Minimum of 0.1% for Model to Return Values"}]
[null,null,null,null,null,null,null,"Annual Interest Rate - Short-term Debt ",null,null,null,"%"]
[null,null,null,null,null,null,null,"Annual Interest Rate - Long-term Debt",null,null,null,"%"]
[null,null,null,null,null,null,null,"Tenor (amount of time left to repay loan) - Short-term Debt",null,null,null,"Years"]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(AND(K44<=K33,K44>0),\"OK\",IF(K44=0,\"ERROR-Enter Short-term Debt Tenor\", \"ERROR-Debt Tenor Cannot Exceed Composting Equipment Life\"))","v":"ERROR-Enter Short-term Debt Tenor"}]
[null,null,null,null,null,null,null,"Tenor (amount of time left to repay loan) - Long-term Debt ",null,null,null,"Years"]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(AND(K46<=K34,K46>0),\"OK\",IF(K46=0,\"ERROR-Enter Long-term Debt Tenor\",\"ERROR-Debt Tenor Cannot Exceed AD Equipment Life\"))","v":"ERROR-Enter Long-term Debt Tenor"}]
[null,null,null,null,null,null,null,"Use Debt/Equity to Finance Purchase of New Composting Equipment at End of Useful Life? ",null,null,"CHOOSE ONE"]
[null,null,null,null,null,null,null,"Depreciation Method",null,null,"CHOOSE ONE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CHOOSE ONE","CHOOSE ONE","CHOOSE ONE"]
[null,"Purchase","Yes","Straight-Line"]
[null,"Lease","No","Sum-of-Years' Digits"]

{"sheet":"8-Default Values","index":9,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,7]]}
[]
[null,"Default Values"]
[]
[null,"Instructions:"]
[]
[]
[]
[]
[]
[null,"Technology","Composting Without Forced Aeration","Composting With Forced Aeration"]
[null,"Soil Product Selected","Compost","Compost"]
[null,"Facility Design Capacity",{"$f":"IF(C13=0,0,YardWasteTonnes*(1+WasteGrowthRate)^'5-Facility Inputs'!D27)","v":0},{"$f":"IF(D13=0,0,SUM(YardWasteTonnes:BulkingAgentTonnesForCompost)*(1+WasteGrowthRate)^'5-Facility Inputs'!E27)","v":0}]
[null,"Total Annual Waste to Composting in YR 1 of Operations ",{"$f":"'10-Compost W.O. FA'!D25","v":0},{"$f":"'11-Compost With FA'!D25","v":0}]
[null,"Scenario"]
[null,"Facility Operations",1E-4,8.0000000000000007E-5]
[null,"Operating Days/Year",310,310]
[null,"Land Requirement (ha/tonne)",2.0000000000000001E-4,2.0000000000000001E-4]
[null,"Electricity Demand (kWh/tonne) ",4,4]
[null,"Fuel Demand (liters/tonne) ",7.5,7.5]
[null,"Primary Screening Residues (% of incoming feedstock)",0.1,0.1]
[null,"Compost Production (% of incoming feedstock) ",0.3,0.3]
[null,"Final Screening Residues (% of incoming feedstock)",0.1,0.1]
[null,"Composting System Capex"]
[null,"Equipment Cost in Investment Year ($)",{"$f":"'7-Economic Inputs'!$E34","v":0},{"$f":"'7-Economic Inputs'!$E34","v":0}]
[null,"Infrastructure & Site Development Cost in Investment Year ($)",{"$f":"'7-Economic Inputs'!$E33","v":0},{"$f":"'7-Economic Inputs'!$E33","v":0}]
[null,"Capital Cost Contingency (% of Capex)",0.1,0.1]
[null,"All Systems O&M"]
[null,"Maintenance Cost (% of Capex)",0.02,0.02]
[null,"Insurance (% of total Capex excl. VAT and grants)",0.01,0.01]
[null,"Outside Services and Supplies (% of O&M before contingency)",0.02,0.02,null,"`"]
[null,"O&M Cost Contingency (% of O&M)",0.1,0.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operating Days/Year",310,310]
[null,"Land Requirement (ha/tonne)",2.0000000000000001E-4,2.0000000000000001E-4]
[null,"Electricity Demand (kWh/tonne) ",4,4]
[null,"Fuel Demand (liters/tonne) ",7.5,7.5]
[null,"Primary Screening Residues (% of incoming feedstock)",0.1,0.1]
[null,"Compost Production (% of incoming feedstock) ",0.3,0.3]
[null,"Final Screening Residues (% of incoming feedstock)",0.1,0.1]
[]
[null,"Capital Cost Contingency (% of Capex)",0.1,0.1]
[null,"All Systems O&M"]
[null,"Maintenance Cost (% of Capex)",0.02,0.02]
[null,"Insurance (% of total Capex excl. VAT and grants)",0.01,0.01]
[null,"Outside Services and Supplies (% of O&M before contingency)",0.02,0.02]
[null,"O&M Cost Contingency (% of O&M)",0.1,0.1]

{"sheet":"9-Outputs","index":10,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,4]]}
[]
[null,"Outputs"]
[]
[null,"Guidance: ","This sheet summarizes and visualizes some basic information about the project based on user inputs from tab “5-Faculty Inputs,” “6-Waste Inputs,” “7-Economic Inputs,” and “8-Default Values.”  "]
[]
[]
[]
[null,"Composting Without Forced Aeration",null,"USD",null,"Composting With Forced Aeration",null,"USD"]
[null,"(e.g., mattress/bed, windrow)",null,null,null,"(e.g., semi-permeable cover, container/box/tunnel, tower, drum)"]
[null,"Initial Capital Investment ($)",null,{"$f":"IF(ISERROR(ROUNDUP('10-Compost W.O. FA'!D39,-2)),0,ROUNDUP('10-Compost W.O. FA'!D39,-2))","v":0},null,"Initial Capital Investment ($)",null,{"$f":"IF(ISERROR(ROUNDUP('11-Compost With FA'!D39,-2)),0,ROUNDUP('11-Compost With FA'!D39,-2))","v":0}]
[null,"Capex/tonne ($/TPY)",null,{"$f":"IF(ISERROR(ROUNDUP(D10/D17,0)),0,ROUNDUP(D10/D17,0))","v":0},null,"Capex/tonne ($/TPY)",null,{"$f":"IF(ISERROR(ROUNDUP(H10/H17,0)),0,ROUNDUP(H10/H17,0))","v":0}]
[null,"Total Annual Expenses in YR 1 Operations ($/year)",null,{"$f":"IF(ISERROR(ROUNDUP(MIN('10-Compost W.O. FA'!E227:X227),-2)),0,ROUNDUP(MIN('10-Compost W.O. FA'!E227:X227),-2))","v":0},null,"Total Annual Expenses in YR 1 Operations ($/year)",null,{"$f":"IF(ISERROR(ROUNDUP(MIN('11-Compost With FA'!D227:Z227),-2)),0,ROUNDUP(MIN('11-Compost With FA'!D227:Z227),-2))","v":0}]
[null,"O&M/tonne in YR 1 Operations ($/tonne of waste processed)",null,{"$f":"IF(ISERROR(ROUNDUP(D12/(D15+D16),0)),0,ROUNDUP(D12/(D15+D16),0))","v":0},null,"O&M/tonne in YR 1 Operations ($/tonne of waste processed)",null,{"$f":"IF(ISERROR(ROUNDUP(H12/(H15+H16),0)),0,ROUNDUP(H12/(H15+H16),0))","v":0}]
[null,"Total Land Required (ha)",null,{"$f":"'10-Compost W.O. FA'!D29","v":0},null,"Total Land Required (ha)",null,{"$f":"'11-Compost With FA'!D29","v":0}]
[null,"Total Organic Waste Available in YR 1 (tonnes/year)",null,{"$f":"FeedstockAvailability","v":0},null,"Total Organic Waste Available in YR 1 (tonnes/year)",null,{"$f":"FeedstockAvailability","v":0}]
[null,"Total Bulking Agent Required in YR 1 (tonnes/year) ",null,{"$f":"'10-Compost W.O. FA'!$D$24","v":0},null,"Total Bulking Agent Required in YR 1 (tonnes/year)",null,{"$f":"'11-Compost With FA'!D24","v":0}]
[null,"Total Waste Composted in YR 1 (tonnes/year)",null,{"$f":"'10-Compost W.O. FA'!D25","v":0},null,"Total Waste Composted in YR 1 (tonnes/year)",null,{"$f":"'11-Compost With FA'!D25","v":0}]
[null,"Compost Produced in YR 1 (tonnes/year)",null,{"$f":"MIN('10-Compost W.O. FA'!D225:Z225)","v":0},null,"Compost Produced In YR 1 (tonnes/year)",null,{"$f":"MIN('11-Compost With FA'!D224:Z224)","v":0}]
[null,"Levered IRR (%)",null,{"$f":"IF(ISERROR('10-Compost W.O. FA'!D58),\"Not Viable\",'10-Compost W.O. FA'!D58)","v":"Not Viable"},null,"Levered IRR (%)",null,{"$f":"IF(ISERROR('11-Compost With FA'!D58),\"Not Viable\",'11-Compost With FA'!D58)","v":"Not Viable"}]
[null,"Composting Without Forced Aeration",null,"USD",null,"Composting With Forced Aeration",null,"USD"]
[null,"Project Revenues vs. Expenses",null,null,null,"Project Revenues vs. Expenses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Composting Without Forced Aeration",null,"USD",null,"Composting With Forced Aeration",null,"USD"]
[null,"Gross Profit",null,null,null,"Gross Profit"]

{"sheet":"10-Compost W.O. FA","index":11,"n_rows":445,"n_cols":26,"rows_kept":445,"cut":false,"hidden":false,"merged":[[229,1,229,4],[230,1,230,4],[3,1,4,1],[3,2,4,4],[57,3,57,4],[58,1,58,4]]}
[]
[null,"Composting Without Forced Aeration"]
[]
[null,"Guidance: ","This sheet shows the hypothetical project’s estimated annual Income Statement and Balance Sheet, which are used to determine the Internal Rate of Return (IRR). The IRR is the rate that the modeled project’s cash flows break even with initial investment. IRR is determined by setting the net present value of all cash flows (both positive and negative) from the investment equal to zero. Note this model estimates Equity IRR. \nTo estimate Project IRR please set total debt on the “7-Economic Inputs” tab equal to zero. The sheet is organized by first listing important assumptions based on user inputs from tab “5-Faculty Inputs,” “6-Waste Inputs,” “7-Economic Inputs,” and “8-Default Values.” Below this are estimated project costs and revenues, debt schedules, interest, depreciation, and other important information. "]
[]
[]
[null,"Key Inputs"]
[null,"Compost Sale Price",null,{"$f":"CompostMarketPrice","v":0},"$/tonne"]
[null,"Gate Fee - Yard Waste ",null,{"$f":"GateFeeYardWaste","v":0},"$/tonne"]
[null,"Gate Fee - Food Waste",null,{"$f":"GateFeeFoodWaste","v":0},"$/tonne"]
[null,"Gate Fee - Manure/Sludge Waste",null,{"$f":"GateFeeManure","v":0},"$/tonne"]
[null,"Gate Fee - Paper/Cardboard",null,{"$f":"GateFeePaper","v":0},"$/tonne"]
[]
[null,"Composting Facility Assumptions ",null,null,"Units"]
[null,"Equipment Lifespan",null,{"$f":"DepreciationComposting","v":7},"years"]
[null,"Replacement 1",null,{"$f":"IF(D15+OperationsStartYear<(OperationsStartYear+FacilityLifespan),D15+OperationsStartYear,\"N/A\")","v":7},"year"]
[null,"Replacement 2",null,{"$f":"IF(D16=\"N/A\",\"N/A\",IF(D15+D16<(OperationsStartYear+FacilityLifespan),D15+D16,\"N/A\"))","v":14},"year"]
[null,"Replacement 3",null,{"$f":"IF(D17=\"N/A\",\"N/A\",IF(D15+D17<(OperationsStartYear+FacilityLifespan),D15+D17,\"N/A\"))","v":"N/A"},"year"]
[]
[null,"Incoming Yard Waste in YR 1 ",null,{"$f":"YardWasteTonnes","v":0},"tonnes/year"]
[null,"Incoming Food Waste in YR 1",null,{"$f":"FoodWasteTonnes","v":0},"tonnes/year"]
[null,"Incoming Manure/Sludge Waste in YR 1",null,{"$f":"ManureTonnes+SewageTonnes","v":0},"tonnes/year"]
[null,"Incoming Mixed Paper and Cardboard in YR 1",null,{"$f":"MixedPaperTonnes+CardboardTonnes","v":0},"tonnes/year"]
[null,"Purchased Bulking Agent Requirements in YR 1",null,{"$f":"BulkingAgentTonnesForCompost","v":0},"tonnes/year"]
[null,"Total Annual Waste Throughput in YR 1",null,{"$f":"SUM(D20:D24)","v":0},"tonnes/year"]
[null,"Daily Waste Throughput in YR 1",null,{"$f":"D25/'8-Default Values'!C16","v":0},"tonnes/day"]
[null,"Facility Design Capacity",null,{"$f":"D25*(1+WasteGrowthRate)^'5-Facility Inputs'!D27","v":0},"tonnes/year"]
[null,"Design Capacity Daily Throughput",null,{"$f":"D27/'8-Default Values'!C16","v":0},"tonnes/day"]
[null,"Land Requirement",null,{"$f":"'8-Default Values'!C17*D27","v":0},"ha"]
[null,"Process Water Demand in YR 1 ",null,{"$f":"IF(D27=0,0,'6-Waste Inputs'!$E$35)","v":0},"m3/year"]
[]
[null,"Capital Cost Assumptions",null,null,"Units"]
[null,"Infrastructure and Site Development Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!E33","v":0},"$"]
[null,"Equipment Cost in Investment Year ",null,{"$f":"'7-Economic Inputs'!E34","v":0},"$"]
[null,"VAT",null,{"$f":"D34*'5-Facility Inputs'!D31*VAT","v":0},"$"]
[null,"Land Purchase in Investment Year",null,{"$f":"IF('7-Economic Inputs'!E27=\"Purchase\",LandPurchasePrice*D29,0)","v":0},"$"]
[null,"Ancillary Costs",null,{"$f":"'5-Facility Inputs'!D32","v":0},"$"]
[null,"Capital Cost Contingency",null,{"$f":"'8-Default Values'!C26*(D34+D33)","v":0},"$"]
[null,"Capital Investment",null,{"$f":"SUM(D33:D38)","v":0},"$"]
[null,"Grant Funding",null,{"$f":"IF(D25=0,0,GrantFunding)","v":0},"$"]
[null,"TOTAL NET CAPEX IN INVESTMENT YEAR",null,{"$f":"IF(D39-D40>0, D39-D40, 0)","v":0},"$"]
[]
[null,"Financing Assumptions",null,null,"Units"]
[null,"Total Debt in Investment Year",null,{"$f":"PercentDebt*D41","v":0},"$"]
[null,"Total Equity in Investment Year",null,{"$f":"D41*PercentEquity","v":0},"$"]
[null,"Short-term Debt in Investment Year",null,{"$f":"D34*PercentDebt","v":0},"$"]
[null,"Long-term Debt in Investment Year",null,{"$f":"D44-D46","v":0},"$",null," "]
[]
[null,"Finance New Equipment",null,{"$f":"'7-Economic Inputs'!K48","v":"CHOOSE ONE"}]
[null,"Inflated Composting Equipment Costs"]
[null,"Replacement 1",null,{"$f":"IF(D16=\"N/A\",0,(D34*(((1+InflationRateGeneral)^(D16-InvestmentYear)))))","v":0},"$"]
[null,"Financed Amount",null,{"$f":"IF(D49=\"Yes\",D51*PercentDebt,0)","v":0},"$"]
[null,"Replacement 2",null,{"$f":"IF(D17=\"N/A\",0,(D34*(((1+InflationRateGeneral)^(D17-InvestmentYear)))))","v":0},"$"]
[null,"Financed Amount ",null,{"$f":"IF(D49=\"Yes\",D53*PercentDebt,0)","v":0},"$",null,{"$f":"IF(AND(G48>0,G48<=FacilityLifespan),IF($D$25*(1+WasteGrowthRate)^(G48-1)>$D$27,$D$27,$D$25*(1+WasteGrowthRate)^(G48-1)),0)","v":0}]
[null,"Replacement 3",null,{"$f":"IF(D18=\"N/A\",0,(D34*(((1+InflationRateGeneral)^(D18-InvestmentYear)))))","v":0},"$"]
[null,"Financed Amount",null,{"$f":"IF(D49=\"Yes\",D55*PercentDebt,0)","v":0},"$"]
[]
[null,"Equity IRR",null,{"$f":"IFERROR(IRR(D156:Z156),\"Not Viable\")","v":"Not Viable"}]
[null,"A typical target IRR for an infrastructure project may range between 9% and 15%. If the IRR for the modeled organic waste project falls outside this range, carrying out one or more of the following troubleshooting steps may return a more acceptable IRR:\n• Reduce project expenses such as electricity costs, labor costs, water treatment costs, and land or equipment purchases.\n• Increase project revenue by increasing gate fees, accepting more waste, or raising the price(s) of sellable end product(s).\n• Change project cost of debt and check the interest rate on debt obligations is reasonable.\n• Debt/Equity Ratio: Ensure the debt to equity ratio is reasonable. Is there a way to use more equity to finance a project? "]
[]
[]
[null,"Calendar Year",null,{"$f":"InvestmentYear","v":0},{"$f":"D62+1","v":1},{"$f":"E62+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,{"$f":"X62+1","v":21},{"$f":"Y62+1","v":22}]
[null,"Operating Year",null,{"$f":"IF(D62<OperationsStartYear,0,IF(D62=OperationsStartYear,1,IF(D62>OperationsStartYear,C63+1,IF(D62>=D62+$D$15,0))))","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Waste Assumptions"]
[null,"Available Yard Waste to Composting (tonnes/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),IF(D69>=$D$27,D20,0),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$20, IF(E69>=$D$27, D65, $D$20*(1+WasteGrowthRate)^(E63-1))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Available Food Waste to Composting (tonnes/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),IF(D69>=$D$27,D21,0),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$21, IF(E69>=$D$27, D66, $D$21*(1+WasteGrowthRate)^(E63-1))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Available Manure/Sludge Waste to Composting (tonnes/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),IF(D69>=$D$27,D22,0),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$22, IF(E69>=$D$27, D67, $D$22*(1+WasteGrowthRate)^(E63-1))),0)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$22, IF(F69>=$D$27, E67, $D$22*(1+WasteGrowthRate)^(F63-1))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Available Mixed Paper & Cardboard",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$23, IF(D69>=$D$27, C68, $D$23*(1+WasteGrowthRate)^(D64-1))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"HIDDEN - TOTAL AVAILABLE WASTE TO COMPOSTING (for facility max check)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$25*(1+WasteGrowthRate)^(D63-1),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),$D$25*(1+WasteGrowthRate)^(E63-1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Available Waste to Composting (tonnes/year)",null,{"$f":"IF(D69<=$D$27, SUM(D65:D67), C70)","v":0},{"$f":"IF(E69<=$D$27, SUM(E65:E68), D70)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan),IF($D$25*(1+WasteGrowthRate)^(F63-1)>$D$27,$D$27,$D$25*(1+WasteGrowthRate)^(F63-1)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Purchased Bulking Agent to Composting (tonnes/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$24*(1+WasteGrowthRate)^(D63-1),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$24, IF(E69>=$D$27, D71, $D$24*(1+WasteGrowthRate)^(E63-1))),0)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan),IF(WasteGrowthRate=0, $D$24, IF(F69>=$D$27, E71, $D$24*(1+WasteGrowthRate)^(F63-1))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Available Waste to Composting (tonnes/year)",null,{"$f":"D70+D71","v":0},{"$f":"E70+E71","v":0},{"$f":"F70+F71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Primary Screening Residues (tonnes/year)",null,{"$f":"D72*'8-Default Values'!$C$20","v":0},{"$f":"E72*'8-Default Values'!$C$20","v":0},{"$f":"F72*'8-Default Values'!$C$20","v":0},{"$f":"G72*'8-Default Values'!$C$20","v":0},{"$f":"H72*'8-Default Values'!$C$20","v":0},{"$f":"I72*'8-Default Values'!$C$20","v":0},{"$f":"J72*'8-Default Values'!$C$20","v":0},{"$f":"K72*'8-Default Values'!$C$20","v":0},{"$f":"L72*'8-Default Values'!$C$20","v":0},{"$f":"M72*'8-Default Values'!$C$20","v":0},{"$f":"N72*'8-Default Values'!$C$20","v":0},{"$f":"O72*'8-Default Values'!$C$20","v":0},{"$f":"P72*'8-Default Values'!$C$20","v":0},{"$f":"Q72*'8-Default Values'!$C$20","v":0},{"$f":"R72*'8-Default Values'!$C$20","v":0},{"$f":"S72*'8-Default Values'!$C$20","v":0},{"$f":"T72*'8-Default Values'!$C$20","v":0},{"$f":"U72*'8-Default Values'!$C$20","v":0},{"$f":"V72*'8-Default Values'!$C$20","v":0},{"$f":"W72*'8-Default Values'!$C$20","v":0},{"$f":"X72*'8-Default Values'!$C$20","v":0},{"$f":"Y72*'8-Default Values'!$C$20","v":0},{"$f":"Z72*'8-Default Values'!$C$20","v":0}]
[null,"Compost Produced (tonnes/year)",null,{"$f":"(D72-D73)*'8-Default Values'!$C$21","v":0},{"$f":"(E72-E73)*'8-Default Values'!$C$21","v":0},{"$f":"(F72-F73)*'8-Default Values'!$C$21","v":0},{"$f":"(G72-G73)*'8-Default Values'!$C$21","v":0},{"$f":"(H72-H73)*'8-Default Values'!$C$21","v":0},{"$f":"(I72-I73)*'8-Default Values'!$C$21","v":0},{"$f":"(J72-J73)*'8-Default Values'!$C$21","v":0},{"$f":"(K72-K73)*'8-Default Values'!$C$21","v":0},{"$f":"(L72-L73)*'8-Default Values'!$C$21","v":0},{"$f":"(M72-M73)*'8-Default Values'!$C$21","v":0},{"$f":"(N72-N73)*'8-Default Values'!$C$21","v":0},{"$f":"(O72-O73)*'8-Default Values'!$C$21","v":0},{"$f":"(P72-P73)*'8-Default Values'!$C$21","v":0},{"$f":"(Q72-Q73)*'8-Default Values'!$C$21","v":0},{"$f":"(R72-R73)*'8-Default Values'!$C$21","v":0},{"$f":"(S72-S73)*'8-Default Values'!$C$21","v":0},{"$f":"(T72-T73)*'8-Default Values'!$C$21","v":0},{"$f":"(U72-U73)*'8-Default Values'!$C$21","v":0},{"$f":"(V72-V73)*'8-Default Values'!$C$21","v":0},{"$f":"(W72-W73)*'8-Default Values'!$C$21","v":0},{"$f":"(X72-X73)*'8-Default Values'!$C$21","v":0},{"$f":"(Y72-Y73)*'8-Default Values'!$C$21","v":0},{"$f":"(Z72-Z73)*'8-Default Values'!$C$21","v":0}]
[null,"Final Screening Residues (tonnes/year)",null,{"$f":"(D72-D73)*'8-Default Values'!$C$22","v":0},{"$f":"(E72-E73)*'8-Default Values'!$C$22","v":0},{"$f":"(F72-F73)*'8-Default Values'!$C$22","v":0},{"$f":"(G72-G73)*'8-Default Values'!$C$22","v":0},{"$f":"(H72-H73)*'8-Default Values'!$C$22","v":0},{"$f":"(I72-I73)*'8-Default Values'!$C$22","v":0},{"$f":"(J72-J73)*'8-Default Values'!$C$22","v":0},{"$f":"(K72-K73)*'8-Default Values'!$C$22","v":0},{"$f":"(L72-L73)*'8-Default Values'!$C$22","v":0},{"$f":"(M72-M73)*'8-Default Values'!$C$22","v":0},{"$f":"(N72-N73)*'8-Default Values'!$C$22","v":0},{"$f":"(O72-O73)*'8-Default Values'!$C$22","v":0},{"$f":"(P72-P73)*'8-Default Values'!$C$22","v":0},{"$f":"(Q72-Q73)*'8-Default Values'!$C$22","v":0},{"$f":"(R72-R73)*'8-Default Values'!$C$22","v":0},{"$f":"(S72-S73)*'8-Default Values'!$C$22","v":0},{"$f":"(T72-T73)*'8-Default Values'!$C$22","v":0},{"$f":"(U72-U73)*'8-Default Values'!$C$22","v":0},{"$f":"(V72-V73)*'8-Default Values'!$C$22","v":0},{"$f":"(W72-W73)*'8-Default Values'!$C$22","v":0},{"$f":"(X72-X73)*'8-Default Values'!$C$22","v":0},{"$f":"(Y72-Y73)*'8-Default Values'!$C$22","v":0},{"$f":"(Z72-Z73)*'8-Default Values'!$C$22","v":0}]
[null,"Total Waste to Landfill (tonnes/year)",null,{"$f":"D73+D75","v":0},{"$f":"E73+E75","v":0},{"$f":"F73+F75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Waste Diverted from Landfill (tonnes/year)",null,{"$f":"D69-D73","v":0},{"$f":"E69-E73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operating Assumptions "]
[null,"Compost Sold (tonnes/year)",null,{"$f":"IF(D63=1,D74*'5-Facility Inputs'!$D$28,IF(D63=2,D74*'5-Facility Inputs'!$D$29,IF(D63>=3,D74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(E63=1,E74*'5-Facility Inputs'!$D$28,IF(E63=2,E74*'5-Facility Inputs'!$D$29,IF(E63>=3,E74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(F63=1,F74*'5-Facility Inputs'!$D$28,IF(F63=2,F74*'5-Facility Inputs'!$D$29,IF(F63>=3,F74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(G63=1,G74*'5-Facility Inputs'!$D$28,IF(G63=2,G74*'5-Facility Inputs'!$D$29,IF(G63>=3,G74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(H63=1,H74*'5-Facility Inputs'!$D$28,IF(H63=2,H74*'5-Facility Inputs'!$D$29,IF(H63>=3,H74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(I63=1,I74*'5-Facility Inputs'!$D$28,IF(I63=2,I74*'5-Facility Inputs'!$D$29,IF(I63>=3,I74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(J63=1,J74*'5-Facility Inputs'!$D$28,IF(J63=2,J74*'5-Facility Inputs'!$D$29,IF(J63>=3,J74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(K63=1,K74*'5-Facility Inputs'!$D$28,IF(K63=2,K74*'5-Facility Inputs'!$D$29,IF(K63>=3,K74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(L63=1,L74*'5-Facility Inputs'!$D$28,IF(L63=2,L74*'5-Facility Inputs'!$D$29,IF(L63>=3,L74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(M63=1,M74*'5-Facility Inputs'!$D$28,IF(M63=2,M74*'5-Facility Inputs'!$D$29,IF(M63>=3,M74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(N63=1,N74*'5-Facility Inputs'!$D$28,IF(N63=2,N74*'5-Facility Inputs'!$D$29,IF(N63>=3,N74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(O63=1,O74*'5-Facility Inputs'!$D$28,IF(O63=2,O74*'5-Facility Inputs'!$D$29,IF(O63>=3,O74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(P63=1,P74*'5-Facility Inputs'!$D$28,IF(P63=2,P74*'5-Facility Inputs'!$D$29,IF(P63>=3,P74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(Q63=1,Q74*'5-Facility Inputs'!$D$28,IF(Q63=2,Q74*'5-Facility Inputs'!$D$29,IF(Q63>=3,Q74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(R63=1,R74*'5-Facility Inputs'!$D$28,IF(R63=2,R74*'5-Facility Inputs'!$D$29,IF(R63>=3,R74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(S63=1,S74*'5-Facility Inputs'!$D$28,IF(S63=2,S74*'5-Facility Inputs'!$D$29,IF(S63>=3,S74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(T63=1,T74*'5-Facility Inputs'!$D$28,IF(T63=2,T74*'5-Facility Inputs'!$D$29,IF(T63>=3,T74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(U63=1,U74*'5-Facility Inputs'!$D$28,IF(U63=2,U74*'5-Facility Inputs'!$D$29,IF(U63>=3,U74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(V63=1,V74*'5-Facility Inputs'!$D$28,IF(V63=2,V74*'5-Facility Inputs'!$D$29,IF(V63>=3,V74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(W63=1,W74*'5-Facility Inputs'!$D$28,IF(W63=2,W74*'5-Facility Inputs'!$D$29,IF(W63>=3,W74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(X63=1,X74*'5-Facility Inputs'!$D$28,IF(X63=2,X74*'5-Facility Inputs'!$D$29,IF(X63>=3,X74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(Y63=1,Y74*'5-Facility Inputs'!$D$28,IF(Y63=2,Y74*'5-Facility Inputs'!$D$29,IF(Y63>=3,Y74*'5-Facility Inputs'!$D$30,0)))","v":0},{"$f":"IF(Z63=1,Z74*'5-Facility Inputs'!$D$28,IF(Z63=2,Z74*'5-Facility Inputs'!$D$29,IF(Z63>=3,Z74*'5-Facility Inputs'!$D$30,0)))","v":0}]
[null,"Compost Gifted (tonnes/year)",null,{"$f":"D74-D79","v":0},{"$f":"E74-E79","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Consumption (kWh/year)",null,{"$f":"(D72*'8-Default Values'!$C$18)","v":0},{"$f":"(E72*'8-Default Values'!$C$18)","v":0},{"$f":"(F72*'8-Default Values'!$C$18)","v":0},{"$f":"(G72*'8-Default Values'!$C$18)","v":0},{"$f":"(H72*'8-Default Values'!$C$18)","v":0},{"$f":"(I72*'8-Default Values'!$C$18)","v":0},{"$f":"(J72*'8-Default Values'!$C$18)","v":0},{"$f":"(K72*'8-Default Values'!$C$18)","v":0},{"$f":"(L72*'8-Default Values'!$C$18)","v":0},{"$f":"(M72*'8-Default Values'!$C$18)","v":0},{"$f":"(N72*'8-Default Values'!$C$18)","v":0},{"$f":"(O72*'8-Default Values'!$C$18)","v":0},{"$f":"(P72*'8-Default Values'!$C$18)","v":0},{"$f":"(Q72*'8-Default Values'!$C$18)","v":0},{"$f":"(R72*'8-Default Values'!$C$18)","v":0},{"$f":"(S72*'8-Default Values'!$C$18)","v":0},{"$f":"(T72*'8-Default Values'!$C$18)","v":0},{"$f":"(U72*'8-Default Values'!$C$18)","v":0},{"$f":"(V72*'8-Default Values'!$C$18)","v":0},{"$f":"(W72*'8-Default Values'!$C$18)","v":0},{"$f":"(X72*'8-Default Values'!$C$18)","v":0},{"$f":"(Y72*'8-Default Values'!$C$18)","v":0},{"$f":"(Z72*'8-Default Values'!$C$18)","v":0}]
[null,"Diesel Consumption (liters/year)",null,{"$f":"(D72*'8-Default Values'!$C$19)","v":0},{"$f":"(E72*'8-Default Values'!$C$19)","v":0},{"$f":"(F72*'8-Default Values'!$C$19)","v":0},{"$f":"(G72*'8-Default Values'!$C$19)","v":0},{"$f":"(H72*'8-Default Values'!$C$19)","v":0},{"$f":"(I72*'8-Default Values'!$C$19)","v":0},{"$f":"(J72*'8-Default Values'!$C$19)","v":0},{"$f":"(K72*'8-Default Values'!$C$19)","v":0},{"$f":"(L72*'8-Default Values'!$C$19)","v":0},{"$f":"(M72*'8-Default Values'!$C$19)","v":0},{"$f":"(N72*'8-Default Values'!$C$19)","v":0},{"$f":"(O72*'8-Default Values'!$C$19)","v":0},{"$f":"(P72*'8-Default Values'!$C$19)","v":0},{"$f":"(Q72*'8-Default Values'!$C$19)","v":0},{"$f":"(R72*'8-Default Values'!$C$19)","v":0},{"$f":"(S72*'8-Default Values'!$C$19)","v":0},{"$f":"(T72*'8-Default Values'!$C$19)","v":0},{"$f":"(U72*'8-Default Values'!$C$19)","v":0},{"$f":"(V72*'8-Default Values'!$C$19)","v":0},{"$f":"(W72*'8-Default Values'!$C$19)","v":0},{"$f":"(X72*'8-Default Values'!$C$19)","v":0},{"$f":"(Y72*'8-Default Values'!$C$19)","v":0},{"$f":"(Z72*'8-Default Values'!$C$19)","v":0}]
[null,"Process Water Consumption (m3/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$30*(1+WasteGrowthRate)^(D63-1),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),$D$30*(1+WasteGrowthRate)^(E63-1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Number of Managers/Engineers",null,{"$f":"TotalNumberofEngineers","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Number of Operators",null,{"$f":"TotalNumberofOperators","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Economic Assumptions"]
[null,"Compost Sale Price ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$8*(1+InflationRateCompostDigestateBulking)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Yard Waste ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$9*(1+InflationRateDisposalGate)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Food Waste ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$10*(1+InflationRateDisposalGate)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Manure/Sludge Waste ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$11*(1+InflationRateDisposalGate)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Paper/Cardboard ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),$D$12*(1+InflationRateDisposalGate)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Landfill Disposal Fee ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),AvoidedLandfillDisposalFee*(1+InflationRateDisposalGate)^(D62-$D$62),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),AvoidedLandfillDisposalFee*(1+InflationRateDisposalGate)^(E62-$D$62),0)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan),AvoidedLandfillDisposalFee*(1+InflationRateDisposalGate)^(F62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fee ($/tonne/km)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),TransportationFee*(1+InflationRateDisposalGate)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Electricity Purchase Price ($/kWh)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),(ElectricityPrice*((1+InflationRateElectricityFuel)^(D62-$D$62))),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan),(ElectricityPrice*((1+InflationRateElectricityFuel)^(E62-$D$62))),0)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan),(ElectricityPrice*((1+InflationRateElectricityFuel)^(F62-$D$62))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Purchase Price ($/liter)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),(DieselPrice*((1+InflationRateElectricityFuel)^(D62-$D$62))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Transportation ($/tonne/km)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),TransportationFee*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Disposal ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),ResidualDisposalFee*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Price ($/ha/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),LandLeasePrice*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Managers - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),LaborManager*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operators - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),LaborOperator*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Process Water Fee ($/m3)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),WaterPurchasePrice*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),BulkingAgentCost*(1+InflationRateCompostDigestateBulking)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Land Application Cost ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),CompostLandAppCost*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Transportation Cost ($/tonne)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan),CompostTransportCost*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual Maintenance Cost ($/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan,D62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan,E62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(E62-$D$62),0)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan,F62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(F62-$D$62),0)","v":0},{"$f":"IF(AND(G63>0,G63<=FacilityLifespan,G62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(G62-$D$62),0)","v":0},{"$f":"IF(AND(H63>0,H63<=FacilityLifespan,H62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(H62-$D$62),0)","v":0},{"$f":"IF(AND(I63>0,I63<=FacilityLifespan,I62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(I62-$D$62),0)","v":0},{"$f":"IF(AND(J63>0,J63<=FacilityLifespan,J62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(J62-$D$62),0)","v":0},{"$f":"IF(AND(K63>0,K63<=FacilityLifespan,K62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(K62-$D$62),0)","v":0},{"$f":"IF(AND(L63>0,L63<=FacilityLifespan,L62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(L62-$D$62),0)","v":0},{"$f":"IF(AND(M63>0,M63<=FacilityLifespan,M62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(M62-$D$62),0)","v":0},{"$f":"IF(AND(N63>0,N63<=FacilityLifespan,N62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(N62-$D$62),0)","v":0},{"$f":"IF(AND(O63>0,O63<=FacilityLifespan,O62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(O62-$D$62),0)","v":0},{"$f":"IF(AND(P63>0,P63<=FacilityLifespan,P62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(P62-$D$62),0)","v":0},{"$f":"IF(AND(Q63>0,Q63<=FacilityLifespan,Q62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(Q62-$D$62),0)","v":0},{"$f":"IF(AND(R63>0,R63<=FacilityLifespan,R62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(R62-$D$62),0)","v":0},{"$f":"IF(AND(S63>0,S63<=FacilityLifespan,S62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(S62-$D$62),0)","v":0},{"$f":"IF(AND(T63>0,T63<=FacilityLifespan,T62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(T62-$D$62),0)","v":0},{"$f":"IF(AND(U63>0,U63<=FacilityLifespan,U62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(U62-$D$62),0)","v":0},{"$f":"IF(AND(V63>0,V63<=FacilityLifespan,V62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(V62-$D$62),0)","v":0},{"$f":"IF(AND(W63>0,W63<=FacilityLifespan,W62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(W62-$D$62),0)","v":0},{"$f":"IF(AND(X63>0,X63<=FacilityLifespan,X62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(X62-$D$62),0)","v":0},{"$f":"IF(AND(Y63>0,Y63<=FacilityLifespan,Y62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(Y62-$D$62),0)","v":0},{"$f":"IF(AND(Z63>0,Z63<=FacilityLifespan,Z62>=MaintenanceBegins),$D$39*'8-Default Values'!$C$28*(1+InflationRateGeneral)^(Z62-$D$62),0)","v":0}]
[null,"Annual Insurance Cost ($/year)",null,{"$f":"IF(AND(D63>0,D63<=FacilityLifespan,D62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},{"$f":"IF(AND(E63>0,E63<=FacilityLifespan,E62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(E62-$D$62),0)","v":0},{"$f":"IF(AND(F63>0,F63<=FacilityLifespan,F62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(F62-$D$62),0)","v":0},{"$f":"IF(AND(G63>0,G63<=FacilityLifespan,G62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(G62-$D$62),0)","v":0},{"$f":"IF(AND(H63>0,H63<=FacilityLifespan,H62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(H62-$D$62),0)","v":0},{"$f":"IF(AND(I63>0,I63<=FacilityLifespan,I62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(I62-$D$62),0)","v":0},{"$f":"IF(AND(J63>0,J63<=FacilityLifespan,J62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(J62-$D$62),0)","v":0},{"$f":"IF(AND(K63>0,K63<=FacilityLifespan,K62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(K62-$D$62),0)","v":0},{"$f":"IF(AND(L63>0,L63<=FacilityLifespan,L62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(L62-$D$62),0)","v":0},{"$f":"IF(AND(M63>0,M63<=FacilityLifespan,M62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(M62-$D$62),0)","v":0},{"$f":"IF(AND(N63>0,N63<=FacilityLifespan,N62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(N62-$D$62),0)","v":0},{"$f":"IF(AND(O63>0,O63<=FacilityLifespan,O62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(O62-$D$62),0)","v":0},{"$f":"IF(AND(P63>0,P63<=FacilityLifespan,P62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(P62-$D$62),0)","v":0},{"$f":"IF(AND(Q63>0,Q63<=FacilityLifespan,Q62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(Q62-$D$62),0)","v":0},{"$f":"IF(AND(R63>0,R63<=FacilityLifespan,R62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(R62-$D$62),0)","v":0},{"$f":"IF(AND(S63>0,S63<=FacilityLifespan,S62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(S62-$D$62),0)","v":0},{"$f":"IF(AND(T63>0,T63<=FacilityLifespan,T62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(T62-$D$62),0)","v":0},{"$f":"IF(AND(U63>0,U63<=FacilityLifespan,U62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(U62-$D$62),0)","v":0},{"$f":"IF(AND(V63>0,V63<=FacilityLifespan,V62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(V62-$D$62),0)","v":0},{"$f":"IF(AND(W63>0,W63<=FacilityLifespan,W62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(W62-$D$62),0)","v":0},{"$f":"IF(AND(X63>0,X63<=FacilityLifespan,X62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(X62-$D$62),0)","v":0},{"$f":"IF(AND(Y63>0,Y63<=FacilityLifespan,Y62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(Y62-$D$62),0)","v":0},{"$f":"IF(AND(Z63>0,Z63<=FacilityLifespan,Z62>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$C$29*(1+InflationRateGeneral)^(Z62-$D$62),0)","v":0}]
[]
[null,"Consolidated Profit and Loss"]
[null,"Compost Sales ($/year)",null,{"$f":"D88*D79","v":0},{"$f":"E88*E79","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Yard Waste ($/year)",null,{"$f":"D89*D65","v":0},0,{"$f":"F89*F70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Food Waste ($/tonne)",null,0,0,{"$f":"F90*F66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Manure/Sludge Waste ($/tonne)",null,0,0,{"$f":"F91*F67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Paper/Cardboard ($/year)",null,0,0,{"$f":"F92*F70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Avoided Landfill Disposal Fees ($/year)",null,{"$f":"D93*D70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fees ($/year)",null,{"$f":"(DistanceGeneratorsToLandfill-DistanceGeneratorsToOrganicsFacility)*D94*D70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Land Sale at End of Project Life ($/year)",null,{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",D62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(D62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",E62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(E62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",F62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(F62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",G62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(G62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",H62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(H62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",I62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(I62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",J62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(J62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",K62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(K62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",L62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(L62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",M62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(M62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",N62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(N62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",O62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(O62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",P62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(P62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",Q62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(Q62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",R62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(R62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",S62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(S62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",T62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(T62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",U62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(U62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",V62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(V62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",W62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(W62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",X62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(X62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",Y62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(Y62-$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",Z62=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^(Z62-$D$62),0)","v":0}]
[null,"Composting Equipment Sale at End of Project Life ($/year)",null,{"$f":"IF(D63=FacilityLifespan,SUM($D$172:$D$175),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Revenues ($/year)",null,{"$f":"SUM(D111:D120)","v":0},{"$f":"SUM(E111:E120)","v":0},{"$f":"SUM(F111:F120)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Costs ($/year)",null,{"$f":"D96*D81","v":0},{"$f":"E96*E81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Costs ($/year)",null,{"$f":"D97*D82","v":0},{"$f":"E97*E82","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Transportation Cost ($/year)",null,{"$f":"D98*D76*DistanceOrganicsFacilityToLandfill","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Disposal Cost ($/year)",null,{"$f":"D99*D76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Cost ($/year)",null,{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(D100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(E100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(F100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(G100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(H100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(I100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(J100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(K100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(L100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(M100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(N100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(O100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(P100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(Q100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(R100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(S100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(T100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(U100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(V100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(W100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(X100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(Y100*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(Z100*$D$29),0)","v":0}]
[null,"Labor Cost ($/year)",null,{"$f":"(D101*D84)+(D85*D102)","v":0},{"$f":"(E101*E84)+(E85*E102)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Process Water Cost ($/year)",null,{"$f":"D103*D83","v":0},0,{"$f":"F103*F83","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/year)",null,{"$f":"D104*D71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Land Application Cost ($/year)",null,{"$f":"D105*D74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Transportation Cost ($/year)",null,{"$f":"D106*D74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance Costs ($/year)",null,{"$f":"D107","v":0},{"$f":"E107","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Insurance Costs ($/year)",null,{"$f":"D108","v":0},{"$f":"E108","v":0},0,{"$f":"G108","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Outside Services and Supplies ($/year)",null,{"$f":"'8-Default Values'!$C$30*SUM(D122:D133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(E122:E133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(F122:F133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(G122:G133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(H122:H133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(I122:I133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(J122:J133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(K122:K133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(L122:L133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(M122:M133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(N122:N133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(O122:O133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(P122:P133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(Q122:Q133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(R122:R133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(S122:S133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(T122:T133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(U122:U133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(V122:V133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(W122:W133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(X122:X133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(Y122:Y133)","v":0},{"$f":"'8-Default Values'!$C$30*SUM(Z122:Z133)","v":0}]
[null,"Operating Cost Contingency ($/year)",null,{"$f":"SUM(D122:D134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(E122:E134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(F122:F134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(G122:G134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(H122:H134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(I122:I134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(J122:J134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(K122:K134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(L122:L134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(M122:M134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(N122:N134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(O122:O134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(P122:P134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(Q122:Q134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(R122:R134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(S122:S134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(T122:T134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(U122:U134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(V122:V134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(W122:W134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(X122:X134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(Y122:Y134)*'8-Default Values'!$C$31","v":0},{"$f":"SUM(Z122:Z134)*'8-Default Values'!$C$31","v":0}]
[null,"Cost of Goods Sold",null,{"$f":"SUM(D122:D134)+D143","v":0},{"$f":"SUM(E122:E134)+E143","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenses ($/year)",null,{"$f":"SUM(D122:D135)","v":0},{"$f":"SUM(E122:E135)","v":0},0,{"$f":"SUM(G122:G135)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total O&M/tonne of Waste Processed",null,{"$f":"IF(D137=0,0,IF(D63>0,D137/D72,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Adjusted COGS ($/year)",null,{"$f":"D136","v":0},{"$f":"E136","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Adjusted Expenses ($/year)",null,{"$f":"D137","v":0},{"$f":"E137","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross Profit",null,{"$f":"SUM(D111:D115)-D139","v":0},{"$f":"SUM(E111:E115)-E139","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBITDA",null,{"$f":"D121-D140","v":0},{"$f":"E121-E140","v":0},0,0,{"$f":"H121-H140","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation",null,{"$f":"D169","v":0},{"$f":"E169","v":0},{"$f":"F169","v":0},{"$f":"G169","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y169","v":0},{"$f":"Z169","v":0}]
[null,"EBIT",null,{"$f":"D142-D143","v":0},{"$f":"E142-E143","v":0},{"$f":"F142-F143","v":0},0,{"$f":"H142-H143","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y142-Y143","v":0},{"$f":"Z142-Z143","v":0}]
[]
[null,"Operating Cash Flow"]
[null,"EBIT",null,{"$f":"D144","v":0},{"$f":"E144","v":0},{"$f":"F144","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"X144","v":0},{"$f":"Y144","v":0},{"$f":"Z144","v":0}]
[null,"Taxes",null,{"$f":"IF(D141>0,-D141*Tax,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBIAT (After Tax EBIT)",null,{"$f":"D147+D148","v":0},{"$f":"E147+E148","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y147+Y148","v":0},{"$f":"Z147+Z148","v":0}]
[null,"Depreciation",null,{"$f":"D169","v":0},{"$f":"E169","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operating Cash Flow",null,{"$f":"D149+D150","v":0},{"$f":"E149+E150","v":0},{"$f":"F149+F150","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y149+Y150","v":0},{"$f":"Z149+Z150","v":0}]
[null,"Debt Service",null,{"$f":"-D222","v":0},{"$f":"-E222","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-S222","v":0},0,0,0,0,0,{"$f":"-Y222","v":0},{"$f":"-Z222","v":0}]
[null,"Initial Equity ",null,{"$f":"IF(D62=InvestmentYear,$D$45,0)","v":0},{"$f":"-IF(E62=InvestmentYear,$D$45,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Initial Debt",null,{"$f":"IF(D62=InvestmentYear,$D$44,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"New Debt for Equipment Replacement",null,{"$f":"IF(AND(D62=$D$16,$D$49=\"Yes\"),$D$52,IF(AND(D62=$D$17,$D$49=\"Yes\"),$D$54,IF(AND(D62=$D$18,$D$49=\"Yes\"),$D$56,0)))","v":0},{"$f":"IF(AND(E62=$D$16,$D$49=\"Yes\"),$D$52,IF(AND(E62=$D$17,$D$49=\"Yes\"),$D$54,IF(AND(E62=$D$18,$D$49=\"Yes\"),$D$56,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Levered Free Cash Flow",null,{"$f":"(-D153)+D151+(-D222)","v":0},{"$f":"(-E153)+E151+(-E222)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Capex and Depreciation Schedule"]
[null,"Infrastructure and Site Development Investment",null,{"$f":"IF(D62=InvestmentYear,$D$33,0)","v":0},0,{"$f":"IF(F62=InvestmentYear,$D$33,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Equipment Investment",null,{"$f":"IF(D62=InvestmentYear,$D$34,0)","v":0},{"$f":"IF(E62=InvestmentYear,$D$34,0)","v":0},{"$f":"IF(F62=InvestmentYear,$D$34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"New Equipment Capex",null,{"$f":"IF(D62=$D$16,$D$51,IF(D62=$D$17,$D$53,IF(D62=$D$18,$D$55,0)))","v":0},{"$f":"IF(E62=$D$16,$D$51,IF(E62=$D$17,$D$53,IF(E62=$D$18,$D$55,0)))","v":0},{"$f":"IF(F62=$D$16,$D$51,IF(F62=$D$17,$D$53,IF(F62=$D$18,$D$55,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation - Infrastructure and Site Development",null,null,{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,E63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,F63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,G63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,H63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,I63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,J63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,K63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,L63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,M63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,N63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,O63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,P63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,Q63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,R63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,S63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,T63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,U63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,V63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,W63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,X63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,Y63)),0)","v":0},{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,Z63)),0)","v":0}]
[null,"Depreciation - Composting Equipment",null,null,{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$161,SalvageValue,DepreciationComposting),SYD($D$161,SalvageValue,DepreciationComposting,E63)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation Initial Investment",null,null,{"$f":"E163+E164","v":0},{"$f":"F163+F164","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation New Capex - Composting Equipment Replacement 1",null,null,{"$f":"IF($D$16=\"N/A\",0,IF(AND(E62>=$D$16,E62<$D$17,E63<=FacilityLifespan),IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$51,SalvageValue,DepreciationComposting),SYD($D$51,SalvageValue,DepreciationComposting,E63)),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation New Capex - Composting Equipment Replacement 2",null,null,{"$f":"IF($D$16=\"N/A\",0,IF(AND(E63>=$D$16,E63<$D$17,E63<=FacilityLifespan),IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$53,SalvageValue,DepreciationComposting),SYD($D$53,SalvageValue,DepreciationComposting,E63)),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation New Capex - Composting Equipment Replacement 3",null,null,{"$f":"IF($D$16=\"N/A\",0,IF(AND(E63>=$D$16,E63<$D$17,E63<=FacilityLifespan),IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$55,SalvageValue,DepreciationComposting),SYD($D$55,SalvageValue,DepreciationComposting,E63)),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Depreciation",null,null,{"$f":"SUM(E165:E168)","v":0},{"$f":"SUM(F165:F168)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Composting Equipment Sale at End of Project Life"]
[null,"Initial Equipment",null,{"$f":"IF(SUM(E164:Z164)=D34,0,D34-SUM(E164:Z164))","v":0}]
[null,"Equipment Replacement 1",null,{"$f":"IF(SUM(E166:Z166)=D51,0,D51-SUM(E166:Z166))","v":0}]
[null,"Equipment Replacement 2",null,{"$f":"IF(SUM(E167:Z167)=D53,0,D53-SUM(E167:Z167))","v":0}]
[null,"Equipment Replacement 3",null,{"$f":"IF(SUM(E168:Z168)=D55,0,D55-SUM(E168:Z168))","v":0}]
[]
[null,"Financing"]
[null,"Short-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D62<OperationsStartYear,0,IF(D62=OperationsStartYear,$D$46,C183))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D63,TenorShortTermDebt,$D$46)),0,(-IPMT(InterestRateShortTermDebt,D63,TenorShortTermDebt,$D$46)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D63,TenorShortTermDebt,$D$46)),0,(-PPMT(InterestRateShortTermDebt,D63,TenorShortTermDebt,$D$46)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D180+D181","v":0},{"$f":"E180+E181","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y180+Y181","v":0},{"$f":"Z180+Z181","v":0}]
[null,"EOY Balance",null,{"$f":"D179-D181","v":0},{"$f":"E179-E181","v":0},{"$f":"F179-F181","v":0},0,0,0,0,0,0,0,{"$f":"N179-N181","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Y179-Y181","v":0},{"$f":"Z179-Z181","v":0}]
[]
[null,"Long-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D62<OperationsStartYear,0,IF(D62=OperationsStartYear,$D$47,C190))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateLongTermDebt,D63,TenorLongTermDebt,$D$47)),0,(-IPMT(InterestRateLongTermDebt,D63,TenorLongTermDebt,$D$47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateLongTermDebt,D63,TenorLongTermDebt,$D$47)),0,(-PPMT(InterestRateLongTermDebt,D63,TenorLongTermDebt,$D$47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D187+D188","v":0},{"$f":"E187+E188","v":0},{"$f":"F187+F188","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y187+Y188","v":0},{"$f":"Z187+Z188","v":0}]
[null,"EOY Balance",null,{"$f":"D186-D188","v":0},{"$f":"E186-E188","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y186-Y188","v":0},{"$f":"Z186-Z188","v":0}]
[]
[null,"DO NOT DELETE",null,{"$f":"IF($D$16=\"N/A\",0,IF(D62=$D$16,1,IF(D62<$D$16,0,IF(AND(D62>$D$16,D63<=FacilityLifespan),C192+1,0))))","v":0},0,0,0,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,0,0,0]
[null,"Debt Tenor",null,{"$f":"IF(D16=\"N/A\",\"N/A\",IF(OperationsStartYear+FacilityLifespan-D16<TenorShortTermDebt,OperationsStartYear+FacilityLifespan-D16,TenorShortTermDebt))","v":0}]
[null,"Replacement Equipment 1 - Composting"]
[null,"BOY Balance",null,{"$f":"IF(D192=1,$D$52,C199)","v":0},0,0,0,0,0,0,{"$f":"IF(K192=1,$D$52,J199)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D192,$D$193,$D$52)),0,(-IPMT(InterestRateShortTermDebt,D192,$D$193,$D$52)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D192,$D$193,$D$52)),0,(-PPMT(InterestRateShortTermDebt,D192,$D$193,$D$52)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D196+D197","v":0},{"$f":"E196+E197","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y196+Y197","v":0},{"$f":"Z196+Z197","v":0}]
[null,"EOY Balance",null,{"$f":"D195-D197","v":0},{"$f":"E195-E197","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y195-Y197","v":0},{"$f":"Z195-Z197","v":0}]
[]
[null,"DO NOT DELETE",null,{"$f":"IF($D$17=\"N/A\",0,IF(D62=$D$17,1,IF(D62<$D$17,0,IF(AND(D62>$D$17,D63<=FacilityLifespan),C201+1,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,3,4,5,6,0,0,0]
[null,"Debt Tenor",null,{"$f":"IF(D17=\"N/A\",\"N/A\",IF(OperationsStartYear+FacilityLifespan-D17<TenorShortTermDebt,OperationsStartYear+FacilityLifespan-D17,TenorShortTermDebt))","v":0}]
[null,"Replacement Equipment 2 - Composting"]
[null,"BOY Balance",null,{"$f":"IF(D201=1,$D$54,C208)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Q201=1,$D$54,P208)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D201,$D$202,$D$54)),0,(-IPMT(InterestRateShortTermDebt,D201,$D$202,$D$54)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D201,$D$202,$D$54)),0,(-PPMT(InterestRateShortTermDebt,D201,$D$202,$D$54)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D205+D206","v":0},{"$f":"E205+E206","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y205+Y206","v":0},{"$f":"Z205+Z206","v":0}]
[null,"EOY Balance",null,{"$f":"D204-D206","v":0},{"$f":"E204-E206","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y204-Y206","v":0},{"$f":"Z204-Z206","v":0}]
[]
[null,"DO NOT DELETE",null,{"$f":"IF($D$18=\"N/A\",0,IF(D62=$D$18,1,IF(D62<$D$18,0,IF(AND(D62>$D$18,D63<=FacilityLifespan),C210+1,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt Tenor",null,{"$f":"IF(D18=\"N/A\",\"N/A\",IF(OperationsStartYear+FacilityLifespan-D18<TenorShortTermDebt,OperationsStartYear+FacilityLifespan-D18,TenorShortTermDebt))","v":"N/A"}]
[null,"Replacement Equipment 3 - Composting"]
[null,"BOY Balance",null,{"$f":"IF(D210=1,$D$56,C217)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(W210=1,$D$56,V217)","v":0},{"$f":"IF(X210=1,$D$56,W217)","v":0},0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D210,$D$211,$D$56)),0,(-IPMT(InterestRateShortTermDebt,D210,$D$211,$D$56)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D210,$D$211,$D$56)),0,(-PPMT(InterestRateShortTermDebt,D210,$D$211,$D$56)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D214+D215","v":0},{"$f":"E214+E215","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y214+Y215","v":0},{"$f":"Z214+Z215","v":0}]
[null,"EOY Balance",null,{"$f":"D213-D215","v":0},{"$f":"E213-E215","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y213-Y215","v":0},{"$f":"Z213-Z215","v":0}]
[]
[null,"Summary"]
[null,"Interest Payment",null,{"$f":"D180+D187+D196+D205+D214","v":0},{"$f":"E180+E187+E196+E205+E214","v":0},{"$f":"F180+F187+F196+F205+F214","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"D181+D188+D197+D206+D215","v":0},{"$f":"E181+E188+E197+E206+E215","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D182+D189+D198+D207+D216","v":0},{"$f":"E182+E189+E198+E207+E216","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"DO NOT DELETE",null,null,null,null,1,2,3]
[null,"Compost Produced in YR 1 (tonnes/year)",null,{"$f":"IF(D74=0,\"\",D74)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Revenues",null,{"$f":"IF(D121=0,\"\",D121)","v":""},{"$f":"IF(E121=0,\"\",E121)","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Expenses",null,{"$f":"IF(D140=0,\"\",D140+D222)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yes"]
[null,"No"]

{"sheet":"11-Compost With FA","index":12,"n_rows":445,"n_cols":26,"rows_kept":445,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,4],[58,1,58,4]]}
[]
[null,"Composting With Forced Aeration"]
[]
[null,"Guidance: ","This sheet shows the hypothetical project’s estimated annual Income Statement and Balance Sheet, which are used to determine the Internal Rate of Return (IRR). The IRR is the rate that the modeled project’s cash flows break even with initial investment. IRR is determined by setting the net present value of all cash flows (both positive and negative) from the investment equal to zero. Note this model estimates Equity IRR. To estimate Project IRR please set total debt on the “7-Economic Inputs” tab equal to zero. The sheet is organized by first listing important assumptions based on user inputs from tab “5-Faculty Inputs,” “6-Waste Inputs,” “7-Economic Inputs,” and “8-Default Values.” Below this are estimated project costs and revenues, debt schedules, interest, depreciation, and other important information. "]
[]
[]
[null,"Key Outputs"]
[null,"Compost Sale Price",null,{"$f":"CompostMarketPrice","v":0},"$/tonne"]
[null,"Gate Fee - Yard Waste",null,{"$f":"GateFeeYardWaste","v":0},"$/tonne"]
[null,"Gate Fee - Food Waste",null,{"$f":"GateFeeFoodWaste","v":0},"$/tonne"]
[null,"Gate Fee - Manure/Sludge Waste",null,{"$f":"GateFeeManure","v":0},"$/tonne"]
[null,"Gate Fee - Paper/Cardboard",null,{"$f":"GateFeePaper","v":0},"$/tonne"]
[]
[null,"Composting Facility Assumptions ",null,null,"Units"]
[null,"Equipment Lifespan",null,{"$f":"DepreciationComposting","v":7},"years"]
[null,"Replacement 1",null,{"$f":"IF(D15+OperationsStartYear<(OperationsStartYear+FacilityLifespan),D15+OperationsStartYear,\"N/A\")","v":7},"year"]
[null,"Replacement 2",null,{"$f":"IF(D16=\"N/A\",\"N/A\",IF(D15+D16<(OperationsStartYear+FacilityLifespan),D15+D16,\"N/A\"))","v":14},"year"]
[null,"Replacement 3",null,{"$f":"IF(D17=\"N/A\",\"N/A\",IF(D15+D17<(OperationsStartYear+FacilityLifespan),D15+D17,\"N/A\"))","v":"N/A"},"year"]
[]
[null,"Incoming Yard Waste in YR 1",null,{"$f":"YardWasteTonnes","v":0},"tonnes/year"]
[null,"Incoming Food Waste in YR 1",null,{"$f":"FoodWasteTonnes","v":0},"tonnes/year"]
[null,"Incoming Manure/Sludge Waste in YR 1",null,{"$f":"ManureTonnes+SewageTonnes","v":0},"tonnes/year"]
[null,"Incoming Mixed Paper and Cardboard in YR 1",null,{"$f":"MixedPaperTonnes+CardboardTonnes","v":0},"tonnes/year"]
[null,"Purchased Bulking Agent in YR 1",null,{"$f":"BulkingAgentTonnesForCompost","v":0},"tonnes/year"]
[null,"Total Annual Waste Throughput in YR 1",null,{"$f":"SUM(D20:D24)","v":0},"tonnes/year"]
[null,"Daily Waste Throughput in YR 1",null,{"$f":"D25/'8-Default Values'!D16","v":0},"tonnes/day"]
[null,"Facility Design Capacity",null,{"$f":"D25*(1+WasteGrowthRate)^'5-Facility Inputs'!D27","v":0},"tonnes/year"]
[null,"Design Capacity Daily Throughput",null,{"$f":"D27/'8-Default Values'!D16","v":0},"tonnes/day"]
[null,"Land Requirement",null,{"$f":"'8-Default Values'!D17*D27","v":0},"ha"]
[null,"Process Water Demand in YR 1",null,{"$f":"IF(D27=0,0,'6-Waste Inputs'!$E$34)","v":0},"m3/year"]
[]
[null,"Capital Cost Assumptions",null,null,"Units"]
[null,"Infrastructure and Site Development Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!E33","v":0},"$"]
[null,"Equipment Cost in Investment Year ",null,{"$f":"'7-Economic Inputs'!E34","v":0},"$"]
[null,"VAT",null,{"$f":"D34*'5-Facility Inputs'!E31*VAT","v":0},"$"]
[null,"Land Purchase in Investment Year",null,{"$f":"IF('7-Economic Inputs'!E27=\"Purchase\",LandPurchasePrice*D29,0)","v":0},"$"]
[null,"Ancillary Costs",null,{"$f":"'5-Facility Inputs'!$E$32","v":0},"$"]
[null,"Capital Cost Contingency",null,{"$f":"'8-Default Values'!D26*(D34+D33)","v":0},"$"]
[null,"Capital Investment",null,{"$f":"SUM(D33:D38)","v":0},"$"]
[null,"Grant Funding",null,{"$f":"IF(D25=0,0,GrantFunding)","v":0},"$"]
[null,"TOTAL NET CAPEX IN INVESTMENT YEAR",null,{"$f":"IF(D39-D40>0, D39-D40, 0)","v":0},"$"]
[]
[null,"Financing Assumptions",null,null,"Units"]
[null,"Total Debt in Investment Year",null,{"$f":"PercentDebt*D41","v":0},"$"]
[null,"Total Equity in Investment Year",null,{"$f":"D41*PercentEquity","v":0},"$"]
[null,"Short-term Debt in Investment Year",null,{"$f":"D34*PercentDebt","v":0},"$"]
[null,"Long-term Debt in Investment Year",null,{"$f":"D44-D46","v":0},"$"]
[]
[null,"Finance New Equipment",null,{"$f":"'7-Economic Inputs'!K48","v":"CHOOSE ONE"}]
[null,"Inflated Composting Equipment Costs"]
[null,"Replacement 1",null,{"$f":"IF(D16=\"N/A\",0,(D34*(((1+InflationRateGeneral)^(D16-InvestmentYear)))))","v":0},"$"]
[null,"Financed Amount",null,{"$f":"IF(D49=\"Yes\",D51*PercentDebt,0)","v":0},"$"]
[null,"Replacement 2",null,{"$f":"IF(D17=\"N/A\",0,(D34*(((1+InflationRateGeneral)^(D17-InvestmentYear)))))","v":0},"$"]
[null,"Financed Amount ",null,{"$f":"IF(D49=\"Yes\",D53*PercentDebt,0)","v":0},"$"]
[null,"Replacement 3",null,{"$f":"IF(D18=\"N/A\",0,(D34*(((1+InflationRateGeneral)^(D18-InvestmentYear)))))","v":0},"$"]
[null,"Financed Amount",null,{"$f":"IF(D49=\"Yes\",D55*PercentDebt,0)","v":0},"$"]
[]
[null,"Equity IRR",null,{"$f":"IFERROR(IRR(D155:Z155),\"Not Viable\")","v":"Not Viable"}]
[null,"A typical target IRR for an infrastructure project may range between 9% and 15%. If the IRR for the modeled organic waste project falls outside this range, carrying out one or more of the following troubleshooting steps may return a more acceptable IRR:\n• Reduce project expenses such as electricity costs, labor costs, water treatment costs, and land or equipment purchases.\n• Increase project revenue by increasing gate fees, accepting more waste, or raising the price(s) of sellable end product(s).\n• Change project cost of debt and check the interest rate on debt obligations is reasonable.\n• Debt/Equity Ratio: Ensure the debt to equity ratio is reasonable. Is there a way to use more equity to finance a project? "]
[]
[null,"Calendar Year",null,{"$f":"InvestmentYear","v":0},{"$f":"D61+1","v":1},{"$f":"E61+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,{"$f":"X61+1","v":21},{"$f":"Y61+1","v":22}]
[null,"Operating Year",null,{"$f":"IF(D61<OperationsStartYear,0,IF(D61=OperationsStartYear,1,IF(D61>OperationsStartYear,C62+1,IF(D61>=D61+$D$15,0))))","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Waste Assumptions"]
[null,"Available Yard Waste to Composting (tonnes/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$20*(1+WasteGrowthRate)^(D62-1),0)","v":0},{"$f":"IF(AND(E$62>0,E$62<=FacilityLifespan),IF(E$68>$D$27, D64, $D$20*(1+WasteGrowthRate)^(E$62-1)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Available Food Waste to Composting (tonnes/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$21*(1+WasteGrowthRate)^(D62-1),0)","v":0},{"$f":"IF(AND(E$62>0,E$62<=FacilityLifespan),IF(E$68>$D$27, D65, $D$21*(1+WasteGrowthRate)^(E$62-1)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Available Manure/Sludge Waste to Composting (tonnes/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$22*(1+WasteGrowthRate)^(D62-1),0)","v":0},{"$f":"IF(AND(E$62>0,E$62<=FacilityLifespan),IF(E$68>$D$27, D66, $D$22*(1+WasteGrowthRate)^(E$62-1)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Available Mixed Paper & Cardboard",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$23*(1+WasteGrowthRate)^(D62-1),0)","v":0},{"$f":"IF(AND(E$62>0,E$62<=FacilityLifespan),IF(E$68>$D$27, D67, $D$23*(1+WasteGrowthRate)^(E$62-1)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"HIDDEN - TOTAL AVAILABLE WASTE TO COMPOSTING (for facility max check)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$25*(1+WasteGrowthRate)^(D62-1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Waste Available to Composting (tonnes/year)",null,{"$f":"IF(D68<=$D$27, SUM(D64:D67), C69)","v":0},{"$f":"IF(E68<=$D$27, SUM(E64:E67), D69)","v":0},{"$f":"IF(F68<=$D$27, SUM(F64:F67), E69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Purchased Bulking Agent to Composting (tonnes/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$24*(1+WasteGrowthRate)^(D62-1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Waste to Composting (tonnes/year)",null,{"$f":"D69+D70","v":0},{"$f":"E69+E70","v":0},{"$f":"F69+F70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Primary Screening Residues (tonnes/year)",null,{"$f":"D71*'8-Default Values'!$D$20","v":0},{"$f":"E71*'8-Default Values'!$D$20","v":0},{"$f":"F71*'8-Default Values'!$C$20","v":0},{"$f":"G71*'8-Default Values'!$C$20","v":0},{"$f":"H71*'8-Default Values'!$C$20","v":0},{"$f":"I71*'8-Default Values'!$C$20","v":0},{"$f":"J71*'8-Default Values'!$C$20","v":0},{"$f":"K71*'8-Default Values'!$C$20","v":0},{"$f":"L71*'8-Default Values'!$C$20","v":0},{"$f":"M71*'8-Default Values'!$C$20","v":0},{"$f":"N71*'8-Default Values'!$C$20","v":0},{"$f":"O71*'8-Default Values'!$C$20","v":0},{"$f":"P71*'8-Default Values'!$C$20","v":0},{"$f":"Q71*'8-Default Values'!$C$20","v":0},{"$f":"R71*'8-Default Values'!$C$20","v":0},{"$f":"S71*'8-Default Values'!$C$20","v":0},{"$f":"T71*'8-Default Values'!$C$20","v":0},{"$f":"U71*'8-Default Values'!$C$20","v":0},{"$f":"V71*'8-Default Values'!$C$20","v":0},{"$f":"W71*'8-Default Values'!$C$20","v":0},{"$f":"X71*'8-Default Values'!$C$20","v":0},{"$f":"Y71*'8-Default Values'!$C$20","v":0},{"$f":"Z71*'8-Default Values'!$C$20","v":0}]
[null,"Compost Produced (tonnes/year)",null,{"$f":"(D71-D72)*'8-Default Values'!$D$21","v":0},{"$f":"(E71-E72)*'8-Default Values'!$D$21","v":0},{"$f":"(F71-F72)*'8-Default Values'!$D$21","v":0},{"$f":"(G71-G72)*'8-Default Values'!$D$21","v":0},{"$f":"(H71-H72)*'8-Default Values'!$D$21","v":0},{"$f":"(I71-I72)*'8-Default Values'!$D$21","v":0},{"$f":"(J71-J72)*'8-Default Values'!$D$21","v":0},{"$f":"(K71-K72)*'8-Default Values'!$D$21","v":0},{"$f":"(L71-L72)*'8-Default Values'!$D$21","v":0},{"$f":"(M71-M72)*'8-Default Values'!$D$21","v":0},{"$f":"(N71-N72)*'8-Default Values'!$D$21","v":0},{"$f":"(O71-O72)*'8-Default Values'!$D$21","v":0},{"$f":"(P71-P72)*'8-Default Values'!$D$21","v":0},{"$f":"(Q71-Q72)*'8-Default Values'!$D$21","v":0},{"$f":"(R71-R72)*'8-Default Values'!$D$21","v":0},{"$f":"(S71-S72)*'8-Default Values'!$D$21","v":0},{"$f":"(T71-T72)*'8-Default Values'!$D$21","v":0},{"$f":"(U71-U72)*'8-Default Values'!$D$21","v":0},{"$f":"(V71-V72)*'8-Default Values'!$D$21","v":0},{"$f":"(W71-W72)*'8-Default Values'!$D$21","v":0},{"$f":"(X71-X72)*'8-Default Values'!$D$21","v":0},{"$f":"(Y71-Y72)*'8-Default Values'!$D$21","v":0},{"$f":"(Z71-Z72)*'8-Default Values'!$D$21","v":0}]
[null,"Final Screening Residues (tonnes/year)",null,{"$f":"(D71-D72)*'8-Default Values'!$D$22","v":0},{"$f":"(E71-E72)*'8-Default Values'!$D$22","v":0},{"$f":"(F71-F72)*'8-Default Values'!$D$22","v":0},{"$f":"(G71-G72)*'8-Default Values'!$D$22","v":0},{"$f":"(H71-H72)*'8-Default Values'!$D$22","v":0},{"$f":"(I71-I72)*'8-Default Values'!$D$22","v":0},{"$f":"(J71-J72)*'8-Default Values'!$D$22","v":0},{"$f":"(K71-K72)*'8-Default Values'!$D$22","v":0},{"$f":"(L71-L72)*'8-Default Values'!$D$22","v":0},{"$f":"(M71-M72)*'8-Default Values'!$D$22","v":0},{"$f":"(N71-N72)*'8-Default Values'!$D$22","v":0},{"$f":"(O71-O72)*'8-Default Values'!$D$22","v":0},{"$f":"(P71-P72)*'8-Default Values'!$D$22","v":0},{"$f":"(Q71-Q72)*'8-Default Values'!$D$22","v":0},{"$f":"(R71-R72)*'8-Default Values'!$D$22","v":0},{"$f":"(S71-S72)*'8-Default Values'!$D$22","v":0},{"$f":"(T71-T72)*'8-Default Values'!$D$22","v":0},{"$f":"(U71-U72)*'8-Default Values'!$D$22","v":0},{"$f":"(V71-V72)*'8-Default Values'!$D$22","v":0},{"$f":"(W71-W72)*'8-Default Values'!$D$22","v":0},{"$f":"(X71-X72)*'8-Default Values'!$D$22","v":0},{"$f":"(Y71-Y72)*'8-Default Values'!$D$22","v":0},{"$f":"(Z71-Z72)*'8-Default Values'!$D$22","v":0}]
[null,"Total Waste to Landfill (tonnes/year)",null,{"$f":"D72+D74","v":0},{"$f":"E72+E74","v":0},{"$f":"F72+F74","v":0},{"$f":"G72+G74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Waste Diverted from Landfill (tonnes/year)",null,{"$f":"D68-D72","v":0},{"$f":"E68-E72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operating Assumptions "]
[null,"Compost Sold (tonnes/year)",null,{"$f":"IF(D62=1,D73*'5-Facility Inputs'!$E$28,IF(D62=2,D73*'5-Facility Inputs'!$E$29,IF(D62>=3,D73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(E62=1,E73*'5-Facility Inputs'!$E$28,IF(E62=2,E73*'5-Facility Inputs'!$E$29,IF(E62>=3,E73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(F62=1,F73*'5-Facility Inputs'!$E$28,IF(F62=2,F73*'5-Facility Inputs'!$E$29,IF(F62>=3,F73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(G62=1,G73*'5-Facility Inputs'!$E$28,IF(G62=2,G73*'5-Facility Inputs'!$E$29,IF(G62>=3,G73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(H62=1,H73*'5-Facility Inputs'!$E$28,IF(H62=2,H73*'5-Facility Inputs'!$E$29,IF(H62>=3,H73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(I62=1,I73*'5-Facility Inputs'!$E$28,IF(I62=2,I73*'5-Facility Inputs'!$E$29,IF(I62>=3,I73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(J62=1,J73*'5-Facility Inputs'!$E$28,IF(J62=2,J73*'5-Facility Inputs'!$E$29,IF(J62>=3,J73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(K62=1,K73*'5-Facility Inputs'!$E$28,IF(K62=2,K73*'5-Facility Inputs'!$E$29,IF(K62>=3,K73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(L62=1,L73*'5-Facility Inputs'!$E$28,IF(L62=2,L73*'5-Facility Inputs'!$E$29,IF(L62>=3,L73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(M62=1,M73*'5-Facility Inputs'!$E$28,IF(M62=2,M73*'5-Facility Inputs'!$E$29,IF(M62>=3,M73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(N62=1,N73*'5-Facility Inputs'!$E$28,IF(N62=2,N73*'5-Facility Inputs'!$E$29,IF(N62>=3,N73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(O62=1,O73*'5-Facility Inputs'!$E$28,IF(O62=2,O73*'5-Facility Inputs'!$E$29,IF(O62>=3,O73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(P62=1,P73*'5-Facility Inputs'!$E$28,IF(P62=2,P73*'5-Facility Inputs'!$E$29,IF(P62>=3,P73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(Q62=1,Q73*'5-Facility Inputs'!$E$28,IF(Q62=2,Q73*'5-Facility Inputs'!$E$29,IF(Q62>=3,Q73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(R62=1,R73*'5-Facility Inputs'!$E$28,IF(R62=2,R73*'5-Facility Inputs'!$E$29,IF(R62>=3,R73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(S62=1,S73*'5-Facility Inputs'!$E$28,IF(S62=2,S73*'5-Facility Inputs'!$E$29,IF(S62>=3,S73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(T62=1,T73*'5-Facility Inputs'!$E$28,IF(T62=2,T73*'5-Facility Inputs'!$E$29,IF(T62>=3,T73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(U62=1,U73*'5-Facility Inputs'!$E$28,IF(U62=2,U73*'5-Facility Inputs'!$E$29,IF(U62>=3,U73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(V62=1,V73*'5-Facility Inputs'!$E$28,IF(V62=2,V73*'5-Facility Inputs'!$E$29,IF(V62>=3,V73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(W62=1,W73*'5-Facility Inputs'!$E$28,IF(W62=2,W73*'5-Facility Inputs'!$E$29,IF(W62>=3,W73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(X62=1,X73*'5-Facility Inputs'!$E$28,IF(X62=2,X73*'5-Facility Inputs'!$E$29,IF(X62>=3,X73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(Y62=1,Y73*'5-Facility Inputs'!$E$28,IF(Y62=2,Y73*'5-Facility Inputs'!$E$29,IF(Y62>=3,Y73*'5-Facility Inputs'!$E$30,0)))","v":0},{"$f":"IF(Z62=1,Z73*'5-Facility Inputs'!$E$28,IF(Z62=2,Z73*'5-Facility Inputs'!$E$29,IF(Z62>=3,Z73*'5-Facility Inputs'!$E$30,0)))","v":0}]
[null,"Compost Gifted (tonnes/year)",null,{"$f":"D73-D78","v":0},{"$f":"E73-E78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Consumption (kWh/year)",null,{"$f":"(D71*'8-Default Values'!$D$18)","v":0},{"$f":"(E71*'8-Default Values'!$D$18)","v":0},{"$f":"(F71*'8-Default Values'!$D$18)","v":0},{"$f":"(G71*'8-Default Values'!$D$18)","v":0},{"$f":"(H71*'8-Default Values'!$D$18)","v":0},{"$f":"(I71*'8-Default Values'!$D$18)","v":0},{"$f":"(J71*'8-Default Values'!$D$18)","v":0},{"$f":"(K71*'8-Default Values'!$D$18)","v":0},{"$f":"(L71*'8-Default Values'!$D$18)","v":0},{"$f":"(M71*'8-Default Values'!$D$18)","v":0},{"$f":"(N71*'8-Default Values'!$D$18)","v":0},{"$f":"(O71*'8-Default Values'!$D$18)","v":0},{"$f":"(P71*'8-Default Values'!$D$18)","v":0},{"$f":"(Q71*'8-Default Values'!$D$18)","v":0},{"$f":"(R71*'8-Default Values'!$D$18)","v":0},{"$f":"(S71*'8-Default Values'!$D$18)","v":0},{"$f":"(T71*'8-Default Values'!$D$18)","v":0},{"$f":"(U71*'8-Default Values'!$D$18)","v":0},{"$f":"(V71*'8-Default Values'!$D$18)","v":0},{"$f":"(W71*'8-Default Values'!$D$18)","v":0},{"$f":"(X71*'8-Default Values'!$D$18)","v":0},{"$f":"(Y71*'8-Default Values'!$D$18)","v":0},{"$f":"(Z71*'8-Default Values'!$D$18)","v":0}]
[null,"Diesel Consumption (liters/year)",null,{"$f":"(D71*'8-Default Values'!$D$19)","v":0},{"$f":"(E71*'8-Default Values'!$D$19)","v":0},{"$f":"(F71*'8-Default Values'!$D$19)","v":0},{"$f":"(G71*'8-Default Values'!$D$19)","v":0},{"$f":"(H71*'8-Default Values'!$D$19)","v":0},{"$f":"(I71*'8-Default Values'!$D$19)","v":0},{"$f":"(J71*'8-Default Values'!$D$19)","v":0},{"$f":"(K71*'8-Default Values'!$D$19)","v":0},{"$f":"(L71*'8-Default Values'!$D$19)","v":0},{"$f":"(M71*'8-Default Values'!$D$19)","v":0},{"$f":"(N71*'8-Default Values'!$D$19)","v":0},{"$f":"(O71*'8-Default Values'!$D$19)","v":0},{"$f":"(P71*'8-Default Values'!$D$19)","v":0},{"$f":"(Q71*'8-Default Values'!$D$19)","v":0},{"$f":"(R71*'8-Default Values'!$D$19)","v":0},{"$f":"(S71*'8-Default Values'!$D$19)","v":0},{"$f":"(T71*'8-Default Values'!$D$19)","v":0},{"$f":"(U71*'8-Default Values'!$D$19)","v":0},{"$f":"(V71*'8-Default Values'!$D$19)","v":0},{"$f":"(W71*'8-Default Values'!$D$19)","v":0},{"$f":"(X71*'8-Default Values'!$D$19)","v":0},{"$f":"(Y71*'8-Default Values'!$D$19)","v":0},{"$f":"(Z71*'8-Default Values'!$D$19)","v":0}]
[null,"Process Water Consumption (m3/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$30*(1+WasteGrowthRate)^(D62-1),0)","v":0},{"$f":"IF(AND(E62>0,E62<=FacilityLifespan),$D$30*(1+WasteGrowthRate)^(E62-1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Number of Managers/Engineers",null,{"$f":"TotalNumberofEngineers","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Number of Operators",null,{"$f":"TotalNumberofOperators","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Economic Assumptions"]
[null,"Compost Sale Price ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$8*(1+InflationRateCompostDigestateBulking)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Yard Waste ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$9*(1+InflationRateDisposalGate)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Food Waste ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$10*(1+InflationRateDisposalGate)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Manure/Sludge Waste ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$11*(1+InflationRateDisposalGate)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Paper/Cardboard",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),$D$12*(1+InflationRateDisposalGate)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Landfill Disposal Fee ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),AvoidedLandfillDisposalFee*(1+InflationRateDisposalGate)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fee ($/tonne/km)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),TransportationFee*(1+InflationRateDisposalGate)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Electricity Purchase Price ($/kWh)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),(ElectricityPrice*((1+InflationRateElectricityFuel)^(D61-$D$61))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Purchase Price ($/liter)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),(DieselPrice*((1+InflationRateElectricityFuel)^(D61-$D$61))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Transportation ($/tonne/km)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),TransportationFee*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Disposal ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),ResidualDisposalFee*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Price ($/ha/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),LandLeasePrice*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Managers - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),LaborManager*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operators - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),LaborOperator*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Process Water Fee ($/m3)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),WaterPurchasePrice*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),BulkingAgentCost*(1+InflationRateCompostDigestateBulking)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Land Application Cost ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),CompostLandAppCost*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Transportation Cost ($/tonne)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan),CompostTransportCost*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual Maintenance Cost ($/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan,D61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},{"$f":"IF(AND(E62>0,E62<=FacilityLifespan,E61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(E61-$D$61),0)","v":0},{"$f":"IF(AND(F62>0,F62<=FacilityLifespan,F61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(F61-$D$61),0)","v":0},{"$f":"IF(AND(G62>0,G62<=FacilityLifespan,G61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(G61-$D$61),0)","v":0},{"$f":"IF(AND(H62>0,H62<=FacilityLifespan,H61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(H61-$D$61),0)","v":0},{"$f":"IF(AND(I62>0,I62<=FacilityLifespan,I61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(I61-$D$61),0)","v":0},{"$f":"IF(AND(J62>0,J62<=FacilityLifespan,J61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(J61-$D$61),0)","v":0},{"$f":"IF(AND(K62>0,K62<=FacilityLifespan,K61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(K61-$D$61),0)","v":0},{"$f":"IF(AND(L62>0,L62<=FacilityLifespan,L61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(L61-$D$61),0)","v":0},{"$f":"IF(AND(M62>0,M62<=FacilityLifespan,M61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(M61-$D$61),0)","v":0},{"$f":"IF(AND(N62>0,N62<=FacilityLifespan,N61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(N61-$D$61),0)","v":0},{"$f":"IF(AND(O62>0,O62<=FacilityLifespan,O61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(O61-$D$61),0)","v":0},{"$f":"IF(AND(P62>0,P62<=FacilityLifespan,P61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(P61-$D$61),0)","v":0},{"$f":"IF(AND(Q62>0,Q62<=FacilityLifespan,Q61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(Q61-$D$61),0)","v":0},{"$f":"IF(AND(R62>0,R62<=FacilityLifespan,R61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(R61-$D$61),0)","v":0},{"$f":"IF(AND(S62>0,S62<=FacilityLifespan,S61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(S61-$D$61),0)","v":0},{"$f":"IF(AND(T62>0,T62<=FacilityLifespan,T61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(T61-$D$61),0)","v":0},{"$f":"IF(AND(U62>0,U62<=FacilityLifespan,U61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(U61-$D$61),0)","v":0},{"$f":"IF(AND(V62>0,V62<=FacilityLifespan,V61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(V61-$D$61),0)","v":0},{"$f":"IF(AND(W62>0,W62<=FacilityLifespan,W61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(W61-$D$61),0)","v":0},{"$f":"IF(AND(X62>0,X62<=FacilityLifespan,X61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(X61-$D$61),0)","v":0},{"$f":"IF(AND(Y62>0,Y62<=FacilityLifespan,Y61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(Y61-$D$61),0)","v":0},{"$f":"IF(AND(Z62>0,Z62<=FacilityLifespan,Z61>=MaintenanceBegins),$D$39*'8-Default Values'!$D$28*(1+InflationRateGeneral)^(Z61-$D$61),0)","v":0}]
[null,"Annual Insurance Cost ($/year)",null,{"$f":"IF(AND(D62>0,D62<=FacilityLifespan,D61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(D61-$D$61),0)","v":0},{"$f":"IF(AND(E62>0,E62<=FacilityLifespan,E61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(E61-$D$61),0)","v":0},{"$f":"IF(AND(F62>0,F62<=FacilityLifespan,F61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(F61-$D$61),0)","v":0},{"$f":"IF(AND(G62>0,G62<=FacilityLifespan,G61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(G61-$D$61),0)","v":0},{"$f":"IF(AND(H62>0,H62<=FacilityLifespan,H61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(H61-$D$61),0)","v":0},{"$f":"IF(AND(I62>0,I62<=FacilityLifespan,I61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(I61-$D$61),0)","v":0},{"$f":"IF(AND(J62>0,J62<=FacilityLifespan,J61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(J61-$D$61),0)","v":0},{"$f":"IF(AND(K62>0,K62<=FacilityLifespan,K61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(K61-$D$61),0)","v":0},{"$f":"IF(AND(L62>0,L62<=FacilityLifespan,L61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(L61-$D$61),0)","v":0},{"$f":"IF(AND(M62>0,M62<=FacilityLifespan,M61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(M61-$D$61),0)","v":0},{"$f":"IF(AND(N62>0,N62<=FacilityLifespan,N61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(N61-$D$61),0)","v":0},{"$f":"IF(AND(O62>0,O62<=FacilityLifespan,O61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(O61-$D$61),0)","v":0},{"$f":"IF(AND(P62>0,P62<=FacilityLifespan,P61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(P61-$D$61),0)","v":0},{"$f":"IF(AND(Q62>0,Q62<=FacilityLifespan,Q61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(Q61-$D$61),0)","v":0},{"$f":"IF(AND(R62>0,R62<=FacilityLifespan,R61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(R61-$D$61),0)","v":0},{"$f":"IF(AND(S62>0,S62<=FacilityLifespan,S61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(S61-$D$61),0)","v":0},{"$f":"IF(AND(T62>0,T62<=FacilityLifespan,T61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(T61-$D$61),0)","v":0},{"$f":"IF(AND(U62>0,U62<=FacilityLifespan,U61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(U61-$D$61),0)","v":0},{"$f":"IF(AND(V62>0,V62<=FacilityLifespan,V61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(V61-$D$61),0)","v":0},{"$f":"IF(AND(W62>0,W62<=FacilityLifespan,W61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(W61-$D$61),0)","v":0},{"$f":"IF(AND(X62>0,X62<=FacilityLifespan,X61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(X61-$D$61),0)","v":0},{"$f":"IF(AND(Y62>0,Y62<=FacilityLifespan,Y61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(Y61-$D$61),0)","v":0},{"$f":"IF(AND(Z62>0,Z62<=FacilityLifespan,Z61>=OperationsStartYear),($D$39-$D$35)*'8-Default Values'!$D$29*(1+InflationRateGeneral)^(Z61-$D$61),0)","v":0}]
[]
[null,"Consolidated Profit and Loss"]
[null,"Compost Sales ($/year)",null,{"$f":"D87*D78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Yard Waste ($/year)",null,{"$f":"D88*D64","v":0},{"$f":"E88*E64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Food Waste ($/year)",null,{"$f":"D89*D65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Manure/Sludge Waste ($/year)",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Paper/Cardboard ($/year)",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Avoided Landfill Disposal Fees ($/year)",null,{"$f":"D92*D76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fees ($/year)",null,{"$f":"(DistanceGeneratorsToLandfill-DistanceGeneratorsToOrganicsFacility)*D93*D66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Land Sale at End of Project Life ($/year)",null,{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",D61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!D62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",E61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!E62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",F61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!F62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",G61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!G62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",H61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!H62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",I61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!I62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",J61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!J62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",K61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!K62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",L61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!L62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",M61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!M62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",N61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!N62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",O61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!O62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",P61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!P62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",Q61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!Q62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",R61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!R62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",S61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!S62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",T61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!T62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",U61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!U62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",V61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!V62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",W61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!W62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",X61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!X62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",Y61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!Y62-'10-Compost W.O. FA'!$D$62),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$27=\"Purchase\",Z61=OperationsStartYear+FacilityLifespan-1),$D$36*(1+InflationRateGeneral)^('10-Compost W.O. FA'!Z62-'10-Compost W.O. FA'!$D$62),0)","v":0}]
[null,"Composting Equipment Sale at End of Project Life ($/year)",null,{"$f":"IF(D62=FacilityLifespan,SUM($D$171:$D$174),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Revenues ($/year)",null,{"$f":"SUM(D110:D119)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Costs ($/year)",null,{"$f":"D95*D80","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Costs ($/year)",null,{"$f":"D96*D81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Transportation Cost ($/year)",null,{"$f":"D97*D75*DistanceOrganicsFacilityToLandfill","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Disposal Cost ($/year)",null,{"$f":"D98*D75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Cost ($/year)",null,{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(D99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(E99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(F99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(G99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(H99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(I99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(J99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(K99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(L99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(M99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(N99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(O99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(P99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(Q99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(R99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(S99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(T99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(U99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(V99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(W99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(X99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(Y99*$D$29),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$27=\"Lease\",(Z99*$D$29),0)","v":0}]
[null,"Labor Costs ($/year)",null,{"$f":"(D100*D83)+(D84*D101)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Process Water Cost ($/year)",null,{"$f":"D102*D82","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/year)",null,{"$f":"D103*D70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Land Application Cost ($/tonne)",null,{"$f":"D104*D73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compost - Soil Product Transportation Cost ($/tonne)",null,{"$f":"D105*D73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance Costs ($/year)",null,{"$f":"D106","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Insurance Costs ($/year)",null,{"$f":"D107","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Outside Services and Supplies ($/year)",null,{"$f":"'8-Default Values'!$D$30*SUM(D121:D132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(E121:E132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(F121:F132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(G121:G132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(H121:H132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(I121:I132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(J121:J132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(K121:K132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(L121:L132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(M121:M132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(N121:N132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(O121:O132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(P121:P132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(Q121:Q132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(R121:R132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(S121:S132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(T121:T132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(U121:U132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(V121:V132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(W121:W132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(X121:X132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(Y121:Y132)","v":0},{"$f":"'8-Default Values'!$D$30*SUM(Z121:Z132)","v":0}]
[null,"Operating Cost Contingency ($/year)",null,{"$f":"SUM(D121:D133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(E121:E133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(F121:F133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(G121:G133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(H121:H133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(I121:I133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(J121:J133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(K121:K133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(L121:L133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(M121:M133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(N121:N133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(O121:O133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(P121:P133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(Q121:Q133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(R121:R133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(S121:S133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(T121:T133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(U121:U133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(V121:V133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(W121:W133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(X121:X133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(Y121:Y133)*'8-Default Values'!$D$31","v":0},{"$f":"SUM(Z121:Z133)*'8-Default Values'!$D$31","v":0}]
[null,"Cost of Goods Sold",null,{"$f":"SUM(D121:D133)+D149","v":0},{"$f":"SUM(E121:E133)+E149","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenses ($/year)",null,{"$f":"SUM(D121:D134)","v":0},{"$f":"SUM(E121:E134)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total O&M/Tonne of Waste Processed",null,{"$f":"IF(D136=0,0,IF(D62>0,D136/D71,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Adjusted COGS ($/year)",null,{"$f":"D135","v":0},{"$f":"E135","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Adjusted Expenses ($/year)",null,{"$f":"D136","v":0},{"$f":"E136","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross Profit",null,{"$f":"SUM(D110:D115)-D138","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBITDA",null,{"$f":"D120-D139","v":0},{"$f":"E120-E139","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation",null,{"$f":"D168","v":0},{"$f":"E168","v":0},{"$f":"F168","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V168","v":0},0,0,{"$f":"Y168","v":0},{"$f":"Z168","v":0}]
[null,"EBIT",null,{"$f":"D141-D142","v":0},{"$f":"E141-E142","v":0},{"$f":"F141-F142","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y141-Y142","v":0},{"$f":"Z141-Z142","v":0}]
[]
[null,"Operating Cash Flow"]
[null,"EBIT",null,{"$f":"D143","v":0},{"$f":"E143","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"X143","v":0},{"$f":"Y143","v":0},{"$f":"Z143","v":0}]
[null,"Taxes",null,{"$f":"IF(D140>0,-D140*Tax,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBIAT (After Tax EBIT)",null,{"$f":"D146+D147","v":0},{"$f":"E146+E147","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y146+Y147","v":0},{"$f":"Z146+Z147","v":0}]
[null,"Depreciation",null,{"$f":"D168","v":0},{"$f":"E168","v":0},{"$f":"F168","v":0},{"$f":"G168","v":0},{"$f":"H168","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y168","v":0},{"$f":"Z168","v":0}]
[null,"Operating Cash Flow",null,{"$f":"D148+D149","v":0},{"$f":"E148+E149","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y148+Y149","v":0},{"$f":"Z148+Z149","v":0}]
[null,"Debt Service",null,{"$f":"-D221","v":0},{"$f":"-E221","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-Y221","v":0},{"$f":"-Z221","v":0}]
[null,"Initial Equity ",null,{"$f":"IF(D61=InvestmentYear,$D$45,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Initial Debt",null,{"$f":"IF(D61=InvestmentYear,$D$44,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"New Debt for Equipment Replacement",null,{"$f":"IF(AND(D61=$D$16,$D$49=\"Yes\"),$D$52,IF(AND(D61=$D$17,$D$49=\"Yes\"),$D$54,IF(AND(D61=$D$18,$D$49=\"Yes\"),$D$56,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Levered Free Cash Flow",null,{"$f":"(-D152)+D150+(-D221)","v":0},{"$f":"(-E152)+E150+(-E221)","v":0},0,{"$f":"(-G152)+G150+(-G221)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Capex and Depreciation Schedule"]
[null,"Infrastructure and Site Development Investment",null,{"$f":"IF(D61=InvestmentYear,$D$33,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Equipment Investment",null,{"$f":"IF(D61=InvestmentYear,$D$34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"New Equipment Capex",null,{"$f":"IF(D61=$D$16,$D$51,IF(D61=$D$17,$D$53,IF(D61=$D$18,$D$55,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation - Infrastructure and Site Development",null,null,{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$160,SalvageValue,DepreciationAllInfrastructure),SYD($D$160,SalvageValue,DepreciationAllInfrastructure,E62)),0)","v":0},{"$f":"IF(AND(F62<=DepreciationAllInfrastructure,F62>0),(SUM($D159:E$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(G62<=DepreciationAllInfrastructure,G62>0),(SUM($D159:F$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(H62<=DepreciationAllInfrastructure,H62>0),(SUM($D159:G$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(I62<=DepreciationAllInfrastructure,I62>0),(SUM($D159:H$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(J62<=DepreciationAllInfrastructure,J62>0),(SUM($D159:I$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(K62<=DepreciationAllInfrastructure,K62>0),(SUM($D159:J$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(L62<=DepreciationAllInfrastructure,L62>0),(SUM($D159:K$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(M62<=DepreciationAllInfrastructure,M62>0),(SUM($D159:L$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(N62<=DepreciationAllInfrastructure,N62>0),(SUM($D159:M$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(O62<=DepreciationAllInfrastructure,O62>0),(SUM($D159:N$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(P62<=DepreciationAllInfrastructure,P62>0),(SUM($D159:O$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(Q62<=DepreciationAllInfrastructure,Q62>0),(SUM($D159:P$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(R62<=DepreciationAllInfrastructure,R62>0),(SUM($D159:Q$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(S62<=DepreciationAllInfrastructure,S62>0),(SUM($D159:R$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(T62<=DepreciationAllInfrastructure,T62>0),(SUM($D159:S$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(U62<=DepreciationAllInfrastructure,U62>0),(SUM($D159:T$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(V62<=DepreciationAllInfrastructure,V62>0),(SUM($D159:U$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(W62<=DepreciationAllInfrastructure,W62>0),(SUM($D159:V$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(X62<=DepreciationAllInfrastructure,X62>0),(SUM($D159:W$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(Y62<=DepreciationAllInfrastructure,Y62>0),(SUM($D159:X$159)/DepreciationAllInfrastructure),0)","v":0},{"$f":"IF(AND(Z62<=DepreciationAllInfrastructure,Z62>0),(SUM($D159:Y$159)/DepreciationAllInfrastructure),0)","v":0}]
[null,"Depreciation - Composting Equipment",null,null,{"$f":"IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$161,SalvageValue,DepreciationComposting),SYD($D$161,SalvageValue,DepreciationComposting,E62)),0)","v":0},{"$f":"IF(AND(F62<=DepreciationComposting,F62>0),(SUM($D160:E$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(G62<=DepreciationComposting,G62>0),(SUM($D160:F$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(H62<=DepreciationComposting,H62>0),(SUM($D160:G$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(I62<=DepreciationComposting,I62>0),(SUM($D160:H$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(J62<=DepreciationComposting,J62>0),(SUM($D160:I$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(K62<=DepreciationComposting,K62>0),(SUM($D160:J$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(L62<=DepreciationComposting,L62>0),(SUM($D160:K$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(M62<=DepreciationComposting,M62>0),(SUM($D160:L$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(N62<=DepreciationComposting,N62>0),(SUM($D160:M$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(O62<=DepreciationComposting,O62>0),(SUM($D160:N$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(P62<=DepreciationComposting,P62>0),(SUM($D160:O$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(Q62<=DepreciationComposting,Q62>0),(SUM($D160:P$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(R62<=DepreciationComposting,R62>0),(SUM($D160:Q$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(S62<=DepreciationComposting,S62>0),(SUM($D160:R$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(T62<=DepreciationComposting,T62>0),(SUM($D160:S$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(U62<=DepreciationComposting,U62>0),(SUM($D160:T$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(V62<=DepreciationComposting,V62>0),(SUM($D160:U$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(W62<=DepreciationComposting,W62>0),(SUM($D160:V$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(X62<=DepreciationComposting,X62>0),(SUM($D160:W$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(Y62<=DepreciationComposting,Y62>0),(SUM($D160:X$160)/DepreciationComposting),0)","v":0},{"$f":"IF(AND(Z62<=DepreciationComposting,Z62>0),(SUM($D160:Y$160)/DepreciationComposting),0)","v":0}]
[null,"Depreciation Initial Investment",null,null,{"$f":"E162+E163","v":0},{"$f":"F162+F163","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation New Capex - Composting Equipment Replacement 1",null,null,{"$f":"IF($D$16=\"N/A\",0,IF(AND(E61>=$D$16,E61<$D$17,E62<=FacilityLifespan),IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$51,SalvageValue,DepreciationComposting),SYD($D$51,SalvageValue,DepreciationComposting,E62)),0),0))","v":0},{"$f":"IF($D$16=\"N/A\",0,IF(AND(F61>=$D$16,F61<$D$17,F62<=FacilityLifespan),$D$51/DepreciationComposting,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation New Capex - Composting Equipment Replacement 2",null,null,{"$f":"IF($D$16=\"N/A\",0,IF(AND(E62>=$D$16,E62<$D$17,E62<=FacilityLifespan),IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$53,SalvageValue,DepreciationComposting),SYD($D$53,SalvageValue,DepreciationComposting,E62)),0),0))","v":0},{"$f":"IF($D$17=\"N/A\",0,IF(AND(F61>=$D$17,F61<$D$18,F62<=FacilityLifespan),$D$53/DepreciationComposting,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation New Capex - Composting Equipment Replacement 3",null,null,{"$f":"IF($D$16=\"N/A\",0,IF(AND(E62>=$D$16,E62<$D$17,E62<=FacilityLifespan),IFERROR(IF(DeprMeth=\"Straight-Line\",SLN($D$55,SalvageValue,DepreciationComposting),SYD($D$55,SalvageValue,DepreciationComposting,E62)),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Depreciation",null,null,{"$f":"SUM(E164:E167)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Composting Equipment Sale at End of Project Life"]
[null,"Initial Equipment",null,{"$f":"IF(SUM(E163:Z163)=D34,0,D34-SUM(E163:Z163))","v":0}]
[null,"Equipment Replacement 1",null,{"$f":"IF(SUM(E165:Z165)=D51,0,D51-SUM(E165:Z165))","v":0}]
[null,"Equipment Replacement 2",null,{"$f":"IF(SUM(E166:Z166)=D53,0,D53-SUM(E166:Z166))","v":0}]
[null,"Equipment Replacement 3",null,{"$f":"IF(SUM(E167:Z167)=D55,0,D55-SUM(E167:Z167))","v":0}]
[]
[null,"Financing"]
[null,"Short-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D61<OperationsStartYear,0,IF(D61=OperationsStartYear,$D$46,C182))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D62,TenorShortTermDebt,$D$46)),0,(-IPMT(InterestRateShortTermDebt,D62,TenorShortTermDebt,$D$46)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D62,TenorShortTermDebt,$D$46)),0,(-PPMT(InterestRateShortTermDebt,D62,TenorShortTermDebt,$D$46)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D179+D180","v":0},{"$f":"E179+E180","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y179+Y180","v":0},{"$f":"Z179+Z180","v":0}]
[null,"EOY Balance",null,{"$f":"D178-D180","v":0},{"$f":"E178-E180","v":0},{"$f":"F178-F180","v":0},0,0,0,0,0,0,0,{"$f":"N178-N180","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Y178-Y180","v":0},{"$f":"Z178-Z180","v":0}]
[]
[null,"Long-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D61<OperationsStartYear,0,IF(D61=OperationsStartYear,$D$47,C189))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateLongTermDebt,D62,TenorLongTermDebt,$D$47)),0,(-IPMT(InterestRateLongTermDebt,D62,TenorLongTermDebt,$D$47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateLongTermDebt,D62,TenorLongTermDebt,$D$47)),0,(-PPMT(InterestRateLongTermDebt,D62,TenorLongTermDebt,$D$47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D186+D187","v":0},{"$f":"E186+E187","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y186+Y187","v":0},{"$f":"Z186+Z187","v":0}]
[null,"EOY Balance",null,{"$f":"D185-D187","v":0},{"$f":"E185-E187","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y185-Y187","v":0},{"$f":"Z185-Z187","v":0}]
[]
[null,"DO NOT DELETE",null,{"$f":"IF($D$16=\"N/A\",0,IF(D61=$D$16,1,IF(D61<$D$16,0,IF(AND(D61>$D$16,D62<=FacilityLifespan),C191+1,0))))","v":0},0,0,0,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,0,0,0]
[null,"Debt Tenor",null,{"$f":"IF(D16=\"N/A\",\"N/A\",IF(OperationsStartYear+FacilityLifespan-D16<TenorShortTermDebt,OperationsStartYear+FacilityLifespan-D16,TenorShortTermDebt))","v":0}]
[null,"Replacement Equipment 1 - Composting"]
[null,"BOY Balance",null,{"$f":"IF(D191=1,$D$52,C198)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D191,$D$192,$D$52)),0,(-IPMT(InterestRateShortTermDebt,D191,$D$192,$D$52)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D191,$D$192,$D$52)),0,(-PPMT(InterestRateShortTermDebt,D191,$D$192,$D$52)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D195+D196","v":0},{"$f":"E195+E196","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y195+Y196","v":0},{"$f":"Z195+Z196","v":0}]
[null,"EOY Balance",null,{"$f":"D194-D196","v":0},{"$f":"E194-E196","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y194-Y196","v":0},{"$f":"Z194-Z196","v":0}]
[]
[null,"DO NOT DELETE",null,{"$f":"IF($D$17=\"N/A\",0,IF(D61=$D$17,1,IF(D61<$D$17,0,IF(AND(D61>$D$17,D62<=FacilityLifespan),C200+1,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,3,4,5,6,0,0,0]
[null,"Debt Tenor",null,{"$f":"IF(D17=\"N/A\",\"N/A\",IF(OperationsStartYear+FacilityLifespan-D17<TenorShortTermDebt,OperationsStartYear+FacilityLifespan-D17,TenorShortTermDebt))","v":0}]
[null,"Replacement Equipment 2 - Composting"]
[null,"BOY Balance",null,{"$f":"IF(D200=1,$D$54,C207)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D200,$D$201,$D$54)),0,(-IPMT(InterestRateShortTermDebt,D200,$D$201,$D$54)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D200,$D$201,$D$54)),0,(-PPMT(InterestRateShortTermDebt,D200,$D$201,$D$54)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D204+D205","v":0},{"$f":"E204+E205","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y204+Y205","v":0},{"$f":"Z204+Z205","v":0}]
[null,"EOY Balance",null,{"$f":"D203-D205","v":0},{"$f":"E203-E205","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y203-Y205","v":0},{"$f":"Z203-Z205","v":0}]
[]
[null,"DO NOT DELETE",null,{"$f":"IF($D$18=\"N/A\",0,IF(D61=$D$18,1,IF(D61<$D$18,0,IF(AND(D61>$D$18,D62<=FacilityLifespan),C209+1,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt Tenor",null,{"$f":"IF(D18=\"N/A\",\"N/A\",IF(OperationsStartYear+FacilityLifespan-D18<TenorShortTermDebt,OperationsStartYear+FacilityLifespan-D18,TenorShortTermDebt))","v":"N/A"}]
[null,"Replacement Equipment 3 - Composting"]
[null,"BOY Balance",null,{"$f":"IF(D209=1,$D$56,C216)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D209,$D$210,$D$56)),0,(-IPMT(InterestRateShortTermDebt,D209,$D$210,$D$56)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D209,$D$210,$D$56)),0,(-PPMT(InterestRateShortTermDebt,D209,$D$210,$D$56)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D213+D214","v":0},{"$f":"E213+E214","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y213+Y214","v":0},{"$f":"Z213+Z214","v":0}]
[null,"EOY Balance",null,{"$f":"D212-D214","v":0},{"$f":"E212-E214","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y212-Y214","v":0},{"$f":"Z212-Z214","v":0}]
[]
[null,"Summary"]
[null,"Interest Payment",null,{"$f":"D179+D186+D195+D204+D213","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"D180+D187+D196+D205+D214","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D181+D188+D197+D206+D215","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"DO NOT DELETE"]
[null,"Compost Produced in YR 1 (tonnes/year)",null,{"$f":"IF(D73=0,\"\",D73)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Waste Diverted from Landfill in YR 1 (tonnes/year)",null,{"$f":"IF(D76=0,\"\",D76)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Revenues",null,{"$f":"IF(D120=0,\"\",D120)","v":""},{"$f":"IF(E120=0,\"\",E120)","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Expenses",null,{"$f":"IF(D139=0,\"\",D139+D221)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yes"]
[null,"No"]

{"sheet":"12-Tool Assumptions","index":13,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,3,4,3]]}
[]
[null,"Tool Assumptions"]
[]
[null,"Guidance: ",null,"This tab provides a list of additional assumptions used throughout the model, and their sources."]
[]
[]
[null,null,null,"Assumption",null,"Source"]
[null,1,null,"Revenues and expenses are projected over the same 20-year operating period for all technologies. The tool can tolerate construction periods greater than 1 and less than 3 years. "]
[null,2,null,"When electing to finance the purchase of replacement composting equipment, short-term debt and equity assumptions applied to the initial investment are also applied to all replacement equipment purchases over the life of the project."]
[null,3,null,"When electing to purchase land, it is assumed that the land is financed along with the facility, but is sold at the end of the project life. The value of the land is inflated at the general rate of inflation."]
[null,4,null,"Interest does not accrue during the construction period. Debt service begins in YR 1 of operations."]
[null,5,null,"Compost sale prices assume bulk material sales. "]
[null,6,null,"Maintenance and insurance expenses are calculated as a percentage of capex prior to contingencies being added in."]

{"sheet":"13-Sources","index":14,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sources"]
[]
[null,null,"Source"]
[null,1,"Angelonidi, Eleni and Stephen R. Smith. \"A Comparison of Wet and Dry Anaerobic Digestion Processes for the Treatment of Municipal Solid Waste and Food Waste.\" Water and Environment Journal, 29, 2015. pp. 549-557."]
[null,{"$f":"B5+1","v":2},"Agri-Food and Biosciences Institute, Peter Frost and Stephen Gilkinson. August 2010. \"FIRST 18 MONTH PERFORMANCE SUMMARY FOR ANAEROBIC DIGESTION OF DAIRY COW SLURRY AT\nAFBI HILLSBOROUGH.\""]
[null,{"$f":"B6+1","v":3},"Bioferm Energy Systems. \"Anaerobic Digestion FAQ\". Bioferm Energy Systems. n.d. Accssed August 2014."]
[null,{"$f":"B7+1","v":4},"Blair, Charlie. \"Energy from Waste Potential in Scotland.\" January 2010.  https://www.webarchive.org.uk/wayback/archive/3000/https://www.gov.scot/resource/doc/311011/0098129.pdf. Accessed December 2014."]
[null,5,"Chastain, John P. and James J. Camberato. \"Dairy Manure Production and Nutrient Content.\" Confined Animal Manure Manager Certification Program Manual: Dairy Version, 2004."]
[null,6,"Crowe, Matt, Kirsty Nolan, Caitríona Collins, Gerry Carty, Brian Donlon, Merete Kristoffersen, Morten Brøgger, Morten Carlsbæk, Reto Michael Hummelshøj, and Claus Dahl Thomsen (European Topic Centre on Waste). \"Biodegradable Municipal Waste\nManagement in Europe Part 3: Technology and Market Issues.\" January 2002. https://www.eea.europa.eu/publications/topic_report_2001_15_Part3. Accessed July 2014."]
[null,7,"Eunomia Research & Consulting. \"Annexes.\" Costs for Municipal Waste Management in the EU. European Commission, 2002. Web."]
[null,8,"Fachagentur Nachwachsende Rohstoffe (FNR). Biogas: An Introduction. 2013. https://www.fnr.de/fileadmin/Projekte/2021/Mediathek/brosch.biogas-2013-en-web-pdf.pdf."]
[null,9,"Goldstein, Nora. \"High Solids Anaerobic Digestion and Composting in San Jose.\" Biocycle Magazine, March/April 2014, https://www.biocycle.net/2014/03/28/high-solids-anaerobic-digestion-composting-in-san-jose/. Accessed October 2014."]
[null,10,"Italian Composting and Biogas Association. Biogas e Compost: da rifiuti organici selezionati. October 2011. https://www.compost.it/attachments/604_CIC_biogas_e_compost_2011_definitivo.pdf"]
[null,11,"Italian Composting and Biogas Association. July 2014."]
[null,12,"Lansing, Stephanie, Raúl Botero Botero, and Jay F. Martin. \"Waste treatment and biogas quality in small-scale agricultural digesters.\" Bioresource Technology, 99, 13, 2008, pp. 5881-5890."]
[null,13,"Levis, James W. and Morton A. Barlaz (North Carolina State University). Anaerobic Digestion Process Model Documentation. September 2013. Accessed September 2014."]
[null,14,"Levis, James W. and Morton A. Barlaz (North Carolina State University). Composting Process Model Documentation. November 2013. Accessed September 2014."]
[null,15,"Liebrand, Carolyn B., and K. Charles Ling. Cooperative Approaches for Implementation of Dairy Manure Digesters. USDA Rural Development Research Report 217, 2009. https://naldc.nal.usda.gov/catalog/35107."]
[null,16,"Mata-Alvarez, J. Biomethanization of the organic fraction of municipal solid wastes. IWA Publishing. 2003. Chapter 4. Accessed October 2014."]
[null,17,"Midwest Plan Service. Livestock Waste Facilities Handbook. 1985."]
[null,18,"Moriarty, Kristi. Feasibility Study of Anaerobic Digestion of Food Waste in St. Bernard, Louisiana: A Study Prepared in Partnership with the Environmental Protection Agency for the RE-Powering America’s Land Initiative: Siting Renewable Energy on Potentially Contaminated Land and Mine Sites. Golden: National Renewable Energy Laboratory, 2013. Web. Oct 2014."]
[null,19,"Pier for California Energy Commission Report. \"Characterization of Food and Green Wastes As Feedstock for Anaerobic Digesters.\" July 2005. Accessed November 2014."]
[null,20,"Rigby, Hannah and Stephen R. Smith (WRAP). \"New Markets for Digestate from Anaerobic Digestion.\" August 2011. https://archive.wrap.org.uk/sites/files/wrap/New_Markets_for_AD_WRAP_format_Final_v2.c6779ccd.11341.pdf. Accessed November 2014."]
[null,21,"Rogroff, Clark. Rogroff, Clark. “TFC Recycling: Going the Extra Mile.” Waste Advantage Magazine 5, 7, 2014, pp. 21-25. https://www.scsengineers.com/wp-content/uploads/2015/03/Rogoff_Clark_Anaerobic_Digestion_WASTEADVANTAGE.pdf. Accessed November 2014."]
[null,22,"Rynk, R., Maarten va de Kamp, George B. Willson, Mark E. Singley, Tom L. Richard, John J. Kolega, Francis R. Gouin, Lucien Laliberty, Jr., David Kay, Dennis W. Murphy, Harry A.J. Hotink, and William F. Brinton. On-Farm Composting Handbook. Ithaca: Northeast Regional Agricultural Engineering Service, 1992. Web. Oct 2014. https://campus.extension.org/pluginfile.php/48384/course/section/7167/NRAES%20FarmCompost%20manual%201992.pdf."]
[null,23,"SmartFerm for Zero Waste Energy. California. "]
[null,24,"Sniffer (2010). \"Review of Available Literature on the Carbon and Nitrogen Contents and C:N Ratios of Composting Input Feedstock.\" Accessed September 2014."]
[null,25,"Swedish Gas Center, 2012, Basic Data on Biogas- Second Edition, ISBN: 978-91-85207-10-7. "]
[null,26,"Tolvik Consulting. The Economics of Anaerobic Digestion of Source Segregated Organic Wastes in the UK. Edition 2. 2010. Accessed September 2014."]
[null,27,"University of Minnesota. \"Anaerobic Digester Economics\" Spreadsheet. 2009. "]
[null,28,"US Environmental Protection Agency. \"The Benefits of Anaerobic Digestion of Food Waste At Wastewater Treatment Facilities.\" n.d. https://archive.epa.gov/region9/organics/web/pdf/why-anaerobic-digestion.pdf. "]
[null,29,"Wheeler, PA and L de Rome.  Waste Pre-Treatment: A Review. R&D Technical Report PI-344/TR. Bristol: Environment Agency, 2002."]
[null,30,"World Bank. PPP conversion factor, private consumption (LCU per international $). n.d. https://data.worldbank.org/indicator/PA.NUS.PRVT.PP. Accessed October 2017."]
[null,31,"WRAP. Summary Report – Material Bulk Densities, Report prepared by Resource Futures. 2009. https://silo.tips/download/material-bulk-densities. Accessed June 2015."]

{"sheet":"25-Misc","index":15,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"TPY"]
["Wet AD",20000,40000,60000,80000,null,20000,40000,60000,80000]
["Min Capex",5000000,7000000,8000000,9000000,null,{"$f":"B4*1.29","v":6450000},{"$f":"C4*1.29","v":9030000},10320000,11610000]
["Min Capex/Tonne",{"$f":"B4/B3","v":250},{"$f":"C4/C3","v":175},{"$f":"D4/D3","v":133.33333333333334},{"$f":"E4/E3","v":112.5},null,{"$f":"B5*1.29","v":322.5},225.75,172.00000000000003,145.125]
["Max Capex",{"$f":"B7*B3","v":6000000},{"$f":"C7*C3","v":11000000},{"$f":"D7*D3","v":15000000},{"$f":"E7*E3","v":16000000},null,{"$f":"B6*1.29","v":7740000},14190000,19350000,20640000]
["Max Capex/Tonne",{"$f":"300","v":300},{"$f":"275","v":275},{"$f":"250","v":250},{"$f":"200","v":200},null,{"$f":"B7*1.29","v":387},354.75,322.5,258]
[]
["% Cheaper",0.1]
[null,"TPY"]
["Dry AD",20000,40000,60000,80000,null,20000,40000,60000,80000]
["Min Capex",{"$f":"B4*(1-$B$9)","v":4500000},{"$f":"C4*(1-$B$9)","v":6300000},{"$f":"D4*(1-$B$9)","v":7200000},{"$f":"E4*(1-$B$9)","v":8100000},null,{"$f":"B12*1.29","v":5805000},{"$f":"C12*1.29","v":8127000},9288000,10449000]
["Min Capex/Tonne",{"$f":"B12/B11","v":225},{"$f":"C12/C11","v":157.5},{"$f":"D12/D11","v":120},{"$f":"E12/E11","v":101.25},null,{"$f":"B13*1.29","v":290.25},203.17500000000001,154.80000000000001,130.61250000000001]
["Max Capex",{"$f":"B6*(1-$B$9)","v":5400000},{"$f":"C6*(1-$B$9)","v":9900000},{"$f":"D6*(1-$B$9)","v":13500000},{"$f":"E6*(1-$B$9)","v":14400000},null,{"$f":"B14*1.29","v":6966000},12771000,17415000,18576000]
["Max Capex/Tonne",{"$f":"B14/B11","v":270},{"$f":"C14/C11","v":247.5},{"$f":"D14/D11","v":225},{"$f":"E14/E11","v":180},null,{"$f":"B15*1.29","v":348.3},319.27500000000003,290.25,232.20000000000002]
[]
[]
["Complete Mix- Without dewatering"]
["Cows",250,500,700,2000,3000,4000,5000]
["Lbs /year",{"$f":"B19*120*365","v":10950000},{"$f":"C19*120*365","v":21900000},{"$f":"120*D19*365","v":30660000},{"$f":"120*E19*365","v":87600000},{"$f":"120*F19*365","v":131400000},{"$f":"120*G19*365","v":175200000},{"$f":"120*H19*365","v":219000000}]
["MT/year",{"$f":"B20/2204.62","v":4966.8423583202548},{"$f":"C20/2204.62","v":9933.6847166405096},{"$f":"D20/2204.62","v":13907.158603296713},39734.738866562038,59602.108299843057,79469.477733124077,99336.847166405103]
["Low",null,684445,811545,1637695,2273195,2908695,3544195]
["High",null,810897,961478,1940260,2693169,3446078,4198987]
[]
["dewatering costs"]
["Low",null,12846,15231,30737,42664,54591,66519]
["High",null,96344,114235,230526,319981,409435,498890]