Excel workbook · Catalog edition v1.4
NREL CREST Anaerobic Digestion Cash-Flow Model
National Renewable Energy Laboratory (NREL / DOE)
CREST v1.4 anaerobic digestion required tariff, nominal LCOE, project finance and after-tax equity return calculator.
- Inputs
- 148
- Outputs
- 12
- File size
- 220 KB
- Verification
- Engine regression check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesOutput
| Row | B | C | D |
|---|---|---|---|
| 6 | Outputs Summary | units | Current Model Run |
| 7 | Net Year-One Cost of Energy (COE) | ¢/kWh | 11.35 |
| 8 | Annual Escalation of Year-One COE | % | 0.0% |
| 9 | Percentage of Tariff Escalated | % | 0.0% |
| 10 | Does modeled project meet minimum DSCR requirements? | No, see Inputs Worksheet | |
| 14 | Net Nominal Levelized Cost of Energy | ¢/kWh | 11.35 |
| 24 | Production, Yr 1 | kWh | 3,626,640 |
| 29 | Net Installed Cost (Total Installed Cost less Grants) | $ | $3,750,000 |
What was checked
Scenarios match the engine’s own earlier results, not an independent check.
Scope and limitations
Catalog calculations, not certification.
Try it uses Formualizer’s own tariff solver in place of Excel’s What-If tables.
- Three native What-If tables are recalculated at all 33 trial tariffs; midpoint rounding preserves 0.1-cent bracket resolution. Supported source tariff interval 0..100 cents/kWh.
- Complex year schedules can be edited with cellOverrides. Source edition metadata follows the supplied v1.4 catalog edition; source workbook does not establish current-law suitability.
- Source-grid What-If solver; baseline cached-value comparison and perturbed regression vectors.
What it computes
Ports for the compact flow: quick_biogas_lcoe_check. The full port contract includes all 160 ports.
Inputs (14)
| Port / description | Type / constraints / default |
|---|---|
system_size_kwGenerator Nameplate Capacity; units: kW. Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Default: 500 |
tipping_fee_per_tonTipping Fee - Source #1; units: USD/ton. Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Default: 30 |
tipping_quantity_tons_yearQuantity Received Each Year; units: tons per year. Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Default: 10000 |
electrical_efficiencyElectrical Conversion Efficiency; units: decimal fraction (0.30 = 30%). Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Constraints: min: -1; max: 1 Default: 0.35 |
availabilityAvailability; units: decimal fraction (0.30 = 30%). Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Constraints: min: -1; max: 1 Default: 0.92 |
parasitic_loadStation Service (Parasitic Load); units: decimal fraction (0.30 = 30%). Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Constraints: min: -1; max: 1 Default: 0.1 |
capital_cost_detailSelect Cost Level of Detail; units: dimensionless or exact text enum. Case-sensitive source text. Allowed values: Simple | Intermediate | Complex. | Type: string Constraints: one of: Simple, Intermediate, Complex Default: "Simple" |
installed_cost_per_kwTotal Installed Cost; units: USD/kW. Positive input unless explicitly an escalation factor; escalation may be negative. Active only when capital_cost_detail = Simple; USD/kW (not USD/W). | Type: number Default: 7500 |
om_cost_detailSelect Cost Level of Detail; units: dimensionless or exact text enum. Case-sensitive source text. Allowed values: Simple | Intermediate. | Type: string Constraints: one of: Simple, Intermediate Default: "Intermediate" |
fixed_om_per_kw_yearFixed O&M Expense, Yr 1; units: USD/kW-yr. Positive input unless explicitly an escalation factor; escalation may be negative. Active only when om_cost_detail = Simple. | Type: number Default: 300 |
variable_om_cents_per_kwhVariable O&M Expense, Yr 1; units: cents/kWh . Positive input unless explicitly an escalation factor; escalation may be negative. Active only when om_cost_detail = Simple. | Type: number Default: 3 |
feedstock_cost_per_tonFeedstock Expense, if applicable; units: USD/ton. Positive input unless explicitly an escalation factor; escalation may be negative. Active only when om_cost_detail = Intermediate; Simple O&M replaces the entire operating-cost schedule. | Type: number Default: 0 |
debt_fraction% Debt (% of hard costs) (mortgage-style amort.); units: decimal fraction (0.30 = 30%). Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Constraints: min: -1; max: 1 Default: 0.55 |
debt_interest_rateInterest Rate on Term Debt; units: decimal fraction (0.30 = 30%). Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Constraints: min: -1; max: 1 Default: 0.07 |
Outputs (5)
| Port / description | Type / constraints / default |
|---|---|
year_one_coe_cents_per_kwhRequired first-year tariff; cents/kWh. | Type: number |
nominal_lcoe_cents_per_kwhNominal levelized cost of energy; cents/kWh. | Type: number |
year_one_energy_kwhNet electricity after station service; kWh/year. | Type: number |
net_installed_costCapital cost less grants; USD, positive cost. | Type: number |
after_tax_equity_irr_year20Actual cumulative equity IRR at year 20; decimal fraction, distinct from target. | Type: number |
Questions this workbook answers
- Calculate anaerobic digestion LCOE with NREL CREST
- Compare anaerobic digestion debt coverage and equity returns
- Model anaerobic digestion capital and operating cost sensitivity
Questions and answers
What does CREST LCOE represent?
The model solves a cost-based tariff for a target equity return and reports nominal levelized cost in cents/kWh.
What units do inputs use?
Costs are USD/kW, USD/year, cents/kWh or fuel/feedstock units stated per port. Percentages are decimal fractions. Simple capital and O&M modes activate their scalar cost inputs.
Are these current tax assumptions?
This historical v1.4 workbook retains its source tax and incentive assumptions. Review these inputs for the intended analysis.
How is the workbook checked?
The baseline is checked against Excel cached values. Two perturbed scenarios are deterministic WASM regressions; they have not been recalculated independently in Excel.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: nrel-crest-anaerobic-digestion · Edition: v1.4
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "nrel-crest-anaerobic-digestion",
"edition": "v1.4",
"flow": "quick_biogas_lcoe_check",
"inputs": {
"system_size_kw": 1000,
"availability": 0.94,
"capital_cost_detail": "Simple",
"installed_cost_per_kw": 6500,
"om_cost_detail": "Intermediate",
"tipping_fee_per_ton": 35,
"tipping_quantity_tons_year": 15000,
"debt_fraction": 0.6,
"debt_interest_rate": 0.06
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_biogas_lcoe_check
Quick anaerobic digestion LCOE check
Primary operating, capital, financing and revenue assumptions; omitted assumptions retain source defaults. Simple capex/O&M switches activate corresponding scalar costs. All percentages are decimal fractions.
14 input ports · 5 output ports. Full membership in the port contract.
full_biogas_project_finance
Full anaerobic digestion project finance
All mapped scalar assumptions, incentives, reserves and depreciation allocations with finance diagnostics. Detailed year-by-year Complex schedules and formula-derived replacement years use cellOverrides; selectCells and trace expose additional diagnostics.
148 input ports · 12 output ports. Full membership in the port contract.
REST example
Bundle scenario: larger_digester · Flow: quick_biogas_lcoe_check
curl 'https://catalog.formualizer.com/v1/models/nrel-crest-anaerobic-digestion/v1.4/evaluate?flow=quick_biogas_lcoe_check' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"system_size_kw":1000,"availability":0.94,"capital_cost_detail":"Simple","installed_cost_per_kw":6500,"om_cost_detail":"Intermediate","tipping_fee_per_ton":35,"tipping_quantity_tons_year":15000,"debt_fraction":0.6,"debt_interest_rate":0.06}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"year_one_coe_cents_per_kwh": 8.849999999999998,
"nominal_lcoe_cents_per_kwh": 8.849999999999993,
"year_one_energy_kwh": 7410959.999999999,
"net_installed_cost": 6500000,
"after_tax_equity_irr_year20": 0.1184021835899466
}
}Looking for another spreadsheet? Request a workbook.