formualizer

Excel workbook · Catalog edition v1.4

NREL CREST Fuel Cell Cash-Flow Model

National Renewable Energy Laboratory (NREL / DOE)

CREST v1.4 fuel cell required tariff, nominal LCOE, project finance and after-tax equity return calculator.

Inputs
132
Outputs
12
File size
219 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)¢/kWh12.85
8Annual Escalation of Year-One COE%0.0%
9Percentage of Tariff Escalated%0.0%
10Does modeled project meet minimum DSCR requirements?Yes
14Net Nominal Levelized Cost of Energy¢/kWh12.85
24Production, Yr 1kWh25,898,940
29Net Installed Cost (Total Installed Cost less Grants)$$17,337,500

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_fuelcell_lcoe_check. The full port contract includes all 144 ports.

Inputs (15)
Port / descriptionType / constraints / default
unit_count

# of units; units: #. Positive input unless explicitly an escalation factor; escalation may be negative.

Type: number

Default: 1

capacity_per_unit_kw

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

Type: number

Default: 3650

electrical_efficiency

Initial Electrical Conversion Efficiency (Year 1); 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.48

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.9

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: 4750

federal_incentive_type

Select Form of Federal Incentives; units: dimensionless or exact text enum. Case-sensitive source text. Allowed values: Cost-Based | Performance-Based | Neither.

Type: string

Constraints: one of: Cost-Based, Performance-Based, Neither

Default: "Cost-Based"

federal_cost_incentive_form

Investment Tax Credit (ITC) or Cash Grant?; units: dimensionless or exact text enum. Case-sensitive source text. Allowed values: ITC | Cash Grant.

Type: string

Constraints: one of: ITC, Cash Grant

Default: "ITC"

itc_fraction

ITC or Cash Grant Amount ; units: decimal fraction (0.30 = 30%). Positive input unless explicitly an escalation factor; escalation may be negative. Active only when federal_incentive_type = Cost-Based and federal_cost_incentive_form = ITC.

Type: number

Constraints: min: -1; max: 1

Default: 0.3

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: 250

fuel_cost_per_mmbtu

Fuel Cost ; units: USD/MMBtu. 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: 4

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.4

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 fuel cell LCOE with NREL CREST
  • Compare fuel cell debt coverage and equity returns
  • Model fuel cell 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-fuel-cell · 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-fuel-cell",
    "edition": "v1.4",
    "flow": "quick_fuelcell_lcoe_check",
    "inputs": {
      "unit_count": 2,
      "capacity_per_unit_kw": 1000,
      "electrical_efficiency": 0.55,
      "availability": 0.95,
      "capital_cost_detail": "Simple",
      "installed_cost_per_kw": 4000,
      "om_cost_detail": "Intermediate",
      "fuel_cost_per_mmbtu": 3,
      "debt_fraction": 0.5,
      "debt_interest_rate": 0.06,
      "federal_incentive_type": "Cost-Based",
      "federal_cost_incentive_form": "ITC",
      "itc_fraction": 0.3
    }
  }
}

cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

Flows

quick_fuelcell_lcoe_check

Quick fuel cell 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.

15 input ports · 5 output ports. Full membership in the port contract.

full_fuelcell_project_finance

Full fuel cell 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.

132 input ports · 12 output ports. Full membership in the port contract.

REST example

Bundle scenario: efficient_chp · Flow: quick_fuelcell_lcoe_check

curl 'https://catalog.formualizer.com/v1/models/nrel-crest-fuel-cell/v1.4/evaluate?flow=quick_fuelcell_lcoe_check' \
  -H 'Content-Type: application/json' \
  --data '{"inputs":{"unit_count":2,"capacity_per_unit_kw":1000,"electrical_efficiency":0.55,"availability":0.95,"capital_cost_detail":"Simple","installed_cost_per_kw":4000,"om_cost_detail":"Intermediate","fuel_cost_per_mmbtu":3,"debt_fraction":0.5,"debt_interest_rate":0.06,"federal_incentive_type":"Cost-Based","federal_cost_incentive_form":"ITC","itc_fraction":0.3}}'

Expected response

Expected values from the bundle, subject to the check level above.

{
  "outputs": {
    "year_one_coe_cents_per_kwh": 9.95,
    "nominal_lcoe_cents_per_kwh": 9.949999999999994,
    "year_one_energy_kwh": 14979599.999999996,
    "net_installed_cost": 8000000,
    "after_tax_equity_irr_year20": 0.11709220563337322
  }
}

Looking for another spreadsheet? Request a workbook.