{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Pro Forma"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2]]}
["Instructions for Use:"]
[null,"Applicants should enter data in cells shaded green and provide descriptions in place of the text formatted in blue.  The numbers that are currently entered in the example cells are simply illustrative and should not be used as is.  Applicant may manipulate spreadsheet to incorporate pertinent information not included in this standard form.  If additional lines are inserted, make sure the totals include the inserted cells."]
[]
[]
["Assumptions:"]
[null,"Inflation Rate:","Fixed at 2.4% (Line 41)"]
[null,"Interest Rate on Debt:","Fixed at 8% (Line 197)"]
[null,"Term of Loan:","15 years (Line 198)"]
[null,"Product Pricing:","2.5 cents per 1000 BTU, low heating value, 2009 dollars (Lines 44-47)"]
[]
["Clarifications:"]
[null,"Line 32 - \"Other Consumed\""]
[null,null,"Include any other sources of energy in the plant, this should also include any coal, biomass, lignin, or syngas slipstreams.  Insert additional lines for each source as necessary.  To assign a value, if biomass feedstock is used in a direct fire boiler, use the same price/unit that is shown in \"Feedstock Pricing.\"  If lignin (or another potential waste product) is used, this could be shown as a credit equal to the cost that would be incurred to dispose of the waste.  For syngas or other slipstreams, base the value on the foregone income that would be realized if the stream were directed to the final product."]
[]
[null,"Line 37 - \"Other Wastes\""]
[null,null,"Include any ash, wastewater sludge, or any other waste streams that will need to be disposed of.  In this section, report in tons/year."]
[]
[null,"Line 60 - \"Other Consumed\""]
[null,null,"Include costs for all sources that were added in Line 32 - \"Other Consumed.\"  In this section, report in $/unit."]
[]
[null,"Feedstock Costs"]
[null,null,"This should include any expenses incurred in processing (chipping, grinding) the feedstock into a form that can be fed into the reactor.  For MSW, do not include the cost of transportation of the bulk material or separation/segration costs.  Processing costs for MSW are restricted to post-sorted materials. "]
[]
[null,"Miscellaneous Process Supplies"]
[null,null,"Examples of expenses to include in this section include (but are not limited to): chemicals such as wastewater treatment consumables, catalyst and catalyst regeneration expenses, and fermenting organisms"]
[]
[null,"IP Fees"]
[null,null,"Account for any IP fees or royalties related to the project.  State the basis for calculating the expense, for example, annual flat-rate, as a percentage of revenue or other."]

{"sheet":"Pro Forma","index":1,"n_rows":210,"n_cols":15,"rows_kept":210,"cut":false,"hidden":false,"merged":[[210,0,210,14],[7,0,7,14],[206,0,206,14],[207,0,207,14],[208,0,208,14],[209,0,209,14]]}
["Appendix H: Cash Flow Pro-Forma DE-FOA-0002396"]
["FY21 BETO Scale-up and Conversion FOA DE-FOA-0002396",{"$nulls":4},"Name of Company",null,null,"Company Name Here"]
["Generic Pro-Forma",{"$nulls":4},"Name of Facility",null,null,"Facility Name Here"]
[{"$nulls":5},"Commercial Operation Date",null,null,"Date Here"]
[{"$nulls":5},"Facility Capitalized Construction Cost",null,null,99000000]
[]
[]
["Projected Operating Results"]
[]
["Federal Fiscal Year Ending September 30,",{"$nulls":4},"Example",2022,{"$f":"G10+1","v":2023},2024,2025,2026,2027,2028,2029,2030]
[]
["PERFORMANCE"]
[null,"Plant Operating Days",null,null,null,350]
[null,"Plant Availability Factor",null,null,null,{"$f":"F13/365","v":0.95890410958904104}]
[]
[null,"Production",null,null,"Units(1)"]
[null,"#1","Product Number One Name Here",null,"XX/year",1000]
[null,"#2","Product Number Two Name Here",null,"XX/year",1000]
[null,"#3","Product Number Three Name Here",null,"XX/year",1000]
[null,"#4","Product Number Four Name Here",null,"XX/year",1000]
[]
[null,"Feedstock Consumption",null,null,"Units(1)"]
[null,"A","Feedstock Number One Name Here",null,"XX/year",1000]
[null,"B","Feedstock Number Two Name Here",null,"XX/year",1000]
[null,"C","Feedstock Number Three Name Here",null,"XX/year",1000]
[null,"D","Feedstock Number Four Name Here",null,"XX/year",1000]
[null,"E","Feedstock Number Five Name Here",null,"XX/year",1000]
[]
[null,"Utility Consumption"]
[null,null,"Natural Gas Consumed",null,"MMBTU",1000]
[null,null,"Net Electricity Consumed",null,"MWh",1000]
[null,null,"Water Consumed",null,"kGal",1000]
[null,null,"Other Consumed",null,"XX",1000]
[]
[null,"Facility Emissions & Wastes"]
[null,null,"SO2",null,"tons/yr",1000]
[null,null,"NOx",null,"tons/yr",1000]
[null,null,"Other Wastes",null,"tons/yr",1000]
[]
["COMMODITY PRICES"]
[]
[null,"General Inflation",null,null,null,2.4E-2]
[]
[null,"Product Pricing",null,null,"Units(1)"]
[null,"#1","Product Number One Name Here",null,"$/XX",1]
[null,"#2","Product Number Two Name Here",null,"$/XX",1]
[null,"#3","Product Number Three Name Here",null,"$/XX",1]
[null,"#4","Product Number Four Name Here",null,"$/XX",1]
[]
[null,"Feedstock Pricing",null,null,"Units(1)"]
[null,"A","Feedstock Number One Name Here",null,"$/XX",1]
[null,"B","Feedstock Number Two Name Here",null,"$/XX",1]
[null,"C","Feedstock Number Three Name Here",null,"$/XX",1]
[null,"D","Feedstock Number Four Name Here",null,"$/XX",1]
[null,"E","Feedstock Number Five Name Here",null,"$/XX",1]
[]
[null,"Utility Consumption"]
[null,null,"Natural Gas Consumed",null,"$/MMBTU",10.49]
[null,null,"Net Electricity Consumed",null,"$/MWh",54.53]
[null,null,"Water Consumed",null,"$/kGal",1.25]
[null,null,"Other Consumed",null,"$/XX",1]
[]
[null,"Emmissions & Waste Allowances"]
[null,null,"SO2",null,"$/ton",1]
[null,null,"NOx",null,"$/ton",1]
[null,null,"Other Wastes",null,"$/ton",1]
[]
["OPERATING REVENUES"]
[null,"Product Revenues"]
[null,"#1","Product Number One Name Here",null,null,{"$f":"F17*F45","v":1000}]
[null,"#2","Product Number Two Name Here",null,null,{"$f":"F18*F46","v":1000}]
[null,"#3","Product Number Three Name Here",null,null,{"$f":"F19*F47","v":1000}]
[null,"#4","Product Number Four Name Here",null,null,{"$f":"F20*F48","v":1000}]
[]
[null,"TOTAL OPERATING REVENUES",null,null,null,{"$f":"SUM(F70:F73)","v":4000}]
[]
["OPERATING EXPENSES"]
[null,"Variable Operating Costs"]
[]
[null,null,"Feedstock Costs"]
[null,null,"A - Feedstock Number One Name Here",null,null,{"$f":"F23*F51","v":1000}]
[null,null,"B - Feedstock Number Two Name Here",null,null,{"$f":"F24*F52","v":1000}]
[null,null,"C - Feedstock Number Three Name Here",null,null,{"$f":"F25*F53","v":1000}]
[null,null,"D - Feedstock Number Four Name Here",null,null,{"$f":"F26*F54","v":1000}]
[null,null,"E - Feedstock Number Five Name Here",null,null,{"$f":"F27*F55","v":1000}]
[]
[null,null,"Total Feedstock Costs",null,null,{"$f":"SUM(F81:F85)","v":5000}]
[]
[null,null,"Utility Costs"]
[null,null,"Natural Gas Consumed",null,null,{"$f":"F58*F30","v":10490}]
[null,null,"Net Electricity Consumed",null,null,{"$f":"F59*F31","v":54530}]
[null,null,"Water Consumed",null,null,{"$f":"F60*F32","v":1250}]
[null,null,"Other Consumed",null,null,1000]
[]
[null,null,"Total Utility Costs",null,null,{"$f":"SUM(F90:F93)","v":67270}]
[]
[null,null,"Emissions & Waste Allowance Costs"]
[null,null,"SO2",null,null,{"$f":"F36*F64","v":1000}]
[null,null,"NOx",null,null,{"$f":"F37*F65","v":1000}]
[null,null,"Other Wastes",null,null,1000]
[]
[null,null,"Total Emissions Allowance Costs",null,null,{"$f":"SUM(F98:F100)","v":3000}]
[]
[null,null,"Product Transportation Pricing"]
[null,null,"#1 - Product Number One Name",null,"$/XX",1]
[null,null,"#2 - Product Number Two Name",null,"$/XX",1]
[null,null,"#3 - Product Number Three Name",null,"$/XX",1]
[null,null,"#4 - Product Number Four Name",null,"$/XX",1]
[]
[null,null,"Product Transportation Cost"]
[null,null,"#1 - Product Number One Name",null,null,{"$f":"F105*F17","v":1000}]
[null,null,"#2 - Product Number Two Name",null,null,{"$f":"F106*F18","v":1000}]
[null,null,"#3 - Product Number Three Name",null,null,{"$f":"F107*F19","v":1000}]
[null,null,"#4 - Product Number Four Name",null,null,{"$f":"F108*F20","v":1000}]
[]
[null,null,"Total Product Transportation Cost",null,null,{"$f":"SUM(F111:F114)","v":4000}]
[]
[null,null,"Feedstock Transportation Pricing"]
[null,null,"A - Feedstock Number One Name",null,"$/XX",1]
[null,null,"B - Feedstock Number Two Name",null,"$/XX",1]
[null,null,"C - Feedstock Number Three Name",null,"$/XX",1]
[null,null,"D - Feedstock Number Four Name",null,"$/XX",1]
[null,null,"E - Feedstock Number Five Name",null,"$/XX",1]
[]
[null,null,"Feedstock Transportation Cost"]
[null,null,"A - Feedstock Number One Name",null,null,{"$f":"F119*F23","v":1000}]
[null,null,"B - Feedstock Number Two Name",null,null,{"$f":"F120*F24","v":1000}]
[null,null,"C - Feedstock Number Three Name",null,null,{"$f":"F121*F25","v":1000}]
[null,null,"D - Feedstock Number Four Name",null,null,{"$f":"F122*F26","v":1000}]
[null,null,"E - Feedstock Number Five Name",null,null,{"$f":"F123*F27","v":1000}]
[]
[null,null,"Total Feedstock Transportation Cost",null,null,{"$f":"SUM(F126:F130)","v":5000}]
[]
[null,null,"Product Marketing Pricing"]
[null,null,"#1 - Product Number One Name",null,"% of Revenue",0.01]
[null,null,"#2 - Product Number Two Name",null,"% of Revenue",0.02]
[null,null,"#3 - Product Number Three Name",null,"% of Revenue",0.03]
[null,null,"#4 - Product Number Four Name",null,"% of Revenue",0.04]
[]
[null,null,"Product Marketing Cost"]
[null,null,"#1 - Product Number One Name",null,null,{"$f":"F135*F70","v":10}]
[null,null,"#2 - Product Number Two Name",null,null,{"$f":"F136*F71","v":20}]
[null,null,"#3 - Product Number Three Name",null,null,{"$f":"F137*F72","v":30}]
[null,null,"#4 - Product Number Four Name",null,null,{"$f":"F138*F73","v":40}]
[]
[null,null,"Total Product Marketing Cost",null,null,{"$f":"SUM(F141:F144)","v":100}]
[]
[null,null,"Miscellaneous Process Supplies"]
[null,null,"Z - Misc Number One Name",null,null,1000]
[null,null,"Y - Misc Number Two Name",null,null,1000]
[null,null,"X - Misc Number Three Name",null,null,1000]
[null,null,"W - Misc Number Four Name",null,null,1000]
[null,null,"V - Misc Number Five Name",null,null,1000]
[]
[null,null,"Total Miscellaneous Supplies Cost",null,null,{"$f":"SUM(F149:F153)","v":5000}]
[]
[null,null,"Total Variable Operating Costs",null,null,{"$f":"F87+F95+F102+F116+F132+F146+F155","v":89370}]
[]
[null,"Fixed Operating Costs"]
[null,null,"Payroll & Benefits",null,"% of Revenue",0.3]
[{"$nulls":5},{"$f":"F160*F75","v":1200}]
[null,null,"Fixed Operating Expenses",null,"% of Revenue",0.01]
[{"$nulls":5},{"$f":"F162*F75","v":40}]
[null,null,"Annual Maintenance",null,"% of Capex",2.5000000000000001E-2]
[{"$nulls":5},{"$f":"F164*$I$5","v":2475000}]
[]
[null,null,"Total Fixed Operating Costs",null,null,{"$f":"F161+F163+F165","v":2476240}]
[]
[null,"General & Administrative"]
[null,null,"Corporate Overhead",null,"% of Revenue",0.08]
[{"$nulls":5},{"$f":"F170*F87","v":400}]
[null,null,"Insurance",null,"% of Capex",0.02]
[{"$nulls":5},{"$f":"F172*$I$5","v":1980000}]
[null,null,"Property Tax",null,"% of Capex",0.04]
[{"$nulls":5},{"$f":"F174*$I$5","v":3960000}]
[null,null,"Management Fees",null,"% of Revenue",0.04]
[{"$nulls":5},{"$f":"F176*F75","v":160}]
[null,null,"IP Fees",null,"% of X","%"]
[]
[]
[null,null,"Total G&A Expenses",null,null,{"$f":"F171+F173+F175+F177+F179","v":5940560}]
[]
[null,"Contingency"]
[null,null,"Contingency",null,"% of O&M, G&A",0.05]
[{"$nulls":5},{"$f":"(F181+F167)*F184","v":420840}]
[]
[null,null,"Total Contingency",null,null,{"$f":"F177+F181+F183+F185","v":6361560}]
[]
[null,"TOTAL OPERATING EXPENSES",null,null,null,{"$f":"F157+F167+F181+F187","v":14867730}]
[]
["NET OPERATING REVENUES",{"$nulls":4},{"$f":"F75-F189","v":-14863730}]
[]
["DEBT SERVICE"]
[null,"Capitalized Construction Cost (from top of sheet)",null,null,null,{"$f":"I5","v":99000000}]
[null,"Equity Contribution",null,null,null,29000000]
[null,"Total Debt Financing",null,null,null,{"$f":"F194-F195","v":70000000}]
[]
[null,"Interest Rate on Debt",null,null,"Annual %",0.08]
[null,"Term of Loan",null,null,"Years",15]
[null,"Monthly Payment on Loan",null,null,null,{"$f":"PMT(F198/12,F199*12,F196)","v":-668956.45903124602}]
[]
[null,"ANNUAL DEBT SERVICE",null,null,null,{"$f":"$F$200*12","v":-8027477.5083749518}]
[]
["NET REVENUES",{"$nulls":4},{"$f":"F191+F202","v":-22891207.508374952}]
[]
["Notes:"]
["(1) Units should be converted to match between Performance and Pricing sections"]
["(2) Text in Blue should be modified to match applicants names, products, units, etc."]
["(3) Grouped rows, for example product transportation pricing, may be rolled up after data entry to simplify pro-forma output"]
["(4) Applicant may manipulate spreadsheet to incorporate pertinent information not included in the standard form"]