formualizer

Excel workbook · Catalog edition v1.4

NREL CREST Geothermal Cash-Flow Model

National Renewable Energy Laboratory (NREL / DOE)

NREL CREST v1.4 geothermal cost-of-energy and project-finance model with tax incentives, debt service and after-tax equity returns.

Inputs
144
Outputs
17
File size
251 KB
Verification
Engine regression check

Try it

Try it loads a copy of this file from formualizer.com.

Summary ResultsB6:D46

Saved workbook valuesOutput

RowBCD
6Outputs SummaryunitsCurrent Model Run
7Net Year-One Cost of Energy (COE)¢/kWh18.55
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¢/kWh18.55
21Production, Yr 1kWh112,347,000
26Net Installed Cost$$144,341,779

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.

  • Historical CREST v1.4 assumptions retain the source tax and incentive defaults; they are not current policy advice.
  • Changed-input scenarios are engine regression checks; only baseline values have an independent original Excel cache comparison. Cash flows with multiple sign changes may have multiple IRR roots.
  • Cascaded one-variable tariff tables are evaluated at each trial point; the final tariff uses the source 0.1-cent bracket midpoint, so target-return NPV need not be exactly zero.

What it computes

Ports for the compact flow: quick_geothermal_lcoe_check. The full port contract includes all 161 ports.

Inputs (12)
Port / descriptionType / constraints / default
system_size_mw

Generator Gross Nameplate Capacity; units: MW. Numeric costs are positive unless stated otherwise.

Type: number

Constraints: min: 0.001

Default: 15

capacity_factor

Net Capacity Factor, Yr 1; units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise. Directly active; this edition has no capacity-factor mode switch.

Type: number

Constraints: min: 0; max: 1

Default: 0.855

om_cost_detail

Select Cost Level of Detail; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. Allowed values: Simple, Intermediate.

Type: string

Constraints: one of: Simple, Intermediate

Default: "Intermediate"

capital_cost_detail

Select Cost Level of Detail; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. Allowed values: Simple, Intermediate, Complex.

Type: string

Constraints: one of: Simple, Intermediate, Complex

Default: "Intermediate"

installed_cost_per_kw

Installed Cost, excluding exploration costs; units: USD/kW. Numeric costs are positive unless stated otherwise. Active only when capital_cost_detail = Simple. Excludes exploration costs and retains workbook phase-finance uplift.

Type: number

Constraints: min: 0.001

Default: 3200

fixed_om_per_kw_year

Fixed O&M Expense, Yr 1; units: USD/kW/year. Numeric costs are positive unless stated otherwise. Active only when om_cost_detail = Simple.

Type: number

Default: 2

variable_om_cents_per_kwh

Variable O&M Expense, Yr 1; units: ¢/kWh . Numeric costs are positive unless stated otherwise. Active only when om_cost_detail = Simple.

Type: number

Default: 1

federal_incentive_type

Select Form of Federal Incentive; units: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. 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: workbook selection or ratio/count as labeled. Numeric costs are positive unless stated otherwise. 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%). Numeric costs are positive unless stated otherwise. Active when federal_incentive_type = Cost-Based; federal_cost_incentive_form selects ITC or Cash Grant.

Type: number

Constraints: min: 0; max: 1

Default: 0.3

debt_fraction

% Debt (% of hard costs) (mortgage-style amort.); units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise.

Type: number

Constraints: min: 0; max: 1

Default: 0.5

debt_interest_rate

Interest Rate on Term Debt; units: decimal fraction (0.30 = 30%). Numeric costs are positive unless stated otherwise.

Type: number

Default: 0.07

Outputs (5)
Port / descriptionType / constraints / default
year_one_coe_cents_per_kwh

cents/kWh; year-one tariff, rounded to the midpoint of the 0.1-cent CREST bracket

Type: number

nominal_lcoe_cents_per_kwh

cents/kWh; nominal levelized cost of energy

Type: number

year_one_energy_kwh

kWh/year; positive generation

Type: number

net_installed_cost

USD; positive net capital cost

Type: number

after_tax_equity_irr_year25

decimal fraction; cumulative equity IRR through year 25

Type: number

Questions this workbook answers

  • Calculate geothermal LCOE with NREL CREST
  • Compare geothermal project financing and tax incentives
  • Estimate geothermal project after-tax equity returns

Questions and answers

What units are required?

Capacity is MW, capex USD/kW, capacity factor and rates decimal fractions, and tariff cents/kWh.

Are the perturbed scenarios checked in Excel?

The baseline is compared against source Excel caches. Perturbed cases are deterministic WASM regression vectors, not independently recalculated Excel oracles.

Does the reported IRR always equal the target return?

No. CREST solves a tariff bracket against target-return NPV. Its separate IRR formula can select a different root when cash flows change sign repeatedly. The 100 MW wind preset exhibits this behavior. Inspect full-flow NPV, DSCR, cash flows and achieved IRR together.

For agents

Connect an MCP client to the catalog endpoint:

https://catalog.formualizer.com/v1/mcp

Slug: nrel-crest-geothermal · 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-geothermal",
    "edition": "v1.4",
    "flow": "quick_geothermal_lcoe_check",
    "inputs": {
      "system_size_mw": 20,
      "capacity_factor": 0.9,
      "capital_cost_detail": "Simple",
      "installed_cost_per_kw": 4500,
      "om_cost_detail": "Simple",
      "fixed_om_per_kw_year": 120,
      "variable_om_cents_per_kwh": 0.5,
      "debt_fraction": 0.55,
      "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_geothermal_lcoe_check

Quick geothermal LCOE check

Capacity, costs, O&M, debt and federal incentive sensitivity. Capacity factor is directly active in this edition. Simple cost modes activate the quick cost inputs; omitted inputs retain source defaults.

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

full_geothermal_project_finance

Full geothermal project finance

All mapped Inputs assumptions and depreciation allocations, plus cash-flow and DSCR diagnostics. Complex Inputs schedules can be supplied through cellOverrides. Expenses and initial equity are negative USD; ratios and rates use decimal fractions.

144 input ports · 17 output ports. Full membership in the port contract.

REST example

Bundle scenario: binary_20mw · Flow: quick_geothermal_lcoe_check

curl 'https://catalog.formualizer.com/v1/models/nrel-crest-geothermal/v1.4/evaluate?flow=quick_geothermal_lcoe_check' \
  -H 'Content-Type: application/json' \
  --data '{"inputs":{"system_size_mw":20,"capacity_factor":0.9,"capital_cost_detail":"Simple","installed_cost_per_kw":4500,"om_cost_detail":"Simple","fixed_om_per_kw_year":120,"variable_om_cents_per_kwh":0.5,"debt_fraction":0.55,"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": 10.45,
    "nominal_lcoe_cents_per_kwh": 10.450000000000006,
    "year_one_energy_kwh": 157680000,
    "net_installed_cost": 108327306.34375001,
    "after_tax_equity_irr_year25": 0.14977712252842731
  }
}

Looking for another spreadsheet? Request a workbook.