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.
Saved workbook valuesOutput
| Row | B | C | D |
|---|---|---|---|
| 6 | Outputs Summary | units | Current Model Run |
| 7 | Net Year-One Cost of Energy (COE) | ¢/kWh | 12.85 |
| 8 | Annual Escalation of Year-One COE | % | 0.0% |
| 9 | Percentage of Tariff Escalated | % | 0.0% |
| 10 | Does modeled project meet minimum DSCR requirements? | Yes | |
| 14 | Net Nominal Levelized Cost of Energy | ¢/kWh | 12.85 |
| 24 | Production, Yr 1 | kWh | 25,898,940 |
| 29 | Net 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 / description | Type / 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_kwCapacity per Unit; units: kW. Positive input unless explicitly an escalation factor; escalation may be negative. | Type: number Default: 3650 |
electrical_efficiencyInitial 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 |
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.9 |
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: 4750 |
federal_incentive_typeSelect 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_formInvestment 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_fractionITC 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_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: 250 |
fuel_cost_per_mmbtuFuel 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_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 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/mcpSlug: 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.