formualizer

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.

Summary ResultsB6:D47

Saved workbook valuesOutput

RowBCD
6Outputs SummaryunitsCurrent Model Run
7Net Year-One Cost of Energy (COE)¢/kWh11.35
8Annual Escalation of Year-One COE%0.0%
9Percentage of Tariff Escalated%0.0%
10Does modeled project meet minimum DSCR requirements?No, see Inputs Worksheet
14Net Nominal Levelized Cost of Energy¢/kWh11.35
24Production, Yr 1kWh3,626,640
29Net 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 / descriptionType / constraints / default
system_size_kw

Generator Nameplate Capacity; units: kW. Positive input unless explicitly an escalation factor; escalation may be negative.

Type: number

Default: 500

tipping_fee_per_ton

Tipping Fee - Source #1; units: USD/ton. Positive input unless explicitly an escalation factor; escalation may be negative.

Type: number

Default: 30

tipping_quantity_tons_year

Quantity Received Each Year; units: tons per year. Positive input unless explicitly an escalation factor; escalation may be negative.

Type: number

Default: 10000

electrical_efficiency

Electrical 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

availability

Availability; 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_load

Station 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_detail

Select 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_kw

Total 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_detail

Select 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_year

Fixed 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_kwh

Variable 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_ton

Feedstock 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_rate

Interest 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 / descriptionType / constraints / default
year_one_coe_cents_per_kwh

Required first-year tariff; cents/kWh.

Type: number

nominal_lcoe_cents_per_kwh

Nominal levelized cost of energy; cents/kWh.

Type: number

year_one_energy_kwh

Net electricity after station service; kWh/year.

Type: number

net_installed_cost

Capital cost less grants; USD, positive cost.

Type: number

after_tax_equity_irr_year20

Actual 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/mcp

Slug: 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.