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.
Saved workbook valuesOutput
| Row | B | C | D |
|---|---|---|---|
| 6 | Outputs Summary | units | Current Model Run |
| 7 | Net Year-One Cost of Energy (COE) | ¢/kWh | 18.55 |
| 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 | 18.55 |
| 21 | Production, Yr 1 | kWh | 112,347,000 |
| 26 | Net 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 / description | Type / constraints / default |
|---|---|
system_size_mwGenerator Gross Nameplate Capacity; units: MW. Numeric costs are positive unless stated otherwise. | Type: number Constraints: min: 0.001 Default: 15 |
capacity_factorNet 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_detailSelect 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_detailSelect 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_kwInstalled 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_yearFixed 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_kwhVariable 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_typeSelect 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_formInvestment 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_fractionITC 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_rateInterest 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 / description | Type / constraints / default |
|---|---|
year_one_coe_cents_per_kwhcents/kWh; year-one tariff, rounded to the midpoint of the 0.1-cent CREST bracket | Type: number |
nominal_lcoe_cents_per_kwhcents/kWh; nominal levelized cost of energy | Type: number |
year_one_energy_kwhkWh/year; positive generation | Type: number |
net_installed_costUSD; positive net capital cost | Type: number |
after_tax_equity_irr_year25decimal 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/mcpSlug: 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.